Search
Mixed-Use Building with Retail
New
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 Market5

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 #01943903
Source: Cityrealestatesf
Added: Aug 28 Changed: Aug 31 Last Checked: Aug 30 at 8:25PM

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

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 = area × lease_rate × (100 − vacancy) / 100 × (1 − expense_ratio). Net Operating Income — what the owner takes home each year before mortgage payments and income tax. Effective rent (asking rent minus vacancy losses) minus operating costs (taxes, insurance, maintenance, management).
NOI / Yr
$173,374
Cap rate = NOI / list price × 100. Capitalization rate — annual return on a fully cash purchase, before financing. NOI divided by price. Higher means more income per dollar invested, but usually also more risk or older condition. 5–8% is typical for stabilized commercial property; double digits often signal distressed deals.
Cap Rate
8.67%
Suggested Prices Based on Cap Rates Cap rates vary significantly by property type, market, and asset quality. Typical U.S. stable-market ranges: Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+) Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand) Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically) Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher) Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk) Self-Storage — 5.5% to 7.5% Medical Office — 6.0% to 7.5% Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term Rules of thumb: Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%). Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C. Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI. Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
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 Vacancy — income lost from leasable area expected to sit empty during the year, subtracted from gross rent. EGI (Effective Gross Income) — gross rent minus vacancy losses, the realistic income before paying operating costs. OpEx (Operating Expenses) — recurring costs to operate the property (property tax, insurance, utilities, maintenance, management); excludes financing and capital improvements. NOI (Net Operating Income) — income a property generates after operating costs but before financing and taxes.
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 rates vary significantly by property type, market, and asset quality. Typical U.S. stable-market ranges: Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+) Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand) Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically) Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher) Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk) Self-Storage — 5.5% to 7.5% Medical Office — 6.0% to 7.5% Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term Rules of thumb: Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%). Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C. Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI. Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
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.

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
Rey
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.

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