Saved query 04bb9a076ad89169

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

0/80

Live SQL

SELECT * 
FROM "parcel_layer" 
WHERE statefp = '42' 
  AND countyfp = '035'

33,262 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	taxdistrict
14-6625	42	035	15 DARBY BOTTOM LN	MILL HALL	PA	17751	DARBY RAY ET AL	15 DARBY BOTTOM LN	MILL HALL	PA	17751	CLINTON	31680	GRUGAN	030300	303	4092.9282	25100	12600	37700	1	1	42035C	2025-12-21	A			174.5556	193.5332	180.7444	RF	1.0109	PERSON		GOVT UNKNOWN	RESTRICTED	VI	SPROUL STATE FOREST - BUCKTAIL …	STATE RESOURCE MANAGEMENT AREA	14
19-9745-36	42	035	422 E WALNUT ST	LOCK HAVEN	PA	17745	ISH PROPERTIES LLC	28 UPPERHILL DR	LOCK HAVEN	PA	17745	CLINTON	44128	LOCK HAVEN	030600	306	3246.9840	65700	23500	89200	1	1	42035C	2025-12-21	X	AREA WITH REDUCED FLOOD RISK DU…		169.0719	172.4015	170.5486	GC-LI	0.8020	BUSINESS	6216				KEYSTONE SECURITY AND TECHNOLOG…	HOME_SERVICE	19
19-9530	42	035	115 S WASHINGTON ST	WILLIAMSPORT	PA	17702	RELL BERNARD D	254 PLANTATION LN	WILLIAMSPORT	PA	17702	CLINTON	44128	LOCK HAVEN	030600	306	30290.4762	491700	165600	657300	1	1	42035C	2025-12-21	X	AREA WITH REDUCED FLOOD RISK DU…		167.9109	171.0045	169.4327	GC-LI	7.4850	PERSON	531130				BEST SELF STORAGE	SELF STORAGE FACILITY	19
13-6585-86	42	035		LOCK HAVEN	PA	17745	LOCK HAVEN CITY AUTHORITY	UNKNOWN	LOCK HAVEN	PA	17745	CLINTON	30928	GREENE	030900	309	16980.4360		1459400	1459400			42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		522.3467	546.5294	537.6911		4.1959	PERSON		NGO	CLOSED	V	BALD EAGLE MOUNTAINS	CONSERVATION EASEMENT	13
16-20605-1	42	035	1054 BIRCH ISLAND RD	HARRISBURG	PA	17120	DEPT OF ENVIRONMENTAL RESOURCE	PO BOX 1467	HARRISBURG	PA	17120	CLINTON	83240	WEST KEATING	030100	301	14635.7028		5547200	5547200			42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		602.5490	606.4191	604.3012		3.6160	GOVERNMENT		GOVT STATE	RESTRICTED	OTHER	SPROUL STATE FOREST	STATE RESOURCE MANAGEMENT AREA	16
26-13313-27	42	035	211 MIDDLE ST	MILL HALL	PA	17751	BITTNER KENNETH		MILL HALL	PA	17751	CLINTON	49760	MILL HALL	030200	302	525.7027	7300	18600	25900	1	1	42035C	2025-12-21	AE	FLOODWAY		171.9405	172.3864	172.1733		0.1300	PERSON							26
11-22999	42	035	645 WOODS AVE	FLEMINGTON	PA	17745	WYKOFF DEWARD M & MAY C	645 WOODS AVE	FLEMINGTON	PA	17745	CLINTON	26296	FLEMINGTON	030500	305	570.7824	11000	21400	32400	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		175.8482	179.4080	177.8200		0.1290	PERSON							11
20-22910-77	42	035	145 E WALNUT ST	LOCK HAVEN	PA	17745	NESTLERODE CONTRACTING CO INC	145 E WALNUT ST	LOCK HAVEN	PA	17745	CLINTON	44128	LOCK HAVEN	030600	306	866.5109	280700	162500	443200	1	1	42035C	2025-12-21	X	AREA WITH REDUCED FLOOD RISK DU…		170.0664	171.8417	171.3778	GC	0.2140	BUSINESS							20
29-15142-67A	42	035	494 PARK AVE	LOCK HAVEN	PA	17745	ROHRBACH STEVEN ET AL	494 PARK AVE	LOCK HAVEN	PA	17745	CLINTON	60360	PINE CREEK	030400	304	1586.3682	165900	30000	195900	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		180.6342	184.4085	182.7166		0.3920	PERSON							29
18-21961	42	035	61 AUSTIN HOLLOW RD	CROSS FORKS	PA	16829	GEORGE MONTE & HEIDI	61 AUSTIN HOLLOW RD	CROSS FORKS	PA	16829	CLINTON	42544	LEIDY	030100	301	22404.6069	53500	25300	78800	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		477.5518	501.9885	485.4208		5.5359	PERSON							18
13-29800-47C	42	035	327 SPRUCE RUN RD	LOGANTON	PA	17747	MOORE DOUGLAS L	327 SPRUCE RUN RD	LOGANTON	PA	17747	CLINTON	30928	GREENE	030900	309	7869.4762	85500	15200	100700	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		516.9595	519.9846	518.2483		1.9450	PERSON							13
7-24426	42	035	98 SKUNK HOLLOW RD	THOMASVILLE	PA	17364	MILLER ROBERT F JR ET AL	215 N RIDGE RD	THOMASVILLE	PA	17364	CLINTON	12640	CHAPMAN	030100	301	2491.1231	2600	19100	21700	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		225.8847	236.8455	230.5835	AG/FOR	0.6340	PERSON							7
23-11942	42	035	825 WOODS AVE	LOCK HAVEN	PA	17745	GARDNER JUSTINE	825 WOODS AVE	LOCK HAVEN	PA	17745	CLINTON	44128	LOCK HAVEN	030701	307.0100	503.1149	92600	16900	109500	1	1	42035C	2025-12-21	X	AREA WITH REDUCED FLOOD RISK DU…		171.7036	173.4372	172.7802	RL	0.1240	PERSON							23
28-20512-5	42	035	89 MUNICIPAL DR	JERSEY SHORE	PA	17740	COHICK MICHAEL J	89 MUNICIPAL DR	JERSEY SHORE	PA	17740	CLINTON	60360	PINE CREEK	030400	304	594.4425	27100	16300	43400	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		179.7536	180.6815	180.2687		0.1470	PERSON							28
12-5846	42	035	3621 QUEENS RUN RD	SEVEN VALLEYS	PA	17360	BECK THOMAS E &	HEIDI A	SEVEN VALLEYS	PA	17360	CLINTON	28296	GALLAGHER	030300	303	22989.6057	59600	31000	90600	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		510.2191	529.0910	519.3033	RF	5.6800	PERSON							12
35-27304	42	035	28 COCHISE TRL	MCELHATTAN	PA	17748	KOCH RYAN	PO BOX 523	MCELHATTAN	PA	17748	CLINTON	81728	WAYNE	030500	305	3626.0154	177500	42700	220200	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		232.9648	241.3715	237.3649	R-1	0.8960	PERSON							35
10-24232	42	035	1147 BIG PLUM RUN RD	LOCK HAVEN	PA	17745	WATKINS JOSEPHINE V	1147 BIG PLUM RUN RD	LOCK HAVEN	PA	17745	CLINTON	20408	DUNNSTABLE	030300	303	76620.4449	27800	44100	71900	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		178.0839	260.7050	229.0665	R-1	18.9320	PERSON							10
21-10297	42	035	421 W MAIN ST	LOCK HAVEN	PA	17745	DICKSON LORETTA D ET AL	421 W MAIN ST	LOCK HAVEN	PA	17745	CLINTON	44128	LOCK HAVEN	030701	307.0100	1031.8291	166500	21700	188200	1	1	42035C	2025-12-21	X	AREA WITH REDUCED FLOOD RISK DU…		171.2891	171.9780	171.6342	RM	0.2550	PERSON							21
36-29221	42	035	JULIA DR	LOCK HAVEN	PA	17745	GENTZYEL AARON W & KRISTA A	232 CIDER PRESS RD	LOCK HAVEN	PA	17745	CLINTON	86448	WOODWARD	030300	303	2175.4235	133400	22800	156200	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		234.3456	239.0658	236.7815		0.5380	PERSON							36
19-9384-31	42	035	632 E CHURCH ST	LOCK HAVEN	PA	17745	SPONG MITCHELL P	632 E CHURCH ST	LOCK HAVEN	PA	17745	CLINTON	44128	LOCK HAVEN	030600	306	678.1891	60100	17600	77700	1	1	42035C	2025-12-21	AE		554.8000	168.1004	169.2676	168.5792	RM	0.1680	PERSON							19
26-24165	42	035	624 W CHURCH ST	MILL HALL	PA	17751	BOWER DAVID E III & ALYSSA C	624 W CHURCH ST	MILL HALL	PA	17751	CLINTON	49760	MILL HALL	030200	302	443.0720	83600	19700	103300	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		215.4114	218.2508	216.8907		0.1100	PERSON							26
10-24403-67	42	035	1033 HUMMING BIRD LN	LOCK HAVEN	PA	17745	OHL W CAREY & DIANA S	1033 HUMMINGBIRD LN	LOCK HAVEN	PA	17745	CLINTON	60360	PINE CREEK	030400	304	2695.0444	207700	39600	247300	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		220.4601	230.1839	224.6247	R-1	0.6660	PERSON							10
22-11609-62	42	035	308 LOGAN ST	LOCK HAVEN	PA	17745	CLINTON CO HOUSING AUTHORITY	369 LINDEN CIR	LOCK HAVEN	PA	17745	CLINTON	44128	LOCK HAVEN	030701	307.0100	1274.6064	656400	122200	778600	1	1	42035C	2025-12-21	X	AREA WITH REDUCED FLOOD RISK DU…		169.1488	170.6816	169.9839	RM	0.3150	GOVERNMENT							22
36-18852	42	035	150 CARDINAL DR	LOCK HAVEN	PA	17745	MILLS THOMAS G JR	150 CARDINAL DR	LOCK HAVEN	PA	17745	CLINTON	86448	WOODWARD	030300	303	1620.1813	103500	24100	127600	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		180.2448	188.6272	184.9681		0.4000	PERSON							36
1-136-34	42	035	1021 RENOVO RD	AVIS	PA	17721	TONER ROBERT G	PO BOX 906	AVIS	PA	17721	CLINTON	02032	ALLISON	030500	305	1017.2979	45100	15200	60300	1	1	42035C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		195.7232	206.3954	201.3837		0.2510	PERSON							1