Saved query cd2fabecef6abe34

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

10,339 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	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	taxacres	ownertype	naicscode	legaldesc	book	page	placename	placetype	heating	heatfuel	cooling	foundation	roofcover	siding	taxyear	taxdistrict
2165	2165	51	840	1019 BERRYVILLE AVE	WINCHESTER	VA	22601	MURPHY SEAN	1019 BERRYVILLE AVE	WINCHESTER	VA	22601	Winchester	96427	Winchester	000101	1.0100	633.0140	201700	120000	321700	148000	2014-12-30	2	1	1930	0	10000	3	1	1	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	211.0039	213.5260	212.2782	40	DWELLING	B2	0.2296	PERSON	8121	HARRIS ADD B-5 L-47 S S 1019 BE…	2014	2860	MARLEN'S HAIR STUDIO	PERSONAL_OR_BEAUTY_SERVICE	BASEBOARD	ELECTRIC	UNDETERMINED	CONCRETE	METAL/TIN	ASPHALT	2023	1
9868	9868	51	840	423 S BRADDOCK ST	WINCHESTER	VA	22601	CENTRO CRISTIANO PUERTO D/C	PO BOX 1372	WINCHESTER	VA	22604	Winchester	96427	Winchester	000202	2.0200	309.4290	370300	34700	405000	425000	2005-06-21	2	0	1893	71	2310	0	2	0	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	222.5420	225.7749	224.1677	75	COMMERCIAL PROPERTY	RB1	0.0530	NONPROFIT	62141	W S 423 SOUTH BRADDOCK STREET	2005	2730	CENTRO CRISTIANO CASA DE GLORIA	CHRISTIAN_PLACE_OF_WORSHIP	CENTRAL AIR	OIL	UNDETERMINED	CONCRETE	METAL/TIN	BRICK	2023	1
1846	1846	51	840	102 S KENT ST	WINCHESTER	VA	22601	GRIFFIN RENTAL PROPERTIES LLC	205 FAIRMONT AVE	WINCHESTER	VA	22601	Winchester	96427	Winchester	000102	1.0200	315.0719	380800	41100	421900		2014-12-19	1	0	1865	18	3427	0	2	0	51069C	2026-01-08	AE	FLOODWAY	212.2400	212.8329	212.5274	40	COMMERCIAL PROPERTY	B1	0.0790	BUSINESS	54111	BLA SURVEY GRIFFIN LOT E S 102 …	2014	2772	PHILLIP S. GRIFFIN	ATTORNEY_OR_LAW_FIRM	CENTRAL AIR	GAS	UNDETERMINED	STONE	METAL/TIN	WOOD/FRAME	2023	1
6927	6927	51	840	501 S CAMERON ST	WINCHESTER	VA	22601	OMNI LC	114 N CAMERON ST	WINCHESTER	VA	22601	Winchester	96427	Winchester	000301	3.0099	523.6571	536800	86400	623200	1	2002-03-25	2	0	1955	13	5760	0	0	0	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	228.8070	230.5760	229.5948	40	COMMERCIAL PROPERTY	RB1	0.1320	BUSINESS	4595	W S 501 SOUTH CAMERON STREET	2002	1127	SPCA THRIFT STORE	SECOND_HAND_STORE	CENTRAL AIR	GAS	OTHER	CONC/BLOCK	BUILT UP	BRICK	2023	1
8643	8643	51	840	2930 VALLEY AVE	WINCHESTER	VA	22601	SHIV SHAMBHU LLC	2930 VALLEY AVE	WINCHESTER	VA	22601	Winchester	96427	Winchester	000302	3.0200	7381.9612	336997	664700	1001697	825000	2019-11-18	1	0	1961	39	83091	0	0	0	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	232.6909	237.0890	235.9117	40	COMMERCIAL PROPERTY	B2	1.9075	BUSINESS	721110	SHIVE CONSOLIDATION 1.9075 ACRE…	2019	2391	ROYAL INN	HOTEL	HOT WATER	GAS	UNDETERMINED	CONCRETE	COMP SHINGLE	BRICK	2023	1
7939	7939	51	840	2350 LEGGE BLVD	WINCHESTER	VA	22601	H D DEVELOPMENT OF MD INC	HOME DEPOT INC TAX DEPT #4618	ATLANTA	GA	30348	Winchester	96427	Winchester	000302	3.0200	43185.0966	9603400	4669900	14273300	1		1	0	1998	48	466989	0	1	0	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	219.4380	232.2669	224.7543	40	COMMERCIAL PROPERTY	CM1	10.7205	BUSINESS	44414	S/D OF L-2B ADAM'S/SAM'S SD L-A…	297	1468	THE HOME DEPOT	HARDWARE_HOME_AND_GARDEN_STORE	CENTRAL AIR	GAS	OTHER	CONC/BLOCK	BUILT UP	CONCRETE BLOCK	2023	1
537	537	51	840	112 S CAMERON ST	WINCHESTER	VA	22601	FAIRFAX HALL PROPERTIES LLC	PO BOX 2097	WINCHESTER	VA	22604	Winchester	96427	Winchester	000102	1.0200	2249.8382	865300	274300	1139600	1		2	0	1900	18	10346	0	4	0	51069C	2026-01-08	AE		213.0659	214.8609	213.7846	40	COMMERCIAL PROPERTY	B1	0.5109	BUSINESS	5411	E S 112 SOUTH CAMERON STREET (1…	269	22	CRAWFORD LAW GROUP PLLC	ATTORNEY_OR_LAW_FIRM	CENTRAL AIR	GAS	UNDETERMINED	STONE	METAL/TIN	BRICK	2023	1
9834	9834	51	840	2312 ROOSEVELT BLVD	WINCHESTER	VA	22601	PENTECOSTAL CHURCH NEW REBIRTH	154 WINTERS LN	CATONSVILLE	MD	21228	Winchester	96427	Winchester	000302	3.0200	1147.0551	936000	40000	976000	900000	2022-12-05	1	0	1962	71	1	0	2	0	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	222.9750	225.0350	224.5440	40	COMMERCIAL PROPERTY	HR	0.2980	NONPROFIT	8131	MILTON VALLEY SD L-24 E S 2312 …	2022	2767	IGLESIA EVANGELICA CAMINO DE VI…	CHRISTIAN_PLACE_OF_WORSHIP	CENTRAL AIR	GAS	UNDETERMINED	CONC/BLOCK	COMP SHINGLE	BRICK	2023	1
4999	4999	51	840	715 S KENT ST	WINCHESTER	VA	22601	AT THE HUB LLC	C/O CRAIG KIM W	WINCHESTER	VA	22601	Winchester	96427	Winchester	000301	3.0099	282.1209	141000	38000	179000	90000	2018-07-18	1	0	1956	48	1	0	0	1	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	212.1950	214.1569	213.1451	40	COMMERCIAL PROPERTY	HR1	0.0895	BUSINESS	4855	W S 715 SOUTH KENT STREET	2018	1552			HOT WATER	OIL	UNDETERMINED	CONCRETE	BUILT UP	CONCRETE BLOCK	2023	1
3585	3585	51	840	805 S KENT ST	WINCHESTER	VA	22601	RIOS GUILLERMO	805 S KENT ST	WINCHESTER	VA	22601	Winchester	96427	Winchester	000301	3.0099	402.2079	191000	38000	229000	270000	2022-09-12	1	1	1925	0	1	5	0	2	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	209.7839	211.5859	210.4045	10	DWELLING	HR1	0.1010	PERSON		W S 805 SOUTH KENT STREET	2022	2160			FLOOR UNIT	GAS	UNDETERMINED	STONE	METAL/TIN	VINYL	2023	1
8521	8521	51	840	294 GREEN ST	WINCHESTER	VA	22601	MENEFEE ALFRED L	294 GREEN ST	WINCHESTER	VA	22601	Winchester	96427	Winchester	000102	1.0200	600.6400	310400	60000	370400	136900	2002-05-02	1	1	2002	8	1	3	0	3	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	221.2270	222.2760	221.8058	10	DWELLING	HR1	0.1530	PERSON		ORCHARD TERR SD S-1 L-102 N S 2…	2002	1604			CENTRAL AIR	GAS	UNDETERMINED	CONC/BLOCK	COMP SHINGLE	VINYL	2023	1
3147	3147	51	840	315 GRAY AVE	WINCHESTER	VA	22601	HANSEL JOHN DARIN	315 GRAY AVE	WINCHESTER	VA	22601	Winchester	96427	Winchester	000102	1.0200	705.9669	298000	50000	348000	386350	2025-03-14	2	2	1931	0	1	3	0	2	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	225.8520	228.0449	227.0365	30	DWELLING	HR1	0.1747	PERSON		W S 315 GRAY AVENUE	2025	529			CENTRAL AIR	OIL	UNDETERMINED	CONC/BLOCK	COMP SHINGLE	ALUMINUM	2023	1
9519	9519	51	840	190 CAMPUS BLVD STE 410	WINCHESTER	VA	22601	WINCHESTER MEDICAL CENTER INC	ATTN ACCOUNTING DEPT	WINCHESTER	VA	22604	Winchester	96427	Winchester	000201	2.0099	193.9889	567500	29100	596600	1	2007-11-30	1	0	1999	64	4854	0	0	0	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	253.5820	253.8229	253.7688	78	COMMERCIAL PROPERTY	MC	0.1110	BUSINESS	6215	MED OFFICE BLDG II-STE 410 S S …	2007	4031			CENTRAL AIR	GAS	UNDETERMINED	CONCRETE	BUILT UP	BRICK	2023	1
9008	9008	51	840	2655 STONERIDGE RD	WINCHESTER	VA	22601	HOBSON TIMOTHY	2655 STONERIDGE RD	WINCHESTER	VA	22601	Winchester	96427	Winchester	000302	3.0200	1546.7260	603700	75000	678700	410000	2018-12-11	1	0	2006	0	1	4	1	3	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	246.1600	252.4080	248.4497	10	DWELLING	LR	0.3630	PERSON		HARVEST RIDGE SD S-2 L-50 W S 2…	2018	2602			CENTRAL AIR	GAS	UNDETERMINED	CONCRETE	COMP SHINGLE	VINYL	2023	1
6444	6444	51	840	536 BARR AVE	WINCHESTER	VA	22601	HUMPHREY HUBERT	PO BOX 1564	MIDDLEBURG	VA	20118	Winchester	96427	Winchester	000202	2.0200	517.3672	333700	90000	423700	240000	2015-08-14	1	1	1962	4	1	3	0	2	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	244.2330	246.8999	245.5442	10	DWELLING	MR	0.1310	PERSON		BELLVIEW HGTS SD B-E L-1 N S 53…	2015	1886			HOT WATER	GAS	UNDETERMINED	CONC/BLOCK	COMP SHINGLE	BRICK	2023	1
115	115	51	840	679 NATIONAL AVE	WINCHESTER	VA	22601	GROVE-CHERRY LLC	1492 FISHEL RD	WINCHESTER	VA	22602	Winchester	96427	Winchester	000102	1.0200	698.5087	182700	58500	241200		2016-02-18	1	1	1940	0	1	3	0	1	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	215.7169	216.5319	216.1658	10	DWELLING	MR	0	BUSINESS	111310	GLAIZE ADD NAT'L AVE EXT L-20 6…	2016	234			CENTRAL AIR	GAS	UNDETERMINED	CONCRETE	COMP SHINGLE	VINYL	2023	1
2670	2670	51	840	89 LEE ST	WINCHESTER	VA	22601	LAMBERT LORETTA JANE	89 LEE ST	WINCHESTER	VA	22601	Winchester	96427	Winchester	000202	2.0200	540.5338	391100	110000	501100	219000	2003-12-17	1	1	1961	0	1	3	1	2	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	221.3390	223.4730	222.7223	10	DWELLING	MR	0.1405	PERSON		CARTER & GLAIZE SD L-16 W S 89 …	2003	6472			HEAT PUMP	GAS/ELECTRIC	HEAT PUMP	CONC/BLOCK	COMP SHINGLE	BRICK	2023	1
3175	3175	51	840	421 NATIONAL AVE	WINCHESTER	VA	22601	OLD TOWN PROPERTY GROUP LLC	861 REDBUD RD	WINCHESTER	VA	22603	Winchester	96427	Winchester	000102	1.0200	360.4522	136500	30000	166500		2025-02-28	1	1	1920	0	1	3	0	1	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	220.7189	222.1640	221.5493	10	DWELLING	HR1	0.0790	BUSINESS	2372	S S 421 NATIONAL AVENUE	2025	397			HOT WATER	GAS	UNDETERMINED	CONCRETE	COMP SHINGLE	STUCCO/MASONRY	2023	1
4237	4237	51	840	120 E PALL MALL ST	WINCHESTER	VA	22601	MURF PROPERTIES LLC	8560 GEORGETOWN PIKE	MCLEAN	VA	22102	Winchester	96427	Winchester	000301	3.0099	557.2151	162000	42000	204000		2026-02-27	2	2	1920	0	1	2	0	2	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	211.7389	216.0290	213.1039	30	DWELLING	HR1	0.1171	BUSINESS	23839	L-8 N S 120-122 EAST PALL MALL …	2026	399			BASEBOARD	ELECTRIC	UNDETERMINED	STONE	METAL/TIN	VINYL	2023	1
3898	3898	51	840	223 BAKER ST	WINCHESTER	VA	22601	AVBEL PROPERTIES LLC	8401 MAYLAND DR STE S	HENRICO	VA	23294	Winchester	96427	Winchester	000102	1.0200	109.6093	140800	10000	150800		2026-01-21	1	1	1927	6	1	2	0	1	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	224.9219	225.6490	225.2814	10	DWELLING	HR1	0.0170	BUSINESS	5312	S S 223 BAKER STREET	2026	131			BASEBOARD	ELECTRIC	UNDETERMINED	CONCRETE	COMP SHINGLE	WOOD/FRAME	2023	1
6506	6506	51	840	903 BERRYVILLE AVE	WINCHESTER	VA	22601	ROGERS ROSEMARY	903 BERRYVILLE AVE	WINCHESTER	VA	22601	Winchester	96427	Winchester	000101	1.0100	759.8068	331500	40500	372000	200000	2017-06-01	1	1	1930	3	1	3	0	2	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	215.8170	218.8569	217.6114	10	DWELLING	MR	0.2200	PERSON		HARRIS ADD L-32 S S 903 BERRYVI…	2017	1221			HEAT PUMP	ELECTRIC	HEAT PUMP	CONCRETE	COMP SHINGLE	STUCCO/MASONRY	2023	1
8103	8103	51	840	2640 WINDWOOD DR	WINCHESTER	VA	22601	BEARER ERIK D	2640 WINDWOOD DR	WINCHESTER	VA	22601	Winchester	96427	Winchester	000302	3.0200	1185.0359	460400	70000	530400	465000	2022-06-01	1	1	2001	3	1	4	1	2	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	249.8500	255.0269	252.9476	10	DWELLING	LR	0.2864	PERSON		WESTRIDGE S-2B L-49 E S 2640 WI…	2022	1371			CENTRAL AIR	GAS	UNDETERMINED	CONCRETE	COMP SHINGLE	VINYL	2023	1
7170	7170	51	840	648 BELLVIEW AVE	WINCHESTER	VA	22601	MELLEN GROUP LLC	PO BOX 1484	WINCHESTER	VA	22604	Winchester	96427	Winchester	000202	2.0200	1006.9760	390800	90000	480800	485000	2024-11-07	1	1	1986	1	1	3	1	2	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	246.0249	251.1479	249.0957	10	DWELLING	LR	0.2458	BUSINESS	4246	WILLIAMSBURG HGTS SD L-69 N S 6…	2024	2209			HEAT PUMP	ELECTRIC	HEAT PUMP	CONC/BLOCK	COMP SHINGLE	BRICK	2023	1
4411	4411	51	840	118 RICHARDS AVE	WINCHESTER	VA	22601	PIN HIGH III LLC	20 E 8TH ST	FRONT ROYAL	VA	22630	Winchester	96427	Winchester	000201	2.0099	574.9545	219600	58500	278100	162500	2026-03-30	1	1	1964	0	1	3	0	2	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	227.8880	230.5489	229.2173	10	DWELLING	MR	0.1566	BUSINESS	3325	N S 118 RICHARDS AVENUE	2026	623			CENTRAL AIR	GAS	UNDETERMINED	CONC/BLOCK	COMP SHINGLE	BRICK	2023	1
4103	4103	51	840	356 PARKWAY ST	WINCHESTER	VA	22601	CAMPBELL MICHAEL E	356 PARKWAY STREET	WINCHESTER	VA	22601	Winchester	96427	Winchester	000301	3.0099	696.9237	325600	70000	395600		2013-01-01	1	1	1970	1	1	3	0	2	51069C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	213.5269	214.8339	214.5772	10	DWELLING	MR	0	PERSON		SHAWNEE HGTS SD B-D L-35 E S 35…	2000	0			HEAT PUMP	ELECTRIC	HEAT PUMP	CONC/BLOCK	COMP SHINGLE	WOOD/FRAME	2023	1