Saved query 204ec87efd61dcac

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

0/80

Live SQL

SELECT * 
FROM "parcel_layer" 
WHERE statefp = '42' 
  AND countyfp = '067'

13,667 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	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	naicscode	book	page	placename	placetype
5-6-25	05-06 -025	42	067	1275 LONG HOLLOW RD	LITITZ	PA	17543	517 NORTH PLUM STREET LLC	4 OAKWOOD LN	LITITZ	PA	17543	JUNIATA	31424	GREENWOOD	070400	704	389897.3485	52194	23324	23324	28870	550000	2016-03-31	1	1	2003	112	1320	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	206.6813	271.0448	239.9418	001	F	100.0900	BUSINESS		0	0
13-5-44	13-05 -044	42	067	139 GAMBI HILL RD	COCHRANVILLE	PA	19330	STOLTZFUS FAMILY PRTNSP	1043 GAP NEWPORT PIKE	COCHRANVILLE	PA	19330	JUNIATA	75536	SUSQUEHANNA	070400	704	37552.5790	15740	6220	6220	9520	158500	2003-12-15	1	1	1970	1	896	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	252.4172	271.2076	260.6325	001	R	10	PERSON		328	1025
4-6-41	04-06 -041	42	067	698 BUTCHERSHOP RD	MIFFLINTOWN	PA	17059	SANER TRAVIS &	698 BUTCHER SHOP RD	MIFFLINTOWN	PA	17059	JUNIATA	25648	FERMANAGH	070102	701.0200	5638.7696	48880	-9200	-11420	79650	1	2012-08-17	1	1	2014	2	2462	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	161.1902	166.3334	163.6408	001	R	1.4400	PERSON		0	0
1-6-35	01-06 -035	42	067	5387 MCCOYSVILLE RD	MIFFLIN	PA	17058	DEVENUTA FRANK	5387 MCCOYSVILLE RD	MIFFLIN	PA	17058	JUNIATA	04560	BEALE	070202	702.0200	54826.0412	34190	8950	8950	25240	430000	2023-07-20	1	1	1985	112	1840	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	206.7291	259.8120	221.1945	001	R	14.2000	PERSON		0	0
15-5-59	15-05 -059	42	067	8953 MOUNTAIN RD	PORT ROYAL	PA	17082	SHAY CORY L RESIDENCE TRT	8953 MOUNTAIN RD	PORT ROYAL	PA	17082	JUNIATA	77824	TURBETT	070202	702.0200	1543.0936	15940	1590		17530	1	2015-07-16	1	1	1969	1	1120	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	177.7346	179.2852	178.6857	001	R	0.4200	TRUST		0	0
9-17-36	09-17 -036	42	067	1697 STETLER RD	MIFFLINTOWN	PA	17059	GEIBEL SEAN R	1697 STETLER RD	MIFFLINTOWN	PA	17059	JUNIATA	49392	MILFORD	070202	702.0200	5216.1481	29530	2640		32170	175000	2009-10-02	1	1	1992	2	1488	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	150.6906	161.2754	155.7107	001	R	1.2700	PERSON		432	698
11-1-33	11-01 -033	42	067	903 MILFORD ST	PORT ROYAL	PA	17082	CISNEY DYLAN S	903 MILDFORD STREET	PORT ROYAL	PA	17082	JUNIATA	62304	PORT ROYAL	070202	702.0200	1280.4303	19460	2700		22160	128000	2019-02-27	1	1	1950	112	868	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	142.6735	143.9305	143.5623	001	R	0	PERSON		0	0
13-5-51	13-05 -051	42	067	1162 SMITHVILLE RD	LIVERPOOL	PA	17045	BRUBAKER PAUL E &	1162 SMITHVILLE RD	LIVERPOOL	PA	17045	JUNIATA	75536	SUSQUEHANNA	070400	704	34431.8195	8520	2380		10900	96900	2015-11-04	1	1	1000	112	750	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	165.3373	206.4350	195.5402	001	R	9.7500	PERSON		0	0
3-12-6	03-12 -006	42	067	200 LIBERTY RD	MCALISTERVILLE	PA	17049	HAINES TIMOTHY J &	200 LIBERTY RD	MCALISTERVILLE	PA	17049	JUNIATA	25440	FAYETTE	070101	701.0100	5686.7455	26770	2250		29020	187000	2015-11-30	1	1	1995	1	1644	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	275.1607	286.1898	280.3212	001	R	1.5000	PERSON		0	0
16-11-17	16-11 -017	42	067	1446 MIDDLE RD	HONEY GROVE	PA	17035	SAUTER CHARLES H	1446 MIDDLE RD	HONEY GROVE	PA	17035	JUNIATA	77952	TUSCARORA	070201	702.0100	177265.5376	14720	5610		20330	1	2005-09-30	1	1	1000	2	432	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	169.6370	226.6577	189.4598	001	F	47.6500	PERSON		361	829
4-10A-29	04-10A-029	42	067	427 BRITCHER DR	MIFFLINTOWN	PA	17059	HARLOW MICHAEL W JR	427 BRITCHER DR	MIFFLINTOWN	PA	17059	JUNIATA	25648	FERMANAGH	070102	701.0200	15102.7808	13590	2220		15810	153250	2014-06-06	1	1	1995	1	1052	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	243.5211	264.5985	252.8902	001	R	3.2100	PERSON		0	0
13-3-9	13-03 -009	42	067	674 LIGHT RD	LIVERPOOL	PA	17045	CONDRAN JOSHUA E &	674 LIGHT RD	LIVERPOOL	PA	17045	JUNIATA	75536	SUSQUEHANNA	070400	704	3912.2744	6480	1530		8010	111000	2021-04-26	1	1	1000	2	640	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	176.5099	184.9687	179.8147	001	R	1.1399	PERSON		0	0
4-7-12	04-07 -012	42	067	212 MEADOWBROOK LN	MIFFLINTOWN	PA	17059	ZIMMERMAN CINDY L	212 MEADOWBROOK LANE	MIFFLINTOWN	PA	17059	JUNIATA	25648	FERMANAGH	070102	701.0200	3168.7693	6980	2500		9480	1	2013-02-05	1	1	1000	2	672	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	141.5138	144.9103	143.3577	001	R	0.9400	PERSON		0	0
2-2-56	02-02 -056	42	067	12039 WILLIAM PENN HWY	THOMPSONTOWN	PA	17094	KLINGLER INC	12039 WILLIAM PENN HWY	THOMPSONTOWN	PA	17094	JUNIATA	18680	DELAWARE	070300	703	15320.4727	61400	7810		69210	6000	1977-06-01	1	1				42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	146.4805	159.4447	151.0436	028	C	3.8100	BUSINESS	11111	118	009	THE AGRONOMY CENTER	AGRICULTURAL_SERVICE
6-19-44	06-19 -044	42	067	1801 PUMPING STATION RD	CHAMBERSBURG	PA	17202	RAMER TRAVIS L &	5237 CUMBERLAND HWY	CHAMBERSBURG	PA	17202	JUNIATA	40752	LACK	070201	702.0100	26022.4417	18990	2640		21630	140000	2021-04-27	1	1	1992	112	1204	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	253.6581	285.9705	268.3611	001	R	6.6900	PERSON		0	0
13-5-66	13-05 -066	42	067	19334 RT 235	PORT TREVORTON	PA	17864	MARTIN KEITH A ET AL	543 HILLTOP RD	PORT TREVORTON	PA	17864	JUNIATA	75536	SUSQUEHANNA	070400	704	26081.4164	6050	2370		8420	75000	2019-02-05	1	1	1930	1	324	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	175.8525	218.1395	199.0913	001	R	5.9000	PERSON		0	0
9-19-13	09-19 -013	42	067	1032 LIONS CLUB PARK RD	PORT ROYAL	PA	17082	BERGSTRESSER GINI	1032 LIONS CLUB PARK RD	PORT ROYAL	PA	17082	JUNIATA	49392	MILFORD	070202	702.0200	6293.1554	12560	1620		14180	147100	2018-07-26	1	1	1961	1	1232	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	130.5944	146.3643	140.3395	001	R	1.4100	PERSON		0	0
6-14-8	06-14 -008	42	067	3680 RT 75 S	EAST WATERFORD	PA	17021	PARKER TYLER W &	3258 RT 75 S	EAST WATERFORD	PA	17021	JUNIATA	40752	LACK	070201	702.0100	14325.5938	5760	2600		8360	140000	2021-05-11	1	1	1000	2	1160	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	213.6814	230.5363	220.8425	001	R	3	PERSON		0	0
4-17-12	04-17 -012	42	067	25593 RT 35 N	MIFFLINTOWN	PA	17059	ZOOK JOSEPH A &	25593 RT 35 N	MIFFLINTOWN	PA	17059	JUNIATA	25648	FERMANAGH	070102	701.0200	3553.9791	28820	2980		31800	35000	2014-06-23	1	1	1968	1	2102	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	164.6233	172.3674	167.8462	001	R	0.9100	PERSON		0	0
12-8-84	12-08 -084	42	067	4914 MOUNTAIN RD	PORT ROYAL	PA	17082	EICHENBERGER KATHIE M	4990 MOUNTAIN RD	PORT ROYAL	PA	17082	JUNIATA	73504	SPRUCE HILL	070202	702.0200	13004.8621	30020	1830		31850	1	2017-06-28	1	1	2022	1	2070	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	195.9053	199.7003	198.0466	001	R	3.2000	PERSON		0	0
3-13B-41	03-13B-041	42	067	225 PINE MAPLE ST	MC ALISTERVILLE	PA	17049	WYNN THOMAS & ELEANOR 1998 REVO…	PO BOX 213	MC ALISTERVILLE	PA	17049	JUNIATA	25440	FAYETTE	070101	701.0100	1674.1088	20800	2020		22820	172000	2021-09-08	1	1	1980	1	1408	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	197.9923	200.8866	199.5524	001	R	0.4300	TRUST		0	0
9-16-108	09-16 -108	42	067	460 SCHOOL HOUSE RD	MIFFLINTOWN	PA	17059	EHRENZELLER KEVIN R	460 SCHOOLHOUSE RD	MIFFLINTOWN	PA	17059	JUNIATA	49392	MILFORD	070202	702.0200	29776.2594	21310	1990		23300	1	2007-08-03	1	1	1998	1	1456	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	236.3174	290.9033	267.4893	001	R	7.5900	PERSON		395	1016
17-1A-20	17-01A-020	42	067	6154 WILLIAM PENN HWY	MIFFLINTOWN	PA	17059	MILLER GREGORY E &	6152 WILLIAM PENN HIGHWAY	MIFFLINTOWN	PA	17059	JUNIATA	80568	WALKER	070300	703	669.1268	11830	1140		12970	62200	2021-04-05	1	1	1940	2	576	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	143.1212	144.5917	143.8631	001	R	0	PERSON		0	0
10-3A-13	10-03A-013	42	067	35725 RT 35 N	RICHFIELD	PA	17086	HOFFMAN CAROL KANTZ	783 LITTLE EVENDALE RD	RICHFIELD	PA	17086	JUNIATA	50480	MONROE	070400	704	1741.9698	11290	2870		14160	158	2018-05-22	1	1	1940	2	960	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	225.0184	226.4855	225.7484	001	R	0	PERSON		0	0
4-7-25	04-07 -025	42	067	52 WOODY LN	MIFFLINTOWN	PA	17059	CHACK ALAN K &	52 WOODY LANE	MIFFLINTOWN	PA	17059	JUNIATA	25648	FERMANAGH	070102	701.0200	10574.5118	32170	2160		34330	1	2009-07-21	1	1	1994	1	1536	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	133.8518	150.0454	141.9716	001	R	2.6400	PERSON		428	1017