738 Long Bridge Street Unit 407, San Francisco, CA 94158-2554, USA

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

Property Overview:

Luxury 2-bedroom + den corner condo in the prestigious Arden building, located in Mission Bay, San Francisco. Features 2 bathrooms, open-concept floor plan, and a large private terrace. Fully furnished and available for a 6-month lease.

Neighborhood Highlights:

  • Prime Location:

    • Situated in the vibrant Mission Bay neighborhood.
    • Close to Chase Center, Oracle Park, UCSF campus, tech HQs, and cafes/restaurants.
    • Easy access to MUNI, Caltrain, I-280, and nearby parks/playgrounds.

  • Community Amenities:

    • Adjacent to a dog park, children’s playground, and the Channel.

Property Features:

  • Interior:

    • Bright and spacious with Southeastern exposure and wall-to-wall windows.
    • Den ideal for a home office or guest space.
    • Gourmet kitchen with Caesarstone countertops, Grohe fixtures, Thermador appliances, and mosaic tile backsplash.
    • Brand-new carpeting in bedrooms and in-unit laundry.

  • Building Amenities:

    • Two designer lobbies with attendants.
    • Hotel-inspired fireside lounge.
    • 75′ rooftop lap pool and spa.
    • Double-height fitness studio.
    • Expansive outdoor deck with city views, BBQ grills, and fire pit.

Location Benefits:

  • Convenient Urban Living:
    • Perfect for entertaining or relaxing with access to luxury amenities.
    • Surrounded by parks, recreational spaces, and public transit options.
2

Price and Status History

date type price
2016-02-11 For Sale 1899000
2016-02-26 For Sale 1789000
2016-03-02 Pending NaN
2016-03-31 Sold 1809000
2022-06-24 For Sale NaN
2022-07-19 For Sale NaN
2023-08-16 For Sale NaN
2023-09-04 Off Market NaN
2024-01-24 Rental 6490
2024-02-01 Rental 6490
2025-02-16 Pending NaN
2025-02-17 Rental 7500
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 1E 8TH & Channel Street, San Francisco, CA 94103, USA N N NF 0 CAD981415599 0.09
H & H SHIP SERVICE 220 China Basin Street, San Francisco, CA 94107, USA N N NF 0 CAD004771168 0.10
PG&E GAS PLANT SAN FRANCISCO 502 1D KING NR 3rd Street, San Francisco, CA 94107, USA N N NF 0 CAD981415532 0.35
C & M PLATING WORKS 598 6th Street, San Francisco, CA 94103, USA N N DR 0 CAD009204736 0.45
CONSOLIDATED IRON & METAL 634 Townsend Street, San Francisco, CA 94103, USA N N NF 0 CAD980884969 0.47
UNITED AMERICAN METALS CORP OF CALIFORNIA 785 Bryant Street, San Francisco, CA 94107-1014, USA N N RR 0 CAN000909448 0.52
GAMLEN CHEMICAL CO 195 San Bruno Avenue, San Francisco, CA 94103, USA N N NF 0 CAD982358491 0.71
ELECTRIC SMELTING CO. 91 Federal Street, San Francisco, CA 94107, USA N N RR 0 CAN000909432 0.76
PG&E GAS PLANT SAN FRANCISCO 502 1B KING &, 2nd Street, San Francisco, CA 94107, USA N N NF 0 CAD981415417 0.78
PG&E GAS PLANT SAN FRANCISCO 502 1K STEVENSON BET 5TH &, 6th Street, San Francisco, CA 94103, USA N N NF 0 CAD981415110 0.78

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.39
WILLIAMS LITHOGRAPH CO 534 4th Street, San Francisco, CA 94107-1621, USA 7 1991 N/A 94107WLLMS534FO 0.53
CONTINENTAL MARITIME OF S F INC Pier 50, San Francisco, CA 94107, USA 4 1988 N/A 94107CNTNNPIER5 0.53
CEMEX SAN FRANCISCO (M) 420 Mariposa Street, San Francisco, CA 94107-2513, USA 5 2006 N/A 94107RMCPC42MAR 0.59
R.J. MCGLENNON CO INC. 198 Utah Street, San Francisco, CA 94103-4826, USA 45 2019 Yes 94103RJMCG198UT 0.77
BAE SYSTEMS SAN FRANCISCO SHIP REPAIR FOOT OF, 20th Street, San Francisco, CA 94107, USA 75 2015 Yes 94107STHWSFOOTO 0.80
CONTINENTAL BAKING CO 1525 Bryant Street, San Francisco, CA 94103-4807, USA 2 1991 N/A 94103CNTNN1525B 0.92

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.30
ALBER SEAFOODS PIER 45_SHED, B Street B-4, San Francisco, CA 99999, USA OPR: Operating 0.30
WEST BAY SEAFOOD COMPANY, INC B Street PIER 45, SHED B-11, San Francisco, CA 99999, USA OPR: Operating 0.30
GAITO FISHERIES B Street PIER 45, SHED B - 8, San Francisco, CA 99999, USA OPR: Operating 0.30
ALL SHORES SEAFOOD B Street PIER 45, SHED B-8, San Francisco, CA 99999, USA OPR: Operating 0.30
CIAO BELLA GELATO 685 Harrison Street, San Francisco, CA 94107-1312, USA OPR: Operating 0.77
COACH USA CO 350 8th Street, San Francisco, CA 94103-4422, USA OPR: Operating 0.81
MCGUIRE FURNITURE COMPANY 1201 Bryant Street, San Francisco, CA 94103-4306, USA OPR: Operating 0.87
COSTCO 450 10th Street, San Francisco, CA 94103-4304, USA OPR: Operating 0.93
COSTCO Harrison Street, San Francisco, CA 94105, USA OPR: Operating 0.97
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 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
5

Traffic Noise by Hour x Weekday

Not enough data points

6

Airplane Noise by Hour x Weekday

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