{"id": "n-c6a09c147a", "slug": "sandusky-sandusky-mall", "type": "mall", "name": "Sandusky Mall", "aka": [], "city": "Sandusky", "county": "Erie County", "state": "OH", "country": "US", "census_division": 3, "lat": 41.4183333, "lon": -82.6691667, "geocode_method": "wikipedia", "address": null, "metro": null, "original_use": "indoor shopping center", "year_opened": 1977, "year_closed": null, "acres": null, "gla_sqft": null, "stores_peak": null, "levels": null, "original_developer": null, "original_architect": null, "before_notes": "Draft from Wikipedia, model-extracted, unreviewed: Sandusky Mall is being transformed into a mixed-use property featuring retail, residential, entertainment, and office space, with new tenants occupying former anchor stores.", "strategy": ["redevelop", "reinhabit"], "new_use": ["entertainment", "housing", "mixed", "office", "retail"], "share_retrofit": null, "status": "under construction", "year_retrofit": 2019, "developer": "Cafaro Company", "architect": null, "after_notes": "mixed-used property to feature retail, residential, entertainment, and office space", "narrative": "Sandusky Mall is an indoor shopping center located in Perkins Township, south of Sandusky, Ohio.  It is located on the east side of US Route 250, north of I-80/I-90 (Ohio Turnpike) and Ohio State Route 2. It is the only major shopping center within 45 miles (72 km). It comprises more than 70 stores; the anchor stores are TJ Maxx, JCPenney, Books-A-Million, Dewey Furniture, Five Below, Tilt Studio, and Ross. JCPenney had previously operated a store in downtown Sandusky. It is managed by Cafaro Company of Niles, Ohio.\n\n\n== History ==\nMall construction began in 1976 and Sandusky Mall opened on March 16, 1977.", "narrative_license": "CC BY-SA 4.0", "narrative_source": "https://en.wikipedia.org/wiki/Sandusky_Mall", "zoning_change": null, "public_subsidy": null, "entitlement_year": null, "planning_notes": null, "wikidata_qid": "Q7417014", "wikipedia": "https://en.wikipedia.org/wiki/Sandusky_Mall", "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": "39043", "opp_score": 0.0, "opp_reasons": ["already in play: under construction, approved, or sold to a developer with housing plans", "housing in the record"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/malls/oh/sandusky-sandusky-mall/", "events": [{"year": 1977, "date": null, "kind": "opened", "detail": "Opened", "source_id": null}, {"year": 2018, "date": null, "kind": "note", "detail": "Cafaro Company announced a redevelopment plan for the mall.", "source_id": 7604}, {"year": 2019, "date": null, "kind": "note", "detail": "Hobby Lobby announced to replace half of the former Sears store.", "source_id": 7605}, {"year": 2019, "date": null, "kind": "retrofit", "detail": "Retrofit: redevelop, reinhabit", "source_id": null}, {"year": 2020, "date": null, "kind": "note", "detail": "Hobby Lobby opened.", "source_id": 7606}, {"year": 2020, "date": null, "kind": "note", "detail": "TJ Maxx announced to open in new location inside the mall in 2021.", "source_id": 7607}, {"year": 2020, "date": null, "kind": "note", "detail": "Five Below announced to open near Hobby Lobby in 2021.", "source_id": 7608}, {"year": 2020, "date": null, "kind": "note", "detail": "Another Broken Egg Cafe announced to open in 2021.", "source_id": 7609}, {"year": 2021, "date": null, "kind": "note", "detail": "Five Below opened.", "source_id": 7610}, {"year": 2021, "date": null, "kind": "note", "detail": "TJ Maxx opened its new store.", "source_id": 7611}, {"year": 2022, "date": null, "kind": "note", "detail": "Ross Dress for Less opened a new store.", "source_id": 7612}, {"year": 2024, "date": null, "kind": "note", "detail": "Tilt Studio opened in the former Elder Beerman anchor store.", "source_id": 7613}], "sources": [{"id": 7603, "site_id": "n-c6a09c147a", "url": "https://en.wikipedia.org/wiki/Sandusky_Mall", "title": "Sandusky Mall", "publisher": "Wikipedia", "date": null, "quote": "Sandusky Mall", "kind": "wikipedia", "license": "CC BY-SA 4.0", "retrieved": "2026-10-18"}, {"id": 7604, "site_id": "n-c6a09c147a", "url": "https://en.wikipedia.org/wiki/Sandusky_Mall", "title": "Timeline", "publisher": null, "date": null, "quote": "In December 2018, Cafaro Company announced that they had a redevelopment plan set in place for the mall with changes on the horizon coming within the next year.", "kind": "quote", "license": null, "retrieved": "2026-10-18"}, {"id": 7605, "site_id": "n-c6a09c147a", "url": "https://en.wikipedia.org/wiki/Sandusky_Mall", "title": "Timeline", "publisher": null, "date": null, "quote": "On June 30, 2019, it was announced that Hobby Lobby, a crafts and home decor store, would be coming to the Sandusky Mall. It replaced roughly half of the former Sears store.", "kind": "quote", "license": null, "retrieved": "2026-10-18"}, {"id": 7606, "site_id": "n-c6a09c147a", "url": "https://en.wikipedia.org/wiki/Sandusky_Mall", "title": "Timeline", "publisher": null, "date": null, "quote": "It opened March 23, 2020.", "kind": "quote", "license": null, "retrieved": "2026-10-18"}, {"id": 7607, "site_id": "n-c6a09c147a", "url": "https://en.wikipedia.org/wiki/Sandusky_Mall", "title": "Timeline", "publisher": null, "date": null, "quote": "It was announced on December 17, 2020, that T.J. Maxx will open in their new location, inside the mall, in 2021.", "kind": "quote", "license": null, "retrieved": "2026-10-18"}, {"id": 7608, "site_id": "n-c6a09c147a", "url": "https://en.wikipedia.org/wiki/Sandusky_Mall", "title": "Timeline", "publisher": null, "date": null, "quote": "Five Below will also open near Hobby Lobby in 2021 in the former Macy's.", "kind": "quote", "license": null, "retrieved": "2026-10-18"}, {"id": 7609, "site_id": "n-c6a09c147a", "url": "https://en.wikipedia.org/wiki/Sandusky_Mall", "title": "Timeline", "publisher": null, "date": null, "quote": "Another Broken Egg Cafe will be opening at the mall in 2021 near Cheers Sports Bar and Grill.", "kind": "quote", "license": null, "retrieved": "2026-10-18"}, {"id": 7610, "site_id": "n-c6a09c147a", "url": "https://en.wikipedia.org/wiki/Sandusky_Mall", "title": "Timeline", "publisher": null, "date": null, "quote": "On May 30, 2021, Five Below held its soft opening and opened to the public for its grand opening on June 4, 2021.", "kind": "quote", "license": null, "retrieved": "2026-10-18"}, {"id": 7611, "site_id": "n-c6a09c147a", "url": "https://en.wikipedia.org/wiki/Sandusky_Mall", "title": "Timeline", "publisher": null, "date": null, "quote": "On October 21, 2021, T.J. Maxx opened its new store at Sandusky Mall", "kind": "quote", "license": null, "retrieved": "2026-10-18"}, {"id": 7612, "site_id": "n-c6a09c147a", "url": "https://en.wikipedia.org/wiki/Sandusky_Mall", "title": "Timeline", "publisher": null, "date": null, "quote": "On October 30, 2022, Ross Dress for Less opened a new store at the Sandusky Mall.", "kind": "quote", "license": null, "retrieved": "2026-10-18"}, {"id": 7613, "site_id": "n-c6a09c147a", "url": "https://en.wikipedia.org/wiki/Sandusky_Mall", "title": "Timeline", "publisher": null, "date": null, "quote": "Tilt Studio eventually opened on December 7, 2024.", "kind": "quote", "license": null, "retrieved": "2026-10-18"}], "deals": [], "parties": [{"name": "Cafaro Company", "kind": "developer", "role": "developer", "year_from": 2019, "year_to": null}], "parcels": [], "context": {"assessment": {"what_happened": "Sandusky Mall (opened 1977) is under construction for redevelopment since 2019, led by Cafaro Company. The project aims to convert the site into mixed-use space with housing, retail, entertainment, and office components. Key developments include Hobby Lobby (2020), TJ Maxx (2021), Five Below (2021), and Tilt Studio (2024) opening in former anchor spaces. Traffic data shows high volume (34,332 ADT) on a principal arterial road. Housing market data indicates rising ZHVI ($240k, +3.4% YoY) in Erie County. The opportunity is marked as 'already in play' due to active construction and housing-focused plans. No current vacancy data or completion timeline is provided in the record.", "why": "The assessment uses only the provided record: status, developer, timeline, new uses, traffic, housing market, and 'opp_reasons' explicitly state the site is under active development with housing plans.", "where_it_stands": "Status: under construction (2019–present). New uses confirmed: retail (TJ Maxx, Five Below), entertainment (Tilt Studio), housing (permits show 2023–2024 residential units), office. No data on current occupancy or final completion date.", "for_a_planner": ["High traffic volume supports retail/entertainment viability.", "Housing permits indicate residential component is underway.", "No data on community impact or displacement."], "for_a_developer": ["Active construction and housing focus align with current strategy.", "No new opportunity identified (record states 'already in play').", "Anchor tenant transitions (e.g., Elder Beerman to Tilt Studio) show adaptive reuse."], "risks_and_unknowns": ["No data on project cost, timeline, or final unit count.", "No current vacancy rates or tenant mix details beyond listed openings.", "Housing market growth rate (3.4% YoY) is noted but not contextualized."], "data_quality": "partial", "one_line": "Sandusky Mall is actively redeveloping into mixed-use (housing/retail/entertainment) under Cafaro Company, with construction ongoing since 2019 and housing permits issued in 2023–2024. Opportunity score is 0.0 due to active development.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "a3d1597eae9c"}, "edgar": {"query": "Sandusky Mall", "city": "Sandusky", "total": 24, "name_only_total": 2, "common_name": false, "sampled": 24, "latest": "2018-09-10", "earliest": "2001-04-27", "cmbs": [], "public": [], "other": [{"name": "AEROPOSTALE INC", "cik": "0001168213", "n": 5, "first": "2010-09-08", "last": "2015-08-24", "forms": {"8-K": 3, "10-Q": 1, "10-Q/A": 1}, "cmbs": false, "kind": "other", "sic": "5600", "acc": "0001168213-15-000062", "doc": "aro-20150818xex101.htm", "adjacent": false}, {"name": "CHRISTOPHER & BANKS CORP", "cik": "0000883943", "n": 4, "first": "2011-05-12", "last": "2018-08-06", "forms": {"10-K": 2, "8-K": 2}, "cmbs": false, "kind": "other", "sic": "5621", "acc": "0000883943-18-000134", "doc": "cbsecondamendmentfinal.htm", "adjacent": false}, {"name": "ELDER BEERMAN STORES CORP", "cik": "0000032020", "n": 4, "first": "2001-04-27", "last": "2003-10-15", "forms": {"10-K": 3, "10-K/A": 1}, "cmbs": false, "kind": "other", "sic": "5311", "acc": "0000950152-03-008808", "doc": "l01995be10vkza.txt", "adjacent": false}, {"name": "CRACKER BARREL OLD COUNTRY STORE, INC  (CBRL)", "cik": "0001067294", "n": 3, "first": "2011-07-11", "last": "2018-09-10", "forms": {"8-K": 3}, "cmbs": false, "kind": "other", "sic": "5812", "acc": "0001193125-18-270150", "doc": "d618824dex101.htm", "adjacent": false}, {"name": "EDISON BROTHERS STORES INC", "cik": "0000031575", "n": 2, "first": "2001-09-06", "last": "2002-02-04", "forms": {"8-K": 2}, "cmbs": false, "kind": "other", "sic": "5600", "acc": "0000922423-02-000107", "doc": "kl01040_ex99-1.txt", "adjacent": false}, {"name": "SIGHT RESOURCE CORP", "cik": "0000895651", "n": 1, "first": "2005-11-10", "last": "2005-11-10", "forms": {"8-K": 1}, "cmbs": false, "kind": "other", "sic": "8000", "acc": "0000950152-05-009093", "doc": "l16936aexv99w1.txt", "adjacent": false}, {"name": "COLE NATIONAL CORP /DE/", "cik": "0000769644", "n": 1, "first": "2003-09-15", "last": "2003-09-15", "forms": {"10-Q": 1}, "cmbs": false, "kind": "other", "sic": "5990", "acc": "0000950152-03-008276", "doc": "l03024aexv10w1.txt", "adjacent": false}, {"name": "COLE NATIONAL GROUP INC", "cik": "0000909492", "n": 1, "first": "2003-09-15", "last": "2003-09-15", "forms": {"10-Q": 1}, "cmbs": false, "kind": "other", "sic": "5945", "acc": "0000950152-03-008275", "doc": "l03023aexv10w1.txt", "adjacent": false}], "forms": {"8-K": 12, "10-K": 5, "10-Q": 4, "10-K/A": 1, "10-Q/A": 1, "8-K/A": 1}, "url": "https://efts.sec.gov/LATEST/search/#/q=%22Sandusky%20Mall%22%20%22Sandusky%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": [], "adj_total": 0, "first_in_sample": null, "securitised": null, "vintage": null, "vintage_strong": false, "source": "SEC EDGAR full-text search"}, "elevation": {"elevation_ft": 607.2, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "39043041500", "urban": 1, "lila_1_10": 0, "low_access_1mi": 1, "lapop1share": 28.1474738021663, "poverty_rate": 4.54288939051919, "median_family_income": 83274.0, "snap_households": 38.0, "pop2010": 3473.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 240422, "month": "2026-09", "change_1y": 0.034, "change_5y": 0.33}, "zori": {"latest": 1812, "month": "2026-09", "change_1y": 0.111, "change_5y": null}, "county_fips": "39043", "source": "Zillow Research (ZHVI, ZORI)"}, "jobs_lodes": {"tract20": "39043041900", "jobs": 4826, "retail_jobs": 1510, "food_accommodation_jobs": 1011, "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": "44870", "month": "202609", "median_listing_price": 229450, "median_listing_price_yy": -0.0748, "active_listing_count": 134, "median_days_on_market": 52, "price_reduced_share": 0.1504, "pending_ratio": 0.4403, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "39043041500", "kfr_p25": 0.4429, "jail_p25": 0.018, "kids_count": 144.5573, "commuting_zone": "Lorain", "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": "m-dbf9b78307", "name": "Barstow Mall", "city": "Barstow", "state": "CA", "score": 5.5, "why": ["opened 1975", "same strategy: reinhabit"]}, {"id": "m-2c6ba048e3", "name": "Euclid Square Mall", "city": "Euclid", "state": "OH", "score": 5.5, "why": ["opened 1977", "same strategy: redevelop", "also in OH"]}, {"id": "m-94b3a4fb75", "name": "Land of Oz shopping mall", "city": null, "state": "OH", "score": 5.5, "why": ["opened 1980", "same strategy: redevelop", "also in OH"]}, {"id": "m-d3d67274ab", "name": "North Towne Square", "city": "Toledo", "state": "OH", "score": 5.5, "why": ["opened 1980", "same strategy: redevelop", "also in OH"]}, {"id": "m-109f0836ff", "name": "Northgate Mall", "city": "Northgate", "state": "OH", "score": 5.5, "why": ["opened 1972", "same strategy: redevelop", "also in OH"]}, {"id": "m-e084e068b0", "name": "Pine Ridge Mall", "city": "Chubbuck", "state": "ID", "score": 5.5, "why": ["opened 1981", "same strategy: redevelop"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "Erie County", "2024": {"units_1": 107, "units_2_4": 6, "units_5plus": 0, "value_total": 38639843}, "2023": {"units_1": 112, "units_2_4": 6, "units_5plus": 17, "value_total": 41580016}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "39043", "year": 2025, "establishments": 293, "employment": 5194, "avg_annual_pay": 36947, "lq_employment": 1.44, "employment_change_1y": 3.2, "source": "BLS QCEW 2025 annual, county, NAICS 44-45 retail trade, private", "retrieved": "2026-10-20"}, "retail_trend": {"2012": {"estab": 309, "emp": 4633}, "2023": {"estab": 301, "emp": 5655}, "estab_change": -0.026, "emp_change": 0.221, "county_fips": "39043"}, "schools": {"district": "Perkins Local School District", "district_geoid": "3904681", "grades": "PK-12", "district_vintage": "SY2024-25", "public_schools_1mi": 1, "schools": ["Meadowlawn Elementary School"], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "39043", "years": "2016-2025", "events": 70, "by_type": {"Thunderstorm Wind": 51, "Hail": 10, "Flash Flood": 5, "Tornado": 2, "Flood": 2}, "property_damage_usd": 5560000, "deaths_direct": 0, "injuries_direct": 2, "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": 34332, "trucks_aadt": null, "road": "MILAN RD", "class": "principal arterial", "lanes": 4, "segments_600m": 11, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}}, "elements": [{"slug": "strategy-reinhabit", "name": "Reinhabited", "group_": "strategy", "evidence": "mixed-used property to feature retail, residential, entertainment, and office space", "origin": "record"}, {"slug": "use-office", "name": "Office", "group_": "use", "evidence": "property to feature retail, residential, entertainment, and office space", "origin": "newtypes-extraction"}, {"slug": "use-retail", "name": "Retail (continued)", "group_": "use", "evidence": "mixed-used property to feature retail, residential, entertainment, and office space", "origin": "newtypes-extraction"}, {"slug": "era-retrofit-2010s", "name": "Retrofit 2010s", "group_": "era", "evidence": "2019", "origin": "newtypes-extraction"}, {"slug": "strategy-redevelop", "name": "Redeveloped", "group_": "strategy", "evidence": "mixed-used property to feature retail, residential, entertainment, and office space", "origin": "record"}, {"slug": "use-housing", "name": "Housing", "group_": "use", "evidence": "mixed-used property to feature retail, residential, entertainment, and office space", "origin": "newtypes-extraction"}, {"slug": "anchor-jcpenney", "name": "JCPenney", "group_": "anchor", "evidence": "JCPenney", "origin": "wikipedia"}, {"slug": "era-opened-1970s", "name": "Opened 1970s", "group_": "era", "evidence": "1977", "origin": "newtypes-extraction"}, {"slug": "use-mixed", "name": "Mixed use", "group_": "use", "evidence": "new_use field", "origin": "newtypes-extraction"}, {"slug": "place-high-traffic", "name": "30,000+ vehicles a day on an adjacent road", "group_": "place", "evidence": "34,332 on MILAN RD", "origin": "fhwa-hpms"}, {"slug": "place-shrinking-county", "name": "Shrinking county", "group_": "place", "evidence": "-0.3%", "origin": "census-acs"}, {"slug": "use-entertainment", "name": "Entertainment and sports", "group_": "use", "evidence": "mixed-used property to feature retail, residential, entertainment, and office space", "origin": "newtypes-extraction"}, {"slug": "anchor-montgomery-ward", "name": "Montgomery Ward", "group_": "anchor", "evidence": "Montgomery Ward", "origin": "wikipedia"}, {"slug": "status-pipeline", "name": "Retrofit in the pipeline", "group_": "finance", "evidence": "under construction", "origin": "newtypes-extraction"}], "details": {}, "photos": [], "provenance": {"year_opened": "newtypes-extraction", "status": "newtypes-extraction", "after_notes": "newtypes-extraction", "year_retrofit": "newtypes-extraction", "developer": "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\": …}"}}