REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your advisor 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
$ 9,700,000
Est. payment | /mo
6 Beds
6 Baths
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 $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. The ground-floor commercial space at 1095 Columbus Ave is an extremely rare and valuable asset. It was formerly a cannabis dispensary (Cannabis 21) and is one of only three lots on Columbus Avenue 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 and unlock immediate profit. Flexible Seller Financing is available to qualified buyers with a substantial down payment (40-50%).
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
© 2025 MLSListings Inc. All rights reserved.
"My job is to find and attract mastery-based agents to the office, protect the culture, and make sure everyone is happy! "
GET MORE INFORMATION