_yoast_indexnow_last_ping,1747826292
ffd_listing_title,2 Mercedes Way, San Francisco, CA, 94127
ffd_mls_id,425029603
ffd_salesforce_id,a0EUd000004tYTNMA2
num_of_fireplaces__c,0
num_of_rooms__c,0
of_units__c,0
pba__address_pb__c,2 Mercedes Way, San Francisco, CA, 94127
address2__c,2 Mercedes Way, San Francisco, CA, 94127
agent_only_remarks__c,Seller will consider offers which requests for buyer concessions | Easy to Show - Book your tour on Calendly here > https://calendly.com/2mercedes/tour | Showing needs to be confirmed in separate email/text and pls meet our agent at the property. Call/text Mia 415.728.2596 | [email protected] for more info. Offers to be on most recent SFAR contract. Escrow opened with Michael Yip with Chicago Title. Pls follow offer instructions on the disclosure.io > https://app.disclosures.io/link/2-Mercedes-Way-n4guqxf5
appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Free Standing Gas Oven;Built-In Gas Oven;Wine Refrigerator;Self/Cont Clean Oven;Built-In Refrigerator;Gas Cook Top;Free Standing Electric Oven;Built-In Electric Oven;Gas Plumbed
architectural_style__c,Traditional;Mediterranean;French
bath_features__c,Tub w/Shower Over;Shower Stall(s);Tub;Tile;Quartz
pba__fullbathrooms_pb__c,7
pba__bedrooms_pb__c,7
year_build_text__c,1931
pba__city_pb__c,San Francisco
pba__contingentdate__c,1800-01-01
cooling__c,Central
ffd_createddate,2025-05-01T21:46:44.000+0000
days_on_market__c,20
dom__c,20
ffd_description_pb,Distinguished and meticulously renovated, this Mediterranean view home occupies a prestigious corner lot in historic Ingleside Terraces. Beyond a gated courtyard and elegant double-arched portico, a dramatic rotunda foyer welcomes you with a sweeping circular staircase and walk-in coat closet. The formal living room impresses with soaring coved ceilings, a stately fireplace, rich moldings, and hardwood floors. Ideal for entertaining, the banquet-sized dining room and cocktail lounge open through French doors to breathtaking treetop and hillside views. Designed for culinary excellence, the gourmet kitchen boasts a central island, breakfast area, quartz counters, custom cabinetry, generous pantry storage, wet bar with wine fridge, and premium Bertazzoni stove and Thermador refrigerator. Six en-suite bedrooms include a luxurious primary suite with Pacific Ocean views, sitting room/office, spa-like bath, and walk-in closet. A spacious family room with full second kitchen opens to a lush garden with two-tiered stone patio, wrap-around path, and mature trees. Two laundry rooms, two storage rooms, and an attached 2-car garage complete this exceptional residence. Minutes from West Portal, Stonestown Galleria, top schools, and Hwy 280.
district__c,SF District 4
driveway_sidewalks__c,Sidewalk/Curb/Gutter
entry_level__c,0
exterior_features__c,Balcony;Uncovered Courtyard;Entry Gate
external_listing__c,1
fencing__c,Back Yard;Fenced;Front Yard;Full;Other
pba__floortype_pb__c,Tile;Wood
pba__hoafees__c,0
pba__hoafrequency_pb__c,Annually
hoa_name__c,Ingleside Terrances Homes Association
hoa__c,Yes
pba__halfbathrooms_pb__c,2
pba__heatingtype_pb__c,Central;Gas;Fireplace(s)
interior_features__c,Formal Entry;Skylight(s);Wet Bar
ffd_lastmodifieddate,2025-05-21T10:47:00.000+0000
pba__latitude_pb__c,37.7265668
pba__latitude_property__c,37.7265668
laundry_features__c,Inside Room;Washer/Dryer Stacked Included;Upper Floor;Inside Area;Washer Included;Dryer Included;Sink
listed_date__c,2025-04-30
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Miyuki Mia
pba__listing_agent_lastname__c,Takami
listing_agent_mls_id__c,806485
ffd_listingagentname,Miyuki Mia Takami
listing_agent_number__c,166017050
listing_co_agent_number__c,0
listing_co_office_number__c,0
listing_office_mls_id__c,EXPRE
listing_office_name__c,eXp Realty of California, Inc
listing_office_number__c,26334
pba__listingprice_pb__c,4985000
pba__listingtype__c,Sale
pba__longitude_pb__c,-122.4714109
lower_level__c,Bedroom(s),Family Room,Garage,Partial Bath(s),Retreat,Street Entrance
mls_id__c,425029603
main_level__c,Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c,Shower Stall(s);Quartz;Double Sinks;Tile;Soaking Tub
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,2
on_market_date__c,2025-05-01
open_house_end__c,2025-05-22T19:00:00.000+0000
open_house_start__c,2025-05-22T17:00:00.000+0000
original_price__c,4985000
overall_days_on_market__c,-82300
parking_access__c,Side by Side
parking_features__c,Attached,Covered,Enclosed,Garage Door Opener,Garage Facing Side,Guest Parking Available,Interior Access,Side-by-Side
parking_type__c,On Site (Single Family Only)
patio_and_porch_features__c,Back Porch;Uncovered Patio;Front Porch;Wrap Around Porch
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,761.07
pba__propertytype__c,Single Family Residence
ListingId,a0EUd000004tYTNMA2
road_surface_type__c,Paved
roof__c,Tile
room_type__c,Office;Laundry;Kitchen;Living Room;Guest Quarters;Dining Room;Family Room;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Smoke Detector;Security Gate;Security Fence;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,6550
size__c,6550
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,Mercedes
subdist__c,Ingleside Terraces
ffd_name,2 Mercedes Way, San Francisco, CA, 94127
view__c,Ocean;Golf Course;Panoramic;City Lights;Garden/Greenbelt;Water;Hills;Mountains
website_property_type__c,Single Family Home
window_features__c,Window Coverings
pba__yearbuilt_pb__c,1931
pba__postalcode_pb__c,94127
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530990194-1.jpg
Open 05/22 05:00pm till 07:00pm