Celebrating 10 years: fixed fees, full service, fast responses

Property search · The Consumer Protection Brokerage

Every listing shows your estimated rebate.

The green number on each home is what could come back to you: the buyer-broker fee (typically 2 to 3%) minus our flat $9,750. No other search shows you this, because no other brokerage gives it back.

At a glance

1786-1790 Haight Street, San Francisco, CA, 94117

$2,000,000·SFAR MLS #426158546

Estimated Arrivva buyer rebate$30,000 to $51,000

Every completed rebate is published: see all 249 closings.

Listing data from SFAR MLS. Listing courtesy of Ning H Ho of Marcus & Millichap | Agent Phone: (415) 625-2192. Rebate estimate calculated by Arrivva.

Save
Ask
Tour
Hide
Share
$2,000,000
12 Days On Site

1786-1790 Haight Street
San Francisco, CA 94117

For Sale|Mixed Use|Active
4
Beds
0
Total Baths
5,340
SqFt
$375
/SqFt
1900
Built
County:
San Francisco
Listing courtesy of Ning H Ho of Marcus & Millichap | Agent Phone: (415) 625-2192
Call Now: (408) 868-2620
Is this the listing for you? We can help make it yours.
(408) 868-2620
1786-1790 Haight Street1786-1790 Haight Street1786-1790 Haight Street1786-1790 Haight Street
Save
Ask
Tour
Hide
Share

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$2,000,000
Days On Site 
12 Days
Bedrooms 
4
Inside Area (SqFt) 
5,340 sqft
Total Baths 
N/A
Full Baths 
N/A
Partial Baths 
N/A
Lot Size 
0.0574 Acres
Year Built 
1900
MLS® Number 
426158546
Status 
Active
Property Tax 
N/A
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
2 weeks agoListing updated with changes from the MLS®
2 weeks agoListing first seen on site
General Features
Acres 
0.0574
Cross Street 
Shrader Street
Levels 
Three Or More
Property Sub Type 
Mixed Use
SqFt Total 
5340
Zoning 
HAIGHT
Interior Features
Furnished? 
Varies By Unit
Save
Ask
Tour
Hide
Share
Community Features
MLS Area 
SF District 5
Listing courtesy of Ning H Ho of Marcus & Millichap | Agent Phone: (415) 625-2192



Listing information is provided by Participants of the San Francisco Association of Realtors MLS. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Copyright 2026, San Francisco Association of Realtors MLS.
Last checked: 2026-09-10 05:26 AM UTC

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share

*Estimate only. Actual rebate may vary based on final price, lender requirements, MLS rules, and broker policies.

Questions about this listing

How much could a buyer get back on 1786-1790 Haight Street, San Francisco, CA, 94117?
Arrivva estimates a buyer rebate of $30,000 to $51,000 on this listing. The buyer-broker fee, typically 2 to 3% of the price, goes back to you minus Arrivva's flat $9,750 fee. Every completed rebate is published on the Arrivva results page. See every completed closing
Who is the listing brokerage for 1786-1790 Haight Street, San Francisco, CA, 94117?
Listing courtesy of Ning H Ho of Marcus & Millichap | Agent Phone: (415) 625-2192, per SFAR MLS listing #426158546. Arrivva is not the listing brokerage: Arrivva is a separate flat-fee brokerage that represents you as the buyer, with your interests first and no dual agency, ever. How Arrivva represents buyers
How do I schedule a tour of 1786-1790 Haight Street, San Francisco, CA, 94117?
Set up a quick chat with Arrivva by phone or video. The team confirms showing availability fast, tours the home with you, and walks you through offer strategy and the rebate math before you commit to anything. Set up a time to talk

Found a home you love?

Schedule a free consultation to lock in your rebate before you offer.

Calls and texts are answered by Amy, our AI assistant, who can answer questions and help you book.