{"id": "m-109f0836ff", "slug": "northgate-northgate-mall", "type": "mall", "name": "Northgate Mall", "aka": [], "city": "Northgate", "county": "Hamilton County", "state": "OH", "country": "US", "census_division": 3, "lat": 39.24465, "lon": -84.59917, "geocode_method": null, "address": null, "metro": null, "original_use": "mall", "year_opened": 1972, "year_closed": 2026, "acres": null, "gla_sqft": null, "stores_peak": null, "levels": null, "original_developer": null, "original_architect": null, "before_notes": "Wikipedia categories: Defunct shopping malls in the United States", "strategy": ["redevelop"], "new_use": ["mixed", "housing"], "share_retrofit": null, "status": "demolished", "year_retrofit": null, "developer": "Tundra Realty", "architect": null, "after_notes": "mixed-use housing", "narrative": "Northgate Mall is a defunct enclosed shopping mall in Northgate, Ohio.", "narrative_license": "CC BY-SA 4.0", "narrative_source": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "zoning_change": "mixed-use", "public_subsidy": null, "entitlement_year": 2025, "planning_notes": "mixed-use housing", "wikidata_qid": "Q7059461", "wikipedia": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "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": "39061", "opp_score": 20.0, "opp_reasons": ["closed or demolished site (sourced)", "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/northgate-northgate-mall/", "events": [{"year": 1970, "date": null, "kind": "note", "detail": "Construction began", "source_id": 1456}, {"year": 1972, "date": null, "kind": "opened", "detail": "Opened (Wikidata)", "source_id": null}, {"year": 1972, "date": null, "kind": "note", "detail": "Opened", "source_id": 1457}, {"year": 2006, "date": null, "kind": "note", "detail": "JCPenney closed", "source_id": 1458}, {"year": 2007, "date": null, "kind": "note", "detail": "Pogue's/JCPenney demolished", "source_id": 1459}, {"year": 2012, "date": null, "kind": "note", "detail": "Sold to Tabani Group", "source_id": 1460}, {"year": 2013, "date": null, "kind": "note", "detail": "Dillard's subdivided", "source_id": 1461}, {"year": 2018, "date": null, "kind": "note", "detail": "Sears closed", "source_id": 1462}, {"year": 2020, "date": null, "kind": "note", "detail": "Macy's closed", "source_id": 1463}, {"year": 2023, "date": null, "kind": "note", "detail": "Xscape closed", "source_id": 1464}], "sources": [{"id": 641, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Wikipedia: Northgate Mall (Ohio)", "publisher": "Wikipedia", "date": "2026-10-11", "quote": null, "kind": "wikipedia", "license": "CC BY-SA 4.0", "retrieved": "2026-10-18"}, {"id": 1451, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Quoted support for year_closed", "publisher": null, "date": null, "quote": "remaining interior tenants were required to vacate Northgate Mall by September 14, 2026.", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}, {"id": 1452, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Quoted support for after_notes", "publisher": null, "date": null, "quote": "mixed-use housing", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}, {"id": 1453, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Quoted support for status", "publisher": null, "date": null, "quote": "demolition began on the former Sears building.", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}, {"id": 1454, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Quoted support for strategy", "publisher": null, "date": null, "quote": "demolition began on the former Sears building.", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}, {"id": 1455, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Quoted support for zoning_change", "publisher": null, "date": null, "quote": "Tundra Realty had not publicly announced its plans...", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}, {"id": 1456, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Timeline", "publisher": null, "date": null, "quote": "Construction on the mall began in 1970.", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}, {"id": 1457, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Timeline", "publisher": null, "date": null, "quote": "opened on September 10, 1972.", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}, {"id": 1458, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Timeline", "publisher": null, "date": null, "quote": "JCPenney closed their anchor store in 2006.", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}, {"id": 1459, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Timeline", "publisher": null, "date": null, "quote": "Pogue's/JCPenney anchor store was demolished in 2007.", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}, {"id": 1460, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Timeline", "publisher": null, "date": null, "quote": "In 2012, the mall was sold to Tabani Group.", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}, {"id": 1461, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Timeline", "publisher": null, "date": null, "quote": "The vacant Dillard's anchor store was subdivided into four big-box stores in 2013.", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}, {"id": 1462, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Timeline", "publisher": null, "date": null, "quote": "Sears anchor store closed in November 2018.", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}, {"id": 1463, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Timeline", "publisher": null, "date": null, "quote": "Macy's announced that they would close in March 2020.", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}, {"id": 1464, "site_id": "m-109f0836ff", "url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "title": "Timeline", "publisher": null, "date": null, "quote": "Xscape theater closed.", "kind": "wikipedia", "license": null, "retrieved": "2026-10-18"}], "deals": [{"id": 20, "site_id": "m-109f0836ff", "kind": "sale", "date": null, "year": 2012, "acres": null, "sqft": null, "buyer": "Tabani Group", "seller": "previous owners", "broker": null, "lender": null, "loan_maturity": null, "loan_status": null, "listing_url": null, "status": null, "notes": "scope: property", "source_url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "source_title": "Wikipedia", "source_date": null, "quote": "In 2012, the mall was sold to Tabani Group.", "verified": "draft", "retrieved": "2026-10-18"}, {"id": 21, "site_id": "m-109f0836ff", "kind": "loan", "date": null, "year": 2007, "acres": null, "sqft": null, "buyer": "Rave multiplex", "seller": "mall's then-owners", "broker": null, "lender": "bank", "loan_maturity": null, "loan_status": null, "listing_url": null, "status": null, "notes": "scope: property", "source_url": "https://en.wikipedia.org/wiki/Northgate_Mall_(Ohio)", "source_title": "Wikipedia", "source_date": null, "quote": "demolished on a $74 million loan.", "verified": "draft", "retrieved": "2026-10-18"}], "parties": [{"name": "Tabani Group", "kind": "owner", "role": "owner (from text)", "year_from": 2012, "year_to": 2026}, {"name": "Tundra Realty", "kind": "owner", "role": "owner (from text)", "year_from": 2026, "year_to": null}], "parcels": [], "context": {"assessment": {"what_happened": "Northgate Mall opened in 1972 and operated as an enclosed shopping center. Over time, anchor stores such as JCPenney (2006), Sears (2018), Macy's (2020) and Xscape (2023) closed, leading to declining occupancy. The mall was sold to Tabani Group in 2012, then to Tundra Realy in 2026, after which it was demolished and cleared for redevelopment.", "why": "The primary causes visible in the record are the loss of major anchor tenants and subsequent demolition of the mall. No explicit debt or competition factors are cited beyond the anchor closures.", "where_it_stands": "The site is currently demolished and controlled by Tundra Realy, which acquired the property in 2026.", "for_a_planner": ["- Mixed-use zoning change approved in 2025 (zoning_change: mixed-use).", "- Entitlement for housing granted in 2025 (entitlement_year: 2025).", "- Redevelopment strategy outlined in planning notes (mixed-use housing).", "- Open question: timing and phasing of construction and required infrastructure upgrades."], "for_a_developer": ["- Site size and parcel boundaries are not provided in the record.", "- Controlled by Tundra Realy since 2026, with entitlement approved for mixed-use housing.", "- No context-layer data (flood, transit, environment) are included to assess constraints.", "- Market signals are limited to the opp_score of 20.0 and housing‑focused opportunity reasons."], "risks_and_unknowns": ["- Exact demolition date and current construction status are not specified.", "- Site dimensions, parcel count, and ownership details beyond the two listed owners are missing.", "- Flood‑plain, transit access, and environmental constraints are absent from context layers.", "- Financial details such as outstanding debt, tax incentives, or construction costs are not provided.", "- The record is marked as ‘draft’ verified status, indicating some facts may be model‑extracted and unreviewed."], "data_quality": "partial", "one_line": "Northgate Mall opened 1972, lost anchors, closed 2026, demolished, now slated for mixed-use housing by Tundra Realy in Ohio today.", "model": "nvidia/nemotron-3-super-120b-a12b", "machine": "NVIDIA API via Hermes CT", "record_sha1": "670c32ee20f8"}, "cluster": {"within_10km": [{"id": "m-340d3077a1", "name": "Forest Fair Mall", "city": "Hamilton County", "status": "demolished", "km": 9.5}], "count_10km": 1, "count_25km": 9}, "edgar": {"query": "Northgate Mall", "city": "Northgate", "total": 684, "name_only_total": 26, "common_name": true, "sampled": 100, "latest": "2024-11-12", "earliest": "2001-03-19", "cmbs": [], "public": [{"name": "Feldman Mall Properties, Inc.", "cik": "0001299901", "n": 28, "first": "2005-05-02", "last": "2008-11-14", "forms": {"8-K": 17, "10-Q": 6, "10-K": 3, "8-K/A": 1}, "cmbs": false, "kind": "owner", "sic": "6798", "acc": "0000950153-08-001961", "doc": "p13563e8vk.htm", "adjacent": true}, {"name": "MACERICH CO  (MAC)", "cik": "0000912242", "n": 43, "first": "2001-03-29", "last": "2019-02-25", "forms": {"8-K": 20, "10-K": 17, "10-Q": 6}, "cmbs": false, "kind": "owner", "sic": "6798", "acc": "0000912242-19-000004", "doc": "mac-2018x1231x10k.htm", "adjacent": false}, {"name": "CBL & ASSOCIATES PROPERTIES INC  (CBL)", "cik": "0000910612", "n": 15, "first": "2011-11-02", "last": "2024-11-12", "forms": {"8-K": 15}, "cmbs": false, "kind": "owner", "sic": "6798", "acc": "0000950170-24-125320", "doc": "cbl-ex99_1.htm", "adjacent": false}, {"name": "GENERAL GROWTH PROPERTIES INC", "cik": "0000895648", "n": 6, "first": "2001-03-19", "last": "2010-03-01", "forms": {"8-K": 4, "10-K": 2}, "cmbs": false, "kind": "owner", "sic": "6798", "acc": "0001047469-10-001674", "doc": "a2196768zex-21.htm", "adjacent": false}, {"name": "CBL & ASSOCIATES LIMITED PARTNERSHIP", "cik": "0000915140", "n": 4, "first": "2014-02-05", "last": "2021-07-22", "forms": {"8-K": 4}, "cmbs": false, "kind": "owner", "sic": "6798", "acc": "0001564590-21-037489", "doc": "cbl-ex992_6.htm", "adjacent": false}, {"name": "General Growth Properties, Inc.", "cik": "0001496048", "n": 1, "first": "2011-03-08", "last": "2011-03-08", "forms": {"10-K": 1}, "cmbs": false, "kind": "owner", "sic": "6798", "acc": "0001047469-11-001829", "doc": "a2202295zex-21.htm", "adjacent": false}], "other": [{"name": "BJs RESTAURANTS INC  (BJRI)", "cik": "0001013488", "n": 2, "first": "2009-11-03", "last": "2012-05-15", "forms": {"8-K": 2}, "cmbs": false, "kind": "other", "sic": "5812", "acc": "0001171843-12-001893", "doc": "newsrelease.htm", "adjacent": false}, {"name": "BELK INC", "cik": "0001051771", "n": 2, "first": "2005-05-04", "last": "2005-07-11", "forms": {"8-K": 2}, "cmbs": false, "kind": "other", "sic": "5311", "acc": "0000950144-05-007290", "doc": "g96222exv99w3.txt", "adjacent": false}, {"name": "NORDSTROM INC  (JWN)", "cik": "0000072333", "n": 2, "first": "2012-11-01", "last": "2012-11-29", "forms": {"8-K": 2}, "cmbs": false, "kind": "other", "sic": "5651", "acc": "0001193125-12-484757", "doc": "d446202dex991.htm", "adjacent": false}, {"name": "J C PENNEY CO INC", "cik": "0001166126", "n": 1, "first": "2014-01-15", "last": "2014-01-15", "forms": {"8-K": 1}, "cmbs": false, "kind": "other", "sic": "5311", "acc": "0001166126-14-000003", "doc": "jcp-01152014xnewsrelease.htm", "adjacent": false}], "forms": {"8-K": 63, "10-K": 23, "10-Q": 12, "8-K/A": 1, "10-K/A": 1}, "url": "https://efts.sec.gov/LATEST/search/#/q=%22Northgate%20Mall%22%20%22Northgate%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": ["0001299901"], "adj_total": 7, "first_in_sample": null, "securitised": null, "vintage": null, "vintage_strong": false, "source": "SEC EDGAR full-text search"}, "elevation": {"elevation_ft": 870.3, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "env": {"count": 5, "facilities": [{"name": "BP FACILITY #8786", "programs": " ", "site_type": "", "flags": "", "brownfield": false}, {"name": "KROGER #908", "programs": " ", "site_type": "812922", "flags": "", "brownfield": false}, {"name": "KROGER #968-14", "programs": " ", "site_type": "445110", "flags": "", "brownfield": false}, {"name": "SEARS NO 1610", "programs": " ", "site_type": "45299", "flags": "", "brownfield": false}, {"name": "VILLAGE OF NORTHGATE HOMEOWNERS ASSOC", "programs": " ", "site_type": "", "flags": "", "brownfield": false}], "brownfield": false, "retrieved": "2026-10-15"}, "fifteen": {"grocery": 5, "schools": 1, "parks": 4, "health": 2, "civic": 1, "food_drink": 34, "cycleway_ways": 0, "sidewalk_ways": 136, "residential_buildings": 548, "categories_present": 6, "retrieved": "2026-10-15"}, "flood": {"zone": null, "note": "no NFHL polygon at point (unmapped or outside coverage)", "retrieved": "2026-10-15"}, "food_access": {"tract10": "39061020701", "urban": 1, "lila_1_10": 0, "low_access_1mi": 1, "lapop1share": 19.0479672311558, "poverty_rate": 7.00276042423362, "median_family_income": 73707.0, "snap_households": 124.0, "pop2010": 6881.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 266241, "month": "2026-09", "change_1y": 0.008, "change_5y": 0.242}, "zori": {"latest": 1468, "month": "2026-09", "change_1y": 0.024, "change_5y": 0.272}, "county_fips": "39061", "source": "Zillow Research (ZHVI, ZORI)"}, "hpi": {"year": 2025, "index": 386.6, "change_1y": 0.112, "change_5y": 0.602, "change_10y": 1.075, "base": "2000=100 (FHFA annual tract index, all-transactions)", "tract": "39061020701", "retrieved": "2026-10-20"}, "jobs_lodes": {"tract20": "39061020701", "jobs": 4907, "retail_jobs": 2081, "food_accommodation_jobs": 1043, "year": 2022, "source": "Census LEHD LODES8 WAC 2022 (all jobs, primary and secondary), blocks summed to the 2020 tract", "retrieved": "2026-10-20"}, "lihtc": {"count_1km": 0, "units_1km": 0, "li_units_1km": 0, "projects": [], "retrieved": "2026-10-16"}, "listings": {"zip": "45251", "month": "202609", "median_listing_price": 208250, "median_listing_price_yy": -0.2181, "active_listing_count": 54, "median_days_on_market": 39, "price_reduced_share": 0.1917, "pending_ratio": 0.9167, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "nrhp": {"count": 0, "places": [], "retrieved": "2026-10-15"}, "nri": {"tract": "39061020701", "risk_score": 69.9, "risk_rating": "Relatively Moderate", "eal_score": 65.6, "eal_rating": "Relatively Moderate", "expected_annual_loss_usd": 1815753, "social_vulnerability": "Relatively High", "community_resilience": "Relatively High", "hazards": {"hurricane": "Very Low", "tornado": "Very High", "inland flooding": "Relatively Moderate", "heat wave": "Relatively High", "wildfire": "Very Low", "earthquake": "Relatively Moderate", "hail": "Relatively Moderate", "strong wind": "Relatively Moderate", "winter weather": "Relatively Moderate", "landslide": "Relatively Low", "ice storm": "Relatively Low", "cold wave": "Relatively High", "lightning": "Relatively Moderate"}, "high_hazards": ["tornado", "heat wave", "cold wave"], "retrieved": "2026-10-16"}, "opportunity": {"tract10": "39061020701", "kfr_p25": 0.442, "jail_p25": 0.0028, "kids_count": 447.9717, "commuting_zone": "Cincinnati", "vintage": "children born 1978-83, outcomes measured 2014-15", "source": "Opportunity Insights, Opportunity Atlas (Chetty, Friedman, Hendren, Jones, Porter 2018)", "retrieved": "2026-10-20"}, "overture": {"candidates": 445, "place": {"id": "61722fc7-c3bc-4f63-9cb7-abb87abf72bc", "name": "Northgate Mall", "category": "shopping_mall", "operating_status": null, "websites": ["http://www.mynorthgatemall.com"], "socials": ["https://www.facebook.com/137598866308009"], "phones": ["(513) 385-5600"], "emails": ["customerservice@mynorthgatemall.com"], "address": {"freeform": "9501 Colerain Ave", "locality": "Cincinnati", "region": "OH", "postcode": "45251"}, "brand_wikidata": null, "confidence": 0.77, "lat": 39.24465650155089, "lon": -84.59888417732182, "providers": ["Foursquare", "Overture"], "km": 0.02, "match_score": 7, "explore": "https://explore.overturemaps.org/?feature=places.place.61722fc7-c3bc-4f63-9cb7-abb87abf72bc#17/39.24466/-84.59888"}, "retrieved": "2026-10-15", "building": {"id": "35f31e80-5826-4713-92ba-a3d4d81ad741", "area_m2": 73150, "height_m": null, "levels": null, "class": null, "names": null, "contains_point": true, "km": 0.06, "explore": "https://explore.overturemaps.org/?feature=buildings.building.35f31e80-5826-4713-92ba-a3d4d81ad741#17/39.24465/-84.59917"}, "large_buildings_nearby": 3, "buildings_done": true}, "oz": {"opportunity_zone": false, "tract": null, "rural": null, "retrieved": "2026-10-15"}, "pageviews": {"article": "Northgate_Mall_(Ohio)", "months": 136, "total": 42526, "last_12m": 5636, "prior_12m": 4275, "trend": 0.32, "peak_month": "202609", "peak_views": 1090, "series": [["201507", 232], ["201508", 208], ["201509", 145], ["201510", 214], ["201511", 201], ["201512", 239], ["201601", 230], ["201602", 237], ["201603", 240], ["201604", 219], ["201605", 220], ["201606", 203], ["201607", 218], ["201608", 264], ["201609", 232], ["201610", 195], ["201611", 251], ["201612", 326], ["201701", 317], ["201702", 267], ["201703", 308], ["201704", 283], ["201705", 285], ["201706", 294], ["201707", 285], ["201708", 272], ["201709", 199], ["201710", 243], ["201711", 305], ["201712", 328], ["201801", 281], ["201802", 223], ["201803", 310], ["201804", 260], ["201805", 236], ["201806", 209], ["201807", 308], ["201808", 354], ["201809", 322], ["201810", 372], ["201811", 410], ["201812", 401], ["201901", 327], ["201902", 270], ["201903", 274], ["201904", 293], ["201905", 319], ["201906", 246], ["201907", 295], ["201908", 306], ["201909", 263], ["201910", 237], ["201911", 297], ["201912", 490], ["202001", 822], ["202002", 463], ["202003", 377], ["202004", 281], ["202005", 453], ["202006", 240], ["202007", 267], ["202008", 318], ["202009", 251], ["202010", 200], ["202011", 271], ["202012", 381], ["202101", 346], ["202102", 320], ["202103", 312], ["202104", 245], ["202105", 205], ["202106", 212], ["202107", 251], ["202108", 201], ["202109", 211], ["202110", 211], ["202111", 238], ["202112", 331], ["202201", 290], ["202202", 258], ["202203", 357], ["202204", 320], ["202205", 333], ["202206", 276], ["202207", 347], ["202208", 341], ["202209", 286], ["202210", 339], ["202211", 277], ["202212", 364], ["202301", 333], ["202302", 323], ["202303", 334], ["202304", 269], ["202305", 279], ["202306", 269], ["202307", 334], ["202308", 333], ["202309", 326], ["202310", 274], ["202311", 382], ["202312", 391], ["202401", 309], ["202402", 317], ["202403", 408], ["202404", 245], ["202405", 275], ["202406", 293], ["202407", 261], ["202408", 270], ["202409", 220], ["202410", 212], ["202411", 264], ["202412", 315], ["202501", 338], ["202502", 259], ["202503", 287], ["202504", 233], ["202505", 322], ["202506", 481], ["202507", 400], ["202508", 548], ["202509", 398], ["202510", 430], ["202511", 465], ["202512", 451], ["202601", 412], ["202602", 361], ["202603", 370], ["202604", 346], ["202605", 430], ["202606", 464], ["202607", 399], ["202608", 827], ["202609", 1090], ["202610", 21]], "retrieved": "2026-10-15"}, "peers": {"peers": [{"id": "m-d752c4a2d8", "name": "Eastland Mall", "city": "Columbus", "state": "OH", "score": 8.0, "why": ["opened 1968", "closed 2022", "same strategy: redevelop"]}, {"id": "m-bfa5c9d5db", "name": "Lakeforest Mall", "city": "Gaithersburg", "state": "MD", "score": 7.0, "why": ["opened 1978", "closed 2023", "same strategy: redevelop"]}, {"id": "m-e6e8e6b6bc", "name": "Cache Valley Mall", "city": "Logan", "state": "UT", "score": 7.0, "why": ["opened 1976", "closed 2024", "same strategy: redevelop"]}, {"id": "m-ef78173074", "name": "Century III Mall", "city": "West Mifflin", "state": "PA", "score": 7.0, "why": ["opened 1979", "closed 2024", "same strategy: redevelop"]}, {"id": "m-8c7b6813ec", "name": "Chesterfield Mall", "city": "Chesterfield", "state": "MO", "score": 7.0, "why": ["opened 1976", "closed 2024", "same strategy: redevelop"]}, {"id": "m-f31114d100", "name": "Eastfield Mall", "city": "Springfield", "state": "MA", "score": 7.0, "why": ["opened 1967", "closed 2023", "same strategy: redevelop"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "Hamilton County", "2024": {"units_1": 566, "units_2_4": 39, "units_5plus": 217, "value_total": 367863820}, "2023": {"units_1": 534, "units_2_4": 41, "units_5plus": 654, "value_total": 430569981}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "39061", "year": 2025, "establishments": 2586, "employment": 38928, "avg_annual_pay": 39344, "lq_employment": 0.77, "employment_change_1y": -1.1, "source": "BLS QCEW 2025 annual, county, NAICS 44-45 retail trade, private", "retrieved": "2026-10-20"}, "retail_trend": {"2012": {"estab": 2828, "emp": 55188}, "2023": {"estab": 2518, "emp": 40920}, "estab_change": -0.11, "emp_change": -0.259, "county_fips": "39061"}, "schools": {"district": "Northwest Local School District", "district_geoid": "3904736", "grades": "PK-12", "district_vintage": "SY2024-25", "public_schools_1mi": 4, "schools": ["Colerain Elementary School", "Colerain High School", "Colerain Middle School", "Houston Educational Service and Early Childhood Center"], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "39061", "years": "2016-2025", "events": 324, "by_type": {"Thunderstorm Wind": 147, "Flash Flood": 71, "Hail": 57, "Flood": 41, "Tornado": 4, "Lightning": 3, "Heavy Rain": 1}, "property_damage_usd": 6576950, "deaths_direct": 2, "injuries_direct": 3, "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"}, "svi": {"tract": "39061020701", "overall_pct": 0.38, "socioeconomic_pct": 0.11, "household_pct": 0.28, "minority_pct": 0.48, "housing_transport_pct": 0.87, "pop": 7237, "poverty150_share": 14.2, "no_vehicle_share": 10.2, "minority_share": 31.2, "unemployed_share": 0, "retrieved": "2026-10-15"}, "tract": {"geoid": "39061020701", "pop": 6954, "pop_per_sqmi": 2117, "median_hh_income": 55706, "median_gross_rent": 964, "renter_share": 0.35, "vacancy_rate": 0.03, "transit_commute_share": 0.005, "retrieved": "2026-10-15"}, "tract_change": {"geoid": "39061020701", "y2013": {"pop": 6642, "median_hh_income": 53267, "renter_share": 0.212, "median_home_value": 143100}, "y2023": {"pop": 6954, "median_hh_income": 55706, "renter_share": 0.354, "median_home_value": 212000}, "retrieved": "2026-10-16", "pop_change": 0.047, "median_hh_income_change": 0.046, "renter_share_change": 0.142, "median_home_value_change": 0.481}, "traffic": {"max_aadt": 33251, "trucks_aadt": 878, "road": "COLERAIN AVE", "class": "principal arterial", "lanes": 4, "segments_600m": 10, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}, "walk": {"geoid": "390610207012", "walk_index": 15.2, "intersection_density": 143.8, "road_density": 20.5, "transit_distance_m": 620.0, "land_use_mix": 0.75, "jobs_per_acre": 6.12, "jobs_45min_auto": 59497, "jobs_45min_transit": 31848, "zero_car_share": 0.377, "pop": 978, "housing_units": 491, "acres_land": 237.0, "retrieved": "2026-10-15"}, "web": {"images": [{"title": "Northgate Mall Cincinnati OH | …", "page": "https://www.flickr.com/photos/66855546@N03/53177528280", "host": "flickr.com", "img": "https://live.staticflickr.com/65535/53177528280_b65d99b194_b.jpg", "engine": "bing images"}, {"title": "Former Express; Northgate Mall; Cincinnati OH", "page": "https://commons.wikimedia.org/wiki/File:Former_Express;_Northgate_Mall;_Cincinnati_OH.jpg", "host": "commons.wikimedia.org", "img": "https://upload.wikimedia.org/wikipedia/commons/8/84/Former_Express%3B_Northgate_Mall%3B_Cincinnati_OH.jpg", "engine": "wikicommons.images"}, {"title": "MallsCenters - US Shopping Malls & Stores", "page": "https://www.mallscenters.com/malls/ohio/northgate-mall-ohio", "host": "mallscenters.com", "img": "https://i.pinimg.com/originals/b5/61/9c/b5619c94ac1eca33b0bbb4fc63ed13d0.jpg", "engine": "pinterest"}, {"title": "Seattle Neighborhoods", "page": "http://www.seattlepi.com/local/seattle-history/article/Northgate-nation-s-first-suburban-mall-4286441.php#photo-1095651", "host": "seattlepi.com", "img": "https://i.pinimg.com/originals/16/21/23/162123bff94ce275fae97e5cea6966f4.jpg", "engine": "pinterest"}, {"title": "Northgate Mall - 13 Photos & 2…", "page": "https://www.yelp.com/biz/northgate-mall-cincinnati", "host": "yelp.com", "img": "https://s3-media3.fl.yelpcdn.com/bphoto/dFK9R38oO7UZSaMxGG7iRg/o.jpg", "engine": "bing images"}, {"title": "Northgate Mall Tattoos", "page": "https://fity.club/lists/suggestions/northgate-mall-tattoos/", "host": "fity.club", "img": "https://www.douglaswilson.com/wp-content/uploads/2018/02/northgate.jpg", "engine": "bing images"}, {"title": "Council Mulls Mall During Meeting At Northgate - MiddletownUSA.com", "page": "https://www.middletownusa.com/articles/council-mulls-mall-during-meeting-at-northgate", "host": "middletownusa.com", "img": "http://middletownusa.com/images/northgate-mall.jpg", "engine": "bing images"}, {"title": "A look inside Northgate Mall after multiple store closings. See photos", "page": "https://www.cincinnati.com/picture-gallery/news/2026/08/14/see-inside-northgate-mall-photos/83373143007/", "host": "cincinnati.com", "img": "https://i.pinimg.com/originals/81/fc/bf/81fcbf5e8ab634fd269e53a325db76ff.jpg", "engine": "pinterest"}], "refs": [], "query": "\"Northgate Mall\" Northgate OH", "retrieved": "2026-10-15"}, "web_presence": {"websites": ["http://www.mynorthgatemall.com"], "socials": ["https://www.facebook.com/137598866308009"], "phones": ["(513) 385-5600"], "platforms": ["facebook"], "overture_id": "61722fc7-c3bc-4f63-9cb7-abb87abf72bc", "website_status": 521, "website_final": "https://www.mynorthgatemall.com/", "website_alive": false, "retrieved": "2026-10-15", "wayback": null}}, "elements": [{"slug": "place-walkable", "name": "Walkable block group (EPA ≥ 12)", "group_": "place", "evidence": "index 15.2", "origin": "epa-walkability"}, {"slug": "place-15-minute", "name": "15-minute neighbourhood (5+ of 6 daily needs within 800 m)", "group_": "place", "evidence": "6/6", "origin": "openstreetmap"}, {"slug": "place-grocery-800m", "name": "Grocery within 800 m", "group_": "place", "evidence": "5 stores", "origin": "openstreetmap"}, {"slug": "place-hazard-tornado", "name": "High tornado risk", "group_": "place", "evidence": "Very High", "origin": "fema-nri"}, {"slug": "web-social-facebook", "name": "On Facebook", "group_": "finance", "evidence": "https://www.facebook.com/137598866308009", "origin": "overture"}, {"slug": "strategy-redevelop", "name": "Redeveloped", "group_": "strategy", "evidence": "mixed-use housing", "origin": "extraction"}, {"slug": "use-housing", "name": "Housing", "group_": "use", "evidence": "mixed-use housing mixed-use housing", "origin": "extraction"}, {"slug": "scale-big-footprint", "name": "Building footprint 50,000+ m²", "group_": "scale", "evidence": "73,150 m²", "origin": "overture"}, {"slug": "era-opened-1970s", "name": "Opened 1970s", "group_": "era", "evidence": "1972", "origin": "record"}, {"slug": "use-mixed", "name": "Mixed use", "group_": "use", "evidence": "mixed-use housing mixed-use housing", "origin": "extraction"}, {"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": "33,251 on COLERAIN AVE", "origin": "fhwa-hpms"}, {"slug": "place-prices-doubled", "name": "Tract house prices doubled in 10 years", "group_": "place", "evidence": "+108%", "origin": "fhfa"}, {"slug": "web-site-dead", "name": "Website dead or redirecting", "group_": "finance", "evidence": "http://www.mynorthgatemall.com", "origin": "overture / http check"}, {"slug": "anchor-sears", "name": "Sears", "group_": "anchor", "evidence": "Sears", "origin": "wikipedia"}, {"slug": "place-hazard-heat-wave", "name": "High heat wave risk", "group_": "place", "evidence": "Relatively High", "origin": "fema-nri"}, {"slug": "place-income-flat", "name": "Tract income flat or down since 2013", "group_": "place", "evidence": "+5%", "origin": "census-acs"}, {"slug": "era-closed-2020s", "name": "Closed 2020s", "group_": "era", "evidence": "2026", "origin": "extraction"}, {"slug": "finance-loan", "name": "Recorded loan", "group_": "finance", "evidence": "74000000.0 bank", "origin": "research-deals"}], "details": {}, "photos": [{"file": "https://retrofitatlas.org/img/northgate-northgate-mall.jpg", "author": "Greg Hume", "license": "CC BY-SA 4.0", "license_url": "https://creativecommons.org/licenses/by-sa/4.0", "source": "https://thumb.wikimedia.org/wikipedia/commons/thumb/a/a5/NorthgateMall.jpg/960px-NorthgateMall.jpg?utm_source=commons.wikimedia.org&utm_campaign=imageinfo&utm_content=thumbnail", "is_key": 1}, {"file": "https://thumb.wikimedia.org/wikipedia/commons/thumb/6/61/Colerain_sunset_2024.jpg/960px-Colerain_sunset_2024.jpg?utm_source=commons.wikimedia.org&utm_campaign=imageinfo&utm_content=thumbnail", "author": "Antony-22", "license": "CC BY-SA 4.0", "license_url": "https://creativecommons.org/licenses/by-sa/4.0", "source": "https://commons.wikimedia.org/wiki/File:Colerain_sunset_2024.jpg", "is_key": 0}], "provenance": {"*": "wikidata", "year_closed": "extraction", "developer": "extraction", "after_notes": "extraction", "status": "extraction", "strategy": "extraction", "new_use": "extraction", "zoning_change": "extraction", "entitlement_year": "extraction", "planning_notes": "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\": …}"}}