Off Market May 2005 for $1.9M

$4,127,436

Est. refi paymentEst. refi $11,625/mo

•

2,650

sq ft

174 WARREN Rd, San Mateo, CA 94401

About this home

Single-familyProperty Type

1932Year Built

4,500 sq ftLot Size

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

2 car garageParking

Listed by Ellen Mazzoni •DRE #00911540 • Compass

Contact: (650) 931-2007

Bought with Maureen M Schwartz • Intero Real Estate Services

Redfin checked: a few seconds ago

•Source:MLSListings #ML80519344

Redfin Estimate

$4,127,436

$2.2M since sold in May 2005$134K since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 5.9% higher than the average sale price ($3.90M) of 6 comparable homes.

SOLD AUG 12, 2026
$5,000,000
A
5 beds3 baths3,205 sq ft
554 Edgewood Rd, San Mateo, CA 94402
SOLD MAR 9, 2026
$3,821,000
B
4 beds3 baths2,045 sq ft
152 Pepper Ave, Burlingame, CA 94010
SOLD AUG 5, 2026
$4,210,000
C
4 beds3 baths2,770 sq ft
520 Francisco Dr, Burlingame, CA 94010
SOLD DEC 5, 2025
$3,650,000
D
4 beds3 baths2,375 sq ft
343 Warren Rd, San Mateo, CA 94402
SOLD AUG 18, 2026
$3,450,000
E
4 beds2.5 baths2,156 sq ft
442 Marin Dr, Burlingame, CA 94010
SOLD JUN 4, 2026
$3,250,000
F
5 beds2 baths1,900 sq ft
131 Barroilhet Ave, San Mateo, CA 94401

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

Earn from this home

Sell

$3,273,746

Est. take-home

List your home with Redfin and save $20,637

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$7,160/mo

Redfin rental estimate

List your home for rent

Market trends in 94401, CA

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

104.9%

0.8% MoM

Median sale price

$1.3M

$32K MoM

Avg. days on market

25d

3 days MoM

Recently sold homes

2 MoM

New listings for sale

EARLY ACCESS
$748,000
2 beds2 baths1,020 sq ft
240 N Bayshore Blvd #315, San Mateo, CA 94401
OPEN SAT, 1PM TO 4PM
$1,398,000
3 beds2 baths1,372 sq ft
1625 Cottage Grove Ave, San Mateo, CA 94401
OPEN SUN, 2PM TO 4PM
$2,988,000
3 beds3 baths3,116 sq ft
555 Laurel Ave #122, San Mateo, CA 94401
$749,000
2 beds2 baths1,200 sq ft
1 Baldwin Ave #609, San Mateo, CA 94401
3D WALKTHROUGH
$746,900
2 beds1 bath1,032 sq ft
808 Laurel Ave #202, San Mateo, CA 94401
$1,398,000
3 beds2 baths1,080 sq ft
1546 Maxine Ave, San Mateo, CA 94401
3D WALKTHROUGH
$1,298,888
2 beds2 baths1,400 sq ft
216 8th Ave, San Mateo, CA 94401
3D WALKTHROUGH
$1,298,000
2 beds2 baths1,680 sq ft
35 9th Ave #5, San Mateo, CA 94401
REDFIN OPEN TODAY, 4PM TO 7PM
$900,000
2 beds2 baths1,195 sq ft
153 N N San Mateo Dr #304, San Mateo, CA 94401
$4,998,000
12 beds12 baths7,756 sq ft
1101 Tilton Ave, San Mateo, CA 94401
See all

Provided by Redfin

Sale history for 174 WARREN Rd

Date

Event

Price

Public Records

May 26, 2005

Sold

$1,900,000

$717/sq ft

MLSListings #ML80519344

May 26, 2005

Listing Removed

—

Apr 22, 2005

Sold

$1,900,000

$717/sq ft

Apr 15, 2005

Listed

$1,795,000

$677/sq ft

MLSListings #ML80224632

Jul 30, 2002

Sold

$1,600,000

$604/sq ft

Jun 17, 2002

Listing Removed

—

May 16, 2002

Listed

$1,670,000

$630/sq ft

Public Records

Apr 29, 1994

Sold

$361,000

$136/sq ft

Public Records

Apr 29, 1994

Sold

$685,000

$258/sq ft

Public Records

Jun 14, 1988

Sold

$390,500

$147/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$33,355 (+2.2%)

$1,324,212 + $1,383,398

$2,707,610

2024

$32,653 (+2.7%)

$1,324,212 + $1,383,398

$2,707,610

2023

$31,805 (−1.0%)

$1,298,248 + $1,356,274

