Back to Search
ActiveMulti-Family

$1,825,000

2220 Shamrock Dr, Campbell 95008

Beds9
Baths5
Sqft3,395
DOM5
No Photos Available

AddressIntel AI Briefing

With unreliable records for the existing square footage, a standard flip requires careful architectural validation. The optimal play is a focused cosmetic remodel and interior reconfiguration to optimize the functional layout. The stable Campbell school district ensures steady demand from incoming families.

Property Permit History

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

Recent Neighborhood Remodeling (Campbell)

Parcel & Zoning Info

APN41403007
Official Lot Sqft7,841
Zoning Code--
SB 9 StatusN/A

Hazard Snapshot

Flood Zone

D
Special flood hazard area; insurance may be required.

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. Liquefaction and fault flags: modified from California Geological Survey, Web Service of Official Maps of Alquist-Priolo Earthquake Fault Zones and Web Service of Official Maps of Seismic Hazard Zones (2025).

Nearby Public Schools

Elementary School

Farnham Charter

Cambrian

0.6 miles away
Middle School

Price Charter Middle

Cambrian

0.8 miles away
High School

Leigh High

Campbell Union High

2.1 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

72/100

Based on recent sales velocity and local demand in 95008.

Flippability Score

35/100

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

Bidding War Prob.

8%

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.

Median of 12 recent multi-family sales in Campbell (95008): $550/sqft, plus 5% because new houses sold at a median 1.07x their comps across 239 real rebuilds. Sized within 50% of the 5,100 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.

Interest on the purchase price for the whole project plus half the build budget, since construction draws ramp up. The default is 7% over 33 months, the median purchase-to-sale time of 239 real Peninsula and South Bay rebuilds. Set the rate to 0 for a cash purchase, or use your own lender's terms.

Hard Costs$2,805,000
New Build5,100 sqft
Total Capital Required$4,805,000
Estimated Resale (ARV)$2,947,800
Cost of Sale (5%)-$147,390
Carry (33mo @ 7%)-$638,138
Net Proceeds$2,162,273

Projected Profit

-$2,642,728
-55.0% ROI

Warning: Project is mathematically underwater.

Recent Comparables (Campbell 95008)

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

1671 Bucknall Rd

Sold
$2,200,000
Sold: 2026-10-21
Lot: 7,316
Sqft: 3348
$/Sqft: $657

35 Lavonne Dr

Sold
$1,800,000
Sold: 2026-08-31
Lot: 8,064
Sqft: 3535
$/Sqft: $509

1395 Ontario Ln

Sold
$2,050,000
Sold: 2026-08-04
Lot: 9,148
Sqft: 3440
$/Sqft: $596

1410 Ontario Ln

Sold
$1,960,000
Sold: 2026-07-01
Lot: 8,634
Sqft: 3136
$/Sqft: $625

Ravenscourt

Sold
$2,800,000
Sold: 2026-04-23
Lot: 14,000
Sqft: 6656
$/Sqft: $421

1177 Smith Ave

Sold
$2,822,400
Sold: 2026-03-27
Lot: 12,675
Sqft: 5040
$/Sqft: $560

482 Dover Way

Sold
$1,675,000
Sold: 2026-02-27
Lot: 6,465
Sqft: 2592
$/Sqft: $646

614 Beta Ct

Sold
$1,710,000
Sold: 2025-12-16
Lot: 11,700
Sqft: 3400
$/Sqft: $503

115 Superior Dr

Sold
$1,945,375
Sold: 2025-12-11
Lot: 10,703
Sqft: 4206
$/Sqft: $463

203 Wilton Dr

Sold
$1,850,000
Sold: 2025-11-21
Lot: 7,852
Sqft: 3747
$/Sqft: $494

935 Ravenscourt Ave

Sold
$1,800,000
Sold: 2025-09-12
Lot: 6,525
Sqft: 3328
$/Sqft: $541

695 W Valley Dr

Sold
$2,275,000
Sold: 2025-08-18
Lot: 8,030
Sqft: 3785
$/Sqft: $601

Get Teardown Watch

For builders and developers. Text 415-723-0098 with your email address and the cities you build in, or email Andrew at andrew@addressintel.co. It covers San Mateo County, Mountain View and Saratoga. You get the full list for your cities by email every week for four weeks, free: the flagged listings with street addresses, plus off-market houses in 7 San Mateo County cities.

After four weeks it is $99 a month if you want to keep it. Nothing is charged unless you say yes.

How listings get flagged