Saved query fb64a7868d80bd9f

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

36,614 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	numbldgs	numunits	yearbuilt	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	zoningcode	taxacres	ownertype	naicscode	placename	placetype
04040140	51	740	93 NICHOLSON ST	Portsmouth	VA	23702	LENNON ROBERT G & VERONICA S	4701 HAYWOOD DR	PORTSMOUTH	VA	23703	Portsmouth	95123	Portsmouth	212300	2123	451.7460	129420	50960	180380	1	1	1951	515529	2026-01-08	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…		2.3517	2.7465	2.5038	UR	0.1200	PERSON	52599	SPARTAN MONARCH INDUSTRIES	FINANCIAL_SERVICE
01430120	51	740	2430 GRAHAM ST	Portsmouth	VA	23704	TRINITY TEMPLE CHURCH OF AMERICA	2430 GRAHAM ST	PORTSMOUTH	VA	23704	Portsmouth	95123	Portsmouth	211800	2118	2588.9904	247580	44480	292060	1	1	1950	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.2926	3.8290	3.5142	UR-M	0.6080	NONPROFIT	81311	TRINITY TEMPLE CHURCH	CHRISTIAN_PLACE_OF_WORSHIP
00180860	51	740	725 LONDON ST	Portsmouth	VA	23704	SEJ ASSET MANAGEMENT & INVESTME…	1722 ROUTH ST 1000	DALLAS TX 752012506			Portsmouth	95123	Portsmouth	210900	2109	2590.4958	153950	706570	860520	1	1	1981	515529	2026-01-08	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…		1.9797	3.3268	2.7221	GMU	0.6400	PERSON	445131	7-ELEVEN	CONVENIENCE_STORE
04420840	51	740	6 CHOWAN DR	Portsmouth	VA	23701	MOONSCAPE PROPERTIES LLC	4 CROATAN TR	PORTSMOUTH	VA	23701	Portsmouth	95123	Portsmouth	212801	2128.0100	650.4309	91110	62500	153610	1	1	1941	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.5862	4.1547	3.8608	UR-M	0.1600	BUSINESS	5312
00690980	51	740	1513 MAPLE AV	Portsmouth	VA	23704	POLK PINEWILL 5 LLC	5353 PRINCESS ANNE ROAD E F	NORFOLK	VA	23502	Portsmouth	95123	Portsmouth	212000	2120	356.8497	137880	50000	187880	1	1	1910	515529	2026-01-08	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…		2.3103	2.6703	2.5362	UR-M	0.1000	BUSINESS	4911
03020170	51	740	3410 KING ST	Portsmouth	VA	23707	KIKA ENTERPRISES LLC	926 HIGH ST	PORTSMOUTH	VA	23704	Portsmouth	95123	Portsmouth	211500	2115	756.3347	95010	77330	172340	1	1	1940	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.3106	3.9605	3.5839	GMU	0.1900	BUSINESS	44121
04350040	51	740	40 BOLLING RD	Portsmouth	VA	23701	BOOK 1 LLC	440 MONTICELLO AV 1862	NORFOLK	VA	23510	Portsmouth	95123	Portsmouth	212900	2129	1119.0912	112980	81740	194720	1	1	1942	515529	2026-01-08	AE		8	0.3359	2.0599	1.1967	UR	0.2800	BUSINESS	51313
07800021	51	740	1 VACATION LN	Portsmouth	VA	23703	BELLOMY DAVID P & CAROL	1 VACATION LN	PORTSMOUTH	VA	23703	Portsmouth	95123	Portsmouth	213002	2130.0200	2837.7886	272430	83260	355690	1	1	2015	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		-0.4265	4.1149	2.8090	GR	0.7210	PERSON
00280010	51	740	101 LINDEN AV	Portsmouth	VA	23704	NOVAK DUSTIN MICHAEL & LASEK-NO…	101 LINDEN AV	PORTSMOUTH	VA	23704	Portsmouth	95123	Portsmouth	213200	2132	494.2315	351050	61540	412590	1	1	1900	515529	2026-01-08	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…		2.0083	2.6462	2.3713	HR	0.1100	PERSON
08770310	51	740	5812 HAWTHORNE LN	Portsmouth	VA	23703	GRIGGS WALTER S III & DAWNINE R	5812 HAWTHORNE LN	PORTSMOUTH	VA	23703	Portsmouth	95123	Portsmouth	213103	2131.0300	1739.9185	170760	99000	269760	1	1	1960	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		4.4075	5.1555	4.9086	GR	0.4300	PERSON
01210360	51	740	2217 PIEDMONT AV	Portsmouth	VA	23704	GOODMAN NAOMI P	1307 LAKEVIEW DR	PORTSMOUTH	VA	23701	Portsmouth	95123	Portsmouth	211800	2118	741.0009	97330	64500	161830	1	1	1922	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		2.9590	3.2815	3.1439	UR	0.1800	PERSON
06430370	51	740	208 PARK MANOR RD	Portsmouth	VA	23701	HALL DAVID A	208 PARK MANOR RD	PORTSMOUTH	VA	23701	Portsmouth	95123	Portsmouth	212900	2129	1022.8148	140460	79560	220020	1	1	1940	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.8551	4.3315	4.1057	UR	0.2600	PERSON
05040270	51	740	417 BILTMORE PL	Portsmouth	VA	23702	ANDERSON COTY	417 BILTMORE PL	PORTSMOUTH	VA	23702	Portsmouth	95123	Portsmouth	212600	2126	785.4153	275900	66000	341900	1	1	2020	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.0845	3.4957	3.3118	UR	0.1910	PERSON
05460410	51	740	912 DUCE ST	Portsmouth	VA	23701	JONES CHARLIE ELLIS WENDELL	912 DUCE ST	PORTSMOUTH	VA	23701	Portsmouth	95123	Portsmouth	212702	2127.0200	612.6799	168460	53630	222090	1	1	1963	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.9824	4.3691	4.2121	UR	0.1500	PERSON
01500390	51	740	633 MT VERNON AV	Portsmouth	VA	23707	LAURENT JUNIOR	633 MT VERNON AV	PORTSMOUTH	VA	23707	Portsmouth	95123	Portsmouth	210200	2102	520.5936	219120	61040	280160	1	1	1900	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		2.9707	3.3296	3.1725	HR	0.1300	PERSON
08900120	51	740	13 WINDY PINES CR	Portsmouth	VA	23703	SARNA MATTHEW & LERNER JULIA	13 WINDY PINES CR	PORTSMOUTH	VA	23703	Portsmouth	95123	Portsmouth	213104	2131.0400	1437.9578	253810	88200	342010	1	1	1987	515529	2026-01-08	AE		8	-0.3420	3.9502	1.5754	GR	0.2350	PERSON
01211030	51	740	2103 LANSING AV	Portsmouth	VA	23704	HARRELL ELISHA A & MARY F	945 FLINTFIELD CR	CHESAPEAKE	VA	23321	Portsmouth	95123	Portsmouth	211800	2118	696.6949	155460	63000	218460	1	1	1930	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		2.8238	3.3411	3.0666	UR	0.1700	PERSON
09020920	51	740	17 BLUE HERON PT	Portsmouth	VA	23703	JAMES SEAN M & GARDNER TRACY E	17 BLUE HERON PT	PORTSMOUTH	VA	23703	Portsmouth	95123	Portsmouth	213104	2131.0400	1688.4334	263940	139610	403550	1	1	2000	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		0.8735	4.7895	3.7183	GR	0.4320	PERSON
06490340	51	740	303 EDGEWOOD RD	Portsmouth	VA	23701	SHIVLEY ASHLEY & PIERCE	303 EDGEWOOD RD	PORTSMOUTH	VA	23701	Portsmouth	95123	Portsmouth	212900	2129	874.4960	203550	71760	275310	1	1	1951	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.4497	4.0737	3.9004	UR	0.2100	PERSON
03950070	51	740	23 GRAND ST	Portsmouth	VA	23701	RAWLS ALFRED III & LATASHA	23 GRAND ST	PORTSMOUTH	VA	23701	Portsmouth	95123	Portsmouth	211700	2117	555.0339	221940	59380	281320	1	1	1942	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.5324	3.8793	3.6513	UR-M	0.1400	PERSON
07590060	51	740	4636 WINSTON RD	Portsmouth	VA	23703	DENNIS CHAD N	4636 WINSTON RD	PORTSMOUTH	VA	23703	Portsmouth	95123	Portsmouth	213001	2130.0100	1935.8399	234320	110880	345200	1	1	1949	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.0051	4.1697	3.7694	GR	0.4900	PERSON
03650340	51	740	205 RIVERSIDE DR	Portsmouth	VA	23707	LOUGHERY HARRISON DAVID & JILL	205 RIVERSIDE DR	PORTSMOUTH	VA	23707	Portsmouth	95123	Portsmouth	210400	2104	924.8937	260230	93120	353350	1	1	1940	515529	2026-01-08	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…		1.9099	2.9023	2.6236	UR	0.2300	PERSON
06780720	51	740	6 COSBY CT	Portsmouth	VA	23701	LESLIE JANOI	6 COSBY CT	PORTSMOUTH	VA	23701	Portsmouth	95123	Portsmouth	212701	2127.0100	723.4666	207420	59130	266550	1	1	1977	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		4.3818	4.8428	4.6454	UR	0.1760	PERSON
06740260	51	740	8 JAMAL CT	Portsmouth	VA	23701	WRIGHT JERROID J	8 JAMAL CT	PORTSMOUTH	VA	23701	Portsmouth	95123	Portsmouth	212701	2127.0100	1117.1126	148600	68310	216910	1	1	1967	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		4.1830	4.7908	4.5654	UR	0.2900	PERSON
04610147	51	740	327 FORECASTLE ST	Portsmouth	VA	23702	TEAGUE GERHONDA ELIZABETH	327 FORECASTLE ST	PORTSMOUTH	VA	23704	Portsmouth	95123	Portsmouth	212400	2124	579.6270	268220	78000	346220	1	1	2022	515529	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		2.9503	3.3613	3.1808	UR-MPO	1	PERSON