# Parcel Ledger · Full Machine-Readable Corpus & Citation Reference (https://realestate.meruai.co) > Multi-agency real estate, building-safety, house-flip margin, HUD Fair Market Rent, and corporate landlord LLC observatory reconciling 5,595,895 raw rows across 61 primary federal, state, county, and municipal feeds (4,466,654 personal PII cells purged), published by Meru AI (https://meruai.co/). ## 1. Dataset Metadata & Canonical Citation - **Title**: Parcel Ledger: Reconciled U.S. House-Flip Margins, California Distress & ADU Leads, NYC Building Safety Pairs, and Landlord LLC Portfolios - **Canonical URL**: https://realestate.meruai.co/ - **Primary Federal, State & Municipal Sources**: U.S. HUD (Multifamily & Fair Market Rents), FHFA (House Price Index), U.S. Census BPS, CAL FIRE, CA HCD, NYC Open Data (DOB, HPD, DOF, MapPLUTO), and County Assessors/Recorders (61 primary feeds) - **Publication ID**: `9dc35e6bc8abb762da04` - **Snapshot Date**: `2026-11-15` - **Temporal Coverage**: `2018/2026` - **Indexed Sitemap Routes**: 6,378 canonical URLs (https://realestate.meruai.co/sitemap.xml) - **Structured Citation JSON**: https://realestate.meruai.co/citation-summary.json ### Canonical Citation String ```text Meru AI (2026). Parcel Ledger: Reconciled U.S. House-Flip Margins, Southern California & Silicon Valley Distress & SB-9/ADU Leads, NYC Building Safety Pairs, and Landlord LLC Portfolios (Publication 9dc35e6bc8abb762da04). Retrieved from https://realestate.meruai.co/ ``` ### Markdown Citation ```markdown [Parcel Ledger: Reconciled U.S. Property, Building Safety & Ownership Archive (Publication 9dc35e6b, 2026-11-15)](https://realestate.meruai.co/) · Meru AI Public Intelligence, sourced from HUD, FHFA, Census & Municipal Open Data. ``` ### BibTeX ```bibtex @misc{meruai_realestate_2026, author = {{Meru AI}}, title = {{Parcel Ledger: Reconciled U.S. House-Flip Margins, California Distress Leads, NYC Building Safety Pairs, and Landlord LLC Portfolios}}, year = {2026}, note = {Publication 9dc35e6bc8abb762da04, Snapshot 2026-11-15}, howpublished = {\url{https://realestate.meruai.co/}} } ``` ## 2. Seven-County California Distress, ARV & 70%-Rule MAO Benchmarks | County | Reconciled Leads | Median Est. ARV | Median Rehab Capex | Median 70% MAO | HUD FMR / Mo | 5Y FHFA HPI | | --- | ---: | ---: | ---: | ---: | ---: | ---: | | Santa Clara County | 17,039 | $1,970,000 | $122,000 | $1,196,000 | $3,193 | +27.43% | | Los Angeles County | 14,327 | $1,934,500 | $55,500 | $1,211,000 | $2,919 | +28.11% | | San Mateo County | 4,280 | $5,023,000 | $233,000 | $3,283,000 | N/A | N/A | | San Diego County | 3,583 | $1,769,000 | $116,000 | $1,023,500 | $3,001 | +40.84% | | Riverside County | 1,914 | $1,658,500 | $137,000 | $1,026,500 | $2,201 | +35.91% | | Orange County | 1,372 | $1,409,000 | $96,500 | $900,000 | $2,919 | +28.11% | | San Bernardino County | 748 | $596,000 | $45,000 | $367,000 | $2,201 | +35.91% | ## 3. Five-Borough NYC Adjacent Excavation & Building Age Risk Summary | Borough | Full-Ledger Pairs | Stratified Sample | High-Priority Sample | Active Stop-Work Nearby | Missing BC 3309 | | --- | ---: | ---: | ---: | ---: | ---: | | Brooklyn | 4,935 | 60 | 60 | 59 | 54 | | Manhattan | 1,597 | 60 | 60 | 58 | 34 | | Queens | 969 | 60 | 49 | 56 | 52 | | Bronx | 738 | 60 | 34 | 47 | 53 | | Staten Island | 68 | 60 | 0 | 47 | 38 | ## 4. Top 20 U.S. State Housing & Portfolio Hubs | State Hub | Canonical URL | Total Filings | Median HUD Rent | Median 5Y HPI | | --- | --- | ---: | ---: | ---: | | TX Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-tx | 1,459,625 | $1,015/mo | +34.4% | | NY Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-ny | 1,323,715 | $1,185/mo | +49.9% | | CA Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-ca | 1,319,262 | $1,625/mo | +28.1% | | FL Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-fl | 798,011 | $1,155/mo | +46.0% | | IL Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-il | 489,732 | $916/mo | +46.9% | | NJ Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-nj | 470,837 | $1,950/mo | +58.3% | | NC Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-nc | 453,520 | $952/mo | +51.4% | | OH Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-oh | 366,606 | $482/mo | +48.1% | | GA Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-ga | 357,253 | $973/mo | +47.6% | | MA Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-ma | 329,941 | $508/mo | +41.9% | | TN Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-tn | 285,824 | $925/mo | +50.0% | | MI Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-mi | 285,465 | $973/mo | +45.6% | | PA Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-pa | 266,434 | $457/mo | +44.2% | | VA Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-va | 256,000 | $1,044/mo | +44.1% | | MD Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-md | 251,883 | $451/mo | +32.0% | | WA Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-wa | 248,036 | $1,273/mo | +29.7% | | IN Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-in | 239,044 | $956/mo | +46.7% | | MN Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-mn | 233,268 | $973/mo | +31.2% | | AZ Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-az | 223,118 | $448/mo | +36.3% | | SC Housing Markets & Multi-LLC Portfolios | https://realestate.meruai.co/markets/state-sc | 202,895 | $902/mo | +54.9% | ## 5. Top 20 California Acquisition & ADU 5-Digit ZIP Cohorts | ZIP Cohort | Canonical URL | Parcel Leads | Avg Est. ARV | Avg 70% MAO | | --- | --- | ---: | ---: | ---: | | ZIP 94306 (Palo Alto, CA) | https://realestate.meruai.co/markets/ca-zip-94306 | 2,213 | $2,857,298 | $1,901,152 | | ZIP 94303 (Palo Alto, CA) | https://realestate.meruai.co/markets/ca-zip-94303 | 1,866 | $2,920,384 | $1,944,274 | | ZIP 94301 (Palo Alto, CA) | https://realestate.meruai.co/markets/ca-zip-94301 | 1,764 | $3,470,950 | $2,333,042 | | ZIP 90019 (Los Angeles, CA) | https://realestate.meruai.co/markets/ca-zip-90019 | 1,707 | $1,350,689 | $796,443 | | ZIP 95112 (San Jose, CA) | https://realestate.meruai.co/markets/ca-zip-95112 | 1,032 | $1,622,791 | $942,998 | | ZIP 95125 (San Jose, CA) | https://realestate.meruai.co/markets/ca-zip-95125 | 718 | $2,133,872 | $1,294,770 | | ZIP 95116 (San Jose, CA) | https://realestate.meruai.co/markets/ca-zip-95116 | 562 | $1,427,747 | $803,577 | | ZIP 95124 (San Jose, CA) | https://realestate.meruai.co/markets/ca-zip-95124 | 512 | $2,019,184 | $1,228,477 | | ZIP 95122 (San Jose, CA) | https://realestate.meruai.co/markets/ca-zip-95122 | 497 | $1,318,074 | $751,002 | | ZIP 95126 (San Jose, CA) | https://realestate.meruai.co/markets/ca-zip-95126 | 463 | $1,725,205 | $1,007,315 | | ZIP 95127 (San Jose, CA) | https://realestate.meruai.co/markets/ca-zip-95127 | 433 | $1,447,790 | $830,942 | | ZIP 95111 (San Jose, CA) | https://realestate.meruai.co/markets/ca-zip-95111 | 414 | $1,433,229 | $821,751 | | ZIP 94010 (San Mateo, CA) | https://realestate.meruai.co/markets/ca-zip-94010 | 397 | $3,243,509 | $2,073,055 | | ZIP 94062 (Woodside, CA) | https://realestate.meruai.co/markets/ca-zip-94062 | 383 | $3,334,104 | $2,107,747 | | ZIP 90272 (Pacific Plsds, CA) | https://realestate.meruai.co/markets/ca-zip-90272 | 348 | $3,796,526 | $2,386,003 | | ZIP 95128 (San Jose, CA) | https://realestate.meruai.co/markets/ca-zip-95128 | 333 | $1,749,039 | $1,024,832 | | ZIP 95129 (San Jose, CA) | https://realestate.meruai.co/markets/ca-zip-95129 | 328 | $2,035,241 | $1,201,405 | | ZIP 94025 (Redwood City, CA) | https://realestate.meruai.co/markets/ca-zip-94025 | 327 | $3,725,792 | $2,409,566 | | ZIP 94080 (South San Francisco, CA) | https://realestate.meruai.co/markets/ca-zip-94080 | 314 | $1,850,975 | $1,118,019 | | ZIP 95110 (San Jose, CA) | https://realestate.meruai.co/markets/ca-zip-95110 | 312 | $1,550,990 | $895,750 | ## 6. Top 20 NYC Building Safety & Excavation 5-Digit ZIP Cohorts | NYC ZIP Cohort | Canonical URL | Risk Pairs | Mean Risk Score | Stop-Work Nearby | | --- | --- | ---: | ---: | ---: | | ZIP 11215 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11215 | 282 | 62.6/100 | 200 pairs | | ZIP 11219 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11219 | 249 | 60.2/100 | 194 pairs | | ZIP 11223 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11223 | 248 | 59.7/100 | 192 pairs | | ZIP 11221 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11221 | 242 | 64.0/100 | 179 pairs | | ZIP 11220 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11220 | 240 | 62.4/100 | 171 pairs | | ZIP 11204 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11204 | 233 | 60.5/100 | 206 pairs | | ZIP 11218 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11218 | 228 | 59.1/100 | 168 pairs | | ZIP 11206 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11206 | 223 | 64.6/100 | 158 pairs | | ZIP 11211 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11211 | 223 | 64.0/100 | 163 pairs | | ZIP 11231 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11231 | 219 | 65.5/100 | 138 pairs | | ZIP 11216 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11216 | 194 | 61.1/100 | 131 pairs | | ZIP 11217 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11217 | 188 | 63.1/100 | 130 pairs | | ZIP 11205 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11205 | 184 | 64.5/100 | 144 pairs | | ZIP 11230 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11230 | 180 | 61.1/100 | 147 pairs | | ZIP 11233 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11233 | 167 | 58.5/100 | 71 pairs | | ZIP 10014 (Manhattan, NY) | https://realestate.meruai.co/markets/nyc-zip-10014 | 166 | 60.8/100 | 48 pairs | | ZIP 11213 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11213 | 162 | 61.0/100 | 126 pairs | | ZIP 11222 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11222 | 156 | 62.9/100 | 118 pairs | | ZIP 11238 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11238 | 151 | 61.2/100 | 96 pairs | | ZIP 11207 (Brooklyn, NY) | https://realestate.meruai.co/markets/nyc-zip-11207 | 122 | 59.4/100 | 84 pairs | ## 7. Primary Source Checksum Sample (First 25 of 61 Feeds) | Source ID | Rows | SHA-256 Checksum | Official URL | | --- | ---: | --- | --- | | census_gaz_counties | 3,222 | `3c337402b5c6e8d5aa26b4278ccf4edc8989f2683765b3ffbf22296cdb2df3a0` | https://www2.census.gov/geo/docs/maps-data/data/gazetteer/2024_Gazetteer/2024_Gaz_counties_national.zip | | census_gaz_zcta | 33,791 | `7b85c04a131672f58b38a950eb82855d5fd4054f0bd9bc3f69aa28897a714e3d` | https://www2.census.gov/geo/docs/maps-data/data/gazetteer/2024_Gazetteer/2024_Gaz_zcta_national.zip | | fhfa_hpi_master | 186,031 | `5b60e562c74211475d6bad8f59d24c74316f31f956d922f6e9d97065393b0feb` | https://www.fhfa.gov/hpi/download/monthly/hpi_master.csv | | census_bps_county_2024 | 3,028 | `a64c2dd19be96c469763c10d637575a584ef16a6878f451bba80c847bcafc8c6` | https://www2.census.gov/econ/bps/County/co2024a.txt | | census_bps_county_2023 | 3,029 | `fab11d759e905ff61838b8dfa41c0f2082e150cad07a20c65ddd620a007aa158` | https://www2.census.gov/econ/bps/County/co2023a.txt | | census_bps_county_2022 | 3,033 | `0a88c16861ede81b04f8785e1c626e772510f33f1de9452f7592d86d308e2b5c` | https://www2.census.gov/econ/bps/County/co2022a.txt | | hud_fmr_areas | 2,622 | `f42ad0d8a9f06c5a3ba425cdf6a96b4704ac5be22aa426275fed5a6f37fbbd0a` | https://services.arcgis.com/VTyQ9soqVukalItT/arcgis/rest/services/Fair_Market_Rents/FeatureServer/0/query | | hud_multifamily_assisted | 23,771 | `f34a752d03d0446d792d7727ef400eef569981b70908b527c82da9e362964ed8` | https://services.arcgis.com/VTyQ9soqVukalItT/arcgis/rest/services/Multifamily_Properties_Assisted/FeatureServer/0/query | | hud_multifamily_insured | 17,792 | `c26642b43650130f50454e3ba795298f9985f3f69a0e81e9432ad367621f79e6` | https://services.arcgis.com/VTyQ9soqVukalItT/arcgis/rest/services/HUD_Insured_Multifamily_Properties/FeatureServer/0/query | | nyc_hpd_registrations | 187,127 | `71bd608f8b8ed5b01a875e07e358dca1779c4feaa23ebef8460c13e228eb6aa1` | https://data.cityofnewyork.us/resource/tesw-yqqr.json | | nyc_hpd_contacts | 744,753 | `2b0b03048961a992c9b469424cc95f07159a9bacc677cc467395eb021a9683d2` | https://data.cityofnewyork.us/resource/feu5-w2e2.json | | nyc_annual_sales | 431,864 | `36161924c82e504289d6afca0eb553bcaa10dab53832fe93a329ee774a5c6fa3` | https://data.cityofnewyork.us/resource/w2pb-icbu.json | | nyc_hpd_violations | 355,540 | `cefcaa63fd8c2f6a1db1cfcf55d5b480dcab486177abe81ae4871ad4a8bb929e` | https://data.cityofnewyork.us/resource/wvxf-dwi5.json | | nyc_oath_ecb_construction | 47,971 | `1ca870c7767cd5182fab596a70eb796292c939e8edfdb67e6de6421a04452445` | https://data.cityofnewyork.us/resource/6bgk-3dad.json | | nyc_dob_excavation_permits | 38,285 | `4d23be7fbfd703fdccb0d26b007af3230f152254f6c149a3092050bb03fd6d9d` | https://data.cityofnewyork.us/resource/rbx6-tga4.json | | nyc_dob_job_filings | 40,925 | `a83fe32d34d8c4c74843b66ff495b39aa4d07d6e3bea4b378454b10db8f31186` | https://data.cityofnewyork.us/resource/w9ak-ipjd.json | | nyc_311_dob_structural | 26,355 | `cace38ee8345f4468c0e78d71a315d0c04e676bb2cf281cc0124b7ae5116ce02` | https://data.cityofnewyork.us/resource/erm2-nwe9.json | | cook_parcel_sales | 476,356 | `d5021c04b5c641664a0044bc6233aa6787f7a3ae0400a32d4905cfbb41b1d5d5` | https://datacatalog.cookcountyil.gov/resource/wvhk-k5uv.json | | chicago_rehab_permits | 165,851 | `67d199e5de1a5a3695dbccf869c61add0d2a54abe3aa2578fc121616aaa248a0` | https://data.cityofchicago.org/resource/ydr8-5enu.json | | chicago_code_violations | 189,230 | `d1460f40ff4580eacec2fcef0a81f5ed18da5cb7b74b4eb2ba880a8c1403372b` | https://data.cityofchicago.org/resource/22u3-xenr.json | | la_rehab_permits | 313,965 | `d251e8f3b4cd96a0938f0ae60b1413761cadf7027553677a8e545fd647b80a3e` | https://data.lacity.org/resource/pi9x-tg5x.json | | la_code_enforcement | 28,772 | `8a1f65d756dcb0e4971f381576413ff5a5995e7d85935560429f98ff6ebe3afe` | https://data.lacity.org/resource/u82d-eh7z.json | | sf_rehab_permits | 144,212 | `e6c38d413a9b39adf2f1639f5eb0f5c9646a182f95bcfd486d07b6ccd44b064d` | https://data.sfgov.org/resource/i98e-djp9.json | | sf_dbi_violations | 76,025 | `e1a9c5a658b558fb1b92f672f74ca8094b18ba5e95a9c26ede7a8b5425132b0e` | https://data.sfgov.org/resource/nbtm-fbw5.json | | seattle_rehab_permits | 42,773 | `174880463c80de47e14b6f8a9bb2baaacfddc31ad23989031a2ba9a55fbc10ab` | https://data.seattle.gov/resource/76t5-zqzr.json | ## 8. Cornerstone Empirical Studies & Meru AI Ecosystem Links - [NYC Adjacent Excavation, Active Stop-Work Orders Nearby, and Adjacent Excavation & Building Age Risk: A 5-Borough Study](https://realestate.meruai.co/insights/nyc-adjacent-excavation-building-collapse-risk): Spatial study of 8,307 NYC building-to-excavation risk pairs, 3-tier link provenance, 1321 Flatbush Ave records, and NYC BC 3309 prevention steps. - [Southern California & Silicon Valley House Flipping Distress, Stalled Permits, and 70%/75% MAO Benchmarks](https://realestate.meruai.co/insights/socal-house-flipping-distress-mao-report): County-by-county audit of 43,263 Southern California and Silicon Valley fix-and-flip leads, 11,385 stalled permits, and 70%/75% rule MAO spreads. - [California CAL FIRE Fire Hazard Severity Zones, AB 38 Defensible Space, and FAIR Plan Exit Risk in Flips](https://realestate.meruai.co/insights/california-fair-plan-fhsz-ab38-flip-risk): Empirical underwriting analysis of 6,381 Southern California and Silicon Valley flip leads inside High and Very High CAL FIRE hazard zones. - [Fastest vs. Slowest Southern California & Silicon Valley Cities for ADU Permits and Bonus Exit ARV](https://realestate.meruai.co/insights/california-hcd-adu-permit-velocity-by-city): City-by-city California ADU permit turnaround rankings from California HCD Annual Progress Reports across 34,545 ADU-eligible flip parcels. - [Mello-Roos CFD Special Taxes and CPUC Leased Solar PPA Liens in California Fix-and-Flip Underwriting](https://realestate.meruai.co/insights/mello-roos-cfd-leased-solar-ppa-underwriting): Underwriting analysis of 13,933 elevated Mello-Roos CFD tax-drag parcels and 11,566 leased solar PPA/PACE lien corridors across SoCal and Silicon Valley. - [Supply-Chain & Environmental Entity Resolution](https://meruai.co/guides/supply-chain-and-environmental-entity-resolution): Cross-registry corporate shell and spatial asset linkage guide. - [AI Automation Consulting](https://meruai.co/ai-automation-consulting): Custom agentic workflows, underwriting pipelines, and enterprise automation by Meru AI. - [Custom Data & Partnership Inquiries](https://meruai.co/partnership?from=realestate.meruai.co&utm_source=realestate&utm_medium=ecosystem_bridge&utm_campaign=public_ledger): Institutional real estate, building-safety, and multi-LLC portfolio data partnerships with Meru AI. - [All 18 Meru AI Public-Data Platforms](https://meruai.co/public-data-platforms): Sibling civic, water, safety, healthcare, and legal ledgers. ## 9. Scope & Attribution Boundary Public assessor deeds, municipal building permits, code enforcement logs, and HUD multifamily filings reflect administrative disclosures as of capture date. Flip spreads and rehab valuations measure permitted construction statements and recorded consideration, not net after-tax profits, private off-permit renovations, or legal habitability determinations.