Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
39/80
Live SQL
SELECT * FROM "lr_parcel_us" WHERE statefp = '20' AND countyfp = '087'
15,510 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1392902006085000 | 20 | 087 | 9501 SHARON LN | KS | LOHMAN CHARLES CRAIG | LOHMAN … | JEFFERSON | 53950 | OZAWKIE | 020102 | 201.0200 | 1120.8960 | 1 | 1 | 1 | — | 314.5264 | 316.4937 | 315.6990 | 1300 | RESIDENTIAL | PERSON | 9S | 29 | 18E | S29 T9S R18E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0183300000004000 | 20 | 087 | 20067 198TH ST | KS | LOLLAR RANDOLPH L | JEFFERSON | 51475 | NORTON | 020200 | 202 | 282943.4361 | 2 | 1 | 1 | — | 329.8361 | 350.5357 | 340.9357 | PERSON | 7S | 33 | 20E | S33 T7S R20E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 2220400000006000 | 20 | 087 | 3971 PAWNEE RD | KS | MOWDER LESTER H & ELSIE L | JEFFERSON | 61700 | RURAL | 020300 | 203 | 3825.7955 | 2 | 1 | 1 | — | 302.1110 | 306.3293 | 304.2362 | PERSON | 11S | 4 | 19E | S4 T11S R19E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 0293001003003000 | 20 | 087 | 316 COTTAGE ST | KS | DEPOY BARRY L & FLORENCE A | JEFFERSON | 51475 | NORTON | 020200 | 202 | 666.4768 | 1 | 1 | 1 | — | 350.3481 | 351.5492 | 351.0062 | PERSON | 7S | 30 | 19E | S30 T7S R19E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 0972603026004000 | 20 | 087 | 406 SPRUCE ST | KS | HART CAREY | JEFFERSON | 35250 | JEFFERSON | 020200 | 202 | 624.0940 | 1 | 1 | 1 | — | 356.7160 | 357.3834 | 356.9884 | PERSON | 8S | 26 | 19E | S26 T8S R19E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 2120900000006020 | 20 | 087 | 3418 UNION RD | KS | JEFFERSON | 63100 | SARCOXIE | 020300 | 203 | 39124.3511 | 1 | — | 325.9001 | 339.8922 | 336.5221 | 8000 | MEADOW | 11S | 9 | 20E | S9 T11S R20E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0293100000010000 | 20 | 087 | 19451 OSAGE RD | KS | LOCKLIN DENISE M | JEFFERSON | 51475 | NORTON | 020200 | 202 | 798639.5253 | 5 | — | 324.1362 | 356.7582 | 342.7885 | PERSON | 7S | 31 | 19E | S31 T7S R19E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0293001006007000 | 20 | 087 | 518 WALNUT ST | KS | ROBEY WILLIAM N JR & BARBARA L | JEFFERSON | 51475 | NORTON | 020200 | 202 | 664.5999 | 1 | — | 349.4090 | 351.0065 | 350.1114 | PERSON | 7S | 30 | 19E | S30 T7S R19E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 1452100000022000 | 20 | 087 | 11340 K4 HWY | KS | JEFFERSON | 60575 | ROCK CREEK | 020101 | 201.0100 | 12465.6353 | 2 | 1 | 2 | — | 293.4489 | 304.9991 | 301.8193 | 9S | 21 | 17E | S21 T9S R17E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 2372602001017000 | 20 | 087 | 906 HARLAND CT | KS | PARAMORE MARC J | JEFFERSON | 36575 | KENTUCKY | 020102 | 201.0200 | 1091.0958 | 1 | — | 258.4349 | 259.4440 | 258.6259 | PERSON | 11S | 26 | 18E | S26 T11S R18E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 2292903004005000 | 20 | 087 | 13912 SECOND ST | KS | HALL LARRY | JEFFERSON | 61700 | RURAL | 020300 | 203 | 573.0041 | — | 258.5073 | 259.4947 | 258.9831 | PERSON | 11S | 29 | 19E | S29 T11S R19E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0183300000002000 | 20 | 087 | 20395 198TH ST | KS | LOLLAR ISAAC | JEFFERSON | 51475 | NORTON | 020200 | 202 | 3692.3001 | — | 346.1598 | 349.5101 | 347.7967 | PERSON | 7S | 33 | 20E | S33 T7S R20E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0293001033001000 | 20 | 087 | 421 PINE ST | KS | WILCOX ALVA E | JEFFERSON | 51475 | NORTON | 020200 | 202 | 1116.5286 | — | 345.3765 | 346.7068 | 346.0333 | PERSON | 7S | 30 | 19E | S30 T7S R19E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 1610100000008000 | 20 | 087 | 0 90TH ST | KS | BUSH MARK L | JEFFERSON | 60575 | ROCK CREEK | 020101 | 201.0100 | 2660.6789 | — | 290.5213 | 297.8436 | 295.7784 | PERSON | 10S | 1 | 16E | S1 T10S R16E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 1973600003051000 | 20 | 087 | 5082 COMANCHE LN | KS | LOSEY AIMEE | JEFFERSON | 63100 | SARCOXIE | 020300 | 203 | 1204.0474 | — | 303.8500 | 319.6162 | 315.7459 | PERSON | 10S | 36 | 19E | S36 T10S R19E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0282700000007010 | 20 | 087 | 0 202ND ST | KS | BIXBY DENISE L | JEFFERSON | 51475 | NORTON | 020200 | 202 | 154756.3528 | — | 324.1585 | 338.7868 | 331.0141 | PERSON | 7S | 27 | 19E | S27 T7S R19E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 1711104005035000 | 20 | 087 | 7455 SKYLINE DR | KS | CLARK RANDALL W | JEFFERSON | 22525 | FAIRVIEW | 020101 | 201.0100 | 1096.5199 | — | 295.5801 | 300.7198 | 298.1767 | PERSON | 10S | 11 | 17E | S11 T10S R17E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 1762402002017000 | 20 | 087 | 6829 LAKE RIDGE PKWY | KS | HUAMAN ANTONIO A | JEFFERSON | 22525 | FAIRVIEW | 020101 | 201.0100 | 847.2936 | — | 311.9696 | 315.4454 | 314.0580 | PERSON | 10S | 24 | 17E | S24 T10S R17E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 1762402002024000 | 20 | 087 | 6755 LAKE RIDGE PKWY | KS | MUMAW SANDRA L DEARING | JEFFERSON | 22525 | FAIRVIEW | 020101 | 201.0100 | 869.8177 | — | 314.7339 | 317.7244 | 316.6091 | PERSON | 10S | 24 | 17E | S24 T10S R17E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 1841701015003000 | 20 | 087 | 9796 MILITARY TRL N | KS | ARMSTRONG DAVID T | JEFFERSON | 22525 | FAIRVIEW | 020102 | 201.0200 | 266.5839 | — | 303.1952 | 305.3859 | 304.4137 | PERSON | 10S | 17 | 18E | S17 T10S R18E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0851500000001000 | 20 | 087 | 0 174TH ST | KS | OCHS FARMS LLC. | JEFFERSON | 17425 | DELAWARE | 020200 | 202 | 494719.4840 | — | 301.0906 | 326.0974 | 312.5862 | BUSINESS | 8S | 15 | 18E | S15 T8S R18E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 1762403001049000 | 20 | 087 | 7935 CHEROKEE CIR | KS | WILEY ROB E | JEFFERSON | 22525 | FAIRVIEW | 020101 | 201.0100 | 872.3643 | — | 293.3185 | 296.7221 | 295.0800 | PERSON | 10S | 24 | 17E | S24 T10S R17E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 2283300000002000 | 20 | 087 | 0 VACANT | KS | BERNS BRUCE POTTER | JEFFERSON | 61700 | RURAL | 020300 | 203 | 48295.4367 | — | 255.3829 | 257.6245 | 255.8239 | PERSON | 11S | 33 | 19E | S33 T11S R19E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0282700000006000 | 20 | 087 | 0 202ND ST | KS | SCHRICK ROBERT J & THERESE A | JEFFERSON | 51475 | NORTON | 020200 | 202 | 160506.5839 | — | 322.1465 | 339.8473 | 334.9062 | PERSON | 7S | 27 | 19E | S27 T7S R19E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 2130800000001040 | 20 | 087 | 0 35TH ST | KS | CRONEMEYER MARY B | JEFFERSON | 63100 | SARCOXIE | 020300 | 203 | 39446.9264 | — | 322.3519 | 337.9774 | 332.8650 | PERSON | 11S | 8 | 20E | S8 T11S R20E | 2026.2 | 2024 |