Saved query 028f53b48fac71c7

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

43/80

Live SQL

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

34,703 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	taxacres	ownertype	legaldesc	book	page	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxdistrict
96B- 1 155	14812-1	51	117	28 ERCELLE CT	BRACEY	VA	23919	SMITH RONALD D BLAIR ARMISTEAD	28 ERCELLE COURT	BRACEY	VA	23919	MECKLENBURG	91553	3	930104	9301.0400	5210.9649	337500	48000	385500	55500	1997-09-01	1	1	1998		1344	3		2	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	62.3960	77.0601	70.7738	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	0	PERSON	JOYCEVILLE SUBDIVISION LOT 155	13	178		CENTRAL AIR	UNDETERMINED	CENTRAL AIR	CONCI BLOCK	COMP SHINGLE	ALUMIVINYL	2026.2	04 MEHERRIN
96B- 1 157	15623-1	51	117	1031 ALEXANDER DR	BRACEY	VA	23919	SAYKO WALTER G NANCY A	1031 ALEXANDER DR	BRACEY	VA	23919	MECKLENBURG	91553	3	930104	9301.0400	5098.6193	323200	144000	467200	61750	2001-01-01	1	1	2001		2162	3		2	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	62.2952	80.1833	70.7829	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	0	PERSON	JOYCEVILLE SUBDIVISION LOT 157	349	317	1	CENTRAL AIR	UNDETERMINED	CENTRAL AIR	CONCRETE BLOCK	METAL		2026.2	04 MEHERRIN
87A- 1 32	11616-1	51	117	14501 NASH RD	CHESTERFIELD	VA	23838	OV WILDWOOD COURT COOPER ROBERT…	14501 NASH ROAD	CHESTERFIELD	VA	23838	MECKLENBURG	91553	3	930104	9301.0400	4081.0244	15100	264000	279100			1	1	1980		1344	3		2	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	62.2125	66.8340	64.0495	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	0	PERSON	TANGLEWOOD LOT 32 SEC W	0310	298	1	CENTRAL AIR	UNDETERMINED	UNDETERMINED	CONCI BLOCK	COMP SHINGLE		2026.2	04 MEHERRIN
68B- 2 9	9779-1	51	117	5887 BRODNAX RD		VA		SADLER MARY MALONE LIFE ESTATE	P OI BOX 266	BRODNAX	VA	23920	MECKLENBURG	91553	3	930101	9301.0100	1774.4552	97800	9000	106800			1	1	1966		1325	3	1	1	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	94.1306	102.5914	97.5073	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	0	PERSON	R R TEMPLE EST SUBDIV LOTS 9 10…	204	268	1	CENTRAL AIR	UNDETERMINED	UNDETERMINED	T-BRICK	COMP SHINGLE		2026.2	04 MEHERRIN
68B- 1 134	9773-1	51	117	225 DUGGER ST	DUGGER	VA		DUGGER ANDREW BRITTNEY	247 DUGGER STREET	BRODNAX	VA	23920	MECKLENBURG	91553	3	930101	9301.0100	464.2496	21000	8000	29000	30000	2021-11-24	1	1	1960		760	3		1	51117C	2026-01-08	AREA NOT INCLUDED		104.6949	107.8336	106.3798	SNGL FAM RES URBAN	OCCUPANCY: DWELLING	0	PERSON	DUGGER ST LOTS 134 135 136 137	0300	420		UNDETERMINED	ELECTRIC	CENTRAL AIR	CONCI BLOCK	COMP SHINGLE		2026.2	02 BRODNAX
68B- 1 108	9769-1	51	117	630 MAIN ST		VA		HATCHEL DAVID BRADLEY	324 COUNTRY LANE	SOUTH HILL	VA	23970	MECKLENBURG	91553	3	930101	9301.0100	1213.7493	75200	6000	81200	5000	2023-05-26	1	1	1965		1025	3		1	51117C	2026-01-08	AREA NOT INCLUDED		106.2324	109.5778	107.5954	SNGL FAM RES URBAN	DWELLING	0	PERSON	MAIN STI LOTS 108 109 110	175	432		CENTRAL AIR	UNDETERMINED	UNDETERMINED	BRICK	COMP SHINGLE		2026.2	02 BRODNAX
87A- 1 41	11621-1	51	117	28 TANGLEWOOD CT		VA		CRUTCHFIELD CHARLES E ALCYON F	4400 GREENBRIAR DRIVE	CHESTER	VA	23831	MECKLENBURG	91553	3	930104	9301.0400	2680.8178	53300	264000	317300	155000	2013-10-31	1	1	1987		1344	3		2	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	62.3007	69.2453	65.3249	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	0	PERSON	LOT 41 SECTION W	3451	11	1				BRICK	COMP SHINGLE	VINYL	2026.2	04 MEHERRIN
68B- 1 134	9773-1	51	117	225 DUGGER ST	DUGGER	VA		DUGGER ANDREW BRITTNEY	247 DUGGER STREET	BRODNAX	VA	23920	MECKLENBURG	91553	3	930101	9301.0100	464.8078	21000	8000	29000	30000	2021-11-24	1	1	1960		760	3		1	51117C	2026-01-08	AREA NOT INCLUDED		105.0475	108.0213	106.6630	SNGL FAM RES URBAN	DWELLING	0	PERSON	DUGGER ST LOTS 134 135 136 137	0300	420		UNDETERMINED	ELECTRIC	CENTRAL AIR	CONCI BLOCK	COMP SHINGLE		2026.2	02 BRODNAX
68B- 1 134	9773-1	51	117	225 DUGGER ST	DUGGER	VA		DUGGER ANDREW BRITTNEY	247 DUGGER STREET	BRODNAX	VA	23920	MECKLENBURG	91553	3	930101	9301.0100	464.8077	21000	8000	29000	30000	2021-11-24	1	1	1960		760	3		1	51117C	2026-01-08	AREA NOT INCLUDED		104.7010	107.9007	106.5130	SNGL FAM RES URBAN	DWELLING	0	PERSON	DUGGER ST LOTS 134 135 136 137	0300	420		UNDETERMINED	ELECTRIC	CENTRAL AIR	CONCI BLOCK	COMP SHINGLE		2026.2	02 BRODNAX
68B- 2 6	9778-1	51	117	5915 BRODNAX RD		VA		ELLIS DAVID G	5915 BRODNAX RD	BRODNAX	VA	23920	MECKLENBURG	91553	3	930101	9301.0100	2094.6674	44300	8100	52400			1	1	1960		1036	3		1	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	95.8607	103.7773	99.5270	SNGL FAM RES SUBURBAN	DWELLING	0	PERSON	LOTS 6 7 8--R R TEMPLE ESTATE S…	313	526		CENTRAL AIR	UNDETERMINED	UNDETERMINED	CONCI BLOCK	COMP SHINGLE		2026.2	04 MEHERRIN
87A- 1 35	11619-1	51	117	29 LEISURE CT	CHESTER	VA	23831	LEWIS LEROY II LIFE ESTATE	4405 VILLAGE GARDEN CIRCLE	WINN	VA	23831	MECKLENBURG	91553	3	930104	9301.0400	4134.9970	132700	264000	396700			1	1	1993		1568	3		2	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	62.0513	66.0540	63.0301	SNGL FAM RES SUBURBAN	DWELLING	0	PERSON	LOT 35 TANGLEWOOD SECTION W	325	754	1				BRICK	COMP SHINGLE		2026.2	04 MEHERRIN
68B- 2 2	9775-1	51	117	9721 MAIN ST	BRODNAX	VA	23920	PIERCE CHRISTOPHER EUGENE EMMETT	1988 CANAAN CHURCH RD	BRODNAX	VA	23920	MECKLENBURG	91553	3	930101	9301.0100	1566.7899	65400	6000	71400			1	1	1959		1920	3		2	51025C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	99.6439	105.5710	103.3251	SNGL FAM RES URBAN	SNGL FAM RES URBAN	0	PERSON	R R TEMPLE EST LOTS 2 3	202	452	1				T-BRICK	COMP SHINGLE		2026.2	02 BRODNAX
78-9C	10698-1	51	117	3408 CLEATON RD	DRUMMOND	VA	23920	DRUMMOND BEN J ALS	3408 CLEATON RD	VICTORIA WEST	VA	23920	MECKLENBURG	91553	3	930101	9301.0100	6950.8824	93700	12600	106300			1	1	1974		1187	3		1	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	89.1967	98.2041	94.7071	SNGL FAM RES SUBURBAN	DWELLING	1.7200	PERSON	RT 625 1 728 AC WB INSTR 230000…	277	1	1				BRICK	COMP SHINGLE		2026.2	04 MEHERRIN
87A- 1 35	11619-1	51	117	29 LEISURE CT	CHESTER	VA	23831	LEWIS LEROY II LIFE ESTATE	4405 VILLAGE GARDEN CIRCLE	WINN	VA	23831	MECKLENBURG	91553	3	930104	9301.0400	16.6233	132700	264000	396700			1	1	1993		1568	3		2	51025C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	65.8715	66.4734	66.1133	SNGL FAM RES SUBURBAN	DWELLING	0	PERSON	LOT 35 TANGLEWOOD SECTION W	325	754	1				BRICK	COMP SHINGLE	VINYL	2026.2	04 MEHERRIN
68B- 2 9	9779-1	51	117	5887 BRODNAX RD		VA		MADLYN MALONE LIFE ESTATE	P OI BOX 266	BRODNAX	VA	23920	MECKLENBURG	91553	3	930101	9301.0100	1613.1161	97800	9000	106800			1	1	1966	1	1325	3	1	1			—		94.0340	102.2224	97.3487	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	0	PERSON	R R TEMPLE EST SUBDIV LOTS 9 10…	204	268	1	CENTRAL AIR	UNDETERMINED	CENTRAL AIR	T-BRICK	COMP SHINGLE		2026.2	04 MEHERRIN
87-1B	11587-1	51	117	3050 CLEATON RD		VA		JEFFERSON JOYCE M KENNETH WILLI…	46 GRANT ST	HEMPSTEAD	NY	11550	MECKLENBURG	91553	3	930101	9301.0100	3429.8965	15200	10400	25600			1	1	1976		960	3		1	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	94.5556	96.9292	96.0074	SNGL FAM RES SUBURBAN	DWELLING	0.9300	PERSON	RT RT 625 0 931 AC	238	352					CONCI BLOCK	SHINGLE		2026.2	04 MEHERRIN
78-5F	10688-1	51	117	4710 CLEATON RD		VA		JOHNSON WALTER SHERMAN LIFE EST…	4710 CLEATON RD	BRODNAX	VA	23920	MECKLENBURG	91553	3	930101	9301.0100	3966.3245	33400	10100	43500			1	1	1990		960	3		1	51025C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	100.4676	105.8602	102.8610	SNGL FAM RES SUBURBAN	DWELLING	0.8100	PERSON	RT 625 0 816 AC	248	31					BRICK	COMP SHINGLE		2026.2	04 MEHERRIN
87-2	11588-1	51	117			VA		CARROLL JAMES HI DEC D	3638 AUSTIN ST SE	WASHINGTON	DC	20020	MECKLENBURG	91553	3	930104	9301.0400	13487.2662	35300	17300	52600			1	1	1954		952	2		1	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	79.7969	88.1655	84.9523	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	3.3800	PERSON	POPLAR CREEK 3 38 AC	43	32					CONCI BLOCK	COMP SHINGLE		2026.2	04 MEHERRIN
78-9D	10699-1	51	117	3350 CLEATON RD		VA		SVENDSEN TONYA	39 WIDING LANE	ISLANDIA	NY	11749	MECKLENBURG	91553	3	930101	9301.0100	3277.9795	65200	10100	75300			1	1	1997		1404	3		2	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	92.1747	98.3264	96.2737	SNGL FAM RES SUBURBAN	DWELLING	0.8000	PERSON	RT 625 0 807 AC	241	765						COMP SHINGLE		2026.2	04 MEHERRIN
68A- 5 A 1	9734-1	51	117	328 MAIN ST	BRODNAX	VA	23920	BROWN PATRICIA A	328 MAIN STREET	BRODNAX	VA	23920	MECKLENBURG	91553	3	930101	9301.0100	1903.1647		1300	1300	35000	1997-06-19	0								51117C	2026-01-08	AREA NOT INCLUDED		111.1886	115.0006	112.4323	SNGL FAM RES URBAN	SNGL FAM RES URBAN	0	PERSON	LOT 1-BK A DB 3071 226	307	226								2026.2	02 BRODNAX
96B- 1 153	14784-1	51	117	86 ERCELLE CT		VA		TOMAZIC JAMES J	86 ERCELLE COURT	BRACEY	VA	23919	MECKLENBURG	91553	3	930104	9301.0400	3697.9719	15000	120000	135000	55500	1997-07-19	1	1							51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	62.7503	72.3075	67.1025		SNGL FAM RES SUBURBAN	0	PERSON	JOYCEVILLE SUBDIVISION LOT 153	307	354								2026.2	04 MEHERRIN
87-2B	16239-1	51	117	95 CHESTNUT LN	N WALES	VA	19454	J G LEGACY REALTY LLC	95 CHESTNUT LANE	N WALES	PA	19454	MECKLENBURG	91553	3	930104	9301.0400	2975.8756		2800	2800			0								51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	84.6323	87.3735	86.3171	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	0	BUSINESS	RT 625 PARCEL 1 0 38 AC	15	250								2026.2	04 MEHERRIN
58-16	7949-1	51	117	181 WOODFIN WAY	SOCIAL CIRCLE	VA	30025	WHITBY EMMITT RAY	181 WOODFIN WAY	SOCIAL CIRCLE	GA	30025	MECKLENBURG	91553	3	930101	9301.0100	5335.4784		10400	10400			0								51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	103.2005	110.2152	107.1474		SNGL FAM RES SUBURBAN	1.3799	PERSON	PEACH TREE ST 1 38 AC	202	285								2026.2	04 MEHERRIN
48-13	4835-1	51	117	258 SHORTS FARM LN	BRODNAX	VA	23920	SEAMSTER TINA	258 SHORTS FARM LANE	BRODNAX	VA	23920	MECKLENBURG	91553	3	930101	9301.0100	134719.6322		44600	44600											51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	75.6514	106.7308	96.3068	20-100 AC	AGRICULTURAL	36	PERSON	OFF RT 58 6 AC WB INSTR 1800000…	00001	NO PAGE								2026.2	04 MEHERRIN
96-2A	14267-1	51	117	226 BROOK RD	WEST BURKE	VA	05871	GERHARDT E FREDERICK ALS	226 BROOK ROAD	WEST BURKE	VT	05871	MECKLENBURG	91553	3	930104	9301.0400	144468.8390		303800	303800			0								51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	61.2057	91.4762	80.0948		SNGL FAM RES SUBURBAN	18.5400	PERSON	PARCEL D-2 18 54 AC	13	113								2026.2	04 MEHERRIN