Saved query 0522e9ab28f0f030

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

41/80

Live SQL

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

16,280 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	numfloors	bldgsqft	bedrooms	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
10-11	372-1	51	111	42 MACEDONIA RD		VA		SWEITZER JOHNATHAN SARA	42 MACEDONIA ROAD	BLACKSTONE	VA	23824	LUNENBURG	90192	BEAVER CREEK	930300	9303	10684.8199	265000	15200		280200	295000	2022-07-27	1	1	1975	1	2004	4		2	51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	132.8367	137.5507	136.1199	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	2.6400	PERSON	RT 616 2 64 AC	158	171						3	CENTRAL AIR	UNDETERMINED	CENTRAL AIR	BRICK	METAL		2026.2		06 RED OAK
38-4B	3291-1	51	111	684 OLD POOLE RD		VA		REESE KEVIN L AMBER	684 OLD POOLE ROAD	BRODNAX	VA	23920	LUNENBURG	90192	BEAVER CREEK	930300	9303	33051.4494	96000	28900		124900	127500	2021-08-20	1	1	2003		2432	3		2	51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	99.4520	114.3518	107.0293	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	8.2200	PERSON	RT 620 8 22 AC	342	159						1	UNDETERMINED	ELECTRIC	UNDETERMINED	STONE	COMP SHINGLE		2026.2		06 RED OAK
38-2A	18489-1	51	111	1070 OLD POOLE RD		VA		HENSHAW CURTIS WADE	1070 OLD POOLE ROAD	BRODNAX	VA	23920	LUNENBURG	90192	BEAVER CREEK	930300	9303	11822.7866	158900	16000		174900			1	1	2020		1836	3		2	51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	119.1912	125.2770	122.9410	SNGL FAM RES SUBURBAN	DWELLING	2.9200	PERSON	RT 620 2 92 AC		0										CONCI BLOCK	COMP SHINGLE	VINYL	2026.2		061 RED OAK
10-1C	14317-1	51	111	61 RAWLINGS HILL RD		VA		BETTY JEAN EDWARD R BRAUN III	61 RAWLINGS HILL ROAD	BLACKSTONE	VA	23824	LUNENBURG	90192	BEAVER CREEK	930300	9303	29278.2813	261900	35300		297200			1	1	2005		1920	2		2	51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	97.5406	119.6497	112.8292	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	12.6100	PERSON	RT 711 12 61 AC	289	666										CONCI BLOCK	COMP SHINGLE		2026.2		06 RED OAK
28-2	1918-1	51	111	3161 OLD POOLE RD		VA		HILDA G OZLIN LIFE ESTATE	THWEATTE G OZLIN	ALBERTA VA		23821	LUNENBURG	90192	BEAVER CREEK	930300	9303	189180.6426	66600	63800		130400			4	1	1930			4		1	51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	112.9114	128.2880	122.1370	20-100 AC	AGRICULTURAL	37.2500	PERSON	GREAT CREEK 37 25 AC	15	260										STONE	COMP SHINGLE		2026.2		06 RED OAK
10-19	380-1	51	111	408 EASY ST		VA		ALMAND EDWARD A	P O BOX 128	DUNDAS	VA	23938	LUNENBURG	90192	BEAVER CREEK	930300	9303	128199.0074	10700	56200		66900			1	1	1980		672				51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	124.9593	136.7537	131.6971	20-100 AC	AGRICULTURAL- 20-100 AC	35.0700	PERSON	WAQUA CREEK 35 07 AC	15	265													2026.2		06 RED OAK
18-11	969-1	51	111	STRT-OFFI ROAD		VA		BRANDON SIDNEY JORDAN III TRUST…	P O BOX 64	DUNDAS	VA	23938	LUNENBURG	90192	BEAVER CREEK	930300	9303	490738.9075	500	104900		105400			1	1							51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				AGR.- 100 AC OR MORE	AGR.- 100 AC OR MORE	116.2500	TRUST	OFF RT 617 116 25 AC	244	730	GOVT STATE	CLOSED	OTHER	VIRGINIA OUTDOORS FOUNDATION EA…	CONSERVATION EASEMENT								2026.2		06 RED OAK
3-12	126-1	51	111	3 12	BLACKSTONE	VA	23824	LIVELY SUSAN S ALS	4416 JONESBORO RD	BLACKSTONE	VA	23824	LUNENBURG	90192	BEAVER CREEK	930300	9303	985334.1571		163300		163300			0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				AGR.- 100 AC OR MORE	AGR.- 100 AC OR MORE	235	PERSON	CEDAR CREEK 235 AC	0293	4	GOVT STATE	CLOSED	OTHER	VIRGINIA OUTDOORS FOUNDATION EA…	CONSERVATION EASEMENT								2026.2		06 RED OAK
43 A 21A		51	111	2717 HORSESHOE BEND RD	KEYSVILLE	VA	23947	HILL RICHARD DAVID CHERYL C		KEYSVILLE	VA	23947	LUNENBURG	95279	REHOBOTH	930200	9302	39668.5416	159026	-76054	-98101	279174			1	1					0		51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	159.2848	172.9317	166.0311	2	SINGLE FAMILY	3.1750	PERSON	DB 237 291 MEHERRIN CR	0 0														2026.2	2024	CWA
033A1 04 0 B1	13072	51	111			VA		POWELL BARRY DAYLON	43 MERRYMAN DRIVE	VICTORIA	VA	23974	LUNENBURG	94647	MEHERRIN RIVER	930200	9302	35082.3019	3500	45500	3500	42000		2009-03-05	0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	154.4777	166.0894	160.4389	2	SINGLE FAMILY RESIDENCE (SUBURB…	9.3000	PERSON	E R BROWDER EST 9 3 AC	DB-342-179														2026.2	2024	PLYMOUTH
035A10 08 0 30	5180	51	111			VA		SINGLETARY JANE B	PO BOX 310 KENBRIDGE VA 23944	KENBRIDGE	VA	23944	LUNENBURG	90512	BROWNS STORE	930100	9301	5133.5929	300	8300	300	8000		2017-08-18	0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	133.8228	139.3236	137.2747	1	SINGLE FAMILY RESIDENCE (URBAN)	0	PERSON	CM LOVE LOTS LOTS 30 31	DB-396-485														2026.2	2024	TOWN OF KENBRIDGE
10-1E	14507-1	51	111	4620 MALLARD CRES	PORTSMOUTH	VA	23703	CACTUS ROCK CREEK LLC	4620 MALLARD CRESCENT	PORTSMOUTH	VA	23703	LUNENBURG	90192	BEAVER CREEK	930300	9303	80079.8520		11900		11900			0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	107.8059	126.9968	119.6487		SNGL FAM RES SUBURBAN	4.0300	BUSINESS	NEAR LUNENBURG COUNTY LNE 4 03 …	0013	198													2026.2		06 RED OAK
38-4D	3293-1	51	111	0 OLDI POOLE RD	BRODNAX	VA	23920	STITH ARCHER L AUGUSTINE A	2215 RENRUT ROAD	BRODNAX	VA	23920	LUNENBURG	90192	BEAVER CREEK	930300	9303	4154.9574		15600		15600			1								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	110.3692	114.4032	112.5459		SNGL FAM RES SUBURBAN	3	PERSON	RT 620 3 0 AC	273	881													2026.2		061 RED OAK
28-7E	17467-1	51	111	5319 OLD POOLE RD	DUNDAS	VA	23938	BACON JACOB S	5319 OLD POOLE RD	DUNDAS	VA	23938	LUNENBURG	90192	BEAVER CREEK	930300	9303	329079.5476		45600		45600			0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	109.9325	131.0800	122.4333	20-100 AC	AGRICULTURAL-	21.4800	PERSON	RT 620 21 48 AC		0													2026.2		061 RED OAK
66 A 54C		51	111	644 WARDS RD	KEYSVILLE	VA	23947	ROBERTS GARY E MARY A		KEYSVILLE	VA	23947	LUNENBURG	95279	REHOBOTH	930200	9302	286699.8089	58707	75481	58707	16774									0		51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	152.7268	178.9591	166.6216	2	SINGLE FAMILY	9.1500	PERSON	PB 14 244 DB 389 342	389 342														2026.2	2024	CWA
033A8 02 52C 1	4460	51	111			VA		HAZELWOOD CHANNELL EVERETT	14319 GLENMORGAN DRIVE	CHESTER	VA	23831	LUNENBURG	94647	MEHERRIN RIVER	930200	9302	1017.5343		5000		5000		2019-03-22	0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	157.0066	159.4009	158.0564	1	SINGLE FAMILY RESIDENCE (URBAN)	0	PERSON	BLK 52C LOTS 1 3	DB-406-683														2026.2	2024	TOWN OF VICTORIA
033A8 02 10N 6	4301	51	111			VA		TRUSTEES OF VICTORIA LODGE CHAP…	4712 PLANK ROAD	KENBRIDGE	VA	23944	LUNENBURG	94647	MEHERRIN RIVER	930200	9302	723.6245		1600		1600		2008-03-21	0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	170.8710	175.4429	173.0637	1	SINGLE FAMILY RESIDENCE (URBAN)	0	PERSON	BLK 10N LOTS 6 7	DB-334-676														2026.2	2024	TOWN OF VICTORIA
032 0A 0 45A	12822	51	111			VA		OVERBY SAMUEL D	365 LUNENBURG COUNTY RD	KEYSVILLE	VA	23947	LUNENBURG	95279	REHOBOTH	930200	9302	2411.7155		2300		2300	177500	2007-10-30	0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	145.7440	151.0550	148.1219	2	SINGLE FAMILY RESIDENCE (SUBURB…	0.5000	PERSON	COURTHOUSE 50 AC	DB-331-182														2026.2	2024	LEWISTON
035A7 08 30 11	5991	51	111			VA		RAMIREZ OLIVAR RAMIREZ OR NORMA…	201 EAST 4TH AVE	KENBRIDGE	VA	23944	LUNENBURG	93927	HOUNDS CREEK	930100	9301	231.7322		1000		1000	40000	2020-06-26	0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	144.8987	146.0578	145.6482	1	SINGLE FAMILY RESIDENCE (URBAN)	0	PERSON	BLK 30 1 2 OF LOT 11	IN-20-0000745														2026.2	2024	TOWN OF KENBRIDGE
033A8 02 58C 11	4474	51	111			VA		HARRIS KATHY A ET AL	15 BELMONT RD	NEWPORT NEWS	VA	23601	LUNENBURG	94647	MEHERRIN RIVER	930200	9302	682.7055		8000		8000		2013-03-07	0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	166.1636	168.4505	167.4387	1	SINGLE FAMILY RESIDENCE (URBAN)	0	PERSON	PT OF BLK 58C	DB-367-36														2026.2	2024	TOWN OF VICTORIA
38-12	3301-1	51	111	0 OLDI POOLE RD		VA		LOCICERO ROBERT A	4204 DAIRY CT	FREEHOLD	NJ	07728	LUNENBURG	90192	BEAVER CREEK	930300	9303	53227.9431		35400		35400	750	2007-07-27	0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	99.5748	119.6501	112.2223		SNGL FAM RES SUBURBAN	13.1500	PERSON	RT 620 13 15 AC LOT 1		0													2026.2		061 RED OAK
10-6	366-1	51	111	2041 CEDAR CREEK RD		VA		BERNARD ALLISONE BROOKS PER SUR…	5319 OLD POOLE ROAD	DUNDAS	VA	23938	LUNENBURG	90192	BEAVER CREEK	930300	9303	406627.0306	4500	132500		137000	517500	2022-08-12	1	1							51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				AGR.- 100 AC OR MORE		100	PERSON	CEDAR CREEK RD 100 AC	253	152													2026.2		06 RED OAK
38-14	3302-1	51	111	0 OLDI POOLE RD		VA		BAIRD GARLAND W	P O BOX 235	BRODNAX	VA	23920	LUNENBURG	90192	BEAVER CREEK	930300	9303	312612.8221		117400		117400			0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	81.1344	116.3020	101.1290	20-100 AC	AGRICULTURAL	73.2500	PERSON	LITTLE CREEK 73 25 AC	132	485													2026.2		06 RED OAK
035A7 08 22 5	5909	51	111			VA		CRAIGHEAD WILLIAM W ET AL	707 FRANCIS ROAD	GLEN ALLEN	VA	23059	LUNENBURG	93927	HOUNDS CREEK	930100	9301	473.6037		8000		8000		2021-11-16	0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	146.7420	149.5627	148.2918	4	COMMERCIAL/INDUSTRIAL	0	PERSON	BLK 22 LOT 5	NONE														2026.2	2024	TOWN OF KENBRIDGE
039A 01 0A 35	6591	51	111			VA		THOMPSON W C JR ET ALS LEIGH EL…	5570 FORT MITCHELL DRIVE	CHASE CITY	VA	23924	LUNENBURG	95279	REHOBOTH	930200	9302	370.8930		2800		2800		2018-08-29	0								51111C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	159.4910	161.1197	160.4306	2	SINGLE FAMILY RESIDENCE (SUBURB…	0	PERSON	BLK A LOTS 3 4 24 THRU 35	DB-403-273														2026.2	2024	REHOBOTH