480 Mission Bay Boulevard North UNIT 318, San Francisco, CA 94158-2177, USA

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

Property Overview:

This is a luxurious 2BD/2BA condo at The Madrone, spanning approximately 1,357 sq. ft.. The home features in-unit washer/dryer, an exclusive covered balcony, 1-car parking, and bonus storage. The south and west-facing corner unit boasts floor-to-ceiling windows with stunning views of Twin Peaks, Sutro Tower, and lush greenery from the park below.

Interior Features:

  • Open kitchen with sleek European-style cabinetry, tiled backsplash, Ceasarstone countertops, and stainless steel Bosch appliances.
  • Built-in Thermador refrigerator for a modern touch.
  • Bright and airy layout, perfect for entertaining.

Building Amenities:

  • Attended lobbies for convenience and security.
  • Heated outdoor pool, spa, and sauna for relaxation.
  • BBQ/dining areas for outdoor gatherings.
  • State-of-the-art fitness center to stay active.
  • Theater and community lounge/game room for entertainment.

Location Benefits:

  • Prime location with easy access to parks, public transit, and major highways.
  • Close to restaurants, entertainment venues, and iconic spots like Chase Center and Oracle Park.
  • Perfect for enjoying live sports and city life.

Summary:

This condo offers luxury living at its finest, combining modern design, premium amenities, and a vibrant location.

2

Price and Status History

date type price
2025-01-09 For Sale NaN
2025-01-14 For Sale 1558444
3

Superfund Enterprise Management System

SITE NAME ADDRESS FEDERAL FACILITY NPL STATUS NON-NPL STATUS CONTAMINANTS SEMS EPA ID DISTANCE (MILES)
H & H SHIP SERVICE 220 China Basin Street, San Francisco, CA 94107, USA N N NF 0 CAD004771168 0.20
PG&E GAS PLANT SAN FRANCISCO 502 1D KING NR 3rd Street, San Francisco, CA 94107, USA N N NF 0 CAD981415532 0.23
PG&E GAS PLANT SAN FRANCISCO 502 1E 8TH & Channel Street, San Francisco, CA 94103, USA N N NF 0 CAD981415599 0.39
C & M PLATING WORKS 598 6th Street, San Francisco, CA 94103, USA N N DR 0 CAD009204736 0.74
SOUTHWEST MARINE & Illinois Street, San Francisco, CA 94107, USA N N NF 0 CAD981453194 0.76
CONSOLIDATED IRON & METAL 634 Townsend Street, San Francisco, CA 94103, USA N N NF 0 CAD980884969 0.78
UNITED AMERICAN METALS CORP OF CALIFORNIA 785 Bryant Street, San Francisco, CA 94107-1014, USA N N RR 0 CAN000909448 0.80
ELECTRIC SMELTING CO. 91 Federal Street, San Francisco, CA 94107, USA N N RR 0 CAN000909432 0.80
PG&E GAS PLANT SAN FRANCISCO 502 1B KING &, 2nd Street, San Francisco, CA 94107, USA N N NF 0 CAD981415417 0.84
FINN, JOHN, METAL WORKS 384 2nd Street, San Francisco, CA 94107, USA N N RR 0 CAN000908410 0.95

Toxic Release Inventory

FACILITY NAME ADDRESS TOTAL FORMS LAST FORM YEAR RISK SCREENING FACILITY ID DISTANCE (MILES)
CONTINENTAL MARITIME OF S F INC Pier 50, San Francisco, CA 94107, USA 4 1988 N/A 94107CNTNNPIER5 0.26
CEMEX SAN FRANCISCO (M) 420 Mariposa Street, San Francisco, CA 94107-2513, USA 5 2006 N/A 94107RMCPC42MAR 0.48
GLIDDEN CO 1000 16th Street, San Francisco, CA 94107-2432, USA 73 1995 N/A 94107THGLD10001 0.58
WILLIAMS LITHOGRAPH CO 534 4th Street, San Francisco, CA 94107-1621, USA 7 1991 N/A 94107WLLMS534FO 0.71
GENON POTRERO LLC 1201-A Illinois Street, San Francisco, CA 94107-3106, USA 19 2010 N/A 94107MRNTP1201A 0.99

Integrated Compliance Information System - Air

PLANT NAME ADDRESS OPERATING STATUS DISTANCE (MILES)
CASTANELLA SEAFOODS, INC B Street PIER 45, SHED B - 8, San Francisco, CA 941192484, USA OPR: Operating 0.47
WEST BAY SEAFOOD COMPANY, INC B Street PIER 45, SHED B-11, San Francisco, CA 99999, USA OPR: Operating 0.47
ALBER SEAFOODS PIER 45_SHED, B Street B-4, San Francisco, CA 99999, USA OPR: Operating 0.47
GAITO FISHERIES B Street PIER 45, SHED B - 8, San Francisco, CA 99999, USA OPR: Operating 0.47
ALL SHORES SEAFOOD B Street PIER 45, SHED B-8, San Francisco, CA 99999, USA OPR: Operating 0.47
PORT OF SAN FRANCISCO FOOT OF, 20th Street, San Francisco, CA 94107, USA OPR: Operating 0.83
CIAO BELLA GELATO 685 Harrison Street, San Francisco, CA 94107-1312, USA OPR: Operating 0.89
MIRANT POTRERO, LLC 1201 Illinois Street, San Francisco, CA 94107-3106, USA CLS: Permanently Closed 0.99
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
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
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 2 1

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
5

Traffic Noise by Hour x Weekday

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

Airplane Noise by Hour x Weekday

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