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 = '033'
3,561 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0172420400000002000 | 20 | 033 | 962 AVE Y | KS | MICHIGAN WISCONSIN PIPE LINE CO… | COMANCHE | 03525 | AVILLA | 967600 | 9676 | 38559.7059 | 3 | — | 544.2390 | 552.5072 | 548.5065 | 3110 | FARMYARD | BUSINESS | 486210 | 35S | 4 | 19W | S4 T35S R19W | ANR PIPELINE - BUTTERMILK STATI… | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0170241902007004000 | 20 | 033 | 205 S SHERMAN ST | KS | DUDLEY JERRY | COMANCHE | 57325 | POWELL | 967600 | 9676 | 625.8265 | 2 | 1 | 1 | — | 623.5351 | 624.9940 | 624.2770 | 1300 | RESIDENTIAL | PERSON | 31S | 19 | 17W | S19 T31S R17W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0170241901002015000 | 20 | 033 | 308 N MAIN ST | KS | MEDCALF RONALD DEAN | COMANCHE | 57325 | POWELL | 967600 | 9676 | 1313.2483 | 2 | 1 | 1 | — | 614.7839 | 615.6710 | 615.1862 | 1300 | RESIDENTIAL | PERSON | 31S | 19 | 17W | S19 T31S R17W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0170830704008003000 | 20 | 033 | 800 E MAIN ST | KS | CROCKETT JEANNE & BILLY ETAL | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 654.6140 | 1 | 1 | 1 | — | 643.2059 | 644.5107 | 643.7767 | 1300 | RESIDENTIAL | PERSON | 32S | 7 | 18W | S7 T32S R18W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0171720400000002000 | 20 | 033 | 0 COUNTY RD | KS | GIRK TRUST GARY W & CHARLOTTE A | COMANCHE | 03525 | AVILLA | 967600 | 9676 | 2516023.0412 | — | 562.7550 | 614.5999 | 591.4345 | TRUST | 211111 211120 | 34S | 4 | 19W | S4 T34S R19W | SANDRIDGE - PEPPER 3419 1-4H ST… | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0170830702002001000 | 20 | 033 | 510 N PHILADELPHIA AVE | KS | BROWN REBECCA JBROWN CHRISTINE | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 1932.4644 | 2 | 1 | 1 | — | 644.6110 | 647.9811 | 646.0385 | 1300 | RESIDENTIAL | PERSON | 32S | 7 | 18W | S7 T32S R18W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0170241902004006000 | 20 | 033 | 106 S TAFT ST | KS | METZGER CHARLES | COMANCHE | 57325 | POWELL | 967600 | 9676 | 1443.6872 | 2 | 2 | — | 618.3916 | 622.2269 | 619.9537 | 3300 | COMMERCIAL | PERSON | 31S | 19 | 17W | S19 T31S R17W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 0170762400000004000 | 20 | 033 | KS | CITY OF COLDWATER | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 781784.5803 | 13 | 1 | 2 | — | 607.4559 | 626.7371 | 615.2590 | 7240 | PARK | GOVERNMENT | 32S | 24 | 19W | S24 T32S R19W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 0170241902010005000 | 20 | 033 | 306 S TAFT ST | KS | AGUA FRIA LAND & CATTLE LLC | COMANCHE | 57325 | POWELL | 967600 | 9676 | 1287.4473 | 2 | — | 625.8411 | 628.0349 | 627.2093 | 1300 | RESIDENTIAL | BUSINESS | 31S | 19 | 17W | S19 T31S R17W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 0170410100000001010 | 20 | 033 | KS | MCKINNEY DENNIS & JEAN | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 634784.9475 | 1 | 1 | 1 | — | 663.1879 | 675.3972 | 669.9611 | PERSON | 31S | 1 | 19W | S1 T31S R19W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0171342000000001000 | 20 | 033 | 1171 RD 15 | KS | KAY JENNIFER R | COMANCHE | 03525 | AVILLA | 967600 | 9676 | 640380.5612 | 5 | — | 596.2880 | 609.7379 | 603.6061 | PERSON | 33S | 20 | 18W | S20 T33S R18W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0171520303014003050 | 20 | 033 | KS | SMITH LARRY G & DEBRA J | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 685.5377 | — | 564.0209 | 565.4820 | 564.3879 | 1300 | RESIDENTIAL | PERSON | 33S | 3 | 20W | S3 T33S R20W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0170651600000001010 | 20 | 033 | KS | KERSTETTER DOUG D | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 1060100.0127 | — | 574.3234 | 582.2321 | 578.9611 | 8000 | FARMLAND | PERSON | 32S | 16 | 20W | S16 T32S R20W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0170410100000001000 | 20 | 033 | KS | ROBBINS GARY L | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 629194.8763 | — | 670.0130 | 682.8982 | 675.2950 | 8000 | FARMLAND | PERSON | 31S | 1 | 19W | S1 T31S R19W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0170830704007002000 | 20 | 033 | KS | BARNARD CHRIS | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 653.2443 | — | 643.7210 | 645.4455 | 644.6669 | 1300 | RESIDENTIAL | PERSON | 32S | 7 | 18W | S7 T32S R18W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0171520301002002020 | 20 | 033 | KS | PAGE BRUCE & SUE | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 1261.0483 | — | 563.4329 | 564.5902 | 563.9200 | 1300 | RESIDENTIAL | PERSON | 33S | 3 | 20W | S3 T33S R20W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0170830704016006000 | 20 | 033 | KS | COMANCHE COUNTY | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 2906.0989 | — | 641.7869 | 644.0044 | 642.8997 | 3100 | INDUSTRIAL | PERSON | 32S | 7 | 18W | S7 T32S R18W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0170241902004005000 | 20 | 033 | KS | METZGER CHARLES | COMANCHE | 57325 | POWELL | 967600 | 9676 | 1000.0826 | — | 620.8073 | 622.7689 | 621.9076 | 3300 | COMMERCIAL | PERSON | 31S | 19 | 17W | S19 T31S R17W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0170241901004013000 | 20 | 033 | KS | BOOTH JOE ETAL | COMANCHE | 57325 | POWELL | 967600 | 9676 | 364.1979 | — | 620.7951 | 623.0380 | 621.8433 | 1300 | RESIDENTIAL | PERSON | 31S | 19 | 17W | S19 T31S R17W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0170241902010003000 | 20 | 033 | KS | WASDEN GEORGE RAY TRUST ETAL | COMANCHE | 57325 | POWELL | 967600 | 9676 | 1043.6894 | — | 628.0024 | 629.3179 | 628.5020 | 1300 | RESIDENTIAL | TRUST | 31S | 19 | 17W | S19 T31S R17W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0171720900000001000 | 20 | 033 | 0 COUNTY RD | KS | JJR PROPERTIES KANSAS LLC | COMANCHE | 03525 | AVILLA | 967600 | 9676 | 2651044.8335 | — | 549.2666 | 606.2617 | 569.9017 | BUSINESS | 486210 | AMERICAN WARRIOR - COLTER WEST … | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 0171983300000003000 | 20 | 033 | 0 COUNTY RD | KS | HAAS TRENTON H & MELISSA D | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 618597.9844 | — | 545.1722 | 580.5789 | 566.0525 | PERSON | 34S | 33 | 17W | S33 T34S R17W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0172030800000006000 | 20 | 033 | 0 COUNTY RD | KS | KANSAS DEPT OF WILDLIFE & PARKS | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 160839.6127 | — | 515.4010 | 541.4780 | 530.5412 | GOVERNMENT | 34S | 8 | 16W | S8 T34S R16W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0171151600000003000 | 20 | 033 | 0 COUNTY RD | KS | OASIS DIRECT SEVEN LLC | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 326982.9537 | — | 518.3492 | 545.2689 | 529.9357 | BUSINESS | 33S | 16 | 16W | S16 T33S R16W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0170373600000003000 | 20 | 033 | 1821 AVE UNIT G | KS | BOWMAN JAMES D & JUDITH E | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 1268335.3787 | — | 641.8649 | 658.3439 | 652.7563 | PERSON | 31S | 36 | 18W | S36 T31S R18W | 2026.2 | 2024 |