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 = '117'

9,995 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
0581682700000002010201172306 HWY 77KSSMERCHEK FAMILY REAL ESTATE LLCMARSHALL75975WATERVILLE070182701.820032419.4873112384.6464397.5985393.50583100INDUSTRIALBUSINESS4S276ES27 T4S R6ETITAN TRAILER MANUFACTURINGMANUFACTURER2026.22024
058174200402700100020117106 W 5TH STKSHEINEN COLBY L. & JENNIFER J.MARSHALL07700BLUE RAPIDS CITY070182701.82004165.6250112351.5335352.4249352.05381300RESIDENTIALPERSON4S207ES20 T4S R7EMUSTANG MOTORSVEHICLE_DEALER2026.22024
058095210400400300020117KSSTUDER TRUCK LINE INCMARSHALL29225GUITTARD090186901.86001318.9502111399.7950401.8544400.78791300RESIDENTIALBUSINESS2S219ES21 T2S R9E2026.22024
058078330100100100020117 KSMHS FAMILY ENTERPRISES LLCMARSHALL45050MARYSVILLE060510605.1000307.847911377.2024378.5903378.09721300RESIDENTIALBUSINESS2S337ES33 T2S R7E2026.22024
058168340000000404020117KSA.T.M.S. REAL ESTATE LLLPMARSHALL75975WATERVILLE070182701.8200357117.4264211377.2387409.3403393.4885BUSINESS4S346ES34 T4S R6E2026.22024
058167250000000200020117KSBLUE RIVER FARMS LLCMARSHALL75975WATERVILLE070182701.8200281089.9624111339.3857354.0992347.6090BUSINESS4S256ES25 T4S R6E2026.22024
058165220201301602020117KSMARSHALL COUNTY RAILROAD HISTOR…MARSHALL75975WATERVILLE070182701.82002221.8176311356.9109358.2557357.5555NONPROFIT4S226ES22 T4S R6E2026.22024
058241020000000900020117KSLANDOLL PROPERTIES LLCMARSHALL07675BLUE RAPIDS070182701.820057770.00611345.7536350.8353348.05898000FARMLANDBUSINESS5S27ES2 T5S R7E2026.22024
058135150000000302020117KSBRENNER JORDAN & JOSIEMARSHALL11850CENTER040701407.0100126394.0474111376.7637402.8783389.8069PERSON3S158ES15 T3S R8E2026.22024
058095210100200401020117KSO'NEIL RONALD L & LAURA MMARSHALL29225GUITTARD090186901.8600539.45231403.0371404.3514403.86751300RESIDENTIALPERSON2S219ES21 T2S R9E2026.22024
058195160300801200020117124 E 2ND STKSGUERIN MARLONMARSHALL73550VERMILLION040701407.0100459.8243348.7073349.3608348.9630PERSON4S169ES16 T4S R9ESARAH'S SALONPERSONAL_OR_BEAUTY_SERVICE2026.22024
058131110000000300020117KSJMP PROPERTIES LLCMARSHALL11850CENTER040701407.01001288651.5599211374.0544407.9320393.5631BUSINESS3S118ES11 T3S R8E2026.22024
058141020000000301020117KSJENKINS WILLIAMJENKINS MARKJE…MARSHALL20600ELM CREEK060510605.1000864036.1615354.3977388.4447366.4941PERSON3S27ES2 T3S R7ESCHELL CREEKHISTORIC_SITE2026.22024
058201110000001800020117KSBUCKLES C CMARSHALL50850NOBLE040701407.0100836.8380361.2319361.4147361.33068000FARMLANDPERSON4S1110ES11 T4S R10E2026.22024
058232100000000100020117KSKANSAS STATE OFMARSHALL06725BIGELOW040701407.0100224212.5216339.7358364.6881347.6921GOVERNMENT5S108ES10 T5S R8EBIGELOW, KANSASHISTORIC_SITE2026.22024
0582382700000002010201171686 CHEYENNE LNKSCLINE LANCE EMARSHALL06725BIGELOW040701407.0100622185.91312386.9292416.8779405.7822PERSON5S278ES27 T5S R8E2026.22024
058106230100200300020117KSRONNEBAUM LAWRENCE & JOANNMARSHALL49275MURRAY090186901.86001508.9055408.3794410.3616409.29891300RESIDENTIALPERSON2S2310ES23 T2S R10E2026.22024
058165220201100901020117KSMANN TONY D & ANN LMARSHALL75975WATERVILLE070182701.820090.2695111358.1015358.6430358.3394PERSON4S226ES22 T4S R6E2026.22024
058078280302200300020117KSLUCKEROTH MASONRY INCMARSHALL45050MARYSVILLE060510605.1000540.4448352.0234352.8149352.35331300RESIDENTIALBUSINESS2S287ES28 T2S R7E2026.22024
058157260000000200020117 5TH RD KSMEYER PAULAMARSHALL75025WALNUT070182701.8200318566.0807390.0085406.8006397.9672PERSON3S266ES26 T3S R6E2026.22024
058169320000000100020117KSUNITED STATES NATURAL RESOURCES…MARSHALL75975WATERVILLE070182701.8200649887.7695351.5748401.5782376.1398GOVERNMENTGOVT FEDERALCLOSEDVGRASSLAND RESERVE PROGRAM (GRP)…CONSERVATION EASEMENT2026.22024
058196130000000700020117KSWAGNER DIANE MMARSHALL73550VERMILLION040701407.0100383038.23515344.7947380.8067357.8536PERSON4S139ES13 T4S R9E2026.22024
058159300000000100020117 2ND RD KSTGBG LLCMARSHALL75025WALNUT070182701.8200242661.1338386.9568408.5415399.1947BUSINESS3S306ES30 T3S R6E2026.22024
058109320000000101020117KSPORTING EDWARD & MARLAPORTING …MARSHALL49275MURRAY040701407.0100382681.99851404.6193427.0950417.3525PERSON2S3210ES32 T2S R10E2026.22024
058178280000001700020117KSALCOVE RANCH L CMARSHALL07700BLUE RAPIDS CITY070182701.820053257.8754351.3633364.2568357.2656PERSON4S287ES28 T4S R7E2026.22024