{"id": "n-f377f332e8", "slug": "st-bernard-st-bernard-square", "type": "strip", "name": "St. Bernard Square", "aka": [], "city": "St. Bernard", "county": "Hamilton County", "state": "OH", "country": "US", "census_division": 3, "lat": 39.167, "lon": -84.49856, "geocode_method": "nominatim-city", "address": null, "metro": null, "original_use": "strip center", "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 soapboxmedia.com, model-extracted, unreviewed: St. Bernard Square was a strip center on Vine Street that is being redeveloped into 190 market-rate apartments and 5,000 square feet of retail space.", "strategy": ["redevelop"], "new_use": ["housing", "retail"], "share_retrofit": null, "status": "under construction", "year_retrofit": null, "developer": "Civitas Development", "architect": null, "after_notes": "190 units of market-rate apartments, and 5,000 square feet of retail space", "narrative": null, "narrative_license": null, "narrative_source": null, "zoning_change": null, "public_subsidy": "grant from Hamilton County", "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": "39061", "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/strips/oh/st-bernard-st-bernard-square/", "events": [], "sources": [{"id": 8620, "site_id": "n-f377f332e8", "url": "https://soapboxmedia.com/out-with-the-old-st-bernard-prepares-for-new-housing-retail/", "title": "Out with the old: A village makes way for new housing, retail, and ...", "publisher": "soapboxmedia.com", "date": null, "quote": "St. Bernard Square", "kind": "news", "license": null, "retrieved": "2026-10-18"}], "deals": [], "parties": [{"name": "Civitas Development", "kind": "developer", "role": "developer", "year_from": null, "year_to": null}], "parcels": [], "context": {"assessment": {"what_happened": "St. Bernard Square (St. Bernard, OH) is a strip center under construction, redeveloping into 190 market-rate apartments and 5,000 sq ft retail. Civitas Development leads the project with a Hamilton County grant. Nearby, Surrey Square Mall (3.8km) is closed, while Swifton Center (3.7km) and Tower Place Mall (7.5km) are unknown status. Housing market shows rising ZHVI (24% 5-year growth). The site is not a new opportunity per Retrofit Atlas (already under construction).", "why": "Status is 'under construction' and 'housing in the record' triggered opp_reasons. No new development opportunity exists per the database.", "where_it_stands": "No new opportunity; project is active. Context shows nearby closed mall (Surrey Square) and two unknown-status malls within 8km. Housing market trends support demand.", "for_a_planner": ["Nearby closed mall (Surrey Square) may indicate market shift. Traffic data (IR 75, 6 lanes) suggests accessibility."], "for_a_developer": ["Project is active; no new opportunity. Market-rate housing aligns with rising ZHVI (24% 5-year growth). Retail space (5,000 sq ft) is small."], "risks_and_unknowns": ["Original opening year unknown. No tenant details for retail. Status of Swifton/Tower Place malls unknown."], "data_quality": "partial", "one_line": "Active redevelopment (190 units, 5k sq ft retail) with county grant; not a new opportunity.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "65efc377e159"}, "cluster": {"within_10km": [{"id": "m-fda62a2697", "name": "Swifton Center", "city": "Cincinnati", "status": "unknown", "km": 3.7}, {"id": "m-94f26bc4bd", "name": "Surrey Square Mall", "city": "Norwood", "status": "closed", "km": 3.8}, {"id": "m-3a1a779e9d", "name": "Tower Place Mall", "city": "Cincinnati", "status": "unknown", "km": 7.5}], "count_10km": 3, "count_25km": 13}, "elevation": {"elevation_ft": 569.4, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "39061025800", "urban": 1, "lila_1_10": 0, "low_access_1mi": 0, "poverty_rate": 10.4477611940299, "median_family_income": 57369.0, "snap_households": 298.0, "pop2010": 4368.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)"}, "jobs_lodes": {"tract20": "39061025800", "jobs": 4356, "retail_jobs": 86, "food_accommodation_jobs": 114, "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": "45217", "month": "202609", "median_listing_price": 87450, "median_listing_price_yy": -0.6007, "active_listing_count": 14, "median_days_on_market": 72, "price_reduced_share": 0.2314, "pending_ratio": 0.5185, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "39061025800", "kfr_p25": 0.423, "jail_p25": 0.037, "kids_count": 494.4052, "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"}, "peers": {"peers": [{"id": "n-6d221998d1", "name": "Cincinnati–Blue Ash Airport", "city": "Blue Ash", "state": "OH", "score": 6.0, "why": ["same strategy: redevelop", "also in OH", "13 km away"]}, {"id": "m-df4cb8b48f", "name": "Beechmont Mall", "city": "Anderson Township", "state": "OH", "score": 5.5, "why": ["same strategy: redevelop", "also in OH", "16 km away"]}, {"id": "m-9d136a7521", "name": "City Centre Mart", "city": "Middletown", "state": "OH", "score": 5.5, "why": ["same strategy: redevelop", "also in OH", "40 km away"]}, {"id": "m-109f0836ff", "name": "Northgate Mall", "city": "Northgate", "state": "OH", "score": 5.0, "why": ["same strategy: redevelop", "also in OH", "12 km away"]}, {"id": "m-77b51c8531", "name": "Towne Mall Galleria", "city": "Middletown", "state": "OH", "score": 5.0, "why": ["same strategy: redevelop", "also in OH", "39 km away"]}, {"id": "n-94a89f6d83", "name": "CIC Industrial Park", "city": "Blue Ash", "state": "OH", "score": 5.0, "why": ["same strategy: redevelop", "also in OH", "13 km away"]}], "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": "St. Bernard-Elmwood Place City School District", "district_geoid": "3904471", "grades": "PK-12", "district_vintage": "SY2024-25", "public_schools_1mi": 3, "schools": ["North Avondale Montessori School", "St Bernard-Elmwood Place Elementary School", "St Bernard-Elmwood Place Junior/Senior High School"], "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"}, "traffic": {"max_aadt": 143590, "trucks_aadt": 23406, "road": "IR 75", "class": "Interstate", "lanes": 6, "segments_600m": 24, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}}, "elements": [{"slug": "use-retail", "name": "Retail (continued)", "group_": "use", "evidence": "0 units of market-rate apartments, and 5,000 square feet of retail space", "origin": "newtypes-extraction"}, {"slug": "place-mall-cluster", "name": "3+ other atlas sites within 10 km", "group_": "place", "evidence": "3 within 10 km", "origin": "computed"}, {"slug": "strategy-redevelop", "name": "Redeveloped", "group_": "strategy", "evidence": "190 units of market-rate apartments, and 5,000 square feet of retail space", "origin": "record"}, {"slug": "use-housing", "name": "Housing", "group_": "use", "evidence": "190 units of market-rate apartments, and 5,000 square feet of retail space", "origin": "newtypes-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": "143,590 on IR 75", "origin": "fhwa-hpms"}, {"slug": "place-freeway-frontage", "name": "Interstate or freeway within 600 m", "group_": "place", "evidence": "IR 75", "origin": "fhwa-hpms"}, {"slug": "status-pipeline", "name": "Retrofit in the pipeline", "group_": "finance", "evidence": "under construction", "origin": "record"}, {"slug": "policy-grant", "name": "Public grant or loan", "group_": "policy", "evidence": "grant from Hamilton County 190 units of market-rate apartments, a", "origin": "newtypes-extraction"}], "details": {}, "photos": [], "provenance": {"after_notes": "newtypes-extraction", "developer": "newtypes-extraction", "public_subsidy": "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\": …}"}}