Saved query ff2a3b345ca00562

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

36/80

Live SQL

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

28,447 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	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	zoningdesc	taxacres	ownertype	legaldesc	placename	placetype	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxdistrict
W02a-0053-4433	10023462	51	199	118 OVERLOOK PT	VA	23693	GOTTHARDT LEE J MIRIAM E	118 OVERLOOK PT	YORKTOWN	VA	23693	YORK	91890	5	050206	502.0600	5264.6521	525200	138600	663800	489000	2016-08-22	1	1	2009	2	2923	3	1	2	51199C	2026-01-08	AE		8	0.4827	2.5917	1.7026	SI	SINGLE FAMILY IMPROVED	R20	MEDIUM DENSITY SINGLE FAMILY RE…	1.3000	PERSON	OVERLOOK POINT LOT 40			1	UNDETERMINED	UNDETERMINED	CENTRAL AIR	CRAWL SPACE	ARCH SHNG	VINYL	2026.2	BETHEL
T08c-1152-1658	10007704	51	199	104 CATHERINE CT	VA	23696	MINETREE ROBERT E KAREN R	104 CATHERINE COURT	SEAFORD	VA	23696	YORK	91590	3	050402	504.0200	2018.2931	314400	112700	427100	269645	2012-08-07	1	1	1973	1	2251	3	1	3	51199C	2026-01-08	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…		2.3790	2.7768	2.5464	SI	SINGLE FAMILY IMPROVED	RR	RURAL RESIDENTIAL	0.4903	PERSON	HERITAGE HAMLET SEC 11 LOT 63			1	CENTRAL AIR	GAS	CENTRAL AIR	CRAWL SPACE	ARCH SHNG	VINYL	2026.2	SEAFORD
H13c-0360-0498	10019231	51	199	103 HAYMAKER PL	VA	23185	VAWTER EARNEST L VICKI A	103 HAYMAKER PL	WILLIAMSBURG	VA	23185	YORK	91290	1	050900	509	736.9955	416700	94800	511500	260075	2004-09-20	1	1	2004	2	2337	3	1	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		15.8962	21.8553	20.1342	SI	SINGLE FAMILY IMPROVED	PD	PLANNED DEVELOPMENT	0.1825	PERSON	WILLIAMSBURG BLUFFS SEC 2 PHASE…			1	CENTRAL AIR	GAS	CENTRAL AIR	BASEMENT	ARCH SHNG	VINYL	2026.2	MAGRUDER
V03b-4154-3607	10019336	51	199	107 TREIS TRL	VA	23693	PATEL VIRALKUMAR C BHAVITABEN V	107 TREIS TRL	YORKTOWN	VA	23693	YORK	91890	5	050206	502.0600	1525.8394	469100	136000	605100	475000	2021-04-28	1	1	1996	2	2641	4	1	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		2.7274	3.8573	3.5050	SI	SINGLE FAMILY IMPROVED	R20	MEDIUM DENSITY SINGLE FAMILY RE…	0.3771	PERSON	WOODS OF TABB THE SECTION 6 LOT…			2	CENTRAL AIR	GAS	CENTRAL AIR	CRAWL SPACE	ARCH SHNG	VINYL	2026.2	TABB
S06d-4840-0067	10009534	51	199	102 BAILEY DR	VA	23692	HARTLEY SCOTT M NICOLE	102 BAILEY DR	YORKTOWN	VA	23692	YORK	91740	4	050303	503.0300	1734.7660	362400	134600	497000	344000	2018-05-30	1	1	1985	2	2755	5	1	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		8.0652	12.6599	11.4082	SI	SINGLE FAMILY IMPROVED	R20	MEDIUM DENSITY SINGLE FAMILY RE…	0.4500	PERSON	LAKESIDE FOREST SEC 2 LOT 90			1	HEAT PUMP	ELECTRIC	HEAT PUMP	CRAWL SPACE	ARCH SHNG	ALUMINUM	2026.2	DARE
T09b-4853-3520	10006289	51	199	203 LANDING RD	VA	23696	MITERA LYNN M MATTHEW R	218 LANDING RD	SEAFORD	VA	23696	YORK	91590	3	050402	504.0200	1665.5463	275300	99400	374700	325000	2022-05-05	2	1	1963	1	2029	4	1	2	51199C	2026-01-08	AE		7	1.2384	2.0844	1.8362	SI	SINGLE FAMILY IMPROVED	RR	RURAL RESIDENTIAL	0.4100	PERSON	CLAYTON EUGENE E KATHERINE M PL…			1	CENTRAL AIR	OIL	CENTRAL AIR	CRAWL SPACE	ARCH SHNG	BRICK	2026.2	SEAFORD
T04c-0328-1042	10010792	51	199	101 VILLA WAY	VA	23693	CHO BYUNG SAM	101 VILLA WAY	YORKTOWN	VA	23693	YORK	91740	4	050205	502.0500	1484.4006	258600	133200	391800	241000	2013-09-18	2	1	1979	2	1728	3	1	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		8.2787	8.9818	8.7171	SI	SINGLE FAMILY IMPROVED	R20	MEDIUM DENSITY SINGLE FAMILY RE…	0.3489	PERSON	KINGS VILLA SEC 1 LOT 126			1	HEAT PUMP	ELECTRIC	HEAT PUMP	CRAWL SPACE	COMP SHNG	VINYL	2026.2	HARWOODS MILL
S02d-4474-2016	10021394	51	199	602 MARY BIERBAUER WAY	VA	23693	LEE SION DAVID CAROLINE JINNIE	602 MARY BIERBAUER WAY	YORKTOWN	VA	23693	YORK	91440	2	050203	502.0300	1177.2072	460200	135000	595200	600000	2024-12-23	1	1	2001	2	2584	4	1	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		9.1949	9.8057	9.6132	SI	SINGLE FAMILY IMPROVED	R13	HIGH DENSITY SINGLE FAMILY RESI…	0.2883	PERSON	YORK MEADOWS SEC 6 LOT 89			1	CENTRAL AIR	GAS	CENTRAL AIR	CRAWL SPACE	ARCH SHNG	VINYL	2026.2	COVENTRY
T08d-3296-0956	10007290	51	199	113 THOMAS RD	VA	23696	SCHROEDER MATTHEW T AMBER L	113 THOMAS RD	SEAFORD	VA	23696	YORK	91590	3	050402	504.0200	1793.7999	283300	130000	413300	312300	2017-03-06	1	1	1964	15	2444	3	2	1	51199C	2026-01-08	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…		0.3801	2.8422	2.0221	SI	SINGLE FAMILY IMPROVED	RR	RURAL RESIDENTIAL	0.6657	PERSON	ROBANNA TERRACE LOT 6			1	CENTRAL AIR	GAS	CENTRAL AIR	BASEMENT	ARCH SHNG	VINYL	2026.2	SEAFORD
M11d-4763-2276	10024618	51	199	206 FOSTER RD	VA	23690	BENINGTON NOVA JUSTIN	206 FOSTER RD	YORKTOWN	VA	23690	YORK	91590	3	050500	505	696.9030	392900	84000	476900	483250	2024-03-13	1	1	2010	25	2764	3	1	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		24.3171	25.5314	25.1060	SI	SINGLE FAMILY IMPROVED	R13	HIGH DENSITY SINGLE FAMILY RESI…	0.1722	PERSON	MAGNOLIA PARK LOT 26			1	CENTRAL AIR	UNDETERMINED	CENTRAL AIR	CRAWL SPACE	ARCH SHNG	VINYL	2026.2	EDGEHILL
S06d-2626-1392	10008498	51	199	120 CHOISY CRES	VA	23692	TRIPLETT ZANE	120 CHOISY CRES	YORKTOWN	VA	23692	YORK	91740	4	050303	503.0300	255.6247	189300	55000	244300	245000	2024-03-28	1	1	1986	2	1318	2	1	1	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		16.2429	16.6820	16.5559	TI	TOWNHOUSE IMPROVED	RMF	MULTI-FAMILY RESIDENTIAL	0.0630	PERSON	YORK CROSSING TOWNHOUSES SEC 1 …			1	HEAT PUMP	ELECTRIC	HEAT PUMP	SLAB	COMP SHNG	VINYL	2026.2	DARE
T02d-4035-2353	10015852	51	199	105 FERGUSON BND	VA	23693	BOCKRATH ROBERTA	105 FERGUSON BEND	YORKTOWN	VA	23693	YORK	91440	2	050203	502.0300	378.9339	187700	85000	272700	99500		1	1	1991	2	1388	2	0	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		6.9222	7.5922	7.3113	XI	DUPLEX IMPROVED	PD	PLANNED DEVELOPMENT	0.0938	PERSON	FERGUSON GLADE SEC 2B LOT 17			1	CENTRAL AIR	GAS	CENTRAL AIR	SLAB	ARCH SHNG	VINYL	2026.2	COVENTRY
Q08a-0087-4801	10005588	51	199	108 LAUREL PATH RD	VA	23692	CARGILE JAMES P GERALDINE D TRS	108 LAUREL PATH RD	YORKTOWN	VA	23692	YORK	91590	3	050306	503.0600	3185.6019	331600	129800	461400		2004-06-01	1	1	1981	2	2545	4	1	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		15.9249	17.1553	16.3941	SI	SINGLE FAMILY IMPROVED	R20	MEDIUM DENSITY SINGLE FAMILY RE…	0.7576	TRUST	EDGEHILL SEC M LOT 7			1	HEAT PUMP	ELECTRIC	HEAT PUMP	CRAWL SPACE	ARCH SHNG	ALUMINUM	2026.2	EDGEHILL
R06b-3444-4492	10016929	51	199	112 GNARLED OAK LN	VA	23692	HOOD CHRISTINE M	112 GNARLED OAK LN	YORKTOWN	VA	23692	YORK	91590	3	050306	503.0600	336.8459	221300	73000	294300		2019-10-30	1	1	1993	1	1426	3	0	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		12.0899	13.0994	12.6905	TI	TOWNHOUSE IMPROVED	RMF	MULTI-FAMILY RESIDENTIAL	0.0832	PERSON	GRAFTON WOODS SEC 6 LOT 130			1	CENTRAL AIR	GAS	CENTRAL AIR	SLAB	ARCH SHNG	VINYL	2026.2	GRAFTON
U04a-1175-3091	10009200	51	199	100 MOORES CREEK DR	VA	23693	TRAN JOSHUA OLIVIA	100 MOORES CREEK DR	YORKTOWN	VA	23693	YORK	91740	4	050205	502.0500	5267.1661	374200	158500	532700	500000	2021-06-29	1	1	1979	2	2834	5		3	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		2.5570	3.7207	3.1554	SI	SINGLE FAMILY IMPROVED	RR	RURAL RESIDENTIAL	1.3000	PERSON	MOORES CREEK EST LOT 5			1	HEAT PUMP	ELECTRIC	HEAT PUMP	CRAWL SPACE	ARCH SHNG	VINYL	2026.2	HARWOODS MILL
T04c-0947-0020	10010625	51	199	200 GREENLAND DR	VA	23693	GRAHAM JOHN P KIMBERLEE H	200 GREENLAND DR	YORKTOWN	VA	23693	YORK	91740	4	050205	502.0500	2153.5055	196700	137400	334100		2016-07-21	1	1	1961	1	1333	3	0	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		9.5025	10.0969	9.7909	SI	SINGLE FAMILY IMPROVED	RR	RURAL RESIDENTIAL	0.5349	PERSON	SMITHVILLE TERRACE LOT 25			1	HEAT PUMP	ELECTRIC	HEAT PUMP	CRAWL SPACE	ARCH SHNG	BRICK	2026.2	TABB
T05c-0727-1902	10010353	51	199	142 MILL LN	VA	23692	YATES IDA MAE SANDRA P RATLIFF	142 MILL LN	YORKTOWN	VA	23692	YORK	91740	4	050304	503.0400	1393.7022	254200	123100	377300		2025-06-03	2	1	1969	1	1562	3	1	1	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		9.7493	10.7827	10.2404	SI	SINGLE FAMILY IMPROVED	R20	MEDIUM DENSITY SINGLE FAMILY RE…	0.3444	PERSON	HARWOOD HEIGHTS LOT 32			1	CENTRAL AIR	GAS	CENTRAL AIR	CRAWL SPACE	ARCH SHNG	BRICK	2026.2	HARWOODS MILL
G14a-1893-2620	10022225	51	199	100 RHINE CT	VA	23185	PAYNE CHARLES HENRY JR	100 RHINE CT	WILLIAMSBURG	VA	23185	YORK	91290	1	051100	511	697.0288	243700	81000	324700	277500	2021-10-25	1	1	2003	2	1644	4	1	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		22.8012	24.5272	24.0737	SI	SINGLE FAMILY IMPROVED	R13	HIGH DENSITY SINGLE FAMILY RESI…	0.1729	PERSON	VINEYARD HEIGHTS LOT 18				CENTRAL AIR	GAS	CENTRAL AIR	SLAB	COMP SHNG	VINYL	2026.2	MAGRUDER
H12a-0294-3728	10019635	51	199	105 PARCHMENT BLVD	VA	23185	BRADLEY DAVID M	27689 SUN CITY BLVD	SUN CITY	CA	92856	YORK	91290	1	050900	509	215.7479	195900	80000	275900		2005-06-08	1	1	2000	2	1412	3	1	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		23.3970	24.9877	24.6463	XI	DUPLEX IMPROVED	RMF	MULTI-FAMILY RESIDENTIAL	0.0829	PERSON	CALLAHAN VILLAGE DUPLEXES LOT 26			1	CENTRAL AIR	GAS	CENTRAL AIR	SLAB	COMP SHNG	VINYL	2026.2	MAGRUDER
R07d-3769-0145	10016221	51	199	105 SANDERLING WALK	VA	23692	LEONARD KATHERINE V	105 SANDERLING WALK	YORKTOWN	VA	23692	YORK	91590	3	050306	503.0600	223.4060	229600	73000	302600	76950		1	1	1992	2	1404	3	1	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		13.4243	14.8123	14.3626	TI	TOWNHOUSE IMPROVED	RMF	MULTI-FAMILY RESIDENTIAL	0.0552	PERSON	GRAFTON WOODS SEC 3 LOT 237			1	CENTRAL AIR	GAS	CENTRAL AIR	SLAB	ARCH SHNG	VINYL	2026.2	GRAFTON
S10c-0103-1316	10004204	51	199	202 OAK POINT DR	VA	23692	MCLAWHORN WADE L	202 OAK POINT DRIVE	YORKTOWN	VA	23692	YORK	91590	3	050401	504.0100	1471.9639	190600	155900	346500			2	1	1970	2	1816	4	1	2	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.5290	4.1896	3.9316	SI	SINGLE FAMILY IMPROVED	RR	RURAL RESIDENTIAL	0.3587	PERSON	WATERVIEW TERRACE LOT 15			1	CENTRAL AIR	OIL	CENTRAL AIR	CRAWL SPACE	COMP SHNG	ALUMINUM	2026.2	SEAFORD
V04c-2285-0627	10012744	51	199	1618 CARYS CHAPEL RD	VA	23693	COMBS MORRIS EST	1618 CARYS CHAPEL RD	YORKTOWN	VA	23693	YORK	91890	5	050206	502.0600	805.1066	191900	84200	276100			2	1	1940	1	1209	3	0	1	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.1055	3.5447	3.3525	SI	SINGLE FAMILY IMPROVED	R20	MEDIUM DENSITY SINGLE FAMILY RE…	0.2405	PERSON	RT 609 ROBERTS			0	HEAT PUMP	ELECTRIC	HEAT PUMP		ARCH SHNG	VINYL	2026.2	TABB
S03d-3511-2439	10012619	51	199	2307 GEORGE WASHINGTON MEMORIAL…	VA	23693	BRADISH PROPERTIES INC	2153 PARTRIDGE PL	SUFFOLK	VA	23433	YORK	91440	2	050305	503.0500	3276.5788	143800	293200	437000			4	1	1956	1	4457	0	0	0	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		9.9607	10.6355	10.2459	RETL	RETAIL	GB	GENERAL BUSINESS	0.8100	BUSINESS	BYRD LANE SUB LOT 1			0			HEAT PUMP	SLAB	METAL	VINYL	2026.2	KILN CREEK
R08c-1949-1154	10134268	51	199	322 F OLD YORK HAMPTON HWY	VA	23692	MARTIN S POINT LLC	126 JENNINGS DR	YORKTOWN	VA	23692	YORK	91590	3	050401	504.0100	138.1931	141100	27500	168600	548000	2023-09-21	1	1	2024	1	1939				51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		14.3809	14.6952	14.5516	FLEX	INDUSTRIAL FLEX BUILDING	IG	GENERAL INDUSTRIAL	0	BUSINESS	YORKTOWN COMMERCE CENTER PHASE …						OTHER	SLAB	BUILTUP	BRICK	2026.2	YORKTOWN
G18a-1244-3044	10001012	51	199	5000 CAPITOL LANDING RD	VA	23188	USA	UNASSIGNED			0	YORK	91290	1	051000	510	34992469.9222	196362600	113670000	310032600			401	1	1754	1	100	0	0	0	51199C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD					USNT	US GOVT NON-TAX	RC	RESOURCE CONSERVATION	8420	GOVERNMENT	CAMP PEARY	BIGLER'S MILL, VIRGINIA	HISTORIC_SITE	0			OTHER				2026.2	WALLER MILL