Off Market Jul 2021 for $4.6M

$5,403,395

Est. refi paymentEst. refi $25,225/mo

•

3,800

sq ft

400 Warren Rd, San Mateo, CA 94402

About this home

FIRST OPEN HOUSE Saturday and Sunday 1-4. Stately and stunning Mediterranean home located near downtown Burlingame Ave, parks, transportation. Gated large lot with lovely gardens, patios, fountain, and al fresco dining areas. Grand 2 story entrance with skylights for natural light. 3800 sq feet of well thought out living spaces, updated by current owner with high quality stainless steel appliances, a master bath sauna, 2 fireplaces in master suite and living room. Along with 3 upstairs large bedrooms all with their own baths, there is a 4th bedroom suite located on the main floor with its own entrance and a lovely view to the courtyard and fountain. In addition, there are double pantry closets in the kitchen, a 3 car garage with lots of parking, a charming traditional balcony off the master suite overlooking the birch trees in the front garden.

Single-familyProperty Type

1908Year Built

0.28 acresLot Size

$1,422Est. Price/Sq.Ft.

3 car garageParking

Listed by Ellen Mazzoni •DRE #00911540 • Compass

Contact: 650-464-2097

Bought with The The Sharp Group •DRE #70010101 • KW Advisors

Redfin checked: a few seconds ago

•Source:MLSListings #ML81847665

Redfin Estimate

$5,403,395

$773K since sold in July 2021$304K since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 10.8% higher than the average sale price ($4.88M) of 5 comparable homes.

SOLD MAR 17, 2026
$4,800,000
A
4 beds4 baths3,093 sq ft
626 Occidental Ave, San Mateo, CA 94402
SOLD JUN 9, 2026
$5,420,000
B
4 beds3 baths3,680 sq ft
641 Crescent Ave, San Mateo, CA 94402
SOLD APR 28, 2026
$5,600,000
C
5 beds5 baths3,963 sq ft
150 Clark Dr, San Mateo, CA 94402
SOLD OCT 21, 2025
$3,560,000
D
5 beds4 baths3,560 sq ft
635 Occidental Ave, San Mateo, CA 94402
SOLD AUG 12, 2026
$5,000,000
E
5 beds3 baths3,205 sq ft
554 Edgewood Rd, San Mateo, CA 94402

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$1,781,717

Est. take-home

List your home with Redfin and save $27,017

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$8,187/mo

Redfin rental estimate

List your home for rent

Market trends in 94402, CA

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

107.2%

1.0% MoM

Median sale price

$2.7M

$59K MoM

Avg. days on market

12d

0 days MoM

Recently sold homes

8 MoM

New listings for sale

NEW 1 DAY AGO
$1,195,000
3 beds1 bath1,935 sq ft
610 S Amphlett Blvd, San Mateo, CA 94402
3D WALKTHROUGH
$2,250,000
3 beds2 baths1,610 sq ft
508 Maple St, San Mateo, CA 94402
3D & VIDEO TOUR
$2,999,900
5 beds3 baths2,390 sq ft
731 W Capistrano Way, San Mateo, CA 94402
OPEN SAT, 1PM TO 4PM
$5,495,000
5 beds5 baths3,420 sq ft
408 Warren Rd, San Mateo, CA 94402
EARLY ACCESS
$4,488,000
4 beds3 baths2,668 sq ft
440 Hobart Ave, San Mateo, CA 94402
See all

Provided by Redfin

Sale history for 400 Warren Rd

Year

Property tax

Land + Additions

Assessment*

2025

$47,092 (−0.6%)

$2,796,500 + $1,428,500

$4,225,000

2024

$47,378 (+0.8%)

$2,629,000 + $1,343,000

$3,972,000

2023

$47,017 (−14.4%)

$3,188,826 + $1,628,226

$4,817,052

2022

$54,940 (+245.0%)

$2,629,000 + $1,343,000

$3,972,000

2021

$15,924 (+4.4%)

$3,065,000 + $1,565,000

$4,630,000

2020

$15,249 (+2.1%)

$604,543 + $604,543

$1,209,086

2019

$14,930 (+6.7%)

$598,345 + $598,345

$1,196,690

2018

$13,987 (+2.9%)

$586,613 + $586,613

$1,173,226

2017

$13,597 (+1.8%)

$563,835 + $563,835

$1,127,670

2016

$13,362 (+2.8%)

$563,835 + $563,835

$1,127,670

2015

$12,994 (+3.3%)

$552,780 + $552,780

$1,105,560

2014

$12,579 (+1.6%)

$533,812 + $533,812

$1,067,624

2012

$12,381 (+2.1%)

$531,400 + $531,400

$1,062,800

2011

$12,130 (−2.4%)

$520,981 + $520,981

$1,041,962

2010

$12,434 (+3.3%)

$510,766 + $510,766

$1,021,532

2009

$12,037 (+4.6%)

$506,949 + $506,949

$1,013,898

2008

$11,504

