{"id": "n-2d8a345d6c", "slug": "aurora-mango-house", "type": "big-box", "name": "Mango House", "aka": [], "city": "Aurora", "county": "Arapahoe County", "state": "CO", "country": "US", "census_division": 8, "lat": 39.74014, "lon": -104.87334, "geocode_method": "nominatim-city", "address": null, "metro": null, "original_use": "JCPenney store", "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 news.cuanschutz.edu, model-extracted, unreviewed: Mango House, a former JCPenney store on Colfax Avenue in Aurora, now operates as a community center with medical clinics, refugee-run food stalls, and retail spaces serving underserved populations.", "strategy": ["reinhabit"], "new_use": ["civic", "healthcare", "other", "retail"], "share_retrofit": null, "status": "operating", "year_retrofit": null, "developer": "P.J. Parmar", "architect": null, "after_notes": "houses a medical clinic, a dental clinic, and a pharmacy, but it also is home to an international grocery store, a Nepalese boutique, and an array of six refugee-run food stalls offering authentic cuisine from Syria, Ethiopia, Sudan, Nepal, Burma, and more", "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": "08005", "opp_score": 0.0, "opp_reasons": ["retrofit already built", "median rent $1,812"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/big-box/co/aurora-mango-house/", "events": [], "sources": [{"id": 7841, "site_id": "n-2d8a345d6c", "url": "https://news.cuanschutz.edu/medicine/mango-house", "title": "Serving the Underserved - CU Anschutz newsroom", "publisher": "news.cuanschutz.edu", "date": null, "quote": "Mango House", "kind": "news", "license": null, "retrieved": "2026-10-18"}], "deals": [], "parties": [{"name": "P.J. Parmar", "kind": "developer", "role": "developer", "year_from": null, "year_to": null}], "parcels": [], "context": {"assessment": {"what_happened": "Mango House (Aurora, CO) was converted from a JCPenney store into a mixed-use space operating as a medical clinic, dental clinic, pharmacy, international grocery, Nepalese boutique, and six refugee-run food stalls (Syria, Ethiopia, Sudan, Nepal, Burma, etc.).", "why": "Developer P.J. Parmar executed a 'reinhabit' strategy. The site is verified as operating with median rent at $1,812. It is one of 11 developments within 10km of the site, including Stapleton International Airport (2.8km) and Buckingham Mall (5.2km).", "where_it_stands": "No vacancy rate or tenant count provided. No conversion year specified. Nearby context includes 27 developments within 25km. Retail establishments in the area decreased by 1.9% (2012–2023), but employment grew 7.4%.", "for_a_planner": ["Rental rate metric available ($1,812 median)", "Proximity to airport (2.8km) and existing mall (5.2km) noted", "No data on tenant turnover or lease terms"], "for_a_developer": ["Retrofit already completed (opp_reasons)", "Median rent data available", "No current vacancy rate or tenant mix details provided"], "risks_and_unknowns": ["No year of conversion", "No specific vacancy rate", "No details on lease terms or tenant retention", "No data on whether refugee food stalls are permanent or temporary"], "data_quality": "partial", "one_line": "Operating mixed-use retrofit (medical, retail, food) with verified median rent $1,812; retrofit already built; no conversion year or vacancy rate provided.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "9e57f32469a1"}, "cluster": {"within_10km": [{"id": "n-2e8a724f11", "name": "Stapleton International Airport", "city": "Denver", "status": "built", "km": 2.8}, {"id": "m-685f3c2586", "name": "Buckingham Mall", "city": "Aurora", "status": "built", "km": 5.2}, {"id": "n-aad5d93c49", "name": "Park Hill Golf Course", "city": "Denver", "status": "proposed", "km": 6.3}, {"id": "n-69f80451de", "name": "Cherry Lane", "city": "Denver", "status": "proposed", "km": 7.5}, {"id": "n-a525464130", "name": "Kmart at Monaco and Evans", "city": "Denver", "status": "proposed", "km": 7.7}, {"id": "n-d230d1a844", "name": "Sears in Cherry Creek", "city": "Denver", "status": "proposed", "km": 7.7}, {"id": "n-4742daa26a", "name": "Celebrity Sports Center", "city": "Denver", "status": "built", "km": 9.5}, {"id": "n-6454e0acd6", "name": "Former Park Hill Golf Club", "city": "Denver", "status": "proposed", "km": 9.5}, {"id": "n-928826c11a", "name": "Former K-Mart site", "city": "Denver", "status": "built", "km": 9.5}, {"id": "n-a5ddca1d49", "name": "Central Park", "city": "Denver", "status": "built", "km": 9.5}, {"id": "m-ac337791b4", "name": "Tamarac Square", "city": "Denver", "status": "operating", "km": 9.7}], "count_10km": 11, "count_25km": 27}, "elevation": {"elevation_ft": 5345.9, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "08005007302", "urban": 1, "lila_1_10": 0, "low_access_1mi": 0, "poverty_rate": 24.793842770753198, "median_family_income": 44947.0, "snap_households": 499.0, "pop2010": 4927.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 499630, "month": "2026-09", "change_1y": -0.021, "change_5y": 0.03}, "zori": {"latest": 1798, "month": "2026-09", "change_1y": -0.008, "change_5y": 0.068}, "county_fips": "08005", "source": "Zillow Research (ZHVI, ZORI)"}, "jobs_lodes": {"tract20": "08005007302", "jobs": 1194, "retail_jobs": 411, "food_accommodation_jobs": 153, "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": "80010", "month": "202609", "median_listing_price": 401750, "median_listing_price_yy": -0.0861, "active_listing_count": 82, "median_days_on_market": 45, "price_reduced_share": 0.4142, "pending_ratio": 0.2378, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "08005007302", "kfr_p25": 0.3439, "jail_p25": 0.0501, "kids_count": 1587.1302, "commuting_zone": "Denver", "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-0d13539e36", "name": "North Valley Mall", "city": "Thornton", "state": "CO", "score": 5.5, "why": ["same strategy: reinhabit", "also in CO", "15 km away"]}, {"id": "n-a292ba6d3e", "name": "Kmart at Belleview and Broadway", "city": "Englewood", "state": "CO", "score": 5.5, "why": ["same strategy: reinhabit", "also in CO", "16 km away"]}, {"id": "n-4742daa26a", "name": "Celebrity Sports Center", "city": "Denver", "state": "CO", "score": 5.0, "why": ["same strategy: reinhabit", "also in CO", "10 km away"]}, {"id": "n-b20ad25eb1", "name": "Former Bed Bath & Beyond", "city": "Norwalk", "state": "CT", "score": 4.0, "why": ["same strategy: reinhabit"]}, {"id": "n-6559af29e6", "name": "Pickle Pop", "city": "Santa Monica", "state": "CA", "score": 4.0, "why": ["same strategy: reinhabit"]}, {"id": "n-c1db8e6cf5", "name": "Verona Community Center", "city": "Verona", "state": "VA", "score": 4.0, "why": ["same strategy: reinhabit"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "Arapahoe County", "2024": {"units_1": 2362, "units_2_4": 45, "units_5plus": 1449, "value_total": 835586807}, "2023": {"units_1": 2293, "units_2_4": 16, "units_5plus": 3170, "value_total": 1212592396}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "08005", "year": 2025, "establishments": 1708, "employment": 31124, "avg_annual_pay": 50118, "lq_employment": 0.92, "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": 1867, "emp": 30953}, "2023": {"estab": 1832, "emp": 33241}, "estab_change": -0.019, "emp_change": 0.074, "county_fips": "08005"}, "schools": {"district": "Adams-Arapahoe School District 28J", "district_geoid": "0802340", "grades": "PK-12", "district_vintage": "SY2024-25", "public_schools_1mi": 14, "schools": ["New America School - Aurora", "Early Learning Center at New Legacy Charter School", "New Legacy Charter School", "Boston K-8 School", "Crawford Elementary School", "Fulton Academy of Excellence"], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "08005", "years": "2016-2025", "events": 231, "by_type": {"Hail": 158, "Thunderstorm Wind": 53, "Tornado": 11, "Flash Flood": 4, "Flood": 3, "Lightning": 1, "Heavy Rain": 1}, "property_damage_usd": 277316000, "deaths_direct": 2, "injuries_direct": 1, "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": 30000, "trucks_aadt": 750, "road": "U.S. 40", "class": "principal arterial", "lanes": 4, "segments_600m": 20, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}}, "elements": [{"slug": "strategy-reinhabit", "name": "Reinhabited", "group_": "strategy", "evidence": "houses a medical clinic, a dental clinic, and a pharmacy, but it also is home to an international grocery store, a Nepalese boutique, and an array of six refugee-run food stalls offering authentic cui", "origin": "record"}, {"slug": "use-medical", "name": "Medical and health", "group_": "use", "evidence": "houses a medical clinic, a dental clinic, and a pharmacy, but it also is hom", "origin": "newtypes-extraction"}, {"slug": "use-retail", "name": "Retail (continued)", "group_": "use", "evidence": "new_use field", "origin": "newtypes-extraction"}, {"slug": "place-mall-cluster", "name": "3+ other atlas sites within 10 km", "group_": "place", "evidence": "11 within 10 km", "origin": "computed"}, {"slug": "place-high-traffic", "name": "30,000+ vehicles a day on an adjacent road", "group_": "place", "evidence": "30,000 on U.S. 40", "origin": "fhwa-hpms"}, {"slug": "use-civic", "name": "Civic and government", "group_": "use", "evidence": "new_use field", "origin": "newtypes-extraction"}, {"slug": "use-grocery", "name": "Grocery", "group_": "use", "evidence": "ic, and a pharmacy, but it also is home to an international grocery store, a Nepalese boutique, and an array of six refugee-run", "origin": "newtypes-extraction"}], "details": {}, "photos": [], "provenance": {"after_notes": "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\": …}"}}