254 Santa Paula Avenue, San Francisco, CA, 94127 - Property Description

_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

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-27T00:47:44.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

_yoast_indexnow_last_ping,1713005956

ffd_listing_title,15 Terrace Drive, San Francisco, CA, 94127

ffd_mls_id,424018134

ffd_salesforce_id,a0EUd000001fk6LMAQ

num_of_fireplaces__c,1

num_of_rooms__c,7

of_units__c,0

address2__c,15 Terrace Drive, San Francisco, CA, 94127

pba__address_pb__c,15 Terrace Drive, San Francisco, CA, 94127

agent_only_remarks__c,DON'T Disturb Tenants!!! No Open houses/broker tour! Show by Thursday and Sunday Appointment Only! hours notice required so tenant can leave the house. Foreigner-Seller need few days to respond to your offers. Super nice tenants, current rent $ 6,000 month2month, Offer date TDB, Disclosure I.O, for showing appts & info. text 415-361-8535 or email: [email protected] Pre-escrow # FWPN-3542400156 -KD with Chicago title Kim Diep, this closure link: https://app.disclosures.io/link/15-Terrace-Drive-l9dpo6wb

appliances__c,Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Wine Refrigerator;Double Oven;Built-In Refrigerator;Plumbed For Ice Maker;Built-In Electric Oven

architectural_style__c,Spanish;Mediterranean

bath_features__c,Shower Stall(s);Marble;Tile;Low-Flow Toilet(s);Dual Flush Toilet;Bidet

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1921

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Ceiling Fan(s),None

ffd_createddate,2024-04-07T10:48:21.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,Rare opportunity to live in a historic, architecturally significant home in the most prestigious of St. Francisco Wood! This beautiful one-story detached house features 3 bedrooms, including master suite,2 luxurious bathrooms (1 with jacuzzi), a grand kitchen with granite island bar, built-in top the line appliances, cabinet and an bonus guestroom/work-from-home office in basement. Despites its peaceful settings, the home is conveniently located near West Portal restaurant, shops, Stonestown Galleria Mall and public transportation.

district__c,SF District 4

driveway_sidewalks__c,Paved Driveway,Shared Driveway

electric__c,220 Volts in Laundry

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard;Fenced

fireplace_features__c,Living Room;Wood Burning

pba__floortype_pb__c,Bamboo;Carpet;Wood

hoa_fee_includes__c,Common Areas

pba__hoafees__c,0

hoa_name__c,St. Francis Homes Association

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas;Fireplace(s)

interior_features__c,Formal Entry;Skylight(s);Storage Area(s)

ffd_lastmodifieddate,2024-04-13T10:47:09.000+0000

pba__latitude_pb__c,37.738076

pba__latitude_property__c,37.738076

laundry_features__c,Laundry Closet;Hookups Only;In Basement;Cabinets;Sink

listed_date__c,2024-04-04

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Thomas

pba__listing_agent_lastname__c,Nguyen

listing_agent_mls_id__c,981210

ffd_listingagentname,Thomas T Nguyen

listing_agent_number__c,981210

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,UPRE

listing_office_name__c,RE/MAX UP Real Estate

listing_office_number__c,25148

pba__listingprice_pb__c,2350000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.467051

lower_level__c,Bedroom(s)

mls_id__c,424018134

main_level__c,Partial Bath(s);Bedroom(s);Kitchen;Living Room;Family Room;Street Entrance

master_bathroom_features__c,Shower Stall(s);Double Sinks;Tile;Bidet;Walk-In Closet;Soaking Tub;Marble;Dual Flush Toilet

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-07

original_price__c,2350000

overall_days_on_market__c,-81911

parking_access__c,Independent

parking_features__c,Attached,Covered,EV Charging,Garage Door Opener,Garage Facing Front,Interior Access

parking_type__c,On Site (Single Family Only)

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,1230.37

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001fk6LMAQ

roof__c,Tile

room_type__c,Bonus Room;Laundry;Kitchen;Living Room;Dining Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Carbon Mon Detector

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,1910

size__c,1910

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Terrace

subdist__c,St. Francis Wood

ffd_name,15 Terrace Drive, San Francisco, CA, 94127

view__c,City;City Lights;Hills

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full;Window Coverings;Window Screens

pba__yearbuilt_pb__c,1921

pba__postalcode_pb__c,94127

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530756005-1.jpg