Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
39/80
Live SQL
SELECT * FROM "lr_parcel_us" WHERE statefp = '26' AND countyfp = '005'
71,784 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24-025-015-22 | 26 | 005 | 129 126TH AVE | WAYLAND | MI | 49348 | WHIP DOUGLAS J & KIMBERLY M | 129 126TH AVE | WAYLAND | MI | 49348 | ALLEGAN | 84900 | WAYLAND | 030501 | 305.0100 | 54993.6526 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 230.0724 | 235.9474 | 232.8267 | 13.5872 | PERSON | GUN LAKE PET LODGE | ANIMAL_OR_PET_SERVICE | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||
| 56-650-012-00 | 26 | 005 | 624 PINE ST | WAYLAND | MI | 49348 | RABIDEAU JANICE | 624 PINE ST | WAYLAND | MI | 49348 | ALLEGAN | 84880 | WAYLAND | 030502 | 305.0200 | 1324.9044 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 228.9138 | 231.5984 | 229.7627 | 0.3273 | PERSON | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||
| 02-033-004-00 | 26 | 005 | PENNY LANE | SOUTH HAVEN | MI | 49090 | MERRY THOMAS J & SUSAN E TRUST | 17928 ASHMONT PL | SOUTH BEND | IN | 46635 | ALLEGAN | 13700 | CASCO | 030901 | 309.0100 | 55636.5899 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 188.8498 | 194.8894 | 190.3965 | 13.7466 | TRUST | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||
| 02-226-016-00 | 26 | 005 | 1011 ORCHARD AVE | SOUTH HAVEN | MI | 49090 | LANG CHRISTOPHER H | 1011 ORCHARD AVE | SOUTH HAVEN | MI | 49090 | ALLEGAN | 13700 | CASCO | 030901 | 309.0100 | 2347.1656 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 203.5086 | 208.3038 | 206.1034 | 0.5798 | PERSON | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||
| 17-007-001-01 | 26 | 005 | MI | ALLEGAN | 61640 | OTSEGO | 031800 | 318 | 25656.6630 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 201.4673 | 216.4181 | 210.7707 | 6.3389 | GOVT STATE | RESTRICTED | V | ALLEGAN STATE GAME AREA | STATE CONSERVATION AREA | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 09-001-010-10 | 26 | 005 | 3493 38TH ST | HAMILTON | MI | 49419 | MARSH JOHN F & MARILYN J | 3493 38TH ST | HAMILTON | MI | 49419 | ALLEGAN | 37460 | HEATH | 030702 | 307.0200 | 8083.0143 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 203.4734 | 205.8103 | 204.7966 | 1.9971 | PERSON | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||
| 14-033-037-10 | 26 | 005 | 2433 55TH ST | FENNVILLE | MI | 49408 | BATEY HOWARD & DORLA | 2433 55TH ST | FENNVILLE | MI | 49408 | ALLEGAN | 50840 | MANLIUS | 030704 | 307.0400 | 5406.6573 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 195.7727 | 201.7297 | 198.2228 | 1.3356 | PERSON | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||
| 07-008-031-00 | 26 | 005 | 2178 70TH ST | FENNVILLE | MI | 49408 | HAMILTON FAMILY TRUST | 16328 HALLAUER RD | OBERLIN | OH | 44074 | ALLEGAN | 31360 | GANGES | 030902 | 309.0200 | 6556.2614 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 176.5096 | 195.1677 | 188.9862 | 1.6197 | TRUST | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||
| 07-012-012-00 | 26 | 005 | 6013 122ND AVE | FENNVILLE | MI | 49408 | FREYMARK NEICE K TRUST | 20 TUTTLE AVE | CLARENDON HILLS | IL | 60514 | ALLEGAN | 31360 | GANGES | 030902 | 309.0200 | 1090.9508 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 193.6486 | 199.5117 | 195.2421 | 0.2695 | TRUST | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||
| 11-009-023-00 | 26 | 005 | 6665 AUDUBON RD | HOLLAND | MI | 49423 | FULLER MARK A III & CYNTHIA G | 1015 DINSMORE RD | WINNETKA | IL | 60093 | ALLEGAN | 45180 | LAKETOWN | 030200 | 302 | 7445.4002 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 188.4503 | 203.1091 | 197.1949 | 1.8392 | PERSON | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||
| 20-027-024-00 | 26 | 005 | 127TH AVE V/L | FENNVILLE | MI | 49408 | BELL LARRY D & STASZSOW KALEO | 1818 W FARRAGUT AVE | CHICAGO | IL | 60640 | ALLEGAN | 71720 | SAUGATUCK | 030802 | 308.0200 | 39719.0814 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 200.6523 | 203.1468 | 201.8915 | 9.8132 | PERSON | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||
| 01-010-005-02 | 26 | 005 | 120TH AVE | ALLEGAN | MI | 49010 | CARNS TROY | 3077 EAST BASELINE RD | GOBLES | MI | 49055 | ALLEGAN | 01280 | ALLEGAN | 031102 | 311.0200 | 173126.7303 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 225.4853 | 257.3149 | 234.5421 | 42.7730 | PERSON | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||
| 55-190-050-00 | 26 | 005 | 353 PRINCE ST | PLAINWELL | MI | 49080 | GURITZ PAUL & JODY LIVING TRUST | 353 PRINCE ST | PLAINWELL | MI | 49080 | ALLEGAN | 64740 | PLAINWELL | 032000 | 320 | 1186.0650 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 222.1979 | 223.0615 | 222.7181 | 0.2930 | TRUST | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||
| 22-034-018-10 | 26 | 005 | 4105 112TH AVE | ALLEGAN | MI | 49010 | GERMAIN KELLY J | 4105 112TH AVE | ALLEGAN | MI | 49010 | ALLEGAN | 81580 | VALLEY | 030702 | 307.0200 | 8078.9861 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 210.8061 | 213.8858 | 211.5842 | 1.9961 | PERSON | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||
| 24-245-019-00 | 26 | 005 | 39 BROWNING DR | SHELBYVILLE | MI | 49344 | FLANNERY RYAN & JENNA | 39 BROWNING DR | SHELBYVILLE | MI | 49344 | ALLEGAN | 84900 | WAYLAND | 030501 | 305.0100 | 3647.3854 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 229.7924 | 232.8522 | 230.8523 | 0.9010 | PERSON | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||
| 12-355-013-00 | 26 | 005 | MI | LARAWAY DOUGLAS | 5583 LARAWAY DR | PULLMAN | MI | 49450 | ALLEGAN | 46600 | LEE | 031001 | 310.0100 | 527.7175 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 207.9262 | 210.6622 | 208.5045 | 0.1303 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||
| 11-320-COMMON | 26 | 005 | MI | ALLEGAN | 45180 | LAKETOWN | 030200 | 302 | 102.5737 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 178.1630 | 180.2851 | 179.0695 | 0.0253 | GOVT LOCAL | OPEN | LAKETOWN TOWNSHIP PARK | LOCAL PARK | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 21-WATER | 26 | 005 | MI | ALLEGAN | 80620 | TROWBRIDGE | 031102 | 311.0200 | 143160.3185 | 26005C | 2025-12-18 | A | 196.6881 | 204.6333 | 200.1295 | 35.3706 | GOVT STATE | RESTRICTED | V | ALLEGAN STATE GAME AREA | STATE CONSERVATION AREA | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 08-415-016-00 | 26 | 005 | 496 E STONERIDGE DR | MI | STAMM CAROL LYNN REV LVG TRUST & | 496 STONERIDGE DR | PLAINWELL | MI | 49080 | ALLEGAN | 35720 | GUN PLAIN | 032000 | 320 | 1913.2766 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 221.3467 | 222.5793 | 221.9317 | 0.4726 | TRUST | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||
| 12-383-016-00 | 26 | 005 | MI | LEE TOWNSHIP | PO BOX 427 | PULLMAN | MI | 49450 | ALLEGAN | 46600 | LEE | 031001 | 310.0100 | 277.8041 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 210.5670 | 217.3985 | 213.6270 | 0.0686 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||
| 02-780-006-00 | 26 | 005 | WINDCLIFF DR | MI | SPIECH FAMILY TRUST | 8685 W H AVE | KALAMAZOO | MI | 49009 | ALLEGAN | 13700 | CASCO | 030901 | 309.0100 | 1542.8749 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 203.8416 | 205.3839 | 204.4550 | 0.3812 | TRUST | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||
| 59-GAP | 26 | 005 | MI | ALLEGAN | 22740 | DOUGLAS | 030801 | 308.0100 | 40.3318 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 181.5898 | 186.4389 | 184.0430 | 0.0099 | PRIVATE | RESTRICTED | WEST SHORE GOLF CLUB | PRIVATE PARK | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 53-02-03-300-027 | 26 | 005 | MI | ALLEGAN | 38640 | HOLLAND | 032401 | 324.0100 | 114411.9912 | 26139C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 203.6379 | 212.7482 | 207.3771 | 28.2671 | LG ENERGY SOLUTION MICHIGAN, INC | MANUFACTURER | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 44-150-ROW | 26 | 005 | MI | ALLEGAN | 39200 | HOPKINS | 030600 | 306 | 10451.4965 | 26005C | 2025-12-18 | X | 0.2 PCT ANNUAL CHANCE FLOOD HAZ… | 212.7556 | 215.4481 | 214.1758 | 2.5820 | UNITED BANK OF MICHIGAN | FINANCIAL_SERVICE | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 05-280-ROW | 26 | 005 | MI | ALLEGAN | 22680 | DORR | 030404 | 304.0400 | 23893.8991 | 26005C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 210.7592 | 213.5220 | 212.0422 | 5.9031 | DORR TOWNSHIP CLERK | GOVERNMENT_OFFICE | 2026.2 |