meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='320817' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12160
[post_author] => 4
[post_date] => 2018-10-29 19:47:38
[post_date_gmt] => 2018-10-29 19:47:38
[post_content] => Proximity to parks, room to roam in the bigger-than-some-SF-neighborhoods yards, and lots of great eateries and local haunts. Downtown is a quick (and probably crowded) N-Judah ride away, and car commuters can hop on 19th Avenue to head south. Yes, there’s more fog than on the east side of town, but that keeps things cool and comfy.
[post_title] => Central Sunset
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => central-sunset
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:20:19
[post_modified_gmt] => 2024-03-19 19:20:19
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12160
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 1479 28th Avenue, San Francisco, CA, 94122
ffd_mls_id, 422705527
ffd_salesforce_id, a0E8W00000ZM9ruUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 1479 28th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1479 28th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Offers due Wednesday 11/16/2022 at noon. Please text Chris Sung at 415-702-7782 for all questions, showing requests and offers. Pre-Escrow opened with Lynn Chan, Fidelity Title. Sellers would appreciate the escrow stays with Fidelity Title. Disclosure Link: https://app.disclosures.io/link/1479-28th-Avenue-jjnbuwtd
appliances__c, Disposal;Built-In Refrigerator
architectural_style__c, Marina
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1927
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Christopher Sung
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-10-29T19:46:36.000+0000
days_on_market__c, 263
dom__c, 18
ffd_description_pb, Sophisticated Marina-style restoration on one of the only tree-lined blocks of prime Sunset District! This elegant 3BD/ 2BA home is refined with exquisitely selected materials, making it the entertainer's dream. The open concept floor plan consists of a formal dining room, which seamlessly connects the spacious chef's kitchen with the cozy living room. Brand new GE appliances, quartzite countertops and marble fireplace style the main living space. Meticulously crafted arches and coved ceilings along with retouched embellishments from the 1920s preserve the architectural integrity of this classic home. Tucked away are two spacious bedrooms sitting harmoniously next to each other for an element of privacy. Step down to the lower-floor primary suite where you'll find an astonishing lounge area. Enjoy the luxury of a walk-in shower, radiant-heated floors, custom-built dry cedar sauna, and a backyard paradise easily accessible through graceful sliding doors. High quality European Oakwood flooring, designer tiles and modern light fixtures finish the home. http://www.1479-28thave.com/
district__c, SF District 2
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning;Brick;Stone
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant Floor;Central;Fireplace(s)
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2023-07-13T18:03:19.000+0000
pba__latitude_pb__c, 37.759815
pba__latitude_property__c, 37.759815
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2022-07-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Susie
pba__listing_agent_lastname__c, Lee
listing_agent_mls_id__c, 814242
ffd_listingagentname, Susie Lee
listing_agent_number__c, 1065352
listing_co_agent_mls_id__c, 817368
listing_co_agent_number__c, 1076245
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP31
listing_office_name__c, Compass
listing_office_number__c, 27894
pba__listingprice_pb__c, 1950000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=tPygzdYPKH1
pba__longitude_pb__c, -122.486866
lower_level__c, Primary Bedroom
mls_id__c, 422705527
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Marble;Radiant Heat;Sauna;Outside Access
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-10-29
original_price__c, 1950000
overall_days_on_market__c, -81385
parking_access__c, Independent
parking_features__c, EV Charging
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-11-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1117.1
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000ZM9ruUAD
room_type__c, Bonus Room;Sun Room;Kitchen;Living Room;Dining Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2022-12-08
sale_price__c, 2280000
selling_agent_mls_id__c, 368076
selling_agent_number__c, 368076
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2041
size__c, 2041
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 28th
subdist__c, Central Sunset
ffd_name, 1479 28th Avenue, San Francisco, CA, 94122
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1927
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530549000-1.jpg