Saved query e1c044fa8d053550

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

22,120 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	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	zoningcode	taxacres	ownertype	naicscode	parceltype	accesstype	iucnclass	placename	placetype
34-01-104	51	093	15185 CARROLLTON BOULEVARD	CARROLLTON	VA	23314	LATIMER TRAVIS B & WANDA L /	15185 CARROLLTON BLVD	CARROLLTON	VA	23314	Isle of Wight	94839	Newport	280107	2801.0700	13125.1711	465000	480000	945000	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		1.5941	7.1047	5.2717	GC	3.2000	PERSON	8111				TRAVIS' AUTO REPAIR	AUTOMOTIVE_SERVICE
69-01-045A	51	093	1550 CARRSVILLE HIGHWAY	FRANKLIN	VA	23851	PARRISH TIMOTHY B & PARRISH MAR…	20385 GOVENOR DARDEN RD	COURTLAND	VA	23837	Isle of Wight	90616	Carrsville	280400	2804	8908.4475	209300	88000	297300	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.6985	8.0525	7.3624	GI	2.2000	TRUST	6216				AIR MECHANIX	HOME_SERVICE
35-01-001	51	093	12527 CARROLLTON BOULEVARD	CARROLLTON	VA	23314	COMM OF VIRGINIA COMMISSION /OF…	12527 CARROLLTON BLVD	CARROLLTON	VA	23314	Isle of Wight	94839	Newport	280107	2801.0700	4850443.7946	87700	4116500	4204200	1	1	51093C	2026-01-08	AE		9				RAC	1236.5400	UNDETERMINED	4871	GOVT STATE	RESTRICTED	V	RAGGED ISLAND WILDLIFE MANAGEME…	RECREATIONAL_TRAIL_OR_PATH
21A-01-184A9	51	093	248 JAMES STREET	SMITHFIELD	VA	23430	JVC LLC /	1807 S CHURCH ST STE 200A	SMITHFIELD	VA	23430	Isle of Wight	93839	Hardy	280105	2801.0500	396.8862		40000	40000	1		51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		10.9108	11.1756	11.0569	SMITH: DN-R	0.1000	BUSINESS	72121	GOVT LOCAL	OPEN		RIVERVIEW PARK	LOCAL PARK
34D-01-128	51	093	4 LITTLE HAMPTON LANE	CARROLLTON	VA	23314	SELL JOSEPH & JULIE /	4 LITTLE HAMPTON LN	CARROLLTON	VA	23314	Isle of Wight	94839	Newport	280107	2801.0700	2233.9611	274500	65000	339500	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		4.0122	4.9302	4.7049	SR	0.5500	BUSINESS	2212
54B-01-151	51	093	19 CHURCH STREET BLDG A	WINDSOR	VA	23487	TWIN INVESTMENTS LLC /	P O BOX 289	WINDSOR	VA	23487	Isle of Wight	96431	Windsor	280300	2803	2235.1640	195300	82500	277800	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		23.1798	24.4148	24.0718	WINDSOR: HDR	0	BUSINESS	52591
14-02-037B	51	093	1 MONETTE PARKWAY	SMITHFIELD	VA	23430	ACCELERATED PROPERTIES LLC /	39 MONETTE PARKWAY	SMITHFIELD	VA	23430	Isle of Wight	95727	Smithfield	280101	2801.0100	5935.1195	585200	250400	835600	1	1	51093C	2026-01-08	AE		9	-0.5899	3.2425	0.9221	RAC	5.8510	BUSINESS	5312
21A-06-A012	51	093	200 WINDSOR AVENUE	SMITHFIELD	VA	23430	AL PROPERTY MANAGEMENT LLC /	P O BOX 103	CARROLLTON	VA	23314	Isle of Wight	93839	Hardy	280105	2801.0500	557.7083	87200	30000	117200	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		9.9785	10.2708	10.1148	SMITH: DN-R	0	BUSINESS	53131
21G-02-017A	51	093	304 CATHEDRAL STREET	SMITHFIELD	VA	23430	SOWERS JOHN & SPEIRS KATHERINE …	304 CATHEDRAL ST	SMITHFIELD	VA	23430	Isle of Wight	95727	Smithfield	280104	2801.0400	548.3854	344200	65000	409200	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		11.7113	12.4051	12.2509	SMITH: MF-R	0.1356	TRUST
34G-02-016	51	093	100 LAURIE COURT	CARROLLTON	VA	23314	KEESEE THOMAS P III /	100 LAURIE CT	CARROLLTON	VA	23314	Isle of Wight	94839	Newport	280107	2801.0700	1705.1791	216800	60000	276800	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.4910	6.7436	6.4930	SR	0.4100	PERSON
31-01-027	51	093	16147 CARROLL BRIDGE ROAD	SMITHFIELD	VA	23430	EDWARDS SHIRLEY J & RAYMOND L /	15335 BOWLING GREEN ROAD	WINDSOR	VA	23487	Isle of Wight	93839	Hardy	280200	2802	486.6512	99000	40000	139000	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		14.8920	15.7716	15.3339	RAC	0	PERSON
32-01-075A165	51	093	134 ASBURY WAY	SMITHFIELD	VA	23430	ADAMS ALICE OWEN /	134 ASBURY WAY	SMITHFIELD	VA	23430	Isle of Wight	96431	Windsor	280105	2801.0500	824.7360	315700	85000	400700	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		15.1108	16.9619	15.9992	PD-MX	0.1980	PERSON
53-01-086A	51	093	9404 WILLIE ROBERTS ROAD	WINDSOR	VA	23487	BLOW RONNIE W & EVELYN C /	9404 WILLIE ROBERTS RD	WINDSOR	VA	23487	Isle of Wight	96431	Windsor	280300	2803	4101.8792	238200	40000	278200	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		25.9048	26.5800	26.2431	WINDSOR: R-1	1.0100	PERSON
42-01-023	51	093	17397 RIDDICK ROAD	SMITHFIELD	VA	23430	SANCHEZ FABIAN /	17397 RIDDICK RD	SMITHFIELD	VA	23430	Isle of Wight	96431	Windsor	280200	2802	8337.3270	160600	60100	220700	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		6.6182	7.8776	7.1195	RAC	2.0099	PERSON
21E-02-112	51	093	104 AYRSHIRE LOOP	SMITHFIELD	VA	23430	COLLINS DONALD S & COLLINS DEBO…	104 AYRSHIRE LOOP	SMITHFIELD	VA	23430	Isle of Wight	95727	Smithfield	280105	2801.0500	802.7169	404000	95000	499000	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		9.9534	10.3952	10.2051	SMITH: S-R	0.1980	PERSON
46A-01-023	51	093	20307 SHADY POND LANE	ZUNI	VA	23898	JANAS ARTHUR J & LAURA C /	20307 SHADY POND LANE	ZUNI	VA	23898	Isle of Wight	90616	Carrsville	280300	2803	21410.0883	364900	70900	435800	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		22.9936	25.6329	24.7474	RAC	5.4200	PERSON
22H-03-015	51	093	8 WIDGEON COURT	SMITHFIELD	VA	23430	BASHAM CLYDE L JR & ANTOINETTE …	8 WIDGEON COURT	SMITHFIELD	VA	23430	Isle of Wight	95727	Smithfield	280104	2801.0400	3214.5717	412000	50000	462000	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		2.7627	7.9320	5.6944	SMITH: N-R	0.7800	PERSON
48-04-002	51	093	21347 ORBIT ROAD	WINDSOR	VA	23487	PITTMAN WATSON & MILDRED F /	21347 ORBIT RD	WINDSOR	VA	23487	Isle of Wight	96431	Windsor	280300	2803	3700.6409	103200	45000	148200	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		23.6613	24.6783	23.9059	RAC	0.9000	PERSON
22R-01-059	51	093	120 WELLINGTON CIRCLE	SMITHFIELD	VA	23430	KENNEDY AARON & GARLITA /	120 WELLINGTON CIR	SMITHFIELD	VA	23430	Isle of Wight	95727	Smithfield	280106	2801.0600	1310.4908	435000	75000	510000	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		7.1110	8.4640	7.7147	SMITH: S-R	0.3200	PERSON
21-01-048A	51	093	12487 COURTHOUSE HIGHWAY	SMITHFIELD	VA	23430	EDWARDS VERNON RAY & LINDA R /	P O BOX 21	SMITHFIELD	VA	23431	Isle of Wight	93839	Hardy	280105	2801.0500	3293.5532	165800	40000	205800	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		20.3091	22.9200	21.2681	SMITH: C-C	0.7300	PERSON
50-01-042	51	093	0	0	VA	23487	PITTMAN CHARLIE EST /C/O PITTMA…	20100 CHERRY GROVE RD	SMITHFIELD	VA	23430	Isle of Wight	96431	Windsor	280200	2802	36075.4855	8000	48500	56500	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		21.9366	24.4753	23.5976	RAC	7.5000	PERSON
21A-16-023	51	093	325 JORDAN DRIVE	SMITHFIELD	VA	23430	WOODARD ELIZABETH BARHAM TRUSTE…	325 JORDAN DRIVE	SMITHFIELD	VA	23430	Isle of Wight	95727	Smithfield	280104	2801.0400	1043.3299	175100	50000	225100	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		9.9027	10.5137	10.2677	SMITH: N-R	0	TRUST
54-13-048	51	093	24317 JOHN HENRY STREET	WINDSOR	VA	23487	WARREN WILSON L & GOLDIE C /	24317 JOHN HENRY ST	WINDSOR	VA	23487	Isle of Wight	96431	Windsor	280300	2803	1563.0237	335000	50000	385000	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		20.9420	22.7918	22.0583	WIND: MHP	0.3900	PERSON
32-01-075A307	51	093	157 WILLIAMSON PARK LANE	SMITHFIELD	VA	23430	RUDDER GAIL /	157 WILLIAMSON PARK LN	SMITHFIELD	VA	23430	Isle of Wight	96431	Windsor	280105	2801.0500	193.5633	260800	60000	320800	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		17.5056	17.8814	17.7406	PD-MX	0.0482	BUSINESS	2212
54-01-086E	51	093	12115 WINDSOR BOULEVARD	WINDSOR	VA	23487	BURKE PAMELA T /	P O BOX 144	WINDSOR	VA	23487	Isle of Wight	96431	Windsor	280300	2803	10168.1497	265800	68900	334700	1	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		16.5815	20.7877	18.2260	WINDSOR: R-1	2.2599	PERSON