2254-2258A, Union Street, San Francisco, CA 94123, USA


Property Overview:

Trophy mixed-use investment property in the heart of Cow Hollow on Union Street. The well-maintained building features ground floor retail/commercial space (leased to 12/1/2023 with 3% annual increases), two full-floor Edwardian flats above, and a detached 1-bedroom cottage at the rear of the lot.


Property Features:

  • Edwardian Flats (2 units above retail):

    • Classic period details: tall ceilings, hardwood floors, fireplaces, period moldings
    • Spacious, south-facing living rooms with French doors to balconies
    • Formal dining rooms
    • In-unit laundry with washer/dryer
    • 2 bedrooms, 1 bathroom per flat
    • Golden Gate views from top flat bedroom
    • Partial basement with storage, updated steam boiler, and 2 hot water heaters
    • Separate gas & electric meters
  • Detached Cottage:

    • Charming 1-bedroom with living room and formal dining room
    • Remodeled kitchen & bath
    • Full basement: laundry, storage, hot water heater, forced air furnace
    • Front porch facing a central courtyard/garden
    • Delivered vacant—ideal for owner-user or rental

Investment Highlights:

  • Ground floor retail:
    • Leased to 12/1/2023 with 3% annual rent increases
  • Multiple income streams: Commercial, residential flats, and cottage
  • Prime Cow Hollow location:
    • Steps to Union Street shops, restaurants, and grocery stores
    • Close to Fillmore Street, Chestnut Street, the Presidio, and Golden Gate Bridge
  • Excellent walkability and access to public transportation

Summary:

  • Well-maintained, mixed-use Edwardian building
  • 2 classic flats, ground floor retail, and detached 1-bedroom cottage
  • Separate utilities for all units
  • Beautiful central courtyard garden
  • Ideal for investors or owner-occupiers seeking a prime Cow Hollow asset with strong income potential and future upside.

Price and Status History

date type price
2017-06-23 For Sale 4000000
2017-07-01 For Sale 4500000
2018-03-07 For Sale 4295000
2018-04-20 Pending NaN
2018-05-04 Sold 4325000
2022-07-26 Pending NaN
2023-03-09 Off Market NaN
2024-09-04 For Sale 4095000
2024-10-24 For Sale 3995000
2024-11-22 Pending NaN

Superfund Enterprise Management System

SITE NAME ADDRESS FEDERAL FACILITY NPL STATUS NON-NPL STATUS CONTAMINANTS SEMS EPA ID DISTANCE (MILES)
PG&E GAS PLANT SAN FRANCISCO 502 1F STEINER BAY, Fillmore Street, San Francisco, CA 94123, USA N N NF 0 CAD981415656 0.25
PG&E GAS PLANT SAN FRANCISCO 502 1G BAY NORTHPOINT BUCHANAN, Laguna Street, San Francisco, CA 94123, USA N N NF 0 CAD981415714 0.50
GOLDEN GATE NATIONAL REC AREA BUILDING, 201 Fort Mason, San Francisco, CA 94123-1307, USA Y N OF 0 CA2141732030 0.72

Toxic Release Inventory

FACILITY NAME ADDRESS TOTAL FORMS LAST FORM YEAR RISK SCREENING FACILITY ID DISTANCE (MILES)
GOLDEN GATE NATIONAL RECREATION AREA 201 Fort Mason, San Francisco, CA 94123-1307, USA 4 2023 Yes 9412WGLDNG21FRT 0.72

Integrated Compliance Information System - Air

No data found within 1.0 miles for this property.

Flood Risk Info

fld_zone very high impact: up to 0.0001 miles high impact: up to 0.2 miles moderate impact: up to 0.5 miles low-moderate impact: up to 1.5 miles
A 0 0 0 0
AE 0 0 0 0
AH 0 0 0 0
VE 0 0 0 0

Flood Zone Type

code meaning
A 1% annual chance flood zone determined using approximate methods. No BFEs shown. Flood insurance and management standards apply.
AE 1% annual chance flood zone determined by detailed methods. BFEs shown. Insurance and floodplain management required.
AH Shallow flooding (ponding) zones with depths between 1-3 feet. BFEs shown. Insurance and management required.
VE Coastal 1% annual chance flood zone with wave action. BFEs shown. Insurance and management required.

Earthquake Risk Info

zone_name quad_name very high impact: up to 0.0001 miles high impact: up to 2.0 miles moderate impact: up to 10.0 miles
N/A N/A 0 0 0

Landslide Risk Info

lscat very high impact: up to 0.0001 miles high impact: up to 0.04 miles moderate impact: up to 0.1 miles low-moderate impact: up to 0.2 miles
8 0 0 0 0

Liquefaction Risk Info

Suscept very high impact: up to 0.0001 miles high impact: up to 0.05 miles moderate impact: up to 0.5 miles low-moderate impact: up to 1.0 miles
High 0 0 0 0
Very high 1 0 1 2

Wild fire Risk Info

haz_class very high impact: up to 0.0001 miles high impact: up to 0.5 miles moderate impact: up to 1.5 miles low-moderate impact: up to 3.0 miles
High 0 0 0 0
Very High 0 0 0 0

Traffic Noise by Hour x Weekday

hour_of_day Monday Tuesday Wednesday Thursday Friday Saturday Sunday
0 36 30 29 NaN 42 36 43
1 34 33 41 37 39 33 50
2 21 23 NaN 34 37 29 34
3 35 NaN 33 29 34 31 38
4 34 32 32 29 35 23 49
5 35 33 33 27 30 40 50
6 33 33 32 31 28 33 50
7 29 30 33 29 NaN 48 39
8 NaN 31 29 NaN 31 NaN 31
9 27 25 30 33 NaN 31 26
10 30 35 32 23 33 32 33
11 29 34 34 32 30 32 34
12 NaN 27 27 32 32 34 25
13 31 34 31 22 29 29 34
14 21 30 35 25 30 30 35
15 35 22 37 32 32 27 25
16 35 35 31 28 35 32 33
17 36 38 35 35 33 36 32
18 33 35 37 37 NaN 36 NaN
19 40 43 40 38 49 37 26
20 32 34 29 36 53 41 40
21 35 38 33 31 29 41 40
22 32 32 27 45 46 32 34
23 NaN 32 31 NaN 33 43 NaN

Airplane Noise by Hour x Weekday

hour_of_day Monday Tuesday Wednesday Thursday Friday Saturday Sunday
0 3 4 4 3 4 4 2
1 2 2 3 2 3 2 2
2 1 2 3 2 3 3 2
3 1 2 2 1 1 2 2
4 1 1 1 1 1 2 1
5 2 2 2 3 1 2 2
6 3 4 4 5 3 4 3
7 3 4 4 4 4 3 4
8 4 4 4 3 4 3 3
9 7 5 5 6 6 7 6
10 4 5 5 6 6 6 9
11 6 6 7 6 8 10 6
12 7 7 5 7 7 9 6
13 7 8 9 6 9 8 7
14 6 8 9 10 10 9 7
15 6 7 6 6 7 7 5
16 5 6 6 7 7 6 3
17 5 5 7 6 6 6 5
18 4 6 5 6 6 4 6
19 5 7 6 7 6 7 5
20 3 5 2 6 5 3 3
21 4 3 4 5 3 3 3
22 3 3 3 4 3 3 3
23 4 6 6 6 6 4 5