Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

37/80

Live SQL
SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '18' 
  AND countyfp = '171'

10,773 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
86040510000200001286040510000200001218171 IN0WARREN61632PRAIRIE9511009511337173.6022234.2834243.8914238.6341100PRAIRIE TOWNSHIP2026.2
86020734012300000286020734012300000218171#N OLD 55 SIDEINWARREN00496ADAMS9510019510.0100908.1489203.5699207.7787206.1461500ADAMS TOWNSHIP2026.2
86010820000900000786010820000900000718171#N E 975 N SIDEINWARREN48222MEDINA9510019510.0100888.6402211.0273212.5937211.7859510MEDINA TOWNSHIP2026.2
18171INUNITED STATES NATURAL RESOURCES…WARREN59958PINE9510019510.010081703.4941222.7218231.3382224.8158GOVERNMENTGOVT FEDERALCLOSEDVWETLANDS RESERVE PROGRAM (WRP),…CONSERVATION EASEMENT2026.2
18171INUNITED STATES NATURAL RESOURCES…WARREN80198WARREN9510019510.0100172841.9283154.0891161.0957156.3239GOVERNMENTGOVT FEDERALCLOSEDVWETLANDS RESERVE PROGRAM (WRP),…CONSERVATION EASEMENT2026.2
860304100001000011860304100001000011181711075 N AND ADEWAY NWINWARREN59958PINE9510019510.0100151179.1340242.0253247.7419244.0659100PINE TOWNSHIP2026.2
860303200002000011860303200002000011181710 E 1100 NINWARREN59958PINE9510019510.0100153032.6194238.3161245.7072241.5365100PINE TOWNSHIP2026.2
860306100001000011860306100001000011181715906 N 900 WINWARREN59958PINE9510019510.0100159411.4748208.6272222.9407217.0396100PINE TOWNSHIP2026.2
86040110000300001286040110000300001218171900 SINWARREN61632PRAIRIE9511009511140233.8753231.0680237.8649233.5885100PRAIRIE TOWNSHIP2026.2
86020620000300000186020620000300000118171 N ST RD 55 INWARREN00496ADAMS9510019510.0100649506.6064212.7994231.9418223.0748199ADAMS TOWNSHIP2026.2
8603051000020000118603051000020000111817110778 N 125 WINWARREN59958PINE9510019510.0100312527.1142223.3950239.8665230.5182101PINE TOWNSHIP2026.2
8603051000010000118603051000010000111817110778 N 125 WINWARREN59958PINE9510019510.0100150859.1377233.2439242.2512237.0410100PINE TOWNSHIP2026.2
860304100002000011860304100002000011181711075 N AND 50 WNWINWARREN59958PINE9510019510.0100145104.6042240.9172247.7965244.4768100PINE TOWNSHIP2026.2
86030520000400001186030520000400001118171 REAR OF 1050 INWARREN59958PINE9510019510.0100147078.5488208.6579228.2916217.6259100PINE TOWNSHIP2026.2
860306100002000011860306100002000011181712876 E 800 NINWARREN59958PINE9510019510.0100151946.6027219.8173237.6597227.6791100PINE TOWNSHIP2026.2
860304200004000011860304200004000011181717524 S 50 WINWARREN59958PINE9510019510.0100250237.0003233.5350250.1598240.4861199PINE TOWNSHIP2026.2
860401100002000012860401100002000012181713045 W 1100 NINWARREN61632PRAIRIE95110095119546.7654235.2993238.1003236.7827511PRAIRIE TOWNSHIP2026.2
86030210000200001186030210000200001118171 S BRISCOE RD INWARREN59958PINE9510019510.0100336094.4995239.7127246.9504243.6731100PINE TOWNSHIP2026.2
8603032000040000118603032000040000111817110631 N ADEWAYINWARREN59958PINE9510019510.0100294578.7771234.8377248.5480242.5151101PINE TOWNSHIP2026.2
86030320000300001186030320000300001118171149 E 1100 NINWARREN59958PINE9510019510.010014948.8220242.2322245.7277244.1952511PINE TOWNSHIP2026.2
86040520000300001286040520000300001218171 SE 650 N AND 1100 W INWARREN61632PRAIRIE9511009511669227.7489232.3026243.3783236.5155100PRAIRIE TOWNSHIP2026.2
860302100001000011860302100001000011181711100 NINWARREN59958PINE9510019510.0100327892.0083235.2589245.5569240.6515100PINE TOWNSHIP2026.2
860305200003000011860305200003000011181710 W 1050 NINWARREN59958PINE9510019510.0100308779.7949215.9791231.1145224.2003100PINE TOWNSHIP2026.2
86030120000200001186030120000200001118171 W 300 E INWARREN59958PINE9510019510.0100321468.9548230.1227245.9547236.7480100PINE TOWNSHIP2026.2
86030110000100001186030110000100001118171 W 300 E INWARREN59958PINE9510019510.0100320043.9708225.7600234.1846230.1164199PINE TOWNSHIP2026.2