Saved query 794ec3e3253f8e73

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

10,465 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	zoningcode	taxacres	ownertype	naicscode	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype
2-18	8256	51	007	17730 BRACKETS BEND LN	AMELIA COURT HOUSE	VA	23002	WEAVER LAND AND TIMBER LL	14851 N LODORE RD	23002	Amelia	91349	2	930102	9301.0200	434042.8584	500	58200	58700	450000	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				A-5	112	PERSON	4889		0	0	NGO	CLOSED		EVER GREEN TEAM EASEMENT	OTHER EASEMENT
23-13A	3240	51	007	13001 DYKELAND RD	AMELIA COURT HOUSE	VA	23002	THE DYKELAND HADFIELD FAM	13001 DYKELAND RD	23002	Amelia	91349	2	930102	9301.0200	229752.8118	692400	156700	849100		2	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	57.2137	82.8508	71.7199	RP-5	40	PERSON	71212		248	99				DYKELAND	HISTORIC_SITE
36-16	8257	51	007	0		VA	23966	FARLEY JAMES R	241 HIGH BRIDGE RD	23966	Amelia	91199	1	930101	9301.0100	127465.4698		51400	51400			51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	92.6219	129.6537	110.8781	A-5	30	GOVERNMENT	7212		0	0	GOVT STATE	RESTRICTED	OTHER	SAILORS CREEK BATTLEFIELD STATE…	STATE PARK
39-46D	7531	51	007	21570 FARMERS LN	JETERSVILLE	VA	23083	ROBINSON SIM E ETUX	P O BOX 86	23083	Amelia	91499	3	930200	9302	3670.5827	69200	21500	90700		1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	129.0631	138.0869	133.4699	R-1	1	PERSON	8131		0	0				EBENEZER CHURCH	CHRISTIAN_PLACE_OF_WORSHIP
33-6-14	10407	51	007	9400 FORESTDALE DR	AMELIA COURT HOUSE	VA	23002	HUMPHREY HARRY B III ETUX	9400 FORESTDALE DR	23002	Amelia	91799	5	930200	9302	11331.6691	250900	38000	288900	169225	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	76.5605	85.2174	80.6085	RR-3	3	PERSON		LOT 14 LOCUST DALE SEC 2	269	5820
21A-3-5	3453	51	007	17170 AMELIA ESTATES	AMELIA COURT HOUSE	VA	23002	CUNDIFF BRIAN D ETUX	17170 AMELIA ESTATES	23002	Amelia	91649	4	930102	9301.0200	11942.5580	228800	32900	261700	372900	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	99.2244	102.6337	101.7162	RR-3	2.2480	PERSON		AMELIA ESTATES	276	9184
22-33	8237	51	007	11187 WINTERHAM RD	AMELIA COURT HOUSE	VA	23002	SMITH JEREMY ETUX	11187 WINTERHAM RD	23002	Amelia	91649	4	930102	9301.0200	34409.0062	382400	37400	419800	459000	2	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	98.9182	109.6139	104.9870	RR-3	4.3290	PERSON		3.225 AC TO 22-33B	0	0
68-47F	1945	51	007	2391 RICHMOND RD	AMELIA COURT HOUSE	VA	23002	CLOSKY LAURA B ETAL	2391 RICHMOND RD	23002	Amelia	91799	5	930200	9302	36325.0831	190700	33700	224400	174000	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	83.3002	94.4721	87.5885	RP-5	7.7300	PERSON		PARCEL 5	154	812
68-56I	11649	51	007	3005 RICHMOND RD	AMELIA COURT HOUSE	VA	23002	WEAVER MICHAEL P TOD	3005 RICHMOND ROAD	23002	Amelia	91799	5	930200	9302	9822.4708	227400	27700	255100		1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	96.5175	100.1760	99.2596	RP-5	2.3550	PERSON		FR 68-56	279	8364
71-14C	11900	51	007	2081 MILL QUARTER RD	FORD	VA	23850	HUGHES JOHN A JR		23112	Amelia	91799	5	930200	9302	113955.9991	446100	82500	528600	94000	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	74.8886	87.0402	80.7085	RP-5	28	PERSON		PARCEL B	0	0
9-9D	4166	51	007	20721 GENITO RD	AMELIA COURT HOUSE	VA	23002	ZIMMERMANN MICHAEL	20721 GENITO RD	23002	Amelia	91349	2	930102	9301.0200	4058.2534	190900	23900	214800	348000	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	112.4368	116.3024	114.9905	A-5	1.0800	PERSON			279	7393
7-1	2827	51	007	14700 FOWLKES BRIDGE RD	AMELIA COURT HOUSE	VA	23002	YOGI JAMES W ETUX	14700 FOWLKES BRIDGE	23002	Amelia	91199	1	930102	9301.0200	78377.8418	260300	65900	326200	225000	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	110.6394	122.6368	117.5098	A-5	20.0100	PERSON			267	3243
18-44B	1303	51	007	22940 ROCKY FORD RD	JETERSVILLE	VA	23083	CLUNE III THOMAS E	1765 FREDERICKS HALL	23024	Amelia	91199	1	930102	9301.0200	8081.4771	25500	26300	51800	10000	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	129.1146	132.5455	131.0674	A-5	2	PERSON			276	7820
33B-1-18	8298	51	007	9870 MOREFIELD MEADOWS DR	AMELIA COURT HOUSE	VA	23002	LOFTIS DAVID R ETUX	9870 MOREFIELD MEADO	23002	Amelia	91649	4	930200	9302	23613.0767	267900	42300	310200	164000	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	84.6393	99.3320	93.9865	RR-3	5.8000	PERSON			244	650
44-82	3802	51	007	7331 MILITARY RD	AMELIA COURT HOUSE	VA	23002	TRUSTEES OF BETHIAH BAPTI		23002	Amelia	91799	5	930200	9302	10434.9246	172900		172900		1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	94.4072	99.0592	97.2388	RR-3	0	PERSON	8131		0	0				BETHIA BAPTIST CHURCH	CHRISTIAN_PLACE_OF_WORSHIP
9-21A	11445	51	007	13826 HAW BRANCH LN	AMELIA COURT HOUSE	VA	23002	CONNER EDWARD L JR	13826 HAW BRANCH LN	23002	Amelia	91349	2	930102	9301.0200	97891.1207	399500	110700	510200		2	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	80.9447	107.6199	92.2153	A-5	38.5180	PERSON		FR 9-21	276	9982
33-88D	3791	51	007	11411 LOCUST DALE LN	AMELIA COURT HOUSE	VA	23002	ROBSON CHRISTOPHER	11411 LOCUST DALE LN	23002	Amelia	91799	5	930200	9302	21374.5068	190300	39600	229900	322000	2	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	87.0636	90.4590	89.1463	RR-3	5	PERSON			0	0
59-42F	12217	51	007	4561 OAK GROVE LOOP	AMELIA COURT HOUSE	VA	23002	PATTERSON JOSHUA ETUX	4571 OAK GROVE LOOP	23002	Amelia	91799	5	930200	9302	12530.3006	5000	29900	34900		1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	89.1009	95.8566	93.2220	RP-5	3.0460	PERSON		FROM 59-42	0	0
55-4F	1339	51	007	6001 WEST CREEK RD	AMELIA COURT HOUSE	VA	23002	WARDEN CLAUDE A JR ETUX	5900 FLINN LN	23002	Amelia	91499	3	930200	9302	35979.2249	91000	57100	148100		1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	106.1105	115.2984	111.3162	RP-5	9.1820	PERSON		5.182 AC FROM 54-41	0	0
11-17E	1044	51	007	14200 GRUB HILL CHURCH RD	AMELIA COURT HOUSE	VA	23002	GRABHAM SCOTT W ETUX		23002	Amelia	91349	2	930102	9301.0200	25423.0719	568000	44500	612500	510000	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	73.8285	83.6007	78.9003	RP-5	7	PERSON		PARCEL A	275	5643
45-25	1978	51	007	10001 BEVILS BRIDGE RD	AMELIA COURT HOUSE	VA	23002	GOUGH DONNA Z	111 S WEST SHORE RD	27959	Amelia	91799	5	930200	9302	22750.2268	145100	40000	185100		1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	84.2613	88.4459	87.2052	RP-5	5.8700	PERSON		PARCEL A	225	339
56-38	912	51	007	14041 HORSESHOE LOOP	AMELIA COURT HOUSE	VA	23002	POSENAU REVOCABLE LIVING	14041 HORSESHOE LOOP	23002	Amelia	91499	3	930200	9302	163349.6622	362500	136200	498700		1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	88.6420	104.0364	99.1394	RP-5	39.3800	TRUST		COMBINED 56-39	267	1016
38-8A	1853	51	007	24731 ST JAMES RD	JETERSVILLE	VA	23083	WHITE SHIRLEY TOD	24731 ST JAMES RD	23083	Amelia	91199	1	930101	9301.0100	21896.6952	185900	33600	219500	273000	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	122.7185	130.9109	127.6338	A-5	5	PERSON			271	7586
70-7A	4590	51	007	2407 BURTON RD	AMELIA COURT HOUSE	VA	23002	GWALTNEY MICHAEL T ETUX	1489 STAGE COACH RD	23103	Amelia	91799	5	930200	9302	155133.7174	87100	95700	182800	21800	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	58.4921	81.9217	67.3781	RP-5	34.6090	PERSON			0	0
69-6C	10690	51	007	8901 ALLEN LN	AMELIA COURT HOUSE	VA	23002	TURNER THEODORE JOSEPH ET	26321 SELMA RD	23083	Amelia	91799	5	930200	9302	17529.6092	312900	34800	347700	18000	1	51007C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	86.1193	94.1955	90.9989	RP-5	5.1700	PERSON			271	1035