Saved query 9e49eaffebd45c23

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

15,179 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
118 A 16	3957	51	037	155 RED HOUSE RD	APPOMATTOX	VA	24522	WILLIAMS ALGIE L LIFE ESTATE	528 WINSTON RIDGE RD	LYNCHBURG VA 24501			CHARLOTTE	94431	MADISON	930102	9301.0200	236648.3265	49900	47100	-82500	262000		2021-02-11	1	1	1963	1	1075	3	0	1	51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	200.6073	227.7327	220.0528		SINGLE FAMILY		42.7500	PERSON		NR RED HOUSE								0	UNDETERMINED	UNDETERMINED	OTHER	CONCRETE BLOCK	COMPOSITION		2026.2	2025	SOUTHSIDE
64-A-27	64-A-27	51	037	PAVED	BROOKNEAL	VA	24528	GILLIAM PAUL T & KATE H	2571 ROLLING HILL RD	PAMPLIN	VA	23958	CHARLOTTE	94687	MIDWAY	930200	9302	60833.7151	54000	56500			290000	2021-12-03	2	1	1946	150	1476	4	0	1	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	212.5678	226.3632	221.5466	1	SINGLE FAMILY	U	10	PERSON		NARUNA RED HOUSE RD		S210008837							No heat-wood stove/insert		N	FULL BSMT	V2	VINYL SIDING	2026.2
64-A-34	64-A-34	51	037	PAVED	BROOKNEAL	VA	24528	KRAPF ESTHER B & JAMES R BARRALL	3 BARLOW RD	EDISON	NJ	08817	CHARLOTTE	94687	MIDWAY	930200	9302	216292.4433	59000	77100				2025-11-18	1	1	1916	100	1350	0	0	1	51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	210.3408	233.3260	222.3152	1	SINGLE FAMILY	U	16.7200	PERSON		TURNIP CRK PARCEL B		250006318							Forced hot air-oil		N	FULL CRAWL	A2	ALUM SIDING	2026.2
64-3-1	64-3-1	51	037		BROOKNEAL	VA	24528-	BALLOU FREDERICK	8507 SUGAR HILL RD	BROOKNEAL	VA	24528	CHARLOTTE	94687	MIDWAY	930200	9302	29364.6604	201300	32200			102520	2000-04-26	2	1	1975	10	1951	3	0	2	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	219.1382	225.9338	224.0043	1	SINGLE FAMILY	U	4.2400	PERSON		0987 0824									Heat pump		Y	NONE	B2	BRICK	2026.2
93-A-101	93-A-101	51	037	PAVED	BROOKNEAL	VA	24528-	BROGGIN JASPER J & ELIZABETH A	1330 ROBIN RD	BROOKNEAL	VA	24528	CHARLOTTE	94687	MIDWAY	930200	9302	4009.0494	73700	18000				2003-09-03	1	1	1973	100	780	3	0	1	51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	159.3900	166.0341	163.0394	1	SINGLE FAMILY	U	1	PERSON		TURNIP CRK		030009109							Electric baseboard		N	FULL BSMT	B2	BRICK	2026.2
104-A-67	104-A-67	51	037	PAVED	BROOKNEAL	VA	24528-	GUTHRIE DONNA WARD	1717 SUGAR HILL RD	BROOKNEAL	VA	24528	CHARLOTTE	94687	MIDWAY	930200	9302	238441.9522	55600	84200				2014-03-24	2	1	1950	100	1348	2	0	1	51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	131.3241	173.7195	148.8373	1	SINGLE FAMILY	U	21.3000	PERSON		TURNIP CRK		S140001180							Forced hot air-propane		N	FULL CRAWL	V2	VINYL SIDING	2026.2
79-A-52	79-A-52	51	037	UNPAVED	BROOKNEAL	VA	24528-	ROACH JAMES EDWIN	773 PARTRIDGE LN	BROOKNEAL	VA	24528	CHARLOTTE	94687	MIDWAY	930200	9302	527227.5525	92300	151100				2023-05-05	6	1	1900	100	1593	2	0	1	51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	171.1325	209.0704	191.6017	1	SINGLE FAMILY	U	47	PERSON		TURNIP CRK		W230000370							Gravity		N	FULL BSMT	B2	BRICK	2026.2
64-A-38	64-A-38	51	037	PAVED	BROOKNEAL	VA	24528-	CHEATHAM DANIEL W JR TRS	7933 SUGAR HILL RD	BROOKNEAL	VA	24528	CHARLOTTE	94687	MIDWAY			429345.3888	206500	180300				2025-02-28	6	1	1940	10	523	1	0	1	51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	190.0620	226.6670	211.4510	1	SINGLE FAMILY	U	47.5590	TRUST		TURNIP CRK		S250000993							Heat pump		Y	FULL CRAWL	B2	VINYL SIDING	2026.2
108-A-2	108-A-2	51	037		BROOKNEAL	VA	24528	PATRICK HENRY BOYS PLANTATION	1250 RED HILL RD	BROOKNEAL	VA	24528	CHARLOTTE	95351	ROANOKE	930200	9302	2514486.9077	769000	657900				2019-10-18	23	1	1950	1	2818				51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	116.1500	180.7093	151.2673	SCHADMIN	SCHOOL ADMINISTRATION	U	313.4100	PERSON	7121	RED HILL PROPERTY		190005336				RED HILL PATRICK HENRY NATIONAL…	HISTORY_MUSEUM		0 sf		N			WOOD FRAME	2026.2
79-A-51	79-A-51	51	037	PAVED	BROOKNEAL	VA	24528	SMITH REGINALD L	6391 SUGAR HILL RD	BROOKNEAL	VA	24528	CHARLOTTE	94687	MIDWAY	930200	9302	989924.0487	1500	52800				2024-08-01	1	1							51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	168.0440	216.5957	190.4458	68	OPEN SECONDARY PAVED	U	123.3500	PERSON		TURNIP CREEK		S240003655													2026.2
64-3-2	64-3-2	51	037	PAVED		VA		AIRSPUN PROPERTIES LLC	8559 SUGAR HILL RD	BROOKNEAL	VA	24528	CHARLOTTE	94687	MIDWAY	930200	9302	75496.1073	44000	46500			286742	2024-05-13	4	1							51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	206.2240	226.4960	217.9805	68	OPEN SECONDARY PAVED	U	7.4400	BUSINESS		DRY SPRING BRANCH LOT 2		240002231													2026.2
79-A-46	79-A-46	51	037	PAVED		VA		WHITLOW WELFORD H	467 WRENN RD	PHENIX	VA	23959	CHARLOTTE	94687	MIDWAY	930200	9302	598685.4990	4800	212300				2022-11-30	5	1							51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	167.3004	211.6771	192.1480	68	OPEN SECONDARY PAVED	U	79.5000	PERSON		TURNIP CRK		S220007184													2026.2
94-A-7	94-A-7	51	037	UNPAVED	BROOKNEAL	VA	24528-	X	188 MEBS WAY	BROOKNEAL	VA	24528	CHARLOTTE	94687	MIDWAY	930200	9302	534278.3179		153300				2001-07-06	0								51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	143.9292	195.6092	169.1263	68	OPEN SECONDARY PAVED	U	71.2000	PERSON		NR HAT CRK		S010004682													2026.2
79-A-47	79-A-47	51	037	UNPAVED	BROOKNEAL	VA	24528	GUTHRIE RONALD COLEMAN	192 OLE SOLDIER TRL	BROOKNEAL	VA	24528	CHARLOTTE	94687	MIDWAY			350119.0441	500	114900				2011-01-07	1	1							51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	170.3166	209.9789	189.3009	68	OPEN SECONDARY PAVED	U	52.8540	PERSON		TURNIP CRK		S110000108													2026.2
64-A-37	64-A-37	51	037	PAVED		VA		GILLIAM PAUL T & KATE H	2571 ROLLING HILL RD	PAMPLIN	VA	23958	CHARLOTTE	94687	MIDWAY	930200	9302	119869.2294		68900			290000	2021-12-03	0								51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	207.9614	226.2363	216.7557	9	HOMESITE	U	15	PERSON		TURNIP CRK		S210008837													2026.2
108-A-2B	108-A-2B	51	037	UNPAVED		VA		PATRICK HENRY MEMORIAL				00000	CHARLOTTE	95351	ROANOKE	930200	9302	1458948.0126		72800			37500	2001-08-24	2								51037C	2026-01-08	AE		105.2615	153.3019	119.8941	71	WOOD SECONDARY PAVED	U	39.7239	PERSON		RED HILL PROPERTY		010006068	GOVT STATE	UNKNOWN		RED HILL PLANTATION	UNKNOWN EASEMENT								2026.2
93-A-102	93-A-102	51	037	UNPAVED		VA		STOLTZFUS ELAM L & EMMA S	3800 WARDS FORK MILL RD	CULLEN	VA	23934	CHARLOTTE	94687	MIDWAY	930200	9302	3016.8050		1300			800000	2025-09-11	0								51031C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	159.0221	166.2901	163.3995	71	WOOD SECONDARY PAVED	U	1	PERSON		TURNIP CRK		250004753													2026.2
48 A 36A		51	037		CHARLOTTE C.H.	VA	23923	VASSAR BRENDA N & L GREGORY & C…	555 GARNETT PUMP RD.	CHARLOTTE C.H.	VA	23923	CHARLOTTE	95351	ROANOKE	930200	9302	119629.0286		44668													51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	136.3847	161.6833	156.6580	5			32.2500	PERSON		DB 481/764 WB 50/870 DB 428/536…	481 764		GOVT STATE	CLOSED	OTHER	CHL-VOF-3881	OTHER EASEMENT								2026.2		CRO
104-A-68	104-A-68	51	037	UNPAVED		VA		BARKSDALE MALCOLM E JR & DANA C	1243 MT CALVARY RD	BROOKNEAL	VA	24528	CHARLOTTE	94687	MIDWAY	930200	9302	214685.9238		40300				2025-05-06	0								51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	128.2465	166.8485	148.2532	71	WOOD SECONDARY PAVED	U	16	PERSON		TURNIP CRK		S250002256													2026.2
79-A-50	79-A-50	51	037	PAVED		VA		SMITH NEIL H TRS	PO BOX 95	MADISON HEIGHTS	VA	24572	CHARLOTTE	94687	MIDWAY	930200	9302	459947.4227		132400				2024-10-11	2								51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	166.8677	215.7172	189.1495	71	WOOD SECONDARY PAVED	U	44	TRUST		TURNIP CRK		240005016													2026.2
94-A-10	94-A-10	51	037	PAVED		VA		PETTY L P & BETTY ANN	129 LAWYERS RD	RED HOUSE	VA	23963	CHARLOTTE	94687	MIDWAY	930200	9302	129292.8520		20000				2024-07-29	0								51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	142.2021	173.1956	152.0232	71	WOOD SECONDARY PAVED	U	5	BUSINESS		TURNIP CRK		W240000693													2026.2
94-A-3	94-A-3	51	037	PAVED		VA		BRADLEY CARL L & PANSY M	1295 RED BOTTOM RD	BROOKNEAL	VA	24528	CHARLOTTE	94687	MIDWAY	930200	9302	293377.7045		8000				2005-06-07	0								51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	157.3246	186.3916	170.7013	68	OPEN SECONDARY PAVED	U	1.6000	PERSON		CHARLOTTE LINE		050004233													2026.2
104-A-69	104-A-69	51	037	UNPAVED		VA		KYANITE MINING CORP	PO BOX 256	DILLWYN	VA	23936	CHARLOTTE	94687	MIDWAY	930200	9302	186382.3148		1800				2005-04-06	0								51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	138.5404	174.1629	154.7354	71	WOOD SECONDARY PAVED	U	1	BUSINESS		TURNIP CRK		050002510													2026.2
94-A-11	94-A-11	51	037	PAVED		VA		CHESAPEAKE FOREST PRODUCTS CO	PO BOX 3349	ALBANY	GA	31706	CHARLOTTE	94687	MIDWAY	930200	9302	496900.6291		36000			8475	2014-11-12	0								51037C	2026-01-08	A		139.0240	173.9326	149.6540	71	WOOD SECONDARY PAVED	U	12.5000	BUSINESS		TURNIP CRK		140005047													2026.2
64-A-39	64-A-39	51	037	UNPAVED		VA		CHEATHAM DANIEL W JR TRS	7933 SUGAR HILL RD	BROOKNEAL	VA	24528	CHARLOTTE	94687	MIDWAY	930200	9302	188398.8411		63100				2025-02-28	3								51037C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	194.2032	219.2852	209.5187	68	OPEN SECONDARY PAVED	U	11.6960	TRUST		TURNIP CRK		250000993													2026.2