Saved query d72faf5fb20f0535

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

41/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '42' 
  AND countyfp = '013'

63,304 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelstate	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	saleamt	numbldgs	numunits	yearbuilt	numfloors	bedrooms	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	legaldesc	book	page	lrversion	taxyear
7473687049	0	42	013		PA						BLAIR	44328	LOGAN	010500	105	1817.3737	0	0	0	0	9	1	1	0	1	140			—		505.0776	507.8328	506.8892					PAGE 0456 LOT 6		0456	2026.2	2024
7483851452	0	42	013	214 SPRUCE AVE	PA						BLAIR	02184	ALTOONA	100700	1007	557.5336	0	0	0	0	10	2	1	0	1	11			—		387.6560	390.8034	389.4209					LOT 6			2026.2	2024
7493641448	0	42	013	802 S MAIN ST	PA						BLAIR	02184	ALTOONA	101800	1018	1114.9159	0	0	0	0	0	1	1	0	1	11			—		374.6714	378.2996	376.5749					LOT 69			2026.2	2024
0109-06 66	0	42	013	870 25TH ST	PA						BLAIR	02184	ALTOONA	100300	1003	401.4319	0	0	0	0	8	1	6	0	2	11			—		353.1077	355.0332	354.0035					LOT 66			2026.2	2024
E 02-0 00-027		42	013		PA	MUSSELMAN ROBERT E	447 UPPER CLAAR RD	CLAYSBURG	PA	16625	BLAIR	31000	GREENFIELD	011600	116	14234.6573											42013C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	449.6943	506.8402	480.9961			3.8100	PERSON		0344	0339	2026.2
E 02-0 00-009		42	013		PA	BROWN GARY L JR &	1190 BUTTERMILK HOLLOW ROAD	CLAYSBURG	PA	16625	BLAIR	31000	GREENFIELD	011600	116	2134.0279											42013C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	437.9530	450.8669	443.2008			0.8700	PERSON		1333	0994	2026.2
E 02-0 00-024		42	013		PA	MUSSELMAN ROBERT E	447 UPPER CLAAR RD	CLAYSBURG	PA	16625	BLAIR	31000	GREENFIELD	011600	116	22968.7328											42013C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	450.1431	512.6970	484.0136			5.4400	PERSON		0334	0178	2026.2
G 03-0 00-005-A		42	013		PA	DETWILER JOY K	15665 DUNNINGS HIGHWAY	DUNCANSVILLE	PA	16635	BLAIR	76160	TAYLOR	011500	115	14657.5837											42013C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	418.7792	427.4025	421.9101			2.6150	PERSON		1374	0398	2026.2
F 02-0 00-003-A		42	013		PA	DICK GARY L & PATRICIA A	901 KEITH STREET	ROARING SPRING	PA	16673	BLAIR	76160	TAYLOR	011500	115	35564.7447											42013C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	428.9769	440.9838	435.5102			6.0950	PERSON		1150	903	2026.2
E 02-0 00-021		42	013		PA	BROWN GARY L	563 UPPER CLAAR ROAD	CLAYSBURG	PA	16625	BLAIR	31000	GREENFIELD	011600	116	3877.5178											42013C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	437.0024	454.0710	444.2006			0.9700	PERSON		0173	0024	2026.2
F 03-0 00-036		42	013		PA	BURKET DENNIS & KAY 1/2 INT&	125 BAXTER DR	CLAYSBURG	PA	16625	BLAIR	31000	GREENFIELD	011600	116	244122.7658											42013C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	539.9807	615.4646	576.0430			61.5910	BUSINESS		0647	0238	2026.2
7490186385	0	42	013		PA						BLAIR	27600	FRANKSTOWN	010900	109	1388.5414	0	0	0	0	6			0		80			—		368.9674	372.2961	370.5961	1300	RESIDENTIAL			PAGE 0971 LOT 25		0971	2026.2	2024
7491602643	0	42	013		PA						BLAIR	27600	FRANKSTOWN	010900	109	3466.2263	0	0	0	0	1			0		80			—		363.8803	381.4491	371.9800	1300	RESIDENTIAL			PAGE 0879 LOT 48		0879	2026.2	2024
7483742688	0	42	013	430 BEECH AVE	PA						BLAIR	02184	ALTOONA	100700	1007	260.1444	0	0	0	0	0	1	1	0	2	11			—		379.9382	382.6228	381.6475					LOT 22			2026.2	2024
8315768496	0	42	013		PA						BLAIR	55592	NORTH WOODBURY	011300	113	3632.5694	0	0	0	0	9	1		0		170			—		416.9147	419.8039	418.7118					PAGE 0665 LOT 14		0665	2026.2	2024
7483727664	0	42	013		PA						BLAIR	02184	ALTOONA	101900	1019	1530.5397	0	0	0	0	12			0		11			—		366.2439	370.5936	368.8695					PAGE 0724 LOT 1		0724	2026.2	2024
8405007852	0	42	013		PA						BLAIR	02680	ANTIS	010403	104.0300	696.6048	0	0	0	0	3			0		30			—		323.3173	323.7948	323.5173					PAGE 0525 LOT 25		0525	2026.2	2024
8530248353	0	42	013		PA						BLAIR	71624	SNYDER	010101	101.0100	24272.3849	0	0	0	0	8			0		190			—		438.2691	473.9896	463.6577					PAGE 0927 LOT 7		0927	2026.2	2024
7389085809	0	42	013		PA						BLAIR	20248	DUNCANSVILLE	011101	111.0100	481.4430	0	0	0	0	1			0		70			—		304.3299	305.0806	304.6619					PAGE 0571 LOT 52		0571	2026.2	2024
0114-36 29	0	42	013		PA						BLAIR	02184	ALTOONA	101200	1012	190.5388	0	0	0	0	10			0		11			—		323.5544	323.7535	323.6545					PAGE 0188 LOT 29		0188	2026.2	2024
7355121800	0	42	013		PA						BLAIR	31000	GREENFIELD	011600	116	1058.2890	0	0	0	0	7			0		100			—		753.6649	758.0978	755.9287					PAGE 0003 LOT 51		0003	2026.2	2024
7375610364	0	42	013		PA						BLAIR	31000	GREENFIELD	011600	116	119506.8753	0	0	0	0	6			0		100			—		436.4126	600.6830	507.1208					PAGE 0985 LOT 87		0985	2026.2	2024
7483650925	0	42	013		PA						BLAIR	02184	ALTOONA	100600	1006	551.1212	0	0	0	0	12			0		11			—		386.8141	389.1394	388.4067					PAGE 0464 LOT 76		0464	2026.2	2024
7385076764	0	42	013		PA						BLAIR	76160	TAYLOR	011500	115	69579.6047	0	0	0	0	12			0		200			—		446.0902	545.7015	494.8490					PAGE 0284 LOT 47		0284	2026.2	2024
7491602756	0	42	013		PA						BLAIR	27600	FRANKSTOWN	010900	109	464.7134	0	0	0	0	0			0		0			—		369.2399	381.8502	375.0509	1300	RESIDENTIAL			LOT 67			2026.2	2024