
San Francisco, CA 94117
This Mixed-Use Asset represents a High-Potential Investment Opportunity, listed at $2,000,000—positioned well below the $2,025,332 Fair Market Value by 1.25%. This valuation gap offers $25,332 in Instant Equity. With a Condition Rating of 4, the property offers significant value-add potential through modernization of the four residential units. Located in the vibrant Haight-Ashbury district near Top-Rated Schools like Deavila Elementary, this is a stable, income-generating acquisition ideal for Buy-and-Hold Investors or Owner-Occupants seeking a strategic urban foothold.
Property is moderate renovation needed.
The property was built in 1900 and the listing lacks mention of recent major renovations to the four residential units or building systems (HVAC/Electric). While the retail space is described as inviting, the residential components are likely dated and exceed the 20-year threshold for modern updates, typical for income-generating Victorian-era mixed-use buildings in this district.
Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
Situated in the heart of the iconic Haight-Ashbury district, the property benefits from high foot traffic and proximity to Golden Gate Park, ensuring consistent demand for both retail and residential spaces.
The combination of a street-level commercial space and four residential units provides a balanced investment portfolio with multiple revenue sources, reducing overall vacancy risk.
Originally constructed in 1900, the property may require significant capital expenditures for modern upgrades, seismic retrofitting, or general upkeep associated with century-old structures.
The residential component is restricted to 1-bedroom units, which may lead to higher tenant turnover and limits appeal to larger households or families seeking more space.
1786-1790 Haight Street is a well-located, mixed-use building in one of San Francisco's most vibrant and desirable areas. Located along the active Haight Street corridor, the property is surrounded by a variety of local restaurants, cafes, shops, and everyday amenities. The property is also close to Golden Gate Park, Buena Vista Park, and several major public transportation routes, making it easy to access nearby areas and other parts of the city. Its location provides a good balance of convenience, local businesses, and access to outdoor spaces. Built in 1900, the building offers approximately 5,340 square feet of building area on a 2,500 square-foot lot. The property features a street-level retail space currently occupied by a cafe and wine bar with a unique and inviting interior, along with four 1-bedroom/1-bath apartments, with two units on each upper floor. The basement is currently used by the owner for storage and will be delivered vacant at closing, providing additional space and flexibility for future use. The property is zoned Haight, and the Assessor's Parcel Number (APN) is 1229-013. This is a rare opportunity to own an income-generating property in San Francisco's popular Haight-Ashbury District, a vibrant neighborhood with strong tenant demand and attractive long-term investment potential.
No exterior & parking available.
Grades K-5 • 0.3 mi
Grades K-5 • 0.4 mi
Grades K-5 • 0.4 mi
No sensitive facilities data found.
| Feature | Subject | Average Home |
|---|---|---|
| Beds | 4.0 | 5.5 |
| Baths | 0.0 | 4.0 |
| Square foot | 5,340 | 4,754.5 |
| Lot Size | 2,500 | 1,647.5 |
| Price | $2.00M | $2.60M |
| Price per sq ft | $375 | $541 |
| Built year | 1900 | 1917 |
| HOA | $0 | $0 |
| Days on market | 37 | 116 |
Aug 3, 2026
$2,000,000
Initial Listing