_yoast_indexnow_last_ping,1714129245
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
appliances__c,Gas Water Heater;Hood Over Range;Built-In Gas Oven;Wine Refrigerator;Gas Cook Top
architectural_style__c,Mediterranean
bath_features__c,Shower Stall(s);Tile;Granite;Stone
pba__fullbathrooms_pb__c,5
pba__bedrooms_pb__c,4
year_build_text__c,1929
pba__city_pb__c,San Francisco
listing_co_agent_name__c,Jacquelyn Pio Roda
pba__contingentdate__c,1800-01-01
ffd_createddate,2024-04-26T10:47:22.000+0000
days_on_market__c,0
dom__c,0
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!
district__c,SF District 4
driveway_sidewalks__c,Paved Driveway,Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c,0
exterior_features__c,Balcony;Uncovered Courtyard
external_listing__c,1
fencing__c,Back Yard;Fenced
fireplace_features__c,Living Room;Wood Burning
pba__floortype_pb__c,Tile;Wood
hoa_fee_includes__c,Common Areas,Management
pba__hoafees__c,6176
pba__hoafrequency_pb__c,Annually
hoa_name__c,Saint Francisco Wood HOA
hoa__c,Yes
pba__halfbathrooms_pb__c,0
pba__heatingtype_pb__c,Central;Gas
interior_features__c,Formal Entry;Cathedral Ceiling
ffd_lastmodifieddate,2024-04-26T10:47:22.000+0000
pba__latitude_pb__c,37.7366979
pba__latitude_property__c,37.7366979
laundry_features__c,Washer Included;Dryer Included;Sink
listed_date__c,2024-02-21
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Gary
pba__listing_agent_lastname__c,Tribulato
listing_agent_mls_id__c,800067
ffd_listingagentname,Gary Tribulato
listing_agent_number__c,800067
listing_co_agent_mls_id__c,MLSL301304
listing_co_agent_number__c,981199031
listing_co_office_mls_id__c,LXMR-1
listing_co_office_name__c,Luxmore Real Estate
listing_co_office_number__c,981050965
listing_office_mls_id__c,CIP
listing_office_name__c,Corcoran Icon Properties
listing_office_number__c,28936
pba__listingprice_pb__c,4795000
pba__listingtype__c,Sale
pba__listing_website__c,https://www.StFrancisWoodEstate.com
pba__longitude_pb__c,-122.4666548
mls_id__c,424027108
main_level__c,Kitchen;Living Room;Dining Room
master_bathroom_features__c,Shower Stall(s);Tub;Double Sinks;Tile;Stone
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,2
on_market_date__c,2024-04-26
open_house_end__c,2024-04-30T15:00:00.000+0000
open_house_start__c,2024-04-30T13:00:00.000+0000
original_price__c,4795000
overall_days_on_market__c,-81930
parking_access__c,Side by Side
parking_features__c,Detached,Garage Door Opener
parking_type__c,On Site (Single Family Only)
patio_and_porch_features__c,Uncovered Deck;Uncovered Patio;Covered Patio
pba__pendingdate__c,1800-01-01
possible_bedrooms__c,0
pba__pricechangedat__c,1800-01-01T00:00:00.000+0000
price_per_square_foot__c,1364.93
pba__propertytype__c,Single Family Residence
ListingId,a0EUd000001qctWMAQ
road_surface_type__c,Asphalt
roof__c,Spanish Tile
room_type__c,Storage;Office;Bonus Room;Laundry;Kitchen;Living Room;Dining Room;Primary Bedroom
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Smoke Detector;Carbon Mon Detector;Double Strapped Water Heater
selling_agent_number__c,0
selling_co_agent_number__c,0
selling_co_office_number__c,0
pba__status__c,Active
pba__totalarea_pb__c,3513
size__c,3513
pba__state_pb__c,CA
stories__c,2
pba__street_pb__c,Santa Clara
subdist__c,St. Francis Wood
ffd_name,200 Santa Clara Avenue, San Francisco, CA, 94127
website_property_type__c,Single Family Home
window_features__c,Bay Window(s)
pba__yearbuilt_pb__c,1929
pba__postalcode_pb__c,94127
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530766893-1.jpg
