Saved query 4ccdf1014021ebd9

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

7,887 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	naicscode	parceltype	accesstype	iucnclass	placename	placetype	taxdistrict
14559	16A2 A 11	51	159	179 MAIN STREET	WARSAW	VA	22572	Richmond	91571	3	040100	401	879.6154	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		39.1738	39.7632	39.3856	3231				WILLOW STITCH	PRINTING_SERVICE	Richmond County
16299	10-52	51	159	NEW ZION CEMETERY	WARSAW	VA	22572	Richmond	91871	5	040100	401	16710.2796	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		10.9896	23.6237	17.2118	8131				NEW ZION BAPTIST CHURCH	CHRISTIAN_PLACE_OF_WORSHIP	Richmond County
17018	23-112A	51	159			VA	22572	Richmond	91571	3	040100	401	116370.6487		51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		12.8646	31.9673	25.7428	3211	GOVT FEDERAL	CLOSED	V	RAPPAHANNOCK RIVER VALLEY NATIO…	CONSERVATION EASEMENT	Richmond County
0	ROW-25-HINSON RD	51	159	53 HINSON ROAD	WARSAW	VA	22572	Richmond	91421	2	040100	401	3143.2177		51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		30.6126	35.3654	33.1201	33637				MCA MOBILE DETAILING	AUTOMOTIVE_SERVICE	Richmond County
0	ROW-26-RICH NECK RD	51	159	136 RICH NECK ROAD	WARSAW	VA	22572	Richmond	91421	2	040200	402	5665.9898		51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		34.0580	37.9327	36.2441	6117				HAYNESVILLE CORR CTR UNIT #17	JAIL_OR_PRISON	Richmond County
25317	2A2-15	51	159	106 MALLARD DRIVE	WARSAW	VA	22572	Richmond	91871	5	040100	401	7831.3906	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		39.7895	47.1050	44.3270							Richmond County
24542	36-92A	51	159	3500 SHARPS RD	WARSAW	VA	22572	Richmond	91571	3	040100	401	29409.0836	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		7.8696	9.9038	8.5410							Richmond County
12679	24-39	51	159	7690 RICHMOND ROAD	WARSAW	VA	22572	Richmond	91421	2	040100	401	115195.1067	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		-0.1700	36.2408	17.6249							Richmond County
14075	16A3 1 16	51	159	31 WEST JEFFERSON AVENUE	WARSAW	VA	22572	Richmond	91571	3	040100	401	1342.0014	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		35.0648	38.8999	36.5187							Richmond County
20050	10-63C	51	159	6125 NEWLAND ROAD	WARSAW	VA	22572	Richmond	91871	5	040100	401	4520.5326	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		42.6089	45.7749	44.7286							Richmond County
11875	27-44	51	159	13740 RICHMOND ROAD	FARNHAM	VA	22460	Richmond	91721	4	040200	402	3684.5531	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		43.8981	44.9009	44.4072							Richmond County
26255	27-8	51	159	29 POND VIEW DRIVE	FARNHAM	VA	22460	Richmond	91421	2	040200	402	2799.5304	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		41.6640	45.7822	43.4853							Richmond County
11679	34-48	51	159	2586 QUINTON OAK LANE	FARNHAM	VA	22460	Richmond	91721	4	040200	402	12550.2734	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		22.8337	34.0383	27.5241							Richmond County
10990	32-55A	51	159	5917 HISTORY LAND HIGHWAY	FARNHAM	VA	22460	Richmond	91271	1	040100	401	3792.4854	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		31.4478	35.4361	33.6611							Richmond County
19289	16A2 3 11A	51	159	295 LAKESIDE DRIVE	WARSAW	VA	22572	Richmond	91571	3	040100	401	1592.1821	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		38.4816	39.9481	39.1239							Richmond County
18868	27-116	51	159	14776 RICHMOND ROAD	CALLAO	VA	22435	Richmond	91721	4	040200	402	4705.5267	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		36.2017	42.3884	40.6461							Richmond County
27488	16A5 1 15	51	159	99 MAPLE STREET	WARSAW	VA	22572	Richmond	91421	2	040100	401	6829.8562	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		39.9758	41.7180	41.0021							Richmond County
25652	31-14	51	159	460 THE HOOK ROAD	WARSAW	VA	22572	Richmond	91271	1	040100	401	24642.5435	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		13.7944	37.4482	29.6804							Richmond County
25465	16A5 2 41	51	159	15 MAPLE STREET	WARSAW	VA	22572	Richmond	91421	2	040100	401	1739.2729	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		37.8267	39.3526	38.6786							Richmond County
15707	31-15D	51	159	414 THE HOOK ROAD	WARSAW	VA	22572	Richmond	91271	1	040100	401	3605.0893	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		30.9429	36.1918	34.4693							Richmond County
19270	16A2 11 17	51	159	187 FREEDOM WAY	WARSAW	VA	22572	Richmond	91571	3	040100	401	2275.3737	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		39.1731	40.4887	39.9489							Richmond County
27660	24J 1 8	51	159	21 GRAND VIEW LANE	WARSAW	VA	22572	Richmond	91571	3	040100	401	329.0167	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		4.3229	4.9801	4.7039							Richmond County
12802	43-32	51	159	1925 HALES POINT ROAD	FARNHAM	VA	22460	Richmond	91271	1	040100	401	37602.9793	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.9369	7.2071	6.5846							Richmond County
11437	43-70F	51	159	4185 HALES POINT ROAD	FARNHAM	VA	22460	Richmond	91721	4	040100	401	1438.2304	1	51159C	2026-01-08	AE		6	-0.3000	1.8140	0.9669							Richmond County
20054	36 6 3	51	159	57 SUGGETTS POINT ROAD	WARSAW	VA	22572	Richmond	91571	3	040100	401	5666.9293	1	51159C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		8.6750	9.1236	8.8266							Richmond County