2817 24th Street, San Francisco, CA 94110-4213, USA


Property Overview:

2817 24th St is a 3-unit mixed-use building located in the Mission District of San Francisco, CA. It features two recently remodeled 1-bedroom residential flats above a commercial ground level. The property spans 2,930 sq. ft. and offers a prime investment opportunity.


Neighborhood Highlights:

  • Location: Situated in the vibrant 24th Street corridor of the Inner Mission, known for its Latino culture, murals, and diverse businesses.
  • Walkability: The property is a Walker’s and Biker’s Paradise, with easy access to public transportation (near BART station) and local amenities.
  • Cultural Hub: Close to the new AI hub and surrounded by gourmet shops, restaurants, and cultural landmarks.

Property Features:

  • Residential Units:

    • Two 1-bedroom flats, both recently remodeled with:
      • Tall ceilings, updated kitchens and baths, in-unit laundry, hardwood floors, and sunny decks with Southern exposure.
    • Vacancy: Both units are currently vacant, ideal for full market rent or owner occupancy.
  • Commercial Unit:

    • Ground level leased under NNN by the highly rated Tacos Del Barrio restaurant, providing stable rental income.
    • Tenant contributes to 1/3 of taxes and insurance, enhancing profitability.
  • Investment Potential:

    • Turn-key property with huge price reduction, offering excellent income potential in a high-demand area.

Location Benefits:

  • Cultural and Economic Growth: Located in a thriving neighborhood with a mix of historic charm and modern development.
  • Proximity to Amenities: Surrounded by murals, gourmet eateries, and local businesses.
  • Transportation: Close to BART, making it ideal for commuters.

Price and Status History

date type price
2015-02-03 Off Market 1850000
2024-03-08 For Sale 2195000
2024-04-10 For Sale 2300000
2024-05-29 For Sale 2195000
2024-06-13 For Sale 1895000
2024-10-28 For Sale 1895000
2024-12-28 For Sale 2195000
2025-03-17 Pending NaN

Superfund Enterprise Management System

SITE NAME ADDRESS FEDERAL FACILITY NPL STATUS NON-NPL STATUS CONTAMINANTS SEMS EPA ID DISTANCE (MILES)
NL INDS INC 2240 24th Street, San Francisco, CA 94107, USA N N NF 0 CAD980637003 0.37
KNUDSON PARK BET 24TH & 26TH, Potrero Avenue, San Francisco, CA 94110, USA N N NF 0 CAD980674048 0.45
ARMSTRONG JAMES VACANT LOT 2250 Jerrold Avenue, San Francisco, CA 94124-1042, USA N N NF 0 CAD980736052 0.67
COOKSON CO 1525 Cortland Avenue, San Francisco, CA 94110-5714, USA N N NF 0 CAD982358616 0.87
GOLLAN TYPE METAL COMPANY 1220 Pennsylvania Avenue, San Francisco, CA 94107-3415, USA N N RR 0 CAN000909436 0.87
MCKINNON 2100 McKinnon Avenue, San Francisco, CA 94124, USA N N RO 0 CAD982029001 0.96

Toxic Release Inventory

FACILITY NAME ADDRESS TOTAL FORMS LAST FORM YEAR RISK SCREENING FACILITY ID DISTANCE (MILES)
SYN-MAR CULTURED MARBLE INC 220 Bayshore Boulevard, San Francisco, CA 94124-1323, USA 5 1991 N/A 94124SYNMR220BA 0.56
CLERVI MARBLE CO 221 Bayshore Boulevard, San Francisco, CA 94124-1322, USA 11 1994 N/A 94124CLRVM221BA 0.62
BEST FOODS 1890 Bryant Street, San Francisco, CA 94110-1459, USA 6 1990 N/A 94110BSTFD1890B 0.74
BAE SYSTEMS SAN FRANCISCO SHIP REPAIR FOOT OF, 20th Street, San Francisco, CA 94107, USA 75 2015 Yes 94107STHWSFOOTO 0.98

Integrated Compliance Information System - Air

PLANT NAME ADDRESS OPERATING STATUS DISTANCE (MILES)
SAN FRANCISCO GENERAL HOSPITAL 1001 Potrero Avenue BLDG 2, ROOM 105, San Francisco, CA 94110-3518, USA 0.26
MCALINDON’S AUTO 1270 Valencia Street, San Francisco, CA 94110-3029, USA OPR: Operating 0.68
VALENCIA SHELL 899 Valencia Street, San Francisco, CA 94110-1736, USA OPR: Operating 0.80
CHERIN’S APPLIANCES 727 Valencia Street, San Francisco, CA 94110-1734, USA OPR: Operating 0.91
KING’S REFRIGERATION 659 Valencia Street, San Francisco, CA 94110-1150, USA OPR: Operating 0.96
F LOFRANO & SON INC 3355 17th Street, San Francisco, CA 94110-1207, USA OPR: Operating 0.98

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 0 0
Very high 0 0 3 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 46 45 45 44 46 45 45
1 43 43 49 45 51 45 47
2 44 43 51 48 45 50 47
3 44 44 44 47 48 43 51
4 44 43 42 43 43 46 46
5 39 42 38 45 43 48 40
6 37 39 37 41 47 40 40
7 42 41 41 40 38 43 41
8 41 41 42 42 44 40 40
9 40 40 40 40 39 42 40
10 40 42 40 40 43 44 38
11 42 43 39 40 43 44 40
12 41 46 48 43 41 43 43
13 40 42 41 40 42 39 41
14 46 44 51 47 43 41 43
15 45 44 48 48 47 44 44
16 48 47 50 44 46 51 45
17 45 45 45 48 44 39 47
18 46 51 45 48 47 45 45
19 45 NaN 48 49 46 52 47
20 52 43 45 47 43 44 44
21 47 45 52 49 47 47 44
22 43 47 47 46 41 47 46
23 41 47 51 48 50 44 45

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 2 2 3 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 1
5 2 3 2 3 2 3 2
6 4 5 6 6 5 5 5
7 5 7 6 5 6 5 6
8 4 4 4 6 5 4 5
9 7 6 8 8 8 8 8
10 6 7 6 8 7 7 8
11 8 8 10 9 10 10 8
12 10 8 7 7 9 8 8
13 9 9 12 9 10 11 9
14 8 9 10 11 12 9 8
15 7 6 7 8 8 5 6
16 6 7 6 10 7 7 5
17 5 6 8 8 7 6 6
18 5 7 4 8 8 4 7
19 7 7 6 9 7 7 7
20 5 5 4 5 5 3 5
21 6 3 4 6 4 3 4
22 4 4 3 5 3 4 4
23 6 7 7 8 6 5 7