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 = '17' AND countyfp = '051'
21,800 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13-06-17-204-001 | 17 | 051 | 106 S SUPERIOR ST | RAMSEY | IL | 62080 | OTTO BLAINE E | 2781 N 1000 ST | FAYETTE | 62640 | RAMSEY | 950700 | 9507 | 1123.1983 | -11100 | -11100 | -11100 | 16650 | 9000 | 2006-03-31 | 1 | 1 | 1 | — | 186.8385 | 187.1478 | 187.0394 | COMMERCIAL | PERSON | 71394 | VILLAGE OF RAMSEY 106 SUPERIOR … | 8N | 17 | 1E | S17 T8N R1E | 1627-345 | ST JOSEPH'S FOOD PANTRY & CLOTH… | GYM | 2024 | |||||||||||||||||||||||||||||||
| 18-14-09-376-007 | 17 | 051 | 1121 N SIXTH ST | VANDALIA | IL | 62471 | STEPHENSON EVONNE | 873 N 1100 ST | FAYETTE | 77330 | VANDALIA | 950800 | 9508 | 856.9602 | -41858 | -41858 | -41858 | 62787 | 37000 | 2015-10-16 | 2 | 1 | 1 | — | 158.7763 | 159.5149 | 159.2719 | COMMERCIAL | PERSON | CITY OF VANDALIA PT N1/2 OL 67 … | 6N | 9 | 1E | S9 T6N R1E | - | THRIVE WELLNESS | BEHAVIORAL_OR_MENTAL_HEALTH_CLI… | 2024 | ||||||||||||||||||||||||||||||||
| 10-04-22-400-024 | 17 | 051 | 3239 N 2175TH ST | BEECHER CITY | IL | 62414 | HOLSTE JESSICA | 3239 N 2175 ST | FAYETTE | 44901 | LOUDON | 950500 | 9505 | 4046.3481 | -14336 | -14336 | -14336 | 21504 | 0 | 2022-08-19 | 2 | 1 | 1 | 13278 | — | 173.1733 | 182.4431 | 179.5224 | RESIDENTIAL IMPROVED | PERSON | SECTION 22-9N-3E PT N1/2 SE 177… | 9N | 22 | 3E | S22 T9N R3E | 2342-175 | 2024 | |||||||||||||||||||||||||||||||||
| 19-16-16-400-001 | 17 | 051 | 1534 N 2050TH ST | BROWNSTOWN | IL | 62418 | STINE JARED | 1534 N 2050 ST | FAYETTE | 81022 | WHEATLAND | 951100 | 9511 | 40647.9963 | -134952 | -134952 | -134952 | 202428 | 0 | 2011-06-29 | 2 | 1 | 1 | — | 174.4743 | 182.4439 | 180.7981 | FARM WITH IMPROVEMENTS | PERSON | SEC 16-6N-3E N1/2 W1/2 SE LOT 1… | 6N | 16 | 3E | S16 T6N R3E | - | 2024 | ||||||||||||||||||||||||||||||||||
| 01-12-28-200-008 | 17 | 051 | 2104 E 2000TH AVE | SAINT ELMO | IL | 62458 | AVENA TOWNSHIP | 2205 E 2300 AVE | FAYETTE | 03155 | AVENA | 950500 | 9505 | 37643.5869 | -7070 | -7070 | -7070 | 10605 | 17500 | 2008-12-15 | 1 | 1 | 2 | — | 172.1331 | 188.0959 | 180.2366 | EXEMPT | PERSON | SEC 28-7N-3E EPT NE N OF RR BK … | 7N | 28 | 3E | S28 T7N R3E | - | 2024 | ||||||||||||||||||||||||||||||||||
| 13-06-08-482-001 | 17 | 051 | 329 E THIRD ST | RAMSEY | IL | 62080 | PHILBRICK WALTER S | 329 E 3RD ST | FAYETTE | 62640 | RAMSEY | 950700 | 9507 | 1687.7989 | -32824 | -32824 | -32824 | 49236 | 80000 | 2022-09-20 | 2 | 1 | 1 | — | 184.8837 | 185.6718 | 185.3642 | RESIDENTIAL IMPROVED | PERSON | SEC 8-8-1E,PT SE COR WPT SE SE … | 8N | 8 | 1E | S8 T8N R1E | GR2344-247 | 2024 | ||||||||||||||||||||||||||||||||||
| 18-14-08-378-010 | 17 | 051 | 1802 W FILLMORE ST | VANDALIA | IL | 62471 | CHILDERS KEVIN J | PO BOX 179 | FAYETTE | 77330 | VANDALIA | 950800 | 9508 | 14245.4439 | -204436 | -204436 | -204436 | 306654 | 67000 | 2008-07-14 | 1 | 1 | 1 | — | 160.8114 | 167.6553 | 164.2814 | RESIDENTIAL IMPROVED | PERSON | CITY OF VANDALIA PT OL 31 408 X… | 6N | 8 | 1E | S8 T6N R1E | - | 2024 | ||||||||||||||||||||||||||||||||||
| 18-14-16-112-004 | 17 | 051 | 822 W WASHINGTON ST | VANDALIA | IL | 62471 | CONEY SHAWNA K | 822 W WASHINGTON AVE | FAYETTE | 77330 | VANDALIA | 950800 | 9508 | 645.8275 | -36054 | -36054 | -36054 | 54081 | 85000 | 2023-01-27 | 2 | 1 | 3 | — | 156.2300 | 157.9927 | 157.1515 | RESIDENTIAL IMPROVED | PERSON | CITY OF VANDALIA LOT 4 BLK 1 60… | 6N | 16 | 1E | S16 T6N R1E | GR2355-283 | 2024 | ||||||||||||||||||||||||||||||||||
| 13-02-20-201-009 | 17 | 051 | 756 E 3300TH AVE | RAMSEY | IL | 62080 | VANUYTVEN STEPHEN | 60 US HIGHWAY 51 | FAYETTE | 62640 | RAMSEY | 950700 | 9507 | 4408.2808 | -26604 | -26604 | -26604 | 39906 | 45000 | 2018-07-23 | 1 | 1 | 1 | — | 195.9636 | 197.1705 | 196.4313 | RESIDENTIAL IMPROVED | PERSON | SECTION 20-9N-1E PT NW NE BK 22… | 9N | 20 | 1E | S20 T9N R1E | 2201-68 | 2024 | ||||||||||||||||||||||||||||||||||
| 18-14-09-358-004 | 17 | 051 | 1004 N EIGHTH ST | VANDALIA | IL | 62471 | LURKINS ALAN L | 1215 US HIGHWAY 40 | FAYETTE | 77330 | VANDALIA | 950800 | 9508 | 514.0172 | -76110 | -76110 | -76110 | 114165 | 0 | 2023-06-16 | 2 | 1 | 1 | — | 157.7456 | 158.1667 | 158.0048 | RESIDENTIAL IMPROVED | PERSON | CITY OF VANDALIA LOT 6 55 X 100… | 6N | 9 | 1E | S9 T6N R1E | GR2367-91 | 2024 | ||||||||||||||||||||||||||||||||||
| 09-20-22-202-004 | 17 | 051 | 406 E RAILROAD ST | ST. PETER | IL | 62880 | HEINZMAN-HALL KELLY A | 406 E RAILROAD ST | FAYETTE | 44459 | LONE GROVE | 951100 | 9511 | 1068.0255 | -32082 | -32082 | -32082 | 48123 | 21000 | 2014-01-28 | 1 | 1 | 1 | — | 181.2250 | 181.5011 | 181.3550 | RESIDENTIAL IMPROVED | PERSON | VILLAGE OF ST PETER LOT 6 W1/2 … | 5N | 22 | 3E | S22 T5N R3E | GR2055-440 | 2024 | ||||||||||||||||||||||||||||||||||
| 01-12-27-152-001 | 17 | 051 | 106 S CHESTNUT ST | SAINT ELMO | IL | 62458 | WORMAN CHRIS L | 106 S CHESTNUT ST | FAYETTE | 03155 | AVENA | 950500 | 9505 | 1344.7117 | -37498 | -37498 | -37498 | 56247 | 65000 | 2023-05-03 | 2 | 1 | 1 | — | 186.8067 | 187.7928 | 187.2523 | RESIDENTIAL IMPROVED | PERSON | CITY OF ST ELMO LOT 25 26 142 X… | 7N | 27 | 3E | S27 T7N R3E | GR2364-181 | 2024 | ||||||||||||||||||||||||||||||||||
| 13-06-08-480-003 | 17 | 051 | 311 E THIRD ST | RAMSEY | IL | 62080 | ELLER ANTHONY B | 311 E THIRD ST | FAYETTE | 62640 | RAMSEY | 950700 | 9507 | 625.1835 | -59536 | -59536 | -59536 | 89304 | 34000 | 2001-07-01 | 1 | 1 | 2 | — | 185.8003 | 186.0576 | 185.9309 | RESIDENTIAL IMPROVED | PERSON | VILLAGE OF RAMSEY,LOT 1 69 X 97… | 8N | 8 | 1E | S8 T8N R1E | 1305-302 | 2024 | ||||||||||||||||||||||||||||||||||
| 18-14-09-376-004 | 17 | 051 | 625 W FILLMORE ST | VANDALIA | IL | 62471 | STITT NATALIE | 625 W FILLMORE ST | FAYETTE | 77330 | VANDALIA | 950800 | 9508 | 644.6032 | -45510 | -45510 | -45510 | 68265 | 107000 | 2024-06-17 | 1 | 1 | 2 | — | 157.8804 | 158.3196 | 158.1495 | RESIDENTIAL IMPROVED | PERSON | CITY OF VANDALIA SE COR W1/2 N1… | 6N | 9 | 1E | S9 T6N R1E | 2395-121 | 2024 | ||||||||||||||||||||||||||||||||||
| 14-11-11-300-006 | 17 | 051 | 2245 N 1650TH ST | BROWNSTOWN | IL | 62418 | STONECIPHER MATTHEW R | 2245 N 1650 ST | FAYETTE | 68549 | SEFTON | 950600 | 9506 | 60963.5871 | -125462 | -125462 | -125462 | 188193 | 0 | 2013-01-11 | 3 | 1 | 1 | — | 167.2581 | 174.1768 | 171.6777 | WOODED ACREAGE TRANSITION | PERSON | SEC 11-7N-2E E 15A N1/2 NE SW B… | 7N | 11 | 2E | S11 T7N R2E | - | 2024 | ||||||||||||||||||||||||||||||||||
| 14-11-06-200-007 | 17 | 051 | 2353 N 1300TH ST | BROWNSTOWN | IL | 62418 | BARKER DANIEL C | 2353 N 1300 ST | FAYETTE | 68549 | SEFTON | 950600 | 9506 | 5472.8170 | -15692 | -15692 | -15692 | 23538 | 0 | 2001-01-01 | 1 | 1 | 1 | — | 161.1216 | 164.6505 | 162.5368 | RESIDENTIAL IMPROVED | PERSON | SEC 6-7N-2E SE COR NE BK 2126 P… | 7N | 6 | 2E | S6 T7N R2E | 1275-235 | 2024 | ||||||||||||||||||||||||||||||||||
| 01-12-27-203-004 | 17 | 051 | 411 N MAIN ST | ST. ELMO | IL | 62458 | ST ELMO CITY OF | 411 N MAIN ST | FAYETTE | 03155 | AVENA | 950500 | 9505 | 312.9595 | -12524 | -12524 | -12524 | 18786 | 1250 | 1991-09-01 | 1 | 1 | — | 188.7115 | 189.1518 | 188.9443 | EXEMPT | GOVERNMENT | CITY OF ST ELMO,19 S SIDE LOT 5… | 7N | 27 | 3E | S27 T7N R3E | 866-23 | CITY OF SAINT ELMO, IL | GOVERNMENT_OFFICE | 2024 | |||||||||||||||||||||||||||||||||
| 18-14-09-102-002 | 17 | 051 | 907 W WYANDOTTE ST | VANDALIA | IL | 62471 | CHATHAM BRYAN LEE | 1018 W WYANDOTTE ST | FAYETTE | 77330 | VANDALIA | 950800 | 9508 | 1396.3764 | -42212 | -42212 | -42212 | 63318 | 80000 | 2024-11-15 | 1 | 1 | 1 | — | 157.1479 | 158.6655 | 157.9246 | RESIDENTIAL IMPROVED | PERSON | CITY OF VANDALIA LOTS 1 2 BLK 6… | 6N | 9 | 1E | S9 T6N R1E | 2024 | |||||||||||||||||||||||||||||||||||
| 07-18-16-486-002 | 17 | 051 | SHOBONIER POST OFFICE | KASKASKIA | IL | 62885 | MILLER JOHN | 906 N 885 ST | FAYETTE | 39116 | KASKASKIA | 951000 | 9510 | 982.1251 | -1710 | -1710 | -1710 | 2565 | 3750 | 2017-11-27 | 1 | 1 | — | 157.0566 | 157.6082 | 157.3518 | RESIDENTIAL IMPROVED | PERSON | VILLAGE OF SHOBONIER FRONT ROW … | 5N | 16 | 1E | S16 T5N R1E | 2180-389 | 2024 | |||||||||||||||||||||||||||||||||||
| 07-18-20-200-001 | 17 | 051 | 754 E 900TH AVE | SHOBONIER | IL | 62885 | SAPP ROBBIN C | 752 E 900 AVE | FAYETTE | 39116 | KASKASKIA | 951000 | 9510 | 14147.4425 | -23680 | -23680 | -23680 | 35520 | 0 | 1998-06-01 | 2 | 2 | — | 141.0854 | 146.8619 | 144.5218 | RESIDENTIAL IMPROVED | PERSON | SEC 20-5N-1E PT NW NE BK 2234 P… | 5N | 20 | 1E | S20 T5N R1E | 1136-294 | 2024 | |||||||||||||||||||||||||||||||||||
| 05-01-31-300-002 | 17 | 051 | 23 E 3000TH AVE | BINGHAM | IL | 62011 | CLARK THOMAS W | 2245 S 14TH ST | FAYETTE | 36802 | HURRICANE | 950700 | 9507 | 144808.5912 | -19370 | -19370 | -19370 | 29055 | 118500 | 2017-02-07 | 1 | 1 | — | 183.7223 | 194.6267 | 190.2437 | FARM WITH IMPROVEMENTS | PERSON | SEC 31-9N-1W SW SW BK 2155 P 155 | 9N | 31 | 1W | S31 T9N R1W | 2155-155 | 2024 | |||||||||||||||||||||||||||||||||||
| 18-14-21-106-003 | 17 | 051 | 810 S POPLAR ST | VANDALIA | IL | 62471 | HANNA DAVID A | 1875 N 1275 ST | FAYETTE | 77330 | VANDALIA | 950900 | 9509 | 992.8285 | -11542 | -11542 | -11542 | 17313 | 0 | 2023-04-28 | 1 | 1 | — | 173.1282 | 179.5987 | 176.6417 | RESIDENTIAL IMPROVED | PERSON | CITY OF VANDALIA OUT LOT 3 BLK … | 6N | 21 | 1E | S21 T6N R1E | GR2364-14 | 2024 | |||||||||||||||||||||||||||||||||||
| 01-12-04-400-001 | 17 | 051 | 2070 E 2350TH AVE | SAINT ELMO | IL | 62458 | MORRISON JARED W | 2050 E 2350 AVE | FAYETTE | 03155 | AVENA | 950500 | 9505 | 120988.9969 | -16126 | -16126 | -16126 | 24189 | 0 | 2018-10-16 | 1 | 1 | — | 174.0975 | 183.3374 | 180.5525 | FARMLAND WITHOUT IMPROVEMENTS | PERSON | SEC 4-7N-3E NW SE EXCEPT SE NW … | 7N | 4 | 3E | S4 T7N R3E | 2208-475 | 2024 | |||||||||||||||||||||||||||||||||||
| 15-17-20-100-010 | 17 | 051 | 149 E 850TH AVE | VANDALIA | IL | 62471 | DOTHAGER KENNETH E | 220 N 5TH ST | FAYETTE | 68601 | SEMINARY | 951000 | 9510 | 81822.9712 | -12316 | -12316 | -12316 | 18474 | 0 | 2021-04-16 | 2 | 1 | — | 155.3344 | 161.3874 | 158.9297 | FARM WITH IMPROVEMENTS | PERSON | SEC 20-5N-1W E1/2 SE NW BK 2290… | 5N | 20 | 1W | S20 T5N R1W | GR2290 P467 | 2024 | |||||||||||||||||||||||||||||||||||
| 01-12-27-135-003 | 17 | 051 | 105 N LOCUST ST | ST. ELMO | IL | 62458 | CARSON LLOYD A JR | 114 N OLIVE ST | FAYETTE | 03155 | AVENA | 950500 | 9505 | 725.3251 | -29430 | -29430 | -29430 | 44145 | 36000 | 2013-02-22 | 2 | 1 | — | 188.2817 | 188.7259 | 188.4698 | RESIDENTIAL IMPROVED | PERSON | CITY OF ST ELMO LOT 5 BLK 9 B F… | 7N | 27 | 3E | S27 T7N R3E | - | 2024 |