Saved query a7f9d8678d8b26f4

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

33,785 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	numbldgs	numunits	yearbuilt	bldgsqft	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	ownertype	naicscode	legaldesc	book	page	placename	placetype	taxdistrict
0103007170	0019	42	009	14200 DOUBLE PINE RD NE	FLINTSTONE	PA	21530	PINEY RUN GUN CLUB INC	13505 BEALLS MILL RD NE	CUMBERLAND	MD	21502	BEDFORD	46928	MANN	961001	9610.0100	2847.8643	45600	82200	127800		1	1	1882	872	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	322.8411	333.3017	328.2121	27.5800	NONPROFIT		IMPS27.582A	00355	0347			ALLE
0134005214	0128	42	009			PA		HELM MICHAEL A	PSC 2 BOX 5879	APO AE	FC	09012	BEDFORD	17664	CUMBERLAND VALLEY	961100	9611	2857.2554		800	800	800		0		0	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	249.8142	281.3441	261.9120	0.0800	PERSON		14431 HAZEN RD ADJ	02170	0068			ALLE
E 09-D 04-144		42	009			PA		LAWTHER MANOR INC	136 E PITT ST	BEDFORD	PA	15522	BEDFORD	04944	BEDFORD	960700	9607	1508.0633									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	333.2916	335.9126	334.9504	0.3300	BUSINESS	7224		0477	0489	THE NOTEWORTHY VENUE OF BEDFORD…	BAR	BEDFORD BORO
D 08-0 00-300		42	009			PA		ERICKSON ANDREW A & DEBRA	112 SOUTH BEDFORD ST	BEDFORD	PA	15522	BEDFORD	04952	BEDFORD	960800	9608	104307.0293									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	344.0383	375.1484	359.9236	22.2480	PERSON	7225		1378	0626	BIG B'S BBQ	RESTAURANT	BEDFORD TWP
F 08-0 00-004-A		42	009			PA		KING GLORIA A	212 KOONTZ ROAD	BEDFORD	PA	15537	BEDFORD	04952	BEDFORD	960800	9608	5478.0807									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	353.4097	366.0934	357.4505	1.7200	PERSON	457		748	424	SHEETZ	GAS_STATION	BEDFORD TWP
D 07-0 00-262		42	009			PA		MILLER THOMAS M & DAVID J	C/O THOMAS M MILLER	SCHELLSBURG	PA	15559	BEDFORD	21788	EAST ST. CLAIR	960300	9603	393907.3064									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	346.3856	422.9754	371.1531	109.1680	PERSON	6111		890	144	CHESTNUT RIDGE HIGH SCHOOL	HIGH_SCHOOL	EAST ST CLAIR TWP
G 08-0 00-083-C		42	009			PA		HANKS HARRY A	1780 RAYSTOWN RD	EVERETT	PA	15537	BEDFORD	35656	HOPEWELL	960400	9604	5789.4016									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	377.7622	392.4608	385.3367	1.4700	PERSON			0253	0035			HOPEWELL TWP
E 09-E 04-147-A		42	009			PA		GRIMES J DEAN	244 REPLOGLE SCHOOL RD	NEW ENTERPRISE	PA	16664	BEDFORD	04944	BEDFORD	960700	9607	932.0917									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	323.4345	324.2538	323.8116	0.2410	PERSON			920	003			BEDFORD BORO
F 08-0 00-076		42	009			PA		WEAVER DOROTHY J ET AL	832 IMLERTOWN RD	BEDFORD	PA	15522	BEDFORD	04952	BEDFORD	960800	9608	2212.9712									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	357.9787	366.7318	362.6746	1.5240	PERSON			1524	0459
F 06-0 00-116		42	009			PA		BECHTEL JOHN W & KIM M	5181 CHURCHVIEW ROAD	NEW ENTERPRISE	PA	16664	BEDFORD	72656	SOUTH WOODBURY	960400	9604	89124.7859									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	392.5162	410.2989	400.8515	21.8000	PERSON			1494	0175			SOUTH WOODBURY BORO
B 14-E 04-122		42	009			PA		LEYDIG FAY E &	PO BOX 585	HYNDMAN	PA	15545	BEDFORD	36640	HYNDMAN	961100	9611	714.5675									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	287.6824	289.7040	288.9751	0.1510	PERSON			1377	0974			HYNDMAN BORO
I 05-0 00-029		42	009			PA		HEATON WILLIAM H ETAL	12270 EAST COLE RD	NORTH EAST	PA	16428	BEDFORD	08880	BROAD TOP	960500	9605	38246.6235									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	376.6385	398.1395	384.7713	2.5350	PERSON			1104	858			BROAD TOP TWP
E 09-D 05-019		42	009			PA		ROSE CAROL ANN	238 S RICHARD ST	BEDFORD	PA	15522	BEDFORD	04944	BEDFORD	960700	9607	651.4346									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	333.8996	335.0126	334.5226	0.1409	PERSON			1051	064			BEDFORD BORO
E 09-D 03-021		42	009			PA		G & N REALTY INC	PO BOX 674	BEDFORD	PA	15522	BEDFORD	04944	BEDFORD	960700	9607	679.3639									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	326.4199	331.2090	328.7370	0.1390	BUSINESS			1044	662			BEDFORD BORO
G 13-0 00-094		42	009			PA		HALL JEFFREY	339 MILLS STORE RD	CLEARVILLE	PA	15535	BEDFORD	50424	MONROE	961001	9610.0100	7897.2776									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	319.5362	337.8572	327.6673	1.8200	PERSON			1435	0364			MONROE TWP
D 06-0 00-150		42	009			PA		HOLLAND STANFORD	ROBERT HOLLAND	FISHERTOWN	PA	15539	BEDFORD	21788	EAST ST. CLAIR	960300	9603	7158.6057									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	354.6535	363.0995	357.3691	3.2300	PERSON			0241	0581			EAST ST CLAIR TWP
D 13-0 00-085		42	009			PA		HARTMAN CRAIG	347 RAINSBURG MOUNTAIN ROAD	BEDFORD	PA	15522	BEDFORD	17664	CUMBERLAND VALLEY	961100	9611	19579.9014									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	489.8452	517.6615	502.1561	5	PERSON			1309	0884			CUMBERLAND VALLEY TWP
E 09-D 07-011		42	009			PA		MOXLEY SCOTT J	808 HALL ST	BEDFORD	PA	15522	BEDFORD	04944	BEDFORD	960700	9607	1099.7054									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	350.2234	355.6119	353.3551	0.2600	PERSON			1473	0540			BEDFORD BORO
D 12-0 00-121		42	009			PA		BROWELL TODD M	385 HOWSARE LN	BEDFORD	PA	15522	BEDFORD	17664	CUMBERLAND VALLEY	961100	9611	20079.0937									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	440.3595	491.9112	468.5263	5.1300	PERSON			939	811			CUMBERLAND VALLEY TWP
D 06-0 00-128-B		42	009			PA		BROWN TROY W	212 OLD QUAKER CHURCH RD	FISHERTOWN	PA	15539	BEDFORD	21788	EAST ST. CLAIR	960300	9603	2005.9838									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	348.2799	349.4097	348.9518	0.4460	PERSON			1137	516			EAST ST CLAIR TWP
I 06-0 00-015		42	009			PA		DRENNING JAMES W	359 BUNKER HILL RD	SIX MILE RUN	PA	16679	BEDFORD	08880	BROAD TOP	960500	9605	190872.8145									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	415.3572	535.7357	471.1374	19.4200	PERSON			1230	71			BROAD TOP TWP
E 09-D 06-142		42	009			PA		IRVIN LISA LOUISE	718 PRESTON ST	BEDFORD	PA	15522	BEDFORD	04944	BEDFORD	960700	9607	1776.4523									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	342.9264	345.5806	343.7545	0.4000	PERSON			0699	0524			BEDFORD BORO
F 16-0 00-024-V		42	009			PA		NORTHCRAFT RONNIE D	801 LASHLEY ROAD	ARTEMAS	PA	17211	BEDFORD	46928	MANN	961001	9610.0100	34885.5848									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	315.6051	347.1040	336.1455	8.8000	PERSON			1236	905			MANN TWP
B 14-F 04-038		42	009			PA		SIVITS DANIEL W	PO BOX 427	HYNDMAN	PA	15545	BEDFORD	36640	HYNDMAN	961100	9611	1185.3380									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	283.2231	283.9383	283.5355	0.3140	PERSON			1122	862			HYNDMAN BORO
E 09-D 02-019		42	009			PA		MICHAEL SUSAN L	800 MILLER RD	CLEARVILLE	PA	15535	BEDFORD	04952	BEDFORD	960800	9608	511.9474									42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	382.4653	388.2376	385.4080	0.2340	PERSON			1105	312			BEDFORD TWP