Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

27/80

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

6,011,253 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
23J03-0004---00042001160 LATIMORE VALLEY RDPACHASE SARA JEANNE518 CARLISLE STHANOVERPA17331ADAMS41672LATIMORE030101301.0100339001.6515354100354100354100012014-02-1142001C2025-12-21XAREA OF MINIMAL FLOOD HAZARD151.0464166.7707157.3508A87.2700PERSONPARCEL 15915559GOVT LOCALCLOSEDADAMS COUNTY AGRICULTURAL EASEM…AGRICULTURAL EASEMENT2026.2
07G07-0034---000420011279 STONE JUG RDPAADAMIK THERESA A1279 STONE JUG RDASPERSPA17304ADAMS10456BUTLER030500305531869.0946309400309400309400012017-06-2142001C2025-12-21XAREA OF MINIMAL FLOOD HAZARDA134.9000PERSONSURVEY 2011, COMBINED W/07G07-0…6274187NGOCLOSEDOTHER2011-05AGRICULTURAL EASEMENT2026.2
010300717000194200914200 DOUBLE PINE RD NEFLINTSTONEPA21530PINEY RUN GUN CLUB INC13505 BEALLS MILL RD NECUMBERLANDMD21502BEDFORD46928MANN9610019610.01002847.8643456008220012780011188287242009C2025-12-21XAREA OF MINIMAL FLOOD HAZARD322.8411333.3017328.212127.5800NONPROFITIMPS27.582A0035503472026.2ALLE
36K08-0023---00042001444 BROWNS DAM RDPASHEMON MICHAEL L444 BROWNS DAM RDNEW OXFORDPA17350ADAMS63616READING030104301.0400326736.8819457300457300457300012021-01-2242001C2025-12-21XAREA OF MINIMAL FLOOD HAZARD128.8009152.9250141.6161A84.3100PERSONCLOSURE ERROR, AC. PLOTTED FRO…67326372026.2
27014-0057---00042001274 S COLUMBUS AVE UNIT L-0147PATOMPKINS IVAN C & CAHTERINE E274 S COLUMBUS AVELITTLESTOWNPA17340ADAMS43944LITTLESTOWN0313003131204.2769167400167400167400012015-04-0242001C2025-12-21XAREA OF MINIMAL FLOOD HAZARD185.5657187.0562186.2506R0.2800PERSON60194142026.2
38H11-0001---000420011731 HUNTERSTOWN RDPAKESTREL ACQUISITION LLC8403 COLESVILLE RD SUITE 915SILVER SPRINGMD20910ADAMS74680STRABAN0306003061186128.16551730450017304500173045000102018-06-0642001C2025-12-21XAREA OF MINIMAL FLOOD HAZARDI298.9100BUSINESS14 TRACTS, AC. PLOTTED FROM DE…6385180NRG ENERGYPUBLIC_UTILITY2026.2
06009-0040A--00042001 UNASSIGNEDPAS & A CUSTOM BUILT HOMES INC2121 OLD GATESBURG RD #200STATE COLLEGEPA16803ADAMS07560BONNEAUVILLE03070030781256.6665879800879800879800042001C2025-12-21XAREA OF MINIMAL FLOOD HAZARD186.8111196.1933190.4363CL14.4900BUSINESS3167982026.2
05002-0007---00042001350 E YORK STPAEYLER ROY K350 E YORK STBIGLERVILLEPA17307ADAMS06296BIGLERVILLE0305003051283.67401352001352001352000142001C2025-12-21XAREA OF MINIMAL FLOOD HAZARD195.7617198.1633197.1446RC0.2600PERSON3648272026.2
27J17-0054---00042001635 HANOVER PIKEPAMAYBERRY AT MASON DIXON LLC126 ONYX RDNEW OXFORDPA17350ADAMS43944LITTLESTOWN031300313431904.6716907200907200907200012023-05-1042001C2025-12-21XAREA OF MINIMAL FLOOD HAZARDCL107.2100BUSINESSDEED 7107-122 PENN DOT R/W 0.22…70907702026.2
40I07-0044---00042001775 FIVE POINTS RDPAHILLANDALE GETTYSBURG LP3910 OXFORD RDGETTYSBURGPA17325ADAMS78160TYRONE030200302983542.0219129267001292670012926700012021-06-0242001C2025-12-21XAREA OF MINIMAL FLOOD HAZARDA248.2200BUSINESSCOMBINED W/40I07-00497149122026.2
22H04-0018B--000420011117 FARM VIEW RDPABONNIE BRAE FRUIT FARMS INC1230 IDAVILLE-YORK SPRINGS RDGARDNERSPA17324ADAMS36424HUNTINGTON030200302858794.137436330036330036330006500002012-01-0942001C2025-12-21XAREA OF MINIMAL FLOOD HAZARDA216.7000BUSINESSCOMBINED WITH H4-18A56654742026.2
40G04-0093---00042001 OLD CARLISLE ROAD PABEAR MOUNTAIN ORCHARDS INC1415 POTATO RDASPERSPA17304ADAMS78160TYRONE030200302549664.054815690015690015690007500002022-07-1542001C2025-12-21XAREA OF MINIMAL FLOOD HAZARDAO142.6500BUSINESSNEW SURVEY 202269883292026.2
22I06-0023---00042001910 WEIRMANS MILL RDPARUDOLPH DENNIS J & ROSANNE910 WEIRMANS MILL RDYORK SPRINGSPA17372ADAMS36424HUNTINGTON030200302564499.348552600052600052600008000002015-10-3042001C2025-12-21XAREA OF MINIMAL FLOOD HAZARDA144.4900PERSON608212026.2
0134005214012842009PAHELM MICHAEL APSC 2 BOX 5879APO AEFC09012BEDFORD17664CUMBERLAND VALLEY96110096112857.25548008008000042009C2025-12-21XAREA OF MINIMAL FLOOD HAZARD249.8142281.3441261.91200.0800PERSON14431 HAZEN RD ADJ0217000682026.2ALLE
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
0120001100007042111PADETRICK COLIN R-KEITH L ET UX413 SCENIC LNRIDGELEYWV26753SOMERSET71920SOUTHAMPTON021300213436.0371270027000042111C2025-12-21XAREA OF MINIMAL FLOOD HAZARD628.5640644.9381636.99430.5000PERSON1/2A0037700472026.2ALLE
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
2990000001015002000000000001462421056781 CO RD 18PAMEAD LOUIS CHARLOTTEPOTTER69736SHARON9502009502809.07381998-07-15464.3610465.5199464.88952100.1998PERSON12991T1 R1 SEC 2991149762026.2