Saved query 19d95a5a5a5f8ef3

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

17,196 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	agvalue	totalvalue	saleamt	numbldgs	numunits	yearbuilt	bldgsqft	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	taxacres	ownertype	naicscode	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	taxdistrict
61 2193	2193	42	105	WATER ST	COUDERSPORT	PA	16915	RUSSELL ELEANOR ET AL	602 N MAIN ST	COUDERSPORT	PA	16915	Potter	16448	Coudersport	950300	9503	622.5675	27880	1720		29600	1	1	1	0	0	42105C	2025-12-21	X	AREA WITH REDUCED FLOOD RISK DU…	496.9369	502.3831	500.2736	C	0	PERSON	7225	LOT 92F X 46.5 AV	0208	0932				CHILLIN OUT ICE CREAM	CASUAL_EATERY	61
61 41496	41496	42	105	BLUEBIRD LANE	COUDERSPORT	PA	16915	RUNKEL RICHARD ETUX	39 BLUEBIRD LANE	COUDERSPORT	PA	16915	Potter	16448	Coudersport	950300	9503	39762.9783	25540	3590	-5350	39830	26300	1	1	8	1248	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	633.4526	646.6076	641.9345	R	10.2000	PERSON		ACT 319	0104	0446						61
150 7739	7739	42	105	REED RUN RD	KEATING	PA	16720	NICHOLS CURT O	498 MARGUERITE RD	LATROBE	PA	15650	Potter	38920	Keating	950402	9504.0200	1004.9374	7560			7560		1	1	50	630	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	595.1386	600.6116	597.6744	X	0	PERSON	1153				GOVT STATE	RESTRICTED	OTHER	SUSQUEHANNOCK STATE FOREST	STATE RESOURCE MANAGEMENT AREA	150
110 5551	5551	42	105	PLEASANT VALLEY RD	HARRISON	PA	16927	JAMES J ROBERT ETUX	951 PLEASANT VALLEY RD	HARRISON VALLEY	PA	16927	Potter	32848	Harrison	950101	9501.0100	377677.0087	52110	16120	-7320	82870	65000	1	1	3	2145	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	590.1913	696.1380	629.8867	A	96.1400	PERSON		RT 52044	0047	0622						110
240 11008	11008	42	105	HONEOYE ST	SHINGLEHOUSE	PA	16748	MCCLEAFTS WINNERS CIRCLE LLC	522 W HONEOYE ST	SHINGLEHOUSE	PA	16748	Potter	70304	Shinglehouse	950200	9502	2543.3526	6780	5500		12280	1	1	1	0	0	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	447.2594	453.4223	451.8892	C	0	BUSINESS	33635	HONEOYE ST						MCCLEAFT'SWINNERSCIRCLE	AUTOMOTIVE_SERVICE	240
62 41736	41736	42	105	MAPLE VIEW LANE	COUDERSPORT	PA	16915	POTTER COUNTY POOR DISTRICT		COUDERSPORT	PA	16915	Potter	16448	Coudersport	950300	9503	2742.5945	172040	32290		204330		1	1	0	0	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	522.8416	525.1995	524.0689	E	106.4600	PERSON	5611	24 MAPLE VIEW LANE-VA CLINIC	56	312				POTTER COUNTY EOC	GOVERNMENT_OFFICE	62
240 11201	11201	42	105	PALMER ST	SHINGLEHOUSE	PA	16748	DICKERSON CLARENCE A	PO BOX 113	SHINGLEHOUSE	PA	16748	Potter	70304	Shinglehouse	950200	9502	465.9400	9120	600		9720	1	1	1	10	992	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	455.1337	455.8466	455.6133	R	0	PERSON		5 PALMER ST	0056	0644						240
230 11560	11560	42	105	BIG DAM HOLLOW RD		PA	17729	HOCK ROGER	234 SUMMER HILL RD	BERNVILLE	PA	19506	Potter	74072	Stewardson	950500	9505	1004.7895	19900			19900		1	1	12	1000	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	545.7425	549.2865	547.2570	X	0	PERSON	1153				GOVT STATE	RESTRICTED	OTHER	SUSQUEHANNOCK STATE FOREST	STATE RESOURCE MANAGEMENT AREA	230
30 1489	1489	42	105	SCHOOL ST	AUSTIN	PA	16720	VALENTI JOSEPH M ETUX	PO BOX 62	AUSTIN	PA	16720	Potter	03576	Austin	950402	9504.0200	1234.0620	19000	1840		20840	1	1	1	0	784	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	416.2961	423.6158	419.4567	R	0	PERSON		LOT 150 X 100	0256	0149						30
62 2861	2861	42	105	DWIGHT ST	COUDERSPORT	PA	16915	WYATT PETER CHRISTIAN ETUX	512 DWIGHT ST	COUDERSPORT	PA	16915	Potter	16448	Coudersport	950300	9503	758.2084	31020	1280		32300	122500	1	1	0	907	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	506.3404	506.9694	506.6580	R	0	PERSON		LOT 55.3 X 122	0278	0181						62
190 47537	47537	42	105	DEAN HOLLOW RD	PLEASANT VALLEY	PA	16748	DEAN NIKKI	288 DEAN HOLLOW RD	SHINGLEHOUSE	PA	16748	Potter	61400	Pleasant Valley	950200	9502	80897.6063	28900	4400	-5700	44700	1	1	1	8	1120	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	567.3817	629.8651	601.3085	R	20	PERSON			0031	0015						190
61 41555	41555	42	105	SECOND ST	COUDERSPORT	PA	16915	POTTER COUNTY JAIL		COUDERSPORT	PA	16915	Potter	16448	Coudersport	950300	9503	2075.1000	82800	9920		92720		1	1	90	3763	42105C	2025-12-21	X	AREA WITH REDUCED FLOOD RISK DU…	503.0956	504.1670	503.8595	E	0	PERSON	6112		0173	0016				POTTER COUNTY JAIL	JAIL_OR_PRISON	61
150 7670	7670	42	105	SR 155	KEATING	PA	16720	COLARUSSO CAROL A ETAL	PO BOX 231	CARMICHAELS	PA	15320	Potter	38920	Keating	950402	9504.0200	887.7778	4160	600		4760	1	1	1	61	613	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	541.0908	545.1329	543.8670	X	0.1700	PERSON		RT 155	0014	0961						150
80 42523	42523	42	105	BLACKBERRY LANE	EULALIA	PA	16915	GRAHAM LINDSAY L ETAL	3067 BURNS ROAD	JAMESTOWN	PA	16134	Potter	24184	Eulalia	950300	9503	9383.0856	34280	3360		37640	1	1	1	79	1232	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	673.4848	693.5730	681.4099	R	2.3200	PERSON	81291							TEACHER'S PET RESCUE	ANIMAL_OR_PET_SERVICE	80
61 2288	2288	42	105	EAST ST	COUDERSPORT	PA	16915	POTTER LANDS LLC	15 CREEKSIDE DRIVE	COUDERSPORT	PA	16915	Potter	16448	Coudersport	950300	9503	984.6182	71490	2300		73790	40000	1	1	91	2028	42105C	2025-12-21	X	AREA WITH REDUCED FLOOD RISK DU…	502.9065	503.6067	503.2587	C	0.2620	BUSINESS	3372							ULTIMATE POWER	CORPORATE_OR_BUSINESS_OFFICE	61
150 7965	7965	42	105	A PRIVATE	KEATING	PA	16720	DALESSANDRO ROBERT ETUX	119 SHIDLER RUN	AMITY	PA	15311	Potter	38920	Keating	950402	9504.0200	300.3086	2520	1240		3760	15000	1	1	0	462	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	656.2225	660.2875	658.4407	X	0.1800	PERSON		OFF 309	0290	0124						150
220 10723	10723	42	105	SR 44 SOUTH	SHARON	PA	16748	LAURICELLA LEONARD P & BROOKE	2007 SR 44 SOUTH	SHINGLEHOUSE	PA	16748	Potter	69736	Sharon	950200	9502	2344.8350	14400	2520		16920	125000	1	1	0	960	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	464.7188	465.7252	465.3444	R	0.8900	PERSON	71213							THE OLD RED SCHOOLHOUSE WILDLIF…	ZOO	220
61 2699	2699	42	105	WOODLAWN AVE	COUDERSPORT	PA	16915	CHILSON KEITH A ETUX	6 WOODLAWN AVE	COUDERSPORT	PA	16915	Potter	16448	Coudersport	950300	9503	643.7251	19160	2120		21280	42500	1	1	91	1120	42105C	2025-12-21	X	AREA WITH REDUCED FLOOD RISK DU…	503.6643	505.5293	504.0202	R	0	PERSON		LOT 76 X 113.025	0077	0904						61
260 12568	12568	42	105	SECOND ST	SWEDEN	PA	16915	BGC HOLDINGS LLC	729 STEEPLECHASE RD	LANDISVILLE	PA	17538	Potter	75720	Sweden	950300	9503	36304.2869	17260	8100		25360	100000	1	1	0	836	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	599.7316	619.8018	607.1576	X	9	BUSINESS	2111		0051	0863						260
100 4901	4901	42	105	PUMP STATION RD		PA	16923	PEASLEY DARLENE ETAL	542 NW LABREA AVE	PORT SAINT LUCIE	FL	34983	Potter	28760	Genesee	950102	9501.0200	233566.8814	10150	9510	-2810	25280	1	1	1	93	864	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	605.5051	667.1816	638.5355	A	50	PERSON		ACT 319	0257	0832						100
150 7428	7428	42	105	BARK SHANTY RD	KEATING	PA	16720	CLEARVIEW CAMP	14456 FORD RD	MADISON	OH	44057	Potter	38920	Keating	950402	9504.0200	519.0656	6200	2000		8200		1	1	72	808	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	656.3441	662.0954	658.8745	X	0.1800	PERSON		RT 309	0156	0389						150
300 14391	14391	42	105	TYOGA RD		PA	16922	BOTT STEVEN M ETUX	343 EAST SECOND MOUNTAIN RD	POTTSVILLE	PA	17901	Potter	82568	West Branch	950500	9505	28348.1584	8840	4720		13560	46000	1	1	74	980	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	662.6453	679.6660	673.9581	R	7.3000	PERSON		RT 423	0082	0954						300
240 41384	41384	42	105	PURITAN ST	SHINGLEHOUSE	PA	16748	SHINGLEHOUSE VOLUNTEER FIRE DEPT		SHINGLEHOUSE	PA	0	Potter	70304	Shinglehouse	950200	9502	7759.8224	115760	4410		120170		1	1	0	0	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	454.5722	455.7447	455.1153	E	0	PERSON	6216	PURITAN ST						SHINGLEHOUSE VOLUNTEER FIRE	HOME_SERVICE	240
300 43589	43589	42	105	HARTMAN LANE		PA	16922	UNDERKOFFLER JOAN Y	413 DEERFIELD DR	MOUNT JOY	PA	17552	Potter	82568	West Branch	950500	9505	17048.2187	21160	5880		27040	1	1	1	85	576	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	645.0770	679.5137	668.6993	X	4.3600	PERSON		OFF RT 423	0236	0097						300
110 5411	5411	42	105	WHITE KNOLL RD	HARRISON	PA	16948	SCHMIDT JERRY & SHERRY POULIOT	1000 WHITE KNOLL ROAD	ULYSSES	PA	16948	Potter	32848	Harrison	950101	9501.0100	270430.8731	107310	11380	-10580	139850	1	1	1	75	6750	42105C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	696.0651	744.1865	722.9127	A	74.7000	PERSON		OFF RT 475								110