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 = '087'
24,522 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20 06-0120C 000 | 42 | 087 | 4752 STATE ROUTE 655 | BELLEVILLE | PA | 17004 | GEISINGER CLINIC | GEISINGER SYSTEM SERVICES 100 N… | DANVILLE | PA | 17822-2455 | MIFFLIN | 78392 | UNION | 960300 | 9603 | 8143.7440 | 170750 | 25000 | 195750 | 10 | 2016-07-01 | 2 | 1 | — | 254.7896 | 259.4391 | 257.9229 | C3 | PERSON | 2016-02710 | ORMSBY J DOUGLAS DMD | HOSPITAL | 2024 | ||||||||||||||||||||||||||||||||||||
| 03 01-0329 000 | 42 | 087 | 111 113 E THIRD ST | LEWISTOWN | PA | 17044 | THE CALVARY BAPTIST CHURCH OF S… | 201 HARVEST FIELDS DRIVE | BOALSBURG | PA | 16827 | MIFFLIN | 43000 | LEWISTOWN | 960800 | 9608 | 1401.4704 | 177500 | 17200 | 194700 | 1 | 2021-01-05 | 1 | 1 | 2 | — | 158.2432 | 164.6254 | 160.8944 | CX | NONPROFIT | 2021-00067 | CALVARY LEWISTOWN | CHRISTIAN_PLACE_OF_WORSHIP | 2024 | |||||||||||||||||||||||||||||||||||
| 12 21-0125 000 | 42 | 087 | 3712 NEW LANCASTER VALLEY RD | MILROY | PA | 17063 | NEW LANCASTER VALLEY VOLUNTEER … | 3712 NEW LANCASTER VALLEY RD | MILROY | PA | 17063 | MIFFLIN | 03040 | ARMAGH | 960100 | 9601 | 4216.6819 | 23050 | 12500 | 35550 | 1800 | 1978-05-25 | 2 | 1 | 1120 | — | 302.3648 | 306.6458 | 304.7466 | RX | PERSON | 0233-00975 | NEW LANCASTER VALLEY FIRE COMPA… | FIRE_STATION | 2024 | |||||||||||||||||||||||||||||||||||
| 18 05-0117A 000 | 42 | 087 | 1100 SR 655 | BELLEVILLE | PA | 17004 | WALKER KENNETH | 1100 SR 655 | BELLEVILLE | PA | 17004 | MIFFLIN | 48664 | MENNO | 960300 | 9603 | 1937.0538 | 58250 | 7500 | 65750 | 190000 | 2020-09-22 | 1 | 1 | 1 | 2940 | — | 283.7651 | 285.0360 | 284.4944 | R | FARMLAND | PERSON | 2020-03910 | 2024 | |||||||||||||||||||||||||||||||||||
| 14 14-0401 000 | 42 | 087 | 210 BETTY CIR | REEDSVILLE | PA | 17084 | DAVIS JESS P | 210 BETTY CIR | REEDSVILLE | PA | 17084 | MIFFLIN | 09288 | BROWN | 960200 | 9602 | 1215.5615 | 52000 | 12750 | 64750 | 260000 | 2025-10-29 | 1 | 1 | 1 | 1792 | — | 239.4800 | 243.2443 | 241.8136 | R | RESIDENTIAL | PERSON | 2025-04616 | 2024 | |||||||||||||||||||||||||||||||||||
| 20 15-0101A 000 | 42 | 087 | 115 S KISHACOQUILLAS ST | BELLEVILLE | PA | 17004 | GLICK BRIAN S LISA M | 115 S KISHACOQUILLAS ST | BELLEVILLE | PA | 17004 | MIFFLIN | 78392 | UNION | 960300 | 9603 | 2519.6394 | 23300 | 6600 | 29900 | 2018-03-14 | 2 | 1 | 1 | 1864 | — | 245.2092 | 249.9388 | 248.2940 | R | PERSON | 2018-00927 | BELLEVILLE POULTRY AUCTION | SPECIALTY_STORE | 2024 | |||||||||||||||||||||||||||||||||||
| 16 09-0461 000 | 42 | 087 | 1 SUNSHINE CIR | LEWISTOWN | PA | 17044 | SEVERS CHRISTOPHER PAUL | 1 SUNSHINE CIRCLE | LEWISTOWN | PA | 17044 | MIFFLIN | 18944 | DERRY | 961101 | 9611.0100 | 1860.4143 | 59900 | 27500 | 87400 | 315000 | 2021-07-19 | 1 | 1 | 2 | 2210 | — | 241.9274 | 245.2097 | 243.5632 | R | RESIDENTIAL | PERSON | 2021-03648 | 2024 | |||||||||||||||||||||||||||||||||||
| 21 09-0119A 000 | 42 | 087 | 2 BIG ELK HORN DR | MC VEYTOWN | PA | 17051 | BENSON BRANDY L BRIAN J | 46 MOUNT HOPE RD | MCVEYTOWN | PA | 17051 | MIFFLIN | 81784 | WAYNE | 960400 | 9604 | 8588.3522 | 31500 | 13950 | 45450 | 2015-04-14 | 1 | 1 | 1 | 2160 | — | 202.6944 | 209.2716 | 205.4411 | R | PERSON | 2015-01303 | BENSON'S B SQUARED | PRINTING_SERVICE | 2024 | |||||||||||||||||||||||||||||||||||
| 14 03-0317 000 | 42 | 087 | 304 PARK DR | REEDSVILLE | PA | 17084 | FULTZ BRANDON J | 304 PARK DR | REEDSVILLE | PA | 17084 | MIFFLIN | 09288 | BROWN | 960200 | 9602 | 2157.9027 | 36400 | 15000 | 51400 | 175000 | 2019-12-26 | 1 | 1 | 1 | 1425 | — | 243.2507 | 245.7720 | 244.8701 | R | RESIDENTIAL | PERSON | 2019-05435 | 2024 | |||||||||||||||||||||||||||||||||||
| 14 01-0542 000 | 42 | 087 | 33 TILBURY LN | REEDSVILLE | PA | 17084 | KYLOR CODY R LAUREN A | 33 TILBURY LANE | REEDSVILLE | PA | 17084 | MIFFLIN | 09288 | BROWN | 960200 | 9602 | 1143.0919 | 61400 | 23000 | 84400 | 330000 | 2022-03-07 | 1 | 1 | 1 | 2647 | — | 226.5187 | 228.4722 | 227.8337 | R | PERSON | 2022-01097 | 2024 | ||||||||||||||||||||||||||||||||||||
| 09 03-0219 000 | 42 | 087 | 351 CEDAR ST | MOUNT UNION | PA | 17066 | GRAINEY JASON W ALESIA D | 351 CEDAR ST | MOUNT UNION | PA | 17066 | MIFFLIN | 40016 | KISTLER | 960400 | 9604 | 359.4254 | 19000 | 3750 | 22750 | 55000 | 2005-02-17 | 1 | 1 | 1 | 1423 | — | 175.6360 | 176.0150 | 175.7842 | R | PERSON | 0538-01837 | 2024 | ||||||||||||||||||||||||||||||||||||
| 21 08-0114AA,000 | 42 | 087 | 150 COY LN | MC VEYTOWN | PA | 17051 | LANE JAMES E SR DIANA M | 150 COY LANE | MCVEYTOWN | PA | 17051 | MIFFLIN | 81784 | WAYNE | 960400 | 9604 | 42892.4205 | 26000 | 17200 | 43200 | 25000 | 2002-04-26 | 1 | 1 | 2 | 1680 | — | 229.5746 | 275.0984 | 256.0067 | A | PERSON | 0504-03962 | 2024 | ||||||||||||||||||||||||||||||||||||
| 16 11-1111 000 | 42 | 087 | 147 CAMBRIDGE LN | LEWISTOWN | PA | 17044 | BAKER DANIEL B SAUNDRA K TRUSTEE | 147 CAMBRIDGE LN | LEWISTOWN | PA | 17044 | MIFFLIN | 18944 | DERRY | 961101 | 9611.0100 | 1475.3233 | 52000 | 8200 | 60200 | 1 | 2021-01-04 | 1 | 1 | 1 | 1690 | — | 163.6988 | 167.5708 | 165.2686 | R | TRUST | 2021-00013 | 2024 | ||||||||||||||||||||||||||||||||||||
| 13 07-0212 000 | 42 | 087 | 108 COLD SPRINGS RD | LEWISTOWN | PA | 17044 | FOX STACEY E | C O H PAUL SEMDER 108 COLD SPRI… | LEWISTOWN | PA | 17044 | MIFFLIN | 08304 | BRATTON | 960500 | 9605 | 7477.0671 | 51050 | 13550 | 64600 | 1 | 2025-10-01 | 1 | 1 | 1 | 1632 | — | 178.3685 | 186.5795 | 182.8659 | R | PERSON | 2025-04176 | 2024 | ||||||||||||||||||||||||||||||||||||
| 16 16-1010 000 | 42 | 087 | 21 REDBUD LN | LEWISTOWN | PA | 17044 | SHEAFFER DAVID K DENISE R | 21 REDBUD LANE | LEWISTOWN | PA | 17044 | MIFFLIN | 18944 | DERRY | 961102 | 9611.0200 | 1199.6141 | 25950 | 16900 | 42850 | 8100 | 1980-09-23 | 1 | 1 | 1 | 1120 | — | 195.2741 | 204.8771 | 199.6461 | R | PERSON | 0246-00794 | 2024 | ||||||||||||||||||||||||||||||||||||
| 20 01-0118WA,000 | 42 | 087 | 297 UPPER STONE MOUNTAIN RD | BELLEVILLE | PA | 17004 | PEACHEY SAMUEL R BARBARA I | 100 PLANE VIEW DRIVE | BELLEVILLE | PA | 17004 | MIFFLIN | 78392 | UNION | 960300 | 9603 | 82997.0879 | 58000 | 22150 | 80150 | 16373 | 1991-07-19 | 1 | 1 | 1 | 1664 | — | 455.9011 | 549.1074 | 510.4420 | A | PERSON | 0375-01249 | 2024 | ||||||||||||||||||||||||||||||||||||
| 01 16-0250 000 | 42 | 087 | 209 W MARKET ST | LEWISTOWN | PA | 17044 | STEWART LUCAS D | 478 HONEY CREEK RD | REEDSVILLE | PA | 17084 | MIFFLIN | 43000 | LEWISTOWN | 960800 | 9608 | 607.3037 | 23950 | 7800 | 31750 | 40000 | 2015-08-14 | 1 | 1 | 2156 | — | 153.0635 | 154.7857 | 154.3431 | RC | PERSON | 2015-03319 | VANTAGE POINT | FINANCIAL_SERVICE | 2024 | |||||||||||||||||||||||||||||||||||
| 16 38-0622 000 | 42 | 087 | 912 US HWY 522 N | LEWISTOWN | PA | 17044 | ANGNEY ROBERT L JR | 7661 STAGE ROAD | MCCLURE | PA | 17841 | MIFFLIN | 18944 | DERRY | 961101 | 9611.0100 | 1625.9039 | 24400 | 8400 | 32800 | 71670 | 2001-08-24 | 1 | 1 | 1 | 1368 | — | 177.8574 | 182.8337 | 180.7002 | R | PERSON | 0496-02981 | 2024 | ||||||||||||||||||||||||||||||||||||
| 17 38-0326 000 | 42 | 087 | 40 MIDDLE RD | MC VEYTOWN | PA | 17051 | DEAMER MATTHEW T BRADLEY L BEDLY | 543 EAST FREEDOM AVE | BURNHAM | PA | 17009 | MIFFLIN | 30480 | GRANVILLE | 960600 | 9606 | 1486.1472 | 7200 | 10900 | 18100 | 15000 | 2019-01-25 | 1 | 1 | 1 | 720 | — | 159.0918 | 168.2418 | 163.9774 | R | PERSON | 2019-00339 | 2024 | ||||||||||||||||||||||||||||||||||||
| 08 25-0104 000 | 42 | 087 | 637 E FREEDOM AVE | BURNHAM | PA | 17009 | STRINGER ANGELA M | PO BOX 52 | MATTAWANA | PA | 17054 | MIFFLIN | 10256 | BURNHAM | 961000 | 9610 | 1794.0252 | 19050 | 8150 | 27200 | 64500 | 1998-07-16 | 2 | 1 | 1 | 1152 | — | 163.2512 | 169.6654 | 166.3621 | R | PERSON | 0459-01795 | 2024 | ||||||||||||||||||||||||||||||||||||
| 18 03-0225 000 | 42 | 087 | 25 MARGERY RD | BELLEVILLE | PA | 17004 | PEACHEY VINCENT M | 25 MARGERY RD | BELLEVILLE | PA | 17004 | MIFFLIN | 48664 | MENNO | 960300 | 9603 | 4741.9768 | 24700 | 12900 | 37600 | 78765 | 2013-11-12 | 1 | 1 | 1 | 1120 | — | 323.8004 | 334.2916 | 328.8216 | R | PERSON | 2013-05672 | 2024 | ||||||||||||||||||||||||||||||||||||
| 05 06-0112 000 | 42 | 087 | 414 E WALNUT ST | LEWISTOWN | PA | 17044 | FALCONE RENTALS LLC | 9428 US HWY 522 S | LEWISTOWN | PA | 17044 | MIFFLIN | 43000 | LEWISTOWN | 960700 | 9607 | 1386.5888 | 14600 | 6600 | 21200 | 25000 | 2022-02-03 | 1 | 1 | 1 | 1269 | — | 152.4285 | 160.6340 | 157.7320 | R | BUSINESS | 2022-00567 | 2024 | ||||||||||||||||||||||||||||||||||||
| 16 01-0126D 000 | 42 | 087 | 186 WINDING LN | LEWISTOWN | PA | 17044 | BEDLYON GRAIG L TABITHA L | 182 WINDING LANE | LEWISTOWN | PA | 17044 | MIFFLIN | 18944 | DERRY | 961102 | 9611.0200 | 1037.0228 | 18800 | 10250 | 29050 | 47000 | 2022-03-16 | 1 | 1 | 1 | 1387 | — | 183.4339 | 187.1968 | 185.5076 | R | PERSON | 2022-01249 | 2024 | ||||||||||||||||||||||||||||||||||||
| 17 11-0118IA,000 | 42 | 087 | 29 BLUE JUNIATA DR | LEWISTOWN | PA | 17044 | STINE CHESTER A ROBIN L | 29 BLUE JUNIATA DR | LEWISTOWN | PA | 17044 | MIFFLIN | 30480 | GRANVILLE | 960600 | 9606 | 1870.7299 | 32100 | 11000 | 43100 | 99000 | 2006-05-26 | 2 | 1 | 1 | 1120 | — | 143.1488 | 152.4016 | 149.1340 | R | PERSON | 0553-03329 | 2024 | ||||||||||||||||||||||||||||||||||||
| 15 02-0101D 000 | 42 | 087 | 2836 OLD STAGE RD | LEWISTOWN | PA | 17044 | TODARO RHONDA L | 2836 OLD STAGE RD | LEWISTOWN | PA | 17044 | MIFFLIN | 18464 | DECATUR | 961200 | 9612 | 10302.4158 | 65150 | 12950 | 78100 | 1 | 2019-09-10 | 1 | 1 | 1 | 2418 | — | 234.6818 | 274.4901 | 249.1873 | R | PERSON | 2019-03745 | 2024 |