Saved query fc3a205da15ee384

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

11,785 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	totalvalue	saleamt	saledate	numbldgs	numunits	yearbuilt	numfloors	bldgsqft	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	naicscode	book	page	parceltype	accesstype	placename	placetype	lrversion
3-10-95	03-10 -095	42	067	63 STEVES WOODS DR	MCALISTERVILLE	PA	17049	PETERSHEIM VALENTINE A &	63 STEVES WOODS DR	MCALISTERVILLE	PA	17049	JUNIATA	25440	FAYETTE	070101	701.0100	33962.2205	40500	3730	44230	39800	2004-06-02	1	1	2005	2	2380	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	191.5133	203.4952	195.3233	001	R	8.3000	PERSON	6216	337	0169			VM WOOD PRODUCTS LLC	HOME_SERVICE	2026.2
3-10-12	03-10 -012	42	067	MAIN ST	MCALISTERVILLE	PA	17049	FAYETTE TWP	181 BUNKERTOWN RD	MCALISTERVILLE	PA	17049	JUNIATA	25440	FAYETTE	070101	701.0100	153331.1637	2450	11520	13970	1	2011-02-21	1	1				42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	190.5358	203.8692	196.2163	019	E	37.6599	PERSON		2011	536	GOVT LOCAL	OPEN	SIEBER PROPERTY ACQUISITION	LOCAL RECREATION AREA	2026.2
9-9-18	09-09 -018	42	067	6580 LICKING CREEK RD	MIFFLINTOWN	PA	17059	BRUBAKER CHAD M	6580 LICKING CREEK RD	MIFFLINTOWN	PA	17059	JUNIATA	49392	MILFORD	070202	702.0200	4431.0799	10470	2500	12970	151000	2017-06-16	1	1	1953	1	780	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	173.0566	182.1410	179.9640	001	R	1	PERSON		0	0					2026.2
12-6-14	12-06 -014	42	067	2589 MOUNTAIN RD	NEWPORT	PA	17074	BEILER CHRIST D	1001 MARKELSVILLE RD	NEWPORT	PA	17074	JUNIATA	73504	SPRUCE HILL	070202	702.0200	1723.2774	7300	1200	8500	55000	2011-11-23	1	1	1000	1	952	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	185.3440	187.1974	186.3573	001	R	0.5000	PERSON		0	0					2026.2
2-9-28	02-09 -028	42	067	12752 WILLIAM PENN HWY	THOMPSONTOWN	PA	17094	LEONARD RYAN J &	12752 WILLIAM PENN HWY	THOMPSONTOWN	PA	17094	JUNIATA	18680	DELAWARE	070300	703	5554.1112	25450	3740	29190	185000	2013-01-08	1	1	1970	1	1680	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	148.0973	150.0389	148.9423	001	R	1.3700	PERSON		0	0					2026.2
4-17-13	04-17 -013	42	067	25877 RT 35 N	MIFFLINTOWN	PA	17059	CAMPBELL ROBERT J &	25877 RT 35 NORTH	MIFFLINTOWN	PA	17059	JUNIATA	25648	FERMANAGH	070102	701.0200	14603.8977	24640	4020	28660	1	2019-06-17	1	1	1969	1	1620	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	167.0275	178.7037	171.0946	001	R	3.5400	PERSON		0	0					2026.2
17-14-9	17-14 -009	42	067	10408 WILLIAM PENN HWY	THOMPSONTOWN	PA	17094	RITZMAN TAMBRA C &	10408 WILLIAM PENN HWY	THOMPSONTOWN	PA	17094	JUNIATA	80568	WALKER	070300	703	204421.6478	15210	19480	34690	100000	2009-01-13	1	1	1000	2	1318	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	146.0376	154.6665	149.7145	001	F	48.0800	PERSON		420	916					2026.2
16-16-20	16-16 -020	42	067	154 GILBOW HILL RD	DENVER	PA	17517	HIGH LESTER M &	85 MARTZALL RD	DENVER	PA	17517	JUNIATA	77952	TUSCARORA	070201	702.0100	3269.7609	3160	1400	4560	1	2005-09-27	1	1	1950	1	468	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	226.3689	247.9741	233.5563	001	R	0.8100	PERSON		361	674					2026.2
9-9-58	09-09 -058	42	067	107 CREEKSIDE LN	MIFFLINTOWN	PA	17059	SMITH DANIEL P &	107 CREEKSIDE LN	MIFFLINTOWN	PA	17059	JUNIATA	49392	MILFORD	070202	702.0200	72282.5487	13040	4200	17240	1	2014-11-03	1	1	1000	1	960	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	163.7945	180.3791	170.1397	001	F	17.8200	PERSON		0	0					2026.2
4-16-70	04-16 -070	42	067	4767 CUBA MILLS RD	MIFFLINTOWN	PA	17059	SUTER CANDACE A	4767 CUBA MILLS RD	MIFFLINTOWN	PA	17059	JUNIATA	25440	FAYETTE	070101	701.0100	7398.5923	23630	3680	27310	153000	2013-10-25	1	1	1998	1	1400	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	170.1690	176.3814	174.0253	001	R	1.8400	PERSON		0	0					2026.2
13-7-88	13-07 -088	42	067	434 PAULINE LN	MOUNT PLEASANT MILLS	PA	17853	GRAHAM GLENN D &	434 PAULINE LANE	MOUNT PLEASANT MILLS	PA	17853	JUNIATA	75536	SUSQUEHANNA	070400	704	60398.3707	24210	3870	28080	48119	2005-04-21	1	1	2005	1	1296	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	187.5304	224.4853	209.8511	001	R	14.0900	PERSON		352	1057					2026.2
13-7-7	13-07 -007	42	067	423 PAULINE LN	MOUNT PLEASANT MILLS	PA	17853	STAHR DIANE M	423 PAULINE LN	MOUNT PLEASANT MILLS	PA	17853	JUNIATA	75536	SUSQUEHANNA	070400	704	59752.7644	44580	2860	47440	52800	2010-10-25	1	1	2012	1	2652	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	167.5381	224.9639	209.4987	001	R	13.7000	PERSON		2010	2804					2026.2
2-5-50	02-05 -050	42	067	24 DOUBLE B RD	MIFFLINTOWN	PA	17059	EAST SALEM COMMUNITY CHURCH	7398 RT 235	MIFFLINTOWN	PA	17059	JUNIATA	18680	DELAWARE	070300	703	4217.6654	25060	2550	27610	1	2023-07-03	1	1	1990	2	1260	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	191.7315	197.4421	194.6282	001	E	1.0200	NONPROFIT		0	0					2026.2
16-10-27	16-10 -027	42	067	204 RIDGE LN	HONEY GROVE	PA	17035	SCHEIB PATRICIA A &	204 RIDGE LN	HONEY GROVE	PA	17035	JUNIATA	77952	TUSCARORA	070201	702.0100	46911.5120	15660	2290	17950	1	2010-08-30	1	1	1992	1	1120	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	265.9556	296.5408	281.4842	001	R	11.5800	PERSON		2010	2157					2026.2
4-9-28	04-09 -028	42	067	2747 CUBA MILLS RD	MIFFLINTOWN	PA	17059	BENNETT BRANDON F &	2747 CUBA MILLS RD	MIFFLINTOWN	PA	17059	JUNIATA	25648	FERMANAGH	070102	701.0200	4716.0852	15080	2130	17210	154000	2020-09-30	1	1	1968	1	1040	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	154.1630	161.6663	157.2369	001	R	1.4400	PERSON		0	0					2026.2
3-14-69	03-14 -069	42	067	198 SUNNYSIDE LN	MCALISTERVILLE	PA	17049	LOGAN KAREN E	198 SUNNYSIDE LN	MCALISTERVILLE	PA	17049	JUNIATA	25440	FAYETTE	070101	701.0100	41191.3345	31540	3800	35340	1	2019-02-26	1	1	1994	112	1500	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	276.9379	322.6777	298.3138	001	R	10	PERSON		0	0					2026.2
3-2-63	03-02 -063	42	067	624 OAKLAND RD	MIFFLINTOWN	PA	17059	TROYER STEVEN D & EMMA S	624 OAKLAND RD	MIFFLINTOWN	PA	17059	JUNIATA	25440	FAYETTE	070101	701.0100	38729.5724	34560	3320	37880	1	2023-06-20	1	1	1992	112	2352	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	173.5790	194.9848	183.5892	001	R	10.0800	PERSON		0	0					2026.2
3-16-77	03-16 -077	42	067	184 RED BANK RD	ALLENTOWN	PA	18104	LEONARD BRUCE E &	214 WOLF DR	ALLENTOWN	PA	18104	JUNIATA	25440	FAYETTE	070101	701.0100	2997.6337	15480	1950	17430	1	2017-12-11	1	1	1978	1	1120	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	224.8220	228.2546	226.9119	001	R	0.6899	PERSON		0	0					2026.2
17-1A-24	17-01A-024	42	067	104 MEXICO HEIGHTS RD	MIFFLINTOWN	PA	17059	DAVIS AMANDA E	104 MEXICO HEIGHTS RD	MIFFLINTOWN	PA	17059	JUNIATA	80568	WALKER	070300	703	5514.7879	26720	2200	28920	1	2020-06-03	1	1	2004	1	1456	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	145.0643	151.6940	148.4971	001	R	1.3899	PERSON		0	0					2026.2
17-5-14	17-05 -014	42	067	8141 WILLIAM PENN HWY	MIFFLINTOWN	PA	17059	FRYMOYER MARLIN R &	8141 WILLIAM PENN HWY	MIFFLINTOWN	PA	17059	JUNIATA	80568	WALKER	070300	703	4050.3790	12540	3000	15540	1	2010-05-03	1	1	1000	2	1320	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	168.2926	170.8147	169.5780	001	R	1	PERSON		0	0					2026.2
15-3A-11	15-03A-011	42	067	11508 RT 333	PORT ROYAL	PA	17082	HECKERT GABRIEL R	11508 RT 333	PORT ROYAL	PA	17082	JUNIATA	77824	TURBETT	070202	702.0200	5282.8476	6230	2500	8730	55000	2009-04-23	1	1	1928	2	384	42067C	2025-12-21	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	129.7124	141.2135	134.3770	001	R	1.3400	PERSON		424	0236					2026.2
9-12-24	09-12 -024	42	067	20266 RT 35 S	MIFFLIN	PA	17058	IMES DONALD ET UX	20266 RT 35 S	MIFFLIN	PA	17058	JUNIATA	49392	MILFORD	070202	702.0200	4822.1400	20140	2090	22230	1	2020-07-14	1	1	1985	1	1344	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	149.9956	155.7512	152.2246	001	R	1.3500	PERSON		0	0					2026.2
9-16A-40	09-16A-040	42	067	14 THOMAS ST	MIFFLINTOWN	PA	17059	GREGG MICHAEL S &	14 THOMAS ST	MIFFLINTOWN	PA	17059	JUNIATA	49392	MILFORD	070202	702.0200	2318.8612	25490	3000	28490	124000	2016-06-28	1	1	1920	2	1200	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	147.9091	151.5154	150.3833	001	R	0.4800	PERSON		0	0					2026.2
13-3-67	13-03 -067	42	067	522 KLINGER HOLLOW RD	LIVERPOOL	PA	17045	HESS TODD E	522 KLINGER HOLLOW RD	LIVERPOOL	PA	17045	JUNIATA	75536	SUSQUEHANNA	070400	704	19460.0703	18760	2890	21650	1	2002-10-02	1	1	2009	2	2508	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	167.0249	179.0707	174.4304	001	R	5.4400	PERSON		304	0264					2026.2
6-28-22	06-28 -022	42	067	990 BARTON HOLLOW RD	EAST WATERFORD	PA	17021	HENRY SCOTT A &	990 BARTON HOLLOW RD	EAST WATERFORD	PA	17021	JUNIATA	40752	LACK	070201	702.0100	118655.4914	11430	2900	14330	169900	2005-07-08	1	1	1970	1	704	42067C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	236.5988	311.7525	272.0201	001	F	28.9000	PERSON		357	0605					2026.2