Saved query 55fa3717fd621c74

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

237,488 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	ownertype	parceltype	accesstype	placename	placetype
01 011 028 002	42	017	432 ELEPHANT RD	PERKASIE	PA	18944	BEDMINSTER TWP	BUCKS	04976	BEDMINSTER	104000	1040	44975.7955	37570	16600	54170	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	123.7723	138.5018	134.2359	9943	PERSON	GOVT UNKNOWN	RESTRICTED	BEDMINSTER TOWNSHIP BUILDING	GOVERNMENT_OFFICE
06 014 012 001	42	017	5042 ANDERSON RD	HOLICONG	PA	18928	BRETZ FAMILY TRUST	BUCKS	09816	BUCKINGHAM	104506	1045.0600	127018.0421	55160	47640	102800	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	79.3228	96.9092	87.9128	1058	TRUST			THOMAS AND LYDIA GILBERT FARM	HISTORIC_SITE
20 005 072	42	017	N KIMBLES RD	YARDLEY	PA	19067	LOWER MAKEFIELD TWP	BUCKS	44968	LOWER MAKEFIELD	105508	1055.0800	5341.1570		680	680			42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	57.3496	63.5926	60.2384	9941	PERSON	GOVT UNKNOWN	UNKNOWN	KIMBLES FIELD AT FARMVIEW	LOCAL OTHER OR UNKNOWN
04 019 003	42	017	POND & STS	BRISTOL	PA	19007	BRISTOL BORO	BUCKS	08760	BRISTOL	100600	1006	10081.8730		20480	20480			42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	4.9975	8.0433	5.5445	9943	PERSON	GOVT LOCAL	OPEN	BRISTOL SPURLINE PARK	LOCAL RECREATION AREA
31 065 019	42	017	2190 E VILLAGE RD	SOUTHAMPTON	PA	18966	TIGER MARK J	BUCKS	54688	NORTHAMPTON	105011	1050.1099	391.3463	21640	2520	24160	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	40.2140	42.4952	41.0976	1006	PERSON
16 005 042	42	017	215 FORD AVE	LANGHORNE	PA	19047	WARE JOAN F	BUCKS	36192	HULMEVILLE	106000	1060	727.0418	17800	3400	21200	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	9.6619	10.5185	10.0944	1001	PERSON
13 030 424	42	017	401 MUSKET DR	YARDLEY	PA	19067	SCHIFANO JASON MICHAEL & CARIN…	BUCKS	25112	FALLS	105801	1058.0100	1044.4803	23080	7520	30600	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	36.3545	37.6647	37.0601	1001	PERSON
08 004 055	42	017	344 DOYLE ST	DOYLESTOWN	PA	18901	CAMBURN DONALD R & ARLENE M	BUCKS	19784	DOYLESTOWN	104701	1047.0100	904.8834	23800	7040	30840	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	107.1268	108.4816	107.8602	1001	PERSON
48 007 268	42	017	1009 WILLOPENN DR	SOUTHAMPTON	PA	18966	MESSER-ROMERO JO-ANN	BUCKS	79296	UPPER SOUTHAMPTON	101506	1015.0600	1351.9314	11760	6240	18000	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	78.3818	80.1747	79.0597	1002	PERSON
02 088 049	42	017	2303 EBURY CT	BENSALEM TOWNSHIP	PA	19020	ROOMAN MOH	BUCKS	05616	BENSALEM	100207	1002.0700	412.6795	20440	3200	23640	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	28.4885	30.1963	29.4787	1023	PERSON
02 065 022 012	42	017	308 CAMER DR	BENSALEM TOWNSHIP	PA	19020	CAMER 308 LLC	BUCKS	05616	BENSALEM	100102	1001.0200	1522.2402	52760	13240	66000	1	1	42017C	2025-12-21	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	2.4032	4.2540	3.6259	3425	BUSINESS
52 010 155 006	42	017	211 CATHILL RD	SELLERSVILLE	PA	18960	CLYMER DAVID E & AUDREY	BUCKS	83960	WEST ROCKHILL	102700	1027	6548.3381	29240	8360	37600	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	97.8716	113.2979	104.7788	1002	PERSON
15 011 022 003	42	017	809 DIAMOND ST	SELLERSVILLE	PA	18960	FLANNERY MICHAEL E	BUCKS	34952	HILLTOWN	106300	1063	2931.4030	24440	5280	29720	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	123.4193	125.3970	124.6297	1002	PERSON
36 040 017	42	017	1056 GLEN MANOR DR	QUAKERTOWN	PA	18951	DAY CHRISTOPHER M & ALYSHA M	BUCKS	64536	RICHLAND	106401	1064.0100	1051.0412	25920	5720	31640	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	149.6248	150.9365	150.4197	1001	PERSON
50 033 133	42	017	872 STALLION RD	WARRINGTON	PA	18976	SHARKEY STEPHANIE	BUCKS	81048	WARRINGTON	101807	1018.0700	1233.5597	20440	5160	25600	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	71.0567	74.5603	72.8131	1004	PERSON
35 001 118	42	017	67 DEWSBURY LN	QUAKERTOWN	PA	18951	ZAVITSANOS PETER	BUCKS	63048	QUAKERTOWN	103103	1031.0300	517.1586	14720	3000	17720	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	161.6983	162.3275	162.0380	1023	PERSON
02 007 112	42	017	2515 PARIS AVE	TREVOSE	PA	19053	HINTON LEROY	BUCKS	05616	BENSALEM	100201	1002.0100	603.2068	14920	1880	16800	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	47.4766	49.0150	48.3296	1002	PERSON
13 016 258	42	017	865 TRENTON RD	FAIRLESS HILLS	PA	19030	KILMER GROVER C III&CAROLYN E	BUCKS	25112	FALLS	105808	1058.0800	2198.9985	36100	9320	45420	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	25.6708	27.9610	26.7451	1002	PERSON
50 008 166	42	017	135 MORNING WALK DR	WARRINGTON	PA	18976	BRETT WILLIAM J JR & CHRISTINE	BUCKS	81048	WARRINGTON	101802	1018.0200	1254.1561	38010	9040	47050	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	99.4208	100.5145	100.1201	1010	PERSON
48 026 012	42	017	1714 BUSTLETON PIKE	SOUTHAMPTON	PA	18966	WERBOCK CARL & MONA	BUCKS	79296	UPPER SOUTHAMPTON	101505	1015.0500	15083.7898	43320	15880	59200	1	1	42017C	2025-12-21	AE	FLOODWAY	30.8039	39.9033	33.9639	1018	PERSON
51 023 130	42	017	1589 BROOK LN	JAMISON CITY	PA	18929	KORPALSKI STEPHEN P & COLLEEN	BUCKS	81144	WARWICK	104901	1049.0100	1106.1965	30600	8880	39480	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	107.0416	108.2798	107.6828	1010	PERSON
20 071 108	42	017	1981 GREGG CT	YARDLEY	PA	19067	TOBIAS JOSEPH J JR & KAROLE ANN	BUCKS	44968	LOWER MAKEFIELD	105510	1055.1000	746.7822	34540	8000	42540	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	53.3703	54.2832	53.9839	1001	PERSON
13 025 071	42	017	12 WALNUT LN	LEVITTOWN	PA	19054	CARPENTER JOSEPH M	BUCKS	25112	FALLS	105811	1058.1099	656.0487	11800	4600	16400	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	9.4140	10.3139	9.9937	1002	PERSON
08 017 218	42	017	235 HILLCREST DR	DOYLESTOWN	PA	18901	HUYNH CAU & KHANH	BUCKS	19784	DOYLESTOWN	104701	1047.0100	1501.5308	20480	4320	24800	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	108.3094	109.8883	109.0787	1004	PERSON
29 003 034 118	42	017	110 RITTENHOUSE CIR	NEWTOWN	PA	18940	SCHWARTZ SHARON	BUCKS	54192	NEWTOWN	105207	1052.0700	442.2666	62890	4000	66890	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	93.2177	93.8601	93.6215	1006	PERSON