Saved query acf18f7e29bc012c

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

43,999 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	agvalue	totalvalue	saleamt	saledate	numbldgs	numunits	numfloors	bldgsqft	fldzone	elevmin	elevmax	elevavg	ownertype	legaldesc	book	parceltype	accesstype	iucnclass	placename	placetype	taxyear
12-023-106.00 000	42	063	456 POWER PLANT RD	CORAL	PA	15717	UNITED STATES ARMY CORPS OF ENG…	PO BOX 124	INDIANA	12040	CENTER	961600	9616	2801.7651	56400		56400			3	1	1	1144	—	299.4294	302.7959	301.6960	GOVERNMENT	BOOK 0970-000644	0970-000644	GOVT FEDERAL	OPEN		CONEMAUGH RIVER LAKE	RECREATION MANAGEMENT AREA	2015
19-008-127.00 000	42	063	3046 PINE VALE RD	PA	PA	15742	C/O KARL SPRENGER	61 LINDA LANE	INDIANA	30416	GRANT	960300	9603	99423.5490	22700	83400	106100	62100	2015-07-31	3	1	2	1456	—	441.5538	479.5140	448.4029	PERSON	BOOK 2015-263452	2015-263452						2015
03-003-108.01 000	42	063	261 W LAKE DR	BANKS	PA	15772	STATE OF PENNSYLVANIA	BOX 1673	INDIANA	04056	BANKS	960100	9601	111608.0900	85500		85500			1	1			—	529.5700	551.6858	537.3268	GOVERNMENT	BOOK 0585-000820	0585-000820	GOVT STATE	OPEN	OTHER	HEMLOCK LAKE (FORMERLY STRAIGHT…	STATE OTHER OR UNKNOWN	2015
30-007-111.02F 000	42	063	1576 WINDOWS RD W	PA	PA	16256		1998 HEMLOCK ACRES RD	INDIANA	83416	WEST MAHONING	960200	9602	235973.9477	143200	138700	281900	108000	2015-09-11	4	2	2	2996	—	410.4869	460.8811	444.4141		BOOK 2015-265049	2015-265049						2016
42-015-155.00 000	42	063	2244 OAKLAND AVE	WHITE	PA	15701	C/O KIN PROPERTIES STE 100	185 N W SPANISH RIVER BLVD,	INDIANA	84472	WHITE	961102	9611.0200	3860.2794	566900		566900			1	2	1		—	382.0030	384.2039	383.3581	BUSINESS	BOOK 2008-192205	2008-192205				JERSEY MIKE'S	CASUAL_EATERY	2015
42-084-104.00 000	42	063	938 MARION RD	WHITE	PA	15701		938 MARION RD	INDIANA	84472	WHITE	960900	9609	1689.2603	117000		117000	5700	2020-01-22	1	1	1	1142	—	444.2350	447.8539	445.9959		BOOK 2020-306618	2020-306618						2015
24-006-313.00 000	42	063	LIONS CLUB	INDIANA	PA	15701		351 S 13TH ST	INDIANA	36816	INDIANA	961103	9611.0300	1040.1074	113900		113900	122100	2021-02-03	1	1	2	1302	—	390.4010	394.0960	392.5746		BOOK 2021-315872	2021-315872						2015
32-018-122.00 000	42	063	19068 RTE 286TH HWY UNIT E	EAST	PA	15746		2118 WALNUT DR	INDIANA	50624	MONTGOMERY	960300	9603	1144.9947	15000		15000	900	2021-03-26	2	2	2	1312	—	498.8501	503.0248	500.6804		REPOSITORY 2020	2021-317114						2015
43-022-218.00 000	42	063	477 CHURCH ST	STREET	PA	15756		4629 ELDERS RIDGE RD	INDIANA	87160	YOUNG	961800	9618	321.2479	29800		29800	17500	2017-10-17	1	2	2	1050	—	354.8359	362.2976	357.7628		BOOK 2017-286798	2017-286798						2015
16-018-107.00 000	42	063	7923 SALTSBURG RD	PA	PA	15681		7923 SALTSBURG RD	INDIANA	15560	CONEMAUGH	961900	9619	210252.1717	231500	94500	326000		2017-10-02	3	1	1	2498	—	315.6616	393.0920	354.2638		BOOK 2017-286393	2017-286393						2016
15-009-201.00 000	42	063	1785 DIXON RD	CLYMER	PA	15728		127 CEDAR LN	INDIANA	14520	CLYMER	961300	9613	722.0240	42300		42300	37800	2020-07-30	1	2	2	1312	—	379.0461	385.9220	381.9118		BOOK 2020-310649	2020-310649						2015
42-016-111.00 000	42	063	2530 WARREN RD	WHITE	PA	15701		201 BRIARWOOD	INDIANA	84472	WHITE	960700	9607	1083.7705	127800		127800		2009-01-19	1	1	1		—	412.4286	418.7199	415.5527		BOOK 1199-000034	1199-000034				HAIR THERAPY INDIANA LTD.	PERSONAL_OR_BEAUTY_SERVICE	2015
24-005-631.00 000	42	063	828 GRANT ST UNIT 1	INDIANA	PA	15701		1033 WATER ST	INDIANA	36816	INDIANA	961102	9611.0200	839.2197	243100		243100	235400	2012-01-18	1	1	2	3275	—	385.3549	386.9803	386.1762		BOOK 2012-227292	2012-227292						2015
28-014-106.00 000	42	063	249 KNOX RD N	PA	PA	15771		249 KNOX RD	INDIANA	55184	NORTH MAHONING	960100	9601	274185.8852	90200	160800	251000		2014-06-03	3	2	2	1760	—	438.6116	481.0568	465.1999		BOOK 2014-252994	2014-252994						2015
29-007-111.01 000	42	063	1557 ROSSMOYNE RD S	PA	PA	15747		1557 ROSSMOYNE RD	INDIANA	72304	SOUTH MAHONING	960200	9602	109340.8916	112400	80800	193200		2016-04-12	1	1	1	1496	—	386.0929	455.6164	421.7635		BOOK 2016-272820	2016-272820						2017
12-018-128.00 000	42	063	246 CHERRY RUN RD	PA	PA	15748		246 CHERRY RUN RD	INDIANA	12040	CENTER	961600	9616	1483.2493	66900		66900	78300	2015-11-05	1	1	1	952	—	322.9929	328.6334	325.7313		BOOK 2015-267261	2015-267261						2015
23-004-231.00 000	42	063	215 WASHINGTON ST	STREET	PA	15701		215 WASHINGTON ST	INDIANA	36816	INDIANA	961200	9612	560.8718	80900		80900	68800	2013-06-12	1	2	2	1242	—	402.6300	405.7784	404.4306		BOOK 2013-242982	2013-242982						2015
23-006-237.00 000	42	063	MARSH RUN	INDIANA	PA	15701		647 MAPLE ST	INDIANA	36816	INDIANA	961104	9611.0400	567.2489	93700		93700	57200	2016-05-24	2	1	2	1372	—	380.5790	382.0653	381.1894		BOOK 2016-274385	2016-274385						2015
18-002-421.00 000	42	063	369 GLENWOOD AVE	AVENUE	PA	15742		369 GLENWOOD AVE	INDIANA	29512	GLEN CAMPBELL	960100	9601	353.0048	26300		26300	34700	2015-12-16	1	1	2	952	—	440.9783	443.2667	442.2948		BOOK 2015-268629	2015-268629						2015
33-018-108.01 000	42	063	50 VARNER LN	LANE	PA	15957		50 VARNER LN	INDIANA	60320	PINE	961400	9614	8273.6169	76500		76500		2016-03-18	2	1	1	1540	—	543.3764	545.4461	544.3836		BOOK 2016-272856	2016-272856						2015
29-001-104.00 000	42	063			PA	15747		5977 MAHONING RD	INDIANA	72304	SOUTH MAHONING	960200	9602	235558.5846	172700	94700	267400	158600	2014-08-14	1	1	2	2924	—	366.0192	466.9858	399.9690		BOOK 2014-254347	2014-254347						2016
35-007-109.09 000	42	063	71 EDDIE LN	LANE	PA	15759		15 RAYNE RUN RD	INDIANA	63584	RAYNE	960500	9605	3081.4065	60600		60600		2011-12-28	1	1	1	1200	—	427.3237	432.8821	430.0191		BOOK 2011-226659	2011-226659						2015
04-016-108.00 000	42	063	1179 GRANGE RD	PA	PA	15717		1046 GRANGE RD	INDIANA	06752	BLACK LICK	961900	9619	669132.2255	196500	300000	496500			10	2	2	3510	—	296.4052	355.2945	318.5279		BOOK 0962-000804	0962-000804						2015
35-007-109.05 000	42	063	1120 SKYLINE DR	PA	PA	15759	C/O JENNIFER F TUCKER	1120 SKYLINE DR	INDIANA	63584	RAYNE	960500	9605	4621.5826	121200		121200			2	1		2356	—	413.5695	419.8721	418.1272	BUSINESS	BOOK 2007-177127	2007-177127						2015
02-004-115.05 000	42	063	918 ROUTE 156 HIGHWAY	ARMSTRONG	PA	15774		918 RTE 156 HWY	INDIANA	03064	ARMSTRONG	960600	9606	11261.7295	212100		212100		2016-06-10	1	1	1	2210	—	329.1627	369.2816	346.9696		BOOK 2016-274313	2016-274313						2015