OFF MARKET

Off Market Oct 2021 for $4M

$4,953,281

Est. refi paymentEst. refi $20,921/mo

•

3,610

sq ft

512 Warren Rd, San Mateo, CA 94402

About this home

Warren Manor is the Picture-perfect French country home in the heart of San Mateo Park. 4 bedrooms and 3.5 bathrooms are beautifully appointed over 3 levels with hardwood and limestone floors, crown moldings, plantation shutters in some rooms, and wrought iron accents. Formal living room plus parlor perfect for a library or home office; formal dining room; stunning gourmet kitchen with the best of gas ranges, La Cornue. Lower-level recreation/media room, separate area for fitness/office, plus 700+/- bottle temp-controlled wine cellar. Upstairs primary suite and separate bedroom perfect for a nursery, full bath on main level, and 2 bedrooms plus full and half-baths on lower level. California outdoor living with sparkling 8' deep pool, drapery-enclosed deck with fire pit for year-round enjoyment plus covered patio and balconies off the kitchen and primary suite. Attached 2-car garage with EV wiring. Minutes to either downtown Burlingame Ave or San Mateo.

Single-familyProperty Type

1920Year Built

8,122 sq ftLot Size

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

2 garage spacesParking

Listed by Alan Canas •DRE #01793936 • Coldwell Banker Realty

Listed by Sarah Hillhouse •DRE #01294373 • Coldwell Banker Realty

Contact: 415-298-8940

Bought with Pamela Culp •DRE #00896337 • Compass

Redfin checked: 2 minutes ago

•Source:MLSListings #ML81861146

$5,439,086

Updated Jul 27, 2026

Based on recent home sales selected by the homeowner.

SOLD MAY 28, 2026
442 Hurlingham Ave, San Mateo, CA 94402
$5,400,000 Last sold price
A
4 beds3 baths2,413 sq ft
442 Hurlingham Ave, San Mateo, CA 94402
BOUGHT WITH REDFIN SEP 22, 2025
424 Occidental Ave, San Mateo, CA 94402
$6,550,000 Last sold price
B
4 beds4 baths3,400 sq ft
424 Occidental Ave, San Mateo, CA 94402
SOLD JUL 14, 2026
537 Hurlingham Ave, San Mateo, CA 94402
$6,600,000 Last sold price
C
4 beds4.5 baths3,640 sq ft
537 Hurlingham Ave, San Mateo, CA 94402
SOLD MAR 2, 2026
670 Edgewood Rd, San Mateo, CA 94402
$5,350,000 Last sold price
D
5 beds4 baths3,080 sq ft
670 Edgewood Rd, San Mateo, CA 94402
SOLD MAR 11, 2026
195 Warren Rd, San Mateo, CA 94401
$4,225,000 Last sold price
E
3 beds2.5 baths2,659 sq ft
195 Warren Rd, San Mateo, CA 94401

Redfin Estimate

$4,953,281

$903K since sold in October 2021$127K since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 8.8% lower than the average sale price ($5.43M) of 6 comparable homes.

SOLD JUL 14, 2026
$6,600,000
A
4 beds4.5 baths3,640 sq ft
537 Hurlingham Ave, San Mateo, CA 94402
SOLD JUN 29, 2026
$5,400,000
B
4 beds3 baths3,195 sq ft
420 W Poplar Ave, San Mateo, CA 94402
SOLD MAR 17, 2026
$4,800,000
C
4 beds4 baths3,093 sq ft
626 Occidental Ave, San Mateo, CA 94402
SOLD AUG 12, 2026
$5,000,000
D
5 beds3 baths3,205 sq ft
554 Edgewood Rd, San Mateo, CA 94402
SOLD MAR 2, 2026
$5,350,000
E
5 beds4 baths3,080 sq ft
670 Edgewood Rd, San Mateo, CA 94402
SOLD JUN 9, 2026
$5,420,000
F
4 beds3 baths3,680 sq ft
641 Crescent Ave, 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,756,234

Est. take-home

List your home with Redfin and save $24,766

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$9,247/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

