REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.
In-PersonVirtual Tour

$ 7,600,000
Est. payment | /mo
6 Beds
4,110 SqFt
$ 7,600,000
Est. payment | /mo
6 Beds
4,110 SqFt
Key Details
Property Type Multi-Family
Sub Type Duplex
Listing Status Active
Purchase Type For Sale
Square Footage 4,110 sqft
Price per Sqft $1,849
MLS Listing ID ML82028562
Bedrooms 6
HOA Y/N No
Year Built 1950
Lot Size 1,500 Sqft
Acres 0.03
Property Sub-Type Duplex
Property Description
This unique corner property combines a highly coveted, commercially zoned space with two extensively remodeled residential units, 649 and 651 Francisco. The residential spaces seamlessly blend preserved original charm with luxurious modern amenities, including all-new windows, beautiful hardwood flooring, and in-unit washer/dryer hookups. Unit #649 (configured as an ADU) is a light-filled three-bedroom, two-bathroom unit featuring sky windows/skylights and a magnificent master en-suite leading to a private, 250 sq ft deck. Unit #651 offers two bedrooms, two bathrooms, a large kitchen/dining area, its own separate deck, and an easily convertible additional room for a potential third bedroom. Both units are rented for approx. 5k each. The ground-floor commercial space at 1095 Columbus Ave was formerly a cannabis dispensary (Cannabis 21) and is zoned for cannabis retail use, previously leased at a substantial $14,000 NNN per month. The building is positioned for a Fast-Track condo conversion (totaling three units: one commercial, one residential, one ADU), offering significant potential to maximize returns. Flexible Seller Financing is available to qualified buyers with a substantial down payment (40-50%). All three properties combined generate approx. 288k annually.
Location
State CA
County San Francisco
Zoning R2
Interior
Heating Other
Cooling Other
Fireplace No
Building
New Construction No
Schools
School District San Francisco Unified
Others
Tax ID 0050020

© 2026 BEAR, CCAR, bridgeMLS. This information is deemed reliable but not verified or guaranteed. This information is being provided by the Bay East MLS or Contra Costa MLS or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website.
Listed by Alex Sobieski • Redfin
Nearby Locations

GET MORE INFORMATION
We respect your privacy! Your information WiLL NOT BESHARED,SOLD, or REMTED to anyone, for any reasonoutside the course of normalreal ostate exchange,Bysubmitting, you agree to our Terms of Use and PrlvacyPolicy.
Follow Us






