Saved query 9c932a5ec40093e7

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

41/80

Live SQL

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

13,245 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	saleamt	saledate	numbldgs	numunits	yearbuilt	numfloors	bldgsqft	bedrooms	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	zoningdesc	taxacres	ownertype	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	fireplaces	heating	heatfuel	cooling	foundation	roofcover	lrversion	taxyear	taxdistrict
3684-86-6926	33789	51	051	101 SPRING HAVEN DR	FANCY GAP	VA	24328	REAVES JAMES MICHAEL	101 SPRING HAVEN DR	FANCY GAP	VA	24328	DICKENSON	95575	SAND LICK	040100	401	855.0533	216400	105000		321400	450000	2024-06-29	1	1	1982	1	2496	3	0	2	51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	453.2344	457.7406	454.4702	06	ROCK LICK	SF-2		0.2300	PERSON	AC 28	15	238						1	CENTRAL AIR	ELECTRIC	CENTRAL AIR	SLAB	COMPOSITION	2026.2	2024	6
3685-51-6409	33789	51	051	101 SPRING HAVEN DR	FANCY GAP	VA	24328	REAVES JAMES MICHAEL	101 SPRING HAVEN DR	FANCY GAP	VA	24328	DICKENSON	95575	SAND LICK	040100	401	312.2899	214750	105800		320550	345000	2023-12-01	1	1	1975	1	2898	4	0	3	51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	447.2250	447.8006	447.3632	100	SINGLE FAMILY RESIDENTIAL	SF-1	SINGLE FAMILY RESIDENTIAL	0	PERSON	GRASSY CREEK	0000	0						1	CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONCRETE		2026.2	2024	6
3685-51-6523	33789	51	051	101 SPRING HAVEN DR	FANCY GAP	VA	24328	REAVES JAMES MICHAEL	101 SPRING HAVEN DR	FANCY GAP	VA	24328	DICKENSON	95575	SAND LICK	040100	401	332.2203	452700	46600		499300	345000	2021-05-28	1	1	2011	1	2898	4	0	3	51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.7472	447.8630	447.5703	124-12-8	VACANT	RESIDENTIAL	SINGLE FAMILY	0	PERSON	GRASSY CREEK 13-28 AC 161 LOTS …	579	356						1	CENTRAL AIR	ELECTRIC	CENTRAL AIR	CRAWL		2026.2	2024	06 ROCK LICK
3685-51-7359	33789	51	051	101 SPRING HAVEN DR	FANCY GAP	VA	24328	REAVES JAMES MICHAEL JANE DOE	101 SPRING HAVEN DR	FANCY GAP	VA	24328	DICKENSON	95575	SAND LICK	040100	401	326.9349	452700	46600		499300	345000	2021-05-28	1	1	2011	1	1904	3	0	2	51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	447.3500	448.2542	447.6766	100	SINGLE FAMILY	SF-2		0	PERSON	GRASSY CREEK GEO MULLINS 35-37 …	0214	377							CENTRAL AIR	ELECTRIC	CENTRAL AIR	SLAB	ASPHALT	2026.2	2024	6
3685-15-4895	11861-1	51	051	1757 CROW PASS RD	BREAKS	VA	24607	MUSICK GROVER SWAIN ETALS	P O BOX 11	BREAKS	VA	24607	DICKENSON	95575	SAND LICK			7486.8085	17600	17000		34600	2700		1	1	1930	1	1350	2		1	51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	382.9792	426.0117	400.4013	SINGLE FAMILY COUNTY				10	GOVERNMENT	GRASSY CREEK 0 0 AC 10 MUSICK R…	0200	298	GOVT STATE	RESTRICTED	III	BREAKS INTERSTATE PARK	STATE PARK		UNDETERMINED	OIL	UNDETERMINED	WOOD		2026.2	2021	06 ROCK LICK
3685-51-6536	33789	51	051	101 SPRING HAVEN DR	FANCY GAP	VA	24328	REAVES JAMES MICHAEL	101 SPRING HAVEN DR	FANCY GAP	VA	24328	DICKENSON	95575	SAND LICK			297.2103	345000	145000		490000	345000	2023-01-01	1	1	2011	1	2898	4	0	3	51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.7313	447.7069	447.3447	100	SINGLE FAMILY RESIDENTIAL	SF-1	SINGLE FAMILY RESIDENTIAL	0	PERSON	GRASSY CREEK	0000	0						1	CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONCRETE		2026.2	2024	6
3685-51-7453	33789	51	051	101 SPRING HAVEN DR	FANCY GAP	VA	24328	REAVES JAMES MICHAEL JANE DOE	PO BOX 453	FANCY GAP	VA	24328	DICKENSON	95575	SAND LICK	040100	401	524.6705	452700	46600		499300	345000	2021-05-28	1	1	1974	2	2560	4	1	2	51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.7597	447.9982	447.4957			SF-2		0	PERSON	GRASSY CREEK	0000	0							CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONCRETE	ASPHALT SHINGLE	2026.2	2024	6
3691-69-2810	2024	51	051	101 SPRING HAVEN DR	FANCY GAP	VA	24328	REAVES JAMES MICHAEL	101 SPRING HAVEN DR	FANCY GAP	VA	24328	DICKENSON	95575	SAND LICK	040100	401	8147.1346	317200	100000		417200	345000	2024-02-26	1	1	2001	2	2465	4	0	3	51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	476.1231	516.6963	494.0274	05	PRATER	R-1		2.1000	PERSON	RUSSELL PRATER CREEK 4 1 633 AC…	0000	NO PAGE						1						2026.2	2021	05 PRATER
126C-1758G	1830592	51	051	5569 E HAZEL MOUNTAIN RD	CLEVELAND	VA	24225	SHINN FRANKLIN JUDY CARTER	149 INLET LANE	GRANDY NC		27939	DICKENSON	93495	ERVINTON	040400	404	16291.3231	110500	117100	106500	14600			1	1	1951		2142	3	1	1	51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD					SINGLE FAMILY			399	PERSON	SANDY RIDGE	493	338							UNDETERMINED	UNDETERMINED	OTHER	CONCRETE BLOCK	METAL	2026.2	2025
4517-74-9606	13453-1	51	051	267 YATES ESTATE CIR	CEDAR BLUFF	VA	24609	RATLIFF BOB H RITA SUE	267 YATES ESTATE CIRCLE	CEDAR BLUFF	VA	24609	DICKENSON	93495	ERVINTON	040400	404	3093.7589		1800		1800	4000	1919-07-04	0		0						51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	451.6847	460.3270	453.8791	SINGLE FAMILY COUNTY	LAND		SINGLE FAMILY COUNTY	1.5000	PERSON	INDIAN CRK 0 0 AC LOT FARMER	0219	350												2026.2	2021	02 HURRICANE
4517-83-1867	21157-1	51	051	146 E MAIN ST	ABINGDON	VA	24210	CF HIGHLANDS LLC	146 EAST MAIN ST	ABINGDON	VA	24210	DICKENSON	93495	ERVINTON	040400	404	5247.8336		1100		1100	5619980	2019-07-17	1	1	1979								—		454.6032	463.0866	457.4776	COMMERCIAL & INDUSTRIAL	HURRICANE		COMMERCIAL INDUSTRIAL	1.1000	BUSINESS	INDIAN CRK DUTY AC 1 1 NORFOLK …	586	166												2026.2	2021	02 HURRICANE
USFS		51	051	1566 CUTTER CRK	CLINTWOOD	VA	24228						DICKENSON	96407	WILLIS	040200	402	28972973.7086	86600	86600	86600	0	220000	2024-03-20	1	1	2005		1056	1	1	1	51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD					SINGLE FAMILY														UNDETERMINED	UNDETERMINED	HEAT PUMP	CONCRETE BLOCK	METAL	2026.2	2025
3685-51-7476	9918	51	051	001394 KING SOLOMON HWY	BREAKS	VA	24607	WORLEY PAULA C MORRE JAMES IV	0 BREAKS VA	BREAKS	VA	24607	DICKENSON	95575	SAND LICK	040100	401	511.3560	59500	5000					1	1							51027C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.7394	447.8083	447.5144					0	PERSON	GRASSY CREEK	0000	0												2026.2		6
3685-51-3716	5449	51	051	000000		VA	00000	JUSTICE ANTOINETTE	C O ANTOINETTE JUSTICE BREAKS VA	BREAKS	VA	24607	DICKENSON	95575	SAND LICK	040100	401	948.1324		2000			291400		0								51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.4749	447.8165	447.2953					0	PERSON	GRASSY CREEK	0002	0												2026.2		6
3685-42-8070	5451	51	051	000000 COUNTY MEADOWS RD	BREAKS	VA	24607	LOCKHART CHRISTOPHER JUDY	HAYSI VA	HAYSI	VA	24256	DICKENSON	95575	SAND LICK	040100	401	368.2413		20000					0								51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.0689	449.1656	446.7454					0	PERSON	GRASSY CREEK	0006	55												2026.2		6
3685-51-3782	5449	51	051	000000		VA	00000	JUSTICE ANTOINETTE	C O ANTOINETTE JUSTICE BREAKS VA	BREAKS	VA	24607	DICKENSON	95575	SAND LICK	040100	401	1411.8961		2000			291400		0								51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.5368	447.8851	447.3386					0	PERSON	GRASSY CREEK	0002	0												2026.2		6
3685-41-8994	5451	51	051	000000 COUNTY MEADOWS RD	BREAKS	VA	24607	LOCKHART CHRISTOPHER JUDY	HAYSI VA	HAYSI	VA	24256	DICKENSON	95575	SAND LICK	040100	401	376.5399		20000					0								51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.2122	448.6586	446.6766					0	PERSON	GRASSY CREEK	0006	55												2026.2		6
3685-41-8976	5451	51	051	000000 COUNTY MEADOWS RD	BREAKS	VA	24607	LOCKHART CHRISTOPHER JUDY	HAYSI VA	HAYSI	VA	24256	DICKENSON	95575	SAND LICK	040100	401	395.7911		20000					0								51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.1220	449.1180	446.6321					0	PERSON	GRASSY CREEK	0006	55												2026.2		6
3685-41-9946	5451	51	051	000000 COUNTY MEADOWS RD	BREAKS	VA	24607	LOCKHART CHRISTOPHER JUDY	HAYSI VA	HAYSI	VA	24256	DICKENSON	95575	SAND LICK	040100	401	559.4019		20000					0								51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.2896	449.0713	446.8717					0	PERSON	GRASSY CREEK	0006	55												2026.2		6
3685-51-0956	5451	51	051	000000 COUNTY MEADOWS RD	BREAKS	VA	24607	LOCKHART CHRISTOPHER JUDY	HAYSI VA	HAYSI	VA	24256	DICKENSON	95575	SAND LICK	040100	401	311.2792		20000					0								51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.3697	449.5046	447.0676					0	PERSON	GRASSY CREEK	0006	55												2026.2		6
3685-51-0926	5451	51	051	000000 COUNTY MEADOWS RD	BREAKS	VA	24607	LOCKHART CHRISTOPHER JUDY	HAYSI VA	HAYSI	VA	24256	DICKENSON	95575	SAND LICK	040100	401	325.1647		20000					0								51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.3291	448.6308	446.9572					0	PERSON	GRASSY CREEK	0006	55												2026.2		6
3685-51-0906	5451	51	051	000000 COUNTY MEADOWS RD	BREAKS	VA	24607	LOCKHART CHRISTOPHER JUDY	HAYSI VA	HAYSI	VA	24256	DICKENSON	95575	SAND LICK	040100	401	292.9412		20000					0								51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.2985	448.1421	446.9515					0	PERSON	GRASSY CREEK	0006	55												2026.2		6
3685-51-1906	5451	51	051	000000 COUNTY MEADOWS RD	BREAKS	VA	24607	LOCKHART CHRISTOPHER JUDY	HAYSI VA	HAYSI	VA	24256	DICKENSON	95575	SAND LICK	040100	401	294.1371		20000					0								51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.3846	450.0988	447.2169					0	PERSON	GRASSY CREEK	0006	55												2026.2		6
3685-51-0976	5451	51	051	000000 COUNTY MEADOWS RD	BREAKS	VA	24607	LOCKHART CHRISTOPHER JUDY	HAYSI VA	HAYSI	VA	24256	DICKENSON	95575	SAND LICK	040100	401	256.6967		20000					0								51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.3543	450.2612	447.1553					0	PERSON	GRASSY CREEK	0006	55												2026.2		6
3685-51-1925	5451	51	051	000000 COUNTY MEADOWS RD	BREAKS	VA	24607	LOCKHART CHRISTOPHER JUDY	HAYSI VA	HAYSI	VA	24256	DICKENSON	95575	SAND LICK	040100	401	274.2024		20000					0								51051C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.2972	449.7181	447.3115					0	PERSON	GRASSY CREEK	0006	55												2026.2		6