Off market may 2005 for $1.9M

$4,085,798

Est. refi paymentEst. refi $12,106/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,542Est. Price/Sq.Ft.

2 car garageParking

Listed by Hinh Khong •DRE #00867898 • Compass

Contact: (650) 931-2007

Bought with Maureen M Schwartz • Intero Real Estate Services

Redfin checked: a minute ago

•Source:MLSListings #ML80519344

Redfin Estimate

$4,085,798

$2.2M since sold in May 2005$12K since September

Recently sold homes
Estimate history
Homes for sale

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

SOLD OCT 9, 2026
$4,705,000
A
5 beds2.5 baths2,970 sq ft
769 Crescent Ave, San Mateo, CA 94402
SOLD AUG 12, 2026
$5,000,000
B
5 beds3 baths3,205 sq ft
554 Edgewood Rd, San Mateo, CA 94402
SOLD MAR 9, 2026
$3,821,000
C
4 beds3 baths2,045 sq ft
152 Pepper Ave, Burlingame, CA 94010
SOLD AUG 5, 2026
$4,210,000
D
4 beds3 baths2,770 sq ft
520 Francisco Dr, Burlingame, CA 94010
SOLD OCT 2, 2026
$2,425,000
E
4 beds3.5 baths2,480 sq ft
917 Howard Ave, Burlingame, CA 94010
SOLD SEP 18, 2026
$3,517,500
F
4 beds3.5 baths2,041 sq ft
804 Acacia Dr, Burlingame, CA 94010

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

Earn from this home

Sell

$3,239,294

Est. take-home

List your home with Redfin and save $20,429

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$6,512/mo

Redfin rental estimate

List your home for rent

Market trends in 94401, CA

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

102.1%

0.9% MoM

Median sale price

$1.2M

$13K MoM

Avg. days on market

25d

4 days MoM

Recently sold homes

1 MoM

New listings for sale

OPEN SUN, 1PM TO 4PM
$1,388,000
3 beds2 baths1,250 sq ft
24 North Idaho St, San Mateo, CA 94401
OPEN SUN, 1PM TO 4PM
$1,198,000
3 beds2 baths1,070 sq ft
221 North Delaware St, San Mateo, CA 94401
OPEN SUN, 2PM TO 4PM
$575,000
1 bed1 bath693 sq ft
815 North Humboldt St #304, San Mateo, CA 94401
OPEN SUN, 2PM TO 4PM
$988,000
2 beds2 baths1,400 sq ft
58 North El Camino Real #204, San Mateo, CA 94401
OPEN SUN, 1:30PM TO 4PM
$1,688,000
3 beds2 baths2,070 sq ft
450-452 State St, San Mateo, CA 94401
OPEN SUN, 2PM TO 4PM
$1,150,000
2 beds2.5 baths1,485 sq ft
820 Jefferson Ct, San Mateo, CA 94401
OPEN SUN, 2PM TO 4PM
$1,595,000
4 beds3 baths2,040 sq ft
1810 Kehoe Ave, San Mateo, CA 94401
OPEN SUN, 1:30PM TO 4PM
$1,225,000
2 beds2.5 baths1,235 sq ft
43 Tidal Way, 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,350,696 + $1,411,065

$2,761,761

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,350,696 + $1,411,065

$2,761,761

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
Permits

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 Sep 2, 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 Sep 2, 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 starting in January 2026, median prices climbed steadily, reaching a strong spring peak in March–April 2026 at around $2.35M–$2.4M. Prices pulled back in July, rebounded briefly in August, and closed in September 2026 at around...
1 week ago • San Mateo
Helen Li
Redfin Premier agent
94 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.88M – $4.70M

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

Need the cash from your home fast? Sell to .

Nearby similar homes

OPEN SUN, 1PM TO 4PM

$1,198,000

3 beds2 baths1,070 sq ft

221 North Delaware St, San Mateo, CA 94401

$39,000,000

9 beds7 baths14,290 sq ft

85 Fagan Dr, Hillsborough, CA 94010

OPEN SUN, 1PM TO 4PM3D WALKTHROUGH

$3,995,000

4 beds3 baths3,265 sq ft

1238 Bernal Ave, Burlingame, CA 94010

OPEN SUN, 2:30PM TO 5PM3D WALKTHROUGH

$2,398,000

3 beds3 baths995 sq ft

804 Howard Ave, Burlingame, CA 94010

$26,000,000

6 beds9 baths10,890 sq ft

950 Macadamia Dr, Hillsborough, CA 94010

OPEN SUN, 2PM TO 4PM3D & VIDEO TOUR

$3,498,000

3 beds2.5 baths2,120 sq ft

760 Edgewood Rd, San Mateo, CA 94402

New listings for sale in 94401

OPEN SUN, 1PM TO 4PM

$1,388,000

3 beds2 baths1,250 sq ft

24 North Idaho St, San Mateo, CA 94401

OPEN SUN, 1PM TO 4PM

$1,198,000

3 beds2 baths1,070 sq ft

221 North Delaware St, San Mateo, CA 94401

OPEN SUN, 2PM TO 4PM

$575,000

1 bed1 bath693 sq ft

815 North Humboldt St #304, San Mateo, CA 94401

OPEN SUN, 2PM TO 4PM

$988,000

2 beds2 baths1,400 sq ft

58 North El Camino Real #204, San Mateo, CA 94401

OPEN SUN, 1:30PM TO 4PMVIDEO TOUR

$1,688,000

3 beds2 baths2,070 sq ft

450-452 State St, San Mateo, CA 94401

OPEN SUN, 2PM TO 4PM3D & VIDEO TOUR

$1,150,000

2 beds2.5 baths1,485 sq ft

820 Jefferson Ct, San Mateo, CA 94401

OPEN SUN, 2PM TO 4PM

$1,595,000

4 beds3 baths2,040 sq ft

1810 Kehoe Ave, San Mateo, CA 94401

OPEN SUN, 1:30PM TO 4PM3D WALKTHROUGH

$1,225,000

2 beds2.5 baths1,235 sq ft

43 Tidal Way, 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,514,319
177 Warren Road, San Mateo, CA 5 Beds \| 4.5 Baths \| 3590 Sq. Ft.	$5,253,246

Address	Redfin Estimate
160 Warren Road, San Mateo, CA 2 Beds \| 1 Baths \| 1410 Sq. Ft.	$2,255,971
180 Warren Road, San Mateo, CA 3 Beds \| 3 Baths \| 2720 Sq. Ft.	$3,848,909

Address	Redfin Estimate
170 Warren Road, San Mateo, CA 3 Beds \| 2 Baths \| 2125 Sq. Ft.	$3,714,958
149 Warren Road, San Mateo, CA 4 Beds \| 3 Baths \| 1770 Sq. Ft.	$3,283,370

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	Sacramento, 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 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