Land Records Logo

Land Records

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

41/80

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

149,873 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
{A42B5B8D-AA39-4A61-A729-5DDECF…12008171631556 MULE RDILERIC A MIER1556 MULE RDST. CLAIR73456SUGAR LOAF5031015031.010019953.73031053211053211053210211—194.0831208.0952204.1639PERSONSUGAR LOAF TWP SEC 31S310WS3 T1S R10W2026.22024
{4025C701-B3E7-4995-A0C1-29F8DF…1500517163ILWILLIAM J & JESSICA GORKA820 EDWARDS STST. CLAIR25726FAYETTEVILLE5040025040.02004829.989485662017010583211—127.5752128.7937128.5598PERSONFAYETTEVILLE TWP SEC13 A022459172S136WS13 T2S R6W2026.22024
{C96B8B4A-8F3F-4EE5-99B2-A72A53…1501317163ILVOLLMER JOSEPH BERGKOETTER PAUPO BOX 351ST. CLAIR25726FAYETTEVILLE5040025040.02001227.4271521776019058196111—128.8836129.9209129.5408PERSONSTEEPLEVIEW SUB LOT A019592672S136WS13 T2S R6W2026.22024
{41773BD3-D147-4D95-BD48-EBC9E2…1701617163ILRICHARD & MARY DAUMBACHER609 N MAIN STST. CLAIR27819FREEBURG5039055039.05001187.438404649046491—153.6922154.5645154.1789PERSONMILL ADD TO URBANA1S197WS19 T1S R7W2026.22024
{5ED62E3F-3A18-45B4-8F21-636A9C…09018171637 NOTTINGHAM LNILROGER & ROBIN FOHNE9 FOX CREEK RDST. CLAIR72988STOOKEY5015025015.02001188.04700576605766—174.3446179.2379175.6960PERSONFOX CREEK ESTATES1N19WS1 T1N R9W2026.22024
{C8A790AE-8B6B-47AD-A874-24912D…1302117163ILDOUGLAS SR & EDNA M TRICE10820 LINNELL DRST. CLAIR72741STITES5045025045.0200553.048903830383—124.6019125.3903124.9310PERSONBROOKLYN TOWN OF2N210WS2 T2N R10W2026.22024
{AE014D98-1BDE-40F2-99BC-E28FE6…1701617163ILMARY KINZINGER0 STATE RT 15ST. CLAIR27819FREEBURG5039055039.050025349.9593015960015960—154.6712161.8133159.4972PERSONFREEBURG TWP SEC 18 191S187WS18 T1S R7W2026.22024
{F27CD4BE-4F23-4A05-80F2-5D413B…10087171632368 CAROL STILDAN & FRANCES J TROST9850 PINE CREST RDST. CLAIR12210CENTREVILLE5026035026.03001918.7557934170802642111—125.0422126.9473125.7052PERSONRENOIS FARMS2026.22024
{8AAAAF19-F0B1-4675-B0FE-78D63F…1500117163ILROBERT C. & CYNTHIA YOCKS620 W SOUTH STST. CLAIR25726FAYETTEVILLE5040025040.020085763.61461193119311930—115.5441119.9505119.4659PERSONFAYETTEVILLE TWP SEC22 251S256WS25 T1S R6W2026.22024
{BE403663-C895-44C7-9359-D6133F…1900217163ILNEIL J SCHALLER1414 BALDWIN RDST. CLAIR42873LENZBURG5040025040.020020488.803300765765—126.7482129.8792128.4524PERSONLENZBURG TWP SEC 143S147WS14 T3S R7W2026.22024
{80F48F1B-EE7F-41B4-A169-5F9DD7…1500617163ILWILMER W STEINHEIMER10747 NEW ATHENS DARMSTADT RDST. CLAIR25726FAYETTEVILLE5040025040.020020575.4603217121712835664—124.7097129.2021127.8315PERSONFAYETTEVILLE TWP SEC282S286WS28 T2S R6W2026.22024
{F621AF3B-8AB6-490E-B195-704045…1500317163ILCHARLES DRESSLER4677 PENSONEAU RDST. CLAIR25726FAYETTEVILLE5040025040.020019623.460000351351—115.5220126.0804121.0378PERSONFAYETTEVILLE TWP SEC16 LT 5 PT …2S166WS16 T2S R6W2026.22024
{60C7278F-34CF-4F85-AEA2-97FAD3…0200117163ILMARCO INVESTMENT GROUP LLC1101 CENTREVILLE AVEST. CLAIR04845BELLEVILLE5033325033.3200884.33260480304803—162.9712164.0246163.7709BUSINESSWESTS ACRES 2ND ADD1N148WS14 T1N R8W2026.22024
{CC6E651F-DB7D-4506-89B3-8E4479…1701517163ILECKERT LAND COMPANY951 S GREEN MOUNT RDST. CLAIR27819FREEBURG5039035039.030012354.702200213213—145.1387152.6534149.8342BUSINESSFREEBURG TWP SEC 161S167WS16 T1S R7W2026.22024
{4F3EF0BF-A4C0-475E-AE56-A2F654…1400117163ILPATRICIA K HOCK13130 KOCH LNST. CLAIR24205ENGELMANN5040025040.0200169852.4911001104211042—124.5036131.6897127.1907PERSONENGELMANN TWP SEC 121S126WS12 T1S R6W2026.22024
{4545BD76-2FB4-427B-B1CE-06FA76…0109917163ILGERALDI HAMPTON1420 N 17TH ST APT 15ST. CLAIR22268EAST ST. LOUIS5009005009561.491406040604—126.9928127.7624127.4485PERSONEAST ST LOUIS SUB OFBLKS 2102N1310WS13 T2N R10W2026.22024
{E85D29D8-565B-4CBD-9193-04359A…0109917163ILCITY OF E ST LOUIS0 N 6TH STST. CLAIR22268EAST ST. LOUIS5045025045.0200276.08510147601476—125.4437125.7604125.5884GOVERNMENTEAST ST LOUIS PLATTED TOWN2N1310WS13 T2N R10W2026.22024
{57BF776E-03F3-43DE-833A-0281B8…0109617163ILMARY MCCALLISTER2013 N 43RD STST. CLAIR22268EAST ST. LOUIS5005005005281.291103330333—125.4321125.7511125.6273PERSONGRANBY PARK SUB2N99WS9 T2N R9W2026.22024
{AA085C77-DD4C-4F75-8492-0352C3…1002617163227 N 55TH STILLEONARD J. MEYER602 STATE RTE 13ST. CLAIR12210CENTREVILLE50250050252001.2112104729083311—124.4702126.7625125.7519PERSONCARR JOHNSON ACRES2026.22024
{28B24363-D286-4017-8590-DEA751…0209917163ILCITY OF BELLEVILLEN 44TH STST. CLAIR04845BELLEVILLE5016025016.020064.08780194601946—168.6199170.4440169.6692GOVERNMENTSUB OF LT 13 SEC 18-1N-81N188WS18 T1N R8W2026.22024
{8A0D9201-984B-4BFD-99C0-F27D33…1000117163ILFITZHURA WALLACE267 N 74TH STST. CLAIR12210CENTREVILLE5029005029276.782502470247—125.9679126.3874126.2488PERSONLE PAGE PLACE2N279WS27 T2N R9W2026.22024
{199517AE-F8C6-41DC-965B-74AC94…01099171635700 STATE STILHENRIC WICKSPO BOX 3346ST. CLAIR22268EAST ST. LOUIS5013005013838.551706330633—126.7623127.3990127.0904PERSONALLENDALE SUB2026.22024
{87646CE1-01EB-4E52-B438-3C516F…0500417163ILAMBROSIA LAND INVESTMENT LLC3500 LEBANON AVEST. CLAIR69550SHILOH VALLEY5039075039.070074787.88850034763476—157.5668174.2899169.0412BUSINESSSHILOH VALLEY TWP SECTION 72026.22024
{5ADACCB7-EE5D-4371-9810-BA9E39…10030171636308 BONDILSHAVETTE WILLS4917 PEARL AVEST. CLAIR12210CENTREVILLE5028005028620.359304520452—126.8219127.6304127.2427PERSONSCHIELE SUB2026.22024
{8444AA06-6FF2-4FB3-95B0-928072…0109017163ILCITY OF E ST LOUIS301 E BROADWAYST. CLAIR22268EAST ST. LOUIS5013005013104.967302170217—125.4345125.5062125.4649GOVERNMENTSTATE STREET PARK2026.22024