Saved query 1e65a3222958623c

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

9,257 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	ownertype	naicscode	parceltype	accesstype	iucnclass	placename	placetype
1-A-6	9209	51	043	256 QUEENSHIP LN	BERRYVILLE	VA	22611	WALLACE BENJAMIN BRUCE & LESLIE	96 GARFIELD DR	INWOOD	WV	25428	Clarke	95495	Russell	010102	101.0200	131594.3408	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	163.2489	176.5299	169.8155	32.9596	PERSON	3211	GOVT LOCAL	CLOSED	OTHER	CLARKE COUNTY EASEMENT	CONSERVATION EASEMENT
14A3-A-28	7479	51	043	612 E MAIN ST	BERRYVILLE	VA	22611	VALLEY VENTURES FUND 1 LLC	606 E MAIN ST	BERRYVILLE	VA	22611	Clarke	90544	Buckmarsh	010101	101.0100	21202.5132	3	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	170.7779	175.9629	173.0983	4.9800	NONPROFIT	4442				TRUE VALUE	HARDWARE_HOME_AND_GARDEN_STORE
26-A-122A	8044	51	043	88 LOST BOYS LN	BLUEMONT	VA	20135	CARNE STEVEN A & ALLEGRA F	88 LOST BOYS LN	BLUEMONT	VA	20135	Clarke	94703	Millwood	010300	103	10116.0177	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	422.3822	432.1058	427.1495	2.5000	PERSON	111				EDGEGROVE FARM LLC	FARM
30A-A-57	6165	51	043	2049 MILLWOOD RD	BOYCE	VA	22620	LOCKE AND COMPANY LLC	BOX 304	MILLWOOD	VA	22646	Clarke	94703	Millwood	010200	102	1489.8744	2	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	155.8269	162.0558	158.4814	0	BUSINESS	712110				DUVALL DESIGNS GALLERY	ART_GALLERY
8-A-24B	7802	51	043	1236 KIMBLE RD	BERRYVILLE	VA	22611	RODE MITCHELL K & ALISON R TTE	1236 KIMBLE RD	BERRYVILLE	VA	22611	Clarke	95495	Russell	010102	101.0200	56452.1287	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	192.6230	198.0799	194.4146	13.7900	PERSON	81291				CLARKE EQUINE WELLNESS AND PERF…	ANIMAL_OR_PET_SERVICE
15-A-59	2451	51	043	2626 SHEPHERDS MILL RD	BERRYVILLE	VA	22611	BIGHOUSE JO ELLEN	2626 SHEPHERDS MILL RD	BERRYVILLE	VA	22611	Clarke	90544	Buckmarsh	010102	101.0200	14207.9777	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	152.8419	158.7859	154.9282	3.1800	PERSON	111				SERENITY FARM VIRGINIA	FARM
21-A-40	4613	51	043	500 HUNTINGDON LN	BOYCE	VA	22620	SCHUTTE C H INC	P O BOX 5	BOYCE	VA	22620	Clarke	96367	White Post	010200	102	746141.6025	2	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				180	BUSINESS	33631	GOVT STATE	CLOSED	OTHER	HUNTINGDON (BOYCE, VIRGINIA)	HISTORIC_SITE
14A2-A-84	1541	51	043	13 LIBERTY ST	BERRYVILLE	VA	22611	ST LUKE BAPTIST CHURCH	PO BOX 261	BERRYVILLE	VA	22611	Clarke	90256	Berryville	010101	101.0100	1202.5377	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	179.2980	182.3533	180.7355	0	NONPROFIT	4922
23-A-8B	5179	51	043	1531 SPRINGSBURY RD	BERRYVILLE	VA	22611	BLUE SKY TOWERS LLC	PO BOX 723597	ATLANTA	GA	31139	Clarke	90544	Buckmarsh	010102	101.0200	42873.3726	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	149.7839	167.4819	161.6920	9.9700	BUSINESS	2361
14A3-A-5	1909	51	043	340 FIRST ST	BERRYVILLE	VA	22611	VALLEY VENTURES FUND 1 LLC	606 E MAIN ST	BERRYVILLE	VA	22611	Clarke	90544	Buckmarsh	010101	101.0100	13426.8381	2	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	165.5429	170.7149	167.9662	3.0964	NONPROFIT	3391
14A7-7-186A	8019	51	043	113 JACKSON DR	BERRYVILLE	VA	22611	FORNES MARK N & JEANNE M	12922 VAUGHN ST	SPRINGVILLE	NY	14141	Clarke	90256	Berryville	010101	101.0100	1396.2408	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	187.7409	189.9340	188.7938	0	PERSON
24-A-33	5259	51	043	2018 CHILLY HOLLOW RD	BERRYVILLE	VA	22611	GIACOMANGELI SANDRO	7061 ELDRIDGE ST	SAN DIEGO	CA	92120	Clarke	90544	Buckmarsh	010102	101.0200	20841.8587	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	121.0613	157.2469	139.0449	5.2200	PERSON
40-A-1	7309	51	043	311 HIDDEN HOLLOW LN	BOYCE	VA	22620	LACEY PETER B & MARGARET C	15436 LORD FAIRFAX HWY	WHITE POST	VA	22663	Clarke	94703	Millwood	010300	103	163282.0162	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	250.0819	329.6029	283.9703	40.4099	PERSON
26-A-85	5559	51	043	616 PINE GROVE RD	BLUEMONT	VA	20135	LERTORA KAITLIN & CALEB LANTZ	616 PINE GROVE LN	BLUEMONT	VA	20135	Clarke	94703	Millwood	010300	103	3961.0512	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	207.1740	215.5817	212.7844	1	PERSON
12-A-23	919	51	043	1854 SALEM CHURCH RD	BOYCE	VA	22620	COPENHAVER MARY	P O BOX 30	BOYCE	VA	22620	Clarke	96367	White Post	010200	102	28141.5593	2	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	190.5879	199.4850	194.0733	5	PERSON
15-3-8	2505	51	043	4733 HARRY BYRD HWY	BERRYVILLE	VA	22611	ANDERSON ELMER C & M ELEANOR	4733 HARRY BYRD HIGHWAY	BERRYVILLE	VA	22611	Clarke	90544	Buckmarsh	010102	101.0200	21033.7962	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	153.3886	162.5910	159.3928	5.0084	PERSON
23-A-32	5149	51	043	2544 SPRINGSBURY RD	BERRYVILLE	VA	22611	LEVI GEORGE G TRUSTEE	P O BOX 366	BERRYVILLE	VA	22611	Clarke	94703	Millwood	010102	101.0200	3101.8729	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	157.0650	166.8831	161.7335	0	TRUST
30-A-42C	8050	51	043	155 SYCAMORE LN	BOYCE	VA	22620	PILLION IONA F	P O BOX 134	MILLWOOD	VA	22646	Clarke	96367	White Post	010200	102	18457.6909	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	150.1239	162.2180	153.5756	4.6300	PERSON
14A7-3-55	7869	51	043	308 ASHBY CT	BERRYVILLE	VA	22611	ST CLAIR MATTHEW J & DEBORAH L	308 ASHBY COURT	BERRYVILLE	VA	22611	Clarke	90256	Berryville	010101	101.0100	1403.5878	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	189.3619	192.0399	190.4649	0	PERSON
14A8-3-85	8535	51	043	136 HERMITAGE BLVD	BERRYVILLE	VA	22611	HOUCK JOAN P & LAURIE R TRUSTEES	136 HERMITAGE BLVD	BERRYVILLE	VA	22611	Clarke	90256	Berryville	010101	101.0100	1496.4867	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	188.4632	191.2429	190.1870	0	PERSON
7-A-43	410	51	043	130 TRIPLE J RD	BERRYVILLE	VA	22611	MELECIO JOSE R	114 FORT EVANS RD NE	LEESBURG	VA	20176	Clarke	95495	Russell	010102	101.0200	3924.5490	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	184.9720	188.5850	186.4675	0	PERSON
15A-2-C-7	2540	51	043	184 CLARKE LN	BERRYVILLE	VA	22611	COLE ANGELA V & ROBERT A	184 CLARKE LN	BERRYVILLE	VA	22611	Clarke	90544	Buckmarsh	010102	101.0200	3162.2801	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	172.4160	174.2590	173.3834	0	PERSON
14A8-3-107	8557	51	043	117 HERMITAGE BLVD	BERRYVILLE	VA	22611	GRAY-IRWIN PATRICIA L & EDWARD …	117 HERMITAGE BLVD	BERRYVILLE	VA	22611	Clarke	90256	Berryville	010101	101.0100	1437.5392	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	187.2389	189.7219	188.4390	0	PERSON
22-1-11	5057	51	043	405 MILL LN	BOYCE	VA	22620	HEIDELBERGER TODD W TTE	405 MILL LN	BOYCE	VA	22620	Clarke	94703	Millwood	010200	102	23567.1368	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	154.3930	175.8009	164.2110	5.0199	PERSON
14A3-A-31D	8216	51	043	11 BATTLETOWN DR	BERRYVILLE	VA	22611	ZINMAN-HILLERSON ZACHARIAH &	HILLERSON FAMILY TRUST	BERRYVILLE	VA	22611	Clarke	90544	Buckmarsh	010101	101.0100	1257.3292	1	51043C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	170.0235	171.7980	171.0604	0	PERSON