Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

36/80

Live SQL
SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '17' 
  AND countyfp = '149'

2,307 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
17149ILUSDA-NRCSPIKE32863HARDIN9528009528327461.1105111164.1906207.4102188.9457NONPROFIT6S253WS25 T6S R3W2026.22011
17149ILAIR & WATER COMPLIANCE GROUP L…PIKE32863HARDIN95280095289074.4241111212.7489215.9169215.1189BUSINESS6S263WS26 T6S R3W2026.22010
17149ILUSDA-NRCSPIKE60235PITTSFIELD9526009526865535.18883201.3730241.4338221.4363NONPROFIT5S64WS6 T5S R4W2026.22011
17149ILJEREMY PRUDENPIKE52818NEW SALEM9524009524160705.31861201.4135231.0516219.6547PERSON4S114WS11 T4S R4W2026.22019
17149ILROBERT CLARKPIKE60547PLEASANT HILL9526009526353801.7939164.2900223.9387197.1634PERSON7S54WS5 T7S R4W2026.22012
17149ILPRAIRIE POWER INCPIKE03974BARRY952500952513391.0762171.7750173.2541172.6381BUSINESS4S126WS12 T4S R6W2026.22021
17149ILUSDA-NRCSPIKE12359CHAMBERSBURG952400952451841.9032154.9330176.7088169.0254NONPROFIT3S72WS7 T3S R2W2026.22010
17149ILCALLENDAR CONSTRUCTION INC.PIKE02791ATLAS952600952622592.9359182.7731215.6788205.0892BUSINESS6S25WS2 T6S R5W2026.22015
17149ILGPD ASSOCIATESPIKE32070HADLEY9525009525123764.1481224.4285236.8100230.5860PERSON4S305WS30 T4S R5W2026.22011
17149ILUSDA NRCSPIKE19577DERRY9526009526109467.8231188.6973217.2762201.9586PERSON5S35WS3 T5S R5W2026.22010
17149ILIDNR - OFFICE OF WATER RESOURCESPIKE65936ROSS95260095262281.8952135.2754136.4726135.8344UNDETERMINED7S255WS25 T7S R5W2026.22017
17149ILERIKA OLSONPIKE60547PLEASANT HILL9528009528152633.5865166.7078199.1398186.8090PERSON7S124WS12 T7S R4W2026.22021
17149ILUSDAPIKE03974BARRY9525009525112417.2729191.8932218.0619210.4392UNDETERMINED4S246WS24 T4S R6W2026.22013
17149ILMATTHEW KUNZPIKE03974BARRY95250095256486.0036193.6731196.6323195.4271PERSON4S76WS7 T4S R6W2026.22013
17149ILUSDA - NRCSPIKE03974BARRY9525009525264208.1996196.3745219.2868210.3564NONPROFIT4S186WS18 T4S R6W2026.22022
17149ILJEFF HUDGENSPIKE03974BARRY9525009525528483.9091156.3732211.6761185.4664PERSON4S166WS16 T4S R6W2026.22020
17149ILPANHANDLE EASTERN PIPE LINE CO.…PIKE65936ROSS9526009526157176.5278134.2225137.0371135.6890BUSINESS7S175WS17 T7S R5W2026.22014
17149ILUSDA NRCSPIKE03974BARRY95250095254802.4670182.7471189.0074185.3472PERSON4S126WS12 T4S R6W2026.22020
17149ILUSDAPIKE50192MONTEZUMA9528009528171796.3112161.6896191.4238182.8721UNDETERMINED6S22WS2 T6S R2W2026.22013
17149ILILLINOIS ENVIRONMENTAL PROTECTI…PIKE31784GRIGGSVILLE952400952460465.6759203.3570208.8468206.7371PERSON4S293WS29 T4S R3W2026.22011
17149ILUSDA - NRCSPIKE03974BARRY9525009525287708.4246197.6616221.9686215.2381NONPROFIT4S86WS8 T4S R6W2026.22022
17149ILMATTHEW KUNZPIKE03974BARRY95250095257205.8171193.7246196.6918195.5669PERSON4S76WS7 T4S R6W2026.22013
17149ILHDR INCPIKE65936ROSS9526009526130583.7499134.2225137.0371135.6937BUSINESS7S175WS17 T7S R5W2026.22014
17149ILUSDAPIKE02791ATLAS952600952663086.5791205.6251230.1651222.0596UNDETERMINED6S115WS11 T6S R5W2026.22013
17149ILUSDA - NRCSPIKE71617SPRING CREEK952800952840942.6581201.0236216.5634209.8541NONPROFIT7S253WS25 T7S R3W2026.22022