$2,654,522

2022

$32,128 (+3.5%)

$1,272,793 + $1,329,682

$2,602,475

2021

$31,046 (−2.9%)

$1,247,837 + $1,303,611

$2,551,448

2020

$31,989 (+2.3%)

$1,223,370 + $1,278,051

$2,501,421

2019

$31,279 (+8.2%)

$1,210,826 + $1,264,947

$2,475,773

2018

$28,911 (+2.3%)

$1,187,085 + $1,240,145

$2,427,230

2017

$28,249 (+6.0%)

$1,140,990 + $1,191,990

$2,332,980

2016

$26,662 (+10.7%)

$1,140,990 + $1,191,990

$2,332,980

2015

$24,089 (+13.8%)

$1,118,618 + $1,118,618

$2,237,236

2014

$21,164 (+5.8%)

$900,000 + $900,000

$1,800,000

2012

$20,012 (−1.1%)

$825,000 + $825,000

$1,650,000

2011

$20,230 (+3.2%)

$825,000 + $825,000

$1,650,000

2010

$19,595 (−8.7%)

$825,000 + $825,000

$1,650,000

2009

$21,456 (−7.3%)

$825,000 + $825,000

$1,650,000

2008

$23,152

$900,000 + $900,000

$1,800,000

Tax history for 174 WARREN Rd

Year

Property tax

Land + Additions

Assessment*

2025

$33,355 (+2.2%)

$1,324,212 + $1,383,398

$2,707,610

2024

$32,653 (+2.7%)

$1,324,212 + $1,383,398

$2,707,610

2023

$31,805 (−1.0%)

$1,298,248 + $1,356,274

$2,654,522

2022

$32,128 (+3.5%)

$1,272,793 + $1,329,682

$2,602,475

2021

$31,046 (−2.9%)

$1,247,837 + $1,303,611

$2,551,448

2020

$31,989 (+2.3%)

$1,223,370 + $1,278,051

$2,501,421

2019

$31,279 (+8.2%)

$1,210,826 + $1,264,947

$2,475,773

2018

$28,911 (+2.3%)

$1,187,085 + $1,240,145

$2,427,230

2017

$28,249 (+6.0%)

$1,140,990 + $1,191,990

$2,332,980

2016

$26,662 (+10.7%)

$1,140,990 + $1,191,990

$2,332,980

2015

$24,089 (+13.8%)

$1,118,618 + $1,118,618

$2,237,236

2014

$21,164 (+5.8%)

$900,000 + $900,000

$1,800,000

2012

$20,012 (−1.1%)

$825,000 + $825,000

$1,650,000

2011

$20,230 (+3.2%)

$825,000 + $825,000

$1,650,000

2010

$19,595 (−8.7%)

$825,000 + $825,000

$1,650,000

2009

$21,456 (−7.3%)

$825,000 + $825,000

$1,650,000

2008

$23,152

$900,000 + $900,000

$1,800,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

Beds

Baths

Stories

Lot width

—

Lot depth

—

Lot size

6,313 Sq. Ft.

Year renovated

1970

Sq. Ft.

2,650

Year built

1920

Style

Single Family Residential

County

San Mateo County

APN

032081080

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 15, 2026.

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: Detached, Gate/Door Opener, Off-Street Parking
Garage Spaces: 2

Interior

Bedroom Information
# of Bedrooms (Minimum): 5
# of Bedrooms (Maximum): 5
Bedrooms: Primary Suite/Retreat, Ground Floor Bedroom

Bathroom Information
# of Baths (Full): 3
# of Baths (Minimum): 3
# of Baths (Maximum): 3
Bathroom Description: 2+ Showers Over Tubs, 2+ Tubs, Stall Shower, Tub w/Jets

Room Information
Separate Unit/Apartment
Family Room Description: Kitchen/Family Room Combo
Dining Room Description: Formal Dining Room
Kitchen Description: Dishwasher, Cooktop, Garbage Disposal, Oven (Built-In), Hookups (Gas)

Interior Features
Laundry: In Laundry Room, Dryer, Washer
Flooring: Carpet (Wall-to-Wall), Hardwood

Fireplace Information
Fireplace Description: In Family Room, In Living Room, Wood-Burning, Gas Starter, Fireplace Available

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

Exterior

Exterior Features
View: Local/Neighborhood
Roof: Composition
Yard/Grounds: Patio(s), Sprinkler(s) (Front), Sprinkler(s) (Rear), Sprinkler(s) (Auto), Deck, Fenced

Building Information
Style: Cape Cod
Subclass: Single Family Home
Building Type: Detached
Concrete Perimeter
Building Height (Minimum): 2
Building Height (Maximum): 2

