Saved query 5defd9f66cd04ef4

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

45/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '51' 
  AND countyfp = '093'

22,353 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	saledate	numbldgs	numunits	yearbuilt	numfloors	bldgsqft	bedrooms	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	taxacres	ownertype	legaldesc	placename	placetype	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
37A-01-031	51	093	9364 WHISPERING PINES TRL	WINDSOR	VA	23487	ROACH ALEXANDER KALYN		ISLE OF WIGHT	90616	CARRSVILLE	280300	2803	1868.7458	114800	30000	144800	155000	2020-07-08	1	1	1973		960	3	0	1	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		19.1170	20.4531	19.9326	2	SINGLE FAMILY	NC	0.4615	PERSON				HEAT PUMP	GAS/ELECTRIC	HEAT PUMP	CRAWL/RAISED	ASPHALT		2026.2	2024
34L-01-039	51	093	23187 SPRING CREST DR	CARROLLTON	VA	23314	PULSIFER ALLAN JUNIOR		ISLE OF WIGHT	94839	NEWPORT	280107	2801.0700	1919.0546	321800	70000	391800	275000	2014-09-24	1	1	2002		2464	4	0	3	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		0.7722	5.2265	3.5221	1	SINGLE FAMILY	UR	0.4700	PERSON				UNDETERMINED	GAS	UNDETERMINED	SLAB	ASPHALT		2026.2	2024
22T-01-079	51	093	1126 WHARF HILL DR	SMITHFIELD	VA	23430	BANG EDWARD MIN KIM	1126 WHARF HILL DRIVE SMITHFIEL…	ISLE OF WIGHT	95727	SMITHFIELD	280104	2801.0400	738.3319	551200	75000	626200	69499000	2026-03-25	1	1	2025	1	3523	5	1	4	51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		4.1988	6.3220	5.5591	1		SMITH: C-SR	0.1850	PERSON	MALLORY POINTE PHASE A1 LOT 79 …							COMP SH TO 235#	VINYL SIDING	2026.2		1 IOW COUNTY
47-02-002A	51	093	21010 COURTHOUSE HWY	WINDSOR	VA	23487	HOLLAND FARMS INC	21010 COURTHOUSE HWY WINDSOR VA…	ISLE OF WIGHT	96431	WINDSOR	280300	2803	85721.3988	14000	14600	28600		1990-08-27	1	1	2010						51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		17.2552	25.3846	22.0682	5		RAC	24.2300	BUSINESS	JAMES W HOLLAND PROP									2026.2		150 IOW EAST
33A-02-A009	51	093	14206 CARVER DR	CARROLLTON	VA	23314	DIGGS TERNADON A	14206 CARVER DR CARROLLTON VA 2…	ISLE OF WIGHT	94839	NEWPORT	280108	2801.0800	658.7712		20000	20000	50000	1989-01-20	0								51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.9553	6.3616	6.1336	2		SR	0	PERSON	L 9 BLK A SEC 2 B T ESTATES									2026.2		1 IOW COUNTY
34-01-003I1	51	093	1 W MELLEN ST	HAMPTON	VA	23663	THE OLD POINT NATIONAL BANK OF		ISLE OF WIGHT	94839	NEWPORT	280108	2801.0800	5521.7988	754600	629400	1384000		2004-04-26	1	1							51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		6.1239	7.1326	6.7347	4		GC	1.4450	PERSON		OLD POINT NATIONAL BANK, A DIVI…	BANK_OR_CREDIT_UNION							2026.2
38A-03-006	51	093	10270 CENTRAL HILL RD	WINDSOR	VA	23487	TR CENTRAL HILL BAPTIST	10270 CENTRAL HILL RD WINDSOR V…	ISLE OF WIGHT	90616	CARRSVILLE	280300	2803	4832.0525		41600	41600	3000000	1988-01-15	0								51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		26.1222	27.3025	26.9306	76		RAC	1.1800	PERSON	PARCEL 6 HUGH GWALTNEY PROP									2026.2		73 HUGH GWALTNEY PROP
33A-03-018	51	093	330 THELMAR LN	PORTSMOUTH	VA	23701	NCR HOMES AND CONSTRUCTION LLC	330 THELMAR LN PORTSMOUTH VA 23…	ISLE OF WIGHT	94839	NEWPORT	280108	2801.0800	1053.5197		5000	5000	8000000	2025-08-14	0								51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.9435	6.2537	6.0996	2		SR	0.2600	BUSINESS	LOT 18 BOOKER T ESTATE PLAT 2-1…									2026.2		1 IOW COUNTY
21A-06-D021	51	093	205 EAST ST	SMITHFIELD	VA	23430	TUCKER BOBBY H ROSETTA	205 EAST STREET SMITHFIELD VA 2…	ISLE OF WIGHT	93839	HARDY	280105	2801.0500	664.2004		9000	9000	280000	1980-09-16	1								51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		10.0910	10.5906	10.3840	1		SMITH: DN-R	0	PERSON	LOT 21 BLK D SYKES SURVEY PLAT …									2026.2		80 SYKES SURVEY
23C-01-4002	51	093	20588 WARWICK ST	BATTERY PARK	VA	23304	DRUMRIGHT JOSEPH D JR DALE S	20588 WARWICK STREET BATTERY PA…	ISLE OF WIGHT	94839	NEWPORT	280104	2801.0400	194.9573		5000	5000	9990000	2012-11-20	0								51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.6073	6.3031	5.7846	2		NC	0.0500	PERSON	LOT 2 BLK 4 BATTERY PARK PLAT B…									2026.2		155 BATTERY PARK
30-02-000A	51	093		SMITHFIELD	VA	23431	DENSON PERNELL LEROY SR	P O BOX 813 SMITHFIELD VA 23431	ISLE OF WIGHT	93839	HARDY	280200	2802	6495.4503		59000	59000		1992-03-10	0								51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		21.5719	25.3627	24.2847	2		RAC	1.9000	PERSON	TRACT A KENNETH PRETLOW LAND									2026.2		98 KENNETH W PRETLOW LAND
12-01-005	51	093	6065 EVERETS RD	SUFFOLK	VA	23434	EVERETS PROPERTIES INC	6065 EVERETS ROAD SUFFOLK VA 23…	ISLE OF WIGHT	90616	CARRSVILLE	280101	2801.0100	45055.9918		7900	7900		2007-12-28	0								51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		23.8740	26.1620	25.6179	2		RAC	11.1000	BUSINESS	ADJ JOHN BARLOW PLAT I 250003091									2026.2		1 IOW COUNTY
10-01-011G	51	093	105 LUMAR RD	SMITHFIELD	VA	23430	JONES DAVID W	105 LUMAR RD SMITHFIELD VA 23430	ISLE OF WIGHT	90616	CARRSVILLE	280200	2802	129355.4694		116400	116400		2022-06-10	0								51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		14.1654	24.3154	17.8782	2		RR	32.0400	PERSON	PCL 11G CARROLL PROPERTY PLAT 2…									2026.2		1 IOW COUNTY
03-01-043	51	093	1736 BURNT MILL RD	SURRY	VA	23883	WILSON JEFFERSON EST	1736 BURNT MILL RD SURRY VA 238…	ISLE OF WIGHT	93839	HARDY	280101	2801.0100	53785.1576		103000	103000		1976-07-04	0								51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		8.1191	9.8875	9.3337	2		RAC	10	PERSON	ADJ WILLIE MINNS									2026.2		1 IOW COUNTY
21A-03-D011	51	093	10 JAMESVIEW CIR	SMITHFIELD	VA	23430	BROUILLARD CYNTHIA GATLING PHIL…		ISLE OF WIGHT	93839	HARDY	280105	2801.0500	1090.4880	465900	105000	570900		2024-02-13	1	1							51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		-0.5899	9.9732	7.1765	1		SMITH: DN-R	0	PERSON										2026.2
33B-01-002D	51	093	14346 CHAPMANS LN	CARROLLTON	VA	23314	HARRISON ANTONIA W		ISLE OF WIGHT	96431	WINDSOR	280106	2801.0600	1294.2165	69100	35000	104100		2002-08-28	1	1							51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		7.0319	7.5997	7.3631	2		RAC	0.3200	PERSON										2026.2
21A-30-050	51	093	1105 WILSON RD	SMITHFIELD	VA	23430	BIRON REBECCA M CRUMPLER	1105 WILSON RD SMITHFIELD VA 23…	ISLE OF WIGHT	95727	SMITHFIELD	280105	2801.0500	409.7878		12000	12000		1985-09-11	0								51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		13.2493	13.5421	13.3806	1		SMITH: N-R	0	PERSON	1 2 L 50 SEC 3 GRIMESLAND SOUTH									2026.2		111 GRIMESLAND
21E-01-237	51	093	1102 CYPRESS CREEK PKWY	SMITHFIELD	VA	23430	PERRY JAMES O JR PERRY SHEILA S…		ISLE OF WIGHT	95727	SMITHFIELD	280105	2801.0500	4674.4773	1106700	150000	1256700		2022-12-13	1	1							51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		2.8387	8.1636	5.7536	2		SMITH: S-R	1.1600	TRUST										2026.2
21A-01-438	51	093	344 S CHURCH ST	SMITHFIELD	VA	23430	HOOVER JOHN P SR EMILY		ISLE OF WIGHT	95727	SMITHFIELD	280105	2801.0500	2002.0744	273700	120000	393700		2024-10-23	1	1							51093C	2026-01-08	AE		8	-0.4051	9.1861	2.2099	1		SMITH: DN-R, E-C	0	PERSON										2026.2
21E-02-126	51	093	173 AYRSHIRE LOOP	SMITHFIELD	VA	23430	DAVIS CURTIS L DAVIS ELISHA A T…		ISLE OF WIGHT	95727	SMITHFIELD	280105	2801.0500	802.5501	430400	95000	525400		2025-01-02	1	1							51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		10.9844	11.4307	11.2415	2		SMITH: S-R	0.1980	TRUST										2026.2
21E-02-086	51	093	208 AYRSHIRE LOOP	SMITHFIELD	VA	23430	HOBBS BRETT MOLLY		ISLE OF WIGHT	95727	SMITHFIELD	280105	2801.0500	948.4725	335600	95000	430600		2024-04-17	1	1							51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		8.3553	9.7327	9.0019	2		SMITH: S-R	0.2350	PERSON										2026.2
52-09-005	51	093	23016 BARRETT TOWN RD	ZUNI	VA	23898	OSBORN JAMES G KATHERYN W		ISLE OF WIGHT	90616	CARRSVILLE	280400	2804	38493.9711	341400	79400	420800		2024-12-10	3	1							51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		13.1569	18.3533	16.2669	2		RR	9.8800	PERSON										2026.2
23B-02-166	51	093	22537 JAMES RIVER DR	CARROLLTON	VA	23314	ROBINSON SHERRY N		ISLE OF WIGHT	94839	NEWPORT	280108	2801.0800	1325.3133	550400	55000	605400		2009-12-21	1	1							51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		6.8250	7.9311	7.2153	2		NC	0	PERSON										2026.2
22E-02-155	51	093	802 SMITHFIELD BLVD	SMITHFIELD	VA	23430	EWING JONATHAN		ISLE OF WIGHT	95727	SMITHFIELD	280106	2801.0600	2038.8542	264600	70000	334600		2021-10-15	1	1							51093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		5.6543	6.9113	6.2440	1		SMITH: N-R	0	PERSON										2026.2
21-01-086B	51	093	600 CYPRESS CREEK PKWY	SMITHFIELD	VA	23430	CCGC SMITHFIELD LLC		ISLE OF WIGHT	95727	SMITHFIELD	280105	2801.0500	101183.6734	10000	43500	53500		2025-01-23	1	1							51093C	2026-01-08	AE		8	1.9099	13.0095	3.7870	4		SMITH: S-R	24.6200	BUSINESS										2026.2