meta_query='key:subdist__c;value:St. Francis Wood|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218146' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12174
[post_author] => 4
[post_date] => 2018-10-30 00:43:28
[post_date_gmt] => 2018-10-30 00:43:28
[post_content] => Welcome to Pacific Heights west. Developed beginning in the 1910s and 1920s on land that once belonged to Adolph Sutro, it'll make it clear right away that you've arrived in San Francisco's flagship residential park. The construction craze of the era featured the best of city amenities (sidewalks, street lights!) with wide streets, clear neighborhood boundaries, and plenty of green parks for play within the neighborhood.
[post_title] => St. Francis Wood
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => st-francis-wood
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:19:16
[post_modified_gmt] => 2024-03-19 19:19:16
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12174
[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, 195 San Leandro Way, San Francisco, CA, 94127
ffd_mls_id, 421534620
ffd_salesforce_id, a0E1I00000Ty8AkUAJ
num_of_fireplaces__c, 4
num_of_rooms__c, 0
of_units__c, 0
address2__c, 195 San Leandro Way, San Francisco, CA, 94127
pba__address_pb__c, 195 San Leandro Way, San Francisco, CA, 94127
agent_only_remarks__c, Offers due Thursday, April 15 by 11:00 AM. This is an 'As-Is' Trust Sale (no court confirmation). Please only use SFAR Purchase Contract & stipulate buyer's initial deposit will be in escrow within one business day of acceptance. Escrow opened with First American Title, Liz Paglinawan 650-245-6799. Do NOT send Text Messages. Email ONLY for ALL showing requests, we are not using Showing Time. Property is being marketed under Covid19 guidelines. Buyer's agent must provide their buyer's signed PEAD-V and pre-approval letter or POF before viewing home. All visitors must wear masks. 3D Tour available on the MLS, just click on visual media.
appliances__c, Dishwasher;Built-In Gas Range;Built-In BBQ;Built-In Refrigerator;Free Standing Electric Range;Warming Drawer
architectural_style__c, Traditional;Craftsman
bath_features__c, Tub w/Shower Over;Tile;Closet
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1917
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-11T02:09:12.000+0000
days_on_market__c, 832
dom__c, 7
ffd_description_pb, Grand Craftsman home designed by renowned architect Julia Morgan (famed for Hearst Castle) on nearly 1/4 acre, close to West Portal Village! Impressive entrance opens into dramatic lobby-like foyer w/splendid open-banister staircase. Remarkable formal living rm w/high ceiling boasts stately fireplace, 5 arched windows & hardwood floors. Stately formal dining rm w/beam ceiling, classic fireplace & china display cabinet. Beautifully remodeled gourmet kitchen w/fabulous work-island & sep butler's pantry showcases an Italian Bertazzoni range, black quartz counters, custom-made cabinets & brkf area. Huge adj family rm opens into a magical courtyard patio & garden. Awe-inspiring atrium w/towering roofline sports an extraordinary indoor swimming pool, built-in lounge seating, wet-bar & built-in BBQ. 4BR/3BA up incl luxurious master suite w/nice views to the Pacific Ocean & the Olympic Club, fireplace, dressing rm & bath. Huge basement. Delightful wrap-around landscaped backyd w/walking paths!
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning;Master Bedroom;Dining Room
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas
pba__hoafees__c, 4963
pba__hoafrequency_pb__c, Annually
hoa_name__c, St. Francis Wood
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Storage Area(s);Cathedral Ceiling;Wet Bar;Open Beam Ceiling
ffd_lastmodifieddate, 2022-01-25T15:49:11.000+0000
pba__latitude_pb__c, 37.73332
pba__latitude_property__c, 37.73332
laundry_features__c, Inside Room;Inside Area;Washer Included;Dryer Included
listed_date__c, 2021-02-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Andrew
pba__listing_agent_lastname__c, Herrera II
listing_agent_mls_id__c, 404547
ffd_listingagentname, Andrew Herrera II
listing_agent_number__c, 404547
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BHFP
listing_office_name__c, Berkshire Hathaway-Franciscan
listing_office_number__c, 1665
pba__listingprice_pb__c, 3995000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.195sanleandro.com/
pba__longitude_pb__c, -122.468266
mls_id__c, 421534620
main_level__c, Full Bath(s);Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-04-08
original_price__c, 3995000
overall_days_on_market__c, 183
parking_access__c, Side by Side
parking_features__c, Attached,Covered,Garage Facing Rear,Garage Facing Side,Guest Parking Available,Interior Access,Side-by-Side,Workshop in Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch;Uncovered Patio;Front Porch
pba__pendingdate__c, 2021-04-15
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 990.1
pba__propertytype__c, Single Family Residence
id, a0E1I00000Ty8AkUAJ
roof__c, Composition;Shingle
room_type__c, Storage;Kitchen;Atrium;Master Bedrooms 2+;Living Room;Solarium;Dining Room;Family Room;Workshop;Wine Storage Area
sale_date__c, 2021-04-30
sale_price__c, 5400000
selling_agent_mls_id__c, 802851
selling_agent_number__c, 802851
selling_co_agent_mls_id__c, 808252
selling_co_agent_number__c, 1032461
selling_co_office_mls_id__c, COMP3
selling_co_office_name__c, Compass
selling_co_office_number__c, 27342
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 5454
size__c, 5454
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, San Leandro
subdist__c, St. Francis Wood
ffd_name, 195 San Leandro Way, San Francisco, CA, 94127
view__c, Ocean;City;Golf Course;Park;City Lights;Garden/Greenbelt;Hills;Mountains;Lake
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1917
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530214618-1.jpg
ListingId, a0E1I00000Ty8AkUAJ