OPEN TODAY, 2PM TO 4PM
$4,198,000
5 beds2.5 baths2,970 sq ft
769 Crescent Ave, San Mateo, CA 94402
OPEN TODAY, 1PM TO 4PM
$2,398,000
4 beds5 baths2,940 sq ft
1710-1712 Gum St, San Mateo, CA 94402
OPEN TODAY, 11AM TO 5PM
$2,788,000
4 beds3 baths2,944 sq ft
942 S Eldorado St, San Mateo, CA 94402
OPEN TODAY, 12PM TO 4PM
$4,488,000
4 beds3 baths2,668 sq ft
440 Hobart Ave, San Mateo, CA 94402
$1,195,000
3 beds1 bath1,935 sq ft
610 S Amphlett Blvd, San Mateo, CA 94402
OPEN TODAY, 1PM TO 4PM
$5,495,000
5 beds5 baths3,420 sq ft
408 Warren Rd, San Mateo, CA 94402
See all

Provided by Redfin

Sale history for 512 Warren Rd

Date

Event

Price

MLSListings #ML81861146

Oct 22, 2021

Sold

$4,050,000

$1,122/sq ft

Sep 22, 2021

Pending

—

Sep 3, 2021

Listed

$3,995,000

$1,107/sq ft

MLSListings #ML81625706

Nov 4, 2016

Sold

$3,075,000

$852/sq ft

Oct 21, 2016

Pending

—

Oct 3, 2016

Contingent

—

Sep 23, 2016

Listed

$2,995,000

$830/sq ft

+30

Elegant, newly rebuilt picture-perfect home in the heart of San Mateo Park exudes warmth, charm and exquisite architectural details. Features gracious Formal Living Room, elegant Dining Room, gourmet Chef's Kitchen with private balcony overlooking lush gardens and pool. Home also includes four spacious Bedrooms, three and a half Baths, Family Room with French Doors to outdoors, Office, temperature controlled Wine Room, and multiple outdoor entertaining spaces. Exquisite details abound, including soaring wood-beamed ceilings, wide plank oak flooring, oversized moldings, and wrought-iron accents.

MLSListings #ML81301598

Apr 20, 2013

Sold

$2,575,000

$713/sq ft

Mar 25, 2013

Pending

—

Feb 11, 2013

Price Changed

$2,575,000

$713/sq ft

Jan 18, 2013

Listed

$2,675,000

$741/sq ft

+20

MLSListings #ML80764761

Dec 21, 2007

Sold

$2,650,000

$734/sq ft

Nov 28, 2007

Listed

$2,650,000

$734/sq ft

Nov 28, 2007

Listing Removed

—

Public Records

Jun 13, 2003

Sold

$1,020,000

$283/sq ft

MLSListings #ML80321090

Jun 13, 2003

Listing Removed

—

May 16, 2003

Sold

$1,020,000

$283/sq ft

Apr 12, 2003

Listed

$1,100,000

$305/sq ft

Public Records

Jun 12, 2001

Sold

$2,450,000

$679/sq ft

Public Records

Aug 19, 1998

Sold

$1,450,000

$402/sq ft

Public Records

Apr 16, 1997

Sold

$545,000

$151/sq ft

Public Records

Apr 11, 1991

Sold

$727,000

$201/sq ft

Public Records

Nov 6, 1986

Sold

$383,000

$106/sq ft

Public Records

Jul 16, 1986

Sold

$280,000

$78/sq ft

Public Records

Dec 1, 1979

Sold

$185,000

$51/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$42,418 (−9.2%)

$2,422,500 + $1,455,500

$3,878,000

2024

$46,693 (−0.2%)

$2,249,500 + $1,351,500

$3,601,000

2023

$46,769 (−2.0%)

$2,632,212 + $1,581,408

$4,213,620

2022

$47,708 (+21.1%)

$2,478,000 + $1,488,000

$3,966,000

2021

$39,394 (+4.3%)

$2,530,000 + $1,520,000

$4,050,000

2020

$37,753 (+2.1%)

$1,795,938 + $1,501,082

$3,297,020

2019

$36,979 (+3.1%)

$1,777,523 + $1,485,691

$3,263,214

2018

$35,861 (+1.8%)

$1,742,670 + $1,456,560

$3,199,230

2017

$35,226 (+12.1%)

$1,675,000 + $1,400,000

$3,075,000

2016

$31,417 (+2.2%)

$1,675,000 + $1,400,000

$3,075,000

2015

$30,727 (+0.7%)

$1,339,303 + $1,339,303

$2,678,606

2014

$30,499 (+20.1%)

$1,293,345 + $1,293,345

$2,586,690

2012

$25,404 (+0.9%)

$1,250,000 + $1,250,000

$2,500,000

