Saved query 0fd47f274b28d8fc

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 = '51' 
  AND countyfp = '017'

6,462 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	naicscode	legaldesc	parceltype	accesstype	iucnclass	placename	placetype
40-0-4	69500	51	017	900 HIDDEN VALLEY ROAD	WARM SPRINGS	VA	24484	Bath	96239	Warm Springs	920101	9201.0100	4692.8362	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	574.6892	603.7632	587.9442	1.1399	1132		GOVT FEDERAL	RESTRICTED	OTHER	GEORGE WASHINGTON NATIONAL FORE…	NATIONAL FOREST
87-0-71	283100	51	017	222 SUGAR HOLLOW ROAD	MILLBORO	VA	24460	Bath	94695	Millboro	920101	9201.0100	29299.9283	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	405.4235	428.3544	412.5682	7.9700	3211		GOVT STATE	CLOSED	OTHER	VIRGINIA OUTDOORS FOUNDATION EA…	CONSERVATION EASEMENT
87-0-65	452500	51	017	CALVARY BAPTIST CHURCH	MILLBORO	VA	24460	Bath	94695	Millboro	920101	9201.0100	13204.5608	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	408.6658	425.8304	417.6781	3.1600	6244					CALVARY BAPTIST CHURCH	CHRISTIAN_PLACE_OF_WORSHIP
62A-1-35A	62430	51	017	15857 MOUNTAIN VALLEY ROAD	WARM SPRINGS	VA	24484	Bath	96239	Warm Springs	920101	9201.0100	653.6141	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	620.3449	626.5236	622.6123	0	4595					SPRINGHOUSE ANTIQUES	SECOND_HAND_STORE
62-0-2E	5900	51	017	23 POST OFFICE DRIVE	BACOVA	VA	24412	Bath	96239	Warm Springs	920102	9201.0200	33528.4234	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	565.6838	602.1558	583.1053	0
87-0-108	339200	51	017	457 HIGH COUNTRY ROAD	MILLBORO	VA	24460	Bath	94695	Millboro	920101	9201.0100	4972.7538	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	522.7191	539.5588	535.4244	0
71-0-71	99350	51	017	170 MAIN STREET	HOT SPRINGS	VA	24445	Bath	90672	Cedar Creek	920102	9201.0200	7872.8438	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	556.3240	582.4006	563.5258	2.2500
24-0-4	449000	51	017	9280 TOWER HILL ROAD	WILLIAMSVILLE	VA	24487	Bath	96399	Williamsville	920101	9201.0100	11088.3833	2	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	729.6698	743.2210	739.2100	2.9500
72E-1-D-B	102310	51	017	89 DEEPWOOD LANE	HOT SPRINGS	VA	24445	Bath	90672	Cedar Creek	920102	9201.0200	381.9930	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	783.8695	785.5991	784.6333	0.0940		North Ridge
16-0-37A	237500	51	017	137 COWPASTURE RIVER ROAD	WILLIAMSVILLE	VA	24487	Bath	96399	Williamsville	920101	9201.0100	3569.5925	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	496.5205	506.0745	499.6045	1.2300
104-0-32	252750	51	017	4628 COWPASTURE RIVER HIGHWAY	MILLBORO	VA	24460	Bath	94695	Millboro	920101	9201.0100	18940.9039	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	418.7606	449.0642	430.8732	0
93-0-13	389100	51	017	45 CUBBLEY ROAD	HOT SPRINGS	VA	24445	Bath	96167	Valley Springs	920102	9201.0200	5461.6618	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	705.9790	731.1425	717.2664	0
15-0-35C	203760	51	017	11968 TOWER HILL ROAD	WILLIAMSVILLE	VA	24487	Bath	96399	Williamsville	920101	9201.0100	8714.0767	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	622.8497	647.9559	633.2100	0
57-1-5	0	51	017	6537 MILL CREEK ROAD	MILLBORO	VA	24460	Bath	96399	Williamsville	920101	9201.0100	30358.1619	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	578.7711	620.9483	601.6086	0
72C-3-58	116500	51	017	117 PAUL SIPLE DRIVE	HOT SPRINGS	VA	24445	Bath	90672	Cedar Creek	920102	9201.0200	691.0419	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	756.8590	761.5004	758.9281	0.1729
103-0-19	224200	51	017	WILSON CREEK	MILLBORO	VA	24460	Bath	96399	Williamsville	920101	9201.0100	19214.6841	2	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	485.5307	506.5202	491.8573	0
87-0-109	333400	51	017	511 HIGH COUNTRY ROAD	MILLBORO	VA	24460	Bath	94695	Millboro	920101	9201.0100	3921.7984	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	527.4653	537.4350	534.0715	0
97-0-9	267800	51	017	374 VINEYARD DRIVE	MILLBORO	VA	24460	Bath	94695	Millboro	920101	9201.0100	56258.7539	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	433.3867	477.3639	461.0142	0
97-0-48	298900	51	017	7184 COWPASTURE RIVER HIGHWAY	MILLBORO	VA	24460	Bath	94695	Millboro	920101	9201.0100	137632.7137	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	412.6878	481.3541	441.9053	0
16-0-12B	460193	51	017	565 PHEASANTY HOLLOW ROAD	WILLIAMSVILLE	VA	24487	Bath	96399	Williamsville	920101	9201.0100	11668.9636	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	591.7212	617.3561	605.5115	3
94A1-2-22	456700	51	017	54 METHODIST LANE	HOT SPRINGS	VA	24445	Bath	96167	Valley Springs	920102	9201.0200	2326.0292	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	746.0438	755.4318	749.0741	0
101B-1-27 28	417940	51	017	137 CARLOOVER VILLAGE DRIVE	HOT SPRINGS	VA	24445	Bath	96167	Valley Springs	920102	9201.0200	6006.0251	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	748.5640	760.4719	751.6622	0
97-0-5	292900	51	017	661 NIMROD DRIVE	MILLBORO	VA	24460	Bath	94695	Millboro	920101	9201.0100	28743.1567	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	424.5026	428.2442	426.6135	7
101B-1-47	428800	51	017	128 CARLOOVER VILLAGE DRIVE	HOT SPRINGS	VA	24445	Bath	96167	Valley Springs	920102	9201.0200	1401.2510	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	756.0471	765.5750	760.2623	0
87-0-159	269200	51	017	26 HUFFMAN HILL ROAD	MILLBORO	VA	24460	Bath	94695	Millboro	920101	9201.0100	3635.1301	1	51017C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	512.4115	516.9801	514.6586	0.8900