Saved query fbd2b4fb6407e39e

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

33,249 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	zoningcode	taxacres	ownertype	naicscode	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxdistrict
7-3794	42	035		MCELHATTAN	PA	17748	SARATOGA PARTNERS LP ET AL	PO BOX 400	MCELHATTAN	PA	17748	CLINTON	12640	CHAPMAN	030100	301	212955.5276		3200	3200			42035C	2025-12-21	AE	FLOODWAY		185.5829	264.9570	209.6919	AG/FOR	52.6180	GOVERNMENT		GOVT STATE	RESTRICTED	OTHER	BUCKTAIL STATE PARK	STATE PARK	2026.2	7
6-3207	42	035	200 S HANNA ST	LOCK HAVEN	PA	17745	SHIV OF LOCK HAVEN LLC	200 S HANNA ST	LOCK HAVEN	PA	17745	CLINTON	11640	CASTANEA	030500	305	3746.3595	219300	36400	255700	1	1	42035C	2025-12-21	AH		552.9000	168.6392	171.9763	170.6902	C	0.9260	BUSINESS	457				SUNOCO	GAS_STATION	2026.2	6
9-20608-20	42	035	2557 RAUCHTOWN RD	HARRISBURG	PA	17120	DEPT OF ENVIRONMENTAL RESOURCE	PO BOX 1467	HARRISBURG	PA	17120	CLINTON	16976	CRAWFORD	030900	309	4217770.8419	177400	9187500	9364900	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD						1042.1790	GOVERNMENT		GOVT STATE	RESTRICTED	OTHER	TIADAGHTON STATE FOREST	STATE RESOURCE MANAGEMENT AREA	2026.2	9
36-17642	42	035	15 LENAPE TRL	LOCK HAVEN	PA	17745	JACOBS ERIC T	15 LENAPE TRL	LOCK HAVEN	PA	17745	CLINTON	86448	WOODWARD	030300	303	1056.7137	86700	18300	105000	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		183.0060	183.6176	183.4234		0.2610	PERSON	5313				EJ RENTALS HOUSING UNITS	REAL_ESTATE_SERVICE	2026.2	36
3-26661	42	035	2332 EAGLE VALLEY RD	MILL HALL	PA	17751	EDWARDS WILLIAM J &	2332 EAGLE VALLEY RD	MILL HALL	PA	17751	CLINTON	03912	BALD EAGLE	030200	302	18636.3776	1160700	72000	1232700	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		191.5012	195.6202	193.7365		4.6050	PERSON	531130				CENTRAL STORAGE	SELF-STORAGE FACILITY	2026.2	3
14-20602-12	42	035	85 DONUT HOLE LN	HARRISBURG	PA	17120	DEPT OF ENVIRONMENTAL RESOURCE	PO BOX 1467	HARRISBURG	PA	17120	CLINTON	31680	GRUGAN	030300	303	11224.2446		19288800	19288800			42035C	2025-12-21	A			178.1369	196.4162	185.9865	RF	2.7730	GOVERNMENT		GOVT UNKNOWN	RESTRICTED	VI	SPROUL STATE FOREST - BUCKTAIL …	STATE RESOURCE MANAGEMENT AREA	2026.2	14
22-10843-485	42	035	705 W THIRD ST	LOCK HAVEN	PA	17745	ROBB WILLIAM D & JUDITH A	705 W 3RD ST	LOCK HAVEN	PA	17745	CLINTON	44128	LOCK HAVEN	030701	307.0100	239.8949	91800	17200	109000	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		194.3598	198.4291	197.0371	RL	0.0590	PERSON							2026.2	22
30-28775	42	035	164 WHITETAIL CIR	MILL HALL	PA	17751	ROTHROCK AMY J	164 WHITETAIL CIRCLE	MILL HALL	PA	17751	CLINTON	62152	PORTER	030800	308	1824.0175	223100	39400	262500	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		267.0798	273.0664	270.4220		0.4280	PERSON							2026.2	30
19-9262-62	42	035	368 E MAIN ST	LOCK HAVEN	PA	17745	PELLACORE DANIEL A	368 E MAIN ST	LOCK HAVEN	PA	17745	CLINTON	44128	LOCK HAVEN	030600	306	231.9178	49900	12900	62800	1	1	42035C	2025-12-21	X	AREA WITH REDUCED FLOOD RISK DU…		169.1424	169.4910	169.3109	RM	0.0570	PERSON							2026.2	19
21-25985	42	035	8 SPRUCE DR	LOCK HAVEN	PA	17745	WADSWORTH STEVEN & ALICIA	8 SPRUCE DR	LOCK HAVEN	PA	17745	CLINTON	44128	LOCK HAVEN	030701	307.0100	2727.9969	170200	31700	201900	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		262.5907	279.9553	268.2863	RS	0.6740	PERSON							2026.2	21
33-16663	42	035	112 THIRD ST	WILLIAMSPORT	PA	17701	RENOVO PROPERTIES LLC	333 ROSE ST	WILLIAMSPORT	PA	17701	CLINTON	64200	RENOVO	030100	301	3413.0701	362000	23800	385800	1	1	42035C	2025-12-21	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…		203.7301	204.5742	204.2061		0.8430	BUSINESS					GOODWILL	SECOND_HAND_STORE	2026.2	33
35-20618-70	42	035		HARRISBURG	PA	17120	DEPT OF ENVIRONMENTAL RESOURCE	PO BOX 1467	HARRISBURG	PA	17120	CLINTON	81728	WAYNE	030500	305	2361920.0907		7321700	7321700			42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD					O/R	583.6029	GOVERNMENT		GOVT STATE	RESTRICTED	OTHER	TIADAGHTON STATE FOREST	STATE RESOURCE MANAGEMENT AREA	2026.2	35
25-12571	42	035	38 W MAIN ST	LOGANTON	PA	17747	KERSTETTER NEIL D & SHANNA M	38 W MAIN ST	LOGANTON	PA	17747	CLINTON	44400	LOGANTON	030900	309	978.7954	68800	16300	85100	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		395.4386	398.2932	396.7008	R-4	0.2420	PERSON							2026.2	25
7-3249-5	42	035	520 CENTRAL AVE	RENOVO	PA	17764	HEPFER KEVIN L	520 CENTRAL AVE	RENOVO	PA	17764	CLINTON	12640	CHAPMAN	030100	301	523.3603	53800	12200	66000	1	1	42035C	2025-12-21	AE			197.2553	198.6304	198.0627	RESIDENTIAL	0.1290	PERSON							2026.2	7
2-290-23	42	035	185 ROSS ST	READING	PA	19610	MAFFETT JEFFRY L	125 LUCINDA LN	READING	PA	19610	CLINTON	03632	AVIS	030400	304	614.3815	57700	20200	77900	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		196.7247	198.2782	197.5420		0.1520	PERSON							2026.2	2
14-20602-9	42	035	85 DONUT HOLE LN	HARRISBURG	PA	17120	DEPT OF ENVIRONMENTAL RESOURCE	PO BOX 1467	HARRISBURG	PA	17120	CLINTON	31680	GRUGAN	030300	303	5369596.0513		19288800	19288800			42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD					RF	1326.7490	GOVERNMENT		GOVT STATE	RESTRICTED	OTHER	SPROUL STATE FOREST	STATE RESOURCE MANAGEMENT AREA	2026.2	14
35-24557	42	035	442 MCELHATTAN DR LOT 867	MCELHATTAN	PA	17748	BRUNGART RODNEY C	PO BOX 12	MCELHATTAN	PA	17748	CLINTON	81728	WAYNE	030500	305	139.4645	13800		13800	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		182.8495	183.1856	182.9853	VC	0	PERSON							2026.2	35
2-356-21	42	035	307 GROVE ST	ASH	PA	28420	KELLER ROBERT W ET AL	2953 KAI DEN LN NW	ASH	NC	28420	CLINTON	03632	AVIS	030400	304	663.8626	78600	22300	100900	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		186.7208	188.2460	187.4283		0.1640	PERSON							2026.2	2
2-186-4	42	035	506 FAIRVIEW ST	JERSEY SHORE	PA	17740	HOWLETT LAURA C	506 FAIRVIEW ST	JERSEY SHORE	PA	17740	CLINTON	03632	AVIS	030400	304	663.5457	97700	20200	117900	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		199.2467	202.2583	201.1155		0.1640	PERSON							2026.2	2
31-16258-9	42	035	2229 DELAWARE AVE	RENOVO	PA	17764	BECKER CORINNE J ET AL	2229 DELAWARE AVE	RENOVO	PA	17764	CLINTON	64200	RENOVO	030100	301	362.8885	13600	5800	19400	1	1	42035C	2025-12-21	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…		201.0227	201.7559	201.3372		0.0900	PERSON							2026.2	31
35-17312	42	035		LOCK HAVEN	PA	17745	FRITZ SAMUEL L	458 PINE MOUNTAIN RD	LOCK HAVEN	PA	17745	CLINTON	81728	WAYNE	030500	305	4392.6481	75000	19600	94600	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		192.2659	196.0285	194.1743	R-2	1.0850	PERSON							2026.2	35
13-23537	42	035	785 ROCKEY RD	LOGANTON	PA	17747	KUSTENBORDER RONNIE H & MONICA A	785 ROCKEY RD	LOGANTON	PA	17747	CLINTON	30928	GREENE	030900	309	10984.0501	127600	26500	154100	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		531.8439	545.0523	537.4705		2.7140	PERSON							2026.2	13
2-247-10	42	035	104 PROSPECT AVE	AVIS	PA	17721	BRUNGARD CHARLES L ET UX TRUST	PO BOX 125	AVIS	PA	17721	CLINTON	03632	AVIS	030400	304	590.8516	73700	22100	95800	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		192.6041	196.5533	194.9873		0.1460	PERSON							2026.2	2
22-11170	42	035	220 S FAIRVIEW ST	LOCK HAVEN	PA	17745	ELLING FAMILY TRST	199 S FAIRVIEW ST	LOCK HAVEN	PA	17745	CLINTON	44128	LOCK HAVEN	030701	307.0100	1114.5964	70900	19000	89900	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		174.9250	178.4733	176.7986	RL	0.2750	PERSON							2026.2	22
28-14180-30	42	035	47 ELEVENTH ST	JERSEY SHORE	PA	17740	FALLS KEVIN	47 ELEVENTH ST	JERSEY SHORE	PA	17740	CLINTON	60360	PINE CREEK	030400	304	634.8033	78300	19300	97600	1	1	42035C	2025-12-21	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…		170.1166	171.2517	170.9403		0.1570	PERSON							2026.2	28