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

20,675 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
007-07C-207.L00004211977 PINE FLAT RDMIFFLINBURGPA17844BASHORE JAMES W20 BRIDLE WALKBLOOMSBURGPA17815UNION42960LEWIS090202902.0200777.218526600266001753-01-01111474.5634476.6583475.6128150PERSON00GOVT STATEOPENOTHERBALD EAGLE STATE FORESTSTATE RESOURCE MANAGEMENT AREA2024
001-080-152.0000042119214 FORD LNLEWISBURGPA17837YOUNG GORDON C JR TARA L214 FORD LNLEWISBURGPA17837UNION10016BUFFALO090502905.020084442.63218963020630-299701702001211236.4676282.6225253.2791504PERSON21170009YOUNG'S TAXIDERMYTECHNICAL_SERVICE2024
009-089-014.0000042119RIDGE RDMIFFLINBURGPA17844LAUVER MARGARET L HARRIS133 FARM HOLLOW LNMIFFLINBURGPA17844UNION43368LIMESTONE090400904317501.0888-16634023060-1663401894002000002004-11-01184.0869263.7996226.0620500PERSON13610001GOVT LOCALCLOSEDUNION COUNTY AGRICULTURAL EASEM…AGRICULTURAL EASEMENT2024
002-034-161.0000042119119 S 16TH STLEWISBURGPA17837535 INCPO BOX 423LEWISBURGPA17837UNION20888EAST BUFFALO090600906774.230921710065002236001950002006-01-31111150.7371151.6758151.1281401RESIDENTIALBUSINESS151900692024
010-027-156.0000042119270 MARKET STMIFFLINBURGPA17844STEELE ERIC M PAMELA D270 MARKET STMIFFLINBURGPA17844UNION49288MIFFLINBURG090300903715.5242107600133001209001250002004-06-01111176.3368176.9758176.7455100RESIDENTIALPERSON130500802024
013-096-129.000004211910410 BUFFALO RDMIFFLINBURGPA17844PM HOLDINGS COMPANY LLC10410 BUFFALO RDMIFFLINBURGPA17844UNION82640WEST BUFFALO090202902.020010004.19342832008740037060025500021241.9418251.0116244.0790408BUSINESS722426720164FOREST HOUSE HOTELBAR2024
009-092-040.00000421191130 SWENGEL RDMIFFLINBURGPA17844REIFF ANTHONY M MARY W1130 SWENGEL RDMIFFLINBURGPA17844UNION43368LIMESTONE09040090446248.055335617023470-12133062230012009-04-28411183.7834192.8516186.7457504PERSON190301632024
002-034-020.0000042119130 S 13TH STLEWISBURGPA1783744 MRKT LLCPO BOX 423LEWISBURGPA17837UNION20888EAST BUFFALO0906009064566.7830200600431002437003635002025-07-14111151.3623152.9669152.1312100RESIDENTIALBUSINESS363802812024
005-109-044.A000042119104 WINDY ACRES LNMILLMONTPA17845EPLEY SUSAN104 WINDY ACRES LNMILLMONTPA17845UNION32952HARTLEY090201902.01008418.2005-1320017800-9580019620012026-02-2711231.0840239.4694233.8487504FARMLANDPERSON369101222024
001-080-050.7000042119677 WHIPPOORWILL LNLEWISBURGPA17837HOOVER ALBERT A JR JANET M2252 HERSHEY AVEEAST PETERSBURGPA17520UNION10016BUFFALO090502905.020063634.80921774020840-31560101700550001999-12-01112222.8871280.5662254.2774504PERSON076302532024
009-092-007.1300042119603 PINNACLE LNMIFFLINBURGPA17844ROTHERMEL CURTIS M MANDY L603 PINNACLE LNMIFFLINBURGPA17844UNION43368LIMESTONE0904009042293.59912505003400028450012003-06-01112226.4654232.7231229.6569100RESIDENTIALPERSON115501442024
002-043-003.0130042119325 COUNTRY RDLEWISBURGPA17837MORROW WILLIAM H III KRISTIN A325 COUNTRY RDLEWISBURGPA17837UNION20888EAST BUFFALO0906009064852.5872232300406002729002050002012-07-18111153.8124166.0951160.7298100RESIDENTIALPERSON226500112024
008-011-027.000004211978 BROWN STLEWISBURGPA17837KAZAR BRANDON T DYER-KAZAR ASHL…78 BROWN STLEWISBURGPA17837UNION42976LEWISBURG0907009071249.60874940032100815001480002021-08-11111134.9788138.8644137.6688100PERSON327700932024
006-046-017.9000042119951 BIRCH RDWEST MILTONPA17886DOUGLAS WILLIAM R951 BIRCH STWEST MILTONPA17886UNION39136KELLY090502905.02001075.45636990072007710012018-04-23111148.2074150.6480149.3329100PERSON288401772024
002-034-113.83000421191408 MONROE AVELEWISBURGPA17837DIMON VIRGINIA MARIE1408 MONROE AVELEWISBURGPA17837UNION20888EAST BUFFALO0906009061763.760124900045100294100489900111153.1897155.0552154.4661100RESIDENTIALPERSON336902322024
002-035-092.00000421191040 WASHINGTON AVELEWISBURGPA17837LETTEER JOHN P JEANNE M1040 WASHINGTON AVELEWISBURGPA17837UNION20888EAST BUFFALO0906009061072.0400989003220013110041250111142.1927144.2376143.1422100RESIDENTIALPERSON013504592024
005-110-038.1500042119604 JOLLYS GROVE LNMILLMONTPA17845NASH J NICHOLAS TINA M604 JOLLYS GROVE LN PO BOX 31WEIKERTPA17885UNION32952HARTLEY090201902.01009469.5710413001790059200100001997-04-01111224.1203229.7635225.5991100PERSON053900412024
008-018-091.000004211940 N 8TH STLEWISBURGPA17837SNYDER WILLIAM D RACHEL D40 N 8TH STLEWISBURGPA17837UNION42976LEWISBURG090700907443.60046020021100813002550002021-04-30211140.9975142.1379141.7526100RESIDENTIALPERSON321401862024
008-015-056.0000042119109 N 3RD STLEWISBURGPA17837WHIPPLE CONOR79 BRIDGE STSENECA FALLSNY13148UNION42976LEWISBURG090700907441.432497100152001123002150002020-09-09111141.8080142.4749142.0710100RESIDENTIALPERSON312303172024
006-049-030.0000042119310 HIGH STWEST MILTONPA17886TEEME ENTERPRISE INC1212 MOORES SCHOOL RDLEWISBURGPA17837UNION39136KELLY090502905.0200587.245217910021001812001800002025-02-03111147.5607150.9871149.1669400BUSINESS359302662024
002-035-126.A000042119234 S 12TH STLEWISBURGPA17837CYR VAN T III234 S 12TH STLEWISBURGPA17837UNION20888EAST BUFFALO090600906677.7506141300267001680001111155.6781156.7860156.4054100RESIDENTIALPERSON292501762024
005-110-038.9000042119766 JOLLYS GROVE LNMILLMONTPA17845SMITH CHRISTOPHER J973 JOHNSON DRGETTYSBURGPA17325UNION32952HARTLEY090201902.01003285.701647600135006110012025-06-04211224.9457231.7317227.7481150PERSON361702402024
005-110-056.0000042119128 BARNETT RDMILLMONTPA17845DICAMPLI LOUIS128 BARNETT RDMILLMONTPA17845UNION32952HARTLEY090201902.01004484.527846100201006620077000211247.4806257.0542252.7062100FARMLANDPERSON302601722024
005-111-048.A0000421192495 LAUREL RDMILLMONTPA17845TURNER TIMOTHY N832 CHESTNUT STMIFFLINBURGPA17844UNION32952HARTLEY090201902.0100747.9879405004200447005250011198.6806199.8138199.3355400PERSON27630244UNITED STATES POSTAL SERVICESHIPPING_CENTER2024
002-042-034.W0000421192004 MADISON AVELEWISBURGPA17837BOEHNLEIN ROBERT D DEBORAH A2004 MADISON AVELEWISBURGPA17837UNION20888EAST BUFFALO0906009061260.272588800351001239001110001997-09-0111148.0599149.9430148.8291100RESIDENTIALPERSON057000012024