Data Explorer
Query the US Nationwide Parcel Dataset
Request Sample Download
$1.75 / 1,000 records$100 minimum
0/80
Live SQL
SELECT * FROM "parcel_layer" 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 | taxyear | taxdistrict | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0171520302027007000 | 20 | 033 | 302 W MAIN ST | PROTECTION | KS | 67127 | ASHMORE DAVID & VIRGINIA | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 961.9731 | 1 | 1 | 1 | — | 564.3988 | 565.3309 | 564.9842 | 1300 | RESIDENTIAL | PERSON | 33S | 3 | 20W | S3 T33S R20W | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0171520302005001000 | 20 | 033 | 403 N BROADWAY AVE | PROTECTION | KS | 67127 | MURPHY & SMITH INC | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 958.2619 | 1 | 1 | 1 | — | 563.7999 | 564.4754 | 564.0995 | 3100 | INDUSTRIAL | BUSINESS | 33S | 3 | 20W | S3 T33S R20W | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0170830703001003000 | 20 | 033 | 500 E COTTONWOOD ST | COLDWATER | KS | 67029 | HARRINGTON BOBBY JOE & GAIL M | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 1495.6637 | 4 | 1 | 1 | — | 646.6250 | 648.3389 | 647.5998 | 1300 | RESIDENTIAL | PERSON | 32S | 7 | 18W | S7 T32S R18W | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0170711204024001000 | 20 | 033 | 402 S CENTRAL AVE | COLDWATER | KS | 67029 | C & E PROPERTIES LLC | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 1280.4912 | 2 | 2 | 1 | — | 638.1950 | 639.6967 | 639.0303 | 3100 | INDUSTRIAL | BUSINESS | 32S | 12 | 19W | S12 T32S R19W | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0171520301018003000 | 20 | 033 | 109 S JACKSON AVE | PROTECTION | KS | 67127 | ASHLOCK BILL | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 2624.5988 | 1 | 1 | 1 | — | 560.7769 | 562.0480 | 561.4314 | 1300 | RESIDENTIAL | PERSON | 33S | 3 | 20W | S3 T33S R20W | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0170830702007004010 | 20 | 033 | 401 N LEAVENWORTH AVE | COLDWATER | KS | 67029 | TURLEY TIMOTHY & JOSEPH | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 847.6464 | 1 | 1 | 1 | — | 646.2429 | 647.2846 | 646.7237 | 1300 | RESIDENTIAL | PERSON | 32S | 7 | 18W | S7 T32S R18W | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0170241901003012000 | 20 | 033 | 104 W PLUMMER ST | WILMORE | KS | 67155 | YOST CLARK C & BETTY A | COMANCHE | 57325 | POWELL | 967600 | 9676 | 960.5880 | 1 | 1 | 1 | — | 616.7571 | 618.3330 | 617.7598 | 3300 | COMMERCIAL | PERSON | 31S | 19 | 17W | S19 T31S R17W | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0170711204010002000 | 20 | 033 | 109 N FRISCO AVE | COLDWATER | KS | 67029 | FREUND MATTHEW A & AMANDA M | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 954.9176 | 1 | 1 | 1 | — | 641.6040 | 643.0433 | 642.2596 | 1300 | RESIDENTIAL | PERSON | 32S | 12 | 19W | S12 T32S R19W | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0170830704011007000 | 20 | 033 | 105 S TOPEKA AVE | COLDWATER | KS | 67029 | JONES TERESA L | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 609.9075 | 1 | 1 | 1 | — | 639.6149 | 642.1458 | 641.1929 | 1300 | RESIDENTIAL | PERSON | 32S | 7 | 18W | S7 T32S R18W | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0170841802004003010 | 20 | 033 | 504 S PHILADELPHIA AVE | COLDWATER | KS | 67029 | LOUSCH J ROGER TRUST | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 787.9785 | 4 | 1 | 1 | — | 635.0960 | 636.9491 | 635.8572 | 1300 | RESIDENTIAL | TRUST | 32S | 18 | 18W | S18 T32S R18W | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0171520303004002000 | 20 | 033 | 211 W OLIVE ST | PROTECTION | KS | 67127 | PINNICK JAMIE L | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 1306.1752 | 3 | 1 | 1 | — | 564.3510 | 565.1140 | 564.8290 | 1300 | RESIDENTIAL | PERSON | 33S | 3 | 20W | S3 T33S R20W | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0170830703017005000 | 20 | 033 | 307 E MAIN ST | COLDWATER | KS | 67029 | RUSH CURTIS L | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 1262.7872 | 1 | 2 | 1 | — | 643.2689 | 645.0791 | 644.4102 | 2100 | RETAIL | PERSON | 32S | 7 | 18W | S7 T32S R18W | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0171611200000002000 | 20 | 033 | 0 COUNTY RD | KS | 67127 | PETRO DIANE K PETRO POLLY A | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 634477.6116 | 9 | — | 541.6920 | 547.5626 | 544.4800 | PERSON | 211111 211120 | 34S | 12 | 20W | S12 T34S R20W | SANDRIDGE - SALLY 3420 1-12H ST… | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 0171520302034006000 | 20 | 033 | 206 E OLIVE ST | PROTECTION | KS | 67127 | CIMARRON ICE LLC | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 956.9730 | 2 | 1 | 1 | — | 563.4149 | 564.0609 | 563.7336 | 1300 | RESIDENTIAL | BUSINESS | 33S | 3 | 20W | S3 T33S R20W | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0171520302017003000 | 20 | 033 | 204 N GRANT AVE | PROTECTION | KS | 67127 | MCCUISTON STEPHEN & MEGAN | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 2003.9854 | 1 | 1 | — | 563.1760 | 563.9161 | 563.6664 | 1300 | RESIDENTIAL | PERSON | 33S | 3 | 20W | S3 T33S R20W | 2024 | |||||||||||||||||||||||||||||||||||||||||||
| 0171520302011007000 | 20 | 033 | 301 N BROADWAY AVE | PROTECTION | KS | 67127 | JELLISON GARY & TERESA | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 322.3910 | 2 | 2 | — | 563.6480 | 564.1263 | 563.9047 | 2100 | RETAIL | PERSON | 33S | 3 | 20W | S3 T33S R20W | KANSAS TWISTED SISTERS | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 0170711204008008000 | 20 | 033 | 100 N CENTRAL AVE | COLDWATER | KS | 67029 | GERSTNER DAVID F | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 364.1471 | 1 | 1 | — | 642.1510 | 643.4913 | 642.8031 | 2100 | RETAIL | PERSON | 32S | 12 | 19W | S12 T32S R19W | 2024 | |||||||||||||||||||||||||||||||||||||||||||
| 0170583400000001000 | 20 | 033 | 0 COUNTY RD | KS | 67127 | DUNTEMAN ROGER | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 323694.7863 | — | 590.3369 | 596.7237 | 594.0174 | PERSON | 211120 211111 | 31S | 34 | 20W | S34 T31S R20W | SANDRIDGE - TEAL 1-27H STATION | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 0171520301005005000 | 20 | 033 | 408 E CHESTNUT ST | PROTECTION | KS | 67127 | KOCH JARRETT & ANDREA | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 1926.5825 | 1 | 1 | — | 563.7299 | 564.7689 | 564.2614 | 1300 | RESIDENTIAL | PERSON | 33S | 3 | 20W | S3 T33S R20W | 2024 | |||||||||||||||||||||||||||||||||||||||||||
| 0170830702004001000 | 20 | 033 | 510 N BALTIMORE AVE | COLDWATER | KS | 67029 | CARRITHERS STEVEN | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 1327.0181 | 2 | — | 644.3060 | 646.3178 | 645.1756 | 1300 | RESIDENTIAL | PERSON | 32S | 7 | 18W | S7 T32S R18W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0170241900000013000 | 20 | 033 | 201 W GRANT ST | WILMORE | KS | 67155 | BOOTH JOE ETAL | COMANCHE | 57325 | POWELL | 967600 | 9676 | 4211.2124 | 4 | — | 628.9559 | 633.7869 | 631.2568 | 1300 | RESIDENTIAL | PERSON | 31S | 19 | 17W | S19 T31S R17W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0171520302013001000 | 20 | 033 | 308 W CHESTNUT ST | PROTECTION | KS | 67127 | WAIT JR MERLE D | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 3928.0100 | 1 | 1 | 1 | — | 563.4310 | 564.4390 | 563.8344 | PERSON | 33S | 3 | 20W | S3 T33S R20W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0171592900000002000 | 20 | 033 | 1072 RD 2 | PROTECTION | KS | 67127 | JARNAGIN KAREN | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 643944.3267 | 1 | 1 | 1 | — | 543.0300 | 550.8118 | 546.3196 | PERSON | 33S | 29 | 20W | S29 T33S R20W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0171420900000001000 | 20 | 033 | 1377 RD 10 | COLDWATER | KS | 67029 | JELLISON RUTH ANN | COMANCHE | 14725 | COLDWATER | 967600 | 9676 | 630735.3731 | 3 | 1 | 1 | — | 586.5726 | 610.4136 | 599.8661 | PERSON | 33S | 9 | 19W | S9 T33S R19W | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0171520302001001000 | 20 | 033 | 208 E OAK ST | PROTECTION | KS | 67127 | SNYDER JEREMIAH & ALMITA JO EL… | COMANCHE | 57875 | PROTECTION | 967600 | 9676 | 3900.5609 | 1 | 1 | 1 | — | 564.1439 | 565.5795 | 564.4904 | PERSON | 33S | 3 | 20W | S3 T33S R20W | 2024 |