{"id": "n-fd75d3ba74", "slug": "riverhead-former-walmart-store", "type": "big-box", "name": "Former Walmart store", "aka": [], "city": "Riverhead", "county": "Suffolk County", "state": "NY", "country": "US", "census_division": 2, "lat": 40.91687, "lon": -72.66242, "geocode_method": "nominatim-city", "address": null, "metro": null, "original_use": "retail 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 riverheadnewsreview.archive.timesreview.com, model-extracted, unreviewed: The former Walmart store on Route 58 in Riverhead is being considered for conversion into micro apartments under a town and county plan.", "strategy": ["redevelop"], "new_use": ["housing"], "share_retrofit": null, "status": "proposed", "year_retrofit": null, "developer": null, "architect": null, "after_notes": "micro apartments", "narrative": null, "narrative_license": null, "narrative_source": null, "zoning_change": "plan to allow conversion of empty big-box stores into apartments (county plan)", "public_subsidy": null, "entitlement_year": null, "planning_notes": "Approved by Riverhead Town and Suffolk County officials.", "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": "36103", "opp_score": 10.0, "opp_reasons": ["already in play: under construction, approved, or sold to a developer with housing plans", "median rent $2,190", "housing in the record"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/big-box/ny/riverhead-former-walmart-store/", "events": [], "sources": [{"id": 7015, "site_id": "n-fd75d3ba74", "url": "https://riverheadnewsreview.archive.timesreview.com/2020/08/riverhead-town-considering-plan-to-allow-conversion-of-empty-big-box-stores-into-apartments/", "title": "Riverhead Town considering plan to allow conversion of empty big ...", "publisher": "riverheadnewsreview.archive.timesreview.com", "date": null, "quote": "The former Walmart store on Route 58 in Riverhead.", "kind": "news", "license": null, "retrieved": "2026-10-18"}], "deals": [], "parties": [], "parcels": [], "context": {"assessment": {"what_happened": "Former Walmart store (big-box retail) in Riverhead, NY, proposed for conversion to housing (micro apartments).", "why": "Zoning change approved to allow big-box-to-apartment conversions (county plan). Approved by Riverhead Town and Suffolk County officials. Market validated: median rent $2,190, ZORI $3,352/month (2026-09).", "where_it_stands": "Status: proposed. No construction timeline provided. Nearest peer: Former Kmart (0km away, same strategy, proposed).", "for_a_planner": ["Zoning change aligns with county plan for big-box conversions.", "Housing demand supported by ZORI data ($3,352/month).", "Only 1 comparable site within 10km (Former Kmart)."], "for_a_developer": ["Approved conversion path exists.", "Market rent data matches proposed micro-apartment pricing.", "Status remains proposed; no construction start date confirmed."], "risks_and_unknowns": ["No developer name or project timeline listed.", "No details on construction costs or financing.", "Traffic data (23,663 ADT) not linked to housing viability."], "data_quality": "good", "one_line": "Proposed conversion of Riverhead Walmart to micro-apartments; approved by county, supported by housing market data, but no construction timeline.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "4d0bbd6a5bf1"}, "cluster": {"within_10km": [{"id": "n-d5e94412ed", "name": "Former Kmart", "city": "Riverhead", "status": "proposed", "km": 0.0}], "count_10km": 1, "count_25km": 1}, "elevation": {"elevation_ft": 7.3, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "36103169800", "urban": 1, "lila_1_10": 0, "low_access_1mi": 0, "poverty_rate": 23.0450047877434, "median_family_income": 67167.0, "snap_households": 275.0, "pop2010": 6156.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 729701, "month": "2026-09", "change_1y": 0.04, "change_5y": 0.274}, "zori": {"latest": 3352, "month": "2026-09", "change_1y": 0.068, "change_5y": 0.306}, "county_fips": "36103", "source": "Zillow Research (ZHVI, ZORI)"}, "jobs_lodes": {"tract20": "36103169800", "jobs": 6267, "retail_jobs": 1052, "food_accommodation_jobs": 479, "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": "11901", "month": "202609", "median_listing_price": 787000, "median_listing_price_yy": 0.1147, "active_listing_count": 69, "median_days_on_market": 68, "price_reduced_share": 0.1392, "pending_ratio": 0.3869, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "36103169800", "kfr_p25": 0.3596, "jail_p25": 0.0347, "kids_count": 637.5149, "commuting_zone": "New York", "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-d5e94412ed", "name": "Former Kmart", "city": "Riverhead", "state": "NY", "score": 6.5, "why": ["same strategy: redevelop", "also in NY", "0 km away"]}, {"id": "n-b53a0c35f5", "name": "Vacant box stores", "city": "Lake Grove", "state": "NY", "score": 6.5, "why": ["same strategy: redevelop", "also in NY", "39 km away"]}, {"id": "n-e5b205e244", "name": "Port Plaza shopping center", "city": "Port Jefferson Station", "state": "NY", "score": 6.0, "why": ["same strategy: redevelop", "also in NY", "34 km away"]}, {"id": "n-2b273b620d", "name": "Montauk Highway shopping district", "city": "East Patchogue", "state": "NY", "score": 6.0, "why": ["same strategy: redevelop", "also in NY", "33 km away"]}, {"id": "n-2ed4876441", "name": "J. N. Adam–AM&A Historic District", "city": "Buffalo", "state": "NY", "score": 4.5, "why": ["same strategy: redevelop", "also in NY"]}, {"id": "n-a07a4233fa", "name": "Hauppauge Industrial Park", "city": "Hauppauge", "state": "NY", "score": 4.5, "why": ["same strategy: redevelop", "also in NY"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "Suffolk County", "2024": {"units_1": 1137, "units_2_4": 10, "units_5plus": 260, "value_total": 914104542}, "2023": {"units_1": 1007, "units_2_4": 5, "units_5plus": 208, "value_total": 883390385}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "36103", "year": 2025, "establishments": 5685, "employment": 73266, "avg_annual_pay": 48753, "lq_employment": 1.07, "employment_change_1y": -0.3, "source": "BLS QCEW 2025 annual, county, NAICS 44-45 retail trade, private", "retrieved": "2026-10-20"}, "retail_trend": {"2012": {"estab": 6520, "emp": 78830}, "2023": {"estab": 6079, "emp": 77814}, "estab_change": -0.068, "emp_change": -0.013, "county_fips": "36103"}, "schools": {"district": "Riverhead Central School District", "district_geoid": "3624690", "grades": "PK-12", "district_vintage": "SY2024-25", "public_schools_1mi": 5, "schools": ["PHILLIPS AVENUE SCHOOL", "PULASKI STREET ELEMENTARY SCHOOL", "RIVERHEAD MIDDLE SCHOOL", "ROANOKE AVENUE SCHOOL", "SUFFOLK COUNTY SHERIFFS OFFICE"], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "36103", "years": "2016-2025", "events": 329, "by_type": {"Thunderstorm Wind": 179, "Flash Flood": 113, "Lightning": 13, "Hail": 13, "Tornado": 10, "Funnel Cloud": 1}, "property_damage_usd": 7583800, "deaths_direct": 1, "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": 23663, "trucks_aadt": 1329, "road": null, "class": "principal arterial", "lanes": null, "segments_600m": 39, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}}, "elements": [{"slug": "strategy-redevelop", "name": "Redeveloped", "group_": "strategy", "evidence": "micro apartments", "origin": "record"}, {"slug": "use-housing", "name": "Housing", "group_": "use", "evidence": "micro apartments Approved by Riverhead Town and Suffolk County officials.", "origin": "newtypes-extraction"}, {"slug": "place-rent-2000-plus", "name": "County typical rent $2,000+", "group_": "place", "evidence": "$3,352/mo", "origin": "zillow"}, {"slug": "status-pipeline", "name": "Retrofit in the pipeline", "group_": "finance", "evidence": "proposed", "origin": "newtypes-extraction"}], "details": {}, "photos": [], "provenance": {"status": "newtypes-extraction", "after_notes": "newtypes-extraction", "zoning_change": "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\": …}"}}