Land Records Logo

Land Records

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

44/80

Live SQL
SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '42' 
  AND countyfp = '037'

34,311 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
23 05E0140042037PACOLUMBIA49256MIFFLIN0514005142058.8559111—163.8726165.1399164.43671300RESIDENTIAL2026.22024
23 06 0010542037PACOLUMBIA49256MIFFLIN0514005145064.8525111—172.3066182.6170177.91561300RESIDENTIAL2026.22024
23 05E0070142037PACOLUMBIA49256MIFFLIN0514005141596.1957111—161.8980163.0889162.46371300RESIDENTIAL2026.22024
23 05A0340042037PACOLUMBIA49256MIFFLIN0514005142344.3492211—154.1511155.2795154.88801300RESIDENTIAL2026.22024
23 05A1470042037PACOLUMBIA49256MIFFLIN0514005142698.8595111—153.5904154.9830154.24611300RESIDENTIAL2026.22024
04A10 0160042037PACOLUMBIA05888BERWICK0506005062899.8274111—177.4500178.3129177.95898400GRASS2026.22024
13 07 0080042037PACOLUMBIA14184CLEVELAND051500515720989.69121—211.6781317.1516265.246772121THE HINE'S PINESCAMPGROUND2026.22024
31 3C21140042037PACOLUMBIA68392SCOTT050800508978.1452211—146.3297147.2381146.81832026.22024
04D06 1040042037PACOLUMBIA05888BERWICK050700507552.1851211—158.5457159.3439158.97862026.22024
31 02E0240042037PACOLUMBIA68392SCOTT0504005042782.9325111—217.2097226.3701222.07612026.22024
11 05 0350142037PACOLUMBIA54880NORTH CENTRE0504005042189.5010211—194.8904196.7145195.55852026.22024
07 10 0030042037PACOLUMBIA08480BRIAR CREEK05050050538637.0653211—283.4647306.9562296.66322026.22024
04A01 0500042037PACOLUMBIA05888BERWICK050600506530.9636211—175.0379175.9637175.67942026.22024
04D06 0480042037PACOLUMBIA05888BERWICK050700507675.0571111—160.7500162.4600161.73882026.22024
07 02B0050042037PACOLUMBIA08480BRIAR CREEK0505005051858.0240111—164.0299173.4412171.00862026.22024
17 02C0100042037PACOLUMBIA31392GREENWOOD0502005024017.4948111—252.5264258.8459255.46052026.22024
11 04 0150342037PACOLUMBIA54880NORTH CENTRE0504005048308.8633111—261.8329268.3062265.44232026.22024
04D08 0030042037PACOLUMBIA05888BERWICK050700507668.1713111—157.4234158.6029157.98532026.22024
07 03 0180042037PACOLUMBIA08480BRIAR CREEK0505005052265.2102112—348.6628358.3002354.06322026.22024
07 03 0530742037PACOLUMBIA08480BRIAR CREEK0505005054528.0314111—312.7274330.0702322.58322026.22024
04C02 0400042037PACOLUMBIA05888BERWICK050700507801.0227112—160.6644161.3833160.97632026.22024
04A09 0080042037PACOLUMBIA05888BERWICK050600506721.8519111—174.1643174.5110174.32682026.22024
31 03E0110042037PACOLUMBIA68392SCOTT0509005093004.9801211—222.0811225.1010223.97482026.22024
04D08 1940042037PACOLUMBIA05888BERWICK050700507676.5729111—157.6387159.3375158.37712026.22024
04A09 1520042037PACOLUMBIA05888BERWICK050600506587.5675112—171.8309172.1795172.05152026.22024