0.jpg
1 / 38

247 Madrid St, San Francisco, CA

$1.49M5bd · 3ba · 1,625 sqft
Lot 2,500 sqft•Single Family Residence•
Active
•13d on market•MLS# 00-41153060

Property Description

Welcome to 247 Madrid St! Beautifully renovated and completely move-in ready, this spacious 5-bedroom, 3-bathroom home offers the perfect combination of modern upgrades, comfort, and convenience. Step inside to discover a beautifully updated interior featuring a renovated kitchen, tastefully remodeled bathrooms, new flooring, doors, windows, and paint throughout. Have peace of mind with central heating, copper pipes, tankless water heater, newer 125A panel, retrofitted foundation, and a solar panel system that has been fully paid off. The attached garage has Tesla charger ready equipment. Home and pest reports are clean. Conveniently located near shopping, dining, schools, parks, and major commuter routes, making everyday living a breeze.

Features & Amenities

FeeBuilt 1922

Property Details

Land Type
Fee
Year Built
1922
Property Type
Residential
Property Subtype
Single Family Residence
Heating
Forced Air
Flooring
Vinyl, Tile
City
San Francisco
County
San Francisco
Listed byeXp Realty of California, Yankun Zhen

Mortgage Calculator

Current Rates

$
$
%
Monthly Payment
$7,524.14
Principal & Interest
Loan Amount
$1,190,400
Total Interest
$1,518,290
Total Payment Over 30 Years
$2,708,690
This calculator provides estimates only. Actual mortgage payments may include taxes, insurance, HOA fees, and PMI. Contact a lender for accurate quotes.

Comparative Market Analysis

Residential Tier · 3 active · 5 closed

247 Madrid St, San Francisco, CA

San Francisco · Single Family Residence

$1.49M
Residential Tier
Beds
5
Baths
3
Sqft
1,625
Lot
2,500 sqft
Year
1922
$/Sqft
$916
Pool: No✓

Listed 11.1% below the median closed sale of $1,673,000. Price per sqft ($916) is a 12% discount to closed comps ($1,036). Closed comps sold at 134% of list — strong seller's market.

Price Position

Priced below the market — value advantage over the field.

Price advantage
Subject listed at $1.49M· $916/sqft
Total list price
Closed comps
vs closed median $1.67M
−$185K (−11.1%)
Active comps
vs active median $1.50M
−$7K (−0.5%)
Price per sqft
Closed compsinsufficient comp data
Active comps
vs active avg $/sqft $632
+$284 (+44.9%)

Active Properties (3)

Active Comparables

AddressCityYearBDBTHSqFtLotSzLP/SqFtLPDIMScore
383 Joost AveSan Francisco1948432,6341,873$568$1.50M3063
286 Sagamore STSan Francisco1900431,5865,832$820$1.30M27254
1278 Thomas AveSan Francisco1938022,9525,000$508$1.50M23027
Total: 3 · Average2.72.72,390.6674,235$632$1.43M177.33333333333334
Median2,634$1.50M

Closed Properties (5)

Closed Comparables

AddressCityYearDateBDBTHSqFtLotSzLPSPSP/SqFtSP/LPDIMScore
274 Staples AveSan Francisco192307/20/2026331,6832,813$1.30M$1.70M$1,0101.315477
478 Joost AveSan Francisco195806/05/2026431,7002,500$1.39M$1.50M$8821.082975
1430 Silliman StSan Francisco194508/26/2026421,1422,495$1.20M$1.42M$1,2431.182973
459 FloodSan Francisco192210/23/2026442,0393,371$1.18M$1.67M$8211.425071
230 Ashton AveSan Francisco192205/22/2026221,3752,809$998,000$1.69M$1,2251.692866
Total: 5 · Average3.42.81,587.82,797.6$1.60M$1.60M$1,036.2—38
Median1,683$1.67M$1.67M

Market Analysis

List vs Sale $/SqFt

Sale Price Trend

Days on Market

Sale vs List Price

AI-generated CMA

This analysis was generated automatically from MLS data. For an in-depth, human-reviewed valuation, contact Joseph Sardella at josephsardella@gmail.com.