Saved query 91eac2c3f4b4cb99

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

45,530 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	staticbfe	elevmin	elevmax	elevavg	usecode	zoningcode	taxacres	ownertype	naicscode	placename	placetype	taxdistrict
34 30K	150242000	51	800	117 PLOVER DR	SUFFOLK	VA	23434	COLD STORAGE LANDCO LLC	9211 FORREST HILL AVE SUITE 104	RICHMOND	VA	23235	Suffolk	95987	Suffolk	075701	757.0100	19605.2168	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		18.5081	20.8386	20.1225	NON	B-2	4.7500	BUSINESS	493120	VIRGINIA COLD STORAGE WEST	STORAGE_FACILITY	SUFFOLK
35C 15 12 12A	051055000	51	800	411 BEN ST	SUFFOLK	VA	23434	SUFFOLK REAL ESTATE INVESTMENTS…	415 MARKET ST	SUFFOLK	VA	23434	Suffolk	95987	Suffolk	065100	651	679.1293	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.3394	6.6013	6.2626	VAC	RM	0.1400	BUSINESS	531320			SUFFOLK
35C 26 7 8	050925900	51	800	2129 FLORIDA AVE	SUFFOLK	VA	23434	H EURE PROPERTIES INC	424 MARKET STREET	SUFFOLK	VA	23434	Suffolk	95987	Suffolk	065100	651	707.1635	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		7.4718	7.8658	7.6266	RES	RM	0.0900	BUSINESS	5312			SUFFOLK
35C 22 40	051211000	51	800	2146 OREGON AVE	SUFFOLK	VA	23434	CASTLES & COTTAGES CONSTRUCTION…	1850 PIEDMONT AVE	PORTSMOUTH	VA	23704	Suffolk	95987	Suffolk	065100	651	373.8795	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.5373	6.1505	5.8311	VAC	RM	0.0900	BUSINESS	2379			SUFFOLK
35H 3 D 27 28	053020000	51	800	518 WEKIVA AVE	SUFFOLK	VA	23434	GREATR FRST BAP CH ORLANDO INC	600 FACTORY ST	SUFFOLK	VA	23434	Suffolk	95987	Suffolk	065500	655	821.2308	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		12.2781	13.0754	12.7901	VAC	RM	0.2000	BUSINESS	23831			SUFFOLK
13A PATILLO L	301396000	51	800	4073 PUGHSVILLE RD	SUFFOLK	VA	23435	SANDSTONE HOLDINGS LLC	2228 W GREAT NECK RD #204	VIRGINIA BEACH	VA	23451	Suffolk	95987	Suffolk	075206	752.0599	1257.5142	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.8342	6.9663	6.4377	RES	RM	0.3700	BUSINESS	212321			SUFFOLK
13C 4C 484B	304266800	51	800	6025 BRADFORD DR	SUFFOLK	VA	23435	NEW CEDAR LLC	2849 E POINT DR	CHESAPEAKE	VA	23321	Suffolk	95987	Suffolk	075103	751.0300	459.0051	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.6988	6.2128	6.0175	RES	RM	1	BUSINESS	3212			SUFFOLK
13C 4B 431	304238500	51	800	4644 HARDY DR	SUFFOLK	VA	23435	COLLEGE SQUARE INVESTMENTS LLC	P O BOX 64786	VIRGINIA BEACH	VA	23464	Suffolk	95987	Suffolk	075103	751.0300	874.9962	3	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.0503	6.0159	5.6235	NON	RM	1	BUSINESS	6112			SUFFOLK
10D 6 6	250716800	51	800	KINGS HWY		VA	23432	EL-MAHDI ANAS M & NANCY W TR	1685 E LEWIS LN	BOISE	ID	83712	Suffolk	95987	Suffolk	075302	753.0200	25923.8206		510156	2026-01-08	AE		11	-0.6999	4.8120	1.9125	VAC	RE	5.5599	TRUST	2373	KINGS HIGHWAY BRIDGE	BRIDGE	SUFFOLK
4A 2 40	251851000	51	800	8369 CRITTENDEN RD	SUFFOLK	VA	23436	AB HOMES LLC	1024 CENTERBROOKE LN STE F#116	SUFFOLK	VA	23434	Suffolk	95987	Suffolk	075301	753.0100	653.5053	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		6.6134	7.2182	7.0525	RES	VC	1	BUSINESS	2361			SUFFOLK
64A 72	101153500	51	800	6147 WHALEYVILLE BLVD	SUFFOLK	VA	23438	SHIBUI NI FARM LLC	6145 WHALEYVILLE BL	SUFFOLK	VA	23438	Suffolk	95987	Suffolk	075801	758.0100	27857.3635	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		21.6342	23.5401	22.3621	RES	VC	6.6500	BUSINESS	11111			SUFFOLK
25G 5B 232	253326200	51	800	115 NOTTINGHAM BLVD	SUFFOLK	VA	23434	VMAN LLC	P O BOX 10475	VIRGINIA BEACH	VA	23450	Suffolk	95987	Suffolk	075406	754.0599	1368.1812	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		10.9010	15.3236	13.4934	RES	PD	1	BUSINESS	3369			SUFFOLK
13C 4B 468	304242300	51	800	6056 BROOKWOOD DR	SUFFOLK	VA	23435	TREY ESTATES LLC	P O BOX 865	NORFOLK	VA	23510	Suffolk	95987	Suffolk	075103	751.0300	876.6588	3	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.3209	6.1634	5.9287	NON	RM	1	BUSINESS	5312			SUFFOLK
33 46	252817000	51	800	LAKE KILBY RD	SUFFOLK	VA	23434	PITCHKETTLE LAND LLC	2404 POTTERS RD	VIRGINIA BEACH	VA	23454	Suffolk	95987	Suffolk	075404	754.0400	177790.4084	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		9.5730	17.0807	15.7010	NON	RE	43.8600	BUSINESS	4871			SUFFOLK
25E 3A 10	253247300	51	800	219 WIDGEON CT	SUFFOLK	VA	23434	JARRELL JOHNSON	219 WIDGEON CT	SUFFOLK	VA	23434	Suffolk	95987	Suffolk	075402	754.0200	1445.0695	1	510156	2026-01-08	AE		10	0.9858	4.7086	3.2318	RES	RC	1	PERSON				SUFFOLK
24 28	252503500	51	800	1748 KINGS FORK RD	SUFFOLK	VA	23434	ESMAILI HAYDEH & HOSSAIN	1680 WESTOVER RD	NORTH VANCOUVER	BC	V7J 1X6 CA	Suffolk	95987	Suffolk	075405	754.0500	246664.0367	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		16.8386	21.7030	18.6922	AG	A	50.6700	PERSON				SUFFOLK
24 14G	250684000	51	800	2980 PROVIDENCE RD	SUFFOLK	VA	23434	KISER NANCY COMER	2980 PROVIDENCE ROAD	SUFFOLK	VA	23434	Suffolk	95987	Suffolk	075405	754.0500	12902.0841	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		18.5088	20.8436	19.6000	RES	RE	4.1000	PERSON				SUFFOLK
23A 7	252018000	51	800	3300 ARCHERS MILL RD	SUFFOLK	VA	23434	GISH TRINA K	3300 ARCHERS MILL RD	SUFFOLK	VA	23434	Suffolk	95987	Suffolk	075405	754.0500	1689.0647	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		21.2614	21.8119	21.6295	RES	A	0.3900	PERSON				SUFFOLK
25B 2 A 3	251788050	51	800	99 NORTHGATE LN	SUFFOLK	VA	23434	ALLEN PATRICIA A & HERBERT III	99 NORTHGATE LANE	SUFFOLK	VA	23434	Suffolk	95987	Suffolk	075401	754.0100	2066.9957	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		9.8561	10.7870	10.5224	RES	RLM	0.5200	PERSON				SUFFOLK
26I 3 21	253410300	51	800	310 FESTIVAL CT	SUFFOLK	VA	23434	CULBERTSON DAPHNE D	310 FESTIVAL CT	SUFFOLK	VA	23434	Suffolk	95987	Suffolk	075402	754.0200	743.3563	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.4858	6.2974	5.9483	RES	RM	1	PERSON				SUFFOLK
13F 1 58	304982000	51	800	413 CALVIN ST	SUFFOLK	VA	23435	GLASGOW ROBERT B IV & JANE E F	413 CALVIN ST	SUFFOLK	VA	23435	Suffolk	95987	Suffolk	075205	752.0500	662.6378	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		6.1797	7.0914	6.8298	RES	RL	1	PERSON				SUFFOLK
10 31 3	253139900	51	800	119 BROWN LN	SUFFOLK	VA	23432	MICHAEL RODGERS SR TR	129 ROBIN LN	SUFFOLK	VA	23434	Suffolk	95987	Suffolk	075302	753.0200	11862.9485	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.5623	13.1731	11.7515	RES	RE	3	TRUST				SUFFOLK
12 23 207	306004925	51	800	109 ZUELLA CT	SUFFOLK	VA	23435	YOUNG, CURTIS AUNDRA & SHARON L	109 ZUELLA CT	SUFFOLK	VA	23435	Suffolk	95987	Suffolk	075202	752.0200	1062.6265	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		6.1174	6.3858	6.2949	RES	RR	1	PERSON				SUFFOLK
33 37X 1 2A	251351000	51	800	2684 LAKE COHOON RD	SUFFOLK	VA	23434	BINGHAM, DONOVAN	2684 LAKE COHOON RD	SUFFOLK	VA	23434	Suffolk	95987	Suffolk	075404	754.0400	2863.8496	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		18.2234	19.0965	18.7480	RES	RE	0.6899	PERSON				SUFFOLK
66 5G	053462900	51	800	3757 CAROLINA RD	SUFFOLK	VA	23434	BROWN, CLEVELAND & CRYSTAL D	3757 CAROLINA RD	SUFFOLK	VA	23434	Suffolk	95987	Suffolk	075602	756.0200	16900.8164	1	510156	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		17.2065	18.4053	17.9850	RES	A	5	PERSON				SUFFOLK