{"id": "n-0ec2928510", "slug": "columbia-pierce-pennant-motor-hotel", "type": "gas-station", "name": "Pierce Pennant Motor Hotel", "aka": [], "city": "Columbia", "county": "Boone County", "state": "MO", "country": "US", "census_division": 4, "lat": 38.96722222, "lon": -92.35888889, "geocode_method": "wikipedia", "address": null, "metro": null, "original_use": "hotel and garage complex", "year_opened": null, "year_closed": null, "acres": null, "gla_sqft": null, "stores_peak": null, "levels": null, "original_developer": "Pierce Petroleum Company", "original_architect": null, "before_notes": "Draft from Wikipedia, model-extracted, unreviewed: The Pierce Pennant Motor Hotel, a historic hotel and garage complex built in 1929, was converted to senior citizen housing in 1959.", "strategy": ["reinhabit"], "new_use": ["housing"], "share_retrofit": null, "status": "built", "year_retrofit": null, "developer": null, "architect": null, "after_notes": "senior citizen housing", "narrative": "The Pierce Pennant Motor Hotel, also known as the Candle Light Lodge, is a historic hotel complex that is located on what once was U.S. Route 40, which is now known as Business Loop 70 West in Columbia, Missouri.  The hotel complex was constructed in 1929 and is in the Colonial Revival style. The hotel was also a gas station and garage, and was owned by Pierce Petroleum Company, a subsidiary of Standard Oil. Initially the hotel and garage complex was to be one of several along U.S. Hwy 40, each to be spaced about 150 miles apart from New York to San Francisco. Senator Harry S.", "narrative_license": "CC BY-SA 4.0", "narrative_source": "https://en.wikipedia.org/wiki/Pierce_Pennant_Motor_Hotel", "zoning_change": null, "public_subsidy": null, "entitlement_year": null, "planning_notes": null, "wikidata_qid": "Q14704475", "wikipedia": "https://en.wikipedia.org/wiki/Pierce_Pennant_Motor_Hotel", "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": "29019", "opp_score": 0.0, "opp_reasons": ["retrofit already built", "county grew 5.3% 2018–23", "housing in the record"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/gas-stations/mo/columbia-pierce-pennant-motor-hotel/", "events": [], "sources": [{"id": 8973, "site_id": "n-0ec2928510", "url": "https://en.wikipedia.org/wiki/Pierce_Pennant_Motor_Hotel", "title": "Pierce Pennant Motor Hotel", "publisher": "Wikipedia", "date": null, "quote": "Pierce Pennant Motor Hotel", "kind": "wikipedia", "license": "CC BY-SA 4.0", "retrieved": "2026-10-18"}], "deals": [], "parties": [], "parcels": [], "context": {"assessment": {"what_happened": "Former hotel/garage complex (1929, Colonial Revival) owned by Pierce Petroleum Company, originally part of a U.S. Route 40 chain, was converted to a gas station. Now built as senior citizen housing.", "why": "Housing market shows strong growth (ZHVI up 28.5% 5y, ZORI up 46.2% 5y in Boone County). Retail establishments declined 6.3% but employment rose 4.7% (2012–2023). Peer projects in MO (Ely Walker Lofts, Price Chopper/Hobby Lobby) used same 'reinhabit' strategy.", "where_it_stands": "Status: built. 740 housing units permitted in Boone County (2024). Located near I-70 (4 lanes, 60,990 ADT).", "for_a_planner": ["Historic site (1929) repurposed for housing. Current housing demand validated by market metrics.", "Retail trend shows stability despite establishment decline."], "for_a_developer": ["Senior housing aligns with county housing market growth (ZHVI +28.5% 5y).", "Peer projects confirm 'reinhabit' strategy works in MO.", "No current occupancy data or retrofit details provided."], "risks_and_unknowns": ["Retrofit already built (no details on what was modified).", "No current occupancy rate or tenant mix for the housing. ", "Narrative mentions historic status but no preservation status or constraints."], "data_quality": "thin", "one_line": "Historic 1929 hotel/garage converted to senior housing in growing Boone County housing market; peer projects confirm strategy.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "6da108d35f27"}, "elevation": {"elevation_ft": 778.5, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "29019001400", "urban": 1, "lila_1_10": 0, "low_access_1mi": 1, "lapop1share": 31.003074274600202, "poverty_rate": 9.49092660992452, "median_family_income": 82817.0, "snap_households": 457.0, "pop2010": 11433.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 328757, "month": "2026-09", "change_1y": 0.025, "change_5y": 0.285}, "zori": {"latest": 1463, "month": "2026-09", "change_1y": 0.055, "change_5y": 0.462}, "county_fips": "29019", "source": "Zillow Research (ZHVI, ZORI)"}, "jobs_lodes": {"tract20": "29019001402", "jobs": 3049, "retail_jobs": 240, "food_accommodation_jobs": 178, "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": "65202", "month": "202609", "median_listing_price": 299900, "median_listing_price_yy": -0.0323, "active_listing_count": 139, "median_days_on_market": 39, "price_reduced_share": 0.2398, "pending_ratio": 0.1083, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "29019001400", "kfr_p25": 0.4104, "jail_p25": 0.0242, "kids_count": 753.7568, "commuting_zone": "Columbia", "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-215d12339c", "name": "Ely Walker Lofts", "city": "St. Louis", "state": "MO", "score": 4.5, "why": ["same strategy: reinhabit", "also in MO"]}, {"id": "n-b183e79e72", "name": "Price Chopper and Hobby Lobby", "city": "Gladstone", "state": "MO", "score": 4.5, "why": ["same strategy: reinhabit", "also in MO"]}, {"id": "m-e594aa16bf", "name": "100 Oaks Mall", "city": "Nashville", "state": "TN", "score": 4.0, "why": ["same strategy: reinhabit"]}, {"id": "m-0828e55f1a", "name": "Buford Clairmont Mall", "city": "Chamblee", "state": "GA", "score": 4.0, "why": ["same strategy: reinhabit"]}, {"id": "m-e41df3b63e", "name": "Allegheny Center Mall", "city": "Pittsburgh", "state": "PA", "score": 4.0, "why": ["same strategy: reinhabit"]}, {"id": "m-fd0c314b04", "name": "Westgate Mall", "city": "Bangor", "state": "ME", "score": 4.0, "why": ["same strategy: reinhabit"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "Boone County", "2024": {"units_1": 740, "units_2_4": 14, "units_5plus": 549, "value_total": 375570429}, "2023": {"units_1": 596, "units_2_4": 4, "units_5plus": 56, "value_total": 236649787}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "29019", "year": 2025, "establishments": 544, "employment": 10530, "avg_annual_pay": 37687, "lq_employment": 1.06, "employment_change_1y": 1.3, "source": "BLS QCEW 2025 annual, county, NAICS 44-45 retail trade, private", "retrieved": "2026-10-20"}, "retail_trend": {"2012": {"estab": 622, "emp": 11597}, "2023": {"estab": 583, "emp": 12139}, "estab_change": -0.063, "emp_change": 0.047, "county_fips": "29019"}, "schools": {"district": "Columbia 93 School District", "district_geoid": "2901000", "grades": "PK-12", "district_vintage": "SY2024-25", "public_schools_1mi": 2, "schools": ["WEST BLVD. ELEM.", "WEST MIDDLE SCHOOL"], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "29019", "years": "2016-2025", "events": 96, "by_type": {"Thunderstorm Wind": 58, "Hail": 17, "Flash Flood": 15, "Tornado": 3, "Lightning": 2, "Flood": 1}, "property_damage_usd": 247000, "deaths_direct": 0, "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": 60990, "trucks_aadt": 14934, "road": "70", "class": "Interstate", "lanes": 4, "segments_600m": 19, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}}, "elements": [{"slug": "strategy-reinhabit", "name": "Reinhabited", "group_": "strategy", "evidence": "senior citizen housing", "origin": "record"}, {"slug": "use-housing", "name": "Housing", "group_": "use", "evidence": "senior citizen housing", "origin": "newtypes-extraction"}, {"slug": "place-high-traffic", "name": "30,000+ vehicles a day on an adjacent road", "group_": "place", "evidence": "60,990 on 70", "origin": "fhwa-hpms"}, {"slug": "place-freeway-frontage", "name": "Interstate or freeway within 600 m", "group_": "place", "evidence": "70", "origin": "fhwa-hpms"}], "details": {}, "photos": [], "provenance": {"original_developer": "newtypes-extraction", "after_notes": "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\": …}"}}