Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
38/80
Live SQL
SELECT * FROM "lr_parcel_us" WHERE statefp = '26' AND countyfp = '099'
330,191 matching parcels
Data Preview
parcelid | taxacctnum | statefp | countyfp | parceladdr | parcelcity | parcelstate | parcelzip | ownername | owneraddr | ownercity | ownerstate | ownerzip | countyname | cousubfp | cousubname | tractce | tractname | calcarea | imprvalue | landvalue | agvalue | totalvalue | saleamt | saledate | numbldgs | numunits | yearbuilt | numfloors | bldgsqft | bedrooms | halfbaths | fullbaths | firmid | firmdate | fldzone | zonesubty | staticbfe | elevmin | elevmax | elevavg | usecode | usedesc | zoningcode | zoningdesc | taxacres | ownertype | naicscode | legaldesc | township | section | qtrsection | range | plssdesc | book | page | parceltype | accesstype | iucnclass | placename | placetype | fireplaces | heating | heatfuel | cooling | foundation | roofcover | siding | lrversion | taxyear | taxdistrict | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26-06-33-227-164 | 06-33-227-164 | 26 | 099 | 58206 PEMBROOKE AVE | MI | MACOMB | 46900 | LENOX | 218001 | 2180.0100 | 190234.2716 | 89 | — | 186.1362 | 192.6943 | 189.3361 | PEMBROOKE MCCP NO 911 UNIT 164 | 4N | 33 | 14E | S33 T4N R14E | 2026.2 | 2022 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 46900 | LENOX | 217000 | 2170 | 1754.9674 | — | 196.1738 | 196.8178 | 196.4287 | GOVERNMENT | GOVT STATE | CLOSED | 96-10-0773 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 36820 | HARRISON | 247302 | 2473.0200 | 555.2682 | — | 175.8416 | 176.6146 | 176.1136 | GOVERNMENT | GOVT STATE | CLOSED | 87-14-1291 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 46900 | LENOX | 217000 | 2170 | 1394.5141 | — | 196.1788 | 196.7870 | 196.4456 | GOVERNMENT | GOVT STATE | CLOSED | 02-50-0054 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 72820 | SHELBY | 225900 | 2259 | 1273.7255 | — | 194.6744 | 195.8463 | 195.3347 | GOVERNMENT | GOVT STATE | CLOSED | 05-50-0200 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 84120 | WASHINGTON | 215000 | 2150 | 12187.9948 | — | 230.1971 | 233.3246 | 230.9833 | GOVERNMENT | GOVT STATE | CLOSED | 05-50-0065-P | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 15340 | CHESTERFIELD | 221500 | 2215 | 16585.8617 | — | 190.7007 | 191.7962 | 191.0204 | GOVERNMENT | GOVT STATE | CLOSED | 05-50-0046-P | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 46900 | LENOX | 218001 | 2180.0100 | 10352.3862 | — | 187.5979 | 188.6840 | 187.8115 | GOVERNMENT | GOVT STATE | CLOSED | 00-50-0014 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 50480 | MACOMB | 223401 | 2234.0100 | 16808.5212 | — | 182.5620 | 183.3719 | 182.9200 | GOVERNMENT | GOVT STATE | CLOSED | 02-50-0051 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | CITY GOVERNMENT | MACOMB | 57100 | NEW BALTIMORE | 220004 | 2200.0400 | 29381.6653 | — | 179.6937 | 181.2195 | 180.1092 | PERSON | GOVT LOCAL | OPEN | COUNTY LINE PARK | LOCAL PARK | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 72820 | SHELBY | 225200 | 2252 | 1318.3773 | — | 204.1053 | 205.5144 | 204.6662 | GOVERNMENT | GOVT STATE | CLOSED | 99-10-0838 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 50480 | MACOMB | 224001 | 2240.0100 | 24519.9985 | — | 181.0805 | 183.8478 | 181.9261 | GOVERNMENT | GOVT STATE | CLOSED | 02-50-0051 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 36820 | HARRISON | 247602 | 2476.0200 | 793.2034 | — | 177.8792 | 178.7870 | 178.1682 | GOVERNMENT | GOVT STATE | CLOSED | 98-10-0596 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 50480 | MACOMB | 224201 | 2242.0100 | 3251.9128 | — | 179.0005 | 181.3474 | 179.5991 | GOVERNMENT | GOVT STATE | CLOSED | WRP000476 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 36820 | HARRISON | 247602 | 2476.0200 | 783.6152 | — | 178.1455 | 179.0397 | 178.4320 | GOVERNMENT | GOVT STATE | CLOSED | 98-10-0596 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | CITY GOVERNMENT | MACOMB | 24290 | EASTPOINTE | 258000 | 2580 | 96853.6541 | — | 174.2573 | 190.7605 | 180.4569 | PERSON | GOVT LOCAL | OPEN | SPINDLER PARK | LOCAL PARK | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | CITY GOVERNMENT | MACOMB | 70760 | ST. CLAIR SHORES | 251600 | 2516 | 19968.7684 | — | 174.4370 | 177.7819 | 177.0689 | PERSON | GOVT LOCAL | OPEN | WAHBY PARK | LOCAL PARK | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 46900 | LENOX | 217000 | 2170 | 3806.4087 | — | 196.0644 | 196.9457 | 196.5077 | GOVERNMENT | GOVT STATE | CLOSED | 02-50-0054 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 15340 | CHESTERFIELD | 222105 | 2221.0500 | 851.2822 | — | 180.7997 | 181.4071 | 180.9824 | GOVERNMENT | GOVT STATE | CLOSED | 97-10-0526 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 67420 | RAY | 216000 | 2160 | 702.0193 | — | 204.9001 | 205.2812 | 205.0645 | GOVERNMENT | GOVT STATE | CLOSED | 03-50-0099-P | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 46900 | LENOX | 217000 | 2170 | 87049.2329 | — | 189.6638 | 195.1302 | 192.9768 | GOVERNMENT | GOVT STATE | CLOSED | 05-50-0132 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 50480 | MACOMB | 223802 | 2238.0200 | 60966.3478 | — | 185.7378 | 188.0799 | 186.9927 | GOVERNMENT | GOVT STATE | CLOSED | 08-50-0045 | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 16520 | CLINTON | 240000 | 2400 | 7549.6841 | — | 184.6623 | 186.6802 | 185.0327 | GOVERNMENT | GOVT STATE | CLOSED | 98-50-0007-V | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 67420 | RAY | 216000 | 2160 | 6905.0970 | — | 203.0339 | 203.9575 | 203.4964 | GOVERNMENT | GOVT STATE | CLOSED | 03-50-0099-P | CONSERVATION EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 099 | MI | STATE OF MICHIGAN | MACOMB | 84120 | WASHINGTON | 215500 | 2155 | 10138.8530 | — | 205.3152 | 206.6626 | 205.6432 | GOVERNMENT | GOVT STATE | CLOSED | 01-50-0188 | CONSERVATION EASEMENT | 2026.2 |