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 = '147'
88,520 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74-45-036-4010-100 | 26 | 147 | 10808 MARY STREET | EMMETT | MI | 48022 | VILLAGE OF EMMETT | ST. CLAIR | 25960 | EMMETT | 658100 | 6581 | 26740.3321 | 2 | 1 | 1 | — | 234.0235 | 235.4803 | 234.7112 | 7210 | PITCH | GOVERNMENT | BEG N 87D 5M W 334.50 S 2D 30M … | 7N | 36 | 14E | S36 T7N R14E | EG00028B | EMMETT BALL FIELDS | SPORT_FIELD | 2024 | ||||||||||||||||||||||||||||||||||||||
| 74-12-006-4016-000 | 26 | 147 | 10975 GRATIOT AVE | CASCO | MI | 48064 | GROENEWOUD PAUL GROENEWOUD DALE | ST. CLAIR | 13720 | CASCO | 651200 | 6512 | 5501.0803 | 2 | 1 | 1 | — | 211.1847 | 213.5828 | 212.6686 | 2100 | RETAIL | PERSON | BEG S 0D 28 1/2M E 52.94 FROM I… | 4N | 6 | 15E | S6 T4N R15E | T 00090B1 | 2024 | ||||||||||||||||||||||||||||||||||||||||
| 74-03-032-2001-200 | 26 | 147 | 501 BUSHA HWY | MARYSVILLE | MI | 48040 | BLUE WATER AGGREGATES CO | ST. CLAIR | 52080 | MARYSVILLE | 637300 | 6373 | 65034.1372 | 3 | 1 | 1 | — | 175.8605 | 195.1095 | 181.2829 | BUSINESS | BEG N 87D 59M 1S E 1910.44 N 16… | 6N | 29 | 17E | S29 T6N R17E | Z 00079B | BLUE WATER AGGREGATES | HARDWARE_HOME_AND_GARDEN_STORE | 2024 | ||||||||||||||||||||||||||||||||||||||||
| 74-40-021-2033-500 | 26 | 147 | 15122 WEST PARK STREET | CAPAC | MI | 48014 | WEST MICHIGAN FAMILY HOMES LLC | ST. CLAIR | 56380 | MUSSEY | 657100 | 6571 | 24225.8038 | 3 | 1 | 2 | — | 247.1248 | 248.9665 | 247.9632 | BUSINESS | W 511 OF E 1267.92 OF N 511 OF … | 7N | 21 | 13E | S21 T7N R13E | CF00476B | GLENCREST | HISTORIC_SITE | 2024 | ||||||||||||||||||||||||||||||||||||||||
| 74-20-579-0044-000 | 26 | 147 | 3656 TEEPLE AVE | MI | 48059 | BUDD CHRISTOPHER/LAURIE | ST. CLAIR | 29760 | FORT GRATIOT | 630400 | 6304 | 1800.4552 | 1 | 1 | 1 | — | 190.2424 | 191.0659 | 190.5738 | 1300 | RESIDENTIAL | PERSON | LOT 76 THE OAKS SUBD NO 1 | 7N | 29 | 17E | S29 T7N R17E | J 00719B44 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 74-30-002-1003-000 | 26 | 147 | 5310 GRATIOT AVE | ST. CLAIR | MI | 48079 | WYATT RICK WYATT NANCY | ST. CLAIR | 70700 | ST. CLAIR | 640600 | 6406 | 26992.8498 | — | 192.8013 | 194.8725 | 194.0378 | PERSON | W 100 OF E 623 OF ALL THAT PART… | 5N | 2 | 16E | S2 T5N R16E | Q 00037B | HOAG CABINET SHOP INC | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 74-20-966-0022-000 | 26 | 147 | 2616 WHITNEY PL | MI | 48059 | LIETHEN PHILIP/LINDA | ST. CLAIR | 29760 | FORT GRATIOT | 631600 | 6316 | 1844.5331 | 1 | 1 | 1 | — | 179.4530 | 181.5888 | 180.7911 | 1300 | RESIDENTIAL | PERSON | UNIT 22 GREENFIELD VILLAGE COND… | 7N | 22 | 17E | S22 T7N R17E | J 01075V | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 74-20-756-0038-000 | 26 | 147 | 4320 FAIRWAY DR | MI | 48059 | RICCA MICHELLE | ST. CLAIR | 29760 | FORT GRATIOT | 631600 | 6316 | 2013.7728 | 1 | 1 | 1 | — | 179.5762 | 181.6601 | 180.6498 | 1300 | RESIDENTIAL | PERSON | LOTS 81 83 SUPERVISORS'S GRATIO… | 7N | 22 | 17E | S22 T7N R17E | J 00884A1 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 74-20-029-1029-000 | 26 | 147 | 3982 STATE ROAD | MI | 48059 | BAMBUSCH LORI L | ST. CLAIR | 29760 | FORT GRATIOT | 630400 | 6304 | 2234.0863 | 1 | 1 | 1 | — | 190.6221 | 191.7238 | 191.2163 | 1300 | RESIDENTIAL | PERSON | W 220.59 OF N 5 A OF W 10 A OF … | 7N | 29 | 17E | S29 T7N R17E | J 00323C2 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 74-06-521-0037-000 | 26 | 147 | 3803 CATALPA CT | PORT HURON | MI | 48060 | ROBERTS MALCOLM L/SAM TAMARA A | ST. CLAIR | 65820 | PORT HURON | 629000 | 6290 | 992.3864 | 1 | 1 | 2 | — | 182.5109 | 183.3944 | 183.0716 | 1300 | RESIDENTIAL | PERSON | LOT 37 NORTHERN WOODS SUBDIVISI… | 7N | 27 | 17E | S27 T7N R17E | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 74-19-033-1002-300 | 26 | 147 | 12473 RYNN ROAD | EMMETT | MI | 48022 | WRIGHT JANICE LORRAINE | ST. CLAIR | 25960 | EMMETT | 658100 | 6581 | 10509.4600 | 2 | 1 | 1 | — | 241.1805 | 242.7014 | 241.7000 | PERSON | BEG N 89D 56M E 433.3 FROM NW S… | 7N | 33 | 14E | S33 T7N R14E | G 00383A4 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-13-005-2002-000 | 26 | 147 | 6703 FRED W MOORE HIGHWAY | EAST CHINA TOWNSHIP | MI | 48054 | DECAUSSIN CHARLES JR | ST. CLAIR | 15540 | CHINA | 641000 | 6410 | 8307.3376 | 2 | 1 | 1 | — | 193.1750 | 194.8254 | 193.9922 | PERSON | E 165 OF N 540 OF W 1/4 OF N 2/… | 4N | 5 | 16E | S5 T4N R16E | S 00044B | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-03-842-0015-000 | 26 | 147 | 506 CENTRAL AVE | MARYSVILLE | MI | 48040 | MOMOLA GERALD/MARY ANNE | ST. CLAIR | 52080 | MARYSVILLE | 637100 | 6371 | 818.7776 | 1 | 1 | 2 | — | 185.7878 | 186.1960 | 186.0583 | PERSON | LOT 15 VICKSBURG COMMONS NO 1 | 6N | 30 | 17E | S30 T6N R17E | Z 02154O | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-03-768-0087-500 | 26 | 147 | 4435 RAVENSWOOD | MARYSVILLE | MI | 48040 | PETTYPOOL CHRISTOPHER/CHRISTINA | ST. CLAIR | 52080 | MARYSVILLE | 637100 | 6371 | 2158.0466 | 1 | 1 | 1 | — | 190.8219 | 192.2987 | 191.6296 | PERSON | LOTS 11 TO 18 BLOCK 19 SUBDIVIS… | 6N | 30 | 17E | S30 T6N R17E | Z 00957/959 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-01-135-0028-000 | 26 | 147 | 422 LATHROP AVE | ALGONAC | MI | 48001 | KLEISINGER JOHN KLEISINGER LAU… | ST. CLAIR | 01180 | ALGONAC | 649000 | 6490 | 707.1678 | 1 | 1 | 2 | — | 176.3090 | 176.9239 | 176.5932 | PERSON | LOT 786 EXC NELY 135 THEREOF SU… | 2N | 10 | 16E | S10 T2N R16E | AW01503 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-03-767-0155-000 | 26 | 147 | 630 GEORGIA AVE | MARYSVILLE | MI | 48040 | BENNETT JAY C JR | ST. CLAIR | 52080 | MARYSVILLE | 637100 | 6371 | 669.1911 | 1 | 1 | 1 | — | 188.6761 | 189.4779 | 189.1238 | PERSON | LOT 29 EXC S 2.6 FT S 17.6 FT O… | 6N | 31 | 17E | S31 T6N R17E | Z 00827D5 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-01-131-0067-000 | 26 | 147 | 336 SHERWOOD LN | ALGONAC | MI | 48001 | KUPPS KENNETH/JULIANN | ST. CLAIR | 01180 | ALGONAC | 649000 | 6490 | 1132.8334 | 1 | 1 | 2 | — | 176.1792 | 177.0379 | 176.5737 | PERSON | LOTS 632 633 W 1/2 LOT 634 SUPE… | 2N | 2 | 16E | S2 T2N R16E | AW01404A | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-10-013-4007-000 | 26 | 147 | 10944 OATMAN ROAD | YALE | MI | 48097 | FAIRCHILD JAMES M JR | ST. CLAIR | 10820 | BROCKWAY | 655100 | 6551 | 7633.7734 | 2 | 1 | 2 | — | 243.5722 | 245.6647 | 244.7266 | PERSON | BEG ON S SEC LINE 394 E OF SW C… | 8N | 13 | 14E | S13 T8N R14E | D 00175B | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-27-011-2002-200 | 26 | 147 | 5411 KNOLL ROAD | CAPAC | MI | 48014 | CASWELL GREGORY JR CASWELL DEA… | ST. CLAIR | 56380 | MUSSEY | 657200 | 6572 | 118064.2356 | 1 | 1 | 2 | — | 243.4726 | 251.4077 | 246.1389 | PERSON | N 30 A OF E 1/2 OF NE 1/4 SECTI… | 7N | 11 | 13E | S11 T7N R13E | F 00107C | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-02-675-0001-000 | 26 | 147 | 644 S BELLE RIVER AVE | MARINE CITY | MI | 48039 | SMALSTIG DAVID | ST. CLAIR | 51600 | MARINE CITY | 644000 | 6440 | 1583.2812 | 1 | 1 | 2 | — | 176.9572 | 178.2055 | 177.7002 | PERSON | LOT A EXC THE W 55 THEREOF DAVI… | 3N | 12 | 16E | S12 T3N R16E | MC01253 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-30-007-3001-500 | 26 | 147 | 7105 DREXLER ROAD | ST. CLAIR | MI | 48079 | STEFFORIA MICHAEL/PATRICIA | ST. CLAIR | 70700 | ST. CLAIR | 640600 | 6406 | 76842.7045 | 2 | 1 | 2 | — | 190.4428 | 193.9486 | 192.4083 | PERSON | BEG S 89D 59M 30S W 645.29 FROM… | 5N | 7 | 16E | S7 T5N R16E | Q 00115G | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-17-004-4005-100 | 26 | 147 | 6350 ARNOLD ROAD | MARINE CITY | MI | 48039 | LORENZ FRED AUGUST LORENZ COLE… | ST. CLAIR | 18400 | COTTRELLVILLE | 645000 | 6450 | 21376.1670 | 2 | 1 | 1 | — | 183.4293 | 185.9412 | 184.4593 | PERSON | W 1/2 OF SW 1/4 OF SE 1/4 OF SW… | 3N | 4 | 16E | S4 T3N R16E | V 00089B | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-03-510-0025-000 | 26 | 147 | 320 FIFTH ST | MARYSVILLE | MI | 48040 | SHARRARD YVONNE | ST. CLAIR | 52080 | MARYSVILLE | 637100 | 6371 | 1129.2693 | 1 | 1 | 2 | — | 185.3454 | 186.0485 | 185.7163 | PERSON | LOT 25 MARYSVILLE ESTATES NO 4 | 6N | 30 | 17E | S30 T6N R17E | Z 00195A171 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-21-017-2003-400 | 26 | 147 | 7871 GIBBONS RD | JEDDO | MI | 48032 | BELL MICHAEL J JR BELL ALICIA M | ST. CLAIR | 34420 | GRANT | 655600 | 6556 | 20254.6904 | 2 | 1 | 1 | — | 232.7057 | 236.8283 | 234.9054 | PERSON | BEG S 0D 1M 5S E 1044.82 FROM N… | 8N | 17 | 16E | S17 T8N R16E | B 00140E | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 74-08-539-0014-000 | 26 | 147 | 107 NORTH ST | YALE | MI | 48097 | BOWER TONY A | ST. CLAIR | 89000 | YALE | 655100 | 6551 | 968.0266 | 1 | 1 | 1 | — | 242.9569 | 243.8769 | 243.4064 | PERSON | LOT 17 MORRELLS ADDITION TO THE… | 8N | 11 | 14E | S11 T8N R14E | Y 00402 | 2024 |