Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
38/80
Live SQL
SELECT * FROM "lr_parcel_us" WHERE statefp = '20' AND countyfp = '075'
4,367 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0381930701036008000 | 20 | 075 | 308 N SUMNER ST | KS | FULLMER CALF RANCH LLC | HAMILTON | 69875 | SYRACUSE | 958600 | 9586 | 623.7335 | 1 | 1 | 1 | — | 986.1281 | 987.4707 | 986.8759 | 1300 | RESIDENTIAL | BUSINESS | 24S | 7 | 40W | S7 T24S R40W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0381930701034007000 | 20 | 075 | 301 N JOHNSON ST | KS | CRITTENDEN WILBUR | HAMILTON | 69875 | SYRACUSE | 958600 | 9586 | 650.5622 | 2 | 1 | 1 | — | 984.6112 | 984.8340 | 984.7142 | 1300 | RESIDENTIAL | PERSON | 24S | 7 | 40W | S7 T24S R40W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0381761300000001000 | 20 | 075 | KS | NON-GOVERNMENTAL ORGANIZATION | HAMILTON | 45650 | MEDWAY | 958600 | 9586 | 2575585.8237 | — | 1004.0823 | 1035.9356 | 1012.9917 | PERSON | 24S | 13 | 42W | S13 T24S R42W | NGO | CLOSED | V | ARKANSAS RIVER EASEMENT | CONSERVATION EASEMENT | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 0381430800000003000 | 20 | 075 | KS | MEYER JENNIFER T | HAMILTON | 15425 | COOLIDGE | 958600 | 9586 | 320227.1327 | — | 1052.5449 | 1067.2915 | 1060.9046 | 8000 | FARMLAND | PERSON | 23S | 8 | 42W | S8 T23S R42W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0382783400000002000 | 20 | 075 | KS | WESTEMAN LAND LLC | HAMILTON | 04850 | BEAR CREEK | 958600 | 9586 | 319058.7160 | — | 1041.1710 | 1046.7165 | 1045.1429 | 8000 | FARMLAND | BUSINESS | 26S | 34 | 42W | S34 T26S R42W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0382562400000001000 | 20 | 075 | KS | RIDDELL MARTHA CORNWELL | HAMILTON | 04850 | BEAR CREEK | 958600 | 9586 | 1284316.5443 | — | 1055.8923 | 1087.0649 | 1070.0260 | 8000 | FARMLAND | PERSON | 25S | 24 | 43W | S24 T25S R43W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0382330600000003000 | 20 | 075 | KS | BERGES PHYLLIS & LYLEOLIVER E… | HAMILTON | 04850 | BEAR CREEK | 958600 | 9586 | 629724.0989 | — | 1055.1114 | 1077.3637 | 1065.5648 | 8000 | FARMLAND | PERSON | 25S | 6 | 41W | S6 T25S R41W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0383011100000003000 | 20 | 075 | KS | PLANE VIEW FARMS LLC | HAMILTON | 38275 | LAMONT | 958600 | 9586 | 620372.6340 | — | 1017.1711 | 1020.4480 | 1018.7902 | 8000 | FARMLAND | BUSINESS | 26S | 11 | 39W | S11 T26S R39W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0381930604017004010 | 20 | 075 | KS | THOMECZEK THOMAS L & JANET S | HAMILTON | 69875 | SYRACUSE | 958600 | 9586 | 392.2843 | — | 998.1221 | 998.5839 | 998.3991 | 1300 | RESIDENTIAL | PERSON | 24S | 6 | 40W | S6 T24S R40W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0381820300000002000 | 20 | 075 | KS | WINNER CIRCLE FEEDYARD SYRACUSE… | HAMILTON | 69875 | SYRACUSE | 958600 | 9586 | 1237971.1084 | — | 990.9956 | 1006.1495 | 993.8455 | BUSINESS | 24S | 3 | 41W | S3 T24S R41W | WINNER CIRCLE FEEDYARD | B2B_SERVICE | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0381672500000003000 | 20 | 075 | KS | HELFRICH RICHARD F | HAMILTON | 15425 | COOLIDGE | 958600 | 9586 | 647892.9367 | — | 1042.7026 | 1053.1015 | 1047.8426 | 8000 | FARMLAND | PERSON | 24S | 25 | 43W | S25 T24S R43W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0381930802017004000 | 20 | 075 | KS | ALVARADO MARCILINA CARMENSHARP… | HAMILTON | 69875 | SYRACUSE | 958600 | 9586 | 751.7361 | — | 982.8436 | 983.8944 | 983.1107 | 1300 | RESIDENTIAL | PERSON | 24S | 8 | 40W | S8 T24S R40W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0382441800000002000 | 20 | 075 | KS | HATCHER CATTLE INC | HAMILTON | 04850 | BEAR CREEK | 958600 | 9586 | 1294384.5300 | — | 1087.0527 | 1107.1922 | 1099.1528 | 8000 | FARMLAND | BUSINESS | 25S | 18 | 42W | S18 T25S R42W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0380520300000003000 | 20 | 075 | KS | BOLTZ ARTHUR C & PENNY J | HAMILTON | 59325 | RICHLAND | 958600 | 9586 | 633901.0181 | — | 1166.6721 | 1170.1015 | 1168.6093 | 8000 | FARMLAND | PERSON | 21S | 3 | 43W | S3 T21S R43W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0381652200000001000 | 20 | 075 | KS | KERSHNER TERRY L & VALORY A TR… | HAMILTON | 15425 | COOLIDGE | 958600 | 9586 | 1919945.0735 | — | 1052.2181 | 1069.0285 | 1060.6467 | 8000 | FARMLAND | TRUST | 24S | 22 | 43W | S22 T24S R43W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0381672500000001000 | 20 | 075 | KS | KERSHNER TERRY L & VALORY A TR… | HAMILTON | 15425 | COOLIDGE | 958600 | 9586 | 1310923.3187 | — | 1041.6702 | 1060.8209 | 1051.2375 | 8000 | FARMLAND | TRUST | 24S | 25 | 43W | S25 T24S R43W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0381672500000002000 | 20 | 075 | KS | HELFRICH RICHARD F | HAMILTON | 15425 | COOLIDGE | 958600 | 9586 | 647689.4307 | — | 1047.2856 | 1059.9035 | 1051.6471 | 8000 | FARMLAND | PERSON | 24S | 25 | 43W | S25 T24S R43W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0382730600000003000 | 20 | 075 | KS | THE SALVATION ARMYCHURCH 1ST B… | HAMILTON | 04850 | BEAR CREEK | 958600 | 9586 | 604440.8858 | — | 1052.3822 | 1061.9764 | 1055.5900 | 8000 | FARMLAND | NONPROFIT | 26S | 6 | 42W | S6 T26S R42W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0381020300000001000 | 20 | 075 | 0 COUNTY RD | KS | MAUNE MATT M & BECKY S | HAMILTON | 36425 | KENDALL | 958600 | 9586 | 619385.9420 | — | 1042.2023 | 1050.4256 | 1046.3903 | PERSON | 22S | 3 | 39W | S3 T22S R39W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0381072500000002010 | 20 | 075 | 0 COUNTY RD | KS | BROWN RONALD HBROWN LINDA R | HAMILTON | 36425 | KENDALL | 958600 | 9586 | 321705.1951 | — | 1040.5970 | 1043.6959 | 1041.5361 | PERSON | 22S | 25 | 39W | S25 T22S R39W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0382030600000001010 | 20 | 075 | 0 COUNTY RD | KS | SIMON DALTON J | HAMILTON | 36425 | KENDALL | 958600 | 9586 | 316760.0696 | — | 1005.9407 | 1015.0740 | 1010.7283 | PERSON | 24S | 6 | 39W | S6 T24S R39W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0382030500000002000 | 20 | 075 | 0 COUNTY RD | KS | SIMON EARL J & DONNA J LIVING … | HAMILTON | 36425 | KENDALL | 958600 | 9586 | 310869.4826 | — | 1011.9488 | 1021.0473 | 1016.3225 | TRUST | 24S | 5 | 39W | S5 T24S R39W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0381930703002006000 | 20 | 075 | 8 S MAIN ST | KS | MARTINEZ MIGUEL & ALMA D | HAMILTON | 69875 | SYRACUSE | 958600 | 9586 | 673.9777 | — | 984.8851 | 985.3143 | 985.0631 | PERSON | 24S | 7 | 40W | S7 T24S R40W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0381561400000007000 | 20 | 075 | KS | LEWIS MARSHAREED WILLIAM R | HAMILTON | 15425 | COOLIDGE | 958600 | 9586 | 3414.1128 | — | 1031.7231 | 1035.6226 | 1033.2440 | PERSON | 23S | 14 | 43W | S14 T23S R43W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| 0381230500000002000 | 20 | 075 | KS | MILLER DONALD & TONI LIVING TR… | HAMILTON | 40075 | LIBERTY | 958600 | 9586 | 1312724.9622 | — | 1037.1978 | 1053.7825 | 1045.9159 | TRUST | 23S | 5 | 40W | S5 T23S R40W | 2026.2 | 2024 |