Saved query e6ce4901e4d0e30b

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

29,424 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	totalvalue	saleamt	numbldgs	numunits	numfloors	bldgsqft	fldzone	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	naicscode	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	taxyear
23-007-219.1	42	083	8946 ROUTE 6	KANE	PA	16735	LINDQUIST JENNIFER ET AL	14 PINE AVE	KANE	PA	16735	MCKEAN	32232	HAMLIN	420900	4209	2210.1252	101840	15860		117700	380000	1	1	1		—	638.5441	640.8965	640.1062	C	RETAIL	0.5460	PERSON	7225	CORR MAP	0890	0802				BARREL HOUSE RESTAURANT & TAVERN	RESTAURANT	2023
17-005-407	42	083	33 GLENDORN DRIVE	BRADFORD	PA	16701	SHADE JEFFREY L JANET M	33 GLENDORN DR	BRADFORD	PA	16701	MCKEAN	08048	BRADFORD	421000	4210	44349.1260	75820	14870		90690		1	1	1	1142	—	487.1099	506.2344	492.0797	R		10.9582	PERSON			0514	0979				JAMES SMITH SRSTP		2023
23-004-201	42	083	Route 42002	HAMLIN TWP	PA	16749	COMMONWEALTH OF PENNSYLVANIA PA…	2001 ELMERTON AVENUE	HARRISBURG	PA	17110	MCKEAN	32232	HAMLIN	420900	4209	4672622.2659	-144030	214530	-144030	358560	1779119					—	475.8836	686.8822	642.5820	V		1154.5637	GOVERNMENT			0752	0731	GOVT STATE	OPEN	OTHER	STATE GAME LAND 062	STATE RESOURCE MANAGEMENT AREA	2023
22-015-129	42	083	5 LINCOLN AVE	HAMILTON TWP	PA	16333	ALLEN GARY KERRY	PO BOX 365	KANE	PA	16735	MCKEAN	32168	HAMILTON	421100	4211	4472.8087	37940	10730		48670	110000	3	1	1	1400	—	463.9240	467.6949	465.9009	R		1.1051	PERSON		MERGED 22-015-127 22-015-128 22…	0877	0121						2023
03-002-467.4	42	083	210 W WASHINGTON ST	BRADFORD CITY	PA	16701	BRADFORD POST 108 AMERICAN LEGI…	210 W WASHINGTON ST	BRADFORD	PA	16701	MCKEAN	08040	BRADFORD	420300	4203	1656.6896	33980	17860		51840		1	1			—	446.7011	447.7644	447.2586	C	RETAIL	0.4093	NONPROFIT		MERGED 019 AC FROM 03-002-412 3…	0915	0069				CARMILLIE'S	SECOND_HAND_STORE	2023
08-003-244	42	083	107 PINE ST	KANE	PA	16735	ASEL MICHAEL G	107 PINE ST	KANE	PA	16735	MCKEAN	38688	KANE	421200	4212	1233.8099	32960	9000		41960	30000	1	1	1	1000	—	564.8754	570.9462	567.9165	R		0.3048	PERSON		CORR MAP	1022	0236						2023
09-001-222	42	083	313 MOFFIT AVE	KANE BORO	PA	16735	GRAY SABRA M	313 1 2 MOFFIT AVE	KANE	PA	16735	MCKEAN	38688	KANE	421100	4211	927.9487	10500	8000		18500	25000	1	1	1	672	—	603.1721	607.6117	604.9467	R		0.2292	PERSON		MERGED 09-001-221	1006	0031						2023
20-003-173	42	083	W ELDRED ROAD	ELDRED TWP	PA	16731	PENNSYLVANIA GAME COMMISSION	2001 ELMERTON AVENUE	HARRISBURG	PA	17110	MCKEAN	22896	ELDRED	420600	4206	195562.4768		33670		33670	9035					—	433.6007	437.0759	435.8102	V	NATURE_RESERVE	48.3241	PERSON			0166	0633	GOVT STATE	OPEN	OTHER	STATE GAME LAND 301	STATE RESOURCE MANAGEMENT AREA	2023
25-020-115	42	083	32 SCOTT ROAD	LEWIS RUN	PA	16738	BRINSKY DANIEL J C O THOMAS SHI…	32 SCOTT RD	LEWIS RUN	PA	16738	MCKEAN	40808	LAFAYETTE	420900	4209	1496.8457	9440	7410		16850	35000	1	1	1	1001	—	635.9192	637.6824	636.9489	R		0.3698	PERSON		LT 308	0646	0018						2023
17-008-401.2	42	083	1176 SOUTH AVENUE	BRADFORD TWP	PA	16701	VINCA RONALD L BEVERLY A	1176 SOUTH AVENUE	BRADFORD	PA	16701	MCKEAN	08048	BRADFORD	421000	4210	143768.3001	18160	7430	-18790	63170		2	1	1	1128	—	477.1232	677.8073	565.3263	A		35.5247	PERSON		MERGED 17-008-401 3	0655	0462						2023
06-006-113	42	083	58 BURNSIDE AVENUE	BRADFORD	PA	16701	WONDRACK ED RUDY ET AL	58 BURNSIDE AVENUE	BRADFORD	PA	16701	MCKEAN	08040	BRADFORD	420400	4204	540.2167	25800	12000		37800	39000	2	1	1	2000	—	446.1686	448.8439	447.2890	R		0.1335	PERSON			0676	0524						2023
26-014-115	42	083	561 SCAFFOLD LICK RD	LIBERTY TWP	PA	16743	SZAKELYHIDI THOMAS A ET AL C O …	4263 US 422	NEW CASTLE	PA	16101	MCKEAN	43096	LIBERTY	420700	4207	7952.1163	11850	12560		24410	45000	1	1	2	672	—	501.8218	522.2567	505.9193	R		1.9649	PERSON			0918	0267						2023
30-025-120	42	083	234 OLD SMETHPORT RD	WETMORE TWP	PA	16735	RYDING HEIDI ET AL	234 OLD SMETHPORT ROAD	KANE	PA	16735	MCKEAN	84312	WETMORE	421100	4211	9059.7676	31450	12800		44250	69000	2	1	1	1298	—	620.8503	627.7172	624.6223	R		2.2384	PERSON			0789	0488						2023
30-023-123.1	42	083	102 GRANDVIEW RD	WETMORE TWP	PA	16735	DROST PAUL E BONNIE J	102 GRANDVIEW ROAD	KANE	PA	16735	MCKEAN	84312	WETMORE	421200	4212	2048.9664	44640	10450		55090	36000	1	1	1	1152	—	635.3707	637.0894	636.2380	R		0.5063	PERSON			0519	0523						2023
06-707-113	42	083	20 MELVIN AVE	BRADFORD	PA	16701	MARRA NEELY PROPERTIES LLC	3620 MALLORY PLACE	WILLIAMSBURG	VA	23188	MCKEAN	08040	BRADFORD	420400	4204	597.4826	74600	6250		80850	240000	2	1	2	2156	—	435.8114	436.3276	436.1565	R		0.1476	BUSINESS			0867	0368						2023
21-020-614.2	42	083	66 BATES RD	FOSTER TWP	PA	16701	SIRLINE ARNOLD E CRYSTAL	66 BATES RD	BRADFORD	PA	16701	MCKEAN	26936	FOSTER	420500	4205	2094.5525	41880	11250		53130	157900	1	1	1	1516	—	456.2037	468.4203	460.8751	R		0.5175	PERSON			0996	0082						2023
09-001-325	42	083	225 YARNELL STREET	KANE	PA	16735	NOWALK CLEON R SUSAN M	225 YARNELL STREET	KANE	PA	16735	MCKEAN	38688	KANE	421100	4211	499.3113	38470	4250		42720	43000	1	1	1	1874	—	614.1682	616.3671	615.6139	R		0.1233	PERSON			0162	0255						2023
22-016-209	42	083	12 W MAIN ST	HAMILTON	PA	16333	JOHNSTON CATHERINE A C O CATHER…	12 WEST MAIN STREET PO BOX 128	LUDLOW	PA	16333	MCKEAN	32168	HAMILTON	421100	4211	1295.0624	59360	5000		64360	34000	3	1	1	2614	—	472.8554	477.0059	474.9678	R		0.3200	PERSON			0195	0765						2023
20-002-108.2	42	083	41 STATE LINE RD	ELDRED TWP	PA	16731	THOMSON KRISTEN ALAN ET AL	41 STATE LINE RD	ELDRED	PA	16731	MCKEAN	22896	ELDRED	420600	4206	3346.5523	20460	11000		31460		2	1	1	1104	—	437.1940	442.6620	439.9121	R		0.8269	PERSON		CORRECTED PARCEL	0917	0150						2023
25-009-210.1	42	083	8590 ROUTE 59	LAFAYETTE TWP	PA	16738	WAGNER THEODORE PATRICIA	114 TOW HILL ROAD	PORT MATILDA	PA	16870	MCKEAN	40808	LAFAYETTE	420900	4209	7169.1748	31450	11000		42450	45000	2	1	1	1240	—	634.9805	638.6297	636.8072	R		1.7714	PERSON			0401	0926						2023
22-009-106	42	083	11217 ROUTE 321	HAMILTON TWP	PA	16735	BAUER JEFFREY M PAULINE	1072 BLISS HILL RD	KANE	PA	16735	MCKEAN	32168	HAMILTON	421100	4211	42405.6614	41480	2370	-7370	58590	135000	1	1		1980	—	429.2901	615.2988	507.2972	A		10.4776	PERSON			0926	0974						2023
21-011-225	42	083	245 BOLIVAR DRIVE	BRADFORD	PA	16701	PANIGHETTI JAMES H ROXANNE	245 BOLIVAR DRIVE	BRADFORD	PA	16701	MCKEAN	26936	FOSTER	420100	4201	1626.0124	69360	12000		81360	108000	1	1	1	1626	—	447.4760	453.0226	451.1711	R		0.4018	PERSON			0317	0119						2023
21-040-114	42	083	221 LOOKER MOUNTAIN TRAIL	FOSTER TWP	PA	16701	BALDWIN DONALD E	218 LOOKER MOUNTAIN TRAIL	BRADFORD	PA	16701	MCKEAN	26936	FOSTER	420500	4205	6808.8115	12300	12000		24300	17000	2	1	2	1088	—	499.4304	510.4799	504.2347	R		1.6825	PERSON			0265	0296						2023
29-009-102.2	42	083	11747 WILCOX RD	WILCOX	PA	15870	ALERICH AMANDA J ET AL	5950 KIMBERLY ANNE WAY UNIT 101	ALEXANDRIA	VA	22310	MCKEAN	69304	SERGEANT	420900	4209	1016.2455	6300	5450		11750	13865	1	1	1	584	—	641.8591	642.5643	642.2568	R		0.2510	PERSON			0926	0158						2023
03-019-239	42	083	56 PLEASANT STREET	BRADFORD	PA	16701	MASON GAIL R	176 CONGRESS ST	BRADFORD	PA	16701	MCKEAN	08040	BRADFORD	420300	4203	301.7346	2100	2900		5000	1500	1	1	1	886	—	456.8042	461.0111	458.4275	R		0.0745	PERSON			0965	0589						2023