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

69,534 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
18A12-0039---000420554590 COLD SPRINGS RDPABENNETT LORELIE TARROSA4530 COLD SPRINGS RDFAYETTEVILLEPA17222FRANKLIN63200QUINCY012001120.010079041.5281121900121900121900012023-03-3042055C2025-12-21XAREA OF MINIMAL FLOOD HAZARD479.5487503.3583492.1535A19.4000PERSONMAY BE SUBJECT TO A 11' EXCEPTI…70776182026.2
140063031400630342055 FIRST AVE CASCADEPA21719CCHL PROPERTIES LLC30 EMLYN LNMECHANICSBURGPA17055FRANKLIN81240WASHINGTON012502125.02005837.295742055C2025-12-21XAREA OF MINIMAL FLOOD HAZARDR1.4422BUSINESSLOT 0.15 ACRESFIRST AVEBLUE RI…0748104092026.214
270002822700028242055 PENNSYLVANIA AVE HAGERSTOWNPA21742HARTLE DANA TRUSTEE L/E FOR ALE…17809 GREENTREE TERHAGERSTOWNMD21740FRANKLIN02696ANTRIM011900119390.106842055C2025-12-21XAREA OF MINIMAL FLOOD HAZARDR0.0963TRUSTLOT 40X72E/S MIDDLEBURG PIKE0732800052026.227
140104671401046742055 FIRST AVE CASCADEPA21719WILLARD PAUL C5920 OLD FT RITCHIE ROADSABILLASVILLEMD21780FRANKLIN81240WASHINGTON012502125.02002722.139242055C2025-12-21XAREA OF MINIMAL FLOOD HAZARDR0.6729PERSONRR LOTS 1-2 95X8524X85 FIRST AV…0072308872026.214
140118111401181142055 WALDHEIM RD CASCADEPA21719HOOVER WARREN B JR6925 E TURNER CAMP RDINVERNESSFL34453FRANKLIN81240WASHINGTON012502125.0200591.031542055C2025-12-21XAREA OF MINIMAL FLOOD HAZARDR0.1458PERSONPTLT IRRG .07 AC (GWALDHEIM RO…0079601472026.214
140006661400066642055 HILLTOP RD CASCADEPA21719GRIMM JARED E ERFURDT KELLY M14714 HILLTOP RDCASCADEMD21719FRANKLIN81240WASHINGTON012502125.02004809.081842055C2025-12-21XAREA OF MINIMAL FLOOD HAZARDR1.1888PERSONLOT 0.506 ACRES14714 HILLTOP RD0763504712026.214
140084111400841142055PEN MAR RDCASCADEPA21719SAGI PROPERTY TWO LLCC/O VALLEY PROP OF HAG LLC 921 …HAGERSTOWNMD21740FRANKLIN81240WASHINGTON012502125.02001923.004542055C2025-12-21XAREA OF MINIMAL FLOOD HAZARDM0.4757BUSINESS0.436 ACRES24700 PEN MAR RDMASO…0248101382026.214
140105131401051342055 FIRST AVE CASCADEPA21719JOHNSON RICHARD E JOHNSON KIM L13716 MONTEREY LNBLUE RIDGE SUMMITPA17214FRANKLIN81240WASHINGTON012502125.020016925.503542055C2025-12-21XAREA OF MINIMAL FLOOD HAZARDR4.1857PERSON1.874 ACRESBLUE RIDGE SUMMIT0135302012026.214
270043342700433442055 PENNSYLVANIA AVE HAGERSTOWNPA21742EBY CURVIN EBY GLENNIS19534 REIDTOWN RDHAGERSTOWNMD21742FRANKLIN02696ANTRIM0119001191161.305142055C2025-12-21XAREA OF MINIMAL FLOOD HAZARDR0.2869PERSONLOT 50X19114733 PENNSYLVANIA AVE0740901742026.227
140101491401014942055 WALDHEIM RD CASCADEPA21719A & L PROPERTIES LLC C/O DONALD…13630 POPLAR GROVE RDHAGERSTOWNMD21742FRANKLIN81240WASHINGTON012502125.0200104.768942055C2025-12-21XAREA OF MINIMAL FLOOD HAZARDR0.0257BUSINESS0.108 ACRE24714 WALDHEIM ROAD0291303212026.214
270002902700029042055 PENNSYLVANIA AVE HAGERSTOWNPA0000014728 PENNSYLVANIA AVE LLCPO BOX 4217HAGERSTOWNMD21741FRANKLIN02696ANTRIM011702117.02001567.1385R0.3875BUSINESSLOT 162X246 .87 APENNSYLVANIA A…0193204032026.227
00ADM-FRAN---00042055PAFRANKLIN81240WASHINGTON012502125.02004464.087842055C2025-12-21XAREA OF MINIMAL FLOOD HAZARD408.3057416.7700412.1458CARRIED IN FRANKLIN57972862026.2
00ADM-ROAD---00042055PAFRANKLIN63200QUINCY012001120.01008189.852742055C2025-12-21XAREA OF MINIMAL FLOOD HAZARD497.8794506.8602502.56832026.2
42055PAFRANKLIN COUNTY GOVERNMENTFRANKLIN59600PETERS011500115133.3370226.2671228.6802227.6534PERSONGOVT LOCALCLOSED3408AGRICULTURAL EASEMENT2026.2
12-0F15 014 00000042055PAFRANKLIN42888LETTERKENNY0102001022762070.8787317.3389444.2254347.35832026.22024
42055PAFRANKLIN81240WASHINGTON012502125.02005520.423242055C2025-12-21XAREA OF MINIMAL FLOOD HAZARD1.3643LIVING WORD ACADEMYPLACE_OF_LEARNING2026.2
UNKNOWN42055PAFRANKLIN71912SOUTHAMPTON010301103.0100879.1304206.9493210.7126208.66032026.22024
42055PAFRANKLIN71912SOUTHAMPTON010302103.020071104.28545811211.7297222.5863215.96182026.22024
42055PAFRANKLIN45496LURGAN0102001023858.8170311176.4535182.1415178.45682026.22024
42055PAFRANKLIN02696ANTRIM011701117.01002355.9289164.4344166.0875164.82551300RESIDENTIAL2026.22024
42055PAFRANKLIN02696ANTRIM011702117.02005473.6277144.8631162.3619156.32741300RESIDENTIAL2026.22024
42055PAFRANKLIN02696ANTRIM011701117.01001649.6914172.9372179.6234176.10507160GOLF_COURSE2026.22024
42055PAFRANKLIN02696ANTRIM011702117.02007589.8509155.6311163.1230159.15901300RESIDENTIAL2026.22024
42055PAFRANKLIN42888LETTERKENNY010200102401.4661237.0418238.5971237.94228500GRAVE_YARD2026.22024
42055PAFRANKLIN71912SOUTHAMPTON010302103.02007142.8892580.3522583.6101582.79728400FOREST2026.22024