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.
Pending
$2,900,000
788 Sequoia Ave, San Mateo, CA 94403
3beds
2,580sqft
Single Family Residence, Residential
Built in 1976
6,680 Square Feet Lot
$-- Zestimate®
$1,124/sqft
$-- HOA
What's special
- 29 days
- 981
- 80
Zillow last checked:
Listing updated:
Listed by:
Sternsmith Group 70016718 650-678-5455,
Compass 650-375-1111
Source: MLSListings Inc,MLS#: ML82056866
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Bedroom
- Features: PrimarySuiteRetreat
Bathroom
- Features: DoubleSinks, PrimaryStallShowers, PrimaryOversizedTub
Dining room
- Features: FormalDiningRoom
Family room
- Features: SeparateFamilyRoom
Kitchen
- Features: Countertop_Stone, Island
Heating
- Central Forced Air Gas
Cooling
- Central Air
Appliances
- Included: Gas Cooktop, Microwave, Double Oven, Built In Oven/Range, Wine Refrigerator, Washer/Dryer
- Laundry: In Garage
Features
- Vaulted Ceiling(s)
- Number of fireplaces: 1
- Fireplace features: Living Room
Interior area
- Total structure area: 2,580
- Total interior livable area: 2,580 sqft
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Attached garage spaces: 2
Features
- Stories: 1
- Patio & porch: Deck
- Has view: Yes
- View description: Bay
- Has water view: Yes
- Water view: Bay
Lot
- Size: 6,680 Square Feet
Details
- Parcel number: 039095110
- Zoning: R1000B
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence, Residential
Materials
- Foundation: Concrete Perimeter
- Roof: Composition, Shingle
Condition
- New construction: No
- Year built: 1976
Utilities & green energy
- Gas: PublicUtilities
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public Utilities, Water Public
Community & HOA
Location
- Region: San Mateo
Financial & listing details
- Price per square foot: $1,124/sqft
- Tax assessed value: $3,024,442
- Annual tax amount: $35,782
- Date on market: 8/6/2026
- Listing agreement: ExclusiveRightToSell
Estimated market value
Not available
Estimated sales range
Not available
$6,343/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/14/2026 | Pending sale | $2,900,000$1,124/sqft |
Source:  MLSListings Inc #ML82056866 Report a problem | ||
| 8/6/2026 | Listed for sale | $2,900,000+1.8%$1,124/sqft |
Source: MLSListings Inc #ML82056866 Report a problem | ||
| 8/24/2021 | Sold | $2,850,000+32.6%$1,105/sqft |
Source:  MLSListings Inc #ML81850755 Report a problem | ||
| 6/25/2021 | Listed for sale | $2,150,000+200.7%$833/sqft |
Source: MLSListings Inc #ML81850755 Report a problem | ||
| 3/9/2013 | Listing removed | $4,988$2/sqft |
Source: HotPads for Rent Report a problem | ||
| 2/24/2013 | Price change | $4,988-0.5%$2/sqft |
Source: vFlyer Rentals #01381122 Report a problem | ||
| 1/28/2013 | Listed for rent | $5,011$2/sqft |
Source: vFlyer Rentals #01381122 Report a problem | ||
| 12/10/1999 | Sold | $715,000$277/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $35,782 +0.7% | $3,024,442 +2% |
| 2024 | $35,525 +5.5% | $2,965,140 +6.3% |
| 2023 | $33,660 -1.4% | $2,790,000 -2.1% |
| 2022 | $34,135 +150.1% | $2,850,000 +180.7% |
| 2021 | $13,647 +6% | $1,015,242 +1% |
| 2020 | $12,880 +2.9% | $1,004,832 +2% |
| 2019 | $12,517 +5.6% | $985,130 +2% |
| 2018 | $11,856 +1.5% | $965,814 +2% |
| 2017 | $11,678 +2.7% | $946,878 +2% |
| 2016 | $11,374 -5.2% | $928,312 +1.5% |
| 2015 | $12,000 | $914,368 +2% |
| 2014 | $12,000 | $896,458 +0.5% |
| 2013 | -- | $892,408 +2% |
| 2012 | -- | $874,910 |
| 2011 | -- | $874,910 +2.8% |
| 2010 | -- | $851,346 -0.2% |
| 2009 | -- | $853,370 +2% |
| 2008 | -- | $836,638 +2% |
| 2007 | -- | $820,234 +2% |
| 2006 | -- | $804,152 |
| 2005 | -- | $804,152 +4% |
| 2004 | -- | $772,928 +1.9% |
| 2003 | -- | $758,762 +2% |
| 2002 | -- | $743,886 +2% |
| 2001 | -- | $729,300 +2% |
| 2000 | -- | $715,000 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: Country Club Heights
Nearby schools
Schools provided by the listing agent
- Elementary: MeadowHeightsElementary
- District: SanMateoFosterCityElementary
Source: MLSListings Inc. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Similar homes
- $2,898,0004 bd3 ba2k sqft751 27th Ave, San Mateo, CA 94403For Sale
MLS ID #ML82035522, Michael Haywood Jr.. MLSListings Inc - $2,799,0004 bd3 ba2.6k sqft1169 Ramblewood Way, San Mateo, CA 94403For Sale
MLS ID #ML82057847, George Chopoff. MLSListings Inc - $2,899,0004 bd3 ba2.2k sqft541 Trinidad Ln, Foster City, CA 94404For Sale
MLS ID #ML82059400, Disen Cai RE Group. MLSListings Inc - $2,880,0003 bd4 ba2.6k sqft608 Anacapa Ln, Foster City, CA 94404For Sale
MLS ID #ML82054544, Rick Smith. MLSListings Inc
Local buyer's agents are ready to help