Property Features
Amenities: Window Covering(s)
Living Sq. Ft.: 2,650
Security Features: Security Alarm (Owned)

Property Information
Level (Street/Main): Bedroom(s)
Property Primary ID: 191415

Lot Information
Lot Description: Grade (Level)
Lot Size Area Minimum Units: Sq. Ft.
Lot Size Area Maximum Units: Sq. Ft.
Zoning: R100

Financial

Tax/Assessment Information
City Transfer Tax: Yes

Utilities

Utility Information
Sewer Septic: Sewer in Street, Sewer Connected

Water Information
Water: Public

Location

Multi-Unit Information
# of Stories: 2

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

Public facts

Beds: 3
Baths: 3.0
Sq. Ft.: 2,650
Stories: 1.0
Lot Size: 6,313 square feet
Style: Single Family Residential
Year Built: 1920
Year Renovated: 1970
County: San Mateo County
APN: 032081080

Home facts updated by county records on Jul 15, 2026

Around this home

Schools

San Mateo Park Elementary School

Public K-5 • Assigned • 0.2mi

2/10

Borel Middle School

Public 6-8 • Assigned • 2.0mi

8/10

San Mateo High School

Public 9-12 • Assigned • 0.9mi

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 • 94401

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

$3.92M – $4.75M

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

Need the cash from your home fast? Sell to .

Nearby similar homes

$48,888,000

10 beds10 baths13,059 sq ft

150 New Place 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

$28,995,000

11 beds12.5 baths18,535 sq ft

1200 Armsby Dr, Hillsborough, CA 94010

3D WALKTHROUGH

$5,198,000

4 beds4.5 baths2,647 sq ft

1548 Cypress Ave, Burlingame, CA 94010

$2,395,000

4 beds3.5 baths2,480 sq ft

917 Howard Ave, Burlingame, CA 94010

$5,495,000

5 beds5 baths3,420 sq ft

408 Warren Rd, San Mateo, CA 94402

New listings for sale in 94401

EARLY ACCESSCOLDWELL BANKER REALTY COMING SOON

$748,000

2 beds2 baths1,020 sq ft

240 N Bayshore Blvd #315, San Mateo, CA 94401

OPEN SAT, 1PM TO 4PMVIDEO TOUR

$1,398,000

3 beds2 baths1,372 sq ft

1625 Cottage Grove Ave, San Mateo, CA 94401

OPEN SUN, 2PM TO 4PM

$2,988,000

3 beds3 baths3,116 sq ft

555 Laurel Ave #122, San Mateo, CA 94401

$749,000

2 beds2 baths1,200 sq ft

1 Baldwin Ave #609, San Mateo, CA 94401

3D WALKTHROUGH

$746,900

2 beds1 bath1,032 sq ft

808 Laurel Ave #202, San Mateo, CA 94401

$1,398,000

3 beds2 baths1,080 sq ft

1546 Maxine Ave, San Mateo, CA 94401

3D WALKTHROUGH

$1,298,888

2 beds2 baths1,400 sq ft

216 8th Ave, San Mateo, CA 94401

3D WALKTHROUGH

$1,298,000

2 beds2 baths1,680 sq ft

35 9th Ave #5, San Mateo, CA 94401

REDFIN OPEN TODAY, 4PM TO 7PM3D WALKTHROUGH

$900,000

2 beds2 baths1,195 sq ft

153 N N San Mateo Dr #304, San Mateo, CA 94401

Home values near 174 WARREN Rd

Data from public records.

Address	Redfin Estimate
140 Warren Road, San Mateo, CA 2 Beds \| 1.5 Baths \| 1310 Sq. Ft.	$2,440,586
177 Warren Road, San Mateo, CA 5 Beds \| 4.5 Baths \| 3590 Sq. Ft.	$5,244,448

Address	Redfin Estimate
160 Warren Road, San Mateo, CA 2 Beds \| 1 Baths \| 1410 Sq. Ft.	$2,195,080
180 Warren Road, San Mateo, CA 3 Beds \| 3 Baths \| 2720 Sq. Ft.	$3,995,305

Address	Redfin Estimate
170 Warren Road, San Mateo, CA 3 Beds \| 2 Baths \| 2125 Sq. Ft.	$3,673,475
149 Warren Road, San Mateo, CA 4 Beds \| 3 Baths \| 1770 Sq. Ft.	$3,191,995

Property information provided by MLSListings when last listed in 2005. This data may not match . 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 94401, CA

Sale history for 174 WARREN Rd

Tax history for 174 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 94401

Home values near 174 WARREN Rd

More real estate resources