Saved query bdb574d555856f5a

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

33,815 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	ownertype	naicscode	book	page	placename	placetype	taxdistrict
H 13-0 00-015-A	42	009	814 ALLEN ROAD	CLEARVILLE	PA	15535	FEOLA RICHARD T	25121 SILVER CREST DR	GAITHERSBURG	MD	20879	BEDFORD	50424	MONROE	961001	9610.0100	78189.8202	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	346.3442	391.0338	376.5839	11.8600	PERSON	48811	0063	0220	GREATER BREEZEWOOD REGIONAL AIR…	AIRPORT	MONROE TWP
C 07-0 00-011	42	009	4355 CORTLAND ROAD		PA	15554	ANDERSON RONALD C	4355 CORTLAND ROAD	NEW PARIS	PA	15554	BEDFORD	52648	NAPIER	960900	9609	24518.8606	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	372.6898	378.6000	375.0857	5	PERSON	11111	1580	0065	NINOVAN HOMESTEAD	FARM	NAPIER TWP
G 09-B 06-182	42	009	220 WEST MAIN STREET	EVERETT	PA	15537	TORRES ROBIN G & FLORA M	439 HOSPITAL DR	EVERETT	PA	15537	BEDFORD	24304	EVERETT	960600	9606	780.6955	42009C	2025-12-21	X	AREA WITH REDUCED FLOOD RISK DU…	308.7545	309.7904	309.2261	0.2500	PERSON		0178	0208	WAY TO WELLNESS	COMPLEMENTARY_AND_ALTERNATIVE_M…	EVERETT BORO
G 05-0 00-306	42	009	252 NORTH ROAD	NEW ENTERPRISE	PA	16664	REPLOGLE ALLEN L	252 NORTH RD	NEW ENTERPRISE	PA	16664	BEDFORD	72656	SOUTH WOODBURY	960400	9604	11774.9632	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	367.2700	384.7212	375.2617	2.3470	PERSON		0610	0384	AWARDING IMAGES	PRINTING_SERVICE	SOUTH WOODBURY BORO
C 06-0 00-048	42	009			PA	15554	HARRIS GUILLERMO V & ELEANOR	5178 CORTLAND RD	NEW PARIS	PA	15554	BEDFORD	83972	WEST ST. CLAIR	960300	9603	159288.8202	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	362.1211	369.6903	365.2864	38.1500	PERSON	6216	1153	162	METAL PLUS CONSTRUCTION	HOME_SERVICE	WEST ST CLAIR TWP
D 06-0 00-193	42	009	CHESTNUT RIDGE HIGH SCHOOL	EAST ST. CLAIR	PA	15554	CHESTNUT RIDGE HIGH SCHOOL	GENERAL DELIVERY	FISHERTOWN	PA	15539	BEDFORD	21788	EAST ST. CLAIR	960300	9603	298695.5097	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	358.2253	419.1174	386.5378	71.6100	PERSON	611110			CHESTNUT RIDGE SCHOOL DISTRICT	ELEMENTARY_SCHOOL	EAST ST CLAIR TWP
G 10-D 01-025-C	42	009	1900 WINDING RIDGE ROAD	EVERETT	PA	15537	FANN WILLIAM	1900 WINDING RIDGE ROAD	EVERETT	PA	15537	BEDFORD	83920	WEST PROVIDENCE	960600	9606	8263.4605	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	364.1112	388.2255	374.6951	2.2000	PERSON		0657	0055			WEST PROVIDENCE TWP
F 06-0 00-200	42	009	262 OAK HILL ROAD	NEW ENTERPRISE	PA	16664	ZIMMERMAN LEE L	1666 RIDGE RD	NEW ENTERPRISE	PA	16664	BEDFORD	72656	SOUTH WOODBURY	960400	9604	16342.7315	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	425.1377	462.7824	442.6099	4.1080	PERSON		1211	617			SOUTH WOODBURY BORO
D 10-0 00-050-E	42	009	4825 MILLIGANS COVE ROAD	SOMERSET	PA	15550	ROBYN ERIC W & SALLY	188 KINGFISHER CIRCLE	POOLER	GA	31322	BEDFORD	32840	HARRISON	960900	9609	67513.8088	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	423.5097	501.2795	455.8180	14.7100	PERSON		1560	951			HARRISON TWP
D 06-0 00-396	42	009	453 RIDGEWOOD DRIVE	EAST ST. CLAIR	PA	15554	STUART RANDALL K	415 RIDGEWOOD DR	NEW PARIS	PA	15554	BEDFORD	21788	EAST ST. CLAIR	960300	9603	2577.7671	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	447.7828	452.1354	450.4140	0.7900	PERSON		807	342			EAST ST CLAIR TWP
G 09-0 00-033-B	42	009	124 LACKAWANNA ROAD	EVERETT	PA	15537	CALHOUN ALLEN E & JOANNE L	163 LEPLEY RD	EVERETT	PA	15537	BEDFORD	83920	WEST PROVIDENCE	960600	9606	1349.4579	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	334.8753	341.0737	338.2448	0.5000	PERSON		0303	0343			WEST PROVIDENCE TWP
G 04-0 00-140-A	42	009	245 MILL STREET	WOODBURY	PA	16695	WEAVER DAVID A SR	245 MILL ST	WOODBURY	PA	16695	BEDFORD	86136	WOODBURY	960100	9601	2351.3634	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	398.1187	399.6994	398.8280	0.5000	PERSON		1073	909			WOODBURY TWP
H 11-0 00-075	42	009	891 EAST MATTIE ROAD	BREEZEWOOD	PA	15533	SNYDER AMELIA SUE	1000 E MATTIE RD	BREEZEWOOD	PA	15533	BEDFORD	21736	EAST PROVIDENCE	960500	9605	343203.7991	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	363.9683	420.4903	395.7605	104.6130	PERSON		1048	567			EAST PROVIDENCE TWP
C 07-E 03-011	42	009	3986 CORTLAND DRIVE	NEW PARIS	PA	15554	CORLE ANNETTE G	3990 CORTLAND DR	NEW PARIS	PA	15554	BEDFORD	53928	NEW PARIS	960900	9609	715.5923	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	388.1079	397.8840	391.9345	0.1900	PERSON		1048	136			NEW PARIS BORO
B 14-0 00-014-P	42	009	499 GOOSEBERRY ROAD	HYNDMAN	PA	15545	HYNDMAN LONDONDERRY RECREATION	P O BOX 316	HYNDMAN	PA	15545	BEDFORD	44448	LONDONDERRY	961100	9611	17997.1291	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	321.2890	329.3382	325.3352	6.4800	PERSON		0292	0357			LONDONDERRY TWP
I 04-A 05-020	42	009	600 SHOUP STREET	SAXTON	PA	16678	BOROSKY SEAN L & CHRISTIAN R	600 SHOUP ST	SAXTON	PA	16678	BEDFORD	43072	LIBERTY	960100	9601	890.8829	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	255.9821	260.1259	259.1794	0.1240	PERSON		1015	465			LIBERTY TWP
D 03-D 05-036	42	009	291 NATURES SYMPHONY ROAD	IMLER	PA	16655	SUTTON RAYMOND S	308 RISA AVE	NEWFIELD	NJ	8344	BEDFORD	58492	PAVIA	960200	9602	654.8261	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	492.5273	503.0522	497.3292	0.1560	PERSON		747	578			PAVIA TWP
D 09-C 06-001-A	42	009	531 MAIN STREET	SOMERSET	PA	15550	CLOUD RICHARD V	531 MAIN STREET	MANNS CHOICE	PA	15550	BEDFORD	46944	MANNS CHOICE	960900	9609	3245.7767	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	358.5208	372.1164	367.8982	0.7000	PERSON		0188	0250			MANNS CHOICE BORO
G 13-0 00-005	42	009	259 PLEASANT UNION CHURCH ROAD	CLEARVILLE	PA	15535	PLEASANT UNION CEMETERY	C/O MRS VAUGHN CLARK	CLEARVILLE	PA	15535	BEDFORD	50424	MONROE	961001	9610.0100	21978.0420	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	464.6318	472.8649	470.2821	4.8900	PERSON				PLEASANT UNION CHURCH	CHRISTIAN_PLACE_OF_WORSHIP	MONROE TWP
H 06-F 05-054-A	42	009	621 CHRISTIAN STREET	HOPEWELL	PA	16650	COON VICKIE D	1822 SIGNAL HILL	MECHANICSBURG	PA	17050	BEDFORD	35648	HOPEWELL	960400	9604	745.6487	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	274.5535	280.4394	278.3562	0.2070	PERSON		0654	0339			HOPEWELL BORO
E 09-D 06-019	42	009	617 SOUTH JULIANA STREET	BEDFORD	PA	15522	MCLAUGHLIN CHARLES V & BARBARA	617 S JULIANA ST	BEDFORD	PA	15522	BEDFORD	04944	BEDFORD	960700	9607	1494.6920	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	336.0949	344.0299	341.0008	0.3300	PERSON		0438	0022			BEDFORD BORO
G 07-0 00-102	42	009	1658 PLANK ROAD	EVERETT	PA	15537	MEDLIN KENNETH EARL	1522 PLANK RD	EVERETT	PA	15537	BEDFORD	35656	HOPEWELL	960400	9604	11058.1233	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	332.8583	352.9465	343.4993	2	PERSON		0222	0350			HOPEWELL TWP
D 06-0 00-090	42	009	235 PRESNELL ROAD	EAST ST. CLAIR	PA	15554	MANGES RODNEY V & PAMELA K	235 PRESNELL RD	NEW PARIS	PA	15554	BEDFORD	21788	EAST ST. CLAIR	960300	9603	61230.0422	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	366.9472	398.1369	385.1779	17.3000	PERSON		830	474			EAST ST CLAIR TWP
I 05-0 00-036-A	42	009	144 RAINBOW ALLEY ROAD	BROAD TOP	PA	16679	MCINTYRE JANICE E & TIMOTHY W	152 RAINBOW ALLEY RD	SIX MILE RUN	PA	16679	BEDFORD	08880	BROAD TOP	960500	9605	310.8113	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	387.3052	389.0443	388.1265	0.0800	PERSON		888	628			BROAD TOP TWP
E 09-C 03-061	42	009	133 VALLEY VIEW ROAD	BEDFORD	PA	15522	BELAND KATHY A	133 VALLEY VIEW RD	BEDFORD	PA	15522	BEDFORD	04952	BEDFORD	960800	9608	1632.4802	42009C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	367.0998	372.7768	369.9354	0.3250	PERSON		0470	0659			BEDFORD TWP