Back to Search
ActiveOther

$4,750,000

0 Tartan Trail Rd, Hillsborough 94010

Beds--
Baths--
Sqft--
DOM688
No Photos Available

AddressIntel AI Briefing

At a $4.75M asking price for a vacant lot yielding a maximum 2,000 sqft build, this property is severely overpriced relative to its $3.04M projected ARV. Having languished on the market for 688 days with no local permit heat, this deal is currently unfeasible for developers unless a massive price reduction occurs.

Property Permit History

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

Recent Neighborhood Remodeling (Hillsborough)

2026-07-17452 ROBLAR AVE
LOWER SEWER LATERAL - REPLACEMENT
--Issued
2026-07-17452 ROBLAR AVE
UPPER SEWER LATERAL - SWR AND WTR TEST W REPLACEMENT
--Issued
2026-07-17380 ROBINWOOD LN
LOWER SEWER LATERAL - REPAIR
--Issued
2026-07-17862 CHILTERN RD
UPPER SEWER LATERAL - SEWER AND WATER TEST
--Issued
2026-07-17600 EUCALYPTUS AVE
SEWER VIDEO REVIEW FOR PROPERT...
--Issued
2026-07-17380 ROBINWOOD LN
UPPER SEWER LATERAL - SWR AND WTR TEST W REPAIR
--Issued

Parcel & Zoning Info

APN028120020
Official Lot Sqft28,033
Zoning Code--
SB 9 StatusLikely

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

McKinley Elementary

Burlingame Elementary

0.5 miles away
Middle School

Crocker Middle

Hillsborough City Elementary

0.6 miles away
High School

Burlingame High

San Mateo Union High

1.0 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

100/100

Based on recent sales velocity and local demand in 94010.

Flippability Score

5/100

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

Bidding War Prob.

1%

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.

Based on 6 recent sales in 94010 averaging $1,350/sqft.

Hard Costs$900,000
New Build2,250 sqft
Total Capital Required$5,825,000
Estimated Resale (ARV)$3,037,500

Projected Profit

-$2,787,500
-47.9% ROI

Warning: Project is mathematically underwater.

Recent Comparables (94010)

309 Lorton Ave

Sold
$2,437,500
Sold: 2026-06-18
Lot: -
Sqft: -
$/Sqft: -

524 Oak Grove Ave

Sold
$4,300,000
Sold: 2026-07-17
Lot: 8,788
Sqft: 3208
$/Sqft: $1,340

520 Darrell Rd

Sold
$6,400,000
Sold: 2026-07-17
Lot: 23,012
Sqft: 4746
$/Sqft: $1,349

2512 Hale Dr

Sold
$3,300,000
Sold: 2026-07-16
Lot: 4,922
Sqft: 1606
$/Sqft: $2,055

735 El Camino Real Apt 104

Sold
$710,000
Sold: 2026-07-14
Lot: 944
Sqft: 993
$/Sqft: $715

225 Tobin Clark Dr

Sold
$10,500,000
Sold: 2026-07-14
Lot: 45,902
Sqft: 8145
$/Sqft: $1,289