Saved query 6d6a1fb637e5d48b

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

40/80

Live SQL

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

177,335 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	saleamt	saledate	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	taxacres	ownertype	naicscode	legaldesc	book	page	parceltype	accesstype	placename	placetype	lrversion
08009-0327---000	42	133	L-0076 SYCAMORE LN	PA		CULBERT DANIEL J & ANGELA S II	706 WASHINGTON AVE	HANOVER	PA	17331	YORK	32448	HANOVER	022300	223	1261.9008	36200	36200	36200	0	52000	2018-08-17	42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	179.9401	182.3340	181.0932	RO	0.3100	PERSON		THIS PROPERTY SHOULD NOW BE CAR…	6410	179					2026.2
08009-0107---000	42	133	304 DILLER RD	PA		RECK CATHY H	304 DILLER RD	HANOVER	PA	17331	YORK	32448	HANOVER	022300	223	835.6263	178500	178500	178500	0	155500	2019-02-15	42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	181.9429	182.8726	182.5862	R	0.2100	PERSON		THIS PROPERTY SHOULD NOW BE CAR…	6463	244					2026.2
08009-0336---000	42	133	502 POPLAR ST	PA	L-0009	KUHN KOREY E	502 POPLAR ST	HANOVER	PA	17331	YORK	32448	HANOVER	022300	223	871.7247	152500	152500	152500	0	127500	2006-06-09	42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	178.5920	179.5884	179.3064	R	0.2300	PERSON			4448	346					2026.2
08009-0328---000	42	133	L-0001 SYCAMORE LN	PA		LAWN BRIAN GREGORY & CINDY MAY	4 SYCAMORE LN	HANOVER	PA	17331	YORK	32448	HANOVER	022300	223	693.2668	163400	163400	163400	0	146900	2018-08-01	42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	179.4033	181.3218	180.2774	R	0.1700	PERSON		THIS PROPERTY SHOULD NOW BE CAR…	6404	209					2026.2
36L07-0026B--000	42	133	405 HARRISBURG ST	PA		SHANK IVAN W & ROSELLA P	403 HARRISBURG ST	EAST BERLIN	PA	17316	YORK	81352	WASHINGTON	020321	203.2100	77497.8335	148300	148300	148300	0	1	2017-02-23	42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	132.6510	136.6600	134.9863	A	19.6600	PERSON		PARCEL 2	6237	296					2026.2
36K05-0001---000	42	133	1925 FISH & GAME ROAD	PA	L-0005	ROBINSON KENNETH E & BARBARA A	1925 FISH AND GAME RD	EAST BERLIN	PA	17316	YORK	81352	WASHINGTON	020321	203.2100	38032.7858	388000	388000	388000	0	43900		42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	162.6410	173.1390	166.1965	R	9.6600	PERSON			1071	275					2026.2
04L13-0004A--000	42	133	1429 CARLISLE PIKE	PA		SHANK JACOB M & ELSIE M	475 FLICKINGER RD	HANOVER	PA	17331	YORK	58888	PENN	021802	218.0200	210200.3663	50600	50600	50600	0	205000	2005-05-23	42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	164.4179	178.1719	168.2777	V	53.0800	PERSON		ROW 5431-739	3973	100					2026.2
41L17-0012---000	42	133	865 OLD WESTMINSTER RD	PA		BECKER FAMILY TRUST	863 OLD WESTMINSTER RD	HANOVER	PA	17331	YORK	83440	WEST MANHEIM	022404	224.0400	183216.2651	605300	605300	605300	0	1	2024-07-11	42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	208.2640	238.3940	227.0992	A	46.0100	TRUST		CLOSURE ERRORS, TR 1 40.616 A…	7226	364					2026.2
36L06-0028---000	42	133	775 RIFE RD	PA		HOLMES REDA L & WILLIAM S	775 RIFE RD	EAST BERLIN	PA	17316	YORK	81352	WASHINGTON	020321	203.2100	3598.0599	151700	151700	151700	0	192000	2021-04-07	42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	139.0959	142.2501	140.8784	RT	0.9700	PERSON		PREVIOUSLY CARRIED IN YORK COUN…	6774	273					2026.2
08009-0083---000	42	133	307 DILLER RD	PA		STOUGH THEODORE A JR	307 DILLER RD	HANOVER	PA	17331	YORK	32448	HANOVER	022300	223	853.5218	152200	152200	152200	0	1		42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	182.6181	183.4299	182.9728	R	0.2100	PERSON		THIS PROPERTY SHOULD NOW BE CAR…	248	275					2026.2
41L17-0002---000	42	133	945 OLD WESTMINSTER RD	PA		HUMBERT THOMAS M	609 MAYBERRY DR	MC KINNEY	TX	75070	YORK	83440	WEST MANHEIM	022404	224.0400	16370.5095	342700	342700	342700	0	65000		42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	215.5228	228.7205	222.7437	R	4.2800	PERSON		AC PLOTTED FROM DEED DESCRIPTION	997	227					2026.2
04L12-0035I--000	42	133	15 OAK HILL DR	PA		AUMEN THOMAS M & ROSE M	15 OAK HILL DR	HANOVER	PA	17331	YORK	58888	PENN	021802	218.0200	2467.4995	206900	206900	206900	0	114500		42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	212.2350	215.4463	213.3778	R	0.5400	PERSON			582	1114					2026.2
04L12-0022---000	42	133	PIGEON HILL RD	PA		BANGE GLENN E & DORIS J	1281 HONDA RD	HANOVER	PA	17331	YORK	58888	PENN	021802	218.0200	154142.5447	3400	3400	3400	0	1	2012-07-09	42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	252.5549	316.2620	291.7322	V	39.6400	PERSON			5723	70					2026.2
04L12-0035J--000	42	133	1585 ABBOTTSTOWN PIKE	PA		STAUB ANTHONY M & YVONNE M	1585 ABBOTTSTOWN PIKE	HANOVER	PA	17331	YORK	58888	PENN	021802	218.0200	12065.1172	312000	312000	312000	0	1	2002-12-10	42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	203.4778	217.2535	209.6957	R	2.9800	PERSON			2904	179					2026.2
08L13-0058---000	42	133	RADIO ROAD	PA	L-0009	NEIDERER JOANN L	125 RADIO RD	HANOVER	PA	17331	YORK	58888	PENN	021802	218.0200	2424.0370	114100	114100	114100	0	105000		42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	172.1052	173.0835	172.5526	CL	0.4800	PERSON			1739	317					2026.2
36K05-0018A--000	42	133	1885 FISH & GAME ROAD	PA		SPAHR RANDY L	1885 FISH & GAME RD	EAST BERLIN	PA	17316	YORK	81352	WASHINGTON	020321	203.2100	26929.2924	258400	258400	258400	0	1		42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	159.5410	165.1950	162.3151	R	7.1200	PERSON			374	638					2026.2
36K04-0043---000	42	133	HARLACHER ROAD	PA		MYERS MICHAEL E & SHARON E	PO BOX 606	EAST BERLIN	PA	17316	YORK	81352	WASHINGTON	020321	203.2100	10051.4625	13500	13500	13500	0	500		42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	136.1770	141.3276	138.4940	L2	2.4500	PERSON			415	1083					2026.2
36L06-0009---000	42	133	865 RIFE RD	PA		KREIDER MELVIN L & LAVONE D	865 RIFE RD	EAST BERLIN	PA	17316	YORK	81352	WASHINGTON	020321	203.2100	141468.7049	151100	151100	151100	0	190000		42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	140.0310	159.8649	146.2962	A	33.6100	PERSON			668	148					2026.2
23J02-0005---000	42	133	730 COUNTY LINE RD	PA		SMOKER JEFFREY D & TAMELA J	906 HAMILTON RD	COCHRANVILLE	PA	19330	YORK	27480	FRANKLIN	020410	204.1000	507710.8750	267500	267500	267500	0	1350000	2024-11-06	42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				A	128.1200	PERSON		D.6505-140 PENNDOT RIGHT OF WAY…	7266	701					2026.2
01002-0006---000	42	133	200 E WATER ST	PA		HANOVER COUNTRY CLUB	200 E WATER ST	ABBOTTSTOWN	PA	17301	YORK	57872	PARADISE	020510	205.1000	476671.9315	1713200	1713200	1713200	0	16000		42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				CY	140.2800	NONPROFIT			235	92			HANOVER COUNTRY CLUB	SOCIAL_OR_COMMUNITY_SERVICE	2026.2
00ADM-YORK---000	42	133		PA							YORK	58888	PENN	021802	218.0200	32318.2007							42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	165.0420	171.9539	168.7833				7225	ROW 5449-666	4864	337			CHIPOTLE MEXICAN GRILL	RESTAURANT	2026.2
00ADM-YORK---000	42	133		PA							YORK	81352	WASHINGTON	020321	203.2100	13410.2311							42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	158.5939	164.8710	162.1312					PART OF 36L06-0002	1609	302					2026.2
00ADM-YORK---000	42	133		PA							YORK	58888	PENN	021801	218.0100	290227.7328							42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	168.8569	187.2940	176.9535					16.48 AC. OF TR 1 IN ADAMS COUN…	6134	452					2026.2
00ADM-YORK---000	42	133		PA							YORK	57872	PARADISE	020510	205.1000	158911.1961							42133C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	197.8750	251.5939	229.2311					CARRIED IN YORK CONY	6104	350					2026.2
00ADM-YORK---000	42	133		PA							YORK	57872	PARADISE	020510	205.1000	1199.5707							42133C	2025-12-21	AE	FLOODWAY	128.9320	130.8091	129.6975								GOVT LOCAL	CLOSED	YORK COUNTY AGRICULTURAL EASEME…	AGRICULTURAL EASEMENT	2026.2