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

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

Property Overview:

This mixed-use Edwardian property in the heart of Cow Hollow features ground floor retail space, two residential flats, and a detached one-bedroom cottage. The retail store is leased until 12/1/2023 with 3% annual rent increases. The residential flats each include 2 bedrooms, 1 bathroom, high ceilings, hardwood floors, fireplaces, formal dining rooms, laundry facilities, and south-facing living rooms with French doors to balconies. The top flat offers Golden Gate views.

Neighborhood Highlights:

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

Property Features:

  • Detached Cottage:

    • 1 bedroom, living room, formal dining room, remodeled kitchen and bath.
    • Full basement with laundry, storage, hot water heater, and forced air furnace.
    • Separate gas and electric meters.
    • Delivered vacant, ideal for owner-use or as a rental unit.

  • Front Building:

    • Partial basement with storage, updated steam boiler, and 2 hot water heaters.
    • Classic Edwardian details throughout.

  • Outdoor Space:

    • Secluded central courtyard separating the front building and the cottage.

Investment Opportunity:

  • Trophy property with mixed-use potential.
  • Ideal for investors or owner-occupiers seeking a pied-à-terre or rental income.
2

Price and Status History

date type price
2017-06-23 For Sale 4000000
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
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.73

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.73

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 37 33 33 NaN 40 36 43
1 36 30 44 39 39 36 30
2 25 32 23 36 34 23 36
3 34 NaN 33 25 32 32 40
4 35 33 31 34 35 30 47
5 31 34 33 33 33 45 48
6 33 25 29 34 36 42 47
7 33 27 33 28 NaN 50 43
8 NaN 34 36 NaN 31 22 23
9 34 27 31 33 NaN 31 32
10 30 36 35 NaN 31 33 35
11 33 33 33 33 32 34 33
12 NaN 34 31 32 33 35 28
13 32 33 37 24 33 32 32
14 NaN 33 35 35 29 33 35
15 35 NaN 37 NaN 32 34 31
16 34 35 28 36 36 30 34
17 33 37 36 33 33 35 33
18 33 36 38 30 23 37 NaN
19 40 33 42 39 49 38 34
20 35 32 31 36 55 39 40
21 39 42 33 31 36 39 39
22 22 33 28 53 51 21 35
23 NaN 36 31 NaN 33 42 23
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 3
12 4 4 3 5 5 5 4
13 5 5 7 5 7 8 5
14 5 6 6 6 7 8 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