Back to Search
Activecondos

$668,000

4004 Farm Hill Blvd Apt 303, Redwood City 94061

Beds2
Baths1
Sqft916
DOM179
No Photos Available

AddressIntel AI Briefing

Condominium constraints eliminate any structural or ground-up redevelopment options. Given the high initial asking price versus recent condo sales, margins are too tight for professional developers.

Property Permit History

DateProject TypeStatusValuationContractor
2025-02-10SFR BUILDING - ALTERATIONIssued$85,000ADVANCE CONSTRUCTION TECHNOLOGY INC
2024-09-20MULTIFAMILY BUILDING - ALTERATIONFinaled$90,000ETHOS ELECTRIC INC

Recent Neighborhood Remodeling (Redwood City)

2026-09-24 • 890 EDGEWOOD RD
FIRE BUILDING
--Issued
2026-09-24 • 816 SEAL POINTE DR
ALTERATIONS_RESIDENTIAL
--Issued
2026-09-24 • 767 MEDITERRANEAN LN
ALTERATIONS_RESIDENTIAL
--Issued
2026-09-24 • 200 LATHROP ST
CONSTRUCTION PERMITS
--Approved
2026-09-24 • 681 UPLAND RD
FIRE BUILDING
--Issued
2026-09-24 • 401 GRAND ST
CONSTRUCTION PERMITS
--Approved

Parcel & Zoning Info

APN110290110
Official Lot Sqft1,067
Zoning CodeR-3
SB 9 StatusN/A

Condo Investment Snapshot

Value Score51/100
Price / Sqft$729 vs $732 mkt
Price vs Market-0.4% At market
Est. Rent$2,319/mo

Price positioning vs. 58 recent comparable condo/townhome sales in this ZIP. Est. rent is a rule-of-thumb (price ÷ 24 ÷ 12), not a market quote. SB 9 / ADU development analysis doesn't apply to condos: the owner doesn't control the underlying land.

Seller Motivation

Motivation Score30/100
Some motivation
90+ days on market

Inferred from days on market and listing-description language (e.g. "as-is", "estate sale", "motivated seller"). A screening heuristic for likely negotiability, not a statement about the seller's circumstances.

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. 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

Roy Cloud Elementary

Redwood City Elementary

0.6 miles away
Middle School

John F. Kennedy Middle

Redwood City Elementary

1.4 miles away
High School

Woodside High

Sequoia Union High

1.7 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

74/100

Based on recent sales velocity and local demand in 94061.

Flippability Score

30/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.

Median of 12 recent condo sales in Redwood City (94061): $732/sqft, plus 5% because new houses sold at a median 1.07x their comps across 239 real rebuilds. Sized within 25% of the 1,400 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$770,000
New Build1,400 sqft
Total Capital Required$1,613,000
Estimated Resale (ARV)$1,076,600
Cost of Sale (5%)-$53,830
Carry (33mo @ 7%)-$219,546
Net Proceeds$803,224

Projected Profit

-$809,776
-50.2% ROI

Warning: Project is mathematically underwater.

Recent Comparables (Redwood City 94061)

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

943 Woodside Rd

Sold
$1,175,000
Sold: 2026-10-01
Lot: -
Sqft: 1708
$/Sqft: $688

955 Woodside Rd

Sold
$1,210,000
Sold: 2026-08-17
Lot: -
Sqft: 1694
$/Sqft: $714

50 Horgan Ave Apt 12

Sold
$1,135,000
Sold: 2026-08-12
Lot: 134,560
Sqft: 1550
$/Sqft: $732

Horgan Ave Unit 12

Sold
$1,135,000
Sold: 2026-08-12
Lot: 134,561
Sqft: 1550
$/Sqft: $732

50 Horgan Ave Apt 9

Sold
$1,150,000
Sold: 2026-08-10
Lot: 1,666
Sqft: 1550
$/Sqft: $742

103 Chelsea Way

Sold
$950,000
Sold: 2026-07-24
Lot: -
Sqft: 1200
$/Sqft: $792

908 Woodside Rd

Sold
$1,299,888
Sold: 2026-07-09
Lot: -
Sqft: 1700
$/Sqft: $765

947 Woodside Rd

Sold
$1,199,000
Sold: 2026-07-07
Lot: -
Sqft: 1717
$/Sqft: $698

4016 Farm Hill Blvd Apt 308

Sold
$830,000
Sold: 2026-06-24
Lot: 1,498
Sqft: 1157
$/Sqft: $717

50 Horgan Ave Apt 47

Sold
$1,135,000
Sold: 2026-06-05
Lot: -
Sqft: 1550
$/Sqft: $732

718 Vera Ave

Sold
$1,380,000
Sold: 2026-04-24
Lot: 1,550
Sqft: 1510
$/Sqft: $914

601 Leahy St Apt 201

Sold
$870,000
Sold: 2026-02-24
Lot: 32,317
Sqft: 1555
$/Sqft: $559