Saved query 5535a5c6e0fd65ca

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

10,354 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	naicscode	parceltype	accesstype	placename	placetype	taxdistrict
09400	118225-36350-1060970	51	670	204 OXFORD ROAD	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820400	8204	60788.8372	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	11.6608	25.6824	21.0652	712190	GOVT LOCAL	OPEN	ATWATER PARK	PARK	Hopewell City
03369	118325-36325-240175	51	670	417 SOUTH 15TH AVENUE	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820300	8203	5248.6306	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	20.8214	22.6603	21.8431	444			HERETICK FEED AND SEED COMPANY	HARDWARE_HOME_AND_GARDEN_STORE	Hopewell City
04200	118325-36350-301590	51	670	300 NORTH 6TH AVENUE	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820300	8203	1909.5441	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	14.7920	15.5427	15.2346	445			RANDOLPH MARKET	FOOD_AND_BEVERAGE_STORE	Hopewell City
04576	118325-36275-330050	51	670	1202 ARLINGTON ROAD	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820700	8207	635.5788	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	12.8100	17.9775	15.1970	722511			LILLIE MAE'S KITCHEN	RESTAURANT	Hopewell City
08989	118225-36200-960045	51	670	4701 WESTERN STREET	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820600	8206	10318.6177	1	510080	2026-01-08	AE		20.7295	22.6478	21.6597	3372			HOPEWELL MOOSE FAMILY CENTER 14…	CORPORATE_OR_BUSINESS_OFFICE	Hopewell City
05915	118375-36325-480400	51	670	1205 EDWARD BLAND COURT	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820300	8203	49357.0772	121	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	12.1164	14.9349	13.8601	4595			THE HOPEWELL DISCOUNT SHOP		Hopewell City
07345	118325-36275-750450	51	670	2403 RALEIGH STREET	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820700	8207	570.5876	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	17.6472	19.3104	18.4667						Hopewell City
09264	118250-36300-1060252	51	670	3523 JACKSON FARM ROAD	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820400	8204	4492.6168	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	18.5610	23.4545	21.8705						Hopewell City
11694	118300-36350-880036	51	670	2124 WEST POYTHRESS STREET	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820500	8205	2801.0304	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	19.8309	24.6933	22.7156						Hopewell City
02654	118275-36300-141300	51	670	319 HOKE AVENUE	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820500	8205	439.5277	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	18.7447	19.9911	19.4227						Hopewell City
06203	118275-36350-540240	51	670	2713 WALNUT STREET	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820400	8204	1497.0492	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	17.3661	22.4538	19.9936						Hopewell City
01156	118375-36375-10765	51	670	401 SPRUANCE STREET	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820100	8201	973.7308	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	12.8485	13.9585	13.4982						Hopewell City
06925	118250-36325-700130	51	670	108 SOUTH COLONIAL DRIVE	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820400	8204	2380.2339	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	13.1870	18.2979	16.4049						Hopewell City
11439	118250-36275-2910025	51	670	3513 COBBLESTONE TERRACE	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820400	8204	1050.0347	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	18.7659	20.7011	20.2099						Hopewell City
08061	118275-36300-850130	51	670	502 JEFFERSON AVENUE	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820500	8205	1850.1028	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	17.3966	20.4879	18.7692						Hopewell City
02914	118300-36300-142640	51	670	555 HILL AVENUE	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820500	8205	634.3006	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	13.4562	13.9300	13.7296						Hopewell City
09259	118225-36325-1060230	51	670	209 THRIFT LANE	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820400	8204	1673.5016	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	19.8843	22.7085	21.5783						Hopewell City
02140	118300-36325-131295	51	670	2207 GORDON STREET	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820500	8205	690.9766	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	19.9557	22.2075	21.3217						Hopewell City
02072	118300-36325-130900	51	670	2300 LEE STREET	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820500	8205	1397.4352	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	20.2512	21.1798	20.7663						Hopewell City
07046	118325-36275-730360	51	670	2113 FREEMAN STREET	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820700	8207	589.6978	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	11.5541	12.5510	12.0554						Hopewell City
11450	118250-36275-2910080	51	670	116 COBBLESTONE DRIVE	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820400	8204	856.5499	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	18.7789	19.7403	19.1927						Hopewell City
11702	118200-36350-2280015	51	670	1600 CAMERON'S LANDING BOULEVARD	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820400	8204	1122.1633	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	23.5791	26.0526	25.4799						Hopewell City
01164	118375-36375-10805	51	670	410 SPRUANCE STREET	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820100	8201	546.8868	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	12.1242	12.8225	12.5637						Hopewell City
11722	118200-36350-2280115	51	670	1607 CAMERON'S LANDING BOULEVARD	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820400	8204	1115.2625	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	23.2806	25.9866	25.3245						Hopewell City
04430	118300-36350-310885	51	670	333 BYRD STREET	HOPEWELL	VA	23860	Hopewell	93915	Hopewell	820400	8204	816.8347	1	510080	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	14.9296	16.5900	15.8876						Hopewell City