646-648 Madrid Street, San Francisco, CA 94112, San Francisco, 94112 - 4 bed, 0 bath
Loading property details...
646-648 Madrid Street
San Francisco, CA 94112
ACTIVE
CONDITION: POOR
4Beds
0Baths
1,400Sq Ft
2,496Lot Size
Property Price
LIST PRICE$1,150,000
EST. MARKET VALUE
$1,108,058
3% AboveMARKET VALUE
SUMMARY
This 2-unit duplex presents a High-Potential Investment Opportunity with a List Price of $1,150,000—positioned above the $1,108,059 Fair Market Value by -3%. Featuring a Condition Rating of 5, this 1905 asset requires comprehensive rehabilitation to address structural and system needs. The property offers significant versatility with a deliverable vacant lower unit and proximity to Top-Rated Schools like Lowell High. This is a strategic acquisition ideal for Buy-and-Hold Investors or Contractors seeking to capture value through renovation in a high-demand San Francisco market.
Estimated Market Value
$1,108,058
Based on Realkey algorithm analyzing recent comparable sales in San Francisco.
Comparable Sales Map
Comparables within 1 miles sold in recently
Map unavailable.
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 646-648 Madrid Street Subject | $1,150,000* List Price | 4 | 0 | 1,400 | $791 | - |
A 5465 Mission Street Active | $999,999 List Price | 2 | 0 | 1,275 | $784 | 0.7 mi |
* Subject property listed price vs sold prices of comps.
Condition Analysis
See Full ReportOVERALL CONDITION SCORE
Poor
TeardownExcellent
Property is extensive renovation needed.
Originally built in 1905, this 119-year-old duplex shows significant signs of age with no mention of recent major system (HVAC/Electric) or structural renovations. The exterior siding and trim show wear, and the description of the basement as having 'uneven height' and being 'sloped' suggests potential foundation or structural issues common in un-rehabilitated San Francisco properties of this era. While the interior shows some minor cosmetic flooring updates, the overall condition indicates a need for a comprehensive rehab.
PROSSTRENGTHS & OPPORTUNITIES
- Great Schools
Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
- Dual-Unit Income Potential
This 2-unit duplex offers excellent versatility for investors or owner-occupiers, with the lower level deliverable vacant at close of escrow and an additional room for flexible use.
- Prime Location & Accessibility
Ideally situated near local shops, restaurants, and public transportation, providing high convenience and strong rental demand in a vibrant San Francisco neighborhood.
CONSRISKS & DEFICIENCIES
- Tenant Occupancy Constraints
The top floor is currently tenant-occupied and subject to San Francisco tenant rights, which may limit immediate rental upside or owner-occupancy options for that specific unit.
- Sub-optimal Basement Space
The basement storage area is sloped with uneven heights due to the downhill grade, potentially limiting its utility and indicating topographical challenges common with older hillside properties.
About 646-648 Madrid Street
Great Opportunity to own a 2 Unit Building in San Francisco! Both units have 2br, 1ba, spacious living room, generously sizes with lots of natural light in the kitchen which also has a dinette area,top floor is tenant occupied and subject to tenant right, lower level has 2 BD + additional room, 1 of the rooms is leased and can be delivered vacant at COE(whole lower level) Large Backyard and storage area downstairs in the basement(sloped down hill with uneven height) Close to shops, restaurants,transportation, playground and much more, Do not Miss out!
Property Details
Public Facts
- Property Type
- Duplex
- Year Built
- 1905
- Lot Size
- 2,496 Sq. Ft.
Interior
- Total Bedrooms
- 4
- Total Bathrooms
- -
Exterior & Parking
No exterior & parking available.
Utilities & Misc
- HOA Fee
- $0 / Month
Neighborhood Insights
San Francisco Unified Schools
Cleveland Elementary School
Grades K-5 • 0.3 mi
3/10
Monroe Elementary School
Grades K-5 • 0.5 mi
5/10
Guadalupe Elementary School
Grades K-5 • 0.6 mi
4/10
Sensitive Facilities
No sensitive facilities data found.
Neighborhood Comparison
| Feature | Subject | Average Home |
|---|---|---|
| Beds | 4.0 | 4.8 |
| Baths | 0.0 | 4.0 |
| Square foot | 1,400 | 3,171.882 |
| Lot Size | 2,496 | 2,678.029 |
| Price | $1.15M | $2.08M |
| Price per sq ft | $821 | $709 |
| Built year | 1905 | 1925 |
| HOA | $0 | $0 |
| Days on market | 41 | 66 |
Pricing History
Listed for Sale
Jul 30, 2026
$1,150,000
Initial Listing
Sold
Nov 21, 2017
$720,000
Public Record
Sold
Feb 29, 2012
$305,000
Public Record
Sold
Nov 30, 2006
$850,000
Public Record
Sold
Apr 29, 2005
$680,000
Public Record