Saved query a524070b3fd24e1b

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

43,999 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelstate	owneraddr	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	totalvalue	saleamt	saledate	numbldgs	numunits	numfloors	bldgsqft	fldzone	elevmin	elevmax	elevavg	legaldesc	book	lrversion	taxyear
42-028-107.00 000	42	063		PA	34 COLLEGE LODGE RD	INDIANA	84472	WHITE	960700	9607	646.6051	119500	119500	134500	2011-05-25	2	2	2	1499	—	423.2682	426.9895	425.0448	BOOK 2011-220548	2011-220548	2026.2	2015
12-030-508.00 000	42	063	71 E 9TH ST	PA	PO BOX 56	INDIANA	12040	CENTER	961600	9616	926.7796	75300	75300		2021-02-08	1	2	2	1924	—	353.1598	354.3389	353.8643	BOOK 2021-315966	2021-315966	2026.2	2015
22-005-206.00 000	42	063		PA	233 PHILADELPHIA ST	INDIANA	36816	INDIANA	961200	9612	598.1057	123200	123200	128400	2013-08-08	2	2	2	1569	—	386.6501	389.4076	387.4299	BOOK 2013-245260	2013-245260	2026.2	2015
22-008-325.00 000	42	063		PA	565 STANNARD AVE	INDIANA	36816	INDIANA	961000	9610	472.7991	128900	128900	127300	2018-08-02	1	1	1	1347	—	402.7519	404.3135	403.4543	BOOK 2018-293716	2018-293716	2026.2	2015
02-018-113.00 000	42	063		PA	208 LOGAN DR	INDIANA	03064	ARMSTRONG	960600	9606	4154.0453	157400	157400	143800	2015-10-31	1	1	1	1650	—	479.3357	491.5366	484.2775	BOOK 2015-267102	2015-267102	2026.2	2015
05-004-121.00 000	42	063		PA	40 SUNSET DR	INDIANA	06904	BLAIRSVILLE	962100	9621	1484.1791	158900	158900	141000	2017-10-12	2	1	1	1567	—	350.8006	356.6823	353.4637	BOOK 2017-286700	2017-286700	2026.2	2015
24-003-303.00 000	42	063		PA	5643 RTE 119 HWY N	INDIANA	36816	INDIANA	961103	9611.0300	882.2359	97500	97500	73400	2015-11-17	2	1	1	1384	—	383.4591	384.8217	384.0298	BOOK 2015-267491	2015-267491	2026.2	2015
10-031-622.00 000	42	063		PA	729 MCCONNELL RD	INDIANA	10352	BURRELL	962000	9620	649.0597	62300	62300	13600	2013-11-12	1	2	2	1120	—	300.3659	303.1725	301.4968	BOOK 2013-247711	2013-247711	2026.2	2015
10-003-104.02 000	42	063		PA	53 PINE LN	INDIANA	10352	BURRELL	962000	9620	35455.6996	200300	200300	9800	2016-07-30	2	1	1	1934	—	334.6636	370.7938	351.5825	BOOK 2016-277420	2016-277420	2026.2	2017
23-006-711.00 000	42	063		PA	350 S 5TH ST	INDIANA	36816	INDIANA	961104	9611.0400	680.1029	103400	103400	110300	2021-02-04	2	1	2	1320	—	382.9083	384.2019	383.4813	BOOK 2021-315911	2021-315911	2026.2	2015
23-006-624.00 000	42	063		PA	1019 WATER ST	INDIANA	36816	INDIANA	961104	9611.0400	421.6361	87800	87800	71500	2019-08-15	2	1	2	1756	—	386.1586	388.7198	387.0454	BOOK 2019-302762	2019-302762	2026.2	2015
43-026-107.00 000	42	063		PA	PO BOX 136	INDIANA	87160	YOUNG	961800	9618	359.0973	24800	24800		2015-04-24	1	2	2	990	—	347.7300	352.3044	349.6310	BOOK 2015-260533	2015-260533	2026.2	2015
21-003-523.00 000	42	063		PA	37 COOPER AVE	INDIANA	35408	HOMER CITY	961700	9617	1590.2156	93700	93700		2017-03-03	1	1	1	1118	—	306.6221	308.8112	307.7758	BOOK 2017-281113	2017-281113	2026.2	2015
42-037-400.00 000	42	063		PA	1405 SCHOOL HOUSE RD	INDIANA	84472	WHITE	960800	9608	2029.4675	815700	815700	131500	2012-03-15	1	1	2		—	386.9218	394.4838	391.6265	BOOK 2012-228876	2012-228876	2026.2	2015
06-002-621.00 000	42	063		PA	105 CORNELL AVE	INDIANA	06904	BLAIRSVILLE	962100	9621	875.0223	102300	102300		2013-07-23	1	1	1	1044	—	320.3044	325.7726	323.4284	BOOK 2013-248592	2013-248592	2026.2	2015
10-029-118.00 000	42	063		PA	PO BOX 261	INDIANA	10352	BURRELL	962000	9620	2297.5592	133700	133700			1	1	1	1428	—	310.8100	313.9624	312.7172	BOOK 0651-000671	0651-000671	2026.2	2015
25-003-100.01 000	42	063		PA	1146 WATER ST	INDIANA	36816	INDIANA	961000	9610	462.2939	90000	90000			1	1	1	1036	—	387.5244	390.2771	388.7560	BOOK 2009-201742	2009-201742	2026.2	2015
23-003-912.00 000	42	063		PA	55 S 5TH ST	INDIANA	36816	INDIANA	961200	9612	337.9057	171700	171700			1	1	2	928	—	394.7996	395.6499	395.2975	BOOK 1026-000473	1026-000473	2026.2	2015
12-036-425.00 000	42	063		PA	285 3RD AVE	INDIANA	12040	CENTER	961600	9616	1104.9451	105000	105000			1	1	1	1422	—	341.4823	344.6233	343.0973	BOOK 1221-000780	1221-000780	2026.2	2015
22-008-101.00 000	42	063		PA	333 N 7TH ST	INDIANA	36816	INDIANA	961000	9610	565.5228	96600	96600			1	1	2	1152	—	402.0901	404.4112	403.5453	BOOK 0952-000835	0952-000835	2026.2	2015
11-017-401.00 000	42	063		PA	403 BLAIR ST	INDIANA	11120	CANOE	960100	9601	639.6412	44000	44000			1	2	2	1632	—	408.6769	411.0574	409.8703	BOOK 1051-000839	1051-000839	2026.2	2015
42-040-202.00 000	42	063		PA	615 E PIKE RD	INDIANA	84472	WHITE	960900	9609	825.2075	141300	141300			2	1	2	1437	—	410.7388	412.2293	411.5244	BOOK 2008-189579	2008-189579	2026.2	2015
23-003-315.01 000	42	063		PA	240 S 4TH ST	INDIANA	36816	INDIANA	961200	9612	1212.9744	192400	192400			1	1	2	1986	—	380.8484	384.7960	383.3036	BOOK 2009-198941	2009-198941	2026.2	2015
22-001-300.00 000	42	063		PA	27 N 6TH ST	INDIANA	36816	INDIANA	961000	9610	219.8196	230400	230400	200000	2015-11-02	1	1			—	395.9021	397.0842	396.3880	BOOK 2015-267276	2015-267276	2026.2	2015
10-049-124.00 000	42	063		PA	934 BLAIRE RD	INDIANA	10352	BURRELL	962000	9620	1621.9491	180000	180000			1	1	1	1935	—	317.7795	321.3632	319.5464	BOOK 1522-000782	1522-000782	2026.2	2015