{"id": "n-98abfb6d68", "slug": "san-mateo-hillsdale-mall", "type": "mall", "name": "Hillsdale Mall", "aka": [], "city": "San Mateo", "county": "San Mateo County", "state": "CA", "country": "US", "census_division": 9, "lat": 37.563, "lon": -122.32533, "geocode_method": "nominatim-city", "address": null, "metro": null, "original_use": "retail", "year_opened": null, "year_closed": null, "acres": null, "gla_sqft": null, "stores_peak": null, "levels": null, "original_developer": null, "original_architect": null, "before_notes": "Draft from cityofsanmateo.org, model-extracted, unreviewed: Hillsdale Mall, an existing retail mall in San Mateo, CA, is proposed to be redeveloped with up to 1,670 residential units and 2,059,000 GSF of new commercial development.", "strategy": ["redevelop"], "new_use": ["housing", "office", "retail"], "share_retrofit": null, "status": "proposed", "year_retrofit": null, "developer": null, "architect": null, "after_notes": null, "narrative": null, "narrative_license": null, "narrative_source": null, "zoning_change": null, "public_subsidy": null, "entitlement_year": null, "planning_notes": null, "wikidata_qid": null, "wikipedia": null, "osm_id": null, "verified": "draft", "verified_by": null, "last_verified": null, "last_updated": "2026-10-18", "created": "2026-10-18", "contributor_name": null, "contributor_org": null, "contributor_link": null, "international": 0, "county_fips": "06081", "opp_score": 0.0, "opp_reasons": ["already in play: under construction, approved, or sold to a developer with housing plans", "county shrank -2.7% 2018–23", "median rent $2,893", "housing in the record"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/malls/ca/san-mateo-hillsdale-mall/", "events": [{"year": 2025, "date": null, "kind": "note", "detail": "Formal Planning Application submitted", "source_id": 8766}, {"year": 2026, "date": null, "kind": "note", "detail": "Planning Application deemed complete", "source_id": 8767}], "sources": [{"id": 8765, "site_id": "n-98abfb6d68", "url": "https://www.cityofsanmateo.org/4856/Hillsdale-Mall-Redevelopment---Mixed-Use", "title": "Hillsdale Mall Redevelopment - Mixed-Use Development", "publisher": "cityofsanmateo.org", "date": null, "quote": "Hillsdale Mall", "kind": "news", "license": null, "retrieved": "2026-10-18"}, {"id": 8766, "site_id": "n-98abfb6d68", "url": "https://www.cityofsanmateo.org/4856/Hillsdale-Mall-Redevelopment---Mixed-Use", "title": "Timeline", "publisher": null, "date": null, "quote": "June 23, 2025 - Formal Planning Application submitted.", "kind": "quote", "license": null, "retrieved": "2026-10-18"}, {"id": 8767, "site_id": "n-98abfb6d68", "url": "https://www.cityofsanmateo.org/4856/Hillsdale-Mall-Redevelopment---Mixed-Use", "title": "Timeline", "publisher": null, "date": null, "quote": "June 1, 2026 - Planning Application deemed complete.", "kind": "quote", "license": null, "retrieved": "2026-10-18"}], "deals": [], "parties": [], "parcels": [], "context": {"assessment": {"what_happened": "Hillsdale Mall (San Mateo, CA) is proposed for redevelopment to housing, office, and retail. The opportunity is flagged as 'already in play' (under construction, approved, or sold to a developer with housing plans), with county population declining 2.7% (2018–23), median rent $2,893, and high housing costs (ZHVI $1.58M, ZORI $3,993). Nearby projects include a proposed 0km adjacent site (2820 South El Camino Real) and approved housing developments within 3.6km. Retail employment declined 5.1% since 2012, while 2024 permits show 521 residential units approved.", "why": "Record explicitly lists 'already in play' as a key reason against opportunity status, with contextual data on declining retail, high housing costs, and active nearby development.", "where_it_stands": "Status: proposed. Noted as not a new opportunity due to existing development activity. Context shows strong housing market demand but declining retail.", "for_a_planner": ["County population decline noted", "Retail employment down 5.1% since 2012", "Nearby housing projects approved/under construction"], "for_a_developer": ["High housing costs (ZHVI $1.58M)", "Median rent $2,893", "Adjacent site proposed at 0km (2820 South El Camino Real)"], "risks_and_unknowns": ["No approval status confirmed for Hillsdale redevelopment", "No current construction timeline provided", "No specific housing mix (e.g., affordable vs. market-rate)"], "data_quality": "partial", "one_line": "Proposed redevelopment flagged as 'already in play' amid declining retail, high housing costs, and active nearby development.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "69e913847bf1"}, "cluster": {"within_10km": [{"id": "n-8748514ca1", "name": "2820 South El Camino Real", "city": "San Mateo", "status": "proposed", "km": 0.0}, {"id": "n-df69b02337", "name": "668 East 3rd Avenue", "city": "San Mateo", "status": "approved", "km": 0.7}, {"id": "n-5d8dc66f1c", "name": "3000 Clearview Way", "city": "San Mateo", "status": "approved", "km": 3.4}, {"id": "m-e505279cb7", "name": "Hillsdale Shopping Center", "city": "San Mateo", "status": "operating", "km": 3.6}, {"id": "m-c2a3d25cfb", "name": "San Mateo Fashion Island", "city": "San Mateo", "status": "demolished", "km": 3.9}], "count_10km": 5, "count_25km": 18}, "edgar": {"query": "Hillsdale Mall", "city": "San Mateo", "total": 51, "name_only_total": 3, "common_name": false, "sampled": 51, "latest": "2013-09-12", "earliest": "2001-09-18", "cmbs": [], "public": [], "other": [{"name": "ANN INC.", "cik": "0000874214", "n": 6, "first": "2010-11-19", "last": "2012-03-09", "forms": {"10-K": 2, "10-Q": 2, "10-Q/A": 2}, "cmbs": false, "kind": "other", "sic": "5621", "acc": "0000874214-12-000007", "doc": "ex102-pledgeandsecurityagr.htm", "adjacent": true}, {"name": "GAP INC  (GAP)", "cik": "0000039911", "n": 4, "first": "2006-03-28", "last": "2013-09-12", "forms": {"10-Q": 2, "10-K": 1, "10-Q/A": 1}, "cmbs": false, "kind": "other", "sic": "5651", "acc": "0000039911-13-000148", "doc": "exhibit101msa2.htm", "adjacent": true}, {"name": "WARNACO GROUP INC /DE/", "cik": "0000801351", "n": 3, "first": "2002-11-18", "last": "2003-01-27", "forms": {"10-Q": 2, "8-K": 1}, "cmbs": false, "kind": "other", "sic": "2340", "acc": "0000950117-03-000218", "doc": "ex2-2.txt", "adjacent": true}, {"name": "FEDERATED DEPARTMENT STORES INC /DE/  (M)", "cik": "0000794367", "n": 3, "first": "2001-09-18", "last": "2005-07-19", "forms": {"10-Q": 2, "8-K": 1}, "cmbs": false, "kind": "other", "sic": "5311", "acc": "0000794367-05-000096", "doc": "creditagreement.htm", "adjacent": true}, {"name": "MEMRY CORP", "cik": "0000720896", "n": 2, "first": "2001-09-28", "last": "2002-08-19", "forms": {"10-K/A": 1, "10-K": 1}, "cmbs": false, "kind": "other", "sic": "3541", "acc": "0000950130-02-006052", "doc": "dex1040.txt", "adjacent": true}, {"name": "FOOTSTAR INC", "cik": "0001011308", "n": 16, "first": "2004-06-16", "last": "2005-11-10", "forms": {"8-K": 16}, "cmbs": false, "kind": "other", "sic": "5661", "acc": "0000909518-05-000866", "doc": "jd11-10ex99_1.txt", "adjacent": false}, {"name": "BARE ESCENTUALS INC", "cik": "0001295557", "n": 2, "first": "2007-03-30", "last": "2008-02-28", "forms": {"10-K": 2}, "cmbs": false, "kind": "other", "sic": "2844", "acc": "0001047469-08-001921", "doc": "a2183013z10-k.htm", "adjacent": false}, {"name": "JONES APPAREL GROUP INC", "cik": "0000874016", "n": 2, "first": "2010-07-30", "last": "2011-04-28", "forms": {"8-K": 2}, "cmbs": false, "kind": "other", "sic": "2330", "acc": "0000950123-11-040836", "doc": "y90974exv10w1.htm", "adjacent": false}], "forms": {"8-K": 21, "10-Q": 15, "10-K": 9, "10-Q/A": 3, "10-K/A": 2, "8-K/A": 1}, "url": "https://efts.sec.gov/LATEST/search/#/q=%22Hillsdale%20Mall%22%20%22San%20Mateo%22&forms=10-K,10-D,8-K,10-Q,ABS-EE&dateRange=custom&startdt=2001-01-01", "retrieved": "2026-10-20", "v": 4, "adj": ["0000039911", "0000720896", "0000794367", "0000801351", "0000850209", "0000874214", "0000876343", "0000879206", "0000886744", "0000896985", "0001041379", "0001318008"], "adj_total": 21, "first_in_sample": null, "securitised": null, "vintage": null, "vintage_strong": false, "source": "SEC EDGAR full-text search"}, "elevation": {"elevation_ft": 45.5, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "06081606300", "urban": 1, "lila_1_10": 0, "low_access_1mi": 0, "poverty_rate": 6.4075382803298, "median_family_income": 126131.0, "snap_households": 61.0, "pop2010": 4073.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 1579058, "month": "2026-09", "change_1y": 0.044, "change_5y": 0.076}, "zori": {"latest": 3993, "month": "2026-09", "change_1y": 0.112, "change_5y": 0.277}, "county_fips": "06081", "source": "Zillow Research (ZHVI, ZORI)"}, "jobs_lodes": {"tract20": "06081606300", "jobs": 8037, "retail_jobs": 658, "food_accommodation_jobs": 1758, "year": 2022, "source": "Census LEHD LODES8 WAC 2022 (all jobs, primary and secondary), blocks summed to the 2020 tract", "retrieved": "2026-10-20"}, "listings": {"zip": "94401", "month": "202609", "median_listing_price": 770450, "median_listing_price_yy": 0.1023, "active_listing_count": 34, "median_days_on_market": 35, "price_reduced_share": 0.1253, "pending_ratio": 0.3676, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "06081606300", "kfr_p25": 0.4908, "jail_p25": 0.0158, "kids_count": 319.3816, "commuting_zone": "San Francisco", "vintage": "children born 1978-83, outcomes measured 2014-15", "source": "Opportunity Insights, Opportunity Atlas (Chetty, Friedman, Hendren, Jones, Porter 2018)", "retrieved": "2026-10-20"}, "peers": {"peers": [{"id": "n-fd7b7e0572", "name": "Shops at Tanforan", "city": "San Bruno", "state": "CA", "score": 6.5, "why": ["same strategy: redevelop", "also in CA", "11 km away"]}, {"id": "m-8989aa18b3", "name": "Old Mills Mall", "city": "Mountain View", "state": "CA", "score": 6.0, "why": ["same strategy: redevelop", "also in CA", "26 km away"]}, {"id": "n-e03df26111", "name": "San Antonio Shopping Center", "city": "Mountain View", "state": "CA", "score": 6.0, "why": ["same strategy: redevelop", "also in CA", "26 km away"]}, {"id": "n-509f236fc5", "name": "Moonlite Center Development", "city": "Santa Clara", "state": "CA", "score": 6.0, "why": ["same strategy: redevelop", "also in CA", "39 km away"]}, {"id": "n-8748514ca1", "name": "2820 South El Camino Real", "city": "San Mateo", "state": "CA", "score": 6.0, "why": ["same strategy: redevelop", "also in CA", "0 km away"]}, {"id": "n-28296958e1", "name": "1198 Valencia", "city": "San Francisco", "state": "CA", "score": 6.0, "why": ["same strategy: redevelop", "also in CA", "23 km away"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "San Mateo County", "2024": {"units_1": 521, "units_2_4": 29, "units_5plus": 538, "value_total": 577977677}, "2023": {"units_1": 398, "units_2_4": 25, "units_5plus": 750, "value_total": 443893104}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "06081", "year": 2025, "establishments": 1714, "employment": 28461, "avg_annual_pay": 58616, "lq_employment": 0.7, "employment_change_1y": -3.1, "source": "BLS QCEW 2025 annual, county, NAICS 44-45 retail trade, private", "retrieved": "2026-10-20"}, "retail_trend": {"2012": {"estab": 2060, "emp": 34019}, "2023": {"estab": 1827, "emp": 32272}, "estab_change": -0.113, "emp_change": -0.051, "county_fips": "06081"}, "schools": {"district": "San Mateo Union High School District", "district_geoid": "0634980", "grades": "09-12", "district_vintage": "SY2024-25", "public_schools_1mi": 7, "schools": ["South Hillsborough", "Baywood Elementary", "Borel Middle", "College Park Elementary", "North Shoreview Montessori", "Sunnybrae Elementary"], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "06081", "years": "2016-2025", "events": 101, "by_type": {"Flood": 50, "Debris Flow": 18, "Thunderstorm Wind": 15, "Hail": 9, "Lightning": 4, "Flash Flood": 3, "Heavy Rain": 2}, "property_damage_usd": 10060, "deaths_direct": 0, "injuries_direct": 0, "note": "county-typed events only; events logged to forecast zones (CZ_TYPE Z: most winter, heat, flood and coastal events) are not counted", "source": "NOAA NCEI Storm Events Database, details files", "retrieved": "2026-10-20"}, "traffic": {"max_aadt": 34000, "trucks_aadt": 1255, "road": "82", "class": "principal arterial", "lanes": 6, "segments_600m": 31, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}}, "elements": [{"slug": "use-office", "name": "Office", "group_": "use", "evidence": "new_use field", "origin": "record"}, {"slug": "use-retail", "name": "Retail (continued)", "group_": "use", "evidence": "new_use field", "origin": "record"}, {"slug": "place-mall-cluster", "name": "3+ other atlas sites within 10 km", "group_": "place", "evidence": "5 within 10 km", "origin": "computed"}, {"slug": "strategy-redevelop", "name": "Redeveloped", "group_": "strategy", "evidence": "", "origin": "record"}, {"slug": "use-housing", "name": "Housing", "group_": "use", "evidence": "new_use field", "origin": "record"}, {"slug": "place-retail-shrinking-county", "name": "County lost 10%+ of retail establishments since 2012", "group_": "place", "evidence": "-11%", "origin": "census-cbp"}, {"slug": "place-high-traffic", "name": "30,000+ vehicles a day on an adjacent road", "group_": "place", "evidence": "34,000 on 82", "origin": "fhwa-hpms"}, {"slug": "place-rent-2000-plus", "name": "County typical rent $2,000+", "group_": "place", "evidence": "$3,993/mo", "origin": "zillow"}, {"slug": "place-shrinking-county", "name": "Shrinking county", "group_": "place", "evidence": "-2.7%", "origin": "census-acs"}, {"slug": "status-pipeline", "name": "Retrofit in the pipeline", "group_": "finance", "evidence": "proposed", "origin": "newtypes-extraction"}], "details": {}, "photos": [], "provenance": {"status": "newtypes-extraction"}, "restricted_fields": {"parcels": ["owner_addr", "assessed", "taxable", "tax_amount", "sale_price", "deed_ref"], "deals": ["price", "price_per_acre", "price_per_sqft", "loan_amount", "asking_price"], "how": "free API key: POST /api/v1/keys {\"email\": …}"}}