Saved query ac324a3a02b0b66d

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

37/80

Live SQL

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

23,261 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	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
164R1750E	131929	51	169	1207 W BEAR WALLOW RD	CASTLEWOOD	VA	24224	NUCKLES BRIAN DALE	HIGHWAY 71 PO BOX 59 NICKLESVIL…	NICKLESVILLE	VA	24271	SCOTT	91576	3	030400	304	103009.8716	60300	0	-6300	72900	30900	2012-07-31	1	1	1992	1	1000	3	1	1	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	655.6301	740.9838	699.8739	1	SINGLE FAMILY	C-10		0.5510	PERSON	LOTS	717	805	UNDETERMINED	UNDETERMINED	CENTRAL AIR	GRD	ASPHALT	VINYL	2026.2	2024	01
166L430	6599	51	169	420 DEERLICK RD	PINEY FLATS	VA	37686	AUSTIN RONALD R OR BRADLEY R	2893 DEVAULT BRIDGE RD PINEY FL…	PINEY FLATS	TN	37686	SCOTT	91876	5	030400	304	2127.5743	7800	1000		8800		2018-05-18	1	1		1	1000				51167C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	489.9077	510.3031	499.9970	COMMERCIAL	HOMESITE		COMMERCIAL	2.5000	PERSON	PINE RIDGE	0832	416				GRAVEL			2026.2	0	02
162R1641A	2712	51	169	4086 LITTLE DUCK RD	NICKELSVILLE	VA	24271	STAPLETON FREDA R	4086 LITTLE DUCK ROAD NICKELSVI…	NICKELSVILLE	VA	24271	SCOTT	91576	3	030500	305	76185.2385	28000	9000		37000			1	1	20	1					51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	621.4371	665.9722	644.7384	COMMERCIAL		0	COMMERCIAL	20	PERSON	SCOTT LINE	0508 - 515	515				GRD			2026.2	2020	01
165L1A	6059	51	169	5211 SINKING CREEK HWY	DUNGANNON	VA	24245	MCBRYAR DONNA OR BRIAN BROMMER	5108 SINKING CREEK HWY DUNGANNO…	DUNGANNON	VA	24245	SCOTT	91576	3	030400	304	1551.1761	11300	4800		16100			1	1		1			0		51167C	2026-01-08	A		445.4677	454.4176	448.9493	1	MANUFACTURED	R-1		0.5000	PERSON	SINKING	0605	239				NONE			2026.2	2024	02
45 A 4	12053	51	169	25210 US HWY 23	DUFFIELD	VA	24244	GILES AUDNIA C L E					SCOTT	92026	6	030300	303	2394.0031	8000	11300		19300	1500	1900-01-01	2	1	0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	455.7205	464.1467	459.6655	61	WOODED			0.7500	PERSON	JASPER	318	279							2026.2		TA
167 A 95	4478	51	169	157 FLANARY DR	GATE CITY	VA	24251	LOWE RICKY					SCOTT	91426	2	030600	306	662.9013	600	23000		23600	6000	2022-11-07	1	1	0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	421.6876	425.1022	423.4416	61	WOODED			0.1700	PERSON	CARTERS VALLEY	610	445							2026.2		ES
165L22	231686	51	169	3161 SUNNY POINT RD	CASTLEWOOD	VA	24224	MARSHALL MELISSA LEANNE OR	3161 SUNNY POINT RD CASTLEWOOD …	CASTLEWOOD	VA	24224	SCOTT	91576	3	030400	304	38039.9871	18400	4000		22400			1	1					0		51167C	2026-01-08	A		441.1252	511.0841	462.5701	COMMERCIAL	MANUFACTURED		COMMERCIAL	9.6500	PERSON	PICK UP FROM DEED AND	808	304							2026.2	2024	02
163R1747A	40640	51	169	892 BEAR WALLOW RD	CASTLEWOOD	VA	24224	DEAN WILLIAM A OR JOYCE R	892 BEAR WALLOW RD CASTLEWOOD V…	CASTLEWOOD	CASTLEWOOD	VA	SCOTT	91576	3	030400	304	14223.5447	11200	8000		19200			1	1							51167C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	618.1029	635.6312	625.2194	0				3	PERSON	BEAR WALLOW	0550	920							2026.2	0	01
40 A 6	5827	51	169		GATE CITY	VA	24251	MANN DAVID AND JUDY					SCOTT	91876	5	030300	303	204661.7778	5200	124900		130100	243710	2013-02-26	1	1	0	0		0			51169C	2026-01-08	AE		384.1850	399.3536	390.8938	65	ROLLING/SLOPING			156.0900	PERSON	CLINCH RIVER	565	1817							2026.2		FL
101 A 68	12133	51	169	2887 COPPER CREEK RD	DUFFIELD	VA	24244	STEWART GREGORY					SCOTT	91876	5	030400	304	785.2723		2300		2300	500	1998-06-08	0		0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	539.6644	557.1926	550.3189	61	WOODED			1.5000	PERSON	CLINCH RIVER BLUFF	470	790							2026.2		TA
100 A 96	12673	51	169	161 WEMBECK DR	KINGSPORT	VA	37660	MENDENHALL SCOTT					SCOTT	91876	5	030400	304	383.0890		10000		10000	20000	2020-06-25	0		0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	425.5553	437.8304	432.1135	61	WOODED			5	PERSON	CLINCH RIVER	598	568							2026.2		TA
89 A 66	9733	51	169	231 PLEASANT VIEW LN	NICKELSVILLE	VA	24271	WAMPLER BILLY DOROTHY					SCOTT	91576	3	030500	305	164.8595		11300		11300	3500	1984-01-01	0		0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	571.6527	572.8007	571.9856	61	WOODED			4.5000	PERSON	MOCCASIN RIDGE	0342	357							2026.2		JO
90 3 7	8429	51	169	546 CORN RIDGE LN	NICKELSVILLE	VA	24271	DELANO MICHAEL					SCOTT	91576	3	030500	305	0.0009	60200	21000		81200		2023-03-24	1	1	1960	1		3			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				64	BRUSHY			1.2700	PERSON	MOCCASIN CREEK	0611	1610	SPACE HEATER	WOOD	OTHER				2026.2		JO
120 A 6	10286	51	169	1192 REDWINE HOLLOW LN	DUFFIELD	VA	24244	QUALLS CARL THOMAS					SCOTT	92026	6	030200	302	952.3663		75000		75000	14500	1900-01-01	0		0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	459.8027	471.7643	465.7438	64	BRUSHY			62.5000	PERSON	BIG RIDGE	358	98							2026.2		PO
121 A 26 14	19820	51	169	218 TEACH DR	DUFFIELD	VA	24244	VANOVER OSCAR L AND SANDRA L					SCOTT	91876	5	030200	302	0.1277	60100	37700		97800	45000	2011-08-29	1	1	2006	1		4			51169C	2026-01-08	A					61	WOODED			11.8600	PERSON	COPPER CREEK	558	2042	CENTRAL AIR	GAS	OTHER				2026.2		ES
129 A 49	7435	51	169	747 DOWELL GAP RD	HILTONS	VA	24258	MASON PATSY ELIZABETH					SCOTT	91426	2	030500	305	6.0713	103800	81600		185400		2019-05-12	1	1	1936	1		2			51169C	2026-01-08	A		391.5227	391.8496	391.6635	65	ROLLING/SLOPING			61.2500	PERSON	LITTLE VALLEY			HEAT PUMP	ELECTRIC	HEAT PUMP				2026.2		FU
62 5 6	17117	51	169	23446 US HWY 23 N	DUFFIELD	VA	24244	JOHNSON HURSHEL LEE KAREN KAY					SCOTT	92026	6	030300	303	49348.5343		12000		12000	1000	1996-04-16	0		0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	436.5479	731.9119	552.5419	61	WOODED			12	PERSON	NORTH FORK	471	138							2026.2		TA
151 A 13	6735	51	169	10104 BRISTOL HWY	HILTONS	VA	24258	HENSLEY JEFFERY SCOTT					SCOTT	91426	2	030500	305	711.5510		58700		58700	57960	2011-06-30	0		0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	511.0452	540.4567	523.1947	64	BRUSHY			108.6400	PERSON	U S 58	558	262							2026.2		FU
180 A 12	6781	51	169	486 PIPPIN LN	BRISTOL	VA	24202	HOWARD RICHARD S AND DOREEN					SCOTT	91426	2	030500	305	1334.7812		77100		77100	315000	2007-03-06	0		0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	598.8507	607.3229	602.4356	64	BRUSHY			43.3700	PERSON	WALKER MOUNTAIN	536	1383							2026.2		FU
11 A 5	1392	51	169	107 VALLEY CREST DR	CHURCH HILL	VA	37645	STOKES ROBERT PATTON					SCOTT	91876	5	030300	303	3096.7280		1100		1100		2018-05-17	0		0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	973.5889	1000.1088	985.1163	61	WOODED			1.4200	PERSON	POWELL MTN	589	168							2026.2		DE
4A A 2	6323	51	169	19081 STONE MOUNTAIN RD	ABINGDON	VA	24210	TILLER JERRY					SCOTT	91876	5	030300	303	435.7399		3500		3500		1974-01-01	0		0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	848.2390	850.3066	849.2130	61	WOODED			0	PERSON	BLACK HILL	281	402							2026.2		FL
170 A 12	7699	51	169	300 NEWLAND AVE	KINGSPORT	VA	37660	DORAN CHARLES LELAND LANA					SCOTT	91426	2	030500	305	0.4779		35100		35100	19000	1992-05-01	0		0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	453.5565	453.5565	453.5565	61	WOODED			7.0300	PERSON	CARTERS VALLEY	395	254							2026.2		FU
4A A 24	5894	51	169		COEBURN	VA	24230	HAWKINS CLIFTON CHARLES ROBERT					SCOTT	91876	5	030300	303	200.1574		40200		40200		2011-02-18	0		0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	844.9992	850.1033	847.4913	64	BRUSHY			67	PERSON	BLACK HILL	0295	264							2026.2		FL
160 A 23	4041	51	169	2106 S MOCCASIN ST	KINGSPORT	VA	37660	PERRY RHONDA R					SCOTT	91276	1	030200	302	2341.3842		2400		2400		1900-01-01	0		0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	488.2148	515.4249	499.8436	61	WOODED			3	PERSON	POOR VALLEY	229	310							2026.2		ES
67 A 28A	1635	51	169	10172 CLINCH RIVER HWY	FORT BLACKMORE	VA	24250	PERRY JAMES AND RITA					SCOTT	91876	5	030300	303	4657.2684		1500		1500		2021-06-08	0		0	0		0			51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	391.6571	416.5891	401.1217	61	WOODED			1.1500	PERSON	CLINCH RIVER	603	5							2026.2		DE