Saved query cc8d28ef3a4f80b6

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

42/80

Live SQL

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

35,041 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	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	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
30813	29051	51	171	18585 NEW MARKET RD		VA		ECKARD TIMOTHY	18585 NEW MARKET RD	TIMBERVILLE	VA	22853	SHENANDOAH	91277	1	040800	408	7270.9476	122100	49000	171100	115000	2015-12-18	1	1	1970	1	1209	2	0	0	51171C	2026-01-08	AE		283.6659	291.1459	288.6082	210R	SUB RESID - SING FAM	A1		0.8660	PERSON	SHENANDOAH RIVER;	4664	167	1	HOT AIR FURNACE	UNDETERMINED	NO	CINDER BLOCK	ASPHALT	BRICK	2026.2	2026	5
4591-07-9061	47A 1 11	51	171			VA		STANLEY VOLUNTEER FIRE DEPARTME…	PO BOX 276	STANLEY	VA	22851	SHENANDOAH	91277	1	040800	408	568.1837		5000	5000		2024-04-22	1	0	0		0	0	0	0	51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	569.9855	576.3350	572.8529	74		R	R	0	BUSINESS	INST 10-2166 MOUNT CREST L-11 12		0	0	UNDETERMINED	UNDETERMINED	UNDETERMINED	0	0		2026.2	2021	MARKSVILLE DISTRICT
4591-07-9845	47A 1 23	51	171			VA		PEER CHARLES	PO BOX 222	LURAY	VA	22835	SHENANDOAH	91277	1	040800	408	545.1819		2000	2000	1300	2023-04-22	1	0	0		0	0	0	0			—		566.1343	570.2520	568.0742	21		R	R	0.2000	PERSON	WB 55-276 TOP OF MASS MTN LOT23		0	0	UNDETERMINED	UNDETERMINED	UNDETERMINED	0	0		2026.2	2021	MARKSVILLE DISTRICT
8687	8071	51	171			VA	0	DELLINGER JOHN W	20279 HOLMANS CREEK LN	TIMBERVILLE	VA	22853	SHENANDOAH	91277	1	040800	408	8258.2063	200	9000	9200	6000	1998-07-16	1	1			0				51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	422.8269	460.0710	440.9386	230V	SUB RESID - AGR <20 AC	A2		2	PERSON	NORTH MT	1603	26								2026.2	2026	5
8686	8070	51	171			VA	0	DELLINGER JOHN W	20279 HOLMANS CREEK LN	TIMBERVILLE	VA	22853	SHENANDOAH	91277	1	040800	408	7945.1524		9000	9000	6000	1998-07-16	1				0				51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	419.5109	460.0390	440.8349	230V	SUB RESID - AGR <20 AC	A2		2	PERSON	NORTH MT;	1603	26								2026.2	2026	5
8688	8072	51	171			VA	0	DELLINGER JOHN W	20279 HOLMANS CREEK LN	TIMBERVILLE	VA	22853	SHENANDOAH	91277	1	040800	408	8303.7422		9000	9000	6000	1998-07-16	1				0				51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	422.0950	459.8829	441.4686	230V	SUB RESID - AGR <20 AC	A2		2	PERSON	NORTH MT;	1603	26								2026.2	2026	5
107 2 9		51	171	238 BLUE SMOKE LN		VA		GREGG CATHY	238 BLUE SMOKE LN NEW MARKET, V…				SHENANDOAH	91277	1	040800	408	14788.6252	75000	61100	136100	98500	2004-10-22	1	1	1981	10		2	0	1	51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				3.5190	PERSON	LT 9 SUNDANCE MOUNTAIN SUBD	1167	572		BASEBOARD	NONE			COMP SHINGLE	T1-11	2026.2	0	LEE
103A2 A 195		51	171			VA		LINSKI RENTALS LLC	457 HAYNESWOOD LN NEW MARKET, V…				SHENANDOAH	91277	1	040800	408	673.5750	61600	28000	89600	43000	2021-02-10	1	1	1995	10		3	0	2	51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				0.1700	BUSINESS	RT 11 PARCEL A	1074	0		HEAT PUMP	NONE			COMP SHINGLE	VINYL	2026.2	2021	LEE NEW MARKET
97 3 3		51	171	80 NOW LOOK LN		VA		MILLS ROBERT W OR	PO BOX 416 TIMBERVILLE, VA				SHENANDOAH	91277	1	040800	408	37762.9165	349900	104600	454500	28000		1	1	1994	18		3	1	2	51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				7.5800	PERSON	LT 3 THE RIDGEVIEW ESTATE	661	533		HOT WATER	NONE			COMP SHINGLE	VINYL	2026.2	0	LEE
43302	40585	51	171			VA	0	YANKEY CURTIS W JUDITH L	137 SOUTH MIDDLE RD	TIMBERVILLE	VA	22853	SHENANDOAH	91277	1	040800	408	8615.8583		10000	10000	210000	2014-05-29	1				0						—		398.8330	434.8009	414.1067	230V	SUB RESID - AGR <20 AC	A2		1.6700	PERSON		4416	395								2026.2	2026	5
70A1 5 4		51	171			VA		WAUGERMAN JANET A	6729 SMITH CREEK RD NEW MARKET,…				SHENANDOAH	91577	3	040600	406	368.1198	132400	36000	168400	155000	2007-05-14	1	1	2007	20		2	1	2	51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				0.0960	PERSON	LOT 4 MADISON VILLAGE	1358	272		HEAT PUMP	NONE			COMP SHINGLE	VINYL	2026.2	0	MADISON EDINBURG
42 1 2		51	171			VA		FOLTZ NOLAND B	467 MILLERTOWN RD EDINBURG, VA …				SHENANDOAH	91577	3	040202	402.0200	13339.1929	79800	93100	172900		2023-07-04	1	1	1961	10		2	0	1	51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				7.5800	PERSON	RT 749 LITTLE STONEY CREEK ON R…	0	0		FORCED AIR	NONE			METAL/TIN	WOOD/FRAME	2026.2	0	MADISON
25A4 1 67 6		51	171			VA		YATES CHRISTIAN N AND	1506 ASHLEY DR SALEM, VA 24153				SHENANDOAH	92027	6	040102	401.0200	248.9798	198000	38000	236000		2024-12-18	1	1	1972	10		2	1	1	51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				0.1840	PERSON	E KING ST BLK 67 1/2 LTS 2 4 6				HEAT PUMP	OPEN			COMP SHINGLE	BRICK	2026.2	2024	DAVIS STRASBURG
8021829	70 A 35	51	171	STAR TANNERY RD	WINCHESTER	VA	22601	HOLLIDAY DAVID B	420 W JUBAL EARLY DR STE 103	WINCHESTER	VA	22601	SHENANDOAH	91877	5			331636.9308		381600	381600	439403	2011-10-07			0						51171C	2026-01-08	A					5	NONE	RA		84.7900	PERSON	84.79 ACRES	8833	0								2026.2		BACK CREEK
54 A 117		51	171			VA		GUINN CLAY	15527 SENEDO RD EDINBURG, VA 22…				SHENANDOAH	91427	2	040202	402.0200	1200.3878	28400	2800	31200	125000	2016-10-11	1	1	0						51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				0.3060	PERSON	RT 42 LOT X	1731	178								2026.2	0	MADISON
99B 2 18		51	171			VA		CUSTER STEVEN F OR DORIS A	5692 SMITH CREEK RD NEW MARKET,…				SHENANDOAH	91277	1	040800	408	568.1335	1200	21000	22200	85000	2016-10-31	1	1	0						51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				0.4020	PERSON	LT 7 18 BUSHONG SUBD US 11 N OF…	1733	827								2026.2	0	LEE
45A5 5 4		51	171			VA		ORNDORFF KALEB R	606 S WATER ST WOODSTOCK, VA 22…				SHENANDOAH	91727	4	040501	405.0100	1699.4082	5100	3900	9000	147000	2019-04-26	1	1	0						51171C	2026-01-08	A					0				0.3880	PERSON	W PT LT 4 STICKLEY SUBD	2228	0								2026.2	2019	JOHNSTON WOODSTOCK
66 A 50A		51	171			VA		DAWSON JERRY A	1819 KELLY RD MOUNT JACKSON, VA				SHENANDOAH	91427	2	040201	402.0100	2174.1529	1400	5000	6400	2000		1	1	0						51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				0.9690	PERSON	RT 721	722	738								2026.2	0	ASHBY
12 A 49		51	171			VA		GRAY ALAN G	340 HUNT CLUB LN MAURERTOWN, VA				SHENANDOAH	91877	5	040202	402.0200	9330.1697	13900	12300	26200	65000		1	1	0						51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				2.0470	PERSON	RT 600 TRACT 2A	840	776								2026.2	0	STONEWALL
16 A 208		51	171			VA		HALL PHYLLIS M	178 HALL LN STRASBURG, VA 22657				SHENANDOAH	91877	5	040102	401.0200	41124.1278	21300	106600	127900		2023-07-04	1	1	0						51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				9.2080	PERSON	RT 629	1462	21								2026.2	0	DAVIS
8 6 25		51	171			VA		DRUMMOND RANDY LEE OR AVIS LYNN	449 MILE RIDGE ESTS LEBANON CHU…				SHENANDOAH	91877	5	040202	402.0200	28095.6127	19700	56900	76600	16900		1	1	0						51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				7.1180	PERSON	LT 25 MILE RIDGE ESTATES	654	259								2026.2	0	DAVIS
103 A 33B		51	171			VA		HUGHES DAVID M TRUSTEE TRUST	18552 EVERGREEN VALLEY RD TIMBE…				SHENANDOAH	91277	1	040800	408	56262.5170	189900	69300	259200		2010-11-12	1	1	0						51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				8700				13.8600	TRUST	RT 617	1509	153								2026.2	0	LEE
46D 6 2 12		51	171			VA		HICKORY LAND LLC	11922 SAFA CT HERNDON, VA 20170				SHENANDOAH	91727	4	040400	404	6615.3332		82800	82800	75000	2007-12-18			0						51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				1.8560	BUSINESS	RIVERMONT ESTATES SEC 4 BLK 2 L…	1392	607								2026.2	0	JOHNSTON
81B 1 1 6A		51	171			VA		HUFFMAN DARRYL OR ELLEN	5092 DOGWOOD DR MOUNT JACKSON, …				SHENANDOAH	91427	2	040700	407	590.5218		7500	7500	281000	2022-07-01			0						51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				0.1200	PERSON	LT S W 1/2 LT 6 BLK 1 SEC 3 AVO…	4458	0								2026.2	2022	ASHBY MT JACKSON
47D1 1 1 360A		51	171			VA		BODY DAVID M	4256 MAIN ST ROHRERSVILLE, MD 2…				SHENANDOAH	91877	5	040400	404	5537.7279		11400	11400	3000	2015-01-15			0						51171C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0				1.4300	PERSON	MINE MTN SUBD SEC 1 LT 360-A	1666	330								2026.2	0	JOHNSTON