meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='331885' 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, 1501 35th Avenue, San Francisco, CA, 94122
ffd_mls_id, 423721425
ffd_salesforce_id, a0E8W00000bGP02UAG
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 1501 35th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1501 35th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, To show: Call Todd at 415-317-5888 or Kim at 415-519-5595. Try to adhere to the showing schedule if possible. Seller's architectural drawings indicate 4104 square feet. Matterport says 4000. Buyer to verify to their satisfaction. Escrow opened with DOMA and Kathie Ng #55905-23-03509. Kathie is great.
architectural_style__c, Spanish
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 5
year_build_text__c, 1923
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kim M Wiley
pba__contingentdate__c, 2023-04-16
ffd_createddate, 2023-03-27T18:48:09.000+0000
days_on_market__c, 114
dom__c, 21
ffd_description_pb, Four years in the making; come see this large, recently remodeled Rousseau Home, featuring 4105 square feet, with gorgeous views. 5 bedrooms/5.5 baths, massive chefs kitchen, luxury finishes, vaulted ceilings in the formal living room, and a primary suite with panoramic views that span from the Golden Gate Bridge to Point Reyes and as far south as Pedro Point. Completing this home is a large family room, office, exercise room, rear deck with an ample, landscaped rear yard complete with irrigation system. Few homes of such magnitude and splendor have ever graced the Sunset District. Close to Golden Gate Park, Ocean Beach, Safeway, Gus Community Market, Damn Fine Pizza, Sunset Cantina, Marnee Thai, San Tung, and so many great restaurants. Mere steps to Muni downtown, easy access to the Peninsula South or escaping the city with the Golden Gate Bridge just to the North; this home is as unique as Rousseau always intended his architecture to be. A must see!
district__c, SF District 2
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T18:25:27.000+0000
pba__latitude_pb__c, 37.758921
pba__latitude_property__c, 37.758921
laundry_features__c, Inside Area;Washer Included;Dryer Included
listed_date__c, 2023-02-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Todd
pba__listing_agent_lastname__c, Wiley
listing_agent_mls_id__c, 804390
ffd_listingagentname, Todd Wiley
listing_agent_number__c, 166013929
listing_co_agent_mls_id__c, 810458
listing_co_agent_number__c, 1046408
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 2995000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=xsHQzcB6RwQ&mls=1
pba__longitude_pb__c, -122.494283
mls_id__c, 423721425
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-27
original_price__c, 2995000
overall_days_on_market__c, -81534
parking_access__c, Independent
parking_features__c, Garage Facing Side
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-04-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 828.46
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bGP02UAG
roof__c, Spanish Tile
sale_date__c, 2023-05-18
sale_price__c, 3400000
selling_agent_mls_id__c, 390409
selling_agent_number__c, 390409
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, BarbCo
pba__status__c, Closed
pba__totalarea_pb__c, 4104
size__c, 4104
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 35th
subdist__c, Central Sunset
ffd_name, 1501 35th Avenue, San Francisco, CA, 94122
view__c, Ocean;Park;Panoramic;Golden Gate Bridge
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1923
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530579984-1.jpg