Saved query 9b9d44db4149b6a0

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

41/80

Live SQL

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

237,487 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelstate	ownername	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	ownertype	naicscode	parceltype	accesstype	placename	placetype	lrversion
22 061 521	42	017	COBALT RIDGE DR S	PA	MIDDLETOWN TWP	BUCKS	49120	MIDDLETOWN	100805	1008.0500	140129.9730		258000	258000			42017C	2025-12-21	AE	FLOODWAY	12.6401	23.0878	15.9578	9943	PERSON	7212	GOVT LOCAL	OPEN	COBALT RIDGE PARK	PARK	2026.2
46 004 020	42	017	5 LOCUST LN	PA	JUTKIEWICZ LOUIS C	BUCKS	77744	TULLYTOWN	105900	1059	791.4366	14400	5200	19600	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	9.1024	10.0228	9.6380	1002	PERSON						2026.2
05 060 372	42	017	4708 HATFIELD ST	PA	MCCLEASE CARLTON	BUCKS	08768	BRISTOL	100303	1003.0300	599.8625	13200	3200	16400	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	8.4995	9.2967	9.0843	1001	PERSON						2026.2
05 024 112	42	017	3013 LOIS AVE	PA	FROLENKO NIKOLAY & SVETLANA	BUCKS	08768	BRISTOL	100303	1003.0300	1049.0671	15620	2680	18300	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	10.5100	12.3287	11.5978	1002	PERSON						2026.2
09 061 010	42	017	353 BIRDSONG WAY	PA	BENDA RICHARD ALLEN & SUZANNE	BUCKS	19792	DOYLESTOWN	104603	1046.0300	1529.6383	38920	9360	48280	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	95.7999	99.7682	98.5339	1001	PERSON						2026.2
02 071 109	42	017	1321 CHELTENHAM DR	PA	QAISAR MUZAMMIL M	BUCKS	05616	BENSALEM	100214	1002.1400	1117.9945	46130	6620	52750	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	22.4545	25.6032	24.4096	1001	PERSON						2026.2
50 008 101	42	017	3155 FOX DR	PA	JAEGER MEGAN L	BUCKS	81048	WARRINGTON	101802	1018.0200	1413.1574	44030	9120	53150	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	102.0041	103.6746	103.0671	1001	PERSON						2026.2
05 034 161	42	017	343 GOLDENRIDGE DR	PA	MCCARTY MICHAEL & SHARON	BUCKS	08768	BRISTOL	100402	1004.0200	805.0034	14880	5120	20000	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	26.4460	27.6748	27.1322	1002	PERSON						2026.2
02 048 271	42	017	85 LIBERTY DR	PA	HOVEY JEAN ELIZABETH	BUCKS	05616	BENSALEM	100207	1002.0700	257.9667	22800	2480	25280	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	31.0495	31.8891	31.6864	1060	PERSON						2026.2
06 010 221	42	017	3921 YORK RD	PA	HALE DAVID	BUCKS	09816	BUCKINGHAM	104502	1045.0200	3180.6486	21760	7840	29600	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	87.4857	91.8890	89.6171	1001	PERSON						2026.2
22 008 150	42	017	139 ELMWOOD AVE	PA	CORDON CASEY & MICAH	BUCKS	49120	MIDDLETOWN	100900	1009	882.6015	15620	2400	18020	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	43.1239	46.6789	44.9030	1001	PERSON						2026.2
23 011 157	42	017	2107 MILL VALLEY LN	PA	CLYMER ETHAN	BUCKS	49384	MILFORD	106402	1064.0200	469.8531	16400	2720	19120	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	159.7005	161.1129	160.4127	1023	PERSON						2026.2
36 028 030	42	017	554 ERIE RD	PA	HOOVER DELMAR E	BUCKS	64536	RICHLAND	106500	1065	1822.3564	5840	560	6400	1	1	42017C	2025-12-21	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	149.5445	150.6762	150.0207	1002	PERSON						2026.2
22 054 346	42	017	51 CANDLE RD	PA	LYNCH DANIEL & JANINE	BUCKS	49120	MIDDLETOWN	100805	1008.0500	641.4138	20130	3720	23850	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	35.3619	36.2420	35.9586	1001	PERSON						2026.2
15 028 099 002	42	017	1476 RICKERT RD	PA	BURKE DANIEL	BUCKS	34952	HILLTOWN	106300	1063	4781.7310	45400	10090	55490	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	177.0939	181.2479	179.4585	1010	PERSON						2026.2
09 023 014	42	017	22 SAUERMAN RD	PA	KUHAR MELISSA L	BUCKS	19792	DOYLESTOWN	104601	1046.0100	3502.8167	23000	6600	29600	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	68.3440	73.1388	71.4136	1001	PERSON						2026.2
05 036 390	42	017	51 BLUE RIDGE DR	PA	TISONE JOHN RUSSELL	BUCKS	08768	BRISTOL	100402	1004.0200	918.3882	15840	5760	21600	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	21.6775	22.6179	22.2687	1002	PERSON						2026.2
51 012 121	42	017	2145 SUGAR MAPLE LN	PA	KLEIMAN SCOTT & ROBIN	BUCKS	81144	WARWICK	104901	1049.0100	464.4571	38190	5040	43230	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	90.0964	92.6102	91.8570	1001	PERSON						2026.2
17 003 114 063	42	017	46 VALENTINE RD	PA	ABRAHAM LISA MARIA	BUCKS	37304	IVYLAND	106202	1062.0200	694.3851	41440	5960	47400	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	96.2699	98.7904	97.5146	1020	PERSON						2026.2
49 036 381	42	017	1537 MULBERRY CIR	PA	BAKER DAVID M & DARLENE E	BUCKS	80952	WARMINSTER	101610	1016.1000	1854.4642	29820	8360	38180	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	68.8530	71.3024	70.2484	1001	PERSON						2026.2
29 035 003	42	017	61 DELAWARE CT	PA	WHITE-PETERS JENNIFER	BUCKS	54192	NEWTOWN	105202	1052.0200	1022.4718	32410	11000	43410	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	32.1766	33.7385	32.7987	1005	PERSON						2026.2
34 032 138	42	017	6173 GERMAN RD	PA	TIETJEN LILIANE A	BUCKS	61616	PLUMSTEAD	104204	1042.0400	1383.5436	35670	5680	41350	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	170.8611	172.5279	171.9876	1001	PERSON						2026.2
15 058 002	42	017	2311 KEYSTONE DR	PA	PINTAR PATRICK CONNOLLY	BUCKS	34952	HILLTOWN	102104	1021.0400	3622.6408	45790	10030	55820	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	156.7804	161.2852	158.8577	1010	PERSON						2026.2
31 065 318	42	017	59 SIGNAL HILL RD	PA	FRANK STEPHEN & LAURA MAC CLAR…	BUCKS	54688	NORTHAMPTON	105011	1050.1099	1125.7734	27120	9800	36920	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	34.9255	39.1570	37.3982	1001	PERSON						2026.2
49 015 109	42	017	724 SPRUCE RD	PA	CARNEY KIMBERLY	BUCKS	80952	WARMINSTER	101611	1016.1100	928.4889	14330	5000	19330	1	1	42017C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	90.9284	91.8906	91.5678	1002	PERSON						2026.2