2157 15th Street, San Francisco, CA 94114-1212, USA


Property Overview:

The Townhome Collection at 2238 Market offers two exceptional homes in the vibrant Castro/Duboce Triangle neighborhood. Designed by renowned designer Alan Tse, these homes feature spacious floor plans, culinary-inspired kitchens, and highly-appointed finishes. Each home includes 3 bedrooms, 3.5 bathrooms, and approximately 2,977 sq. ft. of living space.


Neighborhood Highlights:

  • Located in the Castro/Duboce Triangle, a vibrant and sought-after area.
  • Quiet, tree-lined 15th Street provides a serene setting with private entrances for each home.
  • Close proximity to shops, restaurants, and public transportation.

Property Features:

  • Signature Interiors: Designed by Alan Tse, showcasing modern elegance and luxury.
  • Outdoor Living:
    • Rooftop patios with iconic views of Sutro Tower, the Bay, and the Transamerica Building.
    • Includes gas grills for a unique indoor-outdoor living experience.
    • Additional open-air terraces and organic spaces.
  • Private Entrances: Each home has its own private entrance off 15th Street.
  • Elevator Access: Convenient access to living areas for added privacy and ease.
  • Spacious Layout: Open floor plans with culinary-inspired kitchens and high-end finishes.

Location Benefits:

  • Convenience: Easy access to the best of city living while maintaining a sense of privacy and tranquility.
  • Perfect for those seeking luxury, space, and a rare indoor-outdoor lifestyle in the city.

Price and Status History

date type price
2016-04-01 Sold 8500000
2023-05-31 For Sale 3995000
2023-09-15 Sold 3967800
2023-10-17 For Sale 4295000
2023-10-18 For Sale 4295000
2024-03-01 For Sale 3995000
2024-07-21 For Sale 3595000
2024-10-17 For Sale 3772500
2024-11-15 Pending NaN
2024-12-06 Sold 3150000

Superfund Enterprise Management System

SITE NAME ADDRESS FEDERAL FACILITY NPL STATUS NON-NPL STATUS CONTAMINANTS SEMS EPA ID DISTANCE (MILES)
UNITED STATES MINT AT SAN FRANCISCO 155 Hermann Street, San Francisco, CA 94102-6130, USA Y N NF 0 CA7200090606 0.41
FORTUNA DUMP OFF U.S. 101 North 4 MI E OF FRWY, Fortuna, CA 95540, USA N N NF 0 CAD980637615 1.00
CAMP ROBERTS NAT GUARD UNIT U.S. 101 12 MI N OF, Paso Robles, CA 93446, USA Y N FS 0 CA6211820760 1.00

Toxic Release Inventory

FACILITY NAME ADDRESS TOTAL FORMS LAST FORM YEAR RISK SCREENING FACILITY ID DISTANCE (MILES)
SERVICE ENG CO PIER 38, San Francisco, CA 941072186, USA 5 1989 N/A 94107SRVCNPIER3 0.95

Integrated Compliance Information System - Air

PLANT NAME ADDRESS OPERATING STATUS DISTANCE (MILES)
DRY CLEAN EXPRESS 900 Oak Street, San Francisco, CA 94117-2332, USA OPR: Operating 0.56
SAM’S APPLIANCES 569 Valencia Street, San Francisco, CA 94110-1114, USA OPR: Operating 0.60
JAPAN AUTO 601 Valencia Street, San Francisco, CA 94110-1125, USA OPR: Operating 0.61
KING’S REFRIGERATION 659 Valencia Street, San Francisco, CA 94110-1150, USA OPR: Operating 0.64
F LOFRANO & SON INC 3355 17th Street, San Francisco, CA 94110-1207, USA OPR: Operating 0.66
CHERIN’S APPLIANCES 727 Valencia Street, San Francisco, CA 94110-1734, USA OPR: Operating 0.68
VALENCIA SHELL 899 Valencia Street, San Francisco, CA 94110-1736, USA OPR: Operating 0.78
GRAND STAR CLEANERS 1422 Haight Street, San Francisco, CA 94117-2911, USA CLS: Permanently Closed 0.81
DOUBLE RAINBOW 275 South Van Ness Avenue, San Francisco, CA 94103-3733, USA OPR: Operating 0.84
PLANNERY SEAFOOD PIER 45, San Francisco, CA 99999, USA OPR: Operating 0.95

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
AO 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.
AO Shallow flooding (sheet flow) zones with depths 1-3 feet. BFEs or average depths shown. High-velocity areas may exist.
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
San Andreas - Peninsula San Francisco South 0 0 1

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 1 1
Very high 0 0 1 0

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

Traffic Noise by Hour x Weekday

hour_of_day Monday Tuesday Wednesday Thursday Friday Saturday Sunday
0 45 44 46 47 49 49 47
1 45 44 48 49 48 48 46
2 48 45 44 47 46 50 48
3 46 44 44 45 NaN 48 49
4 46 46 49 44 47 48 46
5 43 41 43 45 45 47 48
6 45 45 44 43 49 46 44
7 41 41 44 43 41 47 47
8 43 43 42 44 49 45 46
9 44 41 44 43 45 44 45
10 43 44 42 42 43 43 44
11 43 41 40 41 42 44 44
12 44 42 45 43 43 44 44
13 41 44 44 47 44 41 46
14 45 42 45 45 44 46 44
15 45 44 42 48 44 49 44
16 47 42 46 43 47 45 45
17 43 47 46 46 44 45 47
18 45 46 45 43 49 46 44
19 47 48 46 45 48 48 46
20 44 43 48 48 45 47 46
21 45 47 48 43 46 47 47
22 45 46 45 45 46 49 45
23 47 46 46 48 45 46 45

Airplane Noise by Hour x Weekday

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