{"id": "n-a6a7c000ec", "slug": "detroit-frederick-stearns-building", "type": "industrial", "name": "Frederick Stearns Building", "aka": [], "city": "Detroit", "county": "Wayne County", "state": "MI", "country": "US", "census_division": 3, "lat": 42.34583333, "lon": -83.00666667, "geocode_method": "wikipedia", "address": null, "metro": null, "original_use": "manufacturing plant", "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 Wikipedia, model-extracted, unreviewed: The Frederick Stearns Building, originally a pharmaceutical manufacturing plant completed in 1899, was converted to condominiums in 1989 and is now known as the Lofts at Rivertown.", "strategy": ["reinhabit"], "new_use": ["housing"], "share_retrofit": null, "status": "built", "year_retrofit": null, "developer": null, "architect": null, "after_notes": "condominiums", "narrative": "The Frederick Stearns Building is a manufacturing plant located at 6533 East Jefferson Avenue in Detroit, Michigan. The building was listed on the National Register of Historic Places in 1980 and designated a Michigan State Historic Site in 1981. It has been converted to condominiums.\n\n\n== History ==\n\nFrederick Stearns & Company, established in 1855, was a leading pharmaceutical manufacturer in 19th century Detroit. In the late 1890s, Frederick K. Stearns (son of the firm's founder, Frederick A. Stearns) commissioned William B. Stratton to design this building (Stratton also designed Stearns's personal home, the Frederick K. Stearns House, a few years later).", "narrative_license": "CC BY-SA 4.0", "narrative_source": "https://en.wikipedia.org/wiki/Frederick_Stearns_Building", "zoning_change": null, "public_subsidy": null, "entitlement_year": null, "planning_notes": null, "wikidata_qid": "Q5498782", "wikipedia": "https://en.wikipedia.org/wiki/Frederick_Stearns_Building", "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": "26163", "opp_score": 0.0, "opp_reasons": ["retrofit already built", "housing in the record"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/industrial/mi/detroit-frederick-stearns-building/", "events": [], "sources": [{"id": 8863, "site_id": "n-a6a7c000ec", "url": "https://en.wikipedia.org/wiki/Frederick_Stearns_Building", "title": "Frederick Stearns Building", "publisher": "Wikipedia", "date": null, "quote": "Frederick Stearns Building", "kind": "wikipedia", "license": "CC BY-SA 4.0", "retrieved": "2026-10-18"}], "deals": [], "parties": [], "parcels": [], "context": {"assessment": {"what_happened": "Converted from manufacturing plant to condominiums (already built, per record).", "why": "Strategy: 'reinhabit' (adaptive reuse). Historic designation noted (National Register 1980, Michigan State Historic Site 1981), but record doesn't link this to conversion.", "where_it_stands": "Completed project; no current development opportunity (record states 'retrofit already built').", "for_a_planner": ["Housing market shows steady growth (ZHVI $175,631, +0.8% YoY; ZORI $1,402, +4.5% YoY).", "5 nearby developments within 10km (including industrial buildings, golf courses, and 1 temporary casino building).", "Peer projects in MI show similar 'reinhabit' strategy (e.g., 4km away MGM Grand temporary casino building, 18km Fairlane Town Center)."], "for_a_developer": ["Not a current opportunity (already built; 'opp_score' 0.0).", "No data on current occupancy, rent rates, or financials of the condominiums.", "No details on conversion costs or timeline."], "risks_and_unknowns": ["No vacancy rate or tenant data provided.", "No indication of how historic status influenced conversion process or costs.", "Record lacks post-conversion performance metrics."], "data_quality": "partial", "one_line": "Completed condo conversion of historic industrial building; not a current development opportunity.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "02bbc27861e1"}, "cluster": {"within_10km": [{"id": "n-2e46de2ba4", "name": "Rogell Golf Course", "city": "Detroit", "status": "built", "km": 3.6}, {"id": "n-721f36596a", "name": "Former MGM Grand Detroit temporary casino building", "city": "Detroit", "status": "built", "km": 3.6}, {"id": "n-7e2abc8bbb", "name": "Former Rogell Golf Course", "city": "Detroit", "status": "built", "km": 3.6}, {"id": "n-db06d3ef5b", "name": "Industrial Building", "city": "Detroit", "status": "operating", "km": 3.8}, {"id": "n-f82fd7da4e", "name": "Graybar Electric Company Building", "city": "Detroit", "status": "built", "km": 4.6}], "count_10km": 5, "count_25km": 13}, "elevation": {"elevation_ft": 599.0, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "26163516400", "urban": 1, "lila_1_10": 0, "low_access_1mi": 0, "poverty_rate": 28.9245982694685, "median_family_income": 24625.0, "snap_households": 121.0, "pop2010": 1095.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 175631, "month": "2026-09", "change_1y": 0.008, "change_5y": 0.207}, "zori": {"latest": 1402, "month": "2026-09", "change_1y": 0.045, "change_5y": 0.255}, "county_fips": "26163", "source": "Zillow Research (ZHVI, ZORI)"}, "jobs_lodes": {"tract20": "26163516400", "jobs": 388, "retail_jobs": 45, "food_accommodation_jobs": 24, "year": 2021, "source": "Census LEHD LODES8 WAC 2021 (all jobs, primary and secondary), blocks summed to the 2020 tract", "retrieved": "2026-10-20"}, "listings": {"zip": "48207", "month": "202609", "median_listing_price": 194000, "median_listing_price_yy": -0.0165, "active_listing_count": 82, "median_days_on_market": 95, "price_reduced_share": 0.1727, "pending_ratio": 0.2025, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "26163516400", "kfr_p25": 0.2674, "jail_p25": 0.0663, "kids_count": 309.8445, "commuting_zone": "Detroit", "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-25ded7d58a", "name": "Troy Community Center", "city": "Troy", "state": "MI", "score": 6.0, "why": ["same strategy: reinhabit", "also in MI", "27 km away"]}, {"id": "n-721f36596a", "name": "Former MGM Grand Detroit temporary casino building", "city": "Detroit", "state": "MI", "score": 6.0, "why": ["same strategy: reinhabit", "also in MI", "4 km away"]}, {"id": "m-3c282a4d8b", "name": "Fairlane Town Center", "city": "Dearborn", "state": "MI", "score": 5.5, "why": ["same strategy: reinhabit", "also in MI", "18 km away"]}, {"id": "m-7552410eb7", "name": "Bella Vista Mall", "city": "Grand Blanc", "state": "MI", "score": 5.0, "why": ["same strategy: reinhabit", "also in MI"]}, {"id": "m-8b336054cd", "name": "Grand Village Mall", "city": "Grandville", "state": "MI", "score": 5.0, "why": ["same strategy: reinhabit", "also in MI"]}, {"id": "m-884fc00b9d", "name": "Gibraltar Trade Center", "city": "Mount Clemens", "state": "MI", "score": 5.0, "why": ["same strategy: reinhabit", "also in MI", "31 km away"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "Wayne County", "2024": {"units_1": 1058, "units_2_4": 344, "units_5plus": 1227, "value_total": 437511890}, "2023": {"units_1": 956, "units_2_4": 230, "units_5plus": 718, "value_total": 314499766}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "26163", "year": 2025, "establishments": 5616, "employment": 64685, "avg_annual_pay": 41403, "lq_employment": 0.91, "employment_change_1y": 0.9, "source": "BLS QCEW 2025 annual, county, NAICS 44-45 retail trade, private", "retrieved": "2026-10-20"}, "retail_trend": {"2012": {"estab": 6083, "emp": 65615}, "2023": {"estab": 5635, "emp": 70575}, "estab_change": -0.074, "emp_change": 0.076, "county_fips": "26163"}, "schools": {"district": "Detroit Public Schools Community District", "district_geoid": "2601103", "grades": "PK-12", "district_vintage": "SY2024-25", "public_schools_1mi": 7, "schools": ["Detroit Academy of Arts and Sciences", "Detroit Academy of Arts and Sciences Middle School", "University Preparatory Science and Math PSAD High School", "Moses Field Center", "Bunche Preparatory Academy", "Martin Luther King Jr Senior High School"], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "26163", "years": "2016-2025", "events": 201, "by_type": {"Thunderstorm Wind": 138, "Hail": 20, "Flood": 19, "Flash Flood": 16, "Tornado": 8}, "property_damage_usd": 211185500, "deaths_direct": 1, "injuries_direct": 5, "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": 30533, "trucks_aadt": 825, "road": "E Jefferson Ave", "class": "principal arterial", "lanes": 4, "segments_600m": 29, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}}, "elements": [{"slug": "strategy-reinhabit", "name": "Reinhabited", "group_": "strategy", "evidence": "condominiums", "origin": "record"}, {"slug": "place-mall-cluster", "name": "3+ other atlas sites within 10 km", "group_": "place", "evidence": "5 within 10 km", "origin": "computed"}, {"slug": "use-housing", "name": "Housing", "group_": "use", "evidence": "new_use field", "origin": "newtypes-extraction"}, {"slug": "place-high-traffic", "name": "30,000+ vehicles a day on an adjacent road", "group_": "place", "evidence": "30,533 on E Jefferson Ave", "origin": "fhwa-hpms"}], "details": {}, "photos": [], "provenance": {"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\": …}"}}