---
listing_id: ML82056866
status: Active
price: 2900000
beds: 3
baths_full: 2
baths_half: 0
sqft_living: 2580
sqft_lot: 6680
lot_acres: 
year_built: 1976
property_type: Residential
property_subtype: Single Family Residence
address: "788 Sequoia Ave"
city: San Mateo
state: CA
zip: 94403
county: "San Mateo County"
lat: 37.537023
lng: -122.321097
days_on_market: 1
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Sternsmith Group"
list_office: "Compass"
list_agent_phone: "(650) 678-5455"
list_agent_license: 70016718
mls_source: MLSL
modified: 2026-08-06
transaction_type: buy
---

Home | San Mateo County | San Mateo | 94403 | 788 Sequoia Ave

788 Sequoia Ave, San Mateo, CA 94403

MLS: ML82056866 | Status: Active | Price: $2,900,000
Beds/Baths: 3 / 2
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
3 2 2,580 6,680 1976

Upcoming Open Houses

Date Time Hosted By
Friday, August 7 11:00 am - 1:00 pm Sternsmith Group
Friday, August 7 4:00 pm - 6:00 pm Sternsmith Group
Saturday, August 8 2:00 pm - 4:00 pm Sternsmith Group
Sunday, August 9 2:00 pm - 4:00 pm Sternsmith Group
Tuesday, August 11 11:00 am - 1:00 pm Sternsmith Group

Remarks

Experience a fully remodeled, chic interior design, offering breathtaking bay views and an enchanting deck and flat lawn. Nestled in the desirable SM Terrace neighborhood, this home offers the perfect balance of privacy and convenience with easy access to commuter freeways, Beresford Park, and downtown San Mateo, plus walkability to Meadow Heights Elementary. High ceilings and oversized windows flood the living and dining rooms with natural light, highlighting wide-plank French oak floors, and curated lighting. At the heart of the home, the chef's kitchen features custom cabinetry, Gaggenau ovens, a beverage refrigerator, and a five-burner Thermador gas cooktop. The space flows effortlessly into the family room and out to a private Trex deck and lush lawnideal for entertaining, play, or pets. The serene primary suite boasts 4 closets and a spa-like updated bath with a double vanity, soaking tub, and custom walk-in shower. Two additional sun-filled bedrooms share a tastefully remodeled second bath. Modern conveniences include a two-car garage with epoxy flooring and a Tesla charger, plus a separate light-filled bonus room perfect for a home office or studio. Complete with extensive dry under-house storage, this home perfectly balances style, function, and indoor-outdoor flow.

MLS Listing Information

Field Value
MLS # ML82056866
MLS Source MLSListings, Inc.
Days on Site 1

Features

Interior Features

Feature Details
Bedrooms Primary Suite/Retreat
Bathrooms Double Sinks, Primary - Stall Shower(s), Primary - Oversized Tub
Kitchen Countertop - Stone, Island
Appliances Cooktop - Gas, Microwave, Oven - Double, Oven Range - Built-In, Wine Refrigerator, Washer/Dryer
Dining Room Formal Dining Room
Family Room Separate Family Room
Fireplace Living Room
Laundry In Garage
Cooling Central Forced Air
Heating Central Forced Air - Gas

Exterior Features

Feature Details
Roof Composition, Shingle
Foundation Concrete Perimeter

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Garage: 2 Car(s)
Elementary District San Mateo-Foster City Elementary
High School District San Mateo Union High
Sewer Public Sewer
Water Public
Zoning R1000B

Contact Information

Sternsmith Group
Compass
License #: 01733080,01999389
Phone: (650) 678-5455

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Meadow Heights Elementary School public K-5 0.31 mi 7
Hillsdale High School public 9-12 0.52 mi 9
Beresford Elementary School public K-5 0.68 mi 4
Abbott Middle School public 6-8 0.80 mi 4
Borel Middle School public 6-8 0.87 mi 8
Laurel Elementary School public K-5 0.95 mi 3
Aragon High School public 9-12 0.97 mi 10
Baywood Elementary School public K-5 1.21 mi 7
College Park Elementary School public K-5 1.56 mi 9
Fiesta Gardens International Elementary School public K-5 1.61 mi 4
Cipriani Elementary School public K-5 1.64 mi 8
George Hall Elementary School public K-5 1.67 mi 9
Sunnybrae Elementary School public K-5 1.76 mi 2
Gateway Center public 6-12 1.81 mi N/A
Ralston Intermediate School public 6-8 1.82 mi 10
Highlands Elementary School public K-5 1.85 mi 7
Fox Elementary School public K-5 1.88 mi 10
South Hillsborough School public K-5 1.92 mi 9
Parkside Montessori public PK,KG,1,2,3,4,5,6,7,8 2.15 mi 9
Central Elementary School public K-5 2.23 mi 9

Nearby Homes

Address Price Beds Baths Sq Ft Status
751 27th Ave $2,898,000 4 3 2,010 Active
2635 Ponce Ave $3,000,000 5 3 2,600 PendingDoNotShow
1255 North Rd $2,480,000 3 2/1 1,830 Active
2706 Belmont Canyon Rd $2,998,000 5 3/1 3,270 PendingDoNotShow
3307 Adelaide Way $2,995,000 5 3/1 2,900 Active

Disclosures

©2026 MLSListings Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MLSListings Inc.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of August 06, 2026. For the most current information, please contact Sternsmith Group, (650) 678-5455.