Saved query 9a5f24b170f67d0d

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

44,455 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	agvalue	totalvalue	saleamt	saledate	numbldgs	numunits	yearbuilt	bldgsqft	bedrooms	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	zoningdesc	taxacres	ownertype	naicscode	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
079 03-06-04 00-0000	34370	51	770	3504 BANDY RD	ROANOKE	VA	24014	GARDEN CITY BRETHREN CHURCH	3504 BANDY RD SE	ROANOKE VA	VA	24014	ROANOKE	95363	ROANOKE	002800	28	8676.9494	672300	200	-76700	825900			1	1	1960	7415	0	0	0	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	351.8740	366.9620	361.2340	NO	OTHER	COUNTY-R1.PDF	LOW DENSITY RESIDENTIAL	2.1439	NONPROFIT	813110	FRONTS ON GARNAND RD						GARDEN CITY BIBLE FELLOWSHIP	RELIGIOUS_ORGANIZATION	CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONTINUOUS FOOTING	ARCHITECTURAL SHINGLES	FACE BRICK	2026.2	2026	ROANOKE COUNTY
061 02-02-16 00-0000	21850	51	770	132 BLUE RIDGE PKWY	BENT MOUNTAIN	VA	24059	DEPARTMENT OF THE INTERIOR	XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX…	XXXXXXXXXXXXXXXXXXXXXXXXX XX	VA	99999	ROANOKE	95363	ROANOKE			11005755.2473	-16663300	99100	-17525900	18487600			6	1	1970	2193	0	0	0	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				NO	GOVERNMENT	COUNTY-EP.PDF	EXPLORE PARK DISTRICT	2719.3018	GOVERNMENT	71212	BLUE RIDGE PARKWAY ROANOKE MAIN…			GOVT LOCAL	OPEN	OTHER	POAGES MILL OVERLOOK	HISTORIC_SITE	CENTRAL AIR	WOOD	OTHER	SPREAD FOOTING	RUBBER	CONCRETE BLOCK	2026.2	2026	ROANOKE COUNTY
4340549	4340549	51	770	1582 GORDON AVE SE	ROANOKE	VA	24014	CROMWELL JOHN E BARBARA J	1582 GORDON AVE SE	ROANOKE	VA	24014	ROANOKE	95363	ROANOKE	002800	28	918.9179	129800	31800		161600		2026-05-16	1	1	1972	9847				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	282.0546	283.1740	282.4263	200-SINGLEFAMILY	R-5	R-5	R-5	0.2261	PERSON		LOT 49-A BLK 5 RIVERDALE	CONV000000							CENTRAL AIR	GAS	UNDETERMINED				2026.2	1012026
1570218	1570218	51	770	3211 COLONIAL AVE SW	ROANOKE	VA	24018	MILLER ADAM L	3211 COLONIAL AVE SW	ROANOKE	VA	24018	ROANOKE	95363	ROANOKE	003000	30	3115.0460	199600	64600		264200	134500	2018-08-30	1	1		33584				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	333.6877	345.1328	340.6737		200-SINGLEFAMILY		R-7	0.7709	PERSON	81291	ACREAGE BENT MOUNTAIN RD						BIG DOG CANINE BEHAVIORAL TRAIN…	ANIMAL_OR_PET_SERVICE							2026.2	1012026
1280321	1280321	51	770	2734 COLONIAL AVE SW	ROANOKE	VA	24018	WINTER PROPERTIES PARTNERSHIP L…	3640 COLONIAL COURT DR	ROANOKE	VA	24018	ROANOKE	95363	ROANOKE	003000	30	12495.3359	2228400	465800		2694200	1750000	2022-12-01	1	1		134438				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	301.5033	309.9971	308.2220		400-COMMERCIAL/INDUSTRIAL		I-1	3.0862	BUSINESS	531130	ACREAGE NELSON MAP						WINTER'S STORAGE	SELF-STORAGE FACILITY							2026.2	1012026
1280603	1280603	51	770	2743 FRANKLIN RD SW	MOUNT PLEASANT	VA	29464	ZRP ROANOKE STORAGE LLC	TIMOTHY J WALTER	MOUNT PLEASANT	SC	29464	ROANOKE	95363	ROANOKE	003000	30	14160.9339	4436600	1328100		5764700	2500000	2022-02-21	2	1		152613				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	298.2114	312.5087	302.8499		400-COMMERCIAL/INDUSTRIAL		CG	3.5034	BUSINESS	531130	ACREAGE FRANKLIN ROAD						PUBLIC STORAGE	SELF-STORAGE FACILITY							2026.2	1012026
1110704	1110704	51	770	0 NORFOLK AVE SW	ROANOKE	VA	24016	SIX MIGS LLC	523 NORFOLK AVE SW	ROANOKE	VA	24016	ROANOKE	95363	ROANOKE	001000	10	308.6075		6900		6900		2013-04-24	1	1		3312				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	287.6689	289.6781	288.9022	140-COMMERCIAL VACANT	I-1	I-1	I-1	0.0760	BUSINESS	3335	LOT 5 BLK 1 SEC S W 7 O S	130004748	090012358												2026.2	1012026
7050111	7050111	51	770	201 BERKLEY RD NE	NEW YORK	VA	10017	AGAP ROANOKE LLC	ANDOVER PROPERTIES LLC	NEW YORK	NY	10017	ROANOKE	95363	ROANOKE	000602	6.0199	30856.1953	3430700	97100		3527800	4115000	2020-08-12	10	1		315950				51161C	2026-01-08	AE		280.3577	293.6156	285.2405		400-COMMERCIAL/INDUSTRIAL		I-1	7.2529	BUSINESS	531130	PARCEL A GLADE CREEK						STORAGE KING USA	SELF-STORAGE FACILITY							2026.2	1012026
5160107	5160107	51	770	0 LAKE DR SW	ROANOKE	VA	24018	SPRING VALLEY LAKE LLC ETALS	CLAY TAYLOR	ROANOKE	VA	24018	ROANOKE	95363	ROANOKE	002100	21	250.0063		500		500		2007-01-17	1	1		2726				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	318.9135	321.7365	320.7914	100-VACANT LAND	R-12	R-12	R-12	0.0626	BUSINESS	3326	ACREAGE SO ROANOKE RIVER	070001301	060017208												2026.2	1012026
4021001	4021001	51	770	907 4TH ST SE	ROANOKE	VA	24013	FAN CONVENIENCE LC	909 4TH ST SE	ROANOKE	VA	24013	ROANOKE	95363	ROANOKE	002700	27	9996.2216	1221300	260800		1482100	928785	2006-12-15	4	1		107272				51161C	2026-01-08	AE		280.5910	288.2202	281.9603		400-COMMERCIAL/INDUSTRIAL		I-1	2.4625	BUSINESS	531130	NEW LOT 20A BLK 2 KOONTZ MAP						A FRIENDLY STORAGE -DISCOUNT ST…	SELF-STORAGE FACILITY							2026.2	1012026
2331908	2331908	51	770	2102 MERCER AVE NW	ROANOKE	VA	24017	WTS ENTERPRISES LLC	2601 PETERS CREEK RD NW	ROANOKE	VA	24017	ROANOKE	95363	ROANOKE	002400	24	603.9810	132900	17600		150500	155000	2023-11-20	1	1		6499				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	319.8298	322.3001	321.3397		200-SINGLEFAMILY		R-5	0.1492	BUSINESS	42373	LOT 8 BLK 90 MELROSE														2026.2	1012026
2332404	2332404	51	770	1620 MERCER AVE NW	ROANOKE	VA	24015	KAIROS PROPERTIES LLC	701 BRANDON AVE	ROANOKE	VA	24015	ROANOKE	95363	ROANOKE	002400	24	603.9912	115100	17600		132700	926000	2021-08-09	1	1		6501				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	308.4964	314.2850	311.3387		200-SINGLEFAMILY		R-5	0.1492	BUSINESS	531311	LOT 4 BLK 49 MELROSE														2026.2	1012026
6090438	6090438	51	770	921 PECK ST NW	CHESTERFIELD	VA	23838	HD INVESTMENT PROPERTIES LLC	12712 BALLATER PL	CHESTERFIELD	VA	23838	ROANOKE	95363	ROANOKE	002200	22	1030.8445	138300	32000		170300	875000	2022-04-21	2	1		11128				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	343.9538	346.5966	345.2852		200-SINGLEFAMILY		R-7	0.2555	BUSINESS	2372	NEW LOT 25A-1 E L CO														2026.2	1012026
6370301	6370301	51	770	2115 PETERS CREEK RD NW	WINSTON SALEM	VA	27120	PARKS HOLDINGS LLC	PO BOX 21284	WINSTON SALEM	NC	27120	ROANOKE	95363	ROANOKE	002302	23.0200	2354.9896	62400	123400		185800	266000	2022-09-12	1	1		25432				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	318.5677	327.8521	323.5172		200-SINGLEFAMILY		CG	0.5838	BUSINESS	551112	58 ACRES E J HARTMAN														2026.2	1012026
4120610	4120610	51	770	608 8TH ST SE	ROANOKE	VA	24011	SOUTHERN ESTATES LLC	410 FIRST ST SW	ROANOKE	VA	24011	ROANOKE	95363	ROANOKE	002700	27	341.1045	7100	13500		20600	12000	2018-03-14	1	1		3658				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	293.4198	295.4076	294.6499		200-SINGLEFAMILY		RM-2	0.0840	BUSINESS	53119	PT L 1-2 BLK 18 BELMONT														2026.2	1012026
060 10-01-09 00-0000	19846	51	770	0 DALETON AVE	VINTON	VA	24179	VINTON SCRAP & METALS COMPANY	C/O OMNISOURCE CORP	7575 W JEFFERSON BLVD	VA	46804	ROANOKE	95363	ROANOKE	000602	6.0199	150.2484		800			1200		1							51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	291.2720	292.9256	292.1920	NO	COMMERCIAL	VINTON-M2.PDF	GENERAL INDUSTRIAL DISTRICT	0.0371	BUSINESS	3335	PT LT 10 SEC 3 JACKSON PARK ADD…														2026.2	2026	TOWN OF VINTON
060 10-01-10 00-0000	19847	51	770	0 DALETON AVE	VINTON	VA	24179	VINTON SCRAP & METALS COMPANY	C/O OMNISOURCE CORP	7575 W JEFFERSON BLVD	VA	46804	ROANOKE	95363	ROANOKE	000602	6.0199	450.9007		1800			31000		1							51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	291.7232	293.3367	292.6849	NO	COMMERCIAL	VINTON-M2.PDF	GENERAL INDUSTRIAL DISTRICT	0.1114	BUSINESS	3335	PT LT 11 12 13 SEC 3 JACKSON PA…														2026.2	2026	TOWN OF VINTON
4112806	4112806	51	770	1013 STEWART AVE SE	BETHLEHEM	VA	18018	JAMILCO INC	PO BOX 4548	BETHLEHEM	PA	18018	ROANOKE	95363	ROANOKE	002600	26	483.2464	76100	15000		91100		2009-01-12	1	1		5146				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	282.8254	283.7487	283.3456		300-MULTIFAMILY		RM-1	0.1181	BUSINESS	31123	LOT 6 BLK 6 BELMONT														2026.2	1012026
3341011	3341011	51	770	1717 19TH ST NE	ROANOKE	VA	24012	YOUNG KATELYN ANN	1717 19TH ST NE	ROANOKE	VA	24012	ROANOKE	95363	ROANOKE	000601	6.0100	464.6126	138400	29000		167400	161400	2022-09-07	1	1		5001				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	305.6870	307.9770	306.7128		200-SINGLEFAMILY		RM-1	0.1148	PERSON		LOT 11 BLK 8 EAST GATE														2026.2	1012026
4021318	4021318	51	770	637 MOUNTAIN AVE SE	ROANOKE	VA	24013	LAWSON JANET	637 MOUNTAIN AVE SE	ROANOKE	VA	24013	ROANOKE	95363	ROANOKE	002700	27	483.6097	90900	24900		115800	69000	2003-09-09	1	1		5214				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	306.9948	310.0198	308.1586		200-SINGLEFAMILY		RM-1	0.1197	PERSON		LOT 20 BLK 32 BEL														2026.2	1012026
5170202	5170202	51	770	4315 CRAVENS CREEK RD SW	ROANOKE	VA	24018	WHITHAM MICHAEL E	4315 CRAVENS CREEK RD SW	ROANOKE	VA	24018	ROANOKE	95363	ROANOKE	002100	21	2779.1817	230100	71700		301800	323000	2026-02-10	1	1		29912				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	316.7540	324.4770	319.6375		200-SINGLEFAMILY		R-12	0.6867	PERSON		LOT 5C BELLE AIR														2026.2	1012026
2102103	2102103	51	770	3319 CRITTENDON AVE NW	ROANOKE	VA	24012	LEMUS OSCAR A DIAZ	3319 CRITTENDON AVE NW	ROANOKE	VA	24012	ROANOKE	95363	ROANOKE	000400	4	1308.2781	230100	45700		275800	169950	2021-06-17	1	1		14163				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	326.7775	328.3442	327.7272		200-SINGLEFAMILY		R-7	0.3251	PERSON		LOT 3 SECT 10 BLK 21 FLEMING OA…														2026.2	1012026
1290405	1290405	51	770	1035 BEECHWOOD DR SW	ROANOKE	VA	24014	JOHNSON TAYLOR C	1035 BEECHWOOD DR SW	ROANOKE	VA	24014	ROANOKE	95363	ROANOKE	003000	30	623.8449	149500	26800		176300	165900	2023-03-15	1	1		6729				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	305.3329	310.3322	308.5397		200-SINGLEFAMILY		R-5	0.1545	PERSON		LOT 9 BLK 4 BEECHWOOD GARDENS														2026.2	1012026
4120818	4120818	51	770	1018 BULLITT AVE SE	ROANOKE	VA	24017	HUNT NAHDIJAH JAWANNA	C O HABITAT FOR HUMANITY	ROANOKE	VA	24017	ROANOKE	95363	ROANOKE	002700	27	616.2583	212100	16500		228600	230000	2025-02-26	1	1		6629				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	285.7539	287.2975	286.5157		200-SINGLEFAMILY		RM-1	0.1522	PERSON		PT LOTS 20 21 BLK 16 BELMONT														2026.2	1012026
3151306	3151306	51	770	510 MAPLETON AVE NE	ROANOKE	VA	24012	MARTINEZ MARIA L	510 MAPLETON AVE NE	ROANOKE	VA	24012	ROANOKE	95363	ROANOKE	000500	5	794.0282	185000	36600		221600	173099	2022-02-24	2	1		8565				51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	314.4363	317.6720	316.4161		200-SINGLEFAMILY		R-5	0.1966	PERSON		LOT 6 SECT 2 BLK 7 MAPLETON HGTS														2026.2	1012026