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
017242040000000200020033962 AVE YKSMICHIGAN WISCONSIN PIPE LINE CO…COMANCHE03525AVILLA967600967638559.70593544.2390552.5072548.50653110FARMYARDBUSINESS48621035S419WS4 T35S R19WANR PIPELINE - BUTTERMILK STATI…2026.22024
017024190200700400020033205 S SHERMAN STKSDUDLEY JERRYCOMANCHE57325POWELL9676009676625.8265211623.5351624.9940624.27701300RESIDENTIALPERSON31S1917WS19 T31S R17W2026.22024
017024190100201500020033308 N MAIN STKSMEDCALF RONALD DEANCOMANCHE57325POWELL96760096761313.2483211614.7839615.6710615.18621300RESIDENTIALPERSON31S1917WS19 T31S R17W2026.22024
017083070400800300020033800 E MAIN STKSCROCKETT JEANNE & BILLY ETALCOMANCHE14725COLDWATER9676009676654.6140111643.2059644.5107643.77671300RESIDENTIALPERSON32S718WS7 T32S R18W2026.22024
0171720400000002000200330 COUNTY RDKSGIRK TRUST GARY W & CHARLOTTE ACOMANCHE03525AVILLA96760096762516023.0412562.7550614.5999591.4345TRUST211111 21112034S419WS4 T34S R19WSANDRIDGE - PEPPER 3419 1-4H ST…2026.22024
017083070200200100020033510 N PHILADELPHIA AVEKSBROWN REBECCA JBROWN CHRISTINECOMANCHE14725COLDWATER96760096761932.4644211644.6110647.9811646.03851300RESIDENTIALPERSON32S718WS7 T32S R18W2026.22024
017024190200400600020033106 S TAFT STKSMETZGER CHARLESCOMANCHE57325POWELL96760096761443.687222618.3916622.2269619.95373300COMMERCIALPERSON31S1917WS19 T31S R17W2026.22024
017076240000000400020033KSCITY OF COLDWATERCOMANCHE14725COLDWATER9676009676781784.58031312607.4559626.7371615.25907240PARKGOVERNMENT32S2419WS24 T32S R19W2026.22024
017024190201000500020033306 S TAFT STKSAGUA FRIA LAND & CATTLE LLCCOMANCHE57325POWELL96760096761287.44732625.8411628.0349627.20931300RESIDENTIALBUSINESS31S1917WS19 T31S R17W2026.22024
017041010000000101020033KSMCKINNEY DENNIS & JEANCOMANCHE14725COLDWATER9676009676634784.9475111663.1879675.3972669.9611PERSON31S119WS1 T31S R19W2026.22024
0171342000000001000200331171 RD 15KSKAY JENNIFER RCOMANCHE03525AVILLA9676009676640380.56125596.2880609.7379603.6061PERSON33S2018WS20 T33S R18W2026.22024
017152030301400305020033KSSMITH LARRY G & DEBRA JCOMANCHE57875PROTECTION9676009676685.5377564.0209565.4820564.38791300RESIDENTIALPERSON33S320WS3 T33S R20W2026.22024
017065160000000101020033KSKERSTETTER DOUG DCOMANCHE57875PROTECTION96760096761060100.0127574.3234582.2321578.96118000FARMLANDPERSON32S1620WS16 T32S R20W2026.22024
017041010000000100020033KSROBBINS GARY LCOMANCHE14725COLDWATER9676009676629194.8763670.0130682.8982675.29508000FARMLANDPERSON31S119WS1 T31S R19W2026.22024
017083070400700200020033KSBARNARD CHRISCOMANCHE14725COLDWATER9676009676653.2443643.7210645.4455644.66691300RESIDENTIALPERSON32S718WS7 T32S R18W2026.22024
017152030100200202020033KSPAGE BRUCE & SUECOMANCHE57875PROTECTION96760096761261.0483563.4329564.5902563.92001300RESIDENTIALPERSON33S320WS3 T33S R20W2026.22024
017083070401600600020033KSCOMANCHE COUNTYCOMANCHE14725COLDWATER96760096762906.0989641.7869644.0044642.89973100INDUSTRIALPERSON32S718WS7 T32S R18W2026.22024
017024190200400500020033KSMETZGER CHARLESCOMANCHE57325POWELL96760096761000.0826620.8073622.7689621.90763300COMMERCIALPERSON31S1917WS19 T31S R17W2026.22024
017024190100401300020033KSBOOTH JOE ETALCOMANCHE57325POWELL9676009676364.1979620.7951623.0380621.84331300RESIDENTIALPERSON31S1917WS19 T31S R17W2026.22024
017024190201000300020033KSWASDEN GEORGE RAY TRUST ETALCOMANCHE57325POWELL96760096761043.6894628.0024629.3179628.50201300RESIDENTIALTRUST31S1917WS19 T31S R17W2026.22024
0171720900000001000200330 COUNTY RDKSJJR PROPERTIES KANSAS LLCCOMANCHE03525AVILLA96760096762651044.8335549.2666606.2617569.9017BUSINESS486210AMERICAN WARRIOR - COLTER WEST …2026.22024
0171983300000003000200330 COUNTY RDKSHAAS TRENTON H & MELISSA DCOMANCHE14725COLDWATER9676009676618597.9844545.1722580.5789566.0525PERSON34S3317WS33 T34S R17W2026.22024
0172030800000006000200330 COUNTY RDKSKANSAS DEPT OF WILDLIFE & PARKSCOMANCHE14725COLDWATER9676009676160839.6127515.4010541.4780530.5412GOVERNMENT34S816WS8 T34S R16W2026.22024
0171151600000003000200330 COUNTY RDKSOASIS DIRECT SEVEN LLCCOMANCHE14725COLDWATER9676009676326982.9537518.3492545.2689529.9357BUSINESS33S1616WS16 T33S R16W2026.22024
0170373600000003000200331821 AVE UNIT GKSBOWMAN JAMES D & JUDITH ECOMANCHE14725COLDWATER96760096761268335.3787641.8649658.3439652.7563PERSON31S3618WS36 T31S R18W2026.22024