Saved query 1747bd7411ebb9d1

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

44/80

Live SQL

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

60,909 matching parcels

Data Preview

parcelid	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	zoningdesc	taxacres	ownertype	legaldesc	book	page	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
0500000304	51	143	121 CROSS HARBOUR DR	PENHOOK	VA	24137	KENNEDY JOHN D PATRICIA P	121 CROSS HARBOUR DRIVE	PENHOOK	VA	24137	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	2990.1113	418900	55000		473900	257000	2000-04-17	1	1	1988	1	1684	3	0	3			—		243.7420	252.7636	248.5913	200R	SINGLE FAMILY SUBURB - RES	RPD		0.7640	PERSON	RT 626	1070	2309	0	HEAT PUMP	ELECTRIC	HEAT PUMP	STONE	COMP SHINGLE	CEDAR	2026.2	2025	UNION HALL
0510005922	51	143	227 COOL BRANCH RD		VA	24137	FELLOWS RANDY SHARON	500 PATHFINDER DR	HENRY	VA	24102	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	3012.3834	196000	39000		235000	25000	2020-09-28	1	1	2023	1	672	1	0	1			—		256.5961	260.6973	259.1821	200R	SINGLE FAMILY SUBURB - RES	A1		0.7500	PERSON	RT 965-PAYNES RD LOT 1 FC PORTI…	1147	2525	0	HEAT PUMP	ELECTRIC	HEAT PUMP	BRICK/CONC BLOCK	METAL/TIN	T1-11	2026.2	2025	UNION HALL
31324	51	143	11033 STAGE COACH RD	GRETNA	VA	24577	CREWS TIFFANI D	11033 STAGE COACH RD	GRETNA	VA	24577	PITTSYLVANIA	90152	BANISTER	010700	107	11670.4259	78254	26613	3000	98867	52800	2015-08-03	1	1	2001	1	2128	4		2	51083C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				200R	SFD - SUBURBAN			3.2500	PERSON	PARCEL 2A PITTS LINE PB21/222	PB21/222	222	1	ELECTRIC CENTRAL HEAT	ELECTRIC	CENTRAL AIR	PIERS	METAL/TERNE PLATE		2026.2	2024	D2
6808	51	143	4175 LOGAN RD	JAVA	VA	24565	BRENDA P COLEMAN CHARLES HENRY …	4175 LOGAN ROAD	JAVA	VA	24565	PITTSYLVANIA	90152	BANISTER	010700	107	5869.0300	107738	12846	200	120184		1994-01-01	1	1	1955	1	1750	3		1	51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				200R	SFD - SUBURBAN	CO		1.4000	PERSON	ELK HORN CREEK DB 315/647	315	647		CENTRAL HEAT	UNDETERMINED		CONCRETE BLOCK	COMPOSITION SHINGLE	ALUMINUM/VINYL	2026.2	2025	HALIFAX
0500101500	51	143	170 ANTHONY FORD RD		VA	24137	HAMMOND LEONARD D	4412 PHEASANT RUN DR	GREENSBORO	NC	27408	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	2170.7688	102900	262000		364900	75000	1987-05-13	1	1	1976	1	1152	3	1	1			—		240.8470	253.8055	250.2754	20	UNION HALL	R1		0.5270	PERSON	ANTHONY FORD SUBD LOT 3 SEC 2	413	431	0				BRICK/CONC BLOCK	COMP SHINGLE	VINYL	2026.2	1987	UNION HALL
23661	51	143	6756 ROCK SPRINGS RD	SUTHERLIN	VA	24594	CHRISTINE M HICKS CHARLES A JR …	6756 ROCKSPRINGS ROAD	SUTHERLIN	VA	24594	PITTSYLVANIA	91104	DAN RIVER	010803	108.0300	138184.7003	143233	49825	2400	188258	190000	2020-08-20	1	1	1982	1	1328	5		2	51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				200R	SFD - SUBURBAN	A1	A1	13	PERSON	PT TR 1D ST RD 713 COUNTY LINE	NULL			CENTRAL HEAT	UNDETERMINED	CENTRAL AIR	CONCRETE BLOCK	COMPOSITION SHINGLE		2026.2	2025	COUNTY LINE
19261	51	143	E ELKHORN ROAD	MOSER	VA	24565	MOSER GARY JANET	3960 CHURCH RD.	MOSER	VA		PITTSYLVANIA	90152	BANISTER	010700	107	220514.0178	102196	35844	384	137272		2023-10-23	1	1	1902	1	2588	6	1	2	51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				500R	AGRICULTURAL 20 - 99 AC - RES	CO		45.8000	PERSON	PT TRACT 1-C L DAVENPORT LD LIF…	NULL		1	WOOD	WOOD	UNKNOWN	STONE	METAL/TERNE PLATE	WOOD LAP SIDING	2026.2	2025	D3
12344	51	143	3649 KERNS CHURCH RD	HALIFAX	VA	37620	FALLEN PHILLIP A OTHERS	236 ROSCOMMON DRIVE	BRISTOL	TN	37620	PITTSYLVANIA	91104	DAN RIVER	010803	108.0300	1988.7302	118150	11311	3811	121839		2017-05-10	1	1	1977	1	1672	3	1	2	51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				200R	SFD - SUBURBAN	45		0.4600	PERSON	SUTHERLIN DB390/167	NULL			CENTRAL HEAT	UNDETERMINED	CENTRAL AIR		COMPOSITION SHINGLE		2026.2	2025	HALIFAX
25366	51	143	611 IONA DR	HALIFAX	VA	24557	REAVIS JESSICA LYNNE	714 VICAR RD	DANVILLE	VA		PITTSYLVANIA	90152	BANISTER	010100	101	4901.9795	4196	10000		14196	28000	2019-05-14	1	1	2002	1	2079	3	1	1	51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				200R	SFD - SUBURBA	A1		1	PERSON	CODY-MT AIRY RD.	NULL		1	HEAT PUMP SYSTEM	ELECTRIC	HEAT PUMP SYSTEM	CONCRETE BLOCK	COMPOSITION SHINGLE		2026.2	2025	D2
11205	51	143	11024 STAGE COACH RD	GRETNA	VA	24557	DEJARNETTE JESSIE MAE	11024 STAGE COACH ROAD	GRETNA	VA		PITTSYLVANIA	90152	BANISTER	010100	101	4168.4709	96473	17350	9600	94623			1	1		1	1401	3		2	51083C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				200R	SFD - SUBURBA	01		0.5000	PERSON	CODY-MT AIRY RD LIFE INT DB1148…	1148	631	0	ELECTRIC BB	ELECTRIC	CENTRAL AIR	CONCRETE REINFORCED	COMPOSITION SHINGLE	ALUMINUM/VINYL	2026.2	2025	HALIFAX
25435	51	143	3029 HACKBERRY RD	SUTHERLIN	VA	24594	MOORE EDWARD R	3023 HACKBERRY ROAD	SUTHERLIN	VA		PITTSYLVANIA	91104	DAN RIVER	010803	108.0300	14243.8815	50015	12149		62164		1999-08-05	1	1	1951	1	1120	4		1	51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				200R	SFD - SUBURBA	40	COMM/IND	0.8900	PERSON	TR 3-C RD 713 COUNTY LINE DB461…	730/45			CENTRAL HEAT	UNDETERMINED			COMPOSITION SHINGLE		2026.2	2025	D4
0500200400	51	143			VA		MATHIAS BARRY A WENDELIN S	3324 MEADOWBROOK LANE	CHESAPEAK	VA	23321	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	2623.3749	20800	75000		95800	450000	2011-02-22	1	1							51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	240.8470	254.5892	249.6609	20	UNION HALL	R1		0.6939	PERSON	TOMPKINS SUBD LOT 4 4-A 4-B	994	1108								2026.2	2011	UNION HALL
0500000601	51	143			VA		MULLADY ALBERT J GAYLE A	140 THREE POINTE ISLE DR	PENHOOK	VA	24137	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	3921.1171	68300	200000		268300	780000	2017-08-16	1	1							51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	240.8494	252.5869	248.3782	20	UNION HALL	A1		0.4150	PERSON	THREE POINTE ISLE PT LOT 3	1096	1884								2026.2	2017	UNION HALL
0500000302A	51	143			VA		WEAVER ROBERT VIRGINIA	P O BOX 110	PENHOOK	VA	24137	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	3672.6102	673200	252000		925200	418000		1	1							51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	240.8502	251.9987	248.0327	20	UNION HALL	A1		0.4970	PERSON	RT 626 PT TRACT B	673	438								2026.2	2000	UNION HALL
0500101600	51	143			VA		RADCLIFF CONNELL L DEBORAH A	3820 SPARROW POND LN	RALEIGH	NC	27606	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	3292.6418	498500	262000		760500		2024-03-15	1	1							51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	240.8470	254.2462	249.7130	20	UNION HALL	R1		0.6310	PERSON	ANTHONY FORD LOT 2 SEC 2	1210	1709								2026.2	2024	UNION HALL
0680007510	51	143			VA		WITCHER ELVIS N PAMELA P	9470 SONTAG ROAD	ROCKY MOUNT	VA	24151	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	95727.5841		40800		40800	268100	2015-01-09	1								51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	233.0928	282.7099	258.0541	20	UNION HALL	A1		9.6000	PERSON	OFF RT 782-FRUITRIDGE DRIVE TRA…	1057	859								2026.2	2015	UNION HALL
0500000305	51	143			VA		FRITH COY B JR ELIZABETH W	550 WINDY RIDGE RD	MARTINSVILLE	VA	24112	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	6745.1228	58400	170000		228400			1	1							51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	243.6701	257.6373	252.7701	20	UNION HALL	A1		0	PERSON	GREEN T FARM PT LOT 5	569	1655								2026.2	1998	UNION HALL
0680007509	51	143			VA		WITCHER ELVIS N PAMELA P	9470 SONTAG ROAD	ROCKY MOUNT	VA	24151	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	60708.1348		20700		20700	268100	2015-01-09	0								51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	242.1051	272.8208	261.9604	20	UNION HALL	A1		6.9000	PERSON	OFF RT 782-FRUITRIDGE DRIVE TRA…	1057	859								2026.2	2015	UNION HALL
0680007200	51	143			VA		WALKER DAVID K GLADYS B	2385 FRUITRIDGE DRIVE	PENHOOK	VA	24137	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	40739.8584		19500		19500	7500	2013-09-06	0								51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	261.2939	275.0627	270.4885	20	UNION HALL	A1		2.5000	PERSON	RT 782	1038	2130								2026.2	2013	UNION HALL
0500000300	51	143			VA		KING SHELBY WORLEY	789 ROXALANA HILLS DR	DUNBAR	WV	25064	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	11093.3024	18400	135000		153400		2022-11-04	4	1							51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	243.5342	259.9329	255.9240	20	UNION HALL	A1		0.5669	PERSON	RD 626		0								2026.2	2022	UNION HALL
0680007511	51	143			VA		WITCHER ELVIS N PAMELA P	9470 SONTAG ROAD	ROCKY MOUNT	VA	24151	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	91555.2883		24900		24900	268100	2015-01-09	0								51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	240.2209	282.8563	265.1648	20	UNION HALL	A1		4.3000	PERSON	OFF RT 782-FRUITRIDGE DRIVE TRA…	1057	859								2026.2	2015	UNION HALL
0500000303	51	143	151 BLUE HERON DR	PENHOOK	VA	24137	SCOTT GREGORY Y	88 ROYAL TERN ST	WIRTZ	VA	24184	PITTSYLVANIA	90592	CALLANDS-GRETNA			2674.2203	40000	240500		280500	125000	2020-07-30	1	1			0						—		242.6743	252.4978	247.7083	200V	SINGLE FAMILY SUBURB - VAC	A1		0.6690	PERSON	RT 626	1115	26								2026.2	2025	UNION HALL
0510005922B	51	143			VA		SONEGO CERA WILMAR JUAN	112 CAROLYN CT	DANVILLE	VA	24540	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	69.1000		700		700	25000	2020-09-02	0								51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	256.1046	257.1114	256.7203	20	UNION HALL	A1		0.0200	PERSON	RT 965-PAYNES RD LOT 3 FC PORTI…	1146	247								2026.2	2020	UNION HALL
0510005922A	51	143			VA		LAKESHORE POINTE AT SML LP	3742 CARDINAL DOWNS DR	GREENSBORO	NC	27410	PITTSYLVANIA	90592	CALLANDS-GRETNA	010302	103.0200	968.1046		1800		1800	950000	2020-05-11	0								51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	253.5198	260.4235	256.8586	20	UNION HALL	A1		0.2200	BUSINESS	RT 965-PAYNES RD LOT 2 FC PORTI…	1139	4								2026.2	2020	UNION HALL
20415	51	143	0 RAILROAD TRL	SUTHERLIN	VA	24594	WEATHERFORD JOHNNA LEE	133 RAILROAD TRAIL	SUTHERLIN	VA		PITTSYLVANIA	91104	DAN RIVER	010803	108.0300	891.9466		1900		1900	10000	2023-12-21	1								51143C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				200V	SFD - SUBURBA	200	DESCRIPT	0	PERSON	LOT 4 RESUB.TR.4 FRANCES O.KERN…	PB6	139								2026.2	2025	D4