$508,154 + $508,154

$1,016,308

Tax history for 400 Warren Rd

Year

Property tax

Land + Additions

Assessment*

2025

$47,092 (−0.6%)

$2,796,500 + $1,428,500

$4,225,000

2024

$47,378 (+0.8%)

$2,629,000 + $1,343,000

$3,972,000

2023

$47,017 (−14.4%)

$3,188,826 + $1,628,226

$4,817,052

2022

$54,940 (+245.0%)

$2,629,000 + $1,343,000

$3,972,000

2021

$15,924 (+4.4%)

$3,065,000 + $1,565,000

$4,630,000

2020

$15,249 (+2.1%)

$604,543 + $604,543

$1,209,086

2019

$14,930 (+6.7%)

$598,345 + $598,345

$1,196,690

2018

$13,987 (+2.9%)

$586,613 + $586,613

$1,173,226

2017

$13,597 (+1.8%)

$563,835 + $563,835

$1,127,670

2016

$13,362 (+2.8%)

$563,835 + $563,835

$1,127,670

2015

$12,994 (+3.3%)

$552,780 + $552,780

$1,105,560

2014

$12,579 (+1.6%)

$533,812 + $533,812

$1,067,624

2012

$12,381 (+2.1%)

$531,400 + $531,400

$1,062,800

2011

$12,130 (−2.4%)

$520,981 + $520,981

$1,041,962

2010

$12,434 (+3.3%)

$510,766 + $510,766

$1,021,532

2009

$12,037 (+4.6%)

$506,949 + $506,949

$1,013,898

2008

$11,504

$508,154 + $508,154

$1,016,308

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Zoning
Permits

Beds

Baths

4.5

Stories

Lot width

—

Lot depth

—

Lot size

12,150

Year renovated

1990

Sq. Ft.

3,800

Year built

1908

Style

Single Family Residential

County

San Mateo County

APN

032031300

Parking Spaces

Basement

Accessible

HOA Dues

—

Garage

Yes

Features

—

Last updated by owner on Oct 25, 2021.

R1A

Single-Family Residence Districts

The R1 Single-Family Residence Districts are intended to create, preserve and enhance areas suitable for single-family dwellings with a substantial presence of open space and opportunities for outdoor living. The R1 districts are intended to protect the character and variety of neighborhoods, preserve privacy and prevent burdens on public facilities, while allowing reasonable housing opportunities for families.

Permitted uses

Include but are not limited to:

Day care facility
Housing-Single unit
Housing-Mobile home park

Jan 20, 2022 • Final

Single family (alteration/repair) - re-roof

Roofing

Oct 7, 2021 • Final

Electrical, plumbing & mechanical - plumbing

Replace the sewer lateral from the house to the city main in the roadway using the trenchless method.

Plumbing

Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.

Property details

Parking

Parking Information
Garage (Minimum): 3
Garage (Maximum): 3
Parking Description: Attached Garage, Electric Gate, Guest/Visitor Parking, Parking Area
Garage Spaces: 3

Interior

Virtual Tour

Bedroom Information
# of Bedrooms (Minimum): 4
# of Bedrooms (Maximum): 4

Bathroom Information
# of Baths (Full): 4
# of Baths (1/2): 1
Bathroom Description: Bidet, Full on Ground Floor, Half on Ground Floor, Sauna

Room Information
Family Room Description: Kitchen/Family Room Combo
Dining Room Description: Formal Dining Room
Kitchen Description: Cooktop (Gas), Countertop (Granite), Dishwasher, Hood Over Range, Oven (Double), Refrigerator(s)

Fireplace Information
Has Fireplace
Fireplace Description: Gas Starter, In Living Room, In Primary Bedroom
Fireplaces (Minimum): 2

Heating & Cooling Information
Heating: Central Forced Air (Gas), Forced Air

Exterior

Exterior Features
Roof: Tar and Gravel, Tile

Building Information
Subclass: Single Family Home
Building Type: Detached
Crawl Space

Property Features
Living Sq. Ft.: 3,800

Property Information
Property Primary ID: 618137

Land Information
Tract Name: San Mateo Park

Lot Information
Lot Acres: 0.2789
Lot Description: Grade (Level)
Lot Size Area Minimum Units: Sq. Ft.
Lot Size Area Maximum Units: Sq. Ft.
Lot Size Source: Assessor
Zoning: R10000

Financial

Tax/Assessment Information
City Transfer Tax: Yes

Utilities

Utility Information
Sewer Septic: Sewer Connected
Utilities: Public Utilities

Water Information
Water: Individual Water Meter, Public

Location

Multi-Unit Information
# of Stories: 1

School Information
Elementary School District: San Mateo-Foster City Elementary
High School District: San Mateo Union High

Public facts

Beds: 4
Baths: 4.5
Sq. Ft.: 3,800
Stories: 1.0
Parking Spaces: 3
Basement: No
Accessible: No
Lot Size: 0.28 acres
Style: Single Family Residential
Year Built: 1908
Year Renovated: 1990
County: San Mateo County
APN: 032031300
HOA Dues: —
Garage: Yes
Features: —

