Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
0/80
Live SQL
SELECT * FROM "parcel_layer" WHERE statefp = '17' AND countyfp = '027'
21,402 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 08-08-18-384-001 | 17 | 027 | 500 1ST ST | CARLYLE | IL | 62231 | CITY OF CARLYLE | Clinton | 11241 | CARLYLE | 900403 | 9004.0300 | 9387.5059 | 2 | 2 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 128.0985 | 134.3752 | 131.7193 | 3100 | INDUSTRIAL | GOVERNMENT | 221112 | CARLYLE MUNICIPAL ELECTRIC PLANT | BRIDGE | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||
| 05-05-24-207-032 | 17 | 027 | 522 E BROOK DR | AVISTON | IL | 62216 | BECKER ALICIA M | Clinton | 73365 | SUGAR CREEK | 900100 | 9001 | 1276.9135 | 1 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 136.0789 | 139.2850 | 138.2776 | 1300 | RESIDENTIAL | PERSON | EAST BROOK ESTATES 2ND ADDN | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 05-05-20-251-039 | 17 | 027 | 605 N ASH ST | TRENTON | IL | 62293 | ARENTSEN DEBORAH E ET AL | Clinton | 73365 | SUGAR CREEK | 900100 | 9001 | 8836.6120 | 4 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 146.8923 | 152.3962 | 150.9029 | PERSON | 327390 | MEYER CONCRETE PRODUCTS INC. | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 05-05-24-208-015 | 17 | 027 | 119 BRIARWOOD LN | AVISTON | IL | 62216 | RAKERS LISA M WINKELER | Clinton | 73365 | SUGAR CREEK | 900100 | 9001 | 471.0639 | 1 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 139.9727 | 141.0323 | 140.6634 | 1300 | RESIDENTIAL | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||
| 03-03-10-201-012 | 17 | 027 | 21512 FOX DR | IRISHTOWN | IL | 62231 | LONG LAWRENCE JR | Clinton | 37673 | IRISHTOWN | 900404 | 9004.0400 | 1584.4618 | 1 | 1 | 2 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 144.5437 | 148.4552 | 146.4818 | 7210 | CAMP_SITE | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||
| 08-08-06-177-006 | 17 | 027 | 15908 WALNUT DR | CARLYLE | IL | 62231 | MC INTOSH RYAN KACIE | Clinton | 11241 | CARLYLE | 900404 | 9004.0400 | 1417.3878 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 144.0541 | 144.6664 | 144.3241 | PERSON | 6216 | MCINTOSH CONTRACTING | HOME_SERVICE | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||
| 05-05-24-114-008 | 17 | 027 | 499 REDWOOD DR | AVISTON | IL | 62216 | ALEXANDER BARBARA J | Clinton | 73365 | SUGAR CREEK | 900100 | 9001 | 1020.0990 | 1 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 142.5517 | 143.3848 | 143.0581 | 1300 | RESIDENTIAL | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||
| 05-05-24-253-007 | 17 | 027 | 202 KUES AVE | AVISTON | IL | 62216 | LOHMAN DENNIS J BARBARA | Clinton | 73365 | SUGAR CREEK | 900100 | 9001 | 1161.4361 | 1 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 139.7434 | 140.6041 | 140.2311 | 1300 | RESIDENTIAL | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||
| 15-14-13-261-005 | 17 | 027 | CENTRAL CITY SCHOOLS TRANSPORTA… | CENTRALIA | IL | 62801 | EASY SPACE STORAGE LLC | Clinton | 08732 | BROOKSIDE | 900500 | 9005 | 644.5439 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 149.4519 | 150.1800 | 149.9383 | BUSINESS | 531130 | WESTSIDE STORAGE CENTRALIA - W … | SELF STORAGE FACILITY | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 11-10-18-134-001 | 17 | 027 | 11 W INDIANA ST | NEW BADEN | IL | 62265 | LAKETOP PROPERTIES LLC | Clinton | 44667 | LOOKING GLASS | 900602 | 9006.0200 | 1417.8945 | 1 | 1 | 2 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 137.6309 | 138.2572 | 138.0552 | BUSINESS | 53119 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 05-05-19-207-005 | 17 | 027 | 659 W 3RD ST | TRENTON | IL | 62293 | HILL OXFORD THREE LLC | Clinton | 73365 | SUGAR CREEK | 900100 | 9001 | 1310.6303 | 1 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 151.2884 | 152.2244 | 151.9027 | BUSINESS | 3111 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 08-08-18-307-001 | 17 | 027 | 1070 12TH ST | CARLYLE | IL | 62231 | JONDRO JOSHUA KRISTINA | Clinton | 11241 | CARLYLE | 900403 | 9004.0300 | 764.3212 | 0 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 140.0623 | 140.6108 | 140.3651 | PERSON | 7225 | CRAVE SHAVE ICE | CASUAL_EATERY | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 14-13-13-152-010 | 17 | 027 | 109 W 5TH ST | HOFFMAN | IL | 62250 | SCHLAU JEFFREY A BEVERLY J | Clinton | 40871 | LAKE | 900500 | 9005 | 2341.0651 | 2 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 138.5333 | 139.1223 | 138.8527 | PERSON | 54143 | THE SIGN SHOP | DESIGN_SERVICE | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 11-10-16-100-004 | 17 | 027 | 2241 STATE ROUTE 161 | NEW BADEN | IL | 62265 | PETERS MICHAEL A GAIL A | Clinton | 44667 | LOOKING GLASS | 900602 | 9006.0200 | 1946.5669 | 1 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 134.7373 | 135.7814 | 135.3052 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 05-05-20-203-003 | 17 | 027 | 418 E 4TH ST | TRENTON | IL | 62293 | KUHN BRIANNE S COLIN D | Clinton | 73365 | SUGAR CREEK | 900100 | 9001 | 865.6887 | 1 | 2 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 148.5419 | 150.8493 | 149.9680 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 06-06-22-219-001 | 17 | 027 | 312 S WALNUT ST | SAINT ROSE | IL | 62230 | CALIZ FRANCISCO RAMON ALVERES M… | Clinton | 07926 | BREESE | 900300 | 9003 | 1311.4406 | 1 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 136.6035 | 137.0523 | 136.8415 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 14-13-02-200-013 | 17 | 027 | 9605 HUEY RD | CARLYLE | IL | 62231 | CLARK BRADLEY JAMES KAYLA MARIE | Clinton | 40871 | LAKE | 900500 | 9005 | 18274.5236 | 2 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 134.1146 | 136.1575 | 135.1792 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 05-05-20-316-003 | 17 | 027 | 314 W KENTUCKY ST | TRENTON | IL | 62293 | TEBBE MICHELLE L | Clinton | 73365 | SUGAR CREEK | 900100 | 9001 | 872.7442 | 1 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 151.6319 | 152.3957 | 151.9627 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 11-10-18-105-002 | 17 | 027 | 7 W CEDAR ST | NEW BADEN | IL | 62265 | RAKERS BRADLEY CASSANDRA | Clinton | 44667 | LOOKING GLASS | 900602 | 9006.0200 | 921.1502 | 2 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 143.8184 | 144.1422 | 144.0066 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 06-06-15-311-031 | 17 | 027 | 15 N 7TH ST | BREESE | IL | 62230 | BUTTS AMY | Clinton | 07926 | BREESE | 900300 | 9003 | 1029.1760 | 1 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 140.7131 | 141.2590 | 141.0851 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 07-07-20-400-010 | 17 | 027 | 13823 HIGHLINE RD | CARLYLE | IL | 62231 | MENSING THOMAS J THERESA M | Clinton | 78344 | WADE | 900300 | 9003 | 8055.7889 | 2 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 133.2801 | 136.9490 | 135.6958 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 12-11-03-106-007 | 17 | 027 | 1000 B ST | GERMANTOWN | IL | 62245 | HUSMANN DERRICK P | Clinton | 29054 | GERMANTOWN | 900601 | 9006.0100 | 2374.4573 | 2 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 132.1765 | 133.3584 | 132.8889 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 07-07-14-300-009 | 17 | 027 | 16213 OLD US HIGHWAY 50 | CARLYLE | IL | 62231 | KOCH JAMES P | Clinton | 78344 | WADE | 900403 | 9004.0300 | 3225.9005 | 2 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 138.8272 | 140.8503 | 140.1732 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 15-14-01-100-014 | 17 | 027 | 29145 COLLEGE RD | CENTRALIA | IL | 62801 | LEWIS JACK MARILYN S | Clinton | 08732 | BROOKSIDE | 900401 | 9004.0100 | 13674.5892 | 2 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 143.6321 | 145.5616 | 144.9798 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 05-05-19-203-020 | 17 | 027 | 723 W BROADWAY | TRENTON | IL | 62293 | NELP JORDAN JONES SARAH L | Clinton | 73365 | SUGAR CREEK | 900100 | 9001 | 4019.7621 | 4 | 1 | 1 | 17027C | 2026-01-22 | X | AREA OF MINIMAL FLOOD HAZARD | 152.0776 | 153.8501 | 153.0049 | PERSON | 2026.2 | 2024 |