Data Explorer
Query the US Nationwide Parcel Dataset
Request Sample Download
$1.75 / 1,000 records$100 minimum
0/80
Live SQL
SELECT * FROM "parcel_layer" WHERE statefp = '26' AND countyfp = '017'
52,453 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 | taxyear | taxdistrict | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63ceba57-6cf6-4be0-bb96-48d8dc4… | 26 | 017 | 1632 W MIDLAND RD | MI | 48611 | BAY | 87380 | WILLIAMS | 285600 | 2856 | 33132.7489 | 1 | 1 | 1 | — | 192.4348 | 196.1348 | 194.1505 | 14N | 21 | 3E | S21 T14N R3E | AUBURN DIECAST CORP | CONVENIENCE_STORE | 2021 | |||||||||||||||||||||||||||||||||||||||||||||
| defc8639-eaa9-4861-a33e-872ff53… | 26 | 017 | 507 EAST MIDLAND STREET | BAY CITY | MI | 48706 | BAY | 06020 | BAY CITY | 286600 | 2866 | 1689.0066 | 1 | 1 | 2 | — | 182.6028 | 183.4864 | 182.9436 | 14N | 20 | 5E | S20 T14N R5E | SALON 205 | PERSONAL_OR_BEAUTY_SERVICE | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 6c8a0c89-c5fa-4747-9a23-fe2b117… | 26 | 017 | AUBURN CORNFEST GROUNDS | AUBURN | MI | 48611 | BAY | 04080 | AUBURN | 285600 | 2856 | 174.1082 | 1 | 1 | 2 | — | 188.5618 | 188.7698 | 188.6346 | 1300 | RESIDENTIAL | 14N | 24 | 3E | S24 T14N R3E | 2021 | ||||||||||||||||||||||||||||||||||||||||||||
| ac23440c-a3bb-4017-a03b-e6e7054… | 26 | 017 | PAUL'S MOTEL | MI | 48706 | BAY | 54980 | MONITOR | 285500 | 2855 | 3238.5877 | — | 179.3066 | 180.6864 | 180.0921 | 3300 | COMMERCIAL | 31192 | 14N | 30 | 5E | S30 T14N R5E | TIM HORTONS | COFFEE_SHOP | 2021 | |||||||||||||||||||||||||||||||||||||||||||||
| 80f72164-a9cc-4ee0-a3fe-4377fae… | 26 | 017 | MI | 48732 | BAY | 36260 | HAMPTON | 285201 | 2852.0100 | 31415.9003 | 2 | 1 | 1 | — | 180.1519 | 183.1101 | 180.9460 | 8000 | FARMLAND | 14N | 30 | 6E | S30 T14N R6E | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||
| 0a57e07d-efc8-4d04-94a8-0119331… | 26 | 017 | LINCOLN SCHOOL | BAY CITY | MI | 48708 | BAY | 06020 | BAY CITY | 280600 | 2806 | 512.1971 | 2 | 1 | 1 | — | 181.5126 | 182.2311 | 181.8551 | 14N | 27 | 5E | S27 T14N R5E | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 74542a15-952d-42bf-9310-5bd7f9b… | 26 | 017 | BARNEY'S PUB & GRILL | BAY CITY | MI | 48708 | BAY | 06020 | BAY CITY | 280800 | 2808 | 464.3362 | 2 | 1 | 1 | — | 181.9229 | 182.4773 | 182.2354 | 14N | 33 | 5E | S33 T14N R5E | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 65fab065-892b-487a-b61c-8db3380… | 26 | 017 | ROOSEVELT PARK | BAY CITY | MI | 48708 | BAY | 06020 | BAY CITY | 280900 | 2809 | 468.1868 | 1 | 1 | 1 | — | 180.0659 | 180.4170 | 180.2495 | 14N | 33 | 5E | S33 T14N R5E | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| a48a43a7-555c-450d-8b76-72effa5… | 26 | 017 | TERMINUE MUFFLER SHOP | BAY CITY | MI | 48708 | BAY | 65980 | PORTSMOUTH | 285300 | 2853 | 2589.1252 | 2 | 1 | 2 | — | 181.0299 | 182.5792 | 182.0293 | 14N | 34 | 5E | S34 T14N R5E | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||
| e345d1a7-e47c-410b-a102-8c10c27… | 26 | 017 | NORTHWOODS WHOLESALE OUTLET | PINCONNING | MI | 48650 | BAY | 64160 | PINCONNING | 286300 | 2863 | 529.3640 | 1 | 1 | 1 | — | 181.9228 | 183.3265 | 182.6247 | 17N | 23 | 4E | S23 T17N R4E | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||
| b2b83d59-c8cd-4470-a9a6-482a4a4… | 26 | 017 | WASHINGTON SCHOOL | BAY CITY | MI | 48708 | BAY | 06020 | BAY CITY | 280500 | 2805 | 1095.5332 | 2 | 1 | 1 | — | 181.3226 | 181.9908 | 181.6002 | 14N | 27 | 5E | S27 T14N R5E | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| b1990ad5-979e-4359-a861-e0fe22e… | 26 | 017 | 601 BLEND STREET | BAY CITY | MI | 48706 | BAY | 06020 | BAY CITY | 286600 | 2866 | 760.3896 | 1 | 1 | 1 | — | 182.2092 | 183.0007 | 182.7060 | 14N | 20 | 5E | S20 T14N R5E | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| efe06f32-d2d1-48dd-9bac-a332245… | 26 | 017 | 201 S MABLE ST | PINCONNING | MI | 48650 | BAY | 64160 | PINCONNING | 286300 | 2863 | 2275.8483 | 2 | 1 | 1 | — | 181.8116 | 182.9259 | 182.3180 | 17N | 23 | 4E | S23 T17N R4E | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||
| 4b32c6ac-0fff-4220-87e9-93b76b1… | 26 | 017 | SAINT JOHNS SCHOOL | BAY CITY | MI | 48706 | BAY | 06020 | BAY CITY | 281000 | 2810 | 479.6533 | 2 | 1 | 1 | — | 183.2933 | 183.8188 | 183.5915 | 14N | 20 | 5E | S20 T14N R5E | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| a1dbfc2f-7de0-4bf2-bf2f-03a214d… | 26 | 017 | ROSEBUSH DRAIN | FRASER | MI | 48634 | BAY | 30400 | FRASER | 286200 | 2862 | 2414.9020 | 1 | 1 | 1 | — | 177.6960 | 178.5428 | 178.0553 | 16N | 35 | 4E | S35 T16N R4E | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||
| ac6d6b25-8056-4145-b931-11415ad… | 26 | 017 | ELECTRIC KITSCH | PORTSMOUTH | MI | 48708 | BAY | 06020 | BAY CITY | 280600 | 2806 | 649.0217 | 1 | 1 | 1 | — | 181.8313 | 182.2149 | 182.0094 | 14N | 27 | 5E | S27 T14N R5E | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 2a34bffa-48f1-4772-8678-ccde1e0… | 26 | 017 | RIVER BEND WEST NATURE AREA | BAY CITY | MI | 48706 | BAY | 06020 | BAY CITY | 286600 | 2866 | 1212.2656 | 2 | 1 | 1 | — | 182.9948 | 183.6432 | 183.2535 | 14N | 21 | 5E | S21 T14N R5E | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 13e12320-af26-4db0-8378-6c4a2d6… | 26 | 017 | BAY CITY CENTRAL HIGH SCHOOL | BAY CITY | MI | 48708 | BAY | 06020 | BAY CITY | 280400 | 2804 | 520.3610 | 1 | 1 | 1 | — | 181.9065 | 182.5085 | 182.1756 | 14N | 27 | 5E | S27 T14N R5E | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 38a3547a-f75a-4f7c-8163-e9e214c… | 26 | 017 | M&M SEAMLESS GUTTERS INC | BAY CITY | MI | 48706 | BAY | 06020 | BAY CITY | 281000 | 2810 | 993.3706 | 2 | 1 | 1 | — | 182.3764 | 182.9893 | 182.6784 | 14N | 29 | 5E | S29 T14N R5E | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 44e6175f-73e9-4f09-bebc-62d2743… | 26 | 017 | MCDONALD'S | AUBURN | MI | 48611-9421 | BAY | 87380 | WILLIAMS | 285600 | 2856 | 2075.3279 | 3 | — | 191.0785 | 191.8061 | 191.4401 | 1300 | RESIDENTIAL | 14N | 22 | 3E | S22 T14N R3E | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||
| b7c1e69f-dc9b-481d-ab04-15b62f3… | 26 | 017 | MI | 48611 | BAY | 87380 | WILLIAMS | 285600 | 2856 | 1892.6604 | 1 | 1 | 2 | — | 191.3218 | 192.0075 | 191.6871 | 1300 | RESIDENTIAL | 14N | 22 | 3E | S22 T14N R3E | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||
| a29845dc-8a87-4f6d-9f35-fa1f449… | 26 | 017 | ROSEBUSH DRAIN | MI | 48634 | BAY | 42360 | KAWKAWLIN | 286102 | 2861.0200 | 2525.7741 | 2 | 1 | 1 | — | 176.8068 | 178.6620 | 177.8010 | 15N | 2 | 4E | S2 T15N R4E | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||
| 8f6977bb-a56a-4fb1-be1c-4e420dc… | 26 | 017 | BAY MOTEL | MI | 48706 | BAY | 54980 | MONITOR | 285500 | 2855 | 2078.7684 | 2 | 1 | 1 | — | 182.0083 | 183.0679 | 182.5018 | 14N | 30 | 5E | S30 T14N R5E | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||
| a9b8659c-9b1c-4c6b-a513-c5518a4… | 26 | 017 | KINGDOM HALL OF JEHOVAH'S WITNE… | MI | 48706 | BAY | 54980 | MONITOR | 285500 | 2855 | 1232.0307 | 1 | 1 | 1 | — | 182.1375 | 182.7669 | 182.3461 | 14N | 30 | 5E | S30 T14N R5E | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||
| 5754b9b4-768d-46a2-896b-7ec28a4… | 26 | 017 | MI | 48650 | BAY | 55920 | MOUNT FOREST | 286400 | 2864 | 7707.8360 | 2 | 1 | 1 | — | 193.5000 | 195.3610 | 194.1851 | 17N | 12 | 3E | S12 T17N R3E | 2021 |