Saved query 14cbc6d73a4c5046

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

45/80

Live SQL

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

189,654 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	ownername	owneraddr	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	saledate	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	taxacres	ownertype	naicscode	legaldesc	book	page	parceltype	accesstype	placename	placetype	lrversion	taxdistrict
531002653232	42	071	156 SWAMP RD		PA	BEAM WILLIAM & ROBIN	338 N MANOR RD ELVERSON PA 195…		LANCASTER	10704	CAERNARVON	012602	126.0200	230653.4116	119800	28900	148700	136125	2008-11-19	1	1	42071C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	166.6544	188.7429	183.1787	801	56.9903	PERSON			5443	0872	GOVT LOCAL	CLOSED	BERKS COUNTY AGRICULTURAL EASEM…	AGRICULTURAL EASEMENT	2026.2	CAERNARVON TOWNSHIP
435504637150	42	071	325 LAUREL RIDGE RD		PA	NASS ROBERT ALAN REVOCABLE TRUS…	905 BISCAYNE BLVD UNIT 2 DELAND…		LANCASTER	82728	WEST COCALICO	010103	101.0300	21781.3167	119100	250300	369400	10	2022-04-29	1	1	42071C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	210.1408	251.9470	230.3592	4200	5.3807	TRUST			2022	017934					2026.2	SOUTH HEIDELBERG TOWNSHIP
530100079502	42	071	1161 EDWARDS RD		PA	SEBASTIAN COTY S & ASHLEY N & D…	1161 EDWARDS RD NARVON PA 1755…		LANCASTER	08352	BRECKNOCK	012601	126.0100	6255.5573	189400	46900	236300	600000	2023-11-02	1	1	42011C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	277.9493	291.1279	285.8386	111	1.5462	PERSON			2023	032801					2026.2	BRECKNOCK TOWNSHIP
530100073947	42	071	1255 MAPLE GROVE RD		PA	MARTIN NEVIN K & ROSE ELAINE	1255 MAPLE GROVE RD MOHNTON PA…		LANCASTER	08352	BRECKNOCK	012601	126.0100	7222.4222	40300	48500	88800	190000	2019-07-31	1	1	42071C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	263.2090	281.7778	275.3156	146	1.7836	PERSON			2019	025125					2026.2	BRECKNOCK TOWNSHIP
437302579377	42	071	307 E MAIN ST		PA	NZ CAPITAL LLC	2111 OLD LANCASTER PIKE REINHO…		LANCASTER	00364	ADAMSTOWN	012501	125.0100	2236.9390	41300	31400	72700	245000	2021-12-10	1	1	42071C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	153.9189	159.9500	158.5620	111	0.5527	BUSINESS			2021	061453					2026.2	SPRING TOWNSHIP
434604610584	42	071	1164 SPORTSMAN RD		PA	KINKAID KELLY L & CLARK JOHN E …	1164 SPORTSMAN RD ROBESONIA PA…		LANCASTER	82728	WEST COCALICO	010103	101.0300	8021.6682	67700	18400	86100	214900	2002-01-25	1	1	42071C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	345.2940	351.3635	348.3033	101	1.9819	PERSON			3470	0889					2026.2	SOUTH HEIDELBERG TOWNSHIP
439203336352	42	071	419 BOWMANSVILLE RD		PA	MAIER NANCY A & ERIC D	429 BOWMANSVILLE RD MOHNTON PA…		LANCASTER	08352	BRECKNOCK	012601	126.0100	264144.1748	131500	74100	205600		2013-05-24	1	1	42071C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	145.5449	206.6337	160.0780	801	65.2607	PERSON			2013	021886					2026.2	BRECKNOCK TOWNSHIP
437307579742	42	071	305 E MAIN ST		PA	NZ CAPITAL LLC	2111 OLD LANCASTER PIKE REINHO…		LANCASTER	00364	ADAMSTOWN	012501	125.0100	3051.5889	45600	40500	86100	215000	2021-12-06	1	1	42071C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	153.9061	164.5031	159.6466	114	0.7536	BUSINESS			2021	060043					2026.2	SPRING TOWNSHIP
531004743246	42	071	2861 MAIN ST		PA	MTM PROPERTIES LLC	PO BOX 677 MORGANTOWN PA 19543…		LANCASTER	10704	CAERNARVON	012602	126.0200	11127.2833	12800	419100	431900	990000	2002-06-04	1	1	42071C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	172.5964	179.6272	176.7665	4220	2.7496	BUSINESS			3544	1872					2026.2	CAERNARVON TOWNSHIP
530100081186	42	071	1249 MAPLE GROVE RD		PA	BENNER MARLIN D & SUZANNE K	1249 MAPLE GROVE RD MOHNTON PA…		LANCASTER	08352	BRECKNOCK	012601	126.0100	6571.0033	81300	47800	129100			1	1	42071C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	256.5169	278.4415	268.5963	102	1.6229	PERSON			1688	0099					2026.2	BRECKNOCK TOWNSHIP
434604805426	42	071	1041 SPORTSMAN RD		PA	DEITRICH PATSY G & CARL E JR	1041 SPORTSMAN RD ROBESONIA PA…		LANCASTER	82728	WEST COCALICO	010103	101.0300	179898.6023	131500	53400	184900			1	1	42071C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	261.5929	323.5585	301.5623	801	44.4480	PERSON			3229	2033					2026.2	SOUTH HEIDELBERG TOWNSHIP
531002559665	42	071	SWAMP RD		PA	BEAM ROBIN A & WILLIAM L & MATT…	338 N MANOR RD ELVERSON PA 195…		LANCASTER	10704	CAERNARVON	012602	126.0200	115740.2697		16500	16500	375000	2013-01-11			42071C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	180.1189	233.1139	195.8657	800	28.5972	PERSON			2013	001233					2026.2	CAERNARVON TOWNSHIP
437307578774	42	071	303 E MAIN ST		PA	GROSSMAN JOSEPH I & JUDITH A	303 E MAIN ST # 115 ADAMSTOWN …		LANCASTER	00364	ADAMSTOWN	012501	125.0100	2697.2248	48500	39100	87600			1	1	42071C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	153.9149	164.5632	159.7814	114	0.6667	PERSON			1557	0821					2026.2	ADAMSTOWN BOROUGH
3602 00310000	42	071	5936 WINDMILL RD		PA	ZOOK JONAS F ZOOK ERMA ROSE	5937 WINDMILL RD PARKESBURG PA	19365	LANCASTER	67568	SALISBURY	014202	142.0200	32120.7970					2012-09-14					—		168.6040	232.3099	209.3523	R-10	9.7000	PERSON	6216	SWS WINDMILL RD 9.7 AC DWG BLDG…	8518	286			ZOOK'S CUSTOM UPHOLSTERY	HOME_SERVICE	2026.2	OCTORARA AREA
3604 00010800	42	071	61 AMY DR		PA	STOLTZFUS ELI W STOLTZFUS LINDA…	61 AMY DR GAP PA	17527	LANCASTER	67096	SADSBURY	014302	143.0200	5144.8034					2018-03-16					—		178.4433	191.3399	183.5210	R-10	1.1000	PERSON		NS OF AMY DR 1.1 AC DWG LOT 8	9712	284					2026.2	OCTORARA AREA
2209 00050000	42	071	2445 BEAVER DAM RD		PA	BEILER KEITH E KING MARILYN F	2399 BEAVER DAM RD HONEY BROOK …	19344	LANCASTER	67568	SALISBURY	014201	142.0100	124562.0437					2022-04-14					—		166.7500	212.6929	193.9390	V-10	35.3793	PERSON		NS OF BEAVER DAM RD 35.3 AC LOT…	10855	1095					2026.2	TWIN VALLEY
2804 00060500	42	071	109 CLYDESDALE CI		PA	BENNETT BRADLEY BWINT EMILY	109 CLYDESDALE CIR HONEY BROOK …	19344	LANCASTER	67568	SALISBURY	014201	142.0100	8444.6205					2020-04-02					—		186.3108	203.1265	194.9792	R-10	2.2000	PERSON		NS OF CLYDESDALE CIR 2.2 AC DWG…	10132	1414					2026.2	COATESVILLE AREA
2209 00290000	42	071	2440 BEAVER DAM RD		PA	SMOKER STEVEN L SMOKER KATHRYN J	2440 BEAVER DAM RD HONEY BROOK …	19344	LANCASTER	67568	SALISBURY	014201	142.0100	65425.9619					2019-10-22					—		163.2949	209.9364	184.8982	R-10	11.2000	PERSON		SW COR OF BEAVER DAM LAM 11.6 A…	10027	714					2026.2	TWIN VALLEY
4401 00180000	42	071		WEST FALLOWFIELD	PA	STOLTZFUS ELAM G STOLTZFUS JERU…	3841 YOST RD GORDONVILLE PA	17529	LANCASTER	67096	SADSBURY	014302	143.0200	84288.5082					2023-08-11					—		119.9840	189	132.1084	N-01	11.8000	PERSON		WS REA OF WOLFS HOLLOW D 11.8 A…	11094	497					2026.2	OCTORARA AREA
5701 00030000	42	071		UPPER OXFORD	PA	ECKMAN FARM LP	4781 LOWER VALLEY RD ATGLEN PA	19310	LANCASTER	67096	SADSBURY	014302	143.0200	150098.0595					2007-11-27					—		97.2799	150.5000	108.2405	V-10	42	BUSINESS		N REAR RT 896 AT LANCAST 42 AC S	7313	830					2026.2	OXFORD AREA
2203 00010000	42	071	1553 RESERVOIR RD		PA	HOLLAND MONTINA SHIELDS JANAE E…	3701 DIANNA RD SUITLAND MD	20746	LANCASTER	35536	HONEY BROOK	304900	3049	7826.5057					2016-03-02					—		264.6700	273.6557	268.9409	R-10	2.4000	PERSON		NS OF RESEVOIR RD 2.4 AC DWG	9271	63					2026.2	TWIN VALLEY
2203 00430000	42	071	1019 WELSH RD		PA	FORD JAMES R JR	410 ASH RD MORGANTOWN PA	19543	LANCASTER	10704	CAERNARVON	012602	126.0200	1380.9183					2014-05-15					—		277.9320	281.5628	280.2327	R-70	0.4100	PERSON		SS WELSH RD LOT	8924	249					2026.2	TWIN VALLEY
2203 004201A0	42	071	554 TWIN COUNTY RD		PA	AQUADRO NATHANIEL AQUADRO CARLA	554 TWIN COUNTY RD HONEY BROOK …	19344	LANCASTER	10704	CAERNARVON	012602	126.0200	9525.4450					2023-07-07					—		274.2179	280.5599	277.5218	R-10	1.9000	PERSON		WS OF TWIN COUNTY RD 1.9 AC DWG…	11076	1866					2026.2	TWIN VALLEY
2203 00010100	42	071	1445 RESERVOIR RD		PA	CHESTER COUNTY SOLID WASTE AUTH…	7224 DIVISION HWY NARVON PA	17555	LANCASTER	10704	CAERNARVON	012602	126.0200	8465.4101					2012-03-27					—		265.2300	274.0260	269.5992	R-10	2.3000	PERSON		NS OF RESEVOIR RD 2.3 AC DWG	8387	2338					2026.2	TWIN VALLEY
2203 00760000	42	071	1293 RESERVOIR RD		PA	LATSHAW JOHN F III	1293 RESERVOIR RD HONEY BROOK PA	19344	LANCASTER	10704	CAERNARVON	012602	126.0200	3148.0686					2022-02-03					—		276.5769	280.6375	278.7642	R-10	1.1000	PERSON		NS OF RESERVOIR RD 1.1 AC DWG	10805	1039					2026.2	TWIN VALLEY