Saved query 78f8bc231060e78b

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

37/80

Live SQL

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

54,608 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	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	zoningcode	taxacres	ownertype	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
1130101500		51	089	8124 HENRY RD	VA	24102	HIRSHFELD SPENCER FELICIA	7156 FAIRYSTONE PARK HWY	BASSETT	VA	24055	HENRY	95263	REED CREEK			2378.5499	137600	23000	160600	159900	2024-08-01	1	1	1931	2	2068	4	1	1			—		270.9692	272.0468	271.4520	200R	SINGLE FAMILY SUBURB - RES	NZ	0.6250	PERSON	HENRY	1216	2252						2	HOT WATER	UNDETERMINED	OTHER	CONCRETE	COMP SHINGLE	BRICK	2026.2	2025	BLUE RIDGE
1170001811		51	089		VA		TOWN CREEK LAND CORPORATION	18000 GREEN HILL ROAD	CHARLOTTE	NC	28278	HENRY	90288	BLACKBERRY	011300	113	58362.7252		1400	1400		2014-12-03	0								51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	278.7147	333.2393	311.2862	20	BLUE RIDGE	NZ	3.8100	BUSINESS	JULIA L PHILPOTT SUB RT 798 - T…	1055	1911	GOVT STATE	CLOSED	OTHER	HRY-VOF-3905	OTHER EASEMENT								2026.2	2014	BLUE RIDGE
1170009600		51	089		VA		TOWN CREEK LAND CORPORATION	18000 GREEN HILL ROAD	CHARLOTTE	NC	28278	HENRY	90288	BLACKBERRY	011300	113	243483.0032		14800	14800		2014-12-03	0								51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	256.6044	369.1690	309.0714	50	BLUE RIDGE	NZ	40	BUSINESS	MILL CREEK RT 603	1055	1911	GOVT STATE	CLOSED	OTHER	HRY-VOF-3905	OTHER EASEMENT								2026.2	2014	BLUE RIDGE
1130102000		51	089	40 HENRY FORK RD	VA	24102	BLUE RIDGE SOLVENTS COATINGS INC	P O BOX 759	HENRY	VA	24102	HENRY	95263	REED CREEK	011300	113	33965.5215	381000	70000	451000	600000	2003-10-03	2	1							51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	267.1603	272.3851	270.8101	40	BLUE RIDGE	NZ	9.6730	BUSINESS	RT 606 TRACT A	798	1383													2026.2	2003	BLUE RIDGE
1180004801		51	089		VA		KAFKA LUKAS	777 FAIRFIELD RD	BASSETT	VA	24055	HENRY	95263	REED CREEK	011300	113	21755.2610	81300	30000	111300	222500	2025-05-22	1	1							51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	327.6925	348.1608	333.9176	20	BLUE RIDGE	NZ	5	PERSON	RT 607-FAIRFIELD ROAD	1229	57													2026.2	2025	BLUE RIDGE
1130101700		51	089		VA		SCHISLER ERIC	4035 ELECTRIC RD	ROANOKE	VA	24018	HENRY	95263	REED CREEK	011300	113	3057.4534	61200	24000	85200	32750	2011-06-15	1	1							51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	271.2506	277.4555	272.3797	20	BLUE RIDGE	NZ	0.5560	PERSON	HENRY BLOCK 8 LOTS 11-14 PIEDMO…	999	267													2026.2	2011	BLUE RIDGE
1210006001		51	089		VA		COMMONWEALTH OF VA GAME INLAND	4010 WEST BROAD STREET	RICHMOND	VA	23230	HENRY	93975	IRISWOOD	010400	104	6836592.9715		1789000	1789000		2024-11-18	0								51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				72	SNOW CREEK	NZ	1789	GOVERNMENT	RT 651 TURKEY COCK MOUNTAIN	362	929	GOVT STATE	RESTRICTED	V	TURKEYCOCK MOUNTAIN	MOUNTAIN								2026.2	2024	SNOW CREEK
1180004900		51	089		VA		MILES WAYNE M	779 FAIRFIELD ROAD	BASSETT	VA	24055	HENRY	95263	REED CREEK	011300	113	73364.1349	179500	56700	236200		2012-02-21	2	1							51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	325.9888	360.5486	349.0374	20	BLUE RIDGE	NZ	14.9450	PERSON	OFF RT 607-FAIRFIELD ROAD	1010	1196													2026.2	2012	BLUE RIDGE
1130101800		51	089		VA		SCHISLER ERIC	4035 ELECTRIC RD	ROANOKE	VA	24018	HENRY	95263	REED CREEK	011300	113	2337.7252		1100	1100	32750	2011-06-15	0								51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	270.5906	271.6036	271.0683	20	BLUE RIDGE	NZ	0.4480	PERSON	HENRY BLOCK 4 LOTS 3 4 P O 11 1…	999	267													2026.2	2011	BLUE RIDGE
1170001810		51	089		VA		BRYANT LARRY L	5 PHILPOTT RD	HENRY	VA	24102	HENRY	90288	BLACKBERRY	011300	113	168396.6319	221700	81300	303000		2023-08-24	1	1							51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	277.1209	356.5039	317.5022	50	BLUE RIDGE	NZ	39.2200	PERSON	JULIA L PHILPOTT EST RT 798 - T…		0													2026.2	2023	BLUE RIDGE
1180002501		51	089		VA		WINSTON JAMES E PATRICIA G	459 DEER TRAIL RD	HENRY	VA	24102	HENRY	95263	REED CREEK	011300	113	40478.3641	24000	8100	32100			1	1							51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	292.7619	328.3081	313.3326	20	BLUE RIDGE	NZ	2.7060	PERSON	MILL CREEK	471	923													2026.2	1990	BLUE RIDGE
1130101600		51	089		VA		HIRSHFELD SPENCER FELICIA	7156 FAIRYSTONE PARK HWY	BASSETT	VA	24055	HENRY	95263	REED CREEK	011300	113	1290.6060		1200	1200	159900	2024-08-01	0								51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	271.2641	272.3013	271.6074	20	BLUE RIDGE	NZ	0.1250	PERSON	HENRY	1216	2252													2026.2	2024	BLUE RIDGE
700100587040	1333160	51	089		VA		WOOD HEATHER L	3163 MAPLE AVE TRLR 9	BURLIGTON	NC	27215	HENRY	93919	HORSEPASTURE	010700	107	3030.9863	60204	11510	71714			1	1	2011						51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	280.3600	287.1420	283.7084			RA	0.7300	PERSON		1580	1519													2026.2		STONEY VIEW FD
1130101400		51	089		VA		DEHART MARY FRANCES H OTHERS	7406 HENRY ROAD	HENRY	VA	24102	HENRY	95263	REED CREEK	011300	113	976.1579		2400	2400			0								51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	270.5249	271.1291	270.8180	40	BLUE RIDGE	NZ	0.5000	PERSON	HENRY	B79	1187													2026.2	1994	BLUE RIDGE
1070000501		51	089		VA		KCRAGET CHARLES BRIAN ANDRES	1116 LOG HVN	DRY FORK	VA	24549	HENRY	93975	IRISWOOD	010400	104	846049.4391		300	300	554415	2020-01-30	0								51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				60	SNOW CREEK	NZ	0.2590	PERSON	TURKEY COCK MTN FRANKLIN HENRY …	1134	51													2026.2	2020	SNOW CREEK
1130101900		51	089		VA		NAFF RUDOLPH C JR ESTATE	1155 LILLIAN NAFF RD	HENRY	VA	24102	HENRY	95263	REED CREEK	011300	113	303.7110		500	500		2025-01-29	0								51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	270.3165	270.9498	270.7249	20	BLUE RIDGE	NZ	0	ESTATE	AT HENRY LOT 9 BLK 4															2026.2	2025	BLUE RIDGE
1070000400		51	089		VA		LESTER LUMBER CO	P O BOX 4991	MARTINSVILLE	VA	24115	HENRY	93975	IRISWOOD	010400	104	1519223.1532		442300	442300		2024-11-18	0								51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				60	SNOW CREEK	NZ	368.6000	BUSINESS	TURKEY COCK MOUNTAIN	104	319													2026.2	2024	SNOW CREEK
700100671967	29762	51	089		VA		LUCAS PAUL J	445 RIVERVIEW RD	STONEVILLE	NC	27048	HENRY	93919	HORSEPASTURE	010700	107	15351.9669		35175	35175					0						51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	256.4473	286.7283	272.3574			RA	3.9600	PERSON		CREATE	2003													2026.2		STONEY VIEW FD
700100272998	17384	51	089		VA		SHELTON DAVID MARTIN	2861 ANGLIN MILL RD	STONEVILLE	NC	27048	HENRY	93919	HORSEPASTURE	010700	107	7088.2968		18168	18168					0						51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	243.9433	269.5605	260.7749			RA	1.7700	PERSON		1346	0716													2026.2		STONEY VIEW FD
700100277991	1195420	51	089		VA		NANCE JIMMY W	2937 ANGLIN MILL RD	STONEVILLE	NC	27048	HENRY	93919	HORSEPASTURE	010700	107	22966.0147		20097	20097					0						51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	243.9612	274.7280	259.1316			RA	5.7500	PERSON		1009	1099													2026.2		STONEY VIEW FD
		51	089		VA							HENRY	95263	REED CREEK	011300	113	65633.2013						5								51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	265.9970	299.6559	277.5525												TACKFULLY TEAMED RIDING ACADEMY	SPORT_OR_FITNESS_FACILITY								2026.2
00 00		51	089		VA							HENRY	93975	IRISWOOD	010400	104	108206.1404						0								51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	408.3961	462.8111	440.2257																					2026.2
		51	089		VA		UNKNOWN					HENRY	90944	COLLINSVILLE	010300	103	52504.0365																—		273.6939	301.2609	281.2932					UNDETERMINED				GOVT UNKNOWN	CLOSED	OTHER	WETLAND MITIGATION AREA	LOCAL OTHER OR UNKNOWN								2026.2
		51	089		VA							HENRY	95263	REED CREEK	011300	113	2343.5550						0								51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	380.8829	385.3667	383.2006																					2026.2
		51	089		VA							HENRY	93975	IRISWOOD	010400	104	17575.9398						0								51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	307.0295	341.6436	321.8268																					2026.2