Saved query 760792f01e427e60

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

36/80

Live SQL

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

6,759 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	numbldgs	yearbuilt	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	zoningcode	taxacres	ownertype	legaldesc	book	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxdistrict
040 40	2704-64-6682	51	017	0	UNASSIGNED	VA	0	BERRY FRANKLIN LEE ORPAMELA ELA…	16370 DEERFIELD RD	DEERFIELD	VA	24432	BATH	96399	WILLIAMSVILLE			64125.3858		226300		226300	0	0	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	617.9169	693.4715	664.8797			66	PERSON	40-40 ON BOTH SIDES OF RT 629 A…		GOVT STATE	CLOSED	OTHER	VIRGINIA OUTDOORS FOUNDATION EA…	CONSERVATION EASEMENT	2026.2
00600-00-000-003A	18329	51	017	COLES MOUNTAIN RD		VA		HARTSOOK FRANKYE J TRUSTEE HAR…	155 LEATHER FLOWER DRIVE	LAKE FREDERICK	VA	22630	BATH	90672	CEDAR CREEK	920102	9201.0200	92051.6783	52480	57580	52480	5100		0	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	441.0339	497.1755	467.9044	50	AR	23.0320	TRUST	23.032 AC CEDAR CREEK	4115						2026.2	FALLING SPRING
		51	017			VA		UNITED STATES FOREST SERVICE					BATH	96239	WARM SPRINGS	920101	9201.0100	638.8335									—		795.7540	806.0795	797.8909				GOVERNMENT			GOVT FEDERAL	OPEN	OTHER	MONONGAHELA NATIONAL FOREST	NATIONAL FOREST	2026.2
		51	017			VA		UNITED STATES FOREST SERVICE					BATH	96239	WARM SPRINGS	920101	9201.0100	216.5680									—		835.7792	840.4133	839.1693				GOVERNMENT			GOVT FEDERAL	OPEN	OTHER	MONONGAHELA NATIONAL FOREST	NATIONAL FOREST	2026.2
88A-1-B		51	017			VA							BATH	94695	MILLBORO	920101	9201.0100	1591.8970									—		513.3798	523.8474	520.3557												2026.2
72D-1-4-4		51	017			VA							BATH	90672	CEDAR CREEK	920102	9201.0200	2836.4930									—		685.4408	701.5061	694.1748												2026.2
72C-3-22		51	017			VA							BATH	90672	CEDAR CREEK	920102	9201.0200	253.6757									—		757.6386	760.1276	759.0114												2026.2
82-0-1		51	017			VA							BATH	90672	CEDAR CREEK	920102	9201.0200	204.7985									—		493.7749	494.2900	493.9979												2026.2
94A1-2-7B		51	017			VA							BATH	96167	VALLEY SPRINGS	920102	9201.0200	1510.9696									—		734.8119	739.6557	737.3470												2026.2
98-0-47		51	017			VA							BATH	94695	MILLBORO	920101	9201.0100	2479.1178									—		525.0279	535.9456	531.9064												2026.2
94A2-1-33		51	017			VA							BATH	96167	VALLEY SPRINGS	920102	9201.0200	1631.9571									—		684.6923	693.1601	688.6055												2026.2
24-0-8A		51	017			VA							BATH	96399	WILLIAMSVILLE	920101	9201.0100	460560.0579									—		661.2246	966.1837	841.7164												2026.2
94-0-12		51	017			VA							BATH	96167	VALLEY SPRINGS	920102	9201.0200	20728.8100									—		871.6008	898.1840	884.7513												2026.2
15-0-6		51	017			VA							BATH	96399	WILLIAMSVILLE	920101	9201.0100	402.2407									—		689.4578	696.6327	694.1068												2026.2
87-0-151		51	017			VA							BATH	94695	MILLBORO	920101	9201.0100	673.3129									—		518.7052	528.0625	523.1829												2026.2
83-0-24		51	017			VA							BATH	96167	VALLEY SPRINGS	920102	9201.0200	4550.7010									—		735.1538	745.9946	742.3240												2026.2
28-0-1		51	017			VA							BATH	96239	WARM SPRINGS	920101	9201.0100	251971.7640									—		617.1066	779.9807	707.9112												2026.2
97-0-64		51	017			VA							BATH	94695	MILLBORO	920101	9201.0100	673.3164									—		383.2009	383.8310	383.5779												2026.2
98-0-19		51	017			VA							BATH	94695	MILLBORO	920101	9201.0100	10199.3772									—		574.9125	592.6843	586.5040												2026.2
87B-2-1-8		51	017			VA							BATH	94695	MILLBORO	920101	9201.0100	595.4312									—		398.2598	399.2546	398.6711												2026.2
87B-1-3-11		51	017			VA							BATH	94695	MILLBORO	920101	9201.0100	592.1181									—		394.7362	396.3063	395.4416												2026.2
97-0-45		51	017			VA							BATH	94695	MILLBORO	920101	9201.0100	5075.0992									—		436.6547	469.7857	453.1851												2026.2
24-0-18		51	017			VA							BATH	96399	WILLIAMSVILLE	920101	9201.0100	402.2507									—		468.4833	469.7406	469.2975												2026.2
52-0-30		51	017			VA							BATH	96239	WARM SPRINGS	920101	9201.0100	278144.4841									—		609.5954	715.1608	650.4348												2026.2
87-0		51	017			VA							BATH	94695	MILLBORO	920101	9201.0100	5557.5597									—		511.8881	531.5067	520.3364												2026.2