Saved query d8d6c764025738f1

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

44/80

Live SQL

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

207,861 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	saledate	numbldgs	numunits	numfloors	fldzone	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxyear	taxdistrict
6504 009605J0		42	045	478 BRINTONS BRIDGE RD		PA	NON-GOVERNMENTAL ORGANIZATION	478 BRINTONS BRIDGE RD WEST CHE…			19382	DELAWARE	12442	CHADDS FORD	410200	4102	8086.6145	2013-02-06				—	132.4100	137.1908	135.4999	R-10		2	PERSON	SS OF BRINTONS BRIDGE RD 2 AC D…	8636	1273	NGO	UNKNOWN	V	BRANDYWINE CONSERVANCY EASEMENT	CONSERVATION EASEMENT	2026.2		UNIONVILLE-CHADDS FORD
6406 0004000E		42	045		PENNSBURY	PA	EAST PENN RAILWAYS INC	C/O EAST PENN RAILROAD LLC 505 …	KENNETT SQUARE	PA		DELAWARE	59136	PENNSBURY	311100	3111	13824.3886	2005-09-09				—	44.5960	55.6648	49.1753	E-40		3.3000	BUSINESS	NW COR RT 100 STABLER RD 3.3 AC…	6613	1021						2026.2		UNIONVILLE-CHADDS FORD
6406 0004000E	64-6-4	42	045			PA	EAST PENN RAILWAYS INC	C/O EAST PENN RAILROAD LLC 505 …	KENNETT SQUARE	PA	19348	DELAWARE	59136	PENNSBURY	311100	3111	13857.5984					—	44.5960	55.6648	49.1671	E-40		3.3000	BUSINESS	NW COR RT 100 & STABLER RD 3.3 …	6613	1021						2026.2
{318E7D53-6C51-4C05-A104-9EDD76…		42	045			PA						DELAWARE	33144	HAVERFORD	408300	4083	12693.3964					—	94.0868	104.7219	99.7888	1300	RESIDENTIAL									HAVERFORD VILLAGE CONDOMINIUM A…	HISTORIC_SITE	2026.2	2006
{04B36F15-6B52-423D-911A-06B094…		42	045			PA						DELAWARE	49136	MIDDLETOWN	407101	4071.0100	89533.3944		1	1	1	—	19.3318	58.3964	38.5126													2026.2	2012
		42	045			PA	NON-GOVERNMENTAL ORGANIZATION					DELAWARE	54224	NEWTOWN	409904	4099.0400	236.9307					—	67.5928	69.4091	68.1139				PERSON				NGO	CLOSED	V	BRANDYWINE CONSERVANCY EASEMENT…	CONSERVATION EASEMENT	2026.2
		42	045			PA	UNKNOWN					DELAWARE	22584	EDGMONT	410000	4100	9862.5219					—	73.2078	100.1168	90.9519				UNDETERMINED				GOVT UNKNOWN	UNKNOWN	V	MILL HOLLOW WOODS	PRIVATE CONSERVATION	2026.2
		42	045			PA	UNKNOWN					DELAWARE	12442	CHADDS FORD	410200	4102	1033.6873					—	46.5529	52.6839	51.5741				UNDETERMINED				GOVT UNKNOWN	OPEN	V	BRANDYWINE CONSERVANCY PROPERTY	PRIVATE CONSERVATION	2026.2
		42	045			PA	UNKNOWN					DELAWARE	12442	CHADDS FORD	410200	4102	502.0210					—	48.3999	48.9323	48.7131				UNDETERMINED				GOVT UNKNOWN	UNKNOWN	V	BRANDYWINE CONSERVANCY PROPERTY	PRIVATE CONSERVATION	2026.2
		42	045			PA	UNKNOWN					DELAWARE	63264	RADNOR	409701	4097.0100	1063.5509					—	94.9444	98.8605	96.6804				UNDETERMINED				GOVT UNKNOWN	CLOSED	V	PRIVATE 4-19	PRIVATE CONSERVATION	2026.2
		42	045			PA	UNKNOWN					DELAWARE	63264	RADNOR	409701	4097.0100	688.1510					—	102.4551	104.6920	103.6390				UNDETERMINED				GOVT UNKNOWN	CLOSED	V	PRIVATE 4-7	PRIVATE CONSERVATION	2026.2
		42	045			PA	NON-GOVERNMENTAL ORGANIZATION					DELAWARE	63264	RADNOR	409701	4097.0100	14617.5130					—	96.0287	107.5841	102.3878				PERSON				NGO	CLOSED	V	NORTH AMERICAN LAND TRUST PROPE…	PRIVATE CONSERVATION	2026.2
		42	045			PA	UNKNOWN					DELAWARE	63264	RADNOR	409701	4097.0100	3584.1873					—	89.2404	102.5432	97.7960				UNDETERMINED				GOVT UNKNOWN	CLOSED	V	PRIVATE OS-8D	PRIVATE CONSERVATION	2026.2
		42	045			PA	UNKNOWN					DELAWARE	63264	RADNOR	409701	4097.0100	1614.9426					—	75.3443	80.2083	77.6130				UNDETERMINED				GOVT UNKNOWN	CLOSED	V	PRIVATE OS-9D	PRIVATE CONSERVATION	2026.2
		42	045			PA	UNKNOWN					DELAWARE	63264	RADNOR	409701	4097.0100	1110.1044					—	95.6991	101.0997	98.0446				UNDETERMINED				GOVT UNKNOWN	CLOSED	V	PRIVATE NRA-25	PRIVATE CONSERVATION	2026.2
		42	045			PA	UNKNOWN					DELAWARE	63264	RADNOR	409701	4097.0100	197.1863					—	98.2079	99.7440	98.9713				UNDETERMINED				GOVT UNKNOWN	CLOSED	V	PRIVATE NRA-25	PRIVATE CONSERVATION	2026.2
		42	045			PA	UNKNOWN					DELAWARE	63264	RADNOR	409701	4097.0100	1121.6078					—	95.5633	100.1395	98.2496				UNDETERMINED				GOVT UNKNOWN	CLOSED	V	PRIVATE 4-17	PRIVATE CONSERVATION	2026.2
		42	045			PA	UNKNOWN					DELAWARE	63264	RADNOR	409701	4097.0100	924.5055					—	85.6884	92.6510	88.5781				UNDETERMINED				GOVT UNKNOWN	CLOSED	V	PRIVATE 4-16	PRIVATE CONSERVATION	2026.2
		42	045			PA	UNKNOWN					DELAWARE	63264	RADNOR	409701	4097.0100	1196.7431					—	75.9150	84.0613	78.7098				UNDETERMINED				GOVT UNKNOWN	CLOSED	V	PRIVATE OS-8G	PRIVATE CONSERVATION	2026.2
		42	045			PA	UNKNOWN					DELAWARE	63264	RADNOR	409701	4097.0100	3240.4401					—	69.8942	80.4226	74.4091				UNDETERMINED				GOVT UNKNOWN	CLOSED	V	PRIVATE OS-8H	PRIVATE CONSERVATION	2026.2
		42	045			PA	UNKNOWN					DELAWARE	63264	RADNOR	409701	4097.0100	658.4532					—	75.0524	80.6103	77.6677				UNDETERMINED				GOVT UNKNOWN	CLOSED	V	PRIVATE OS-9C	PRIVATE CONSERVATION	2026.2
		42	045			PA	NON-GOVERNMENTAL ORGANIZATION					DELAWARE	63264	RADNOR	409701	4097.0100	13696.1689					—	90.0482	104.3800	97.6160				PERSON				NGO	CLOSED	V	BRANDYWINE CONSERVANCY EASEMENT…	CONSERVATION EASEMENT	2026.2
		42	045			PA	NON-GOVERNMENTAL ORGANIZATION					DELAWARE	12442	CHADDS FORD	410200	4102	78250.7738					—	61.1949	107.7513	79.8896				PERSON				NGO	CLOSED	V	BRANDYWINE CONSERVANCY EASEMENT…	CONSERVATION EASEMENT	2026.2
		42	045			PA	UNKNOWN					DELAWARE	76792	TINICUM	403701	4037.0100	14773.7502					—	0.6631	2.1771	1.4495				UNDETERMINED				GOVT UNKNOWN	OPEN	VI	WILLIAM PENN STATE FOREST - TIN…	STATE RESOURCE MANAGEMENT AREA	2026.2
		42	045			PA	UNITED STATES NATURAL RESOURCES…					DELAWARE	03336	ASTON	406904	4069.0400	7520.0902					—	36.5141	43.1391	39.2470				GOVERNMENT				GOVT FEDERAL	CLOSED	V	EMERGENCY WATERSHED PROTECTION …	CONSERVATION EASEMENT	2026.2