Search
Mixed-Use Building with Retail
For Sale
$2,000,000

1786-1790 Haight Street, San Francisco, CA 94117

Street-level café and wine bar anchors four one-bedroom apartments above.

Property Size5,340 SF
Lot Size0.06 Acres
Price / SF$374.53
Days on Market50

Property Features for 1786-1790 Haight Street

General Information

Standard status Active
Size 5,340 SF
Lot size 0.06 Acres
Property subtype Mixed Use
Zoning Haight

Building Details

Building Size 5,340 SF
Year Built 1900
Buildings 1
Stories 3
Tenancy Multi
Listing Agency: Marcus & Millichap
Listed By: Ning H Ho · License #(S):CA:01943903
Source: Cityrealestatesf
Added: Aug 28 Changed: Oct 2 Last Checked: Oct 15 at 4:34AM

Displayed information is deemed reliable but is not guaranteed and should be independently verified. All listing content including descriptions, pricing, images are the copyrighted material of Marcus & Millichap

Rey
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.

Investment Insights

Based on property information with market context.

Positioned at 1786-1790 Haight Street, this mixed-use property combines a commercial storefront with residential units in a building constructed in 1900. The approximately 5,340-square-foot building occupies a 2,500-square-foot lot and includes a street-level café and wine bar with an established interior, along with four one-bedroom, one-bath apartments arranged two per upper floor.

A basement area is currently used for owner storage and is expected to be vacant at closing, adding flexible space within the property. The building is located along Haight Street in San Francisco, near restaurants, cafés, shops, daily amenities, Golden Gate Park, Buena Vista Park, and multiple public transportation routes. The property is zoned Haight and identified by APN 1229-013.

Key Highlights

  • Approximately 5,340 square feet on a 2,500 square‑foot lot
  • Street‑level retail space occupied by a café and wine bar
  • Four 1‑bedroom/1‑bath apartments, with two units on each upper floor

Financial Insights

Estimated NOI and Cap Rate

NOI / Yr
$173,374
Cap Rate
8.67%
Suggested Prices Based on Cap Rates
Cap Rate 5%
$3,467,480 $3.5M
Cap Rate 7%
$2,476,771 $2.5M
Cap Rate 9%
$1,926,378 $1.9M
Market Conditions
NOI Build-Up for 5,340 SF
Gross rent
$336.4K $63.00/SF
− Vacancy
−$21.2K −$3.97/SF
EGI
$315.2K $59.03/SF
− OpEx
−$141.9K −$26.56/SF
NOI
$173.4K $32.47/SF
Area
San Francisco, CA
Vacancy
6.30%
Lease Rate
$63.00 /SF/Yr
Expense Ratio
45.00%
Simulate Cap Rate and NOI
Suggested Prices Based on Cap Rates
Cap Rate 5%
$3,467,480
Cap Rate 7%
$2,476,771
Cap Rate 9%
$1,926,378

Alternative Uses

Best Use
Retail
$24.34M
$21.30M – $28.40M (±1% cap)
NOI $1,704,136 @ 7.0% cap · market cap 85.21%
Second Best
Multifamily LT 5
$2.71M
$2.37M – $3.16M (±1% cap)
NOI $189,781 @ 7.0% cap · market cap 9.49%
Theoretical Best
Specialty Retail
$26.08M
$22.82M – $30.43M (±1% cap)
NOI $1,825,859 @ 7.0% cap · market cap 91.29%
Zoning and permitted uses should be independently verified with authorities. How Realmo checks its estimates

Property Analytics

Current Use

Quadplexes

Suggested Use

Top Pick Law Firm Real Estate Agency HVAC Service Kitchen & Bath Showroom Barber Shop (Bike/Boat/Book/etc) Store

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Lease Details

Multi-tenant
Tenancy

Location Intelligence

Trade Area within ½ mile

6,159
Businesses Nearby

Demographics for 94117, CA

38,451
Population
19,709
Households
2
Avg Household Size
36
Median Age
78%
College-Educated
96%
High-School Grad
1.3 sq mi
ZIP Area
29,578
Density / Sq Mi
$175,096
Median Household Income
$106,542
Median Earnings
$2,786
Median Rent
$1,641,400
Median Home Value

Market

Vacancy Rate% for Multifamily in West region

7% 2022
7.8% 2023
8.6% 2024
8.6% 2025

Frequently Asked Questions

What type of property is this?
Mixed-use property - Street-level café and wine bar anchors four one-bedroom apartments above.
Where is this mixed-use property located?
The property is located at 1786-1790 Haight Street San Francisco, CA.
What is the asking price?
The asking price for this property is $2,000,000.
What are key features of this property?
This property features: Approximately 5,340 square feet on a 2,500 square‑foot lot; Street‑level retail space occupied by a café and wine bar; Four 1‑bedroom/1‑bath apartments, with two units on each upper floor
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message
Why this one?
Saved
Reason not saved — we won't ask again