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-27740 CLYDESDALE DR
TREE REMOVAL - HAZARD ON PRIVATE PROPERTY
--Issued
2026-07-271495 BAIRN DR
HVAC - AC CONDENSER
--Issued
2026-07-231320 LA HONDA RD
UTILITY INFRASTRUCTURE - VEGETATION MANAGEMENT
--Issued
2026-07-232055 FOREST VIEW AVE
SWIMMING POOL - NEW
--Issued
2026-07-23420 BARBARA WAY
TREE REMOVAL - HAZARD ON PRIVATE PROPERTY
--Issued
2026-07-2355 FALKIRK LN
REMODEL - MAJOR REMODEL OVER 1000 SF
--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,318/sqft.

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

Projected Profit

-$2,859,500
-49.1% ROI

Warning: Project is mathematically underwater.

Recent Comparables (94010)

39 Humboldt Rd

Sold
$2,750,000
Sold: 2026-07-24
Lot: 5,398
Sqft: 2053
$/Sqft: $1,340

109 Alturas Dr

Sold
$6,350,000
Sold: 2026-07-24
Lot: 11,337
Sqft: 4410
$/Sqft: $1,440

1515 Floribunda Ave Apt 309

Sold
$690,000
Sold: 2026-07-23
Lot: -
Sqft: 1004
$/Sqft: $687

904 Larkspur Dr

Sold
$1,900,000
Sold: 2026-07-24
Lot: 7,500
Sqft: 1550
$/Sqft: $1,226

820 Eucalyptus Ave

Sold
$8,038,000
Sold: 2026-07-23
Lot: 22,335
Sqft: 4230
$/Sqft: $1,900

35 Tulip Ct

Sold
$2,900,000
Sold: 2026-07-22
Lot: 11,764
Sqft: 2200
$/Sqft: $1,318