1784-1788 Union Street, San Francisco, CA 94123, San Francisco, 94123 - 0 bed, 0 bath
Loading property details...
1784-1788 Union Street
San Francisco, CA 94123
ACTIVE
CONDITION: POOR
0Beds
0Baths
4,950Sq Ft
2,126Lot Size
Property Price
LIST PRICE$2,310,500
SUMMARY
Analysis of 1784-1788 Union Street, San Francisco, CA 94123 is currently available with a list price of $2,310,500. 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.
Condition Analysis
See Full ReportOVERALL CONDITION SCORE
Poor
TeardownExcellent
Property is extensive renovation needed.
Built in 1902, the property explicitly requires renovations according to the listing description. Visual evidence shows extremely dated bathrooms (likely 50+ years old), significantly worn hardwood floors, and outdated wall-mounted heating units, indicating the need for a comprehensive rehab rather than minor repairs.
PROSSTRENGTHS & OPPORTUNITIES
- Great Schools
Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
- Prime Mixed-Use Location
Situated on the prestigious Union Street corridor in Cow Hollow, this property offers a high-visibility commercial space and residential units in one of San Francisco's most sought-after districts.
- Significant Value-Add Potential
The vacant top-floor unit provides a rare opportunity for a full modern renovation, allowing an investor to capture a projected market rent of $7,500 per month.
CONSRISKS & DEFICIENCIES
- Complex Sale Process
The property is subject to court confirmation, which typically involves a more rigid and prolonged closing timeline compared to standard market transactions.
- Protected Tenant Limitations
The middle unit is occupied by a protected tenant at a below-market rate, which limits immediate cash flow growth and restricts future occupancy options for that unit.
About 1784-1788 Union Street
Court Confirmation: Sale is subject to court confirmation and possible overbid. An offer of $2,200,000 has been accepted, subject to court confirmation. The minimum first overbid is $2,310,500. Court confirmation hearing is scheduled for September 8, 2026 at 9:00 AM at San Francisco Superior Court, 400 McAllister Street, Department 204. Prospective overbidders should independently verify the minimum overbid amount, deposit requirements, hearing information, and all court procedures prior to the hearing. All terms are subject to court approval.
Property Details
Public Facts
- Property Type
- Mixed Use
- Year Built
- 1902
- Lot Size
- 2,126 Sq. Ft.
Interior
- Total Bedrooms
- 0
- Total Bathrooms
- -
Exterior & Parking
No exterior & parking available.
Utilities & Misc
- HOA Fee
- $0 / Month
Neighborhood Insights
San Francisco Unified Schools
San Francisco Public Montessori School
Grades K-5 • 0.5 mi
6/10
Cobb (William L.) Elementary School
Grades K-5 • 0.9 mi
2/10
Chinese Education Center
Grades K-5 • 1.4 mi
0/10
Sensitive Facilities
No sensitive facilities data found.
Neighborhood Comparison
| Feature | Subject | Average Home |
|---|---|---|
| Beds | 0.0 | 5.5 |
| Baths | 0.0 | 4.0 |
| Square foot | 4,950 | 4,754.5 |
| Lot Size | 2,126 | 1,647.5 |
| Price | $2.31M | $2.60M |
| Price per sq ft | $467 | $541 |
| Built year | 1902 | 1917 |
| HOA | $0 | $0 |
| Days on market | 130 | 116 |
Pricing History
Listed for Sale
Aug 21, 2026
$2,310,500
$2,595,000
-11% Price Drop
Initial Listing
Price Change
May 2, 2026
$2,595,000
Initial Listing
Sold
Oct 31, 1990
$457,500
Public Record
Sold
Dec 22, 1988
$437,500
Public Record