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

189,646 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
500380360000042071140 WEST END DRPENNPA17545STEHMAN LINDA75 N FULTON STMANHEIMPA17545LANCASTER58840PENN010302103.020027329.79945579004270009849004250001970-01-01112121.4499125.7133123.2597559COMMERCIALPERSON5972263POWER HOUSE PERFORMANCEAUTOMOTIVE_SERVICE2024
210181390000042071384 CABIN DRPA17522HOOVER DARVIN M384 CABIN DRIVEEPHRATAPA17522LANCASTER82824WEST EARL013002130.0200208830.6152429600816600124620011970-01-0161194.8570105.786098.5859824PERSON6510474NGOCLOSED2013-004AGRICULTURAL EASEMENT2024
500529260000042071805 TEMPERANCE HILL RDPENNPA17543TLUMACH BOGDAN I805 TEMPERANCE HILL RDLITITZPA17543LANCASTER58840PENN010302103.02004330.424437710076300453400600001970-01-01211130.5431133.6949132.2762113FARMYARDPERSON51690862024
336762830000042071508 E FULTON STLANCASTERPA17602BECKER DEBORAH L508 E FULTON STLANCASTERPA17602LANCASTER41216LANCASTER0002002144.2561591001710076200599001970-01-0111104.0920105.6910104.8985113PERSON713943263-573STUDIO SPINGYM2024
3700290400000420718 N NEW STLITITZPA17543BEEARS KELLY L37 EAST LINCOLN AVENUELITITZPA17543LANCASTER43816LITITZ012002120.0200248.686376100345001106001800001970-01-01111119.1650119.7262119.4933113RESIDENTIALPERSON65736692024
3901470500000420711113 BRIGHTON AVEMANHEIMPA17543MUSSER ANTHONY D1113 BRIGHTON AVENUELITITZPA17543LANCASTER46896MANHEIM011901119.0100557.4459208000615002695002922601970-01-01112118.6674119.5719119.2287113RESIDENTIALPERSON055989712024
18071812000004207115 PUSEYVILLE RDPA17566CLARK JEANINE15 PUSEYVILLE RDQUARRYVILLEPA17566LANCASTER21040EAST DRUMORE014601146.01004706.70968270073900156600101970-01-01111183.5269186.8228185.1800113PERSON6605927J9 DESIGNDESIGN_SERVICE2024
5008297600000420716324 BAYBERRY AVEPENNPA17545KOSMAN ROBERT6324 BAYBERRY AVEMANHEIMPA17545LANCASTER58840PENN010302103.0200769.5648193400547002481004300001970-01-01112144.1649147.8699145.3886113RESIDENTIALPERSON67677252024
40099323000004207138 S PENN STMANHEIMPA17545MYERS LARRY E38 S PENN STMANHEIMPA17545LANCASTER46888MANHEIM010400104691.6894107500464001539001449001970-01-01112121.4759122.2934121.9111113RESIDENTIALPERSON51022552024
370715680000042071104 OXFORD DRLITITZPA17543FIRESTONE MICHAEL J104 OXFORD DRIVELITITZPA17543LANCASTER43816LITITZ012001120.01001525.83771269006610019300011970-01-01111137.7369143.8309140.3302113RESIDENTIALPERSON67095022024
350414100000042071102 CARRIAGE DRINTERCOURSEPA17529ESH IVAN L REBECCA JANE3734 E NEWPORT RDGORDONVILLEPA17529LANCASTER42080LEACOCK014101141.01003691.52323446008420042880011970-01-01311130.5449133.9362132.6038113RESIDENTIALPERSON62106302024
21042913000004207136 CEDAR AVEBROWNSTOWNPA17522STEELE JAMES L LOUISE A36 CEDAR AVE PO BOX 96BROWNSTOWNPA17508LANCASTER82824WEST EARL013001130.01001169.594312680046400173200920001970-01-01111109.7959111.4810110.8949113RESIDENTIALPERSON3370/4632024
450908040000042071542 BENT OAK DRMOUNT JOYPA17552WAY JODY L542 BENT OAK DRIVEMOUNT JOYPA17552LANCASTER21032EAST DONEGAL011102111.0200724.6798120400526001730001625001970-01-01111115.4530116.6562115.8036113RESIDENTIALPERSON60960372024
390919200000042071338 BLOSSOM HILL DRMANHEIMPA17601DEMYDOVYCH IAROSLAV338 BLOSSOM HILL DRIVELANCASTERPA17601LANCASTER46896MANHEIM011807118.07001819.0278185600805002661001920001970-01-01111139.4770150.7734145.0386113PERSON63770522024
3905262000000420711041 BLUESTONE DRMANHEIMPA17543PATEL DHIREN Y1041 BLUESTONE DRIVELITITZPA17543LANCASTER46896MANHEIM011901119.01006789.24991126200158300128450013500001970-01-0121108.5371112.9069110.8631130RESIDENTIALPERSON59477222024
3907642700000420711820 BEVERLY DRMANHEIMPA17601DRAGAN RADU1820 BEVERLY DRIVELANCASTERPA17601LANCASTER46896MANHEIM011803118.03001207.7908150500625002130003047001970-01-01111127.5909128.7319128.2191113PERSON63137962024
4104608400000420711030 SHADOWSTONE DRMANORPA17603SWISHER HAROLD P MARGARET A1030 SHADOWSTONE DRLANCASTERPA17603LANCASTER46992MANOR013704137.04001867.3114205600719002775001345001970-01-0111193.449998.830196.7610113PERSON23364002024
3909117600000420711161 OAKMONT DRMANHEIMPA17601BURES RAYMOND A1161 OAKMONT DRIVELANCASTERPA17601LANCASTER46896MANHEIM011801118.01001672.50522375001003003378007300001970-01-01112106.9150110.6875109.3153113PERSON202468019882024
130916040000042071118 MARKET STBAINBRIDGEPA17502HOFFACKER KIRK M118 MARKET ST P O BOX 25BAINBRIDGEPA17502LANCASTER15824CONOY010802108.0200935.7156159800355001953002120001970-01-0111189.565090.932990.4035113PERSON62104182024
4606306900000420711357 COLD SPRING RDMOUNT JOYPA17022LUSCIAN STEPHEN J III1357 COLD SPRINGS RDELIZABETHTOWNPA17022LANCASTER51664MOUNT JOY010601106.010010894.4894339900937004336003333611970-01-01112149.4900155.3429152.6066113PERSON53593572024
190117110000042071554 REIDENBACH RDEARLPA17557HORNING ELVIN Z552 REIDENBACH RDNEW HOLLANDPA17557LANCASTER20688EARL01290012928068.770828100018900047000011970-01-01311128.5760131.8819130.6595113PERSON65193622024
60041386000004207169 BROOKVIEW DRPA17543WALTZ DANIEL E KAREN M69 BROOKVIEW DRLITITZPA17543LANCASTER81168WARWICK012103121.03001128.3378220100621002822001699001970-01-01111119.7080120.7749120.3482113RESIDENTIALPERSON55380962024
090367070000042071320 NETZLEY DRWEST COCALICOPA17517SENSENIG CORY L320 NETZLEY RDDENVERPA17517LANCASTER82728WEST COCALICO010104101.040019094.222329670012900042570011970-01-01111236.3869272.0960256.3353113PERSON057222432024
590703920000042071320 BROAD STTERRE HILLPA17519ALLGYER WILMER S ERMA NP O BOX 555TERRE HILLPA17581LANCASTER76400TERRE HILL012701127.01001653.699310640045100151500910001970-01-01211161.4579167.3592164.4308113PERSON58310702024
030618500000042071161 CLOVER HILL RDGEORGETOWNPA17509ESH JERRE S161 CLOVER HILL RDCHRISTIANAPA17509LANCASTER04376BART014301143.010013300.3197151300244300395600316651970-01-01211186.8780202.2899196.1311810PERSON202500492162024