{"id": "n-f8c66e108f", "slug": "mechanicsville-columbia-at-mechanicsville-station", "type": "garden-apartments", "name": "Columbia at Mechanicsville Station", "aka": [], "city": "Mechanicsville", "county": "Cedar County", "state": "IA", "country": "US", "census_division": 4, "lat": 41.90446, "lon": -91.25461, "geocode_method": "nominatim-city", "address": null, "metro": null, "original_use": "housing", "year_opened": null, "year_closed": 2006, "acres": 41.0, "gla_sqft": null, "stores_peak": null, "levels": null, "original_developer": null, "original_architect": null, "before_notes": "Draft from Wikipedia, model-extracted, unreviewed: The 41-acre, 588-unit McDaniel-Glenn Homes in Mechanicsville were torn down in 2006 and replaced by Columbia at Mechanicsville Station.", "strategy": ["redevelop"], "new_use": ["housing"], "share_retrofit": null, "status": "built", "year_retrofit": null, "developer": null, "architect": null, "after_notes": "Replaced the 41 acres (17 ha) 588-unit McDaniel-Glenn Homes", "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": "19031", "opp_score": 0.0, "opp_reasons": ["retrofit already built", "41 acres", "housing in the record"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/garden-apartments/ia/mechanicsville-columbia-at-mechanicsville-station/", "events": [{"year": 2006, "date": null, "kind": "note", "detail": "McDaniel-Glenn Homes torn down", "source_id": 8930}, {"year": 2006, "date": null, "kind": "closed", "detail": "Closed", "source_id": null}], "sources": [{"id": 8929, "site_id": "n-f8c66e108f", "url": "https://en.wikipedia.org/wiki/Atlanta_mixed-income_communities", "title": "Atlanta mixed-income communities", "publisher": "Wikipedia", "date": null, "quote": "Columbia at Mechanicsville Station", "kind": "wikipedia", "license": "CC BY-SA 4.0", "retrieved": "2026-10-18"}, {"id": 8930, "site_id": "n-f8c66e108f", "url": "https://en.wikipedia.org/wiki/Atlanta_mixed-income_communities", "title": "Timeline", "publisher": null, "date": null, "quote": "torn down between February and May 2006.", "kind": "quote", "license": null, "retrieved": "2026-10-18"}], "deals": [], "parties": [], "parcels": [], "context": {"assessment": {"what_happened": "Columbia at Mechanicsville Station replaced the 2006-closed McDaniel-Glenn Homes (588 units, 41 acres) with new garden-apartment housing. The redevelopment is complete (status: built), with recent construction permits (2023-2024) totaling 20-63 units per year. The site’s opportunity score (0.0) is attributed to the retrofit being already built, its 41-acre size, and housing use. Context shows Cedar County housing values rising (5.5% YoY), but the site itself is no longer active for new development. Peer comparisons (e.g., Cottonwood Mall, Los Arcos Mall) reference similar-sized, redeveloped sites in other states, though this site’s status is distinct as completed.", "why": "Record explicitly states redevelopment is built, not pending. No active development or vacant land remains. Peer data reflects other sites in planning, not this completed project.", "where_it_stands": "Completed housing redevelopment on a 41-acre parcel. No further development activity indicated in record.", "for_a_planner": ["41-acre parcel now occupied by new housing", "Traffic: US 30 E (principal arterial, 5,600 ADT) serves site", "County housing market shows growth (ZHVI +5.5% YoY)"], "for_a_developer": ["No active opportunity: project already built", "No vacant land or pending permits beyond recent construction", "Peer sites (e.g., Cottonwood Mall) remain available for redevelopment"], "risks_and_unknowns": ["No current occupancy or housing type details provided", "No financials for new housing (e.g., rent, affordability)", "No indication of whether new housing meets local demand"], "data_quality": "partial", "one_line": "Completed 41-acre garden-apartment redevelopment on former McDaniel-Glenn Homes site; no active development opportunity remains.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "a048781707bb"}, "elevation": {"elevation_ft": 917.7, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "19031450200", "urban": 0, "lila_1_10": 0, "low_access_1mi": 0, "lapop1share": 99.9431070042477, "poverty_rate": 5.75170842824601, "median_family_income": 83558.0, "snap_households": 81.0, "pop2010": 3733.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 254794, "month": "2026-09", "change_1y": 0.055, "change_5y": 0.302}, "county_fips": "19031", "source": "Zillow Research (ZHVI, ZORI)"}, "jobs_lodes": {"tract20": "19031450200", "jobs": 455, "retail_jobs": 36, "food_accommodation_jobs": 30, "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": "52306", "month": "202609", "median_listing_price": 247925, "median_listing_price_yy": 0.5626, "active_listing_count": 2, "median_days_on_market": 70, "price_reduced_share": 0.0, "pending_ratio": 0.5, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "19031450200", "kfr_p25": 0.5309, "jail_p25": 0.0082, "kids_count": 359.9037, "commuting_zone": "Iowa City", "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-d1390721b9", "name": "Cottonwood Mall site", "city": "Holladay", "state": "UT", "score": 8.0, "why": ["similar size (57 acres)", "closed 2008", "same strategy: redevelop"]}, {"id": "m-9067acff67", "name": "Los Arcos Mall", "city": "Scottsdale", "state": "AZ", "score": 7.0, "why": ["similar size (41.9 acres)", "same strategy: redevelop"]}, {"id": "m-1a60792885", "name": "Winter Park Mall", "city": "Winter Park", "state": "FL", "score": 7.0, "why": ["similar size (40 acres)", "same strategy: redevelop"]}, {"id": "m-539ee169dc", "name": "University Mall", "city": "Little Rock", "state": "AR", "score": 7.0, "why": ["closed 2007", "same strategy: redevelop"]}, {"id": "m-21305c2a44", "name": "Town & Country Mall", "city": "Houston", "state": "TX", "score": 7.0, "why": ["similar size (50 acres)", "same strategy: redevelop"]}, {"id": "m-8005c9d0cf", "name": "Eastland Mall", "city": "North Versailles", "state": "PA", "score": 7.0, "why": ["similar size (57 acres)", "closed 2007", "same strategy: redevelop"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "Cedar County", "2024": {"units_1": 20, "units_2_4": 24, "units_5plus": 5, "value_total": 13687540}, "2023": {"units_1": 20, "units_2_4": 24, "units_5plus": 63, "value_total": 18496475}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "19031", "year": 2025, "establishments": 49, "employment": 568, "avg_annual_pay": 32803, "lq_employment": 1.1, "employment_change_1y": -4.1, "source": "BLS QCEW 2025 annual, county, NAICS 44-45 retail trade, private", "retrieved": "2026-10-20"}, "retail_trend": {"2012": {"estab": 59, "emp": 596}, "2023": {"estab": 55, "emp": 569}, "estab_change": -0.068, "emp_change": -0.045, "county_fips": "19031"}, "schools": {"district": "North Cedar Community School District", "district_geoid": "1917100", "grades": "PK-12", "district_vintage": "SY2024-25", "public_schools_1mi": 1, "schools": ["North Cedar Mechanicsville Elem Ctr"], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "19031", "years": "2016-2025", "events": 125, "by_type": {"Thunderstorm Wind": 66, "Hail": 39, "Tornado": 13, "Flash Flood": 4, "Funnel Cloud": 2, "Flood": 1}, "property_damage_usd": 353000, "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": 5600, "trucks_aadt": 867, "road": "US 30 E", "class": "principal arterial", "lanes": 2, "segments_600m": 33, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}}, "elements": [{"slug": "strategy-redevelop", "name": "Redeveloped", "group_": "strategy", "evidence": "Replaced the 41 acres (17 ha) 588-unit McDaniel-Glenn Homes", "origin": "record"}, {"slug": "use-housing", "name": "Housing", "group_": "use", "evidence": "new_use field", "origin": "newtypes-extraction"}, {"slug": "place-shrinking-county", "name": "Shrinking county", "group_": "place", "evidence": "-0.1%", "origin": "census-acs"}, {"slug": "era-closed-2000s", "name": "Closed 2000s", "group_": "era", "evidence": "2006", "origin": "newtypes-extraction"}], "details": {}, "photos": [], "provenance": {"year_closed": "newtypes-extraction", "acres": "newtypes-extraction", "status": "newtypes-extraction", "after_notes": "newtypes-extraction", "state": "census-geocoder"}, "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\": …}"}}