See all 74 photos
74 photos
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
Listed by Alex Sobieski • Redfin
$9,700,000
Est. payment /mo
6 Beds
6 Baths
4,110 SqFt
UPDATED:
Key Details
Property Type Multi-Family
Sub Type Duplex
Listing Status Active
Purchase Type For Sale
Square Footage 4,110 sqft
Price per Sqft $2,360
MLS Listing ID ML82028562
Bedrooms 6
Full Baths 6
Year Built 1950
Lot Size 1,500 Sqft
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 $20,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. 360k annually.
Location
State CA
County San Francisco
Area 8 - North Beach
Zoning R2
Interior
Heating Other
Cooling Other
Exterior
Parking Features On Street
Utilities Available Public Utilities
Roof Type Other
Building
Foundation Other
Sewer Sewer - Public
Water Public
Others
Tax ID 0050020
Security Features Other
Horse Property No
Special Listing Condition Not Applicable
Read Less Info
Copyright 2026 MLSListings Inc. All rights reserved.
GET MORE INFORMATION
Josh Yoo
Broker Associate | License ID: 02024903
Broker Associate License ID: 02024903