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 = '117'
9,995 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0581682700000002010 | 20 | 117 | 2306 HWY 77 | KS | SMERCHEK FAMILY REAL ESTATE LLC | MARSHALL | 75975 | WATERVILLE | 070182 | 701.8200 | 32419.4873 | 1 | 1 | 2 | — | 384.6464 | 397.5985 | 393.5058 | 3100 | INDUSTRIAL | BUSINESS | 4S | 27 | 6E | S27 T4S R6E | TITAN TRAILER MANUFACTURING | MANUFACTURER | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0581742004027001000 | 20 | 117 | 106 W 5TH ST | KS | HEINEN COLBY L. & JENNIFER J. | MARSHALL | 07700 | BLUE RAPIDS CITY | 070182 | 701.8200 | 4165.6250 | 1 | 1 | 2 | — | 351.5335 | 352.4249 | 352.0538 | 1300 | RESIDENTIAL | PERSON | 4S | 20 | 7E | S20 T4S R7E | MUSTANG MOTORS | VEHICLE_DEALER | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0580952104004003000 | 20 | 117 | KS | STUDER TRUCK LINE INC | MARSHALL | 29225 | GUITTARD | 090186 | 901.8600 | 1318.9502 | 1 | 1 | 1 | — | 399.7950 | 401.8544 | 400.7879 | 1300 | RESIDENTIAL | BUSINESS | 2S | 21 | 9E | S21 T2S R9E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 0580783301001001000 | 20 | 117 | KS | MHS FAMILY ENTERPRISES LLC | MARSHALL | 45050 | MARYSVILLE | 060510 | 605.1000 | 307.8479 | 1 | 1 | — | 377.2024 | 378.5903 | 378.0972 | 1300 | RESIDENTIAL | BUSINESS | 2S | 33 | 7E | S33 T2S R7E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 0581683400000004040 | 20 | 117 | KS | A.T.M.S. REAL ESTATE LLLP | MARSHALL | 75975 | WATERVILLE | 070182 | 701.8200 | 357117.4264 | 2 | 1 | 1 | — | 377.2387 | 409.3403 | 393.4885 | BUSINESS | 4S | 34 | 6E | S34 T4S R6E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0581672500000002000 | 20 | 117 | KS | BLUE RIVER FARMS LLC | MARSHALL | 75975 | WATERVILLE | 070182 | 701.8200 | 281089.9624 | 1 | 1 | 1 | — | 339.3857 | 354.0992 | 347.6090 | BUSINESS | 4S | 25 | 6E | S25 T4S R6E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0581652202013016020 | 20 | 117 | KS | MARSHALL COUNTY RAILROAD HISTOR… | MARSHALL | 75975 | WATERVILLE | 070182 | 701.8200 | 2221.8176 | 3 | 1 | 1 | — | 356.9109 | 358.2557 | 357.5555 | NONPROFIT | 4S | 22 | 6E | S22 T4S R6E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0582410200000009000 | 20 | 117 | KS | LANDOLL PROPERTIES LLC | MARSHALL | 07675 | BLUE RAPIDS | 070182 | 701.8200 | 57770.0061 | 1 | — | 345.7536 | 350.8353 | 348.0589 | 8000 | FARMLAND | BUSINESS | 5S | 2 | 7E | S2 T5S R7E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0581351500000003020 | 20 | 117 | KS | BRENNER JORDAN & JOSIE | MARSHALL | 11850 | CENTER | 040701 | 407.0100 | 126394.0474 | 1 | 1 | 1 | — | 376.7637 | 402.8783 | 389.8069 | PERSON | 3S | 15 | 8E | S15 T3S R8E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0580952101002004010 | 20 | 117 | KS | O'NEIL RONALD L & LAURA M | MARSHALL | 29225 | GUITTARD | 090186 | 901.8600 | 539.4523 | 1 | — | 403.0371 | 404.3514 | 403.8675 | 1300 | RESIDENTIAL | PERSON | 2S | 21 | 9E | S21 T2S R9E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0581951603008012000 | 20 | 117 | 124 E 2ND ST | KS | GUERIN MARLON | MARSHALL | 73550 | VERMILLION | 040701 | 407.0100 | 459.8243 | — | 348.7073 | 349.3608 | 348.9630 | PERSON | 4S | 16 | 9E | S16 T4S R9E | SARAH'S SALON | PERSONAL_OR_BEAUTY_SERVICE | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0581311100000003000 | 20 | 117 | KS | JMP PROPERTIES LLC | MARSHALL | 11850 | CENTER | 040701 | 407.0100 | 1288651.5599 | 2 | 1 | 1 | — | 374.0544 | 407.9320 | 393.5631 | BUSINESS | 3S | 11 | 8E | S11 T3S R8E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0581410200000003010 | 20 | 117 | KS | JENKINS WILLIAMJENKINS MARKJE… | MARSHALL | 20600 | ELM CREEK | 060510 | 605.1000 | 864036.1615 | — | 354.3977 | 388.4447 | 366.4941 | PERSON | 3S | 2 | 7E | S2 T3S R7E | SCHELL CREEK | HISTORIC_SITE | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0582011100000018000 | 20 | 117 | KS | BUCKLES C C | MARSHALL | 50850 | NOBLE | 040701 | 407.0100 | 836.8380 | — | 361.2319 | 361.4147 | 361.3306 | 8000 | FARMLAND | PERSON | 4S | 11 | 10E | S11 T4S R10E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0582321000000001000 | 20 | 117 | KS | KANSAS STATE OF | MARSHALL | 06725 | BIGELOW | 040701 | 407.0100 | 224212.5216 | — | 339.7358 | 364.6881 | 347.6921 | GOVERNMENT | 5S | 10 | 8E | S10 T5S R8E | BIGELOW, KANSAS | HISTORIC_SITE | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0582382700000002010 | 20 | 117 | 1686 CHEYENNE LN | KS | CLINE LANCE E | MARSHALL | 06725 | BIGELOW | 040701 | 407.0100 | 622185.9131 | 2 | — | 386.9292 | 416.8779 | 405.7822 | PERSON | 5S | 27 | 8E | S27 T5S R8E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0581062301002003000 | 20 | 117 | KS | RONNEBAUM LAWRENCE & JOANN | MARSHALL | 49275 | MURRAY | 090186 | 901.8600 | 1508.9055 | — | 408.3794 | 410.3616 | 409.2989 | 1300 | RESIDENTIAL | PERSON | 2S | 23 | 10E | S23 T2S R10E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0581652202011009010 | 20 | 117 | KS | MANN TONY D & ANN L | MARSHALL | 75975 | WATERVILLE | 070182 | 701.8200 | 90.2695 | 1 | 1 | 1 | — | 358.1015 | 358.6430 | 358.3394 | PERSON | 4S | 22 | 6E | S22 T4S R6E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0580782803022003000 | 20 | 117 | KS | LUCKEROTH MASONRY INC | MARSHALL | 45050 | MARYSVILLE | 060510 | 605.1000 | 540.4448 | — | 352.0234 | 352.8149 | 352.3533 | 1300 | RESIDENTIAL | BUSINESS | 2S | 28 | 7E | S28 T2S R7E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0581572600000002000 | 20 | 117 | 5TH RD | KS | MEYER PAULA | MARSHALL | 75025 | WALNUT | 070182 | 701.8200 | 318566.0807 | — | 390.0085 | 406.8006 | 397.9672 | PERSON | 3S | 26 | 6E | S26 T3S R6E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0581693200000001000 | 20 | 117 | KS | UNITED STATES NATURAL RESOURCES… | MARSHALL | 75975 | WATERVILLE | 070182 | 701.8200 | 649887.7695 | — | 351.5748 | 401.5782 | 376.1398 | GOVERNMENT | GOVT FEDERAL | CLOSED | V | GRASSLAND RESERVE PROGRAM (GRP)… | CONSERVATION EASEMENT | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0581961300000007000 | 20 | 117 | KS | WAGNER DIANE M | MARSHALL | 73550 | VERMILLION | 040701 | 407.0100 | 383038.2351 | 5 | — | 344.7947 | 380.8067 | 357.8536 | PERSON | 4S | 13 | 9E | S13 T4S R9E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0581593000000001000 | 20 | 117 | 2ND RD | KS | TGBG LLC | MARSHALL | 75025 | WALNUT | 070182 | 701.8200 | 242661.1338 | — | 386.9568 | 408.5415 | 399.1947 | BUSINESS | 3S | 30 | 6E | S30 T3S R6E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0581093200000001010 | 20 | 117 | KS | PORTING EDWARD & MARLAPORTING … | MARSHALL | 49275 | MURRAY | 040701 | 407.0100 | 382681.9985 | 1 | — | 404.6193 | 427.0950 | 417.3525 | PERSON | 2S | 32 | 10E | S32 T2S R10E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0581782800000017000 | 20 | 117 | KS | ALCOVE RANCH L C | MARSHALL | 07700 | BLUE RAPIDS CITY | 070182 | 701.8200 | 53257.8754 | — | 351.3633 | 364.2568 | 357.2656 | PERSON | 4S | 28 | 7E | S28 T4S R7E | 2026.2 | 2024 |