Back to Search
ActiveSingle Family

$5,495,000

408 Warren Rd, San Mateo 94402

Beds5
Baths4.5
Sqft3,420
DOM12
No Photos Available

AddressIntel AI Briefing

This historic century-old home sits on a spacious lot in a premier San Mateo neighborhood with zero hazard risks. The optimal play is an SB 9 lot split into 4 units to unlock maximum density, or alternatively a stealth density: primary + ADU + JADU setup to preserve the main home's historic character. The lack of environmental blockers and strong neighborhood demographics make this a highly versatile site.

Property Permit History

No permit history found directly associated with this property's address.

Recent Neighborhood Remodeling (San Mateo)

2026-09-0427 PRAGUE ST SAN MATEO 94401-1310 CA
Single Family (Alteration/Repair) - Alter
$25,000Issued
2026-09-03242 GREENFIELD AVE Unit: B SAN MATEO CA 94403-5010
Single Family (New) - New
$636,373Issued
2026-09-031543 KALMIA ST SAN MATEO CA 94402-3038
Single Family (Alteration/Repair) - Alter
$60,678Issued
2026-09-03242 GREENFIELD AVE SAN MATEO CA 94403-5010
Single Family (New) - New
$1,080,236Issued
2026-09-011542 ROBERTA DR SAN MATEO 94403-1044 CA
Single Family (Alteration/Repair) - Alter
$145,047Issued
2026-09-011600 LODI AVE SAN MATEO 94401-3658 CA
Single Family (Addition) - Add/Alter
$530,000Issued

Parcel & Zoning Info

APN032031290
Official Lot Sqft12,681
Zoning CodeNO DATA ASSIGNED
SB 9 StatusLikely · up to 4 units
Unlock Pathways
Ministerial ADU Ministerial SB 9 Density Bonus
Entitlement RiskLow (0/100)

ADU Potential

Feasibility Score90/100
Max ADU Units2 (ADU + JADU)
Est. ADU Size1,200 sqft
Existing Coverage27%

Flag / irregular · ~135 ft frontage × 179 ft deep, a tucked-away rear unit is very private; access is typically via the pole driveway.

Screening heuristic based on lot size, existing coverage, lot orientation, and hazard overlays. CA ADU law is ministerial statewide; verify max size, setbacks, and JADU owner-occupancy with the local planning dept.

Redevelopment Potential

Redevelopment Score15/100
ClassBuilt out
FAR Utilization79% of allowed
Buildable Headroom+916 sqft

Existing home already uses most of the allowable floor area, little expansion headroom. Zoning allows roughly 4,336 sqft of gross floor area on this lot.

Screening estimate comparing existing living area to the city's single-family floor-area limit. FAR figure is a discretionary-review trigger, not a hard cap. Treat as approximate. Source: San Mateo Muni Code 27.18.060 (R1-B/C default; district unresolved) (as of 2026-08-24). Verify FAR, coverage, setbacks, and height with the local planning dept.

Hazard Snapshot

Flood Zone

X
Area of minimal flood hazard.

Fire Severity

None
Not in a mapped state fire severity zone.

Liquefaction

No
Not in a mapped liquefaction zone.

Fault Zone

No
Not in a mapped Alquist-Priolo fault zone.

Not a substitute for a Natural Hazard Disclosure (NHD) report. Zones reflect available GIS data and may not cover all localities.

Nearby Public Schools

Elementary School

San Mateo Park Elementary

San Mateo-Foster City

0.3 miles away
Middle School

Crocker Middle

Hillsborough City Elementary

0.9 miles away
High School

Burlingame High

San Mateo Union High

0.9 miles away

School boundaries are subject to change. Nearest school distance does not guarantee enrollment eligibility. Check with the local district. Data provided by CDE.

Proprietary Intelligence

Market Heat Index

79/100

Based on recent sales velocity and local demand in 94402.

Flippability Score

58/100

Measures neighborhood renovation density vs. recent permits on this property.

Bidding War Prob.

60%

Likelihood of multiple offers based on local list-to-sale ratios and DOM.

Proforma ROI Calculator

Back-of-the-napkin deal analysis across development strategies.

Zoning allows roughly 4,336 sqft on this lot, and the default builds to that envelope. The FAR figure is a discretionary-review trigger, not a hard cap.

Median of 12 recent single-family sales in San Mateo (94402): $1,440/sqft. Sized within 25% of the 4,300 sqft build, because smaller houses sell for more per foot and pricing a rebuild off them overstates resale.

Commission, transfer tax and closing. Deducted from resale before profit, so the ROI below is net of the exit rather than gross.

Carry on total capital for the project duration. At 0% the model is a cash purchase; 12 months at a typical construction-loan rate moves ROI by 6 to 10 points on a deal this size, so price it with your real rate.

Hard Costs$2,365,000
New Build4,300 sqft
Total Capital Required$8,035,000
Estimated Resale (ARV)$6,192,000
Cost of Sale (5%)-$309,600
Net Proceeds$5,882,400

Projected Profit

-$2,152,600
-26.8% ROI

Warning: Project is mathematically underwater.

Recent Comparables (San Mateo 94402)

Sized to the modelled 4,300 sqft build: sales within 25% of it. Smaller houses sell for more per foot, so pricing a rebuild off them overstates resale.

613 Barroilhet Ave

Sold
$5,475,000
Sold: 2026-07-31
Lot: 10,000
Sqft: 3342
$/Sqft: $1,638

521 Dorchester Rd

Sold
$4,660,000
Sold: 2026-07-14
Lot: 9,422
Sqft: 4120
$/Sqft: $1,131

537 Hurlingham Ave

Sold
$6,600,000
Sold: 2026-07-14
Lot: 15,923
Sqft: 3640
$/Sqft: $1,813

429 Virginia Ave

Sold
$4,800,000
Sold: 2026-06-12
Lot: 8,605
Sqft: 3270
$/Sqft: $1,468

641 Crescent Ave

Sold
$5,420,000
Sold: 2026-06-09
Lot: 14,585
Sqft: 3680
$/Sqft: $1,473

2060 Bunker Hill Dr

Sold
$3,000,000
Sold: 2026-05-15
Lot: 9,148
Sqft: 3400
$/Sqft: $882

150 Clark Dr

Sold
$5,600,000
Sold: 2026-04-28
Lot: 10,376
Sqft: 3963
$/Sqft: $1,413

809 E 5th Ave

Sold
$2,400,000
Sold: 2026-04-24
Lot: 5,646
Sqft: 3325
$/Sqft: $722

124 W Poplar Ave

Sold
$7,300,000
Sold: 2026-03-12
Lot: 30,851
Sqft: 3470
$/Sqft: $2,104

414 Edgewood Rd

Sold
$6,500,000
Sold: 2026-03-11
Lot: 18,539
Sqft: 3710
$/Sqft: $1,752

74 Crystal Springs Rd

Sold
$3,625,000
Sold: 2026-03-06
Lot: 6,747
Sqft: 3730
$/Sqft: $972

520 Clark Dr

Sold
$4,500,000
Sold: 2026-03-02
Lot: 9,600
Sqft: 3370
$/Sqft: $1,335