Saved query 2f5ebd49fb6ed092

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

57,200 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	ownertype	naicscode	legaldesc	book	page	placename	placetype	taxyear
S12-034-050-00	42	111	114 HARTEIS LN	JOHNSTOWN	PA	15905	JORDAN ROBERT H & CAROL A	114 HARTEIS LN	JOHNSTOWN	PA	15905	Somerset	15568	Conemaugh	020101	201.0100	2477.2338	73600	9100	82700		1	1	42111C	2025-12-21	AE		382.6339	384.1782	383.5037	RRE	PERSON	6216	LOTS 3 TO 5 PT LOT 2	1608/478		JORDAN TREE SERVICE	HOME_SERVICE	0
S45-025-042-00	42	111	320 E MAIN ST	STOYSTOWN	PA	15563	ZIMMERMAN JEFFREY R	320 E MAIN ST PO BOX 121	STOYSTOWN	PA	15563	Somerset	74672	Stoystown	020500	205	1062.1554	34500	10800	45300	1	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	591.6316	596.0566	594.3042	RRE	PERSON		1 LOT BEING 0.25 A	1047/670				0
S08-013-071-00	42	111	2248 MAPLE VALLEY RD	BERLIN	PA	15530	SUDER DAN L & VIRGINIA R	2248 MAPLE VALLEY ROAD	BERLIN	PA	15530	Somerset	09256	Brothersvalley	021400	214	129867.8057	70630	24170	94800	415000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	697.5952	732.1320	710.0912	AAT	PERSON		33.221 A	2477/869				1998
S12-054-072-01	42	111	128 ALYSHA LN	TIRE HILL	PA	15959	MARISA MARIO D ET AL	128 ALYSHA LN	TIRE HILL	PA	15959	Somerset	15568	Conemaugh	020102	201.0200	17740.5438	113510	15430	128940	1	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	410.3582	424.0298	418.0397	RRE	PERSON		4.07 A	2272/343	70			0
S34-002-100-05	42	111	517 SPRUCE RUN RD	WINDBER	PA	15963	SMITH KYLE JR	517 SPRUCE RUN ROAD	WINDBER	PA	15963	Somerset	57552	Paint	020200	202	98743.3539	124080	1470	125550	390000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	548.4870	573.1499	555.3002	AAB	PERSON		24.397 A	2922/493				2023
S47-001-056-00	42	111	415 KANAUL RD	ROCKWOOD	PA	15557	BROWN JACOB S	415 KANAUL RD	ROCKWOOD	PA	15557	Somerset	79336	Upper Turkeyfoot	021903	219.0300	8920.1095	60830	12070	72900	145000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	663.1201	667.4177	665.4630	RRE	PERSON		2.205 A	3091/947				0
S42-010-012-03	42	111	608 SAMUELS RD	SOMERSET	PA	15501	SCHROCK KIRK D	608 SAMUELS RD	SOMERSET	PA	15501	Somerset	71784	Somerset	020801	208.0100	30349.7362	136180	24410	160590	230000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	655.2141	678.1426	673.5011	RRE	PERSON		7.5 A	1221/111				0
S26-031-132-00	42	111	136 KEYSTONE ST	MEYERSDALE	PA	15552	BRENNEMAN DIANNA M	136 KEYSTONE ST	MEYERSDALE	PA	15552	Somerset	48912	Meyersdale	021600	216	1657.2940	17940	8960	26900	28000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	600.9787	615.8659	606.2476	RRE	PERSON		LOTS 324 TO 326	2650/68				0
S12-075-009-00	42	111	149 CHERRY TREE DR	JOHNSTOWN	PA	15904	LE DIEP T	201 KENNETH AVE	JOHNSTOWN	PA	15904	Somerset	15568	Conemaugh	020102	201.0200	1926.3798	75720	9980	85700	225000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	561.8618	573.1984	567.7914	RRE	PERSON		LOT 22 & 1/2 LOT 21 BNG 0.41 A	3060/44				0
S31-004-011-00	42	111	2298 SCHOOLHOUSE RD	CONNELLSVILLE	PA	15425	MAURO LOUIS G & TERRI LEE	106 E CEDAR AVE	CONNELLSVILLE	PA	15425	Somerset	54704	Northampton	021300	213	10278.3019	28120	10590	38710	1000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	706.0064	718.8603	712.5293	RRT	PERSON		2.851 A	1290/191				0
S25-003-014-00	42	111	363 CRANBERRY RD	MURRYSVILLE	PA	15668	KRAL JANET	4766 CHRISTY RD	MURRYSVILLE	PA	15668	Somerset	45136	Lower Turkeyfoot	021904	219.0400	1581.0767	20950	7150	28100	4000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	710.6199	720.9091	716.4511	RRE	PERSON		0.383 A	1428/1097				0
S21-009-216-00	42	111	3240 PENN AVE	BOSWELL	PA	15531	BECKNER RONALD G & BRENDA K	3240 PENN AVE	BOSWELL	PA	15531	Somerset	38032	Jenner	020601	206.0100	3987.8413	56900	9900	66800	87500	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	581.8764	590.4390	586.7453	RRE	PERSON		1.0 A	1416/205				0
S05-021-106-00	42	111	418 DIAMOND ST	BERLIN	PA	15530	WALKER AMANDA R	418 DIAMON STREET	BERLIN	PA	15530	Somerset	05776	Berlin	021400	214	544.8650	43920	9080	53000	53000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	705.5849	707.8884	706.9068	RRE	PERSON		PT LOTS 31 32	3018/837				0
S42-006-141-00	42	111	339 LAVANSVILLE RD	SOMERSET	PA	15501	BOWLBY GREGORY A & CARVER A	339 LAVANSVILLE ROAD	SOMERSET	PA	15501	Somerset	71784	Somerset	020801	208.0100	6242.3622	14500	14860	29360	1	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	635.5682	644.2282	639.5402	RRT	PERSON		0.806 A LAVANSVILLE	3074/945				0
S26-030-071-00	42	111	419 SALISBURY ST	MEYERSDALE	PA	15552	DIFEBO JAMES D ET AL	419 SALISBURY ST	MEYERSDALE	PA	15552	Somerset	48912	Meyersdale	021600	216	986.5657	59930	8270	68200	1	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	605.1832	608.2185	606.7040	RRE	PERSON		LOT 26 1/2 27	2797/202				0
S42-002-002-00	42	111	2388 COXES CREEK RD	SOMERSET	PA	15501	GREIG MARK D & JENNIFER L	2388 COXES CREEK RD	SOMERSET	PA	15501	Somerset	71784	Somerset	020801	208.0100	67280.0361	43270	28710	71980	53000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	650.4264	683.3123	665.7944	AAB	PERSON		13.20 A	1028/423				0
S28-010-053-00	42	111	2711 CASSELMAN RD	ROCKWOOD	PA	15557	MILLER W JAY JR ET AL	2873 CASSELMAN RD	ROCKWOOD	PA	15557	Somerset	49416	Milford	021800	218	65245.6294	43730	23400	67130	1	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	547.0115	587.5466	563.5766	AAO	PERSON		14.06 A FEE	2882/126				0
S12-074-089-00	42	111	1781 TIRE HILL RD	DAVIDSVILLE	PA	15928	PAULEY RONALD D & LINDA R	1781 TIRE HILL ROAD	DAVIDSVILLE	PA	15928	Somerset	15568	Conemaugh	020102	201.0200	1402.4201	62270	24830	87100	108900	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	556.2278	561.4810	559.6866	RRE	PERSON		LOT 6 BNG 0.34 A	2596/389				0
S20-034-032-00	42	111	569 LAUREL CT	HIDDEN VALLEY	PA	15502	TRI-COUNTY ABSTRACT AGENCY LLC	569 LAUREL CT PO BOX 4367	HIDDEN VALLEY	PA	15502	Somerset	37920	Jefferson	020700	207	33.1672	45740	23160	68900	100000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	839.5693	839.9002	839.7384	RTN	BUSINESS	53132	0.037 A TOWNHOUSE UNIT B	2679/70				0
S44-009-001-99	42	111	511 BLUEBERRY WAY	CENTRAL CITY	PA	15926	ZUCCOLOTTO ADAM L & AMY S	511 BLUEBERRY WAY	CENTRAL CITY	PA	15926	Somerset	74440	Stonycreek	021200	212	20549.4952	58400	19020	77420	230000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	856.3994	867.9424	861.4261	RRE	PERSON		TRACT 63 BNG 5.01 A	3163/58				0
S42-069-012-00	42	111	737 TAYLOR RD	FRIEDENS	PA	15541	MARPLE GEORGE & GEORGIA	737 TAYLOR RD	FRIEDENS	PA	15541	Somerset	71784	Somerset	020900	209	1806.1592	115510	9540	125050	13500	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	626.6311	632.8764	629.7941	RRE	PERSON		LOTS 8 BLK K BNG 0.42 A	1798/694				0
S08-028-007-00	42	111	163 BIG DOG LN	BERLIN	PA	15530	WALKER LOGAN & SHROYER SIERRA	163 BIG DOGS LN	BERLIN	PA	15530	Somerset	09256	Brothersvalley	021400	214	681.9682	71900	19000	90900	100000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	669.4029	676.8036	673.1217	RRE	PERSON		47 LOTS BEING 5.000 A	2924/110				0
S42-004-055-06	42	111	710 SECHLER RD	FRIEDENS	PA	15541	IGOU SETH	490 LISTIE RD	FRIEDENS	PA	15541	Somerset	71784	Somerset	020900	209	48621.6273	43970	5240	49210	49155	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	667.7237	693.0263	677.5862	AAB	PERSON		12.0 A	2793/515				1998
S12-007-181-00	42	111	519 E CAMPUS AVE	DAVIDSVILLE	PA	15928	BERCHICK LORI A	519 E CAMPUS AVENUE	DAVIDSVILLE	PA	15928	Somerset	15568	Conemaugh	020102	201.0200	2713.0749	66590	9020	75610	139000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	543.3339	546.7780	545.1531	RRE	PERSON		0.510 A	2538/35				0
S39-009-004-00	42	111	WHISTLER RD	FRIEDENS	PA	15541	FOUST JAMES DALE JR	132 SADDLEBROOK RD	FRIEDENS	PA	15541	Somerset	69448	Shade	020400	204	3744.8667	480	4950	5430	10000	1	1	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	525.4549	536.8773	530.9027	RRE	PERSON		1 A	1934/455				0