Saved query 8d1744c42dcef130

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

39/80

Live SQL

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

52,497 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	saledate	numbldgs	numunits	yearbuilt	numfloors	bldgsqft	bedrooms	fullbaths	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	zoningdesc	taxacres	ownertype	legaldesc	book	page	placename	placetype	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxdistrict
V01b-3431-4331	10012886	51	650	303 CATTAIL LN		VA	23693	MORALES-PAIZ RAMSES LILLIAM JAV…	303 CATTAIL LN	YORKTOWN	VA	23693	HAMPTON	93827	HAMPTON			4338.6740	163400	90000	253400	250000	2024-08-15	1	1	1988	1	1344	3	2	515527	2026-01-08	AE		8	-0.6298	2.6066	0.4699	MD	MODULAR	R7	SINGLE FAMILY MANUFACTERED HOME…	0.2424	PERSON	WHISPERING WINDS SEC 2 LOT 47					CENTRAL AIR	GAS	CENTRAL AIR	CRAWL SPACE	ARCH SHNG	VINYL	2026.2	BETHEL
8005830		51	650	5 SELDENDALE DR	HAMPTON	VA	23669	RKMJ ASSOCIATES L C	217 DARDEN DR	POQUOSON	VA	23662	HAMPTON	93827	HAMPTON	010701	107.0100	34051.7737						1	1	1950	2		3	1	515527	2026-01-08	AE		8	-0.4806	4.1277	1.4986	502	FARM UTILITY BUILDING	R-11		10	PERSON	SINCLAIRS DOOLITTLE TR 10AC	0367	0525	HARDEST PART OF TOWN	SPORT_OR_FITNESS_FACILITY	CENTRAL WARM AIR	UNDETERMINED		FULL CRAWL		CONC BLOCK	2026.2	1232
12001905		51	650	26 N HOPE ST	HAMPTON	VA	23663	SPENCER KENNETH M	26 N HOPE ST	HAMPTON	VA	23663	HAMPTON	93827	HAMPTON	011300	113	1023.6291					2007-01-31	1	1	1977	1	3000			515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	3.2846	3.8621	3.4465	467	INDUSTRIALS, LIGHT MFTG.	C-3		0	PERSON	N HOPE ST 52FT.	0497	0456									2026.2	9140
13002507		51	650	1100 JONQUIL LN	HAMPTON	VA	23669	WILSONDALE L P	1821 AVON ST STE 200	CHARLOTTESVILLE	VA	22902	HAMPTON	93827	HAMPTON	010702	107.0200	25724.2765					2009-05-04	1	1	2011	1	165702			515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	1.3568	3.6177	3.0368	400	MULTIPLE RES	C-2		7.6670	BUSINESS	WILSONDALE U2	00M3	0033									2026.2	4000
10001036		51	650	21 ASHE MEADOWS DR	HAMPTON	VA	23664	HAMPTON CITY OF	22 LINCOLN ST	HAMPTON	VA	23669	HAMPTON	93827	HAMPTON	012100	121	490.8594						1	1	2007	1	144			515527	2026-01-08	AE		8	1.2404	2.0594	1.6765	632	C02	R-15		0	GOVERNMENT	ASHE MEADOWS DR 3358AC PS#48.	1221	0629									2026.2	6040
3002065		51	650	4812 W MERCURY BLVD	HAMPTON	VA	23666	CETERIS PARIBUS INC	9608 WARWICK BLVD	NEWPORT NEWS	VA	23601	HAMPTON	93827	HAMPTON	010310	103.1000	1719.4369						1	1	1974	1	882			515527	2026-01-08	AE		-9999	4.0614	4.6865	4.3696	430	RETAIL STORE	C-2		0.4200	BUSINESS	4812 WEST MERCURY BLVD 150FT	0235	0488									2026.2	4500
13003417		51	650	922 JONQUIL LN	HAMPTON	VA	23669	WILSONDALE L P	1821 AVON ST STE 200	CHARLOTTESVILLE	VA	22902	HAMPTON	93827	HAMPTON	010702	107.0200	35.5626						1	1	2011	1	1054			515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	3.3067	3.4014	3.3595	400	MULTIPLE RES	C-2		0	BUSINESS	WILSONDALE 2 BLDG 900 U922	00M3	0101									2026.2	4000
13002680		51	650	48 GODSPEED WAY	HAMPTON	VA	23663	HAMPTON REDEV HOUSING AUTH	811 W PEMBROKE AVE	HAMPTON	VA	23669	HAMPTON	93827	HAMPTON	010900	109	232.9610						1	1	2011	1	1086			515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	3.3816	3.5816	3.5025	645	MULTIPLE RES	MD-2		0.0576	PERSON	OLD POINT TOWNHOMES L24	0012	0134									2026.2	4000
13002050		51	650	1601 COLISEUM DR	HAMPTON	VA	23666	HAMPTON CITY OF	22 LINCOLN ST	HAMPTON	VA	23669	HAMPTON	93827	HAMPTON	010502	105.0200	1304.2227						1	1	2007	1	144			515527	2026-01-08	AE		8	-0.0399	2.7899	1.2144	632	C01	C-2		0.3548	GOVERNMENT	COLISEUM DR 3548AC PS#118	00M2	0174									2026.2	6040
2000779		51	650	215 W PEMBROKE AVE	HAMPTON	VA	23669	GILAN LLC	713 STANHOPE CLOSE	CHESAPEAKE	VA	23320	HAMPTON	93827	HAMPTON	010601	106.0100	557.3507					2024-04-26	0							515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2.6724	3.1908	2.9549	488	C01	C-3		0.1400	BUSINESS	HAMPTON LAND CO L28.29 B2	120	002783									2026.2	9150
8000077		51	650	610 N BACK RIVER RD	HAMPTON	VA	23669	WARD CATHERINE E	508 TODDSBURY CT	HAMPTON	VA	23663	HAMPTON	93827	HAMPTON	010602	106.0200	710.1519					2021-07-26	0							515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	3.0439	3.3289	3.1970	500	RESIDENTIAL VACANT LOT	R-9		0.1780	PERSON	LANGLEY PARK L5.6 BF	0063	0363									2026.2	1168
8000876		51	650	26 PLAZA DR UNIT A	HAMPTON	VA	23669	KISFOSS KATHERINE SORIANO LAURA…	26 PLAZA DR	HAMPTON	VA	23669	HAMPTON	93827	HAMPTON	010602	106.0200	538.7778					2023-08-31	0							515527	2026-01-08	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	-9999	1.7218	3.1041	2.3973	500	RESIDENTIAL VACANT LOT	R-9		0.1329	PERSON	CHERRY ACRES L22B BA	0763	0813									2026.2	1238
2002037		51	650	387 W QUEEN ST	HAMPTON	VA	23669	395 LLC	395 W QUEEN ST	HAMPTON	VA	23669	HAMPTON	93827	HAMPTON	011800	118	615.4595					2003-07-28	0							515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	3.0008	3.5698	3.2411	500	RESIDENTIAL VACANT LOT	R-8		0.1521	BUSINESS	387 W QUEEN ST 53FT PCII.	0862	0355									2026.2	1100
3000753		51	650	477 WHEALTON RD	HAMPTON	VA	23666	BACALLAO CHARLES D SANDY N	473 WHEALTON RD	HAMPTON	VA	23666	HAMPTON	93827	HAMPTON	010309	103.0900	2551.8435					2017-06-14	0							515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	5.6316	6.4576	6.0665	500	RESIDENTIAL VACANT LOT	R-13		0.6034	PERSON	WHEALTON RD 6034AC	0918	0771									2026.2	1538
1004062		51	650	514 CHILDS AVE	HAMPTON	VA	23661	DE MEDRANO SANDRA T FRIAS	48 NORTHAMPTON BLVD	STAFFORD	VA	22554	HAMPTON	93827	HAMPTON	012000	120	912.0642					2014-12-22	0							515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	3.7953	4.2685	3.9969	500	RESIDENTIAL VACANT LOT	R-9		0	PERSON	WILSON SUB L13.14 BB	0000	0000									2026.2	1224
1002992		51	650	730 ROLFE ST	HAMPTON	VA	23661	BRASWELL LEVERNA	734 ROLFE ST	HAMPTON	VA	23661	HAMPTON	93827	HAMPTON	011900	119	613.0241					2024-09-09	0							515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	3.7830	4.2219	4.0171	509	R01	R-8		0	PERSON	GARDEN CITY L5.6 BG	0075	0154									2026.2	1198
12006723		51	650	116 PARKVIEW PL	HAMPTON	VA	23664	RILEY JAMES PATRICK ELAINE C	661 POQUOSON AVE	POQUOSON	VA	23662	HAMPTON	93827	HAMPTON	011001	110.0100	696.7473					2021-09-15	0							515527	2026-01-08	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	-9999	2.1421	2.3672	2.2435	509	R01	R-8		0	PERSON	B B CHES LD CO LS.T.PTR B6	0080	0322									2026.2	1400
12001348		51	650	8 S CURRY ST	HAMPTON	VA	23663	CHARNOCK LAURA	8 S CURRY ST	HAMPTON	VA	23663	HAMPTON	93827	HAMPTON	011300	113	734.4699					2022-01-19	0							515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	3.0356	3.6755	3.2517	500	RESIDENTIAL VACANT LOT	C-2		0.1865	PERSON	CAPT FERNALD PROP L9A	250	004065									2026.2	1148
12001736		51	650	213 N MALLORY ST	HAMPTON	VA	23663	GIDA HOMES LLC	2123 CHESTNUT AVE C	NEWPORT NEWS	VA	23607	HAMPTON	93827	HAMPTON	011300	113	472.8402					2021-04-09	0							515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	3.2423	3.6074	3.4190	500	RESIDENTIAL 1 FAMILY DWELLING	R-11		0.0968	BUSINESS	WILLOW BEACH L19 B17.	0063	0299									2026.2	1134
1005223		51	650	1604 KECOUGHTAN RD	HAMPTON	VA	23661	HAMPTON CITY OF	22 LINCOLN ST	HAMPTON	VA	23669	HAMPTON	93827	HAMPTON	012000	120	1138.3038					2008-11-14	0							515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	0.2313	3.1801	2.1993	630	EXEMPT: HAMPTON	C-1		0.2832	GOVERNMENT	N N RIVER DEV CO LPT29-32 B8	0038	0190									2026.2	9010
1004635		51	650	920 KECOUGHTAN RD	HAMPTON	VA	23661	HAMPTON REDEV HOUSING AUTH	811 W PEMBROKE AVE	HAMPTON	VA	23669	HAMPTON	93827	HAMPTON	011500	115	1107.8787					2013-12-02	0							515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	3.7750	4.4075	4.1472	645	EXEMPT: HAMPTON - HRHA	C-1		0.2738	PERSON	NEWPORT NEWS CO L21.22.23 B25	0021	0370									2026.2	9010
13000295		51	650	2403 COMMANDER SHEPARD BLVD	HAMPTON	VA	23666	ECONOMIC DEVELOPMENT AUTHORITY	1 FRANKLIN ST STE 600	HAMPTON	VA	23669	HAMPTON	93827	HAMPTON	010304	103.0400	9106.0254					2013-08-08	0							515527	2026-01-08	AE		8	0.2497	2.0006	0.6998	640	EXEMPT: HAMPTON - EDA	HRC-2		2.0490	PERSON	SEMPLE FARM RD.PCB.2.049AC.	00M2	0044									2026.2	6005
2002379		51	650	4313 KECOUGHTAN RD	HAMPTON	VA	23661	HAMPTON CITY OF	22 LINCOLN ST	HAMPTON	VA	23669	HAMPTON	93827	HAMPTON	011600	116	509.7625					2019-04-18	0							515527	2026-01-08	AE		8	-0.4564	2.2279	1.7464	630	EXEMPT: HAMPTON	C-3		0.1263	GOVERNMENT	HAMPTON CITY PARCEL PCA	00M5	00102									2026.2	9010
2002118		51	650	IVY HOME RD	HAMPTON	VA	23669	SINKLER JACQUELINE D	345 IVY HOME RD	HAMPTON	VA	23669	HAMPTON	93827	HAMPTON	011600	116	117.3686					2019-12-03	0							515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	3.2491	3.5676	3.3846	500	RESIDENTIAL VACANT LOT	R-11		0	PERSON	COCK NEWTOWN LPT33.	0000	0000									2026.2	1144
13003036		51	650	100 N PARK LN UNIT A	HAMPTON	VA	23666	SANIFILL INC	PO BOX 1450	CHICAGO	IL	60690	HAMPTON	93827	HAMPTON	010304	103.0400	3.2461						1	1	2006	1				515527	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	8.1380	8.1406	8.1393	466	INDUSTRIALS, LIGHT MFTG.	PO-1		0	BUSINESS	POWER PRODUCTION BLD LEASEHOLD											2026.2	9080