Home facts updated by owner on Oct 25, 2021

Other

Miscellaneous Information
Incorporated: No

Around this home

Schools

San Mateo Park Elementary School

Public K-5 • Assigned • 0.3mi

2/10

Borel Middle School

Public 6-8 • Assigned • 2.0mi

8/10

San Mateo High School

Public 9-12 • Assigned • 1.1mi

9/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Local insights from Redfin agents

San Mateo stayed one of the Peninsula's busiest markets. Homes averaged 110% of asking price, and buyers continue to compete for updated homes in neighborhoods like Aragon, Baywood and Beresford Park.
1 month ago • San Mateo
Sasai Zhang
Redfin Premier agent
182 deals
Was this helpful?

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

2/10 Heat Factor

7 days above 85° expected this year, 15 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

7/10 Air Factor

12 unhealthy days expected this year, 12 days in 30 years

Provided by First Street

Historical weather

San Mateo, CA • 94402

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 10.5 hours in June and 5 hours in December, placing it above the U.S. average for solar exposure.

10.5 hrs

5 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$5.13M – $6.21M

Reach more buyers when you sell with Redfin. Save up to $54,034 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

OPEN SAT, 1PM TO 4PM

$48,888,000

10 beds10 baths13,059 sq ft

150 New Place Rd, Hillsborough, CA 94010

$11,000,000

5 beds6 baths4,700 sq ft

433 El Centro Rd, Hillsborough, CA 94010

NEW CONSTRUCTION

$3,498,000

4 beds3 baths2,134 sq ft

1029 Capuchino Ave, Burlingame, CA 94010

Listing provided by Zillow

$8,999,000

3 beds3.5 baths3,810 sq ft

2155 Geri Ln, Hillsborough, CA 94010

$2,395,000

4 beds3.5 baths2,480 sq ft

917 Howard Ave, Burlingame, CA 94010

3D WALKTHROUGH

$5,198,000

4 beds4.5 baths2,647 sq ft

1548 Cypress Ave, Burlingame, CA 94010

New listings for sale in 94402

NEW 1 DAY AGO

$1,195,000

3 beds1 bath1,935 sq ft

610 S Amphlett Blvd, San Mateo, CA 94402

3D WALKTHROUGH

$2,250,000

3 beds2 baths1,610 sq ft

508 Maple St, San Mateo, CA 94402

3D & VIDEO TOUR

$2,999,900

5 beds3 baths2,390 sq ft

731 W Capistrano Way, San Mateo, CA 94402

OPEN SAT, 1PM TO 4PM

$5,495,000

5 beds5 baths3,420 sq ft

408 Warren Rd, San Mateo, CA 94402

EARLY ACCESSCOMPASS COMING SOON

$4,488,000

4 beds3 baths2,668 sq ft

440 Hobart Ave, San Mateo, CA 94402

Home values near 400 Warren Rd

Data from public records.

Address	Redfin Estimate
408 Warren Rd, San Mateo, CA 5 Beds \| 5 Baths \| 3420 Sq. Ft.	$5,630,493
339 Warren Rd, San Mateo, CA 3 Beds \| 2.5 Baths \| 1960 Sq. Ft.	$3,297,136

Address	Redfin Estimate
423 Warren Rd, San Mateo, CA 5 Beds \| - Baths \| 4390 Sq. Ft.	$4,784,983
415 Warren Rd, San Mateo, CA 2 Beds \| 1 Baths \| 1560 Sq. Ft.	$2,615,203

Address	Redfin Estimate
335 Warren Rd, San Mateo, CA 5 Beds \| 3 Baths \| 3070 Sq. Ft.	$4,654,366
420 Warren Rd, San Mateo, CA 3 Beds \| 2 Baths \| 1610 Sq. Ft.	$3,365,889

Property information provided by MLSListings when last listed in 2021. This data may not show owner updates. Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

94010 homes for sale
94402 homes for sale
94403 homes for sale
94404 homes for sale
94002 homes for sale

Houses for rent in San Mateo	Agents near me	Irvine, CA homes for sale	San Mateo Housing Market
Houses for sale near me	San Diego, CA homes for sale	Fremont, CA homes for sale
Land for sale near me	San Francisco, CA homes for sale	Pasadena, CA homes for sale
Open Houses near me	Los Angeles, CA homes for sale	San Mateo Property Records
Condos for sale near me	San Jose, CA homes for sale	CA New Listings

San Jose homes for sale
San Francisco homes for sale
Fremont homes for sale

Central San Mateo homes for sale
Northwest Heights homes for sale
San Mateo Park homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 94402, CA

Sale history for 400 Warren Rd

Tax history for 400 Warren Rd

Public record

Property details

Around this home

Schools

Lifestyle

Local insights from Redfin agents

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 94402

Home values near 400 Warren Rd

More real estate resources