Data Explorer

Query the US Nationwide Parcel Dataset

Request Sample Download

$1.75 / 1,000 records$100 minimum

0/80

Live SQL
SELECT * 
FROM "parcel_layer" 
WHERE statefp = '42' 
  AND countyfp = '097'

52,659 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
taxyear
taxdistrict
021-00-014-016-B4209710125 ST RTE 44WATSONTOWNPA17777BYERS RYAN MNORTHUMBERLAND18696DELAWARE0802008026359.844330890241003330012025-11-07211170.7454173.9100172.5130RR - RESIDENTIALPERSONBOOK 3158-7603440-474SUDOL'S BOARDING AND GROOMINGANIMAL_OR_PET_SERVICE2024
021-00-014-041-C42097957 SUSQUEHANNA TRLWATSONTOWNPA17777PATRICK FREDERICK PROPERTIES LLCNORTHUMBERLAND18696DELAWARE08020080215805.84468308018700849505500002016-10-12112150.0432161.8352157.8050CC - COMMERCIALBUSINESSBOOK 2727-6112727-611SUSQUEHANNA TRAIL ANIMAL HOSPIT…ANIMAL_OR_PET_SERVICE2024
040-02-044-09542097113 S MARKET STELYSBURGPA17824SMITH KYLENORTHUMBERLAND63328RALPHO0808008081208.8877830018200101201350002024-05-22111178.8252179.8711179.4528RR - RESIDENTIALPERSONBOOK 3048-3523330-941THEBODYLABSPERSONAL_CARE_AND_BEAUTY_STORE2024
041-06-027-010-C4209754 JAY STRIVERSIDEPA17821KORT PAUL T ELIZABETH RNORTHUMBERLAND65112RIVERSIDE0807008071324.4687157001930017630370001988-02-0111143.9946147.4279146.5132RR - RESIDENTIALPERSONBOOK 706-523706-523KNUCKLE BUSTER CUSTOMSAUTOMOTIVE_SERVICE2024
029-00-101-03542097RADEL RDPA17017SPRENKLE MIKKI L KRISTIN ANORTHUMBERLAND44960LOWER MAHANOY082300823201998.220405780057801363842021-10-15164.7063295.5989218.4517VV - VACANTPERSONBOOK 3130-702 PAGE 2245-9353130-7022245-935DALMATIA-ELIZABETHVILLE 69KV TR…2024
00I-02-00I-125420971738 W WALNUT STEDGEWOODPA17866EICHEN DIANE KNORTHUMBERLAND14536COAL081300813633.077718860109001995012016-09-27111276.9733283.0784280.1700RR - RESIDENTIALPERSONBOOK 2723-9072723-9072024
048-01-003-28142097200 S RIVER AVESUNBURYPA17801SOLIS DOMAINS LLCNORTHUMBERLAND75304SUNBURY082100821625.929363101040073501700002024-04-05112132.8812134.0715133.3481RR - RESIDENTIALBUSINESSBOOK 2916-8753321-5642024
027-00-081-009420975337 ST RTE 225LITTLE MAHANOYPA17823KLINGER LARRYNORTHUMBERLAND43912LITTLE MAHANOY0818008181743.6399851023400108501750002025-06-24111183.1070187.4186185.0653RR - RESIDENTIALPERSONBOOK 2979-3113409-9092024
053-01-008-2044209753 CATAWISSA AVESUNBURYPA17801ZWATTY WESLEY R AMY ANORTHUMBERLAND75304SUNBURY082200822659.22957980117009150600002005-04-21211134.6314139.4512137.2222RR - RESIDENTIALPERSONBOOK 1753-1601753-1602024
031-02-016-182420976 RIDGEVIEW CTMILTONPA17847REITZ SETH T A HEATHER LNORTHUMBERLAND50016MILTON080301803.01001648.1460350903130038220360002009-09-03112153.1202157.3004155.4542RR - RESIDENTIALPERSONBOOK 2173-2702173-2702024
024-00-089-053420973583 ST RTE 225JACKSONPA17830SNYDER GUY J IIINORTHUMBERLAND37432JACKSON0823008237441.050417190326002045012022-04-11211147.3030156.5168150.4056CC - COMMERCIALPERSONBOOK 3173-6753173-6752024
061-01-002-14242097214 9TH STWATSONTOWNPA17777SEIDEL TINA MNORTHUMBERLAND81616WATSONTOWN0802008021032.09231730017000190002355002024-07-31111148.5116150.0100149.4244RR - RESIDENTIALPERSONBOOK 2342-3173345-1952024
025-00-103-051420971898 KLINGERSTOWN RDJORDANPA17830MACE CAROL J TERRY ANORTHUMBERLAND38456JORDAN082300823821.98394980157006550140002016-06-21111199.7741204.2533202.0032RR - RESIDENTIALPERSONBOOK 2701-6362701-6362024
060-02-001-02642097122 MURRAY STWATSONTOWNPA17777VADASZ TAYLOR GNORTHUMBERLAND81616WATSONTOWN0802008022013.52081227046300169001600002022-04-18111152.4347158.1032155.3935RR - RESIDENTIALPERSONBOOK 3175-903175-902024
020-01-065-40842097519 S 11TH STTREVORTONPA17881FORNEY CRAIG A SHERRIE SNORTHUMBERLAND87280ZERBE0818008181058.41718290121009500220002003-08-21211231.2352235.8791233.2849RR - RESIDENTIALPERSONBOOK 1579-1931579-1932024
062-00-021-026-M420972953 HOUSELS RUN RDMILTONPA17847PRUTZMAN LINDA S FETTER MARK ENORTHUMBERLAND82712WEST CHILLISQUAQUE08040080418509.007613200351001671012014-05-09212141.6234146.9620143.9112RR - RESIDENTIALPERSONBOOK 2547-4122547-4122024
040-00-044-10942097220 W CENTER STELYSBURGPA17824GRAY THOMAS KILEYNORTHUMBERLAND63328RALPHO08080080814687.83682257042400268102250002019-11-13212173.6688179.2886176.4073RR - RESIDENTIALPERSONBOOK 2963-1952963-1952024
055-00-001-01842097264 KING STTURBOTVILLEPA17772RIDER RICHARD DNORTHUMBERLAND77832TURBOTVILLE0801008014623.06791360038500174501000002006-11-06111172.9309183.2104178.5568RR - RESIDENTIALPERSONBOOK 1917-5171917-5172024
005-01-002-17342097130 132 N MARKET STMOUNT CARMELPA17851ANZOATEGUI ARGENISIS A CERRUFFONORTHUMBERLAND51496MOUNT CARMEL081000810331.9659244208800253002150002025-05-27111334.3130334.9720334.8176RR - RESIDENTIALPERSONBOOK 3291-3373404-12024
032-03-002-0154209743 WILSON CIRMILTONPA17847WALKER JAMIE BNORTHUMBERLAND50016MILTON080301803.01004098.97963902083700473903450002024-04-23112164.8886180.1285174.3883RR - RESIDENTIALPERSONBOOK 1768-9843324-3552024
001-00-085-052-P42097200 FOURA RDEAST CAMERONPA17872LUCAS LEONARD JNORTHUMBERLAND20928EAST CAMERON08180081856084.637331230410003533012015-11-09111209.2618242.5014222.8015AA - AGRICULTUREPERSONBOOK 2657-9072657-9072024
040-00-044-068-A42097148 PENN AVEELYSBURGPA17824NATALE MATTHEW JNORTHUMBERLAND63328RALPHO0808008086740.793543210441004762012025-12-04211185.0880193.8338189.1631RR - RESIDENTIALPERSONBOOK 2367-9833445-5292024
012-01-004-0974209738 40 S MARKET STSHAMOKINPA17872BETHGE KENNETH JNORTHUMBERLAND69600SHAMOKIN081600816404.336852025000302012024-04-2311220.6024221.5054221.2024QQ - BUILDINGPERSONBOOK 1760-1973324-488SMOKIN N SHAMOKINFOOD_TRUCK_STAND2024
049-01-004-15542097PENN STSUNBURYPA17801AURAND BRADLEYNORTHUMBERLAND75304SUNBURY0821008211273.8345011500115012016-09-22112133.9944134.8291134.4289VV - VACANTPERSONBOOK 2722-6672722-6672024
050-02-005-18842097943 FORT AUGUSTA AVESUNBURYPA17801REINARD RHONDA MNORTHUMBERLAND75304SUNBURY082000820338.790681107400885012007-05-25111134.6678135.1232134.8317RR - RESIDENTIALPERSONBOOK 1967-7121967-7122024