1196 Quesada Avenue, San Francisco, CA 94124, San Francisco, 94124 - 9 bed, 3 bath
Loading property details...
1196 Quesada Avenue
San Francisco, CA 94124
ACTIVE
CONDITION: POOR
9Beds
3Baths
3,500Sq Ft
2,500Lot Size
Property Price
LIST PRICE$1,188,000
EST. MARKET VALUE
$1,388,000
SUMMARY
This High-Potential Investment Opportunity is a Residential Income Triplex listed at $1,388,000, which aligns with the current $1,388,000 Fair Market Value. Featuring a 3,500 sqft footprint and 9 bedrooms, this asset offers significant rental scale. While the property carries a Condition Rating of 5, indicating a need for comprehensive rehabilitation, the water and mountain views provide long-term value. This is a strategic acquisition for Buy-and-Hold Investors or Contractors prepared to address deferred maintenance and optimize this high-capacity income producer.
Estimated Market Value
$1,388,000
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 |
|---|---|---|---|---|---|---|
★ 1196 Quesada Avenue Subject | $1,188,000* List Price | 9 | 3 | 3,500 | $397 | - |
A 6246 3rd St Active | $1,390,000 List Price | 0 | 0 | 3,150 | $441 | 0.9 mi |
* Subject property listed price vs sold prices of comps.
Condition Analysis
See Full ReportOVERALL CONDITION SCORE
Poor
TeardownExcellent
Property is extensive renovation needed.
Built in 1919 and over 100 years old, the property is explicitly listed as needing repairs per inspection report and sold as-is. The age, lack of renovation history, and large-scale residential income use (9 beds/3 baths) indicate significant deferred maintenance and the need for a complete rehab of systems and interiors.
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).
- High Revenue Potential
As a 3,500 sqft triplex featuring 9 bedrooms, this property offers significant rental scale and is positioned as a high-capacity income producer in the San Francisco market.
- Scenic Water and Mountain Views
The property benefits from a sunny location just blocks from the bay, offering both water and mountain views that enhance its long-term desirability and tenant appeal.
CONSRISKS & DEFICIENCIES
- MLS Listing Discrepancy
Bedroom count discrepancy between mls listing and other public or private record. mls listing bedroom count = 9, other record bedroom count = 3.
- Deferred Maintenance
The property is sold in 'as-is' condition and requires repairs per the inspection report, indicating a need for immediate capital improvement and renovation budget.
- Tenant Encumbrances
The sale includes one to two existing tenants, which may complicate immediate renovation plans or rent stabilization strategies under San Francisco's strict tenant protection laws.
About 1196 Quesada Avenue
Sunny location a few blocks from the bay. In need of repairs per inspection report. Great income producer. Sold as-is with 1 to 2 tenants. One tenant will be moving out within 2 to 3 weeks.
Property Details
Public Facts
- Property Type
- Triplex
- Year Built
- 1919
- Lot Size
- 2,500 Sq. Ft.
Interior
- Total Bedrooms
- 9
- Total Bathrooms
- 3 (3 Full, 0 Half)
Exterior & Parking
No exterior & parking available.
Utilities & Misc
- HOA Fee
- $0 / Month
Neighborhood Insights
San Francisco Unified Schools
Carver (George Washington) Elementary School
Grades K-5 • 0.4 mi
2/10
Malcolm X Academy
Grades K-5 • 0.4 mi
4/10
Drew (Charles) College Preparatory Academy
Grades K-5 • 0.7 mi
1/10
Sensitive Facilities
No sensitive facilities data found.
Neighborhood Comparison
| Feature | Subject | Average Home |
|---|---|---|
| Beds | 9.0 | 4.8 |
| Baths | 3.0 | 4.0 |
| Square foot | 3,500 | 3,171.882 |
| Lot Size | 2,500 | 2,678.029 |
| Price | $1.19M | $2.08M |
| Price per sq ft | $339 | $709 |
| Built year | 1919 | 1925 |
| HOA | $0 | $0 |
| Days on market | 242 | 66 |
Pricing History
Listed for Sale
Jul 30, 2026
$1,188,000
$1,388,000
-14% Price Drop
Initial Listing
Price Change
Jan 10, 2026
$1,388,000
Initial Listing
Sold
Apr 3, 1998
$155,000
Public Record