2011

$25,176 (+10.9%)

$1,100,000 + $1,100,000

$2,200,000

2010

$22,700 (−24.9%)

$1,100,000 + $1,100,000

$2,200,000

2009

$30,232 (+2.1%)

$1,000,000 + $1,000,000

$2,000,000

2008

$29,611

$1,351,500 + $1,351,500

$2,703,000

Tax history for 512 Warren Rd

Year

Property tax

Land + Additions

Assessment*

2025

$42,418 (−9.2%)

$2,422,500 + $1,455,500

$3,878,000

2024

$46,693 (−0.2%)

$2,249,500 + $1,351,500

$3,601,000

2023

$46,769 (−2.0%)

$2,632,212 + $1,581,408

$4,213,620

2022

$47,708 (+21.1%)

$2,478,000 + $1,488,000

$3,966,000

2021

$39,394 (+4.3%)

$2,530,000 + $1,520,000

$4,050,000

2020

$37,753 (+2.1%)

$1,795,938 + $1,501,082

$3,297,020

2019

$36,979 (+3.1%)

$1,777,523 + $1,485,691

$3,263,214

2018

$35,861 (+1.8%)

$1,742,670 + $1,456,560

$3,199,230

2017

$35,226 (+12.1%)

$1,675,000 + $1,400,000

$3,075,000

2016

$31,417 (+2.2%)

$1,675,000 + $1,400,000

$3,075,000

2015

$30,727 (+0.7%)

$1,339,303 + $1,339,303

$2,678,606

2014

$30,499 (+20.1%)

$1,293,345 + $1,293,345

$2,586,690

2012

$25,404 (+0.9%)

$1,250,000 + $1,250,000

$2,500,000

2011

$25,176 (+10.9%)

$1,100,000 + $1,100,000

$2,200,000

2010

$22,700 (−24.9%)

$1,100,000 + $1,100,000

$2,200,000

2009

$30,232 (+2.1%)

$1,000,000 + $1,000,000

$2,000,000

2008

$29,611

$1,351,500 + $1,351,500

$2,703,000

*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

3.5

Stories

Lot width

—

Lot depth

—

Lot size

8,122

Year renovated

2000

Sq. Ft.

3,610

Year built

1920

Style

Single Family Residential

County

San Mateo County

APN

031041130

Parking Spaces

Basement

Accessible

HOA Dues

—

Garage

Yes

Features

Pool

Last updated by owner on Apr 18, 2024.

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

Property details

Parking

Parking Information
Garage (Minimum): 2
Garage (Maximum): 2
Parking Description: Attached Garage, Gate/Door Opener
Electric Vehicle Hookup Type: Electric Vehicle Hookup Level 2 (240 volts)
Garage Spaces: 2
Parking Spaces: 3

Interior

Virtual Tour

Bedroom Information
# of Bedrooms (Minimum): 4
# of Bedrooms (Maximum): 4
Bedrooms: Primary Suite/Retreat, Walk-In Closet

Bathroom Information
# of Baths (Full): 3
# of Baths (1/2): 1
Bathroom Description: Double Sinks, Granite, Shower and Tub, Stall Shower, Stone, Tub, Updated Bath(s), Other (See Remarks)

Room Information
Den/Study/Office, Formal Entry, Laundry Room, Office Area, Storage, Wine Cellar/Storage
Family Room Description: Separate Family Room
Dining Room Description: Breakfast Bar, Breakfast Nook, Formal Dining Room
Kitchen Description: Countertop (Granite), Dishwasher, Exhaust Fan, Garbage Disposal, Hood Over Range, Island, Microwave, Oven Range (Built-In, Gas), Pantry, Refrigerator(s)

Interior Features
Laundry: Dryer, Washer
Flooring: Hardwood, Stone, Tile

Fireplace Information
Has Fireplace
Fireplace Description: Gas Starter
Fireplaces (Minimum): 1

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

Exterior

Exterior Features
Fencing: Fenced Back, Wood
Roof: Composition
Yard/Grounds: Backyard, Barbecue Area, Deck, Fenced, Fire Pit, Sprinkler(s) (Auto), Sprinkler(s) (Lawn)

Building Information
Style: French, Tudor
Subclass: Single Family Home
Building Type: Detached
Concrete Perimeter and Slab

Pool Information
Has Pool
Pool Description: Cover, Gunite, Heated, Sweep

