Saved query 93970187e423c049

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

0/80

Live SQL

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

54,250 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	landvalue	totalvalue	saledate	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	taxacres	ownertype	naicscode	legaldesc	book	page	placename	placetype	taxyear	taxdistrict
1070000400		51	089			VA	24530	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	AGR/UNDEV 100 UP ACR - VAC	NZ	368.6000	BUSINESS	3212	TURKEY COCK MOUNTAIN	104	319			2024	SNOW CREEK
601790031	43 5-68H	51	089	255 LANCER LANE	MARTINSVILLE	VA	24112						Henry	93975	Iriswood	010300	103	56422.9844				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	248.0787	275.5071	265.8736						611110				MT OLIVET ELEMENTARY SCHOOL	ELEMENTARY_SCHOOL		Henry County
167870002	43 4-25A	51	089	9 LOVELL DRIVE	MARTINSVILLE	VA	24112						Henry	93975	Iriswood	010300	103	10587.9111				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	269.3112	283.6597	278.2139													Henry County
150280000	54 4-12A	51	089	430 COUNTRYSIDE LANE	AXTON	VA	24054						Henry	93975	Iriswood	010500	105	3417.7509				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	225.8215	229.3475	227.9205													Henry County
076280000	63 5-5B	51	089	45 OLD MILL ROAD	RIDGEWAY	VA	24148						Henry	95295	Ridgeway	010500	105	6846.2705				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	217.8192	227.6831	224.3539													Henry County
135670001	5 7-55E	51	089	111 PENROSE DRIVE	BASSETT	VA	24055						Henry	95263	Reed Creek	011300	113	1688.0196				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	384.0141	389.6083	386.9767													Henry County
124190001	65 9-85J	51	089	5805 AXTON ROAD	AXTON	VA	24054						Henry	93975	Iriswood	010500	105	4861.4385				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	244.5182	250.7041	249.1767													Henry County
157450000	22 8-66B	51	089	28 ALICE DRIVE	AXTON	VA	24054						Henry	93975	Iriswood	010400	104	2905.1891				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	302.5299	307.5474	303.9301													Henry County
213410002	32 6-146D	51	089	5500 CHATHAM ROAD	MARTINSVILLE	VA	24112						Henry	93975	Iriswood	010400	104	2933.6641				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	272.0402	279.0354	276.4654													Henry County
002470000	51 3-42-7	51	089	5 CIRCLE DRIVE	MARTINSVILLE	VA	24112						Henry	95295	Ridgeway	010602	106.0200	797.4395				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	238.3343	246.3883	243.3424													Henry County
155160001	43 4-34B	51	089	3021 MOUNT OLIVET ROAD	MARTINSVILLE	VA	24112						Henry	93975	Iriswood	010300	103	19744.6513				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	263.7130	283.3428	276.0718													Henry County
130360059	33 1-2R	51	089	6710 CHATHAM ROAD	MARTINSVILLE	VA	24112						Henry	93975	Iriswood	010400	104	4379.8250				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	289.7412	294.5417	293.4228													Henry County
042900002	39 4-90	51	089	5060 PRESTON ROAD	MARTINSVILLE	VA	24112						Henry	93919	Horsepasture	010900	109	3398.7381				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	311.2536	319.0780	316.1495													Henry County
160910000	40 1-1-13-1212A	51	089	865 CHESTNUT STREET	FIELDALE	VA	24089						Henry	93919	Horsepasture	010800	108	1326.2952				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	258.9221	271.5205	266.0182													Henry County
170040005	44 9-46C	51	089	4035 OLD LIBERTY DRIVE	AXTON	VA	24054						Henry	93975	Iriswood	010400	104	3163.6648				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	267.1818	278.2283	272.5294													Henry County
194830001	31 8-13-A-7	51	089	44 WOODLAWN AVENUE	MARTINSVILLE	VA	24112						Henry	95263	Reed Creek	010300	103	2391.9942				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	327.3927	341.7313	335.1512													Henry County
246470000	29 7-67-K-246	51	089	40 BELMONT STREET	COLLINSVILLE	VA	24078						Henry	90944	Collinsville	010100	101	820.1061				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	255.4037	259.7187	257.7404													Henry County
120770009	43 5-73-13	51	089	70 HUNT WOODS DRIVE	MARTINSVILLE	VA	24112						Henry	93975	Iriswood	010300	103	19045.9070				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	247.6546	275.8977	263.4419													Henry County
053030001	32 5-57A	51	089	735 ELIJAH CIRCLE	MARTINSVILLE	VA	24112						Henry	93975	Iriswood	010400	104	9934.4756				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	241.2320	259.2473	250.3511													Henry County
138070001	25 7-38H	51	089	965 BOXWOOD LANE	BASSETT	VA	24055						Henry	90288	Blackberry	011000	110	8181.2553				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	367.3957	374.9588	372.1879													Henry County
217230000	51 9-12-2B3	51	089	1195 JOSEPH MARTIN HIGHWAY	MARTINSVILLE	VA	24112						Henry	95295	Ridgeway	010601	106.0100	1792.3570				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	250.9464	253.4356	252.7244													Henry County
114605001	44 9-49B	51	089	3901 A L PHILPOTT HIGHWAY	MARTINSVILLE	VA	24112						Henry	93975	Iriswood	010400	104	18627.6505				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	243.2902	275.2403	256.2768													Henry County
225295000	28 6-15-45	51	089	610 MURPHY ROAD	COLLINSVILLE	VA	24078						Henry	90944	Collinsville	010100	101	1336.0667				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	319.8453	323.2878	322.2352													Henry County
202640000	21 7-9	51	089	1049 NORTH FORK ROAD	MARTINSVILLE	VA	24112						Henry	95263	Reed Creek	010400	104	206006.0104				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	269.2877	319.3849	297.2296													Henry County
200630008	70 8-65B	51	089	175 BURBANK DRIVE	RIDGEWAY	VA	24148						Henry	93919	Horsepasture	010700	107	16735.1830				1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	298.6980	313.3724	307.2683													Henry County