Saved query bde82d0f65a0701d

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

22,272 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	saledate	numbldgs	numunits	yearbuilt	numfloors	bedrooms	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	naicscode	legaldesc	book	page	placename	placetype	heating	heatfuel	cooling	taxdistrict
6439	51	169	528 BRANDONWOOD RD.	KINGSPORT	TN	37660-1679	FIDO FARMS, L. L. C.	528 BRANDONWOOD RD.	KINGSPORT	TN	37660-1679	Scott	91426	2	030500	305	17761.1291	52600	100700	153300	48500	1975-01-01	1	1	1900	2	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	427.9340	442.8588	433.1849	64	BRUSHY	45.8000	BUSINESS	11111	COVE CREEK	536	1863			SPACE HEATER	OIL	CENTRAL AIR	FU
3375	51	169	2836 YUMA ROAD	GATE CITY		24251	RELIGION; OAK GLEN BAPTIST CHUR…				24251	Scott	91276	1	030600	306	11175.0901	1223400	58700	1282100	100000	2005-03-21	1	1	2008	1	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	389.0840	398.0658	394.4649	66	LEVEL	2.7400	NONPROFIT	81311	POOR VALLEY	524	2355	OAK GLEN BAPTIST CHURCH	CHRISTIAN_PLACE_OF_WORSHIP	HEAT PUMP	ELECTRIC	HEAT PUMP	ES
418	51	169	1910 MIDWAY RD	GATE CITY	VA	24251	PIERSON, ELMER GRAY, JR AND JUD…	1910 MIDWAY RD	GATE CITY	VA	24251	Scott	91576	3	030400	304	22178.9084	20000	23200	43200	32000	2001-03-13	1	1	1940	1	2	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	582.4424	610.7727	598.2512	61	WOODED	5	PERSON		COPPER CREEK	498	2305			HEAT PUMP	ELECTRIC	HEAT PUMP	DE
3445	51	169	426 LONG RIDGE RD	WEBER CITY	VA	24290	MCCOY, ASHTON BROOKE	426 LONG RIDGE RD	WEBER CITY	VA	24290	Scott	91426	2	030600	306	4315.4636	84900	28000	112900	155000	2022-04-19	1	1	1976	1	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	393.1139	409.3638	399.1083	61	WOODED	1	PERSON		HOLSTON RIVER	607	1063			HEAT PUMP	ELECTRIC	HEAT PUMP	ES
3577	51	169	128 HOLSTON CT LN	WEBER CITY	VA	24290	ELAM, LEANN	128 HOLSTON CT LN	WEBER CITY	VA	24290	Scott	91276	1	030600	306	1404.8374	112300	33000	145300	74500	2013-11-19	1	1	1955	1	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	381.1095	384.5711	383.8005	61	WOODED	0	PERSON		HOLSTON RIVER	569	1208			HEAT PUMP	ELECTRIC	HEAT PUMP	ES
17007	51	169	349 LURAY RD.	GATE CITY	VA	24251	CLARK, ROGER DALE AND JENNIFER A	349 LURAY RD.	GATE CITY	VA	24251	Scott	91576	3	030400	304	12014.9739	90400	23300	113700	10	2018-09-14	1	1	2000	1	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	637.5977	667.1633	650.3538	61	WOODED	3.1300	PERSON		VALLEY CREEK	590	1395			HEAT PUMP	ELECTRIC	HEAT PUMP	JO
10097	51	169	1112 BEBE BRANCH LN	DUFFIELD	VA	24244	CARTER, JAMES EDDIE AND CINDY L…	1112 BEBE BRANCH LN	DUFFIELD	VA	24244	Scott	92026	6	030200	302	12420.4183	42200	13400	55600	5000	2008-01-25	1	1	1979	1	2	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	446.6691	504.2169	475.7405	61	WOODED	3	PERSON		BIG RIDGE	541	1805			SPACE HEATER	WOOD	OTHER	PO
5389	51	169	1688 EAST CARTERS VALLEY ROAD	GATE CITY	VA	24251	LANE, LEIGH ANN	1688 EAST CARTERS VALLEY ROAD	GATE CITY	VA	24251	Scott	91426	2	030600	306	3245.7039	132600	44000	176600	92500	2001-12-07	1	1	1985	1	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	412.5111	418.6203	416.8359	61	WOODED	3.0099	PERSON		CARTERS VALLEY	503	624			HEAT PUMP	ELECTRIC	HEAT PUMP	ES
12666	51	169	527 FAIRVIEW RD	DUFFIELD	VA	24244	ROBINETTE, HAROLD EDWARD	527 FAIRVIEW RD	DUFFIELD	VA	24244	Scott	92026	6	030200	302	52594.0373	61500	16000	77500	7400	1968-01-01	1	1	1957	1	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	374.6963	459.0844	398.4043	61	WOODED	0	PERSON		STOCK CREEK	0371	543			HEAT PUMP	ELECTRIC	HEAT PUMP	TA
13959	51	169	127 LOGAN DR	GATE CITY	VA	24251	PETERS, IVAN E AND JUDY C PETERS	127 LOGAN DR	GATE CITY	VA	24251	Scott	91726	4	030100	301	587.2095	33300	16000	49300	32000	2010-06-04	1	1	1940	1	2	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	402.3771	407.3760	404.6521	60	OPEN	0	PERSON		PARK STREET	2010	1096			HEAT PUMP	ELECTRIC	HEAT PUMP	GA
4766	51	169	3346 DANIEL BOONE RD	GATE CITY	VA	24251	BOWEN, JONATHAN C AND MEGAN B	3346 DANIEL BOONE RD	GATE CITY	VA	24251	Scott	91726	4	030100	301	1010.4337	73800	18000	91800	70000	2004-04-14	1	1	1925	1	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	452.9959	459.1277	455.8131	60	OPEN	0.2500	PERSON		DANIEL BOONE	520	1433			HEAT PUMP	ELECTRIC	HEAT PUMP	ES
5619	51	169	1346 MANVILLE RD	GATE CITY	VA	24251	MANN, GAVIN TYLER	1346 MANVILLE RD	GATE CITY	VA	24251	Scott	91726	4	030100	301	2036.8104	76000	23000	99000	140000	2023-04-28	1	1	1991	1	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	461.7388	474.3171	467.6345	61	WOODED	0.5200	PERSON		BURNT CABIN BR.	612	124			HEAT PUMP	ELECTRIC	HEAT PUMP	ES
4029	51	169	2321 YUMA RD	GATE CITY	VA	24251	FANSLER, JARED AND ASHLEY	2321 YUMA RD	GATE CITY	VA	24251	Scott	91276	1	030600	306	2340.0634	110600	23000	133600	90000	2013-03-12	1	1	1950	16	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	393.2497	397.6352	394.8100	61	WOODED	0	PERSON		POOR VALLEY	565	2277			HEAT PUMP	ELECTRIC	HEAT PUMP	ES
5801	51	169	P. O. BOX 789	COEBURN	VA	24230	HALL, ROCKY, BRETT, & MEGAN HALL	P. O. BOX 789	COEBURN	VA	24230	Scott	91576	3	030400	304	942.5496	58900	13100	72000	20000	2019-05-02	1	1	1988	1	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	455.7453	467.1672	459.8752	61	WOODED	1.5700	PERSON		FALL CREEK	593	557			HEAT PUMP	ELECTRIC	HEAT PUMP	FL
18574	51	169	294 WAGNER DRIVE	GATE CITY	VA	24251	BRICKEY, ANASTASIA LACEY ELIZAB…	294 WAGNER DRIVE	GATE CITY	VA	24251	Scott	91726	4	030100	301	2753.1498	27100	16000	43100	42000	2024-03-13	1	1	1935	1	2	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	511.3831	518.7941	515.4125	61	WOODED	0.6800	PERSON		COPPER CREEK BLUFF	616	393			HEAT PUMP	ELECTRIC	HEAT PUMP	ES
2738	51	169	1400 HAMNER HOLLOW RD	BIG STONE GAP	VA	24219	MCDARIES, JONATHAN	1400 HAMNER HOLLOW RD	BIG STONE GAP	VA	24219	Scott	91726	4	030100	301	1223.0855	1000	10000	11000	2700	2022-12-28	1	1	1930	1	2	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	522.2899	535.1665	528.3703	61	WOODED	0.1200	PERSON		DANIEL BOONE	610	1731			SPACE HEATER	WOOD	OTHER	ES
18913	51	169	654 RED HILL RD	GATE CITY	VA	24251	BRITT, EDGAR RAY JR AND SARAH L…	654 RED HILL RD	GATE CITY	VA	24251	Scott	91726	4	030100	301	2532.8339	373200	94200	467400	40000	2008-06-19	1	1	2009	2	4	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	500.3733	514.7111	509.5794	64	BRUSHY	20.3500	PERSON		PIKES BRANCH	543	2160			HEAT PUMP	ELECTRIC	HEAT PUMP	GA
15479	51	169	158 AMERICANA DR	WEBER CITY	VA	24290	PETERS, ERIC S	158 AMERICANA DR	WEBER CITY	VA	24290	Scott	91276	1	030600	306	652.8817	38500	28000	66500	85000	2022-10-24	1	1	1948	1	2	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	390.6390	392.8850	391.9607	60	OPEN	0.1800	PERSON		W. J. SMITH SUB	610	157			HEAT PUMP	ELECTRIC	HEAT PUMP	WE
12316	51	169	18347 WHITES POINT RD	ABINGDON	VA	24211	FANSLER, PAMELA MICHELLE	18347 WHITES POINT RD	ABINGDON	VA	24211	Scott	91876	5	030300	303	28362.5934	33400	23300	56700	10000	2018-08-06	1	1	1941	1	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	568.6585	621.0690	595.4775	61	WOODED	5.8500	PERSON		COVE RIDGE	590	406			SPACE HEATER	OIL	OTHER	TA
11817	51	169	3423 CLINCH RIVER HWY	DUFFIELD	VA	24244	SUMMEY, JUSTIN B AND TANYA M	3423 CLINCH RIVER HWY	DUFFIELD	VA	24244	Scott	92026	6	030300	303	2066.4303	115400	28000	143400	82000	2020-01-30	1	1	1973	1	3	51169C	2026-01-08	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	379.2720	383.4839	381.0750	61	WOODED	0.5100	PERSON		CLINCH RIVER	596	1125			HEAT PUMP	ELECTRIC	HEAT PUMP	TA
1398	51	169	5027 VETERANS MEMORIAL HWY	GATE CITY	VA	24251	SMITH, RITA KATHLEEN AND ROGER D	5027 VETERANS MEMORIAL HWY	GATE CITY	VA	24251	Scott	91576	3	030400	304	6605.8598	82500	23000	105500	73000	1996-03-05	1	1	1976	1	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	528.9447	558.9454	541.7243	61	WOODED	0.7700	PERSON		COPPER RIDGE	536	355			HEAT PUMP	ELECTRIC	HEAT PUMP	DE
9040	51	169	130 MCCLELLAN TOWN LN	GATE CITY	VA	24251	COMPTON, W. AUSTIN AND TERESA M.	130 MCCLELLAN TOWN LN	GATE CITY	VA	24251	Scott	91576	3	030400	304	74013.2709	9000	100200	109200	155000	2003-09-11	1	1	1898	2	5	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	588.1425	627.7641	609.1154	64	BRUSHY	54.5000	PERSON		MCCONNELL ST.	514	2318			SPACE HEATER	OIL	OTHER	JO
15398	51	169	500 JENNINGS STREET	WEBER CITY	VA	24290	STACY, BUSTER & GLADYS R.	500 JENNINGS STREET	WEBER CITY	VA	24290	Scott	91276	1	030600	306	781.6223	56000	20000	76000	30000	1900-01-01	1	1	1945	1	2	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	380.4774	388.4520	386.8485	60	OPEN	0	PERSON		MOCC. GAP	0325	538			HEAT PUMP	ELECTRIC	HEAT PUMP	WE
13798	51	169	208 BRAMBLEWOOD DR	GATE CITY	VA	24251	COX, EDWIN P III AND LORI L COX	208 BRAMBLEWOOD DR	GATE CITY	VA	24251	Scott	91726	4	030100	301	165.0925	23700	12200	35900	30000	2018-09-05	1	1	1963	1	0	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	404.2526	406.9822	406.2780	60	OPEN	0.0390	PERSON		E JACKSON ST.	0590	1204			CENTRAL AIR	OIL	CENTRAL AIR	GA
8325	51	169	199 GREENHOUSE DR	NICKELSVILLE	VA	24271	COMBS, JIMMY AND FREDIA M	199 GREENHOUSE DR	NICKELSVILLE	VA	24271	Scott	91576	3	030400	304	225099.0098	91800	159000	250800		1900-01-01	1	1	1950	1	3	51169C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	487.0580	564.5192	536.9452	64	BRUSHY	59.7900	PERSON		COPPER CREEK	532	1388			HEAT PUMP	ELECTRIC	HEAT PUMP	JO