meta_query='key:subdist__c;value:St. Francis Wood|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376641' 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
(
)
)
_yoast_indexnow_last_ping, 1714179592
ffd_listing_title, 200 Santa Clara Avenue, San Francisco, CA, 94127
ffd_mls_id, 424027108
ffd_salesforce_id, a0EUd000001qctWMAQ
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 200 Santa Clara Avenue, San Francisco, CA, 94127
pba__address_pb__c, 200 Santa Clara Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Note that the 2D floorplan shows the existing dimensions of 3622 sq ft. Tax records show 3513 sq ft. Pre-Escrow opened with WFG National Title Insurance Company, Escrow Officer Mary Ann Bunnell. For Showings: Call Greg Tribulato: 415-235-6717 Disclosure IO Link: https://app.disclosures.io/link/200-Santa-Clara-Avenue-66m0s2pv
appliances__c, Gas Water Heater;Hood Over Range;Built-In Gas Oven;Wine Refrigerator;Gas Cook Top
ffd_description_pb, Iconic Mediterranean Estate on an enviable large corner lot location within the historically prestigious St. Francis Wood neighborhood. Walk up the charming tree-lined streets with a peaceful park in front onto the front patio. Open the front door and you will be enticed by the straight view into the backyard across the formal entryway. This home has a warm, welcoming layout that was built and designed to entertain! Guests can meander through the living room, the formal dining room or the kitchen, all of which have French doors that flow onto multiple expansive outdoor decks. Host an outdoor brunch on a sunny day, curl up with a book and a warm blanket on the deck off the living room, set up a game table on the side patio landing or enjoy a glass of wine with friends out in the garden to the relaxing sound of the fountain. There are 4 spacious bedroom suites and a corner office with inspiring views. There is a separate breakfast room with a large double window, an enormous formal dining room that can seat a dozen dinner guests comfortably, a beautiful formal Living Room with a floor-to-ceiling picture window that has the perfect spot for a grand piano, and a Wine/Media Room downstairs. This sprawling Estate has everything you need for gracious San Francisco living!
200 Santa Clara Avenue, San Francisco, CA, 94127 - Property Description
Iconic Mediterranean Estate on an enviable large corner lot location within the historically prestigious St. Francis Wood neighborhood. Walk up the charming tree-lined streets with a peaceful park in front onto the front patio. Open the front door and you will be enticed by the straight view into the backyard across the formal entryway. This home has a warm, welcoming layout that was built and designed to entertain! Guests can meander through the living room, the formal dining room or the kitchen, all of which have French doors that flow onto multiple expansive outdoor decks. Host an outdoor brunch on a sunny day, curl up with a book and a warm blanket on the deck off the living room, set up a game table on the side patio landing or enjoy a glass of wine with friends out in the garden to the relaxing sound of the fountain. There are 4 spacious bedroom suites and a corner office with inspiring views. There is a separate breakfast room with a large double window, an enormous formal dining room that can seat a dozen dinner guests comfortably, a beautiful formal Living Room with a floor-to-ceiling picture window that has the perfect spot for a grand piano, and a Wine/Media Room downstairs. This sprawling Estate has everything you need for gracious San Francisco living!
