Saved query 39fe89a285523808

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

3,159 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	saledate	numbldgs	yearbuilt	bldgsqft	bedrooms	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usedesc	taxacres	ownertype	naicscode	legaldesc	book	parceltype	accesstype	placename	placetype	heating	heatfuel	cooling	foundation	roofcover	siding
22 1 37F	2784	51	678	303 WHITE ST	LEXINGTON	VA	24450	HOLSTEAD, THOMAS SCOTT	5335 BORDLEY DR	Lexington	94275	Lexington	930501	9305.0100	1985.5640	121500	30500	152000	149000	2021-08-04	1	1991	1183	4	0	2	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	307.7536	315.2571	313.2094	TOWNHOUSE/CONDO	0.0470	PERSON	6211	WOODS CREEK APARTMENTS	53			COUNTY OF ROCKBRIDGE HEALTH DEP…	GOVERNMENT_OFFICE	HEAT PUMP	ELECTRIC	HEAT PUMP	Cinderblock	Comp Shingle-Asph	Vinyl
29 1 46	1919	51	678	105 HOUSTON ST	LEXINGTON	VA	24450	ZORDANI, ROBERT A	105 HOUSTON ST	Lexington	94275	Lexington	930501	9305.0100	3841.3491	340800	100000	440800	475000	2021-06-11	1	1888	3016	3	0	2	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	335.0452	341.3952	338.8560	DWELLING	0.9800	PERSON	4595	LOT APPROX 107 X 400	58			Z AND K ANTIQUES	SECOND_HAND_STORE	CENTRAL AIR	GAS	OTHER	Brick	Metal	Frame
29 1 32A	1901	51	678	108 HOUSTON ST	LEXINGTON	VA	24450	CHCT VIRGINIA, LLC	14400 METCALF AVENUE	Lexington	94275	Lexington	930501	9305.0100	1241.8952	2782100	120000	2902100	3101300	2021-01-25	1	2000	15630	0	0	0	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	332.2528	335.8130	333.9414	COMMERCIAL	0.2900	BUSINESS	621340	108 HOUSTON ST	71			BODY EASE PHYSICAL THERAPY	PHYSICAL_MEDICINE_AND_REHABILIT…	HEAT PUMP	ELECTRIC	HEAT PUMP	Cinderblock	Comp Shingle-Asph	Brick
30 1 8	2041	51	678	0 E NELSON ST	LEXINGTON	VA	24450	FOUR M PROPERTIES LLC	5228 BELVA RD	Lexington	94275	Lexington	930501	9305.0100	7595.1127	355200	376900	732100		2010-12-27	1	1976	2293	0	0	2	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	318.5821	325.6097	320.6649	COMMERCIAL	0.7210	BUSINESS	722511	LOTS 8 & 8B - E NELSON	20			LEXINGTON FRANK'S PIZZA AND SUBS	RESTAURANT	CENTRAL AIR	GAS	OTHER	Concrete	Tarpaper/Roll	Brick
16 1 51	301	51	678	19 W WASHINGTON ST	LEXINGTON	VA	24450	GONSALVES, SHANE B	19 W WASHINGTON ST	Lexington	94275	Lexington	980000	9800	371.8870	222600	148800	371400	375000	2021-11-12	1	1920	3990	1	2	1	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	312.9800	314.6153	313.9330	COMMERCIAL	0.0853	PERSON	7225	19 W WASHINGTON ST	10			SWEET TREATS BAKERY	CASUAL_EATERY	CENTRAL AIR	GAS	OTHER	Rock	Metal	Brick
23 1 79	1034	51	678	31 S MAIN ST	LEXINGTON	VA	24450	FOUR M PROPERTIES LLC	5228 BELVA RD	Lexington	94275	Lexington	930501	9305.0100	1143.0864	300800	518000	818800		2010-12-27	1	0	6200	0	0	0	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	313.3233	320.0432	316.9500	COMMERCIAL	0.2882	BUSINESS	5312	31-35 S MAIN ST	17			AGENT CLARA	REAL_ESTATE_SERVICE	HOT WATER	GAS	OTHER	Rock	Metal	Brick
22 8 3	2545	51	678	0 HIGHLAND RD		VA	24450	CITY OF LEXINGTON	300 E WASHINGTON STREET	Lexington	94275	Lexington	930501	9305.0100	672.2215	475400	357500	832900			1	1960	3040	0	0	0	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	310.3865	316.5744	313.1940	EXEMPT	6.5000	GOVERNMENT	81293	LOTS 1 3-13 & 15-25	0	GOVT LOCAL	OPEN	WOODS CREEK PARK & LIME KILN BR…	LOCAL PARK	CENTRAL AIR	GAS	OTHER	Cinderblock	Comp Shingle-Asph	Brick
29 1 6	1873	51	678	506 S MAIN ST		VA	24450	HUGHES, ROBERT W & CHERYL L	506 S MAIN ST	Lexington	94275	Lexington	930501	9305.0100	1612.1293	796300	100000	896300	800000	2016-07-13	1	1890	59865	4	2	2	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	334.9095	337.6747	336.6957	DWELLING	0.3900	PERSON	721191	LOT 6 S MAIN ST	82			GRACE HOUSE BED AND BREAKFAST	BED_AND_BREAKFAST	HOT WATER	GAS	OTHER	Rock	Metal	Brick
19 1 1	686	51	678	890 SHOP RD	LEXINGTON	VA	24450	CITY OF LEXINGTON	300 E WASHINGTON STREET	Lexington	94275	Lexington	930501	9305.0100	32926.9533	512500	194000	706500			1	2007	1920	0	2	0	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	306.4752	316.9066	312.6370	EXEMPT	10.4000	GOVERNMENT	921110	LOTS 1 & 2	0			LEXINGTON PUBLIC WORKS DEPARTME…	GOVERNMENT_OFFICE	HEAT PUMP	ELECTRIC	HEAT PUMP	Slab	Comp Shingle-Asph	Vinyl
29 11 15	1978	51	678	130 HOUSTON ST	LEXINGTON	VA	24450	STEELE LEXINGTON LLC	6875 E EVANS AVE	Lexington	94275	Lexington	930501	9305.0100	741.8736	3889600	247500	4137100	4250000	2020-03-13	1	1977	48632	0	0	0	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	333.6086	336.3039	335.7785	APARTMENT	1.9800	BUSINESS	3391	LOTS 9 THRU 19	44					HEAT PUMP	ELECTRIC	HEAT PUMP	Cinderblock	Comp Shingle-Asph	Brick
28 21 26	1836	51	678	511 S MAIN ST	LEXINGTON	VA	24450	CLI HOLDINGS LLC	P O BOX 21384-7878	Lexington	94275	Lexington	930501	9305.0100	1417.4366	415200	120000	535200	180000	2013-10-15	1	1870	55776	5	0	6	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	331.0523	334.4198	332.4407	DWELLING	0.3800	BUSINESS	551112	LOT 93 X 180	34					HOT WATER	GAS	OTHER	Rock	Comp Shingle-Asph	Brick
23 1 200	1160	51	678	7 N MAIN ST	LEXINGTON	VA	24450	ANNIE P. LLC	4601 LILAC LANE	Lexington	94275	Lexington	930501	9305.0100	308.5709	309600	192200	501800	525000	2017-06-20	1	1939	3590	0	0	0	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	315.0074	317.8233	315.9269	COMMERCIAL	0.0801	BUSINESS	4911	7 N MAIN ST	39					HOT WATER	GAS	OTHER	Cinderblock	Metal	Brick
29 1 28A	1897	51	678	407 SPOTSWOOD DR	LEXINGTON	VA	24450	VARGO TTES, JAMES E & DORIS A	407 SPOTSWOOD DR	Lexington	94275	Lexington	930501	9305.0100	1810.5699	228800	70000	298800	295000	2021-01-08	1	1987	17008	3	0	2	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	326.7371	331.6779	328.9411	DWELLING	0.4600	PERSON		20,070 SQ FT	79					CENTRAL AIR	GAS	OTHER	Cinderblock	Comp Shingle-Asph	Cedar
23 1 28	979	51	678	303 S JEFFERSON ST	LEXINGTON	VA	24450	BRENNAN, LOUISE G	303 S JEFFERSON ST	Lexington	94275	Lexington	930501	9305.0100	3645.9033	490000	190000	680000	305500	2006-05-12	1	1850	35199	4	0	3	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	330.2914	333.8348	332.8580	DWELLING	0.9500	PERSON		LOT 133 X 310	0					HOT WATER	GAS	OTHER	Brick	Metal	Brick
23 1 249	1216	51	678	108 MOORE ST	LEXINGTON	VA	24450	HOWSON, RUSSEL F & BETHANY E	343 WHEATLAND RD	Lexington	94275	Lexington	930501	9305.0100	714.4151	103400	35000	138400	80000	2019-04-10	1	1972	1080	4	0	1	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	318.8363	323.0167	320.8267	DWELLING	0.1700	PERSON		LOT APPROX 50 X 145	33					CENTRAL AIR	GAS	OTHER	Cinderblock	Comp Shingle-Asph	Frame
17 1 99	421	51	678	413 N RANDOLPH ST	LEXINGTON	VA	24450	GRAYBILL, MARK H	P O BOX 50	Lexington	94275	Lexington	930501	9305.0100	791.7461	169200	35000	204200	110000	2006-07-14	1	1897	23236	4	0	1	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	307.8659	315.0214	311.8690	DWELLING	0.1800	PERSON		413 N RANDOLPH ST	0					CENTRAL AIR	GAS	OTHER	Concrete	Comp Shingle-Asph	Vinyl
28 14 8	1786	51	678	14 MAPLE LN	LEXINGTON	VA	24450	BERRY, JAMES J & KAY B	14 MAPLE LANE	Lexington	94275	Lexington	930501	9305.0100	1532.9997	241300	60000	301300	317000	2019-06-14	1	1953	19624	3	1	2	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	333.5700	336.1720	335.7556	DWELLING	0.3900	PERSON		WASHINGTON HGTS SBDV	137					CENTRAL AIR	GAS	OTHER	Concrete	Comp Shingle-Asph	Frame
29 10 2	1969	51	678	6 HILL CIR	LEXINGTON	VA	24450	MARKS CO-TTES, RICHARD G & WALA…	312 ENFIELD RD	Lexington	94275	Lexington	930501	9305.0100	552.5558	131300	50000	181300		2019-07-18	1	1959	1326	3	0	2	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	331.5423	333.5367	332.2870	DWELLING	0.1400	BUSINESS	7114	LOT 90 X 65	7					HOT WATER	GAS	OTHER	Cinderblock	Comp Shingle-Asph	Frame
40 3 3 11	2460	51	678	908 SHENANDOAH RD	LEXINGTON	VA	24450	DIETTE, TIMOTHY M & COURTNEY L	908 SHENANDOAH RD	Lexington	94275	Lexington	930501	9305.0100	1540.3238	307900	70000	377900	295000	2015-10-19	1	1978	27238	4	1	3	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	351.3942	355.6634	353.2915	DWELLING	0.3900	PERSON		THORNRIDGE ESTATES SUBDV	20					CENTRAL AIR	GAS	OTHER	Brick	Comp Shingle-Asph	Vinyl
23 1 4	954	51	678	110 MYERS ST	LEXINGTON	VA	24450	COLLINS, OWEN M	110 MYERS ST	Lexington	94275	Lexington	930501	9305.0100	867.8923	191700	95000	286700	280000	2006-06-30	1	1910	2008	4	0	2	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	322.1847	327.2564	325.1481	DWELLING	0.2100	PERSON		LOT 62.5 X 148.75	0					HOT WATER	GAS	OTHER	Rock	Metal	Vinyl
28 1 13	1641	51	678	2 MAPLE LN	LEXINGTON	VA	24450	KERIN, MELISSA R	2 MAPLE LANE	Lexington	94275	Lexington	930501	9305.0100	849.8771	212200	55000	267200	256000	2015-03-26	1	1910	1800	3	0	2	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	333.7901	336.0794	334.9099	DWELLING	0.1900	PERSON		2 MAPLE LANE	21					HOT WATER	GAS	OTHER	Concrete	Metal	Brick
8 1 1 11	5	51	678	11 SIXTY WEST DR	LEXINGTON	VA	24450	FRIDLEY JR, HARRISON L & TERRY G	11 SIXTY WEST DR	Lexington	94275	Lexington	930501	9305.0100	535.4818	389000	60000	449000	429000	2011-10-03	1	1996	28134	3	1	2	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	338.3826	338.9356	338.7851	DWELLING	0.1300	PERSON		SIXTY WEST SBDV	61					CENTRAL AIR	GAS	OTHER	Cinderblock	Comp Shingle-Asph	Frame
34 2 A1	2246	51	678	811 S MAIN ST	LEXINGTON	VA	24450	BECHELBRONN CO INC	218 S MAIN ST, STE A	Lexington	94275	Lexington	930501	9305.0100	1679.0254	327800	105000	432800	255000		1	1964	4406	0	0	4	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	332.3119	337.8933	335.6019	APARTMENT	0.6400	BUSINESS	3351	LEE PARK APTS	660					HOT WATER	GAS	OTHER	Concrete	Comp Shingle-Asph	Brick
23 1 32	983	51	678	110 W MCDOWELL ST	LEXINGTON	VA	24450	MCGINTY, JANE E & WILLIAM J	7239 PLOVERS WAY	Lexington	94275	Lexington	930501	9305.0100	1099.6475	310900	130000	440900	375000	2018-01-11	1	1857	3059	4	0	3	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	329.3848	331.6004	330.1576	DWELLING	0.3000	PERSON		95 X 136	52					HEAT PUMP	GAS/ELECTRIC	HEAT PUMP	Brick	Metal	Brick
29 4 21	1942	51	678	512 TAYLOR ST	LEXINGTON	VA	24450	WALLACE, RICHARD L	512 TAYLOR ST	Lexington	94275	Lexington	930501	9305.0100	1198.4575	483500	60000	543500	581000	2021-07-30	1	1859	2905	4	0	4	51163C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	337.4478	341.5496	339.9422	DWELLING	0.5300	PERSON		LOTS 21 & 22	55					HOT WATER	GAS	OTHER	Rock	Metal	Vinyl