2254 Union Street, San Francisco, CA 94123-3902, USA

Property CA
, , , , , , , , , , ,
1

Property Overview:

Incredible opportunity to own a trophy investment property on Union Street in the heart of Cow Hollow. This well-maintained, mixed-use building features ground floor commercial space, two residential flats above, and a detached one-bedroom cottage. The two full-floor flats each offer 2 bedrooms, 1 bathroom, high ceilings, in-unit laundry, hardwood floors, and views from the upper unit. A beautiful garden separates the main building from the cottage. The charming cottage includes an updated kitchen, bathroom, living room, and a full basement with laundry and spacious storage. The cottage will be delivered vacant—ideal as a pied-à-terre for an owner-user or as an attractive rental unit for investors.

Neighborhood Highlights:

  • Prime Union Street location in the highly desirable Cow Hollow district
  • Close to both residential and commercial corridors
  • Easy access to the Golden Gate Bridge, the Presidio, Fillmore Street, Chestnut Street
  • Surrounded by shops, restaurants, and grocery stores

Property Features:

  • Mixed-use building: Commercial space + two residential flats + detached cottage
  • Classic Edwardian details in residential flats
  • 2 bedrooms, 1 bathroom per flat
  • High ceilings and hardwood floors
  • In-unit laundry in each flat
  • Upper unit offers city views
  • Beautiful garden between main building and cottage
  • Cottage: 1 bedroom, updated kitchen & bath, living room, full basement with laundry and storage
  • Cottage delivered vacant—flexible for owner or rental use

Location Benefits:

  • Highly walkable to amenities and transit
  • Desirable Cow Hollow neighborhood
  • Convenient for commuters with quick access to major city destinations
  • Ideal for investors or owner-occupiers seeking a prime San Francisco address
2

Price and Status History

date type price
2024-11-20 Pending NaN
2024-12-28 For Sale 4260000
3

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.

4

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
5

Traffic Noise by Hour x Weekday

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

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 2 3 2
2 1 2 3 2 2 2 1
3 1 2 2 1 2 1 1
4 1 1 1 1 1 2 2
5 2 1 2 2 2 2 1
6 2 3 4 4 2 3 3
7 2 3 2 2 2 2 3
8 2 1 2 2 2 2 1
9 3 2 3 3 4 3 3
10 2 3 2 3 3 4 4
11 4 3 3 3 4 6 5
12 4 4 3 5 5 5 5
13 5 5 7 5 7 7 5
14 5 6 6 6 7 7 6
15 3 5 5 4 5 6 5
16 4 4 4 4 5 6 3
17 3 5 6 5 5 5 4
18 3 4 3 4 4 4 4
19 4 6 5 4 4 4 4
20 3 4 2 4 3 2 2
21 3 2 3 2 2 2 3
22 2 3 2 2 2 3 2
23 4 5 5 6 5 4 5