Saved query c0cc93ac1a9c2c98

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 = '027'

20,618 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	saleamt	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	ownertype	naicscode	legaldesc	book	page	placename	placetype	taxdistrict
4599-79-6915	20650	51	027	001714 RIVERSIDE DR ,RAVEN,VA 2…	RAVEN	VA	24639	KEENE, JOSEPH S		VANSANT, VA	24656	Buchanan	93679	Garden	010600	106	495.5404	59936	9000	53000	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	676.8599	680.0342	677.6645	0.1200	PERSON	4595	GRASSY CRK	622	707	MOUNTAIN PALLETS PLUS LLC	SECOND_HAND_STORE	1
4661-15-7605	14360	51	027	001036 OLD BRIDGE RD,OAKWOOD,VA…	OAKWOOD	VA	24631	YOUNG, LOGAN WAYNE	1036 OLD BRIDGE RD	OAKWOOD, VA	24631	Buchanan	93951	Hurricane	010600	106	599.9612	4500	6000	4000	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	414.3313	423.1537	416.0732	0	PERSON		GARDEN CRK	0510	516			2
4618-30-3458	16043	51	027	002604 OLD ROCKLICK RD,BIG ROCK…	BIG ROCK	VA	24603	STILTNER, ELSIE	0	BIG ROCK, VA	24603	Buchanan	95415	Rock Lick	010200	102	3161.4362	31600	5500	4600	3	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	310.5390	316.7748	313.6211	0	PERSON		ROCKLICK CREEK	0233	442			6
4611-18-1510	2402	51	027	001143 APACHE RD ,VANSANT,VA 24…	VANSANT	VA	24656	CHARLES, JEFFREY ELLIS & MATTIE…	PO BOX 1039	VANSANT, VA	24656	Buchanan	95167	Prater	010700	107	9424.1775	3000	4600	3000	2	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	511.7395	609.5105	555.9822	2	PERSON		WAR FORK	0313	638			5
4645-71-0217	13669	51	027	001175 ENOCHS BRANCH RD,GRUNDY …	GRUNDY	VA	24614	RATLIFF, JOSEPH ROOSEVELT & WIL…	1175 ENOCHS BRANCH RD	GRUNDY, VA	24614	Buchanan	94903	North Grundy	010100	101	3682.8460	62400	8000	500	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	391.9806	412.8283	400.4029	1	PERSON		SLATE CREEK-ENOCHS BRANCH	0197	182			4
5623-65-5397	13	51	027	000000 , , 00000	JEWELL RIDGE	VA	24622	ADAMS, ROY & WANDA MAE	3884 JEWELL VALLEY RD.	JEWELL RIDGE, VA	24622	Buchanan	93679	Garden	010500	105	4183.8680	57700	9600	2500	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	614.8350	652.4935	624.6232	2	PERSON		DISMAL RIVER	0209	52			1
4660-39-9891	12730	51	027	001523 PAGE DR,OAKWOOD,VA 24631	OAKWOOD	VA	24631	CONSOL BUCHANAN MINING COMPANY		CANONSBURG, PA	15317	Buchanan	93951	Hurricane	010600	106	3469.6827	700	4000	100000	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.5856	474.6953	457.6243	0.1000	BUSINESS	2121	GARDEN CREEK	0516	110			1
4603-62-1569	3119	51	027	004155 OLD GREENBRIER RD,HAYSI,…	HAYSI	VA	24256	COLEMAN, JANICE FAY D.	4155 OLD GREENBRIER RD	HAYSI, VA	24256	Buchanan	95167	Prater	010300	103	12048.6707	72900	10400	1000	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	462.8679	494.5045	468.1628	2.5000	PERSON		GREENBRIER CREEK	160	299			5
4691-35-2255	7777	51	027	001287 MAPLELEAF HOLLOW RD,RAVE…	RAVEN	VA	24639	HYLTON, JOHN WAYNE & LISA KAY	1287 MAPLELEAF HOLLOW RD	RAVEN, VA	24639	Buchanan	93679	Garden	010600	106	196070.4366	77300	32600	1000	2	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	642.7612	836.4302	728.8371	50.1200	PERSON		CLIFTON FK	0274	486			1
4634-64-4507	881	51	027	001098 WALNUT ST ,GRUNDY ,VA 24…	GRUNDY	VA	24614	CORTES, MICHAEL	1628 NORMAN ST	RIDGEWOOD, NY	11385	Buchanan	95775	South Grundy	010400	104	450.7547	29100	52300	70000	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	319.9413	339.1195	325.5787	0.1200	PERSON		WALNUT STREET	412	513			8
4669-40-5199	8513	51	027	008466 HURLEY RD ,HURLEY ,VA 24…	HURLEY	VA	24620	JUSTUS, HURSHELL KENNETH & DIANE	8435 HURLEY RD.	HURLEY, VA	24620	Buchanan	94151	Knox	010100	101	4415.4957	4000	5500	5000	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	310.3062	353.9205	328.2649	0	PERSON		KNOX CREEK	0226	172			3
4644-79-1746	7647	51	027	001018 BLUEGILL RD, , 00000	GRUNDY	VA	24614	HURLEY, FRANK & PEGGY SUE	1018 BLUEGILL RD	GRUNDY, VA	24614	Buchanan	94903	North Grundy	010400	104	5403.4672	124500	15000	9300	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	353.7365	472.0806	385.8524	0	PERSON		SLATE CRK	0254	772			4
4558-15-5485	7085	51	027	001044 LONG RIFLE RD,ROWE,VA 24…	ROWE	VA	24646	LESTER, ELMER LEE & WANDA MARIE	C/O ELMER LESTER	ROWE, VA	24646	Buchanan	93951	Hurricane	010700	107	10107.6958	4000	10000	15000	2	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	746.5383	776.9052	763.5697	1	PERSON		GARDEN CREEK	0216	464			2
4632-92-4707	3839	51	027	001086 COOK RD,VANSANT,VA 24656	VANSANT	VA	24656	COOK, ALBERT DWIGHT, DANNY ETALS	C/O ALBERT DWIGHT COOK	VANSANT, VA	24656	Buchanan	95775	South Grundy	010600	106	64163.0310	43200	18100	2350	3	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	390.4543	628.3477	488.7218	21.1700	PERSON		BIG PRATER CRK-DRY FK	0166	257			7
4611-79-1411	19314	51	027	001415 WAR FORK RD,VANSANT,VA 2…	VANSANT	VA	24656	CLEVINGER, JAMES A & VIOLET	1415 WAR FORK RD	VANSANT, VA	24656	Buchanan	95167	Prater	010700	107	10207.7213	66000	8400	50000	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	499.8763	567.1672	525.0210	3.0299	PERSON		WAR FK	416	79			5
4661-19-4682	16150	51	027	008829 GARDEN CREEK RD,OAKWOOD,…	OAKWOOD	VA	24631	CHAMBERS, SHELBY JEAN	4609 PEA PATCH RD	JEWELL RIDGE, VA	24622	Buchanan	93951	Hurricane	010600	106	8130.2855	8000	8500	12000	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	403.1043	507.5375	440.8567	2	PERSON		GARDEN CREEK	247	407			1
4657-94-4412	8665	51	027	001393 BRUSHY FORK RD,GRUNDY ,V…	GRUNDY	VA	24614	JUSTUS, SONNY ROGER & JENNY LOU	1393 BRUSHY FORK RD	GRUNDY, VA	24614	Buchanan	94151	Knox	010100	101	2412.0883	19100	5000	3000	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	416.8580	428.2158	420.9081	1	PERSON		BRUSHY FK. OF LESTERS FK.	0288	336			3
4625-05-7162	15927	51	027	000000 BILLY STILTNER RD, , 000…	GRUNDY	VA	24614	BUCHANAN COUNTY BOARD OF SUPERV…	PO BOX 950	GRUNDY, VA	24614	Buchanan	94903	North Grundy	010100	101	766.3279		3000	45950	1	51027C	2026-01-08	AE	FLOODWAY	289.6008	296.7348	293.6226	0.1400	PERSON		LEVISA RIVER	0283	778			14
4589-08-5837	5213	51	027	004231 OLD KENTUCKY TURNPIKERD,…	RAVEN	VA	24639	DYE, ROCKY W & PATTY LYNN		RAVEN, VA	24639	Buchanan	93679	Garden	010600	106	44460.8457	9600	16000	29000	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	527.1851	734.3577	629.3931	11.0100	PERSON		LEVISA RIV NEAR MARVIN	476	725			1
4559-71-0602	8804	51	027	003086 GARDEN CREEK RD,ROWE,VA …	ROWE	VA	24646	KEEN, JOSEPH KYLE & WANDA LOU	3086 GARDEN CREEK RD	ROWE, VA	24646	Buchanan	93951	Hurricane	010600	106	2051.0171	115300	6000		1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	538.9332	552.8496	542.3067	0.7000	PERSON		GARDEN CREEK-ROSIN CAMP B	0233	190			2
4631-08-0655	2513	51	027	001433 LEEMASTER DR ,VANSANT,VA…	VANSANT	VA	24656	LAMB, JOHNNY EARL JR		VANSANT, VA	24656	Buchanan	95167	Prater	010700	107	1022.9520	7600	6000	3000	1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	388.3502	409.2815	395.4860	0	PERSON		BIG PRATER CRK	0516	525			7
4770-92-1141	13350	51	027	001398 FOX FARM RD,HURLEY ,VA 2…	HURLEY	VA	24620	RASNAKE, REX KENNEDY & PATRICIA,	1256 FOX FARM RD	HURLEY, VA	24620	Buchanan	94151	Knox	010100	101	16329.1374	6500	4000		3	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	401.7222	438.7450	409.7755	1	PERSON		GUESSES FORK	0214	194			3
4632-55-9868	3276	51	027	001081 DOLPHIN RD,VANSANT,VA 24…	VANSANT	VA	24656	PHILLIPS, GWENDOLYN	1081 DOLPHIN RD	VANSANT, VA	24656	Buchanan	95775	South Grundy	010600	106	2664.5403	18000	5900		1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	359.2538	370.1250	364.2859	0.9500	PERSON		BIG PRATER CRK	0571	221			7
4631-72-6916	6465	51	027	001213 SHORTRIDGE BRANCH RD,VAN…	VANSANT	VA	24656	HAGERMAN, ALLEN EDWARD & REBECC…	1213 SHORTRIDGE BRANCH RD	VANSANT, VA	24656	Buchanan	95167	Prater	010700	107	32955.7397	31900	9000		1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	426.9106	567.3307	484.8735	7.0500	PERSON		RATTLESNAKE BR. OF BIG PR	0347	222			7
4692-09-7027	9787	51	027	001232 FAMILY CIRCLE RD,PILGRIM…	PILGRIMS KNOB	VA	24634	LESTER, TROY, SHIRLEY ANN, BILL…	BOX 101	PILGRIM KNOB, VA	24634	Buchanan	93679	Garden	010600	106	1023.9568	39600	5200		1	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	509.4374	521.5000	515.0567	0.2500	PERSON		DISMAL RIVER	0000	0			1