Saved query 0a2684a3ac806c00

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

41/80

Live SQL

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

46,694 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	saleamt	saledate	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	taxacres	ownertype	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	lrversion
23J03-0004---000	42	001	160 LATIMORE VALLEY RD		PA		CHASE SARA JEANNE	518 CARLISLE ST	HANOVER	PA	17331	ADAMS	41672	LATIMORE	030101	301.0100	339001.6515	354100	354100	354100	1	2014-02-11	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	151.0464	166.7707	157.3508	A	87.2700	PERSON	PARCEL 1	5915	559	GOVT LOCAL	CLOSED		ADAMS COUNTY AGRICULTURAL EASEM…	AGRICULTURAL EASEMENT	2026.2
07G07-0034---000	42	001	1279 STONE JUG RD		PA		ADAMIK THERESA A	1279 STONE JUG RD	ASPERS	PA	17304	ADAMS	10456	BUTLER	030500	305	531869.0946	309400	309400	309400	1	2017-06-21	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				A	134.9000	PERSON	SURVEY 2011, COMBINED W/07G07-0…	6274	187	NGO	CLOSED	OTHER	2011-05	AGRICULTURAL EASEMENT	2026.2
27008-0028A--000	42	001	12 E MYRTLE ST		PA	L-0002	DUVALL LINDA	12 E MYRTLE ST	LITTLESTOWN	PA	17340	ADAMS	43944	LITTLESTOWN	031300	313	367.1726	164000	164000	164000	149000	2013-05-15	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	181.6939	182.7255	182.3305	R	0.0900	PERSON	LOT 2	5830	732						2026.2
36105-0070---000	42	001	7 CURTIS DR UNIT M-0539		PA		LARIVIERE TRAVIS A	14 HUNTER LN	ENFIELD	CT	06082	ADAMS	63616	READING	030103	301.0299	2265.9516	263400	263400	263400	1	2013-11-07	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	168.2449	175.8816	172.1690	R	0.5600	PERSON	24,389.76 SF	5891	515						2026.2
04L12-0112---000	42	001	30 EL GRECO ST		PA	L-0012	BAXTER WILLIAM MARK & LORI KAY	30 EL GRECO ST	HANOVER	PA	17331	ADAMS	05880	BERWICK	030801	308.0100	7095.8722	338900	338900	338900	345000	2006-08-04	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	206.1706	218.1349	212.2440	R	1.7800	PERSON		4520	243						2026.2
36K08-0023---000	42	001	444 BROWNS DAM RD		PA		SHEMON MICHAEL L	444 BROWNS DAM RD	NEW OXFORD	PA	17350	ADAMS	63616	READING	030104	301.0400	326736.8819	457300	457300	457300	1	2021-01-22	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	128.8009	152.9250	141.6161	A	84.3100	PERSON	CLOSURE ERROR, AC. PLOTTED FRO…	6732	637						2026.2
27014-0057---000	42	001	274 S COLUMBUS AVE UNIT L-0147		PA		TOMPKINS IVAN C & CAHTERINE E	274 S COLUMBUS AVE	LITTLESTOWN	PA	17340	ADAMS	43944	LITTLESTOWN	031300	313	1204.2769	167400	167400	167400	1	2015-04-02	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	185.5657	187.0562	186.2506	R	0.2800	PERSON		6019	414						2026.2
35K12-0009---000	42	001	65 SHANK RD		PA		JOEANNA LP	160 RAM DR	HANOVER	PA	17331	ADAMS	57472	OXFORD	030902	309.0200	329622.5861	4078000	4078000	4078000	1	2019-08-22	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	156.5662	183.7142	169.1735	CL	101.9500	BUSINESS	SURVEY 2021	6522	317						2026.2
35K12-0070---000	42	001	1202 HANOVER ST UNIT LE-0011		PA		VULCAN LANDS INC	PO BOX 4900	SCOTTSDALE	AZ	85261	ADAMS	57472	OXFORD	030902	309.0200	630297.8861	664700	664700	664700	2850000	2024-08-12	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				AO	157.3100	BUSINESS	LOTS E-11 & E12	7237	60				FOR THE LOVE OF A VETERAN INC.	CIVIC_ORGANIZATION	2026.2
09E17-0094A--000	42	001	LOT ADDITION	L-0002	PA		RILEY LINDSEY W	790 MARSH CREEK RD	GETTYSBURG	PA	17325	ADAMS	17640	CUMBERLAND	031402	314.0200	7077.3294	48000	48000	48000	1		42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	144.7551	147.6703	146.2713	L2	1.7300	PERSON		2055	265						2026.2
09F13-0150---000	42	001	799 BALTIMORE PIKE		PA		EVERGREEN CEMETERY ASSOCIATION	799 BALTIMORE ST	GETTYSBURG	PA	17325	ADAMS	17640	CUMBERLAND	031402	314.0200	112409.7686	872700	872700	872700			42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	168.1137	191.5120	181.2274	CX	29.1200	NONPROFIT	7 ADDITIONAL DEEDS 73-466, 73-4…	184	520				GETTYSBURG BATTLEFIELD HISTORIC…	HISTORIC_SITE	2026.2
20E12-0119---000	42	001	760 KNOXLYN RD		PA		STONE LUCILLE S	PO BOX 583	ARENDTSVILLE	PA	17303	ADAMS	34424	HIGHLAND	031600	316	20279.7480	159400	159400	159400	1	2019-01-31	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	165.4339	180.6762	172.7883	RT	5.1000	PERSON		6458	767						2026.2
43034-0053---000	42	001	+ WINTER TRL E-0023		PA		KNOTT STEVE R ET AL	34 WINTER TRL	FAIRFIELD	PA	17320	ADAMS	11472	CARROLL VALLEY	031600	316	2652.6382	258900	258900	258900	141000	2003-08-20	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	228.5526	245.0968	236.1486	R	1.4000	PERSON		3256	198						2026.2
38H11-0001---000	42	001	1731 HUNTERSTOWN RD		PA		KESTREL ACQUISITION LLC	8403 COLESVILLE RD SUITE 915	SILVER SPRING	MD	20910	ADAMS	74680	STRABAN	030600	306	1186128.1655	17304500	17304500	17304500	10	2018-06-06	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				I	298.9100	BUSINESS	14 TRACTS, AC. PLOTTED FROM DE…	6385	180				NRG ENERGY	PUBLIC_UTILITY	2026.2
06009-0040A--000	42	001		UNASSIGNED	PA		S & A CUSTOM BUILT HOMES INC	2121 OLD GATESBURG RD #200	STATE COLLEGE	PA	16803	ADAMS	07560	BONNEAUVILLE	030700	307	81256.6665	879800	879800	879800			42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	186.8111	196.1933	190.4363	CL	14.4900	BUSINESS		3167	98						2026.2
20D13-0050---000	42	001	1675 KNOXLYN RD		PA		RANDLES HOLLY	1675 KNOXLYN RD	GETTYSBURG	PA	17325	ADAMS	34424	HIGHLAND	031600	316	2579.5706	211800	211800	211800	355000	2023-10-03	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	184.6231	191.5337	188.2148	R	0.6700	PERSON		7142	47						2026.2
34004-0054---000	42	001	321 W LINCOLN WAY W		PA		ANDES KEITH A	321 LINCOLNWAY WEST	NEW OXFORD	PA	17350	ADAMS	53920	NEW OXFORD	030901	309.0100	988.8404	189700	189700	189700	1	2006-06-20	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	164.4026	165.7736	165.1352	R	0.2300	PERSON		4461	123						2026.2
43022-0212---000	42	001	7 LEE TRL UNIT W-0322		PA		JOHNSTON CRAIG S & DEBORAH B	101 JANET TRL	FAIRFIELD	PA	17320	ADAMS	11472	CARROLL VALLEY	031600	316	1870.6256	4500	4500	4500	4800		42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	261.4826	270.8370	265.9358	L1	0.6500	PERSON		1038	151						2026.2
36102-0042---000	42	001	15 SHERMAN DR UNIT M-0431		PA		LAUGHMAN DARWIN J & DONNA	15 SHERMAN DR	EAST BERLIN	PA	17316	ADAMS	63616	READING	030103	301.0299	1458.6737	185400	185400	185400	89500		42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	144.8917	148.5597	146.8810	R	0.3600	PERSON		1847	153						2026.2
05002-0007---000	42	001	350 E YORK ST		PA		EYLER ROY K	350 E YORK ST	BIGLERVILLE	PA	17307	ADAMS	06296	BIGLERVILLE	030500	305	1283.6740	135200	135200	135200	1		42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	195.7617	198.1633	197.1446	RC	0.2600	PERSON		364	827						2026.2
27008-0319---000	42	001	120 LUMBER ST		PA		GREEN DAVID R & CHRISTINA J	120 LUMBER ST	LITTLESTOWN	PA	17340	ADAMS	43944	LITTLESTOWN	031300	313	451.5608	124000	124000	124000	59900		42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	192.2375	193.7949	193.2197	R	0.1000	PERSON		866	324						2026.2
27J17-0054---000	42	001	635 HANOVER PIKE		PA		MAYBERRY AT MASON DIXON LLC	126 ONYX RD	NEW OXFORD	PA	17350	ADAMS	43944	LITTLESTOWN	031300	313	431904.6716	907200	907200	907200	1	2023-05-10	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				CL	107.2100	BUSINESS	DEED 7107-122 PENN DOT R/W 0.22…	7090	770						2026.2
40I07-0044---000	42	001	775 FIVE POINTS RD		PA		HILLANDALE GETTYSBURG LP	3910 OXFORD RD	GETTYSBURG	PA	17325	ADAMS	78160	TYRONE	030200	302	983542.0219	12926700	12926700	12926700	1	2021-06-02	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				A	248.2200	BUSINESS	COMBINED W/40I07-0049	7149	12						2026.2
22H04-0018B--000	42	001	1117 FARM VIEW RD		PA		BONNIE BRAE FRUIT FARMS INC	1230 IDAVILLE-YORK SPRINGS RD	GARDNERS	PA	17324	ADAMS	36424	HUNTINGTON	030200	302	858794.1374	363300	363300	363300	650000	2012-01-09	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				A	216.7000	BUSINESS	COMBINED WITH H4-18A	5665	474						2026.2
40G04-0093---000	42	001	OLD CARLISLE ROAD		PA		BEAR MOUNTAIN ORCHARDS INC	1415 POTATO RD	ASPERS	PA	17304	ADAMS	78160	TYRONE	030200	302	549664.0548	156900	156900	156900	750000	2022-07-15	42001C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				AO	142.6500	BUSINESS	NEW SURVEY 2022	6988	329						2026.2