Saved query dfa629e4ce58a636

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

38/80

Live SQL

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

10,439 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	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
2890	2890-1	51	007	12230 SPRING RUN DR	AMELIA COURT HOUSE	VA	23002	STAPLES JENNIFER	12230 SPRING RUN DR	AMELIA COURT HOUSE	VA	23002	AMELIA	91349	2	930102	9301.0200	4219.3206	166600	26700	193300	180000	2006-03-20	1	1	1992		1468	3		2	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	85.0560	88.1657	86.7404	SNGL FAM RES SUBURBAN	DWELLING	RURAL RESIDENTIAL		1	PERSON	1 0020 AC	274	3723		CENTRAL AIR	UNDETERMINED	CENTRAL AIR	BRICK	COMP SHGLS	HARDBOARD	2026.2		01 GILES
11420	11420-1	51	007	19330 PERKINSON RD	JETERSVILLE	VA	23083	COREY J DORTON	19330 PERKINSON RD	JETERSVILLE	VA	23083	AMELIA	91499	3	930200	9302	9883.1052	193100	24900	218000	155000	2016-07-22	1	1	2007	2	1488	4		2	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	97.8562	103.7334	101.6238	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION		2	PERSON	2 000 AC	278	2782		CENTRAL AIR	UNDETERMINED	CENTRAL AIR	CONCI BLOCK	COMP SHGLS		2026.2		01 GILES
5053	5053-1	51	007	4897 GUM FORK RD	GLOUCESTER	VA	23061	SHANNON SHARLENE S	22920 GENITO RD	AMELIA COURT HOUSE	VA	23061	AMELIA	91199	1	930102	9301.0200	26204.7496	213100	45000	258100	36000	2003-01-01	1	1	2004	1	1560	3		2	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	118.2638	129.0935	124.3547	03	LEIGH	A-5		6.0199	PERSON	PINECROFT 6 020 AC	225	363	1	CENTRAL AIR	UNDETERMINED	CENTRAL AIR	BRICK	COMP SHGLS		2026.2
3567	3567-1	51	007	7855 DASH LN	JETERSVILLE	VA	23083	WESTON KEVIN	7855 DASH LN LANDING TERRACE	JETERSVILLE	VA	23083	AMELIA	91199	1	930101	9301.0100	18604.3126	102300	32200	134500	158500	2018-11-02	1	1	1999		1566	3		2	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	107.6666	124.8566	118.1014	SNGL FAM RES SUBURBAN	DWELLING	AGRICULTURAL		4	PERSON	4 000 AC	0275	8297	1	CENTRAL AIR	UNDETERMINED	CENTRAL AIR	BRICK			2026.2		03 LEIGH
10585	10585-1	51	007	16861 ARABIAN DR	AMELIA COURT HOUSE	VA	23002	TOMLIN GUY RODNEY ETUX	16861 ABRABIAN DR	AMELIA COURT HOUSE	VA	23002	AMELIA	91649	4	930102	9301.0200	11263.9874	276900	33300	310200			1	1	2004		1722	3	1	2	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	84.2592	93.3976	90.2709	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	RURAL RESIDENTIAL		2.1669	PERSON	AMELIA ESTATES SEC 3	272	1376	1	CENTRAL AIR	UNDETERMINED	CENTRAL AIR	BRICK	COMP SHGLS		2026.2		01 GILES
4986	4986-1	51	007	1443 RICHMOND RD	AMELIA COURT HOUSE	VA	23002	HANCOCK HARVEY LI ETUX LIFE EST…	1443 RICHMOND RD	AMELIA COURT HOUSE	VA	23002	AMELIA	91799	5	930200	9302	21995.8388	115600	34800	150400	150400	2007-03-12	1	1	2002		1512	3		2	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	96.0607	103.6489	100.8359	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION		5.1190	PERSON	PARCEL A	276	2041		CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONC BLOCK	COMP SHGLS		2026.2		03 LEIGH
5617	5617-1	51	007	11550 LOCUST DALE LN	AMELIA COURT HOUSE	VA	23002	TAYLOR MONIQUE NICOLE	AMELIA COURT HOUSE VA 23002			23002	AMELIA	91799	5	930200	9302	5241.7291	398800	49300	448100		2019-02-19	1	1	1996	1	1824	2	1	2	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	76.2369	81.2221	78.9870	RURAL RESIDENTIAL	RURAL RESIDENTIAL	33 73H		5	PERSON	3 AC FROM D	276	1296	1	CENTRAL AIR	ELECTRIC	CENTRAL AIR	SLAB	COMP SHGLS		2026.2	2023
4301	4301-1	51	007	12558 GENITO RD	AMELIA COURT HOUSE	VA	23002	CLEMENTS WILLIAM JR ETALS	12558 GENITO RD	AMELIA COURT HOUSE	VA	23002	AMELIA	91349	2	930102	9301.0200	11357.1517	111600	23200	134800			1	1	1997		2052	3		2	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	78.4052	89.5999	86.0765	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	RURAL PRESERVATION		2	PERSON	2 000 AC	0224	330		CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONC BLOCK	COMP SHGLS	VINYL	2026.2		01 GILES
8180	8180-1	51	007	14161 DYKELAND RD	AMELIA COURT HOUSE	VA	23002	STANG WILLIAM E	AMELIA COURT HOUSE VA 23002	AMELIA COURT HOUSE	VA	23002	AMELIA	91349	2	930102	9301.0200	10182.2903	106600	27600	134200			1	1	2004		1736	4		2	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	84.6057	91.3239	88.7093	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	RURAL PRESERVATION		2.5370	PERSON	PARCEL B	0217	261	1	CENTRAL AIR	UNDETERMINED	CENTRAL AIR	PIERS	COMP SHGLS		2026.2		01 GILES
7006	7006-1	51	007	9610N NAMOZINE RD	AMELIA COURT HOUSE	VA	23002	ALEXANDER AUGUSTUS M	9610 NAMOZINE RD	AMELIA COURT HOUSE	VA	23002	AMELIA	91799	5	930200	9302	6021.9932	78200	26200	104400			1	1	1969		960	3		1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	91.9142	94.8016	93.6124	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION		1.5200	PERSON	1 520 AC	0	0		CENTRAL AIR	UNDETERMINED	UNDETERMINED	CONCI BLOCK	SHGLS		2026.2		02 JACKSON
4181	4181-1	51	007	22300 PERKINSON RD	JETERSVILLE	VA	23083	OWENS LATAISHA	22240 PERKINSON RD	JETERSVILLE	VA	23083	AMELIA	91499	3	930200	9302	2456.7691	92300	17600	109900	109900	2021-07-01	1	1	1970		1016	3		1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	135.5833	138.1172	136.9922	1948	RESIDENTIAL	RESIDENTIAL		0.5000	PERSON	500 AC	0	0					BRICK	COMP SHGLS		2026.2		03 LEIGH
3175	3175-1	51	007	14301 NAMOZINE RD	CHURCHI ROAD	VA	23833	WILLIAMS JOHN W ETUX	1430 NAMOZINE RD	CHURCHI ROAD	VA	23833	AMELIA	91799	5	930200	9302	10554.6524	90800	28800	119600			1	1	1979		1200	3	1	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	52.7193	61.8392	56.7977	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	RURAL PRESERVATION		2.7400	PERSON	REESE ROAD	267	3708	1					COMP SHGLS		2026.2		02 JACKSON
7280	7280-1	51	007	1675 ROCKY FORD RD	POWHATAN	VA	23139	HERTZLER ROBERT L ETAL	11140 PROMISE LAND RD	POWHATAN	VA	23139	AMELIA	91649	4	930102	9301.0200	4836.3278	82900	28200	111100	33000	2009-02-18	1	1	1999		800			1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	109.0883	112.1919	111.3301	01	GILES	AVERAGE		1.9990	PERSON	278 9395	278	9395						METAL		2026.2		01 GILES
2214	2214-1	51	007	94301 PRIDESVILLE RD	AMELIA COURT HOUSE	VA	23221	ONEAL JULIA	207 CLOVELLY RD	RICHMOND	VA	23221	AMELIA	91649	4	930102	9301.0200	2116.8572	98600	19600	118200			1	1	1952		858		1	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	106.4224	108.4902	107.9597	SNGL FAM RES URBAN	SNGL FAM RES URBAN	RURAL RESIDENTIAL		0.3560	PERSON	356 AC	0	0	1					COMP SHGLS		2026.2		01 GILES
2430	A399 / 5	51	007	18509 JOPLIN RD	TRIANGLE	VA	22172	MARTIN WILLIAM M	18509 JOPLIN RD	TRIANGLE	VA	22172	AMELIA	91799	5	930200	9302	54114.3149		37800	37800	5000	2006-04-11	1	1	1999						51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	73.1443	87.7257	80.5154	SNGL FAM RES - SUBURBAN	SNGL FAM RES - SUBURBAN	RURAL PRESERVATION	RURAL PRESERVATION	11.1910	PERSON	PARCEL B 5 AC TO 67-4J	02	JACKSON								2026.2		02 JACKSON
11808	11808-1	51	007	3121 MILITARY RD	AMELIA COURT HOUSE	VA	23821	HAWKES WILLIAM H ESTATE	C O HAWKES BESSIE C	RICHMOND	VA	23223	AMELIA	91799	5	930200	9302	6916.2218	10600	23200	33800	20900	2017-03-01	1	1	2022						51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	85.9352	89.6013	88.5952	02	SNGL FAM RES - SUBURBAN	RURAL PRESERVATION		2.1360	ESTATE	2 136 AC	0	0								2026.2		02 JACKSON
107	260 / 518	51	007	VACANT	JETERSVILLE	VA	23083	GARZA REBECCA D	21828 ROCKY FORD RD	JETERSVILLE	VA	23083	AMELIA	91199	1	930102	9301.0200	55059.6638		22000	22000	18000	2004-01-01	1	1	1999						51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	90.9309	114.4877	102.9347	AGRICULTURAL	SNGL FAM RES - SUBURBAN	18 78C		10	PERSON	03 LEIGH	18	78C								2026.2	2022	03 LEIGH
3809	02 JACKSON	51	007	VACANT	FORD	VA	23850	REDD MARY L	1545 WILLS RD	FORD	VA	23850	AMELIA	91799	5	930200	9302	3269.9988		3000	3000	3000	2001-05-23	1	1	1999						51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	88.3025	90.9995	89.8997	76 4H	SNGL FAM RES - SUBURBAN	RURAL PRESERVATION		1	PERSON	02 JACKSON	258	824								2026.2	2022
5183	270 / 4209	51	007	VACANT	JETERSVILLE	VA	23083	LAM MARGARET M	25931 E SAYLORS CREEK RD	JETERSVILLE	VA	23083	AMELIA	91199	1	930101	9301.0100	34285.2756		25000	25000	899	2015-07-13	1	1	2001						51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	111.3629	128.0857	121.1328	03	LEIGH	AGRICULTURAL		7.3470	PERSON	PARCEL A 7 347 AC	270	4209								2026.2	2022	03 LEIGH
11058	23 53B	51	007	11300 HILLS LN	AMELIA COURT HOUSE	VA	23002	HENDERSON CHARLOTTE E	11300 HILLS LANE	AMELIA COURT HOUSE	VA	23002	AMELIA	91349	2	930102	9301.0200	8369.0231		24700	24700		2006-10-11	1	1	2006						51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	85.3156	92.9749	89.8647	SNGL FAM RES - SUBURBAN	RURAL RESIDENTIAL	RR-3	RURAL RESIDENTIAL	2	PERSON	01 GILES	FR 23-53	23 53B								2026.2	2022	01 GILES
1708	1708-1	51	007	VACANT	AMELIA COURT HOUSE	VA	23002	ONEAL SPENCER ETUX	12041 WINTERHAM RD	AMELIA COURT HOUSE	VA	23002	AMELIA	91649	4	930102	9301.0200	36898.9205		34800	34800	28750	2020-12-03	1	1	1999						51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	96.4044	109.5369	103.7851	RURAL RESIDENTIAL	SNGL FAM RES - SUBURBAN	RURAL RESIDENTIAL		10	PERSON	01 GILES	0	0								2026.2	2020	01 GILES
7601	7601-1	51	007	19165 PERKINSON RD	JETERSVILLE	VA	23083	WALSH ANDREW ETUX	02 JACKSON	JETERSVILLE	VA	23083	AMELIA	91799	5	930200	9302	2128.7398	2700	800	3500		1999-04-21	1	1	1999						51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	80.4719	83.4134	82.0785	SNGL FAM RES - SUBURBAN	RURAL RESIDENTIAL	RURAL RESIDENTIAL	RURAL RESIDENTIAL	0.2620	PERSON	0 262 AC	238	102								2026.2		02 JACKSON
3472	3472-1	51	007	VACANT	AMELIA COURT HOUSE	VA	23002	ANDERSON MICHAEL	P O BOX 577	AMELIA COURT HOUSE	VA	23002	AMELIA	91349	2	930102	9301.0200	65796.9801		20700	20700	3500	2019-10-15	1	1	1999						51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	77.3471	99.8694	90.1069	03	LEIGH	03 LEIGH	AGRICULTURAL	14.3600	PERSON	14 360 AC	2	6								2026.2		03 LEIGH
557	0166 / 132	51	007	VACANT	JAMAICA	VA	11433	VENABLE KHALIM HARRIS	111-34 176TH ST	JAMAICA	NY	11433	AMELIA	91199	1	930101	9301.0100	45610.9227		46700	46700			1	1	1999						51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	90.1618	125.3754	104.4114	SNGL FAM RES - SUBURBAN	AGRICULTURAL	03 LEIGH	AGRICULTURAL	16.1000	PERSON	16 100 AC	0036	701								2026.2	2022	03 LEIGH
7835	7835-1	51	007	660 CLEMENTOWN RD	POWHATAN	VA	23139	BARDEN JOHN D	14610 BENT CREEK RD	AMELIA COURT HOUSE	VA	23139	AMELIA	91199	1	930102	9301.0200	1937.1576	25000	17100	42100			1	1	1940			3		1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	97.6666	100.5974	99.2656	1900	SNGL FAM RES - SUBURBAN	A-5		0.5000	PERSON	03 LEIGH	0	0								2026.2