Saved query bbc959ac1a41d7e9

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

43/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '42' 
  AND countyfp = '087'

24,522 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelstate	ownername	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	numunits	numfloors	fldzone	elevmin	elevmax	elevavg	ownertype	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxyear
10 00-0411 000	42	087	31 N QUEEN ST	PA		MIFFLIN	46400	MCVEYTOWN	960500	9605	847.5455	1	1	1	—	165.2064	169.1102	167.2285							2026.2	2024
	42	087		PA	UNKNOWN	MIFFLIN	03040	ARMAGH	960100	9601	2435.1561				—	221.4669	225.5024	224.7292	UNDETERMINED	GOVT UNKNOWN	CLOSED	V	AITKIN CAVE (ROWLANDS PRESERVE)	PRIVATE CONSERVATION	2026.2
	42	087		PA	STATE OF PENNSYLVANIA	MIFFLIN	09288	BROWN	960200	9602	615.5838				—	180.5973	184.4002	182.3023	GOVERNMENT	GOVT STATE	OPEN	OTHER	TEA CREEK	CONSERVATION EASEMENT	2026.2
	42	087		PA	UNITED STATES NATURAL RESOURCES…	MIFFLIN	30480	GRANVILLE	960600	9606	10105.1071				—	174.2133	177.2620	175.2782	GOVERNMENT	GOVT FEDERAL	CLOSED	V	GRASSLANDS RESERVE PROGRAM (GRP)	CONSERVATION EASEMENT	2026.2
	42	087		PA	UNITED STATES NATURAL RESOURCES…	MIFFLIN	30480	GRANVILLE	960600	9606	773.3658				—	182.6050	188.8150	186.3994	GOVERNMENT	GOVT FEDERAL	CLOSED	V	GRASSLAND RESERVE PROGRAM (GRP)…	CONSERVATION EASEMENT	2026.2
	42	087		PA	UNITED STATES NATURAL RESOURCES…	MIFFLIN	30480	GRANVILLE	960600	9606	1722.2908				—	205.2197	212.0760	207.9510	GOVERNMENT	GOVT FEDERAL	CLOSED	V	GRASSLAND RESERVE PROGRAM (GRP)…	CONSERVATION EASEMENT	2026.2
	42	087		PA	UNKNOWN	MIFFLIN	03040	ARMAGH	960100	9601	957.2924				—	220.5373	248.8436	233.4047	UNDETERMINED	GOVT UNKNOWN	CLOSED	V	AITKIN CAVE (ROWLANDS PRESERVE)	PRIVATE CONSERVATION	2026.2
	42	087		PA	STATE OF PENNSYLVANIA	MIFFLIN	03040	ARMAGH	960100	9601	14004.7533				—	379.0287	406.7594	393.0566	GOVERNMENT	GOVT STATE	OPEN	OTHER	BALD EAGLE STATE FOREST	STATE RESOURCE MANAGEMENT AREA	2026.2
	42	087		PA	NON-GOVERNMENTAL ORGANIZATION	MIFFLIN	03040	ARMAGH	960100	9601	32755.0047				—	384.7028	427.2893	407.2366	PERSON	NGO	UNKNOWN	V	ROTHROCK WOODS	PRIVATE CONSERVATION	2026.2
	42	087		PA	UNKNOWN	MIFFLIN	03040	ARMAGH	960100	9601	54233.4845				—	255.6090	320.9752	294.0003	UNDETERMINED	GOVT UNKNOWN	OPEN	VI	BALD EAGLE STATE FOREST - PENNS…	STATE RESOURCE MANAGEMENT AREA	2026.2
	42	087		PA	UNKNOWN	MIFFLIN	03040	ARMAGH	960100	9601	4447.9898				—	357.1572	379.5311	367.8264	UNDETERMINED	GOVT UNKNOWN	OPEN	VI	BALD EAGLE STATE FOREST - PENNS…	STATE RESOURCE MANAGEMENT AREA	2026.2
	42	087		PA	UNITED STATES NATURAL RESOURCES…	MIFFLIN	30480	GRANVILLE	960600	9606	1444.8786				—	188.3031	192.1369	190.9519	GOVERNMENT	GOVT FEDERAL	CLOSED	V	GRASSLAND RESERVE PROGRAM (GRP)…	CONSERVATION EASEMENT	2026.2
	42	087		PA	UNITED STATES NATURAL RESOURCES…	MIFFLIN	30480	GRANVILLE	960600	9606	1559.5726				—	191.7917	194.4658	193.4878	GOVERNMENT	GOVT FEDERAL	CLOSED	V	GRASSLAND RESERVE PROGRAM (GRP)…	CONSERVATION EASEMENT	2026.2
	42	087		PA	UNITED STATES NATURAL RESOURCES…	MIFFLIN	30480	GRANVILLE	960600	9606	624.7419				—	188.8415	191.0263	190.1287	GOVERNMENT	GOVT FEDERAL	CLOSED	V	GRASSLAND RESERVE PROGRAM (GRP)…	CONSERVATION EASEMENT	2026.2
	42	087		PA	STATE OF PENNSYLVANIA	MIFFLIN	30480	GRANVILLE	960600	9606	462967.7648				—	190.5494	309.9287	259.2548	GOVERNMENT	GOVT STATE	OPEN	OTHER	STATE GAME LAND 113	STATE RESOURCE MANAGEMENT AREA	2026.2
	42	087		PA	STATE OF PENNSYLVANIA	MIFFLIN	03040	ARMAGH	960100	9601	15558529.1272				—	224.4676	670.8201	447.5916	GOVERNMENT	GOVT STATE	OPEN	VI	WHITE MOUNTAIN WILD AREA	STATE RESOURCE MANAGEMENT AREA	2026.2
	42	087		PA	UNKNOWN	MIFFLIN	03040	ARMAGH	960100	9601	17587.4545				—	270.4396	380.4212	293.9486	UNDETERMINED	GOVT UNKNOWN	OPEN	VI	BALD EAGLE STATE FOREST - PENNS…	STATE RESOURCE MANAGEMENT AREA	2026.2
	42	087		PA	UNKNOWN	MIFFLIN	03040	ARMAGH	960100	9601	11815.2444				—	398.3673	440.7705	414.1345	UNDETERMINED	GOVT UNKNOWN	OPEN	VI	BALD EAGLE STATE FOREST - PENNS…	STATE RESOURCE MANAGEMENT AREA	2026.2
	42	087		PA	STATE OF PENNSYLVANIA	MIFFLIN	18464	DECATUR	961200	9612	483739.1683				—	406.3396	540.9815	452.3776	GOVERNMENT	GOVT STATE	OPEN	OTHER	BALD EAGLE STATE FOREST	STATE RESOURCE MANAGEMENT AREA	2026.2
	42	087		PA	NON-GOVERNMENTAL ORGANIZATION	MIFFLIN	18464	DECATUR	961200	9612	693.5053				—	182.5948	184.3681	184.0838	PERSON	NGO	CLOSED	V	CENTRAL PA CONSERVANCY EASEMENT	CONSERVATION EASEMENT	2026.2
	42	087		PA	NON-GOVERNMENTAL ORGANIZATION	MIFFLIN	18464	DECATUR	961200	9612	447.6110				—	183.8428	184.7545	184.4241	PERSON	NGO	CLOSED	V	CENTRAL PA CONSERVANCY EASEMENT	CONSERVATION EASEMENT	2026.2
	42	087		PA	UNITED STATES NATURAL RESOURCES…	MIFFLIN	30480	GRANVILLE	960600	9606	367.1741				—	184.0184	187.4432	186.0856	GOVERNMENT	GOVT FEDERAL	CLOSED	V	GRASSLAND RESERVE PROGRAM (GRP)…	CONSERVATION EASEMENT	2026.2
	42	087		PA	UNITED STATES NATURAL RESOURCES…	MIFFLIN	30480	GRANVILLE	960600	9606	714.8356				—	175.5931	177.3250	176.5689	GOVERNMENT	GOVT FEDERAL	CLOSED	V	GRASSLAND RESERVE PROGRAM (GRP)…	CONSERVATION EASEMENT	2026.2
	42	087		PA	UNKNOWN	MIFFLIN	03040	ARMAGH	960100	9601	1139.1683				—	381.6340	386.5398	385.1209	UNDETERMINED	GOVT UNKNOWN	OPEN	VI	BALD EAGLE STATE FOREST - PENNS…	STATE RESOURCE MANAGEMENT AREA	2026.2
	42	087	100 S LOGAN BLVD	PA		MIFFLIN	30480	GRANVILLE	960600	9606	3536237.2588				—	135.3099	585.6444	228.7274					MCCARDLE MOTORS INC	PROFESSIONAL_SERVICE	2026.2	2024