Back to Search
Off-MarketCondo

$1,398,000

657 Walnut St Apt 540, San Carlos 94070

Beds2
Baths2
Sqft1,223
DOM13
No Photos Available

AddressIntel AI Briefing

This modern condo unit built in 2020 represents a stable, turn-key rental income asset with low maintenance overhead. It trades at a premium to the market, serving strictly as a yield-focused portfolio hold with minimal near-term capital appreciation potential.

Property Permit History

DateProject TypeStatusValuationContractor
2026-04-09MEP - Mechanical MiscellaneousFinaled$4,113NUR HVAC INC
2025-09-18Building (Residential) - Bathroom RemodelPlan Approval Expired$1,500Owner Builder
2025-07-16Building (Residential) - Bathroom RemodelPlan Approval Expired$25,000Owner Builder
2025-06-05Building (Residential) - Bathroom RemodelFinaled$7,500CITY OF SAN CARLOS LESSEE
2025-01-28MEP - New FAUFinaled$1,560CITY OF SAN CARLOS LESSEE
2024-03-14MEP - Water HeaterFinaled--ACCO ENGINEERED SYSTEMS
2023-10-19Building (Residential) - Bathroom RemodelExpired$13,000BAY BUILDING & CONSTRUCTION INC
2023-05-25Building (Commercial) - SignageFinaled--CITY OF SAN CARLOS LESSEE
2023-03-29Building (Residential) - Bathroom RemodelFinaled$20,000CITY OF SAN CARLOS LESSEE

Recent Neighborhood Remodeling (San Carlos)

2026-09-18201 HILLCREST RD SAN CARLOS CA 94070
Building Residential-Interior Remodel
$150,000Issued
2026-09-181893 CARMELITA DR SAN CARLOS CA 94070
Building Residential-New Single Family
$2,400,000Issued
2026-09-1824 OAK CREEK LN SAN CARLOS CA 94070
Building Residential- Addition
$600,000Issued
2026-09-1640 ARUNDEL RD SAN CARLOS CA 94070
Building Residential- Addition
$210,000Issued
2026-09-1517 AZALEA LN SAN CARLOS CA 94070
Building Residential-Interior Remodel
$60,000Issued
2026-09-142534 HOWARD AVE SAN CARLOS CA 94070
MEP - Electrical Temporary Power
$3,000Issued

Parcel & Zoning Info

APN118140999
Official Lot Sqft81,224
Zoning CodeNO DATA ASSIGNED
SB 9 StatusN/A

Condo Investment Snapshot

Value Score0/100
Price / Sqft$1,143 vs $889 mkt
Price vs Market+28.6% Above market
Est. Rent$4,854/mo

Price positioning vs. 61 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.

Hazard Snapshot

Flood Zone

X
Area of minimal flood hazard.

Fire Severity

None
Not in a mapped state fire severity zone.

Liquefaction

Yes
In a mapped liquefaction zone. May require specialized foundation engineering.

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

Arroyo

San Carlos Elementary

0.4 miles away
Middle School

Central Middle

San Carlos Elementary

0.3 miles away
High School

Redwood High

Sequoia Union High

1.2 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

86/100

Based on recent sales velocity and local demand in 94070.

Flippability Score

10/100

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

Bidding War Prob.

46%

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 10 recent condo sales in San Carlos (94070): $881/sqft. Sized within 25% of the 1,800 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$990,000
New Build1,800 sqft
Total Capital Required$2,563,000
Estimated Resale (ARV)$1,585,800
Cost of Sale (5%)-$79,290
Net Proceeds$1,506,510

Projected Profit

-$1,056,490
-41.2% ROI

Warning: Project is mathematically underwater.

Recent Comparables (San Carlos 94070)

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

402 Portofino Dr Apt 3

Sold
$1,000,000
Sold: 2026-09-18
Lot: 1,084
Sqft: 1570
$/Sqft: $637

793 Elm St Apt 21

Sold
$1,256,000
Sold: 2026-07-31
Lot: -
Sqft: 1519
$/Sqft: $827

520 El Camino Real Ste 309

Sold
$1,310,000
Sold: 2026-07-02
Lot: -
Sqft: 1424
$/Sqft: $920

793 Elm St Apt 23

Sold
$1,330,000
Sold: 2026-06-16
Lot: -
Sqft: 1512
$/Sqft: $880

656 Walnut St Unit 401

Sold
$1,605,000
Sold: 2026-05-07
Lot: -
Sqft: 1628
$/Sqft: $986

404 Portofino Dr Apt 3

Sold
$1,255,000
Sold: 2026-04-17
Lot: -
Sqft: 1570
$/Sqft: $799

560 El Camino Real Apt 407

Sold
$1,700,000
Sold: 2026-03-24
Lot: -
Sqft: 1425
$/Sqft: $1,193

793 Elm St Apt 17

Sold
$1,357,000
Sold: 2026-03-09
Lot: -
Sqft: 1539
$/Sqft: $882

777 Walnut St Apt 404

Sold
$1,825,000
Sold: 2026-01-26
Lot: 14,780
Sqft: 1490
$/Sqft: $1,225

438 Portofino Dr Apt 101

Sold
$1,375,000
Sold: 2025-12-12
Lot: -
Sqft: 2113
$/Sqft: $651