Property Features
Amenities: High Ceiling, Open Beam Ceiling, Walk-In Closet
Living Sq. Ft.: 3,247
Security Features: Fire System (Sprinkler), Security Alarm

Property Information
Property Primary ID: 76190

Lot Information
Lot Acres: 0.1865
Lot Description: Grade (Sloped Down)
Lot Size Area Minimum Units: Sq. Ft.
Lot Size Area Maximum Units: Sq. Ft.
Lot Size Source: Assessor
Zoning: R10010

Financial

Tax/Assessment Information
City Transfer Tax: Yes

Utilities

Utility Information
Sewer Septic: Sewer (Public)
Utilities: Public Utilities

Water Information
Water: Public

Location

Multi-Unit Information
# of Stories: 3

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

Public facts

Beds: 4
Baths: 3.5
Sq. Ft.: 3,610
Stories: 2.0
Parking Spaces: 3
Basement: No
Accessible: No
Lot Size: 8,122 square feet
Style: Single Family Residential
Year Built: 1920
Year Renovated: 2000
County: San Mateo County
APN: 031041130
HOA Dues: —
Garage: Yes
Features: Pool

Home facts updated by owner on Apr 18, 2024

Other

Miscellaneous Information
Incorporated: No

Around this home

Schools

San Mateo Park Elementary School

Public K-5 • Assigned • 0.4mi

2/10

Borel Middle School

Public 6-8 • Assigned • 2.0mi

8/10

San Mateo High School

Public 9-12 • Assigned • 1.3mi

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

$4.71M – $5.70M

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

Need the cash from your home fast? Sell to .

Nearby similar homes

OPEN TODAY, 2PM TO 4PM3D WALKTHROUGH

$11,475,000

6 beds7 baths6,430 sq ft

280 Uplands Dr, 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

$11,000,000

5 beds6 baths4,700 sq ft

433 El Centro Rd, Hillsborough, CA 94010

OPEN TODAY, 2PM TO 4PM

$4,198,000

5 beds2.5 baths2,970 sq ft

769 Crescent Ave, San Mateo, CA 94402

OPEN TODAY, 1PM TO 3PM3D & VIDEO TOUR

$5,680,000

4 beds6 baths3,013 sq ft

1033 Cortez Ave, Burlingame, CA 94010

New listings for sale in 94402

OPEN TODAY, 2PM TO 4PM

$4,198,000

5 beds2.5 baths2,970 sq ft

769 Crescent Ave, San Mateo, CA 94402

OPEN TODAY, 1PM TO 4PM3D & VIDEO TOUR

$2,398,000

4 beds5 baths2,940 sq ft

1710-1712 Gum St, San Mateo, CA 94402

OPEN TODAY, 11AM TO 5PM

$2,788,000

4 beds3 baths2,944 sq ft

942 S Eldorado St, San Mateo, CA 94402

OPEN TODAY, 12PM TO 4PM

$4,488,000

4 beds3 baths2,668 sq ft

440 Hobart Ave, San Mateo, CA 94402

$1,195,000

3 beds1 bath1,935 sq ft

610 S Amphlett Blvd, San Mateo, CA 94402

OPEN TODAY, 1PM TO 4PM

$5,495,000

5 beds5 baths3,420 sq ft

408 Warren Rd, San Mateo, CA 94402

Home values near 512 Warren Rd

Data from public records.

Address	Redfin Estimate
530 Warren Road, San Mateo, CA 4 Beds \| 4 Baths \| 3250 Sq. Ft.	$4,717,497
517 Warren Road, San Mateo, CA 3 Beds \| 3 Baths \| 2520 Sq. Ft.	$3,847,355

Address	Redfin Estimate
515 Warren Road, San Mateo, CA 5 Beds \| 4 Baths \| 3390 Sq. Ft.	$4,753,789
500 Warren Road, San Mateo, CA 5 Beds \| 4 Baths \| 3100 Sq. Ft.	$5,224,093

Address	Redfin Estimate
511 Warren Road, San Mateo, CA 5 Beds \| 3 Baths \| 3260 Sq. Ft.	$5,022,573
506 Warren Road, San Mateo, CA 5 Beds \| 4 Baths \| 4232 Sq. Ft.	$6,260,764

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

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

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

About this home

Redfin Estimate

Earn from this home

Market trends in 94402, CA

Sale history for 512 Warren Rd

Tax history for 512 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 512 Warren Rd

More real estate resources