480 Mission Bay Boulevard North UNIT 420, San Francisco, CA 94158-2178, USA


Property Overview:

Madrone 420 is a rare corner 2BR/2BA condo offering park-side tranquility and city vistas. It features one of the largest 2-bedroom floorplans, spanning 1,357 sq. ft. with chic hardwood floors, brand new bedroom carpets, and abundant natural light. The gourmet kitchen includes an oversized island and stainless steel appliances. Additional conveniences include central heating/AC, in-unit laundry, and parking.


Amenities:

  • 24-hour security.
  • Pool, gym, and sauna.
  • BBQ area, club room, and cinema.
  • Meeting spaces for work or gatherings.

Location Benefits:

  • Situated blocks from Oracle Park, UCSF Medical Center, and the San Francisco Bay.
  • Combines serenity with urban excitement, perfect for modern living.

Price and Status History

date type price
2024-05-10 For Sale 1549000
2024-05-21 Pending NaN
2024-05-22 Pending 1549000
2024-06-11 Sold 1549000

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
BAE SYSTEMS SAN FRANCISCO SHIP REPAIR FOOT OF, 20th Street, San Francisco, CA 94107, USA 75 2015 Yes 94107STHWSFOOTO 0.83
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)
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
WEST BAY SEAFOOD COMPANY, INC B Street PIER 45, SHED B-11, San Francisco, CA 99999, USA OPR: Operating 0.47
CASTANELLA SEAFOODS, INC B Street PIER 45, SHED B - 8, San Francisco, CA 941192484, USA OPR: Operating 0.47
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

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

Traffic Noise by Hour x Weekday

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

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 7 7
10 6 7 5 7 7 7 9
11 8 8 7 8 10 12 7
12 9 8 7 7 9 8 8
13 10 9 10 9 10 11 9
14 7 9 11 10 12 10 8
15 8 7 7 8 7 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 4 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