
San Francisco, CA 94112
This Mixed-Use Duplex presents a High-Potential Investment Opportunity with a List Price of $999,000—positioned well below the $1,043,840 Fair Market Value by 4%. This valuation gap offers $44,840 in Instant Equity. Featuring a 2-bedroom residential unit and a flexible commercial space, the property has a Condition Rating of 4, indicating a need for cosmetic updates. With a private patio and proximity to top-rated schools like Lowell High, this is an ideal acquisition for Buy-and-Hold Investors or Owner-Occupants seeking live-work versatility.
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 5480 Mission Street Subject | $999,000* List Price | 2 | 0 | 2,500 | $418 | - |
A 53065308 Mission Street Active | $1,199,000 List Price | 0 | 0 | 2,610 | $459 | 0.1 mi |
* Subject property listed price vs sold prices of comps.
Property is moderate renovation needed.
Built in 1924, this century-old property is functional but significantly dated. While the description notes it is well-maintained, the interior photos show older carpeting and finishes likely from a renovation exceeding 20 years ago. There is no evidence of modern kitchen/bath updates or recent system (HVAC/Electric) overhauls, requiring cosmetic and minor repair work to meet modern standards.
Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
The property features a residential 2-bedroom unit alongside a flexible commercial space, offering a unique live-work opportunity or dual income streams for savvy investors.
Situated in a prime area with heavy foot traffic and proximity to public transportation, the property is perfectly positioned for a boutique business or creative studio to succeed.
Built in 1924, this century-old building may require significant capital expenditure for seismic retrofitting or updates to aging electrical and plumbing systems.
While some high-rated schools are accessible, several immediate neighborhood schools have very low ratings, which may limit the property's appeal to families with school-aged children.
Discover the possibilities with this well-maintained mixed-use duplex offering both residential and business opportunity in one prime location. The residential unit features a spacious 2 bedroom, 2 bathroom layout. Ideal for an owner-occupant or investor. The additional unit is perfect for office space, a boutique business, creative studio, or other ventures. Located in high-visability area with heavy foot traffic, nearby shops, restaurants, and convenient public transportation, this property is positioned for both lifestyle and success. Seller may carry back loan.
No exterior & parking available.
Grades K-5 • 0.2 mi
Grades K-5 • 0.4 mi
Grades K-5 • 0.6 mi
No sensitive facilities data found.
| Feature | Subject | Average Home |
|---|---|---|
| Beds | 2.0 | 0.0 |
| Baths | 0.0 | 0.0 |
| Square foot | 2,500 | - |
| Lot Size | 2,282 | - |
| Price | $999.0K | $2.06M |
| Price per sq ft | $400 | $729 |
| Built year | 1924 | 0 |
| HOA | $0 | $0 |
| Days on market | 56 | 62 |
May 27, 2026
$999,000
Initial Listing
Nov 30, 2022
$946,500
Public Record