Saved query 1e7861b4a27e2f87

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

42/80

Live SQL

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

24,233 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	book	page	taxyear
10-3-5	10-03 -005	42	109	10651 MOUNTAIN RD	RICHFIELD	PA	17086	STIMELING BENJAMIN L	10651 MOUNTAIN RD	RICHFIELD	PA	17086	SNYDER	83808	WEST PERRY	070400	704	183139.9964	21300	11030	32330	1	2013-05-28	1	1	1983	1	1232	42109C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	228.0551	242.5503	234.7810	001	F	46.2299	PERSON	0	0
10-3-10	10-03 -010	42	109	36165 RT 35 N	RICHFIELD	PA	17086	MARTIN CURTIS R &	36165 RT 35 N	RICHFIELD	PA	17086	SNYDER	83808	WEST PERRY	070400	704	131655.3090	11110	11660	22770	430000	2015-11-24	1	1	1000	2	720	42109C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	214.9760	235.7972	224.7857	001	F	31.5200	PERSON	2015	4404
10-3-11	10-03 -011	42	109	36373 RT 35 N	RICHFIELD	PA	17086	DRESSLER DIANE IRREVOCABLE GRAN…	36373 RT 35 N	RICHFIELD	PA	17086	SNYDER	83808	WEST PERRY	070400	704	7320.2865	14200	3290	17490	1	2021-10-27	1	1	1955	1	1384	42109C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	216.5691	220.9511	217.8282	001	R	1.9500	TRUST	0	0
10-4-8	10-04 -008	42	109	79 MAIN ST	RICHFIELD	PA	17086	WYNN RYAN N &	79 MAIN ST	RICHFIELD	PA	17086	SNYDER	83808	WEST PERRY	070400	704	51568.8793	19950	6030	25980	126000	2003-11-13	1	1	1000	2	1925	42109C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	195.9575	206.0039	198.7646	002	R	13.1000	PERSON	327	508
10-3-12	10-03 -012	42	109	36421 RT 35 N	PORT ROYAL	PA	17082	STROUP MATTHEW L & KATHY M	8283 GRONINGER VALLEY RD	PORT ROYAL	PA	17082	SNYDER	83808	WEST PERRY	070400	704	1481.6463	16360	2090	18450	1	2023-07-10	1	1	1956	1	1416	42109C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	217.5260	221.0548	219.3454	001	R	0.3400	PERSON	0	0
10-9B-51	10-09B-051	42	109	243 CHURCH ST	RICHFIELD	PA	17086	HOFFMAN CAROL KANTZ	783 LITTLE EVENDALE RD	RICHFIELD	PA	17086	SNYDER	83808	WEST PERRY	070400	704	21781.6116	11010	4750	15760	105000	2008-11-08	1	1	1939	2	896	42109C	2025-12-21	AE		191.5149	199.2475	193.6588	001	R	4.4900	PERSON	269	0249
10-4-4	10-04 -004	42	109	37871 RT 35 N	LITITZ	PA	17543	WENGER L EUGENE & MARY JANE	150 WISSER RD	LITITZ	PA	17543	SNYDER	83808	WEST PERRY	070400	704	136170.3274	11100	12460	23560	475000	2022-06-22	1	1	1000	2	780	42109C	2025-12-21	AE		198.7076	206.7960	201.4864	001	F	34.2100	PERSON	0	0
10-9-1	10-09 -001	42	109	223 MAIN ST	RICHFIELD	PA	17086	REGESTER JOHN S	P O BOX 116	RICHFIELD	PA	17086	SNYDER	83808	WEST PERRY	070400	704	36206.3938	40860	6010	46870	1		1	1	1970	1	2484	42109C	2025-12-21	AE		195.3961	198.4435	196.8808	001	R	9.6000	PERSON	109	343
10-9A-21	10-09A-021	42	109	183 WATER ST	RICHFIELD	PA	17086	WILLOW JOHN R	BOX 62	RICHFIELD	PA	17086	SNYDER	83808	WEST PERRY	070400	704	10659.4950	11560	2760	14320	24000		1	1	1000	2	1080	42109C	2025-12-21	AE		193.9502	196.9174	195.2727	001	R	0	PERSON	116	544
13-7-105	13-07 -105	42	109	575 FRYMOYER RD	MOUNT PLEASANT MILLS	PA	17853	SPRIGGLE JUDY H ET AL	1870 ARBOGAST CHURCH RD	MOUNT PLEASANT MILLS	PA	17853	SNYDER	59504	PERRY	070400	704	8044.6237	10920	1570	12490	2000	2003-01-15	1	1				42109C	2025-12-21	A		151.2527	156.7552	152.8202	074	R	0	PERSON	308	1024
10-3-45	10-03 -045	42	109	36333 RT 35 N	RICHFIELD	PA	17086	PETERS PAUL R &	36333 RT 35 N	RICHFIELD	PA	17086	SNYDER	83808	WEST PERRY	070400	704	5574.0390	10950	3170	14120	1	2019-07-03	1	1	1960	1	1288			—		217.0393	220.5063	218.3124	001	R	1.5600	PERSON	0	0
10-9A-20	10-09A-020	42	109	WATER ST	RICHFIELD	PA	17086	WILLOW JOHN R & DAWN D	PO BOX 62	RICHFIELD	PA	17086	SNYDER	83808	WEST PERRY	070400	704	9765.7510	3290	4020	7310	6000	2022-04-12	1	1				42109C	2025-12-21	AE		194.0772	197.0468	195.4317	019	R	0	PERSON	0	0
10-3-44	10-03 -044	42	109	GRAYBILL LN	HARLEYSVILLE	PA	19438	JOHNSON R WALTON &	228 KINSEY RD	HARLEYSVILLE	PA	19438	SNYDER	83808	WEST PERRY	070400	704	79707.6676		2400	2400	48000	2021-08-26						42109C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	244.3262	265.5997	254.8849	091	F	24	PERSON	0	0
3-16-91	03-16 -091	42	109	SORREL ACRES LN	HARRISBURG	PA	17112	BENNER NASON J &	7720 FISHING CREEK VALLEY RD	HARRISBURG	PA	17112	SNYDER	83808	WEST PERRY	070400	704	156035.6984		3750	3750	188000	2006-09-15						42109C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	293.9446	508.0190	376.8041	091	F	50	PERSON	379	461
10-3-72	10-03 -072	42	109	3397 MIDDLE RD	RICHFIELD	PA	17086	HOFFMAN RICKY R	3397 MIDDLE RD	RICHFIELD	PA	17086	SNYDER	83808	WEST PERRY			16403.0530	50210	4040	54250	1		1	1	1987	2	3694			—		228.1761	235.0934	231.8096	001	R	4.0700	PERSON	137	348
3-16-54	03-16 -054	42	109	SORREL ACRES LN	MCALISTERVILLE	PA	17049	SMITH FAYE S	1365 MAIN ST	MCALISTERVILLE	PA	17049	SNYDER	83808	WEST PERRY	070400	704	192829.1808		3750	3750	1							42109C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	293.9624	496.4310	361.5376	091	F	50	PERSON	105	481
10-9B-58	10-09B-058	42	109	WATER ST	RICHFIELD	PA	17086	WILLOW JOHN R &	PO BOX 62	RICHFIELD	PA	17086	SNYDER	83808	WEST PERRY			5415.4147		1440	1440	2825	2008-10-28						42109C	2025-12-21	AE		193.8459	196.9405	195.1551	091	R	0	PERSON	416	860
11-01-032		42	109			PA							SNYDER	49016	MIDDLECREEK	070200	702	2191.2388						1	1		1				—		141.9670	143.9899	142.6947							2024
10-03-177		42	109			PA							SNYDER	48960	MIDDLEBURG	070300	703	569.6952						2	1		1				—		158.2865	161.5251	159.7917							2024
12-02-117		42	109			PA							SNYDER	50488	MONROE	070100	701	5234.3272						2	1		1				—		224.5630	231.3290	229.3358							2024
10-01-253		42	109			PA							SNYDER	48960	MIDDLEBURG	070300	703	1014.6127						1	1		1				—		154.1564	159.1742	155.5506							2024
10-01-053		42	109			PA							SNYDER	48960	MIDDLEBURG	070300	703	895.7812						1	1		1				—		151.0322	156.9051	154.8536							2024
10-03-254		42	109			PA							SNYDER	48960	MIDDLEBURG	070300	703	1788.2194						1	1		1				—		164.0771	167.3667	165.7601							2024
13-06-089		42	109			PA							SNYDER	58864	PENN	070200	702	14714.2020						2	1		1				—		169.0746	220.3743	195.8404							2024
10-02-006		42	109			PA							SNYDER	48960	MIDDLEBURG	070300	703	831.5397						1	1		2				—		154.2189	156.3511	155.1514							2024