718 Long Bridge Street Unit 302, San Francisco, CA 94158-2448, USA


Property Overview:

The Arden is a luxury condo located in the vibrant Mission Bay district of San Francisco. This 2-bedroom, 2-bathroom + den unit offers a spacious floor plan with designer details and modern finishes. The home includes a chef’s kitchen, patio with park views, in-unit laundry, and a premium parking space with EV charger.


Neighborhood Highlights:

  • Prime Location:

    • Walking distance to Warriors Chase Center, AT&T Park, groceries, cafes, and trendy retail shops.
    • Easy access to public transit and highways.
  • Family-Friendly:

    • Across the street from a pet and children’s park.
    • Nearby construction of a Pre-K through 5th-grade elementary school.
  • Vibrant Community:

    • Located in one of San Francisco’s fastest-growing neighborhoods.

Property Features:

  • Interior Highlights:

    • Floor-to-ceiling windows for abundant natural light.
    • Chef’s kitchen with Caesarstone counters, mosaic tile backsplash, and Thermador appliances.
    • Den: Enclosed space ideal for an office or third bedroom alternative.
    • Primary bedroom: Spacious with two custom closets, large bathroom, separate shower, and soaking tub.
    • Guest bedroom: Located on the opposite end for privacy.
  • Outdoor Space:

    • Generous tiled terrace and patio with park views.
  • Additional Features:

    • In-unit vented laundry.
    • Storage space and premium parking with EV charger.

Luxury Amenities:

  • 24/7 doorman and designer lobbies.
  • 75’ lap pool and spa.
  • Double-height fitness studio and a new second gym.
  • Expansive outdoor deck with city views.
  • Social lounge with an entertaining kitchen and billiards.
  • BBQ area and more.

Location Benefits:

  • Commuter-friendly: Close to public transit and highways.
  • Perfect for urban living with access to parks, entertainment, and shopping.

Price and Status History

date type price
2018-05-23 For Sale 1460000
2018-05-31 For Sale NaN
2018-06-09 Pending NaN
2018-06-12 For Sale NaN
2018-07-17 For Sale 1429950
2018-08-13 For Sale 1395000
2018-08-25 Pending NaN
2018-09-20 Sold 1117500
2022-09-06 For Sale NaN
2023-05-31 For Sale NaN
2023-07-17 For Sale NaN
2024-09-19 Sold 1390000
2024-10-01 For Sale 1550000
2024-10-17 For Sale 1550000
2024-11-16 Pending NaN

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 1E 8TH & Channel Street, San Francisco, CA 94103, USA N N NF 0 CAD981415599 0.07
H & H SHIP SERVICE 220 China Basin Street, San Francisco, CA 94107, USA N N NF 0 CAD004771168 0.12
PG&E GAS PLANT SAN FRANCISCO 502 1D KING NR 3rd Street, San Francisco, CA 94107, USA N N NF 0 CAD981415532 0.34
CONSOLIDATED IRON & METAL 634 Townsend Street, San Francisco, CA 94103, USA N N NF 0 CAD980884969 0.45
C & M PLATING WORKS 598 6th Street, San Francisco, CA 94103, USA N N DR 0 CAD009204736 0.45
UNITED AMERICAN METALS CORP OF CALIFORNIA 785 Bryant Street, San Francisco, CA 94107-1014, USA N N RR 0 CAN000909448 0.53
GAMLEN CHEMICAL CO 195 San Bruno Avenue, San Francisco, CA 94103, USA N N NF 0 CAD982358491 0.68
PG&E GAS PLANT SAN FRANCISCO 502 1K STEVENSON BET 5TH &, 6th Street, San Francisco, CA 94103, USA N N NF 0 CAD981415110 0.79
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.81

Toxic Release Inventory

FACILITY NAME ADDRESS TOTAL FORMS LAST FORM YEAR RISK SCREENING FACILITY ID DISTANCE (MILES)
GLIDDEN CO 1000 16th Street, San Francisco, CA 94107-2432, USA 73 1995 N/A 94107THGLD10001 0.36
CONTINENTAL MARITIME OF S F INC Pier 50, San Francisco, CA 94107, USA 4 1988 N/A 94107CNTNNPIER5 0.55
WILLIAMS LITHOGRAPH CO 534 4th Street, San Francisco, CA 94107-1621, USA 7 1991 N/A 94107WLLMS534FO 0.55
CEMEX SAN FRANCISCO (M) 420 Mariposa Street, San Francisco, CA 94107-2513, USA 5 2006 N/A 94107RMCPC42MAR 0.57
R.J. MCGLENNON CO INC. 198 Utah Street, San Francisco, CA 94103-4826, USA 45 2019 Yes 94103RJMCG198UT 0.74
MCGUIRE FURNITURE CO 1201 Bryant Street, San Francisco, CA 94103-4306, USA 10 1996 N/A 94103THMCG1201B 0.85

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.26
H & N FOODS B Street PIER 45, SHED B-11, San Francisco, CA 99999, USA OPR: Operating 0.26
CASTANELLA SEAFOODS, INC B Street PIER 45, SHED B - 8, San Francisco, CA 941192484, USA OPR: Operating 0.26
ALL SHORES SEAFOOD B Street PIER 45, SHED B-8, San Francisco, CA 99999, USA OPR: Operating 0.26
GAITO FISHERIES B Street PIER 45, SHED B - 8, San Francisco, CA 99999, USA OPR: Operating 0.26
PORT OF SAN FRANCISCO FOOT OF, 20th Street, San Francisco, CA 94107, USA OPR: Operating 0.77
CIAO BELLA GELATO 685 Harrison Street, San Francisco, CA 94107-1312, USA OPR: Operating 0.80
COACH USA CO 350 8th Street, San Francisco, CA 94103-4422, USA OPR: Operating 0.81
INTERSTATE BRANDS (#76) 1525 Bryant Street, San Francisco, CA 94103-4807, USA OPR: Operating 0.90
COSTCO 450 10th Street, San Francisco, CA 94103-4304, USA OPR: Operating 0.91

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 0 3

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

Not enough data points

Airplane Noise by Hour x Weekday

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