
San Francisco, CA 94123
This Prime Mixed-Use Asset is listed at $2,800,000, positioned accurately at its $2,800,000 Fair Market Value. Featuring a Condition Rating of 3, the property offers turnkey residential units with modern finishes and high-end appliances. Located in the prestigious Cow Hollow neighborhood, it provides access to Top-Rated Schools including Lilienthal Elementary, Lowell High, and Galileo High. The significant development potential of the large, flat rear yard offers a rare pathway for value-add expansion via ADUs. This is an exceptional opportunity for Buy-and-Hold Investors or Owner-Occupants seeking a high-upside legacy property.
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 1964-1966 Union Street Subject | $2,800,000* List Price | 3 | 1 | 3,716 | $753 | - |
A 2272-2276 Union Street Active | $2,495,000 List Price | 3 | 4 | 2,800 | $891 | 0.3 mi |
* Subject property listed price vs sold prices of comps.
Property is move-in ready.
This 1924 property is in move-in ready, turnkey condition following recent updates to the residential units. The interiors feature modern kitchens equipped with high-end stainless steel appliances and stone countertops, updated bathrooms with contemporary fixtures and tiling, and well-maintained hardwood flooring throughout. While the building's core structure is historic, the living spaces have been renovated to meet modern quality standards with recessed lighting and updated finishes, requiring no immediate renovation.
Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
Situated in one of San Francisco's most prestigious and supply-constrained neighborhoods, this property ensures high tenant demand and long-term asset appreciation.
The large, flat, vacant rear yard is a rare find in this area, offering a clear pathway to unlock value through ADU expansion or additional residential units.
As a multi-family asset in San Francisco, the ability to realize 'upside in rents' is subject to strict local rent control ordinances and tenant protections.
Built in 1924, the property may face higher long-term maintenance costs or require future seismic retrofitting typical of century-old San Francisco structures.
Positioned in the heart of San Francisco's prestigious Cow Hollow neighborhood, 1964 Union Street is a prime multi-family investment with both immediate income strength and compelling long-term upside. The property features well-maintained, recently updated residential units, many with modern finishes. While the building is turnkey from an operational standpoint, there remains significant upside in rents, offering investors the ability to capture stronger cash flow as leases roll. Beyond the stabilized income stream, 1964 Union Street includes a large, flat, vacant rear yard that presents an exceptional development opportunity. Whether for additional units, an ADU expansion, or enhanced common-area amenities, this underutilized space offers investors a pathway to unlock further value in one of the city's most supply-constrained neighborhoods.
No exterior & parking available.
Grades K-5 • 0.4 mi
Grades K-5 • 0.8 mi
Grades K-5 • 1.5 mi
No sensitive facilities data found.
| Feature | Subject | Average Home | Neighborhood Ranking (50 Listings) |
|---|---|---|---|
| Beds | - | - | 0% |
| Baths | - | - | 0% |
| Square foot | - | - | 0% |
| Lot Size | - | - | 0% |
| Price | - | - | 0% |
| Price per sq ft | - | - | 0% |
| Built year | 1924 | - | 0% |
| HOA | $0 | $0 | 0% |
| Days on market | - | - | 0% |
Sep 8, 2025
$2,800,000
Initial Listing
Jan 29, 2016
$2,250,000
Public Record
Sep 18, 2015
$2,250,000
Public Record