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 = '059'
14,914 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20 | 059 | 100 E CENTRAL AVE | KS | KANSAS DEPT OF WILDLIFE & PARKS | FRANKLIN | 59700 | RICHMOND | 954500 | 9545 | 5952.9063 | 1 | 1 | 2 | — | 309.8325 | 312.2607 | 311.0265 | 1300 | RESIDENTIAL | GOVERNMENT | 19S | 13 | 19E | S13 T19S R19E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 0301182802008002000 | 20 | 059 | 310 E 3RD ST | KS | KINGMAN OIL LLC | FRANKLIN | 16900 | CUTLER | 954500 | 9545 | 1349.4212 | — | 272.7159 | 273.7786 | 273.1933 | BUSINESS | 17S | 28 | 21E | S28 T17S R21E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0300872504012004000 | 20 | 059 | 535 N BIRCH | KS | BRUCE LLC | FRANKLIN | 53550 | OTTAWA | 954200 | 9542 | 618.7600 | 1 | 1 | 1 | — | 276.7679 | 279.8229 | 278.2509 | BUSINESS | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 200 PRINCE ST | KS | KANSAS DEPT OF WILDLIFE & PARKS | FRANKLIN | 52350 | OHIO | 954500 | 9545 | 18307.6461 | — | 291.6581 | 296.6281 | 294.9033 | 7240 | STATE_PARK | GOVERNMENT | 18S | 14 | 19E | S14 T18S R19E | PRAIRIE SPIRIT RAIL TRAIL - PRI… | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 1627 CALIFORNIA RD | KS | STRANGE JOSEPH L & JOYCE M | FRANKLIN | 79325 | WILLIAMSBURG | 954101 | 9541.0100 | 485933.2524 | 2 | 1 | 1 | — | 344.9339 | 352.0950 | 349.2116 | PERSON | 18S | 7 | 18E | S7 T18S R18E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 469 OLD US 50TH HWY | KS | SHORT DEE D & VICKIE LOU | FRANKLIN | 79325 | WILLIAMSBURG | 954500 | 9545 | 80995.8876 | 2 | 1 | 1 | — | 310.1948 | 334.9630 | 318.6657 | PERSON | 18S | 13 | 17E | S13 T18S R17E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 1404 COLORADO RD | KS | REEKIE CHRIS C & LILA J | FRANKLIN | 79325 | WILLIAMSBURG | 954500 | 9545 | 645024.0373 | 3 | 1 | 1 | — | 334.9002 | 354.5179 | 349.4008 | PERSON | 18S | 18 | 18E | S18 T18S R18E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 1981 STAFFORD RD | KS | NELSON GLEN W & PEGGY E TRUSTS | FRANKLIN | 12475 | CENTROPOLIS | 954101 | 9541.0100 | 269957.0144 | 3 | 1 | 1 | — | 290.1628 | 310.1262 | 302.2644 | TRUST | 15S | 29 | 19E | S29 T15S R19E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 4591 COLORADO RD | KS | WRAY BEN W & LEAH R | FRANKLIN | 02075 | APPANOOSE | 954101 | 9541.0100 | 629714.2325 | 4 | — | 303.0254 | 324.9030 | 318.5344 | 8000 | FARMLAND | PERSON | 15S | 29 | 18E | S29 T15S R18E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 2090 VIRGINIA RD | KS | STEVENSON KENDALL A | FRANKLIN | 16900 | CUTLER | 954500 | 9545 | 151985.8149 | 1 | 1 | 1 | — | 264.4192 | 276.5143 | 269.8824 | PERSON | 17S | 33 | 21E | S33 T17S R21E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0301951500000003030 | 20 | 059 | 1487 OHIO RD | KS | FRANKLIN | 16900 | CUTLER | 954500 | 9545 | 15080.9658 | — | 298.1456 | 304.2535 | 301.4418 | 18S | 15 | 20E | S15 T18S R20E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 2224 OSBORNE TER | KS | SUNDSTROM FARMS | FRANKLIN | 53575 | OTTAWA | 954200 | 9542 | 279071.6788 | — | 266.2352 | 273.4498 | 272.0376 | 8000 | FARMLAND | PERSON | 16S | 33 | 19E | S33 T16S R19E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 3730 SHAWNEE RD | KS | HUBBEL RHONDA DAY & URBAN DIA… | FRANKLIN | 24375 | FRANKLIN | 954102 | 9541.0200 | 150129.5093 | — | 282.1604 | 289.7392 | 287.0426 | 8000 | FARMLAND | PERSON | 16S | 2 | 20E | S2 T16S R20E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 2890 FLORIDA RD | KS | GARROW NANCY L | FRANKLIN | 28750 | GREENWOOD | 954101 | 9541.0100 | 452109.2692 | — | 272.0471 | 280.1920 | 278.6673 | 8000 | FARMLAND | PERSON | 17S | 9 | 18E | S9 T17S R18E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 307 LABETTE RD | KS | SUNDSTROM HARRY P & LYLE W & R… | FRANKLIN | 28750 | GREENWOOD | 954101 | 9541.0100 | 39101.6733 | — | 273.3114 | 282.8748 | 280.4950 | 8000 | FARMLAND | TRUST | 17S | 12 | 17E | S12 T17S R17E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 3555 NEVADA RD | KS | RUMFORD RAYMOND GENE & LINDA L… | FRANKLIN | 53575 | OTTAWA | 954102 | 9541.0200 | 50457.4296 | — | 271.9362 | 274.6856 | 273.5464 | 8000 | FARMLAND | TRUST | 16S | 21 | 20E | S21 T16S R20E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 2855 SHAWNEE RD | KS | SEYLER EDWARD DEAN & MERNA L | FRANKLIN | 30925 | HAYES | 954102 | 9541.0200 | 227907.0167 | — | 279.7545 | 287.0508 | 283.3124 | 8000 | FARMLAND | PERSON | 15S | 36 | 19E | S36 T15S R19E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 4564 JOHN BROWN DR | KS | ROBERTS JAMES V | FRANKLIN | 16900 | CUTLER | 954500 | 9545 | 152849.4455 | 1 | 1 | — | 275.8925 | 297.0069 | 282.1737 | PERSON | 18S | 16 | 21E | S16 T18S R21E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 4339 HAMILTON TER | KS | SAVAGE JUDITH A TRUST | FRANKLIN | 16900 | CUTLER | 954500 | 9545 | 322717.3454 | 2 | — | 312.0602 | 327.6514 | 321.3580 | TRUST | 18S | 5 | 21E | S5 T18S R21E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 2407 OSBORNE TER | KS | D & G AVIATION LC | FRANKLIN | 53575 | OTTAWA | 954200 | 9542 | 37233.2022 | 4 | — | 270.9394 | 277.2128 | 273.6437 | BUSINESS | 16S | 27 | 19E | S27 T16S R19E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0301511100000005000 | 20 | 059 | KS | FRANKLIN | 28750 | GREENWOOD | 954101 | 9541.0100 | 1598.3607 | — | 276.0243 | 284.5721 | 280.5874 | 17S | 11 | 17E | S11 T17S R17E | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 194 OHIO TER | KS | KRATZBERG CARL J & CHERYL L | FRANKLIN | 59700 | RICHMOND | 954500 | 9545 | 508543.8366 | 1 | — | 285.9348 | 324.7037 | 314.5282 | PERSON | 19S | 15 | 20E | S15 T19S R20E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0301993000000004030 | 20 | 059 | 949 US-59 HWY | KS | MOYER RODNEY & KIRSTEN | FRANKLIN | 52350 | OHIO | 954500 | 9545 | 50111.6642 | 2 | — | 298.3241 | 303.0356 | 300.7518 | PERSON | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 3180 SAND CREEK RD | KS | RUMFORD RAYMOND GENE & LINDA L… | FRANKLIN | 53575 | OTTAWA | 954102 | 9541.0200 | 1075355.6780 | 1 | — | 268.4018 | 285.1783 | 276.7552 | TRUST | 16S | 20 | 20E | S20 T16S R20E | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 059 | 993 HAMILTON RD | KS | RANSOM MARY V TRUST | FRANKLIN | 33000 | HOMEWOOD | 954500 | 9545 | 570039.9235 | 8 | — | 337.8300 | 350.7857 | 346.5917 | TRUST | 18S | 4 | 18E | S4 T18S R18E | 2026.2 | 2024 |