Saved query 272d2c0eca9ec0aa

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

44/80

Live SQL

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

57,263 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parcelstate	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	landvalue	totalvalue	numunits	bldgsqft	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	ownertype	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxdistrict
0120001100	0070	42	111	PA	DETRICK COLIN R-KEITH L ET UX	413 SCENIC LN	RIDGELEY	WV	26753	SOMERSET	71920	SOUTHAMPTON	021300	213	436.0371	2700	2700	0	0	42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	628.5640	644.9381	636.9943	0.5000	PERSON	1/2A	00377	0047						2026.2	ALLE
B 09-0 00-143		42	111	PA	SARVER ALFRED GLENN II	178 RIDDLEMOSER ROAD	SCHELLSBURG	PA	15559	SOMERSET	00876	ALLEGHENY	021300	213	12286.8069					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	592.2474	626.1539	610.6486	6.9000	PERSON		1451	0373						2026.2
B 06-0 00-032		42	111	PA	WIKER RALPH L III	PO BOX 396	NEW PARIS	PA	15554	SOMERSET	69448	SHADE	020400	204	5403.9145					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	795.8203	799.9342	797.5197	2.0050	PERSON		1324	0987						2026.2
B 06-0 00-003-C		42	111	PA	ACKER DONALD L	1755 LINCOLN HWY EAST	LANCASTER	PA	17602	SOMERSET	69448	SHADE	020400	204	3589.0547					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	783.0209	791.2537	788.2431	0.8960	PERSON		0635	0655						2026.2
B 10-0 00-096		42	111	PA	SARVER ALFRED GLENN II	178 RIDDLEMOSER RD	SCHELLSBURG	PA	15559	SOMERSET	00876	ALLEGHENY	021300	213	56339.9294					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	535.4957	581.1370	563.3800	10.4900	PERSON		1093	834						2026.2
B 06-0 00-041		42	111	PA	KLINGLER GEORGE A	1260 BOWER RD	SHERMANSDALE	PA	17090	SOMERSET	69448	SHADE	020400	204	5095.8174					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	793.6179	797.2825	795.3783	1.4890	PERSON		0443	0382						2026.2
B 10-0 00-023-A		42	111	PA	WILL PAULINE	240 GLADE PIKE	BUFFALO MILLS	PA	15534	SOMERSET	00876	ALLEGHENY	021300	213	16607.8036					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	500.2056	531.9858	521.0573	6.7500	PERSON		935	772						2026.2
B 08-0 00-220		42	111	PA	DAY RICHARD R	P O BOX 72	ARMBRUST	PA	15616	SOMERSET	00876	ALLEGHENY	021300	213	22518.5804					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	814.4840	858.7669	828.8960	5.0300	PERSON		0368	0572						2026.2
B 08-0 00-198		42	111	PA	DONIA ANTHONY W	322 BUCKTAIL ROAD	CENTRAL CITY	PA	15926	SOMERSET	00876	ALLEGHENY	021300	213	26485.3423					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	838.5927	884.7832	866.9746	5	PERSON		1125	543						2026.2
B 06-0 00-036		42	111	PA	BROWN JEFFREY T & JENNY L	511 BYERLAND CHURCH RD	WILLOW STREET	PA	17584	SOMERSET	69448	SHADE	020400	204	4411.5679					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	793.9290	796.2467	794.7743	1.0100	PERSON		2013	2385						2026.2
B 08-0 00-279		42	111	PA	KALP JOSHUA G & DANIELLE L	207 FORT DE WART LANE	CENTRAL CITY	PA	15926	SOMERSET	00876	ALLEGHENY	021300	213	58295.5152					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	795.0981	811.0834	801.8828	5.0100	PERSON		1538	0713						2026.2
B 09-0 00-084		42	111	PA	SARVER ALFRED GLENN II	178 RIDDLEMOSER ROAD	SCHELLSBURG	PA	15559	SOMERSET	00876	ALLEGHENY	021300	213	7011.2545					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	599.5683	614.1821	608.6000	3.0700	PERSON		1451	0373						2026.2
B 08-0 00-254		42	111	PA	BAZZO ANTHONY DAVID	BOX 188	RILLTON	PA	15678	SOMERSET	00876	ALLEGHENY	021300	213	28197.0421					42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	805.4249	827.8654	811.9266	7.2900	PERSON		0664	0222						2026.2
B 13-0 00-027		42	111	PA	COMMONWEALTH OF PA	STATE CAPITOL	HARRISBURG	PA	17101	SOMERSET	24680	FAIRHOPE	021300	213	2267338.5190					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				555.2000	GOVERNMENT				GOVT STATE	RESTRICTED	OTHER	STATE GAME LAND 104	STATE RESOURCE MANAGEMENT AREA	2026.2
B 08-0 00-237		42	111	PA	SHUGARS MICHAEL	NO 22 2ND ST PO BOX 226	CAIRNBROOK	PA	15924	SOMERSET	69448	SHADE	020400	204	47213.8417					42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	893.4016	905.0207	898.5196	10	PERSON		1233	44						2026.2
B 06-0 00-030		42	111	PA	LEBER DARLENE C	3230 OAKLAND RD #16	DOVER	PA	17315	SOMERSET	69448	SHADE	020400	204	5773.6363					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	790.6320	794.7763	792.9188	1.5160	PERSON		0433	0372						2026.2
B 09-0 00-089		42	111	PA	SARVER ALFRED GLENN II	178 RIDDLEMOSER ROAD	SCHELLSBURG	PA	15559	SOMERSET	00876	ALLEGHENY	021300	213	5994.9585					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	596.0022	607.9734	601.7013	2.2559	PERSON		1451	0373						2026.2
B 06-0 00-037		42	111	PA	BROWN JEFFREY T & JENNY L	511 BYERLAND CHURCH RD	WILLOW STREET	PA	17584	SOMERSET	69448	SHADE	020400	204	5769.0404					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	793.7960	799.3735	796.2408	1.3550	PERSON		2013	2385						2026.2
B 09-0 00-142		42	111	PA	HUTNIK MICHAEL J	105 HOLLY DRIVE	CANONSBURG	PA	15317	SOMERSET	00876	ALLEGHENY	021300	213	6870.1480					42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	614.4497	626.0598	619.9851	1.6000	PERSON		1506	0895						2026.2
B 06-0 00-040		42	111	PA	KUEHL THOMAS J II &	3615 HILTY ROAD	EXPORT	PA	15632	SOMERSET	69448	SHADE	020400	204	5518.6539					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	779.1993	793.1840	786.0857	0.9570	PERSON		1401	0846						2026.2
B 08-0 00-262		42	111	PA	LAMKIE RICHARD J & KAREN M	2176 FLEEGLE RD	CENTRAL CITY	PA	15926	SOMERSET	00876	ALLEGHENY	021300	213	19242.5899					42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	787.0198	795.7597	792.3399	5.0010	PERSON		1567	392						2026.2
B 06-0 00-031		42	111	PA	LEBER DARLENE C	3230 OAKLAND RD #16	DOVER	PA	17315	SOMERSET	69448	SHADE	020400	204	4797.2462					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	793.0245	796.1401	794.8079	1.2980	PERSON		0436	0687						2026.2
B 09-0 00-094		42	111	PA	HUTNIK MICHAEL J	105 HOLLY DRIVE	MCMURRAY	PA	15317	SOMERSET	00876	ALLEGHENY	021300	213	6017.0592					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	609.9318	618.2810	614.0246	4.8620	PERSON		1506	0895						2026.2
B 10-0 00-022		42	111	PA	FLEMING JAMES D	116 C DIEHL RD	MANNS CHOICE	PA	15550	SOMERSET	00876	ALLEGHENY	021300	213	108155.1905					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	458.0920	648.2116	532.8536	23.3100	PERSON		0541	0526						2026.2
B 11-0 00-001		42	111	PA	MCCULLEN LARRY W SR	200 MCCULLEN DR	BUFFALO MILLS	PA	15534	SOMERSET	00876	ALLEGHENY	021300	213	394355.9328					42111C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	565.9354	643.6373	599.5969	91.4400	PERSON		1470	0966						2026.2