Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

43/80

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

54,467 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
4309009018844207599 KREIDER RDPABRUBAKER LUKE Z & DENISE W81 KREIDER RD MYERSTOWN PA 170…LEBANON37392JACKSON00280228.0200195501.0971101000257001267009000002015-07-161142075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD147.9259163.6432155.541180148.3027PERSON2015024362GOVT LOCALCLOSEDBERKS COUNTY AGRICULTURAL EASEM…AGRICULTURAL EASEMENT2026.2MARION TOWNSHIP
4309003533674207521 S JONATHAN DRPAPATRICK JUSTIN DAVID21 S JONATHAN DR MYERSTOWN PA …LEBANON37392JACKSON00280228.02005624.409116300416005790012022-11-071142075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD197.2567201.8576200.02551461.3899PERSON20220436802026.2MARION TOWNSHIP
43370007865442075441 E MAIN STPAZIMMERMAN RAYMOND H & ALMA441 E MAIN ST NEWMANSTOWN PA 1…LEBANON49560MILLCREEK00300030129500.44771086001810012670012020-11-241142075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD135.3804158.0108150.239980132PERSON20200447422026.2MARION TOWNSHIP
339900795893420751407 HILLTOP RDPAEBERLY BRADLEY & EMILY1407 HILLTOP RD MYERSTOWN PA 1…LEBANON37392JACKSON00280228.02006181.332581000315001125002013-05-031142075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD175.2152179.1956177.08841011.5264PERSON20130185432026.2TULPHOCKEN TOWNSHIP
34900051656242075146 GREBLE RDPAMARTIN SHAWN LAMAR & CRYSTAL B146 GREBLE RD MYERSTOWN PA 170…LEBANON37392JACKSON00280228.0200154614.5139353100166003697005000002017-07-071142075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD159.8639182.2245170.572580138.2015PERSON20170245302026.2TULPHOCKEN TOWNSHIP
431800378073420751040 STOUCHSBURG RDPAOBERHOLTZER LLOYD M & TINA S125 RICHLAND RD MYERSTOWN PA 1…LEBANON37392JACKSON00280228.0200118596.8616104300169001212003439002003-04-211142011C2025-12-21XAREA OF MINIMAL FLOOD HAZARD129.0949151.5399141.578480129.2993PERSON374222262026.2MARION TOWNSHIP
34710066368342075296 DOVE RDPASIMMONS ELIZABETH GUARDIOLA-296 DOVE RD FREDERICKSBURG PA …LEBANON06040BETHEL002100215308.6939194000309002249002010-12-231142075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD172.8991176.8556174.33351111.3116PERSON20100512232026.2BETHEL TOWNSHIP
43460451699742075820 TEXTER MT RDPAGRAEFF STEVEN J/LISA820 TEXTER MOUNTAIN RD ROBESON…LEBANON49560MILLCREEK0030003020379.4287112200561001683001142071C2025-12-21XAREA OF MINIMAL FLOOD HAZARD349.2775358.4882354.79131115.0334PERSON194113392026.2SOUTH HEIDELBERG TOWNSHIP
348000876338420756 COTTAGE RDPAHUNSICKER BRUCE M/CHRISTINE F9 COTTAGE RD MYERSTOWN PA 1706…LEBANON06040BETHEL00210021306258.38712190057500794002005-02-171142075C2025-12-21AEFLOODWAY133.2787161.6443142.440980175.6703PERSON453401302026.2TULPHOCKEN TOWNSHIP
4207526 S JONATHAN DRPAGRINEV ANATOLI Y & LUDMILA N26 S JONATHAN DR MYERSTOWN PA …LEBANON37392JACKSON00280228.02008755.1625107000447001517003249002022-09-301142075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD194.8647200.5053197.5639105B2.1700PERSON20220388722026.2MARION TOWNSHIP
348000965473420751 COTTAGE RDPABURKHOLDER LARRY J & NAOMI F1 COTTAGE RD MYERSTOWN PA 1706…LEBANON06040BETHEL00210021369083.7089113300418001551001142075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD137.4183166.8103149.420180191.1893PERSON195304512026.2TULPHOCKEN TOWNSHIP
430900258749420757606 LANCASTER AVEPABURKHOLDER LARRY J & NAOMI F1 COTTAGE RD MYERSTOWN PA 1706…LEBANON37392JACKSON00280228.02002004.61023900030000690002013-01-291142011C2025-12-21XAREA OF MINIMAL FLOOD HAZARD203.0877205.9089204.77171010.4950PERSON20130036052026.2MARION TOWNSHIP
43180074649542075341 HICKORY RDPASONNEN PAUL M & MARILYN F341 HICKORY RD RICHLAND PA 170…LEBANON37392JACKSON00280228.0200772118.80811341001072002413001142075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD801190.7684PERSON15020471GOVT LOCALCLOSEDBERKS COUNTY AGRICULTURAL EASEM…AGRICULTURAL EASEMENT2026.2MARION TOWNSHIP
431800277954420753998 WINTERSVILLE RDPAHURST PAUL H & GLORIA K3998 WINTERSVILLE RD MYERSTOWN…LEBANON37392JACKSON00280228.020016778.0094183700395002232001142075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD148.9128154.1583151.52671064.1453PERSON199820872026.2MARION TOWNSHIP
430900350606420757605 LANCASTER AVEPADOUTRICH ELVIN L & ELAINE H7605 LANCASTER AVE MYERSTOWN P…LEBANON37392JACKSON00280228.02002726.91184050033200737001142011C2025-12-21XAREA OF MINIMAL FLOOD HAZARD199.9798203.6990202.11181010.6742PERSON222303562026.2MARION TOWNSHIP
34900060497142075 GREBLE RD PAMAST IRA L/LOUISE E REVOCABLE L…163 GREBLE RD MYERSTOWN PA 170…LEBANON37392JACKSON00280228.020032606.6794437004370012021-07-1542075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD170.6848186.2420178.8730100A8.0563TRUST20210354982026.2TULPHOCKEN TOWNSHIP
25-005-05242075187 ANGLE RDEAST HANOVERPALEBANON21224EAST HANOVER0023002311325.615342043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999137.8799143.3498141.07642.09006216SLADE'S MECHANICAL SERVICESHOME_SERVICE2026.2
7273OUTSIDE42075PALEBANON49560MILLCREEK0030003058.773142011C2025-12-21XAREA OF MINIMAL FLOOD HAZARD150.8058151.0745150.94100.0145GOVT LOCALCLOSEDBERKS COUNTY AGRICULTURAL EASEM…AGRICULTURAL EASEMENT2026.2
5619OUTSIDE42075PALEBANON06040BETHEL0021002122.673742075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD157.4169158.2680157.75880.0055GOVT LOCALCLOSEDBERKS COUNTY AGRICULTURAL EASEM…AGRICULTURAL EASEMENT2026.2
22-007-01342075132 BACHMANVILLE RDCONEWAGOPALEBANON72296SOUTH LONDONDERRY0040004070013.180742075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999162.6143193.7141174.293417.70002026.2
24-007-0974207526 N LINGLE AVEDERRYPALEBANON57720PALMYRA00390139.0100625.718842075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999137.4878140.1322139.14130.10432026.2
24-054-02942075880 STAUFFERS CHURCH RDDERRYPALEBANON72296SOUTH LONDONDERRY004000407525.226742075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999158.4289167.5431163.36332.10902026.2
22-007-01542075 COLEBROOK RD CONEWAGOPALEBANON72296SOUTH LONDONDERRY00400040328397.594542075C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999150.0722179.5173166.159881.20002026.2
25-005-044420753 LOG CABIN DREAST HANOVERPALEBANON21224EAST HANOVER0023002320955.797342043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999145.5637156.0533151.086652026.2
22-014-045420751000 MAPLEDALE RDCONEWAGOPALEBANON72296SOUTH LONDONDERRY0040004035219.539742043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999142.2030152.5575147.6650102026.2