Saved query db1e58ce6b3a51d6

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

40/80

Live SQL

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

38,075 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	zoningcode	taxacres	ownertype	naicscode	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
60 11 2	10569	51	031	499 STONEWALL RD	CONCORD	VA	24538	EDMA JACK L	499 STONEWALL RD	CONCORD VA 24538			CAMPBELL	90968	CONCORD	020101	201.0100	6359.2218	112200	-61300	-84400	219700	140000	2011-05-27	1	1	2002	1	2156	5	0	3	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	255.7702	260.9025	258.2984		SINGLE FAMILY		0.7100	PERSON		LITTLE OAK SUBD								0	HEAT PUMP	ELECTRIC	HEAT PUMP	OTHER	SHAKE / SHINGLE		2026.2	2025	STONEWALL
104 A 11	4061	51	031	7687 SPRING MILL RD	CONCORD	VA	24538	TORRENCE THOMAS CALVIN JR FORBE…	2665 GOODE RD	GOODE VA 24556			CAMPBELL	90504	BROOKNEAL	020102	201.0200	43032.1268	43500	-7600	-50000	135900	45000	2011-12-08	2	1	1941	1	1081	2	0	1	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	150.7541	164.1052	157.3929		SINGLE FAMILY		7.2900	PERSON		FALLING RIVER RT 646								1	UNDETERMINED	UNDETERMINED	OTHER	CRAWL/RAISED	COMPOSITION		2026.2	2025	SOUTHSIDE
118 2 2	8838	51	031	231 RUSH LN	RED HOUSE	VA	23963	BERRY MICHAEL C REVOCABLE TRUST	1835 HALLTOWN RD	HARTLY DE 19953			CAMPBELL	90504	BROOKNEAL	020900	209	162417.2815	168100	37700	-143000	491800		2022-04-11	3	1	2000	13	2546	3	0	2	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	185.4444	211.3325	202.3794		SINGLE FAMILY		47.9700	TRUST		FALLING RIVER								0	UNDETERMINED	UNDETERMINED	OTHER		COMPOSITION		2026.2	2025	SOUTHSIDE
18-A-91	18-A-91	51	031	PAVED	CONCORD	VA	24538	MOODY ROGER D	PO BOX 205	CONCORD	VA	24538	CAMPBELL	90968	CONCORD	020101	201.0100	32271.8794	557100	159900			155148	1985-12-02	2	1	2000	10	1824	0	0	1	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	232.1001	243.7397	237.4439	1	SINGLE FAMILY	U	7.9940	PERSON		0623 0846						MOODY MOVING AND STORAGE, INC.	MOVERS		Heat pump		Y	NONE			2026.2
68-A-236	68-A-236	51	031	PAVED	ALTAVISTA	VA	24517	GES ENTERPRISES LLC	397 SLEEPY HOLLOW DR	LYNCHBURG	VA	24502	CAMPBELL	90032	ALTAVISTA	020700	207	14621.0575	566800	73900			500000	2015-08-03	9	1	2007	1	3000				51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	210.4012	227.1441	221.9290	MWRHSE	MINI WAREHOUSE	U	3.5700	BUSINESS	531130	NR ALTAVISTA TRACT 1		150003772				OGDEN ROAD MINI STORAGE	SELF-STORAGE FACILITY		3000 sf		N			WOOD FRAME	2026.2		60
118 A 1	2120	51	031		RED HOUSE VA	VA		BETTS STEVEN L BETTS CATHRYN A	2610 MOODY TOWN RD	BUMPASS VA 23024			CAMPBELL	90504	BROOKNEAL	020900	209	116367.2697	51300	110200	1000	159500	22500		2	1	1989	1		1	0	1	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	183.9986	205.5319	197.3422		AGRIC/UNDEV (20-99.99 AC)		27.8100	PERSON		FALLING RIVER	0	0						0							2026.2		SOUTHSIDE
46 3 1A2	11374	51	031	4364 STAGE RD	CONCORD VA	VA		VINE FREDERICK R VINE RHONDA F	4364 STAGE RD	CONCORD VA 24538			CAMPBELL	90968	CONCORD	020101	201.0100	116085.5018	360000	69000	20400	388200			5	1	2023	1		3	0	4	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	231.1301	244.5710	237.8361		SINGLE-FAM RES SUBURB		10	PERSON		LAKEVIEW SUBD								1							2026.2		STONEWALL
105 A 54	3129	51	031			VA		DYE FARMS LLC	388 PROMISE LAND RD	APPOMATTOX VA 24522			CAMPBELL	90504	BROOKNEAL	020900	209	8363.0667		62100		62100		2018-02-02	0								51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	218.9697	222.4524	220.9959		AGRIC/UNDEV (20-99.99 AC)		41	BUSINESS		FALLING RIVER			GOVT STATE	CLOSED	OTHER	VIRGINIA OUTDOORS FOUNDATION EA…	CONSERVATION EASEMENT								2026.2		SOUTHSIDE
34G-1-4	34G-1-4	51	031	PAVED		VA		PATRICK HENRY T JR & MARTHA A S	1538 HARDWOOD CT	MIDLOTHIAN	VA	23114	CAMPBELL	95503	RUSTBURG	020102	201.0200	6968.8972		23000				2003-04-03	0								51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	261.1654	276.3011	268.5854	9	HOMESITE	U	1.7200	PERSON		HENRY PATRICK LAND LOT 4		030003166													2026.2
99A-1-E-41	99A-1-E-41	51	031			VA		CAYTON JEANNE C	PO BOX 117	LONG ISLAND	VA	24569	CAMPBELL	90504	BROOKNEAL	020800	208	483.0933		300			5000	2024-02-12	0								51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	146.1089	150.5669	148.0692	LS	LOT SITE	U	0	PERSON		LOTS 35-41 BK E LONG ISLAND		S240000563													2026.2
60 11 1	10568	51	031			VA		HULSER RICHARD D JR	366 STONEWALL RD	CONCORD VA 24538			CAMPBELL	90968	CONCORD	020101	201.0100	4600.6146		2000		2000	10000	2001-11-19	2								51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	258.8694	262.7668	260.7840		SINGLE-FAM RES SUBURB		0.4900	PERSON		LITTLE OAK SUBD	0	0													2026.2		STONEWALL
103C-27-5-3	103C-27-5-3	51	031			VA		LUNSFORD A L ELIZABETH W	17466 BROOKNEAL HWY	BROOKNEAL	VA	24528	CAMPBELL	90504	BROOKNEAL	020900	209	344.4850		1200				2000-01-01	0								51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	161.9951	163.6871	162.9716	LS	LOT SITE	U	0	PERSON		0545 0450															2026.2		70
91-A-15		51	031	PAVED		VA							CAMPBELL	90504	BROOKNEAL	020900	209	24417.1506							1	1	1970	0	2520	3	0	3	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	175.3822	191.8148	185.1027	1	SINGLE FAMILY	U	5.2000			0386 0310									Geothermal		Y	1/2 BSMT, 1/2 CRAWL		BRICK	2026.2
69-A-16A		51	031	PAVED		VA							CAMPBELL	90032	ALTAVISTA	020600	206	361968.5933							8	1	2002	10	3434	3	0	2	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	189.1469	239.6744	209.3855	1	SINGLE FAMILY	U	88.8900									MISTY HOLLOW FARM			Heat pump		Y	FULL BSMT		VINYL SIDING	2026.2
68-A-122		51	031	PAVED		VA							CAMPBELL	90032	ALTAVISTA	020600	206	3814.1276							1	1	1942	100	1240	2	0	1	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	226.6847	234.0662	231.2187	1	SINGLE FAMILY	U	0.8800			0202 0107									Gravity		N	FULL CRAWL		ASBESTOS SHINGLE/SIDING	2026.2
86-A-4		51	031	PAVED		VA							CAMPBELL	90504	BROOKNEAL	020800	208	9513.8611							4	1	1955	100	1346	2	0	1	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	199.7072	218.0526	209.5971	1	SINGLE FAMILY	U	3.0099			0413 0301									Central Warm Air		Y	3/4 BSMT, 1/4 CRAWL		BRICK	2026.2
21E-2-3-14		51	031	PAVED		VA							CAMPBELL	95858	SPRING HILL	020401	204.0100	1346.0787							1	1	1963	100	1053	3	0	1	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	289.2962	294.9492	291.3671	1	SINGLE FAMILY	U	0			0421 0147									Heat pump		Y	FULL BSMT		BRICK	2026.2
46 A 3E	8464	51	031			VA		CAMPBELL THOMAS EDWARD	P O BOX 814	CONCORD VA 24538			CAMPBELL	90968	CONCORD	020101	201.0100	83200.5286		3900		3900	5700		1								51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	243.5877	266.9584	256.5939		SINGLE-FAM RES SUBURB		1.4600	PERSON		SPENCER	0	0													2026.2		STONEWALL
46 A 3D	8465	51	031			VA		CAMPBELL THOMAS EDWARD	P O BOX 814	CONCORD VA 24538			CAMPBELL	90968	CONCORD	020101	201.0100	101028.1089		24900		24900	7000		0								51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	240.7012	266.1761	253.3229		SINGLE-FAM RES SUBURB		9.2400	PERSON		SPENCER	0	0													2026.2		STONEWALL
103C-39-E-7		51	031	PAVED		VA							CAMPBELL	90504	BROOKNEAL	020900	209	313.1865							1	1	1965	100	1210	4	0	1	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	162.0200	168.5664	165.4803	1	SINGLE FAMILY	U	0			0569 0691									Central Warm Air		Y	FULL BSMT		BRICK	2026.2
91-A-71C		51	031	PAVED		VA							CAMPBELL	90504	BROOKNEAL	020900	209	1606.7249							1	1	1980	10	952	3	0	2	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	185.3205	186.5345	185.9335	1	SINGLE FAMILY	U	0			0493 0656									Forced hot air		N	NONE			2026.2
60 A 46	11048	51	031			VA		SHEEHAN CARLA ET ALS	12987 RICHMOND HWY	CONCORD VA 24538			CAMPBELL	90968	CONCORD	020102	201.0200	6458.3687		2700		2700	126876	2020-10-13	3								51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	249.4432	258.0469	253.1651		SINGLE-FAM RES SUBURB		0.6800	PERSON		NR CONCORD															2026.2		STONEWALL
118 A 6	2022	51	031			VA		ROBERTSON PHILLIP ET ALS	164 RHODODENDRON DR	WESTBURY NY 11590			CAMPBELL	90504	BROOKNEAL	020900	209	171929.0356		99500		99500			0								51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	185.4088	219.2474	205.3598		AGRIC/UNDEV (20-99.99 AC)		38.2500	PERSON		FALLING RIVER	0	0													2026.2		SOUTHSIDE
72 A 11	2127	51	031			VA		HARRIS FRANK A HARRIS EMMAGEAN P	1012 4TH ST NORTH EAST	WASHINGTON DC 20002			CAMPBELL	90968	CONCORD	020102	201.0200	7585.4468		26000		26000			0								51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	259.9103	267.2138	263.8189		SINGLE-FAM RES SUBURB		1.5000	PERSON		NR CONCORD	0	0													2026.2		SOUTHSIDE
60 A 45	6389	51	031			VA		MCMULLAN BRUCE F MCMULLAN MARY M	165 STONEWALL RD	CONCORD VA 24538			CAMPBELL	90968	CONCORD	020101	201.0100	1175.6483		8200		8200	10950	2020-11-25	0								51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	256.8123	262.2414	258.9806		SINGLE-FAM RES SUBURB		1.7500	PERSON		NR CONCORD															2026.2		STONEWALL