
San Francisco, CA 94123
Analysis of 1784-1788 Union Street, San Francisco, CA 94123 is currently available with a list price of $2,595,000. The property maintains a Poor Condition Rating (30/100), indicating the property requires renovation and updates to maximize its market potential. This presents opportunities for value-add investors. Located in a high-demand neighborhood within the San Francisco Unified School District, this asset is categorized as a low-risk, high-reward acquisition suitable for Experienced Investors and Fix-and-Flip Specialists.
Property is extensive renovation needed.
Built in 1902, this 120+ year old property is explicitly described as needing renovations. The interior images show dated windows, worn hardwood flooring, and aged trim, suggesting that the kitchens, bathrooms, and core systems likely require a full rehab to reach modern standards.
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 on the prestigious Union Street corridor in Cow Hollow, this property benefits from high foot traffic for the commercial space and a premier residential address with a 94123 zip code.
The vacant top-floor unit offers a major renovation opportunity to capture a projected $7,500 monthly rent, allowing an investor to significantly increase the building's cap rate and equity.
The requirement for court confirmation adds a layer of procedural complexity and potential timeline delays that may deter buyers looking for a standard, quick transaction.
The middle unit is occupied by a protected tenant at a fixed rent, which limits the owner's ability to achieve market-rate returns or gain full possession of the building.
Property subject to court confirmation. 3 unit building, top floor vacant unit, renovations needed, projected rental value $7500, middle unit, tenant occupied, current $3,875. protected tenant. Lower unit, commercial unit, $4,000, on month to month lease.
No exterior & parking available.
Grades K-5 • 0.5 mi
Grades K-5 • 0.9 mi
Grades K-5 • 1.4 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 | 1902 | - | 0% |
| HOA | $0 | $0 | 0% |
| Days on market | - | - | 0% |
May 2, 2026
$2,595,000
Initial Listing
Oct 31, 1990
$457,500
Public Record
Dec 22, 1988
$437,500
Public Record