Saved query e0da142770da3ad5

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

37/80

Live SQL

SELECT * 
FROM "parcel_layer" 
WHERE statefp = '51' 
  AND countyfp = '173'

35,822 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	saledate	numbldgs	yearbuilt	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	taxacres	ownertype	naicscode	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	taxdistrict
86-A-47	74454	51	173	150 OLD SLASH	TROUTDALE	VA	24378	122 OLD SLASH RD	TROUTDALE	VA	24378-4378	Smyth	95511	Rye Valley	030702	307.0200	4091.3178	57400	12000	69400	14400	2012-03-15	1	1954	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	950.8352	959.8127	954.4286		1	PERSON	7212	WHITE TOP 86 A 47	825	824	GOVT FEDERAL	RESTRICTED	OTHER	MOUNT ROGERS NATIONAL RECREATIO…	NATIONAL RECREATION AREA	03
76-A-212B	47971	51	173	1505 ST CLAIRS CREEK	CHILHOWIE	VA	24319	1505 ST CLAIRS CREEK RD	CHILHOWIE	VA	24319-4319	Smyth	95511	Rye Valley	030702	307.0200	11447.9206	163500	22500	186000	73900		1	1988	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	737.6194	760.1652	749.2090		2.7900	PERSON	7212	ST RD 600 BLEVINS TR 2 76 A 2…	539	301	GOVT FEDERAL	RESTRICTED	OTHER	MOUNT ROGERS NATIONAL RECREATIO…	NATIONAL RECREATION AREA	03
74B-1-16	159638	51	173	0 SQUIRREL	SUGAR GROVE	VA	24375	P O BOX 834	HONAKER	VA	24260-4260	Smyth	95511	Rye Valley	030500	305	2326.4850	7300	6000	13300	2000		1		51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	793.9323	818.4372	804.7282		0.5699	PERSON	7212	SADDLEBROOK FARMS SEC 6-LOT 16 …	503	50	GOVT FEDERAL	RESTRICTED	OTHER	MOUNT ROGERS NATIONAL RECREATIO…	NATIONAL RECREATION AREA	07
71F-A-18	61646	51	173	5553 SUGAR GROVE	SUGAR GROVE	VA	24375	5553 SUGAR GROVE HIGHWAY	SUGAR GROVE	VA	24375	Smyth	95511	Rye Valley	030500	305	10086.2187	87800	16700	104500	80500	2018-08-24	1	1950	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	803.9779	814.8288	808.0109		1.6800	PERSON	81291	CRESS CREEK 71F A 18	1026	392				APPALACHIAN CANINE COACHING	ANIMAL_OR_PET_SERVICE	07
74A-3-13	136727	51	173	0 UNASSIGNED	SUGAR GROVE	VA	24375	13516 PRICES BRIDGE RD	GLADE SPRING	VA	24340	Smyth	95511	Rye Valley	030500	305	1927.4114		6000	6000		2022-06-06	1		51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	784.1958	791.4254	787.6408		0.4800	TRUST	7212	SADDLEBROOK FARMS LOT 13 SEC 3 …	1085	984	GOVT FEDERAL	RESTRICTED	OTHER	MOUNT ROGERS NATIONAL RECREATIO…	NATIONAL RECREATION AREA	07
34-A-51	95711	51	173	0 HUNGRY MOTHER PK		VA	24354	1258 NORTH 11TH ST	WYTHEVILLE	VA	24382-4382	Smyth	94991	Park	030100	301	1113.5301	83700	24500	108200				1931	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	673.6324	674.8356	674.2690		1.2000	GOVERNMENT	11321	SPRUCE CREEK 34 A 51	565	697	GOVT FEDERAL	RESTRICTED	OTHER	JEFFERSON NATIONAL FOREST	NATIONAL FOREST	04
86-A-14B	72460	51	173	0 UNASSIGNED		VA	24378	118 LARRY BARE RD	ELIZABETHTON	TN	37643-5956	Smyth	95511	Rye Valley	030702	307.0200	5741.3322		13500	13500	6000	2004-06-09			51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	917.8076	964.1624	935.0325		2	PERSON	7212	KONNAROCK 86 A 14B	653	701	GOVT FEDERAL	RESTRICTED	OTHER	MOUNT ROGERS NATIONAL RECREATIO…	NATIONAL RECREATION AREA	03
41-2-4-6	53333	51	173	0 VALLEY		VA		PO BOX 1381	CHILHOWIE	VA	24319	Smyth	94895	North Fork	030100	301	445603.9524	336644	208900	545544	1300000	2017-10-05		1834	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				LU	308	BUSINESS	3211	VALLEY & MOUNTAIN PT TRS 4-6 41…	1013	819	GOVT STATE	CLOSED	OTHER	VIRGINIA OUTDOORS FOUNDATION EA…	CONSERVATION EASEMENT	02
28A3-A-48	112330	51	173	123 CARDWELL TOWN	SALTVILLE	VA	24370	123 CARDWELL TOWN RD	SALTVILLE	VA	24370	Smyth	95551	Saltville	030200	302	2872.7819	112500	6000	118500	87000	2020-09-11	1	1936	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	566.2048	571.7265	569.5364		0.7100	PERSON		ALLISON GAP 28A3 A 48	1056	524						01
65-A-74A	116700	51	173	525 SHULER HOLLOW	CHILHOWIE	VA	24319	525 SHULER HOLLOW RD	CHILHOWIE	VA	24319-4319	Smyth	90832	Chilhowie	030701	307.0100	8030.2332	135800	30000	165800	55500	2004-02-25	3	1990	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	689.4453	705.9660	697.8818		2	PERSON		MIDDLE FORK 65 A 74A	644	73						03
38D-1-20	96060	51	173	589 DAVIS VALLEY	RURAL RETREAT	VA	24311	589 DAVIS VALLEY RD	RURAL RETREAT	VA	24311	Smyth	90104	Atkins	030100	301	2722.5933	143800	15000	158800	178500	2026-01-08	1	2006	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	767.8597	779.2315	773.5480		0	PERSON		AIRPORT HTS LOT 20 38D 1 20	1112	8854						05
68-A-6B	82563	51	173	1944 SOUTH FORK	MARION	VA	24354	1944 SOUTH FORK RD	MARION	VA	24354	Smyth	95511	Rye Valley	030702	307.0200	56265.8407	114800	52400	167200	225000	2024-08-13	1	1995	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	723.4695	849.7907	773.0603		15.9700	PERSON		HOG TROUGH 68 A 6B	1110	7696						07
56F-5-25	66907	51	173	301 JORDAN	MARION	VA	24354	301 JORDAN LANE	MARION	VA	24354	Smyth	95479	Royal Oak	030301	303.0100	865.2550	78000	12000	90000	124900	2023-12-15	1	1961	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	657.5992	665.0204	660.8634		0	PERSON		301 JORDAN LN CEDARS LOT 25 56F…	1108	904						06
173-78-B2-15	23647	51	173	1376 HIGHLAND	MARION	VA	24354	6855 NELSON LANE	ATKINS	VA	24311	Smyth	95479	Royal Oak	030500	305	947.1887	36900	18000	54900	8000	2022-12-06	1	1945	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	666.5251	671.2087	669.1676		0	PERSON		MILLER LOT 15 BLK 2 BIRBON HALL…	1094	103						0M
28A7-3-46	38440	51	173	216 HENRYTOWN	SALTVILLE	VA	24370	216 HENRYTOWN RD	SALTVILLE	VA	24370	Smyth	95551	Saltville	030200	302	793.7338	125800	6000	131800	59300	2001-09-10	1	1951	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	529.6989	533.6232	531.8293		0.3200	PERSON		216 HENRYTOWN RD LOT 46 & ADD 2…	576	460						0S
38-A-67E	142875	51	173	456 SHAW	RURAL RETREAT	VA	24368	448 SHAW RD	RURAL RETREAT	VA	24368-4354	Smyth	90104	Atkins	030400	304	6237.6415	167300	16800	184100	50000	2005-07-22	2	2005	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	750.7047	766.9713	756.5226		1.6000	PERSON		456 SHAW RD 38 A 67E	684	309						05
65-A-23A2	72232	51	173	264 GRINSTEAD HILL	CHILHOWIE	VA	24319	1624 28TH AVE S	ST PETERSBURG	FL	33712	Smyth	90832	Chilhowie	030701	307.0100	6275.5645	308700	38300	347000	175000	2016-06-08	2	1990	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	697.6135	721.2911	708.2956		1.6600	PERSON		CHESTNUT RIDGE S ST RD 648 65 …	895	197						03
64A-4-5	150177	51	173	258 GREEN HILL	CHILHOWIE	VA	24319	258 GREEN HILL CIR	CHILHOWIE	VA	24319	Smyth	90832	Chilhowie	030702	307.0200	2118.4512	367100	18000	385100	268000	2019-10-18	1	1990	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	670.4364	680.2054	674.6748		0	PERSON		258 GREENHILL CIRCLE LOT 5 64A …	1042	586						03
173-78-B2-13	15504	51	173	1366 HIGHLAND	MARION	VA	24354	1366 HIGHLAND DR	MARION	VA	24354	Smyth	95479	Royal Oak	030500	305	726.4952	166900	18000	184900	117000	2019-03-26	1	1961	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	663.0321	673.8537	669.1662		0	PERSON		MILLER LOT 13 14 BL 2 173 78 2 …	1034	486						0M
30-A-86	70882	51	173	118 PAGE TOWN	SALTVILLE	VA	24370	118 PAGE TOWN RD	SALTVILLE	VA	24370	Smyth	95551	Saltville	030200	302	3226.8346	105500	15000	120500	98500	2022-08-22	1	1960	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	654.1739	669.9569	662.1690		0.6500	PERSON		RICH VALLEY 30 A 86	1089	849						02
56C-3-30	121151	51	173	215 ALPHA	MARION	VA	24354	14130 NORTH HIGHWAY 38	COLLINSTON	UT	84306	Smyth	94895	North Fork	030301	303.0100	693.2578	120400	12000	132400	52000	2018-08-03		1976	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	686.9827	689.6275	687.9858		0	PERSON		MT VIEW LOTS 30-31 56C 3 30	1025	600						04
41A-1-6	51641	51	173	498 VALLEY	SALTVILLE	VA	24370	498 VALLEY RD	SALTVILLE	VA	24370	Smyth	94895	North Fork	030100	301	963.2673	153200	15000	168200	150000	2023-08-22		1960	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	663.9284	666.7805	665.3020		0	PERSON		GASS S D LOTS 6-9 LOTS 6-9 41A …	1104	194						02
76-A-146	113557	51	173	209 ROSENBAUM HOLLOW	CHILHOWIE	VA	24319	209 ROSENBAUM HOLLOW RD	CHILHOWIE	VA	24319-4319	Smyth	95511	Rye Valley	030702	307.0200	68563.0088	108300	54400	162700	32600		2	1950	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	673.7431	734.0323	697.6078		18.2500	PERSON		SOUTH FORK 76 A 146	361	453						03
58E-1A-33	109568	51	173	1722 HWY 16	MARION	VA	24654	1722 HIGHWAY 16	MARION	VA	24354	Smyth	95479	Royal Oak	030600	306	629.4251	118800	12000	130800	143500	2023-09-06		1968	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	716.8143	729.4695	725.2808		0	PERSON		STALEYS CREEK LOT 33-41 PT 42-4…	1104	804						06
150-44-7A	25909	51	173	421 COYNER	MARION	VA	24354	421 E COYNER AVE	MARION	VA	24354	Smyth	94991	Park	030302	303.0200	366.6408	155400	18000	173400	115500	2022-07-18		1952	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	701.7329	703.3358	702.6354		0	PERSON		SPRINKLE ADD LOT 1 150 44 7A	1088	63						0M