Saved query 3164e0885880f027

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

34,711 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	saledate	numbldgs	yearbuilt	numfloors	bldgsqft	bedrooms	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	zoningcode	taxacres	ownertype	naicscode	legaldesc	parceltype	accesstype	iucnclass	placename	placetype	heating	heatfuel	cooling	foundation	roofcover	siding	taxdistrict
11602	51	117	OLD ROCK ROAD	CLARKSVILLE	VA	23927-3244	HUNTER, PAUL L & HUNTER, BEVERL…	764 OLD ROCK RD	CLARKSVILLE	VA	23927-3244	Mecklenburg	92453	9	930800	9308	243.3977	177500	30000	208200	185000	2018-11-20	1	2005	1	1652	3	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	99.8921	100.1907	100.0340	01	R1A	0.0600	PERSON	3211	UNIT 21	GOVT FEDERAL	CLOSED	OTHER	JOHN H. KERR RESERVOIR EASEMENTS	CONSERVATION EASEMENT	CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONCRETE BLOCK	COMPOSITION SHINGLE	ALUMINUM/VINYL	TCLK
18026	51	117		CLARKSVILLE	VA	23927	RUSSELL, JUNE LENORE	104 BEAR TRACK TRAIL	CLARKSVILLE	VA	23927	Mecklenburg	91253	1	930700	9307	4088.9092		49000	49000		2012-05-22		0	0	0	0	51117C	2026-01-08	A		88.5800	96.7236	91.3558	02	R2	1.0100	PERSON	7212	S 1/2 PAR B	GOVT FEDERAL	CLOSED	OTHER	JOHN H. KERR RESERVOIR	RECREATION MANAGEMENT AREA	UNDETERMINED	UNDETERMINED	OTHER				DPS
24199	51	117	SOUTH MECKLENBURG AVENUE	KENBRIDGE	VA	23944	JENKINS, TIMOTHY D & LINDA D	23 JONESBORO RD	KENBRIDGE	VA	23944	Mecklenburg	91853	5	930202	9302.0200	1081.4784	19200	60000	84400			1	1935	1	1076	0	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	135.4470	137.2849	136.5610	04	C3	0.2700	PERSON	5321	LOT - MECK. &				ENTERPRISE RENT-A-CAR	RENTAL_SERVICE	CENTRAL AIR	ELECTRIC	CENTRAL AIR	SLAB	TAR & GRAVEL	STUCCO/FRAME	TSH
19198	51	117	HIGHWAY ONE	CHESTER	VA	23831	A PLUS A RENTAL PROPERTIES, LLC	5242 NAIRN LANE	CHESTER	VA	23831	Mecklenburg	91703	4	930300	9303	4040.1798	65200	10000	84200	65800	2017-03-28	1	1972	1	1008	3	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	89.0305	92.3333	91.4380	02	AG	0.8500	BUSINESS	53131	DOCKERY CREEK						CENTRAL AIR	OIL	CENTRAL AIR	CONCRETE BLOCK	COMPOSITION SHINGLE	BRICK/VINYL	DSH
22669	51	117	HAWKINS STREET	EARLYSVILLE	VA	22936	ROBERTSON, SYBIL & LAMB, BONNIE…	2020 EARLYSVILLE RD	EARLYSVILLE	VA	22936	Mecklenburg	92453	9	930800	9308	1292.0708	83100	9000	92600	100000	2021-05-26	1	0	1	1025	3	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	104.9343	109.1193	107.0889	01	R2	0.3200	PERSON		LOTS 12-14 BLK 6						CENTRAL AIR	GAS	CENTRAL AIR	CONTINUOUS WALL	COMPOSITION SHINGLE	BRICK AND FRAME	TCLK
31987	51	117	HIGHWAY FIFTY-EIGHT	BOYDTON	VA	23917	SMALLWOOD, DEBORAH B	13575 HWY 58	BOYDTON	VA	23917	Mecklenburg	92303	8	930600	9306	1723.9993	73100	4600	77700	59000	2021-04-14	1	1960	1	976	2	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	120.9989	124.1919	122.6889	02	AG	0.4300	PERSON		PAR 55A- WILKERSON						CENTRAL AIR	GAS	CENTRAL AIR	CONCRETE BLOCK	COMPOSITION SHINGLE	ALUMINUM/VINYL	DBOY
9321	51	117	CAMPBELLS LANE	CLARKSVILLE	VA	23927	DUNSON, JEFFREY CLARK	111 CAMPBELLS LANE	CLARKSVILLE	VA	23927	Mecklenburg	91253	1	930700	9307	3250.1658	89200	52000	146200	65000	2011-05-13	1	1974	1	1520	2	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	98.9456	103.7154	101.1589	02	R2	0.8000	PERSON		LOT 35- HIDE AWAY SUB						STOVE	WOOD	OTHER	PIERS	METAL	BOARD & BATTEN	DCLK
23641	51	117	SOUTH HILL AVENUE	SOUTH HILL	VA	23970-0000	BETTS, ROBERT T & ROSELYN G	9365 HWY ONE	SOUTH HILL	VA	23970-0000	Mecklenburg	91853	5	930202	9302.0200	684.2437	23700	7500	31200	33000	2002-04-14	1	1945	1	768	2	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	129.4333	132.0178	130.8663	01	110	0.1700	PERSON		LOT 5 SEC C						STOVE	GAS	OTHER	CONCRETE BLOCK	COMPOSITION SHINGLE	ALUMINUM/VINYL	TSH
26928	51	117	CLIFFSIDE DRIVE	RALEIGH	VA	27615	GREEN, CATHERINE P & POZARYCKI,…	2125 HAMRICK DR	RALEIGH	NC	27615	Mecklenburg	92003	6	930103	9301.0300	5825.7931	276700	180000	493600	575000	2021-12-22	1	2000	1	2156	3	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	60.4934	81.7917	73.8278	02	AG	1.4400	PERSON		LOT 15R						CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONCRETE BLOCK	COMPOSITION SHINGLE	ALUMINUM/VINYL	DLAC
12273	51	117	HAPPY TRAIL	DINWIDDIE	VA	23841	ATKINSON, PAUL D & ATKINSON, ST…	11122 BOISSEAU ROAD	DINWIDDIE	VA	23841	Mecklenburg	92003	6	930103	9301.0300	316.1782	21500	4000	25900	10950	2021-05-06	1	2021	1	224	0	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	79.2860	81.1893	80.4486	02	R2	0.0800	PERSON		LOT 43H HARE VILLAGE						UNDETERMINED	ELECTRIC	WINDOW UNIT		COMPOSITION SHINGLE	BOARD & BATTEN	DLAC
19206	51	117	OLD PLANTATION ROAD	LACROSSE	VA	23950-0000	WILLIAMS, DAVID O	P O BOX 1	LACROSSE	VA	23950-0000	Mecklenburg	91853	5	930201	9302.0100	7190.3790	83700	18700	102900	75000	2006-05-19	3	1981	1	1488	6	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	95.2355	106.9032	101.5152	03	R2	1.7800	PERSON		MILES CREEK &						CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONCRETE BLOCK	COMPOSITION SHINGLE	CINDER BLOCK	DSH
32083	51	117	EASTERS ROAD	BOYDTON	VA	23917	BOYTER, TIFFANY AMBER & JERONIM…	1512 EASTERS RD	BOYDTON	VA	23917	Mecklenburg	92153	7	930600	9306	7558.6617	88800	17900	106700	171000	2022-08-02	1	1993	1	1512	3	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	110.8166	112.8139	112.1706	02	AG	1.8700	PERSON		PT LOT 10						CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONCRETE BLOCK	METAL	ALUMINUM/VINYL	DBOY
14759	51	117	GREY FOX COURT	HENRICO	VA	23229	GRIFFIN, DANIEL J JR & SUSAN V	8511 HENRICO AVE	HENRICO	VA	23229	Mecklenburg	91553	3	930104	9301.0400	3709.9816	98900	144000	262800	420000	2006-08-18	1	1978	1	1200	3	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	64.2196	73.4015	71.7222	02	R2	0.8100	PERSON		LOT 6-FOX RUN						CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONCRETE BLOCK	COMPOSITION SHINGLE	ALUMINUM/VINYL	DLAC
37824	51	117	WRAY ROAD	LA CROSSE	VA	23950	GITTMAN, PEGGY D	1338 WRAY RD	LA CROSSE	VA	23950	Mecklenburg	91553	3	930101	9301.0100	43470.1494	95300	52400	149700		2015-10-08	1	2002	1	1674	3	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	85.7500	108.7099	99.2779	02	AG	10.7400	PERSON		PAR B- BRANTLEY						CENTRAL AIR	GAS	CENTRAL AIR	CONCRETE BLOCK	COMPOSITION SHINGLE	ALUMINUM/VINYL	DLAC
34998	51	117	HIGHWAY FORTY NINE	SKIPWITH	VA	23968	MILLS, RHONDA L LIFE EST & NEWC…	21411 HWY 49	SKIPWITH	VA	23968	Mecklenburg	92303	8	930500	9305	7733.8445	50100	17400	83900		2022-04-27	1	1950	125	1180	3	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	126.6272	129.3433	128.0178	02	AG	1.9100	PERSON		PAR 2- LENHART						STOVE	GAS	OTHER	CONCRETE BLOCK	COMPOSITION SHINGLE	ALUMINUM/VINYL	DBLU
21755	51	117	EAST SYCAMORE STREET	CHASE CITY	VA	23924-0000	NICHOLS, THOMAS M & RHONDA Y	107 E SYC ST	CHASE CITY	VA	23924-0000	Mecklenburg	92153	7	930402	9304.0200	494.8993	23800	10000	33800		2006-02-14	1	0	1	1512	0	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	159.8458	161.3573	160.4676	04	B2	0.1600	PERSON		PT LOTS 1-3						CENTRAL AIR	OIL	CENTRAL AIR	CONCRETE BLOCK	TILE	CINDER BLOCK	TCC
23786	51	117	CHAPTICO ROAD	SOUTH HILL	VA	23970	FRIEND, CLAUDE H	706 CHAPTICO RD	SOUTH HILL	VA	23970	Mecklenburg	91853	5	930201	9302.0100	2636.3723	55000	20000	75000		2021-04-07	1	1950	1	1280	2	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	124.0274	127.1385	126.0153	01	115	0.6200	PERSON		LOT 9						CENTRAL AIR	OIL	CENTRAL AIR	CONCRETE BLOCK	COMPOSITION SHINGLE	ALUMINUM/VINYL	TSH
21119	51	117	HUSTON STREET	CHASE CITY	VA	23924	MILLS, DAVID S	734 HUSTON STREET	CHASE CITY	VA	23924	Mecklenburg	92153	7	930401	9304.0100	11168.2693	143900	15000	158900		2016-08-26	2	1950	175	2317	4	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	136.9207	146.8068	142.9409	01	R1	2.7599	PERSON		OGBURN ADD						CENTRAL AIR	OIL	CENTRAL AIR	BRICK	COMPOSITION SHINGLE	BRICK VENEER	TCC
21314	51	117	SIXTH STREET	RICHMOND	VA	23223	SMITH, WALTER L	3938 GROVE POINT DR	RICHMOND	VA	23223	Mecklenburg	91403	2	930402	9304.0200	1180.3771	15600	3000	18600		2022-11-02	1	1950	1	1066	3	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	151.0820	155.2240	153.1713	01	R3	0.2900	PERSON		LOT 50 X 210						CENTRAL AIR	GAS	CENTRAL AIR	CONCRETE BLOCK	COMPOSITION SHINGLE	HARD BOARD	TCC
12463	51	117	CIMMARRON TRAIL	NORTH CHESTERFIELD	VA	23237	RIDDLE, KARL W JR & RICE, ANN M	2931 GENERAL BOULEVARD	NORTH CHESTERFIELD	VA	23237	Mecklenburg	92003	6	930103	9301.0300	721.2571		8000	8000	2250	2020-04-27	1	0	0	0	0	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	68.9301	73.3235	70.2315	02	R2	0.1800	PERSON		LOT 53C COYOTE VILLAGE						UNDETERMINED	UNDETERMINED	OTHER				DLAC
6469	51	117	BRIDGE ROAD	SOUTH HILL	VA	23970	OPIE FARMS INC,	3918 SKYLINE RD	SOUTH HILL	VA	23970	Mecklenburg	92003	6	930300	9303	229127.9918		133600	133600	66000	2003-12-15		0	0	0	0	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	70.1203	108.3046	91.8629	05	AG	56.6200	BUSINESS	11111	WHITTLE LAND						UNDETERMINED	UNDETERMINED	OTHER				DBUC
34259	51	117	ESNON ROAD	SKIPWITH	VA	23968	THORNE, NANCY M	P O BOX 174	SKIPWITH	VA	23968	Mecklenburg	91403	2	930402	9304.0200	174169.2167	205300	105700	336400		2012-01-12	1	2006	1	1987	3	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	120.3015	152.0196	131.6159	05	AG	42.3500	PERSON		PAR 1 - BRYANT &						CENTRAL AIR	GAS	CENTRAL AIR	CONCRETE BLOCK	COMPOSITION SHINGLE	ALUMINUM/VINYL	DCC
24287	51	117	NORTH THOMAS STREET	SOUTH HILL	VA	23970	SMITH, DENNIS W & SHANNON D	110 N THOMAS ST	SOUTH HILL	VA	23970	Mecklenburg	91703	4	930201	9302.0100	2150.6810	194800	14000	209800	89000		1	1958	1	2413	3	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	125.5225	131.3179	128.8490	01	115	0.5300	PERSON		LOT 100 X 200						CENTRAL AIR	ELECTRIC	CENTRAL AIR	BRICK	COMPOSITION SHINGLE	BRICK VENEER	TSH
4561	51	117	SKIPWITH ROAD	SKIPWITH	VA	23968	OWEN, LOIS MATTHEWS	P O BOX 163	SKIPWITH	VA	23968	Mecklenburg	91403	2	930600	9306	12349.9922	134500	25000	185300		2020-05-14	2	1960	1	2225	0	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	131.8195	135.9320	133.9260	02	AG	3.0500	PERSON		BUTCHERS CREEK						CENTRAL AIR	OIL	CENTRAL AIR	BRICK	COMPOSITION SHINGLE	BRICK VENEER	DBOY
4285	51	117	SPANISH GROVE ROAD	CHASE CITY	VA	23924-0000	MOSLEY, DANIEL & MARY ANN	1295 SPANISH GROVE RD	CHASE CITY	VA	23924-0000	Mecklenburg	92303	8	930402	9304.0200	9887.6327	64000	21300	92400	6035		2	1978	1	1708	0	51117C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	157.2424	164.2095	161.9200	02	AG	2.4400	PERSON		LOT 2 - LOBLOLLY						BASEBOARD	ELECTRIC	OTHER	CONCRETE BLOCK	METAL	ALUMINUM/VINYL	DCC