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 = '149'
35,566 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 005 006 031 00 | 26 | 149 | 1405 E CHICAGO RD | STURGIS | MI | 49091 | ST. JOSEPH | 27540 | FAWN RIVER | 040800 | 408 | 1286.1193 | 1 | 1 | 1 | — | 284.8166 | 285.6040 | 285.2870 | 8S | 6 | 9W | S6 T8S R9W | EMRO MARKETING COMPANY | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 041 777 030 00 | 26 | 149 | 210 W SOUTH ST | COLON | MI | 49040 | ST. JOSEPH | 17370 | COLON | 041302 | 413.0200 | 548.2983 | 1 | 1 | 2 | — | 257.6244 | 263.8144 | 262.5303 | 6S | 14 | 9W | S14 T6S R9W | MI DEPT/NATURAL RESOURCES AND E… | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 004 014 018 00 | 26 | 149 | MI | 49093 | CITY GOVERNMENT | ST. JOSEPH | 26920 | FABIUS | 041102 | 411.0200 | 159351.5253 | — | 251.1499 | 278.9317 | 263.0529 | 7240 | PARK | PERSON | 6S | 14 | 12W | S14 T6S R12W | GOVT LOCAL | OPEN | MEYER, BROADWAY AND COON HOLLOW… | LOCAL PARK | 2024 | |||||||||||||||||||||||||||||||||||||||||||
| 052 660 048 00 | 26 | 149 | FIRST PRESBYTERIAN CHURCH | STURGIS | MI | 49091 | ST. JOSEPH | 76960 | STURGIS | 040500 | 405 | 3892.8185 | 1 | 1 | 1 | — | 275.3039 | 277.0335 | 275.9595 | 1300 | RESIDENTIAL | 8S | 12 | 10W | S12 T8S R10W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 052 040 288 00 | 26 | 149 | 219 WEST CHICAGO ROAD | STURGIS | MI | 49091 | ST. JOSEPH | 76960 | STURGIS | 040700 | 407 | 379.8101 | 2 | 1 | 1 | — | 276.3098 | 277.2148 | 276.9027 | 8S | 1 | 10W | S1 T8S R10W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 052 445 010 00 | 26 | 149 | LANGRICK STREET PARK | STURGIS | MI | 49091 | ST. JOSEPH | 76960 | STURGIS | 040700 | 407 | 758.7929 | 2 | 1 | 2 | — | 279.5889 | 279.9669 | 279.8038 | 8S | 1 | 10W | S1 T8S R10W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 004 310 002 00 | 26 | 149 | SEVENTH DAY ADVENTIST CHURCH | FABIUS | MI | 49093 | ST. JOSEPH | 26920 | FABIUS | 041102 | 411.0200 | 1913.1867 | 1 | 1 | 1 | — | 252.1300 | 253.1040 | 252.7089 | 6S | 13 | 12W | S13 T6S R12W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 041 075 003 00 | 26 | 149 | VETERANS MEMORIAL PARK | COLON | MI | 49040 | ST. JOSEPH | 17370 | COLON | 041302 | 413.0200 | 958.3684 | 1 | 1 | 1 | — | 255.9375 | 261.1492 | 259.9132 | 6S | 14 | 9W | S14 T6S R9W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 016 230 010 00 | 26 | 149 | MI | 49099 | ST. JOSEPH | 86940 | WHITE PIGEON | 041400 | 414 | 1383.2647 | 1 | 1 | 1 | — | 248.0394 | 249.1855 | 248.5161 | 1300 | RESIDENTIAL | 8S | 24 | 12W | S24 T8S R12W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 051 445 059 00 | 26 | 149 | RIVERSIDE CHURCH | THREE RIVERS | MI | 49093 | ST. JOSEPH | 79760 | THREE RIVERS | 040400 | 404 | 809.3428 | 2 | 1 | 2 | — | 246.5828 | 247.1921 | 246.9354 | 6S | 18 | 11W | S18 T6S R11W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 051 155 019 00 | 26 | 149 | 13 N MAIN ST | THREE RIVERS | MI | 49093 | ST. JOSEPH | 79760 | THREE RIVERS | 040100 | 401 | 261.1740 | 1 | — | 242.3939 | 247.5885 | 244.3361 | 7225 | 6S | 18 | 11W | S18 T6S R11W | MAIN ST. CAFE | CAFE | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 052 510 005 00 | 26 | 149 | 704 WEST CHICAGO ROAD | STURGIS | MI | 49091 | ST. JOSEPH | 76960 | STURGIS | 040600 | 406 | 808.6533 | 1 | 1 | 1 | — | 275.1725 | 276.7885 | 276.0805 | 8S | 1 | 10W | S1 T8S R10W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 051 145 067 00 | 26 | 149 | FIRST PRESBYTERIAN CHURCH | THREE RIVERS | MI | 49093 | ST. JOSEPH | 79760 | THREE RIVERS | 040100 | 401 | 980.9103 | 2 | 1 | 1 | — | 249.1715 | 249.8015 | 249.5010 | 6S | 18 | 11W | S18 T6S R11W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 052 670 014 00 | 26 | 149 | COMMUNITY BIBLE CHURCH | STURGIS | MI | 49091 | ST. JOSEPH | 76960 | STURGIS | 040800 | 408 | 1123.8846 | 2 | 1 | 2 | — | 281.4345 | 282.4059 | 281.8158 | 8S | 1 | 10W | S1 T8S R10W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 002 013 007 00 | 26 | 149 | PALMER LAKE BEACH | COLON | MI | 49040 | ST. JOSEPH | 17370 | COLON | 041302 | 413.0200 | 9345.9838 | 1 | 1 | 2 | — | 255.9375 | 269.8236 | 266.1452 | 6S | 13 | 9W | S13 T6S R9W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 007 003 002 00 | 26 | 149 | MI | 49067 | ST. JOSEPH | 29140 | FLOWERFIELD | 040900 | 409 | 515441.3457 | 2 | 1 | 1 | — | 262.6339 | 280.7133 | 271.4326 | 8000 | FARMLAND | 5S | 3 | 12W | S3 T5S R12W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 051 320 073 09 | 26 | 149 | IMMACULATE CONCEPTION CHURCH | THREE RIVERS | MI | 49093 | ST. JOSEPH | 79760 | THREE RIVERS | 040300 | 403 | 725.2813 | 1 | 1 | 1 | — | 247.5447 | 248.0301 | 247.7972 | 6S | 19 | 11W | S19 T6S R11W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 007 021 031 10 | 26 | 149 | HOWARDSVILLE CHRISTIAN SCHOOL | FLOWERFIELD | MI | 49067 | ST. JOSEPH | 29140 | FLOWERFIELD | 040900 | 409 | 6068.8114 | 2 | 1 | 1 | — | 259.9534 | 261.5096 | 260.6510 | 5S | 21 | 12W | S21 T5S R12W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 051 125 006 00 | 26 | 149 | ARMSTRONG INT. CORPORATE | THREE RIVERS | MI | 49093 | ST. JOSEPH | 79760 | THREE RIVERS | 040100 | 401 | 781.5763 | 1 | 1 | 1 | — | 249.8236 | 250.4010 | 250.1598 | 6S | 7 | 11W | S7 T6S R11W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 052 100 049 00 | 26 | 149 | HOLY ANGELS SCHOOL | STURGIS | MI | 49091 | ST. JOSEPH | 76960 | STURGIS | 040600 | 406 | 588.5669 | 1 | 1 | 1 | — | 278.1018 | 278.5234 | 278.3547 | 8S | 1 | 10W | S1 T8S R10W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 052 640 016 00 | 26 | 149 | ARTHUR CARL'S PARK | STURGIS | MI | 49091 | ST. JOSEPH | 76960 | STURGIS | 040600 | 406 | 642.5540 | 1 | 1 | 2 | — | 274.6314 | 274.9225 | 274.7654 | 8S | 12 | 10W | S12 T8S R10W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 045 200 033 00 | 26 | 149 | WHITE PIGEON POST OFFICE | WHITE PIGEON | MI | 49099 | ST. JOSEPH | 86940 | WHITE PIGEON | 041400 | 414 | 905.8305 | 1 | 1 | 1 | — | 248.9645 | 249.6000 | 249.2440 | 8S | 1 | 12W | S1 T8S R12W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 052 430 025 00 | 26 | 149 | GATEWAY RIVER OF LIFE CHURCH | STURGIS | MI | 49091 | ST. JOSEPH | 76960 | STURGIS | 040700 | 407 | 666.3147 | 2 | 1 | 1 | — | 280.8616 | 282.1807 | 281.5414 | 8S | 1 | 10W | S1 T8S R10W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 012 031 003 00 | 26 | 149 | MI | 49032 | ST. JOSEPH | 59400 | NOTTAWA | 041301 | 413.0100 | 359704.8862 | — | 259.3191 | 274.4484 | 265.3624 | 6S | 31 | 10W | S31 T6S R10W | LOCKPORT TOWNSHIP | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| 052 310 120 00 | 26 | 149 | CONGRESS STREET SCHOOL | STURGIS | MI | 49091 | ST. JOSEPH | 76960 | STURGIS | 040500 | 405 | 511.8136 | 2 | — | 280.8084 | 281.2850 | 281.0928 | 8S | 1 | 10W | S1 T8S R10W | 2024 |