Saved query 43e047fb54d778e5

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

14,338 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	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	heating	heatfuel	cooling	foundation	roofcover	lrversion	taxyear	taxdistrict
113-A-15	113 A 15	51	071	ORCHARD HILL LN	NEWPORT	VA	24128	PRIEST MARGARET B	601 ORCHARD HILL LANE	NEWPORT	VA	24128	GILES	93431	EASTERN	930100	9301	58529.4759		30000		30000	141000	2007-11-20	0							51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	842.0223	922.5924	874.9588	2		A-1	AGRICULTURAL LTD	14.1000	PERSON	JOHNS CK MTN-CLOVER HOLLOW 14 1…	0166	0084											2026.2	2024	04
8764	24B 5 A 2	51	071			VA		SULLOWAY DONALD A JR	107 ROBERTA STREET NARROWS VA 2…	NARROWS	VA	24124	GILES	96287	WESTERN	930300	9303	716.6105	58000	14000			73000	2019-06-28	1	1	1948		3			51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	507.8448	508.8971	508.3319		1 - SINGLE FAMILY URBAN	T		0	PERSON	LOT NO 2 COLONIAL HGTS SEC A		0						HEAT PUMP	GAS		CINDERBLOCK	COMP SHG	2026.2		06
16 A 4		51	071	29 HORSESHOE LN	NARROWS	VA	24124						GILES	96287	WESTERN	930300	9303	355698.6892	167600	167600	167600	0	24900	2000-11-30	1	1	2004	1680	2	1	2			—		572.2090	925.7579	745.8440		SINGLE FAMILY													HEAT PUMP	ELECTRIC	HEAT PUMP	OTHER	COMPOSITION	2026.2	2024
113-A-14	000125	51	071	ORCHARD HILL LN	NEWPORT	VA	24128	SMITH STEVEN D	601 ORCHARD HILL LN	NEWPORT	VA	24128	GILES	93431	EASTERN	930100	9301	50882.0721							0							51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	827.0273	926.4708	873.3545	2		A-1		12.5700	PERSON	JOHNS CK MTN-CLOVER HOLLOW 12 5…													2026.2	1	04
3615	27 35E	51	071			VA		KINDER KAREN LYNN	2308 BROADHEAD SCHOOL ROAD MIDD…	MIDDLEBROOK	VA	24459	GILES	90728	CENTRAL	930300	9303	15227.8216	300	22400				2012-07-03	1	1						51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	547.3187	579.5352	566.8703		2 - SINGLE FAMILY SUBURB	RRA1		3	PERSON	CURVE		0											2026.2		02
14055		51	071	576 MOUNTAIN VIEW LN	PEARISBURG	VA	24134						GILES	90728	CENTRAL	930400	9304	20357.6382	92200	92200	92200	0			1	1	2000	1400	3	0	1			—		667.5993	707.9503	686.0385		SINGLE FAMILY													UNDETERMINED	UNDETERMINED	OTHER	OTHER	METAL	2026.2	2022
103-A-2	002945	51	071			VA		MOSES HAL BROOKS ET AL	12079 BROADWAY TERRACE	OAKLAND	CA	94611	GILES	93431	EASTERN	930100	9301	1096240.8964							2							51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				6		A-1		118.7090	PERSON	JOHNS CK 118 7092 AC INST 07000…			GOVT STATE	CLOSED	OTHER	VIRGINIA OUTDOORS FOUNDATION EA…	CONSERVATION EASEMENT						2026.2	1	04
5610	60 38A	51	071			VA		PORTERFIELD CURT M OR CHRISTINE…	122 SOURWOOD LANE NEWPORT VA 24…	NEWPORT	VA	24128	GILES	93431	EASTERN	930100	9301	8017.0172		7000			95000	2003-08-22								51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	636.9967	702.4625	669.2997		2 - SINGLE FAMILY SUBURB	RRA1		1.9980	PERSON	WYSONG	368	768											2026.2		03
4927	13 124	51	071			VA		WHITE DAVID E OR STACEY	367 MARKET ROAD NARROWS VA 24124	NARROWS	VA	24124	GILES	96287	WESTERN	930300	9303	2649.5602		15000			6800	1999-09-09								51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	538.1752	546.6255	542.2614		2 - SINGLE FAMILY SUBURB	CR-1		0.6300	PERSON	SHUMATE	309	576											2026.2		01
6343	17 27C	51	071			VA		ANDERSON MARK TODD	121 LOST LANE PEARISBURG VA 241…	PEARISBURG	VA	24134	GILES	93431	EASTERN	930200	9302	1306.3806		6000			800	2019-12-17								51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	560.0161	578.4241	567.8626		2 - SINGLE FAMILY SUBURB	RRA1		0.2500	PERSON	HENDERSON		0											2026.2		03
6822	42 68H	51	071			VA		CABOOSE LANE VENTURES LLC	201 CASCADE DRIVE PEMBROKE VA 2…	PEMBROKE	VA	24136	GILES	93431	EASTERN	930200	9302	2033.7577		48000			285000	2024-05-23								51071C	2026-01-08	AE	FLOODWAY	487.2391	494.7650	492.7325		2 - SINGLE FAMILY SUBURB	RRA1		0.5400	BUSINESS	SNIDOW		0											2026.2		03
11409	42A 3 A 4	51	071			VA		JOURNELL JOSEPH M OR DIANE K	3571 MURFREESBORO RD LEBANON TN…	LEBANON	TN	37090	GILES	93431	EASTERN	930200	9302	168.2038		2500			22500	2019-11-07								51071C	2026-01-08	AE	FLOODWAY	496.8502	497.4816	497.1635		1 - SINGLE FAMILY URBAN	T		0	PERSON	LOT NO 4 SNIDOW ADD		0											2026.2		09
703	25 15	51	071			VA		KINNEY JOHN JR	P O BOX 34 NARROWS VA 24124 0034	NARROWS	VA	24124	GILES	90728	CENTRAL	930400	9304	1301.4428		1500			80000	2022-06-30								51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	478.4811	485.8580	479.9628		2 - SINGLE FAMILY SUBURB	RRA1		0.2500	PERSON	SHUMATE		0											2026.2		01
7961	24B 6 33	51	071			VA		ANDERSON MICHAEL F OR TAMMY R	100 EDWARD STREET NARROWS VA 24…	NARROWS	VA	24124	GILES	96287	WESTERN	930300	9303	829.5384		2500			171720	2007-12-03								51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	507.3775	512.3327	511.0159		1 - SINGLE FAMILY URBAN	NR-2		0	PERSON	PT NO 33 COLONIAL HGTS NO 2		0											2026.2		06
90-A-3	002088	51	071			VA		HUFFMAN LAKE L III	3706 JOHNS CREEK RD	NEW CASTLE	VA	24127	GILES	93431	EASTERN	930100	9301	76947.4923							0							51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	619.7889	655.9971	639.6779	2		A-1		14	PERSON	JOHNS CREEK 14 AC DB 40 272													2026.2	1	04
90-A-1A	001134	51	071			VA		DOES UNLIMITED HUNTING CLUB C O…	10289 COLONIAL HWY	EVINGTON	VA	24550	GILES	93431	EASTERN	930100	9301	118997.7505							0							51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	653.9854	681.7804	669.1435	5		A-1		32.5910	NONPROFIT	JOHNS CREEK 32 591 AC DB 79 283…													2026.2	1	04
90-A-2	002192	51	071			VA		HINKLE JAMES W ET AL	1205 HUTCHISON RD	NEW CASTLE	VA	24127	GILES	93431	EASTERN	930100	9301	3710.9890							0							51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	658.0525	663.6211	661.2400	2		A-1		12.6500	PERSON	JOHNS CREEK 12 65 AC DB 82 469 …													2026.2	1	04
2067	55B 1 6	51	071			VA		SPAUR JOHN L OR MARY M	1101 WENONAH AVENUE PEARISBURG …	PEARISBURG	VA	24134	GILES	90728	CENTRAL	930400	9304	2049.7540		2500			4000	2015-08-05								51071C	2026-01-08	A		536.3486	554.1433	543.2751		2 - SINGLE FAMILY SUBURB	RRA1		0	PERSON	NO 6 SUNNYRIDGE TRUCK FARMS		0											2026.2		02
7199	42 67X	51	071			VA		OBRIEN TED OR MARTHA M	102 MAYS HOLLOW ROAD PEMBROKE V…	PEMBROKE	VA	24136	GILES	93431	EASTERN	930200	9302	163.2617		22500			35000	2007-12-21								51071C	2026-01-08	AE	FLOODWAY	486.3994	493.4277	491.3779		2 - SINGLE FAMILY SUBURB	RRA1		0.2500	PERSON	SNIDOW		0											2026.2		03
1264	50 32A	51	071			VA		CONLEY THOMAS A	P O BOX 923 TAZEWELL VA 24651	TAZEWELL	VA	24651	GILES	96287	WESTERN	930400	9304	2189.4006		200				2011-05-26								51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	665.2268	688.1408	672.8748		2 - SINGLE FAMILY SUBURB	A1		0.2500	PERSON	THORNTON		0											2026.2		01
5869	9 19F2	51	071			VA		PARCELL JERRY WAYNE	6194 SAUNDERS ROAD VINTON VA 24…	VINTON	VA	24179	GILES	93431	EASTERN	930200	9302	3250.2513		15600				2011-02-25								51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	1008.1700	1022.1568	1015.6700		2 - SINGLE FAMILY SUBURB	RRA1		0.8000	PERSON	ELMORE		0											2026.2		03
1622	41 40D	51	071			VA		BRUCE HERBERT	415 TABOR HOLLOW ROAD PEARISBUR…	PEARISBURG	VA	24134	GILES	93431	EASTERN	930200	9302	1843.3537		2500			38500	2019-09-16								51071C	2026-01-08	A		502.7684	513.4450	507.0736		2 - SINGLE FAMILY SUBURB	RRA1		1	PERSON	PETERS		0											2026.2		02
1268	37B 3 8	51	071			VA		MULLINS BARBARA A	683 PINEY MTN RD NARROWS VA 241…	NARROWS	VA	24124	GILES	96287	WESTERN	930300	9303	2368.2188		7500				2022-02-25								51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	549.5126	569.4648	558.7151		2 - SINGLE FAMILY SUBURB	RRA1		0	PERSON	LOT NO 8 PINEY MT		0											2026.2		01
6911	69 18E	51	071			VA		THOMPSON BEVERLY JO	111 SPRINGDALE RD PEARISBURG VA…	PEARISBURG	VA	24134	GILES	93431	EASTERN	930200	9302	1085.7443		900				2022-04-06								51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	568.4277	570.8958	570.0686		2 - SINGLE FAMILY SUBURB	RRA1		0.2500	PERSON	STAFFORD		0											2026.2		03
8844	24B 1 38	51	071			VA		TICKLE LORETTA N	306 PARK DRIVE NARROWS VA 24124	NARROWS	VA	24124	GILES	96287	WESTERN	930300	9303	887.8152		5000				2016-02-25								51071C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	478.3589	510.3666	491.9219		1 - SINGLE FAMILY URBAN	NB-2		0	PERSON	LOT NO 38 FRENCH COURT NO 2		0											2026.2		06