Saved query dad28acd60b0389c

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

44,465 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	bldgsqft	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	taxyear
1030509	1030509	51	770	1307 3RD ST SW	ROANOKE	VA	24016	LANDES LLC	1309 THIRD ST SW	ROANOKE	VA	24016	ROANOKE	95363	ROANOKE	001200	12	1017.7270	197500	102600	300100	295000	2024-07-19	1	1	1989	10980	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	297.3333	301.0591	299.7607	400-COMMERCIAL/INDUSTRIAL	MX	MX	MX	0.2521	BUSINESS	487210	LOT 9 BLK 1 O S SEC S W 4	240006828	UNLINK PAR				STILL WATER FLOATATION	WELLNESS_SERVICE	UNDETERMINED	UNDETERMINED	UNDETERMINED	1012026
1111315	1111315	51	770	501 SALEM AVE SW	RICHMOND	VA	23226	SUNLIGHT BAKERY BUILDING LLC	5806 GROVE AVE 108	RICHMOND	VA	23226	ROANOKE	95363	ROANOKE	001000	10	2544.7840	44700	175800	220500	775000	2025-01-27	1	1	1925	27418	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	288.3047	289.9196	289.0940	400-COMMERCIAL/INDUSTRIAL	D	D	D	0.6294	BUSINESS	31123	TRACT A-3 SECT SW 7 OS	250000815	250000802						UNDETERMINED	UNDETERMINED	UNDETERMINED	1012026
3090606	3090606	51	770	124 AVENDALE AVE NE	LYNCHBURG	VA	24503	JCWT LLC	2451 HAWKINS MILL RD	LYNCHBURG	VA	24503	ROANOKE	95363	ROANOKE	000500	5	669.1444	187100	27600	214700	349950	2022-06-24	1	1	1988	7204	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	302.4920	303.6773	303.0186	MULTI-FAMILY DUPLEX	RMF	RMF	RMF	0.1654	BUSINESS	4251	LOT 8 BLK 2 AVENDALE	220007641	130004085						CENTRAL AIR	GAS	UNDETERMINED	1012026
4041413	4041413	51	770	1346 WOODBINE ST SE	ROANOKE	VA	24014	ENDURANCE FRANKLIN LLC	2707 ROSALIND AVE SW	ROANOKE	VA	24014	ROANOKE	95363	ROANOKE	002800	28	650.4036	99100	41400	140500	60000	2019-08-07	1	1	1952	7006	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	310.1622	324.7901	317.7701	200-SINGLEFAMILY	R-5	R-5	R-5	0.1608	BUSINESS	23813	LOT 6 PT ALLEY HUGHSON WHITE	190007924	190000213						CENTRAL AIR	OIL	UNDETERMINED	1012026
1560404	1560404	51	770	2417 ALBERTA AVE SW	ROANOKE	VA	24015	BAKER MATTHEW W	2417 ALBERTA AVE SW	ROANOKE	VA	24015	ROANOKE	95363	ROANOKE	003100	31	799.3145	295400	50700	346100	335000	2024-03-06	2	1	1936	8629	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	335.8694	341.6132	339.1266	200-SINGLEFAMILY	R-5	R-5	R-5	0.1981	PERSON		LOT 2 BLK 11 GRANDIN CT ANX	240004373	220009001						STEAM	UNDETERMINED	UNDETERMINED	1012026
4221205	4221205	51	770	1721 KENWOOD BLVD SE	ROANOKE	VA	24013	WELTY SAMANTHA	1721 KENWOOD BLVD SE	ROANOKE	VA	24013	ROANOKE	95363	ROANOKE	002700	27	329.1257	102600	25500	128100	105500	2021-08-04	1	1	1914	3493	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	287.7381	293.9476	290.9824	200-SINGLEFAMILY	RM-1	RM-1	RM-1	0.0801	PERSON		LOT 5 BLK 12 WAVERLY	210010929	060003983						CENTRAL AIR	GAS	UNDETERMINED	1012026
2201203	2201203	51	770	5149 HAZELRIDGE RD NW	ROANOKE	VA	24012	BRAGG JEFFREY L JENNIFER E	5149 HAZELRIDGE RD NW	ROANOKE	VA	24012	ROANOKE	95363	ROANOKE	000400	4	812.9766	168700	37800	206500	75200	2003-01-30	1	1	1957	8772	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	329.4057	334.5608	332.1479	200-SINGLEFAMILY	R-7	R-7	R-7	0.2014	PERSON		LOT 13 BLK 9 BOWLING GREEN NO 2	0030001786	0020000599						CENTRAL AIR	GAS	UNDETERMINED	1012026
2221309	2221309	51	770	1229 ORANGE AVE NW	ROANOKE	VA	24017	MACK NAYMON MARY L	1320 MELROSE AVE NW	ROANOKE	VA	24017	ROANOKE	95363	ROANOKE	002400	24	627.9578	55700	15100	70800	6000	1987-09-08	1	1	1925	6767	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	296.3504	298.8851	297.4514	200-SINGLEFAMILY	RM-1	RM-1	RM-1	0.1553	PERSON		LOT 9 BLK 19 MELROSE	CONV000000	CONV000000						CENTRAL AIR	OIL	UNDETERMINED	1012026
4360425	4360425	51	770	1336 THOMASON RD SE	ROANOKE	VA	24014	PILCHER MICHAEL	1336 THOMASON RD SE	ROANOKE	VA	24014	ROANOKE	95363	ROANOKE	002800	28	1054.6787	162000	36000	198000	82000	2016-05-10	2	1	1915	11302	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	285.8265	287.6052	286.6676	200-SINGLEFAMILY	RM-1	RM-1	RM-1	0.2595	PERSON		LOT A J C GARNAND	160004440	160000476						HEAT PUMP	ELECTRIC	HEAT PUMP	1012026
2771609	2771609	51	770	4010 TENNESSEE AVE NW	ROANOKE	VA	24017	RICHARDSON JARED	4010 TENNESSEE AVE NW	ROANOKE	VA	24017	ROANOKE	95363	ROANOKE	000100	1	604.0710	114300	23600	137900	170000	2023-10-02	1	1	1948	6515	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	336.5280	342.0255	338.8556	200-SINGLEFAMILY	R-5	R-5	R-5	0.1496	PERSON		LOT 9 BLK 9 W C L CO	230007921	230000148						CENTRAL AIR	ELECTRIC	UNDETERMINED	1012026
2010501	2010501	51	770	532 FAIRFAX AVE NW	ROANOKE	VA	24018	F F INVESTMENT GROUP	PO BOX 20501	ROANOKE	VA	24018	ROANOKE	95363	ROANOKE	002501	25.0100	338.0026	86300	10900	97200	21400	2015-12-18	1	1	1890	3646	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	288.7671	296.7722	292.5008	200-SINGLEFAMILY	RM-1	RM-1	RM-1	0.0837	PERSON		LOT 1 BLK 15 R F H	150012599	150004610						CENTRAL AIR	OIL	UNDETERMINED	1012026
1610405	1610405	51	770	2720 DERWENT DR SW	ROANOKE	VA	24015	CULLEY NELSON G	2720 DERWENT DR SW	ROANOKE	VA	24015	ROANOKE	95363	ROANOKE	001900	19	785.1714	130900	49500	180400	123000	2007-08-17	1	1	1950	8438	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	328.7847	332.2818	330.9712	200-SINGLEFAMILY	R-7	R-7	R-7	0.1937	PERSON		LOT 3 BLK 6 LEE HY GARDENS	070014978	060000807						CENTRAL AIR	GAS	UNDETERMINED	1012026
2751001	2751001	51	770	863 WESTSIDE BLVD NW	ROANOKE	VA	24017	SPRIGGS CARL L	863 WESTSIDE BLVD NW	ROANOKE	VA	24017	ROANOKE	95363	ROANOKE	000900	9	1552.7294	153300	46300	199600	169950	2023-09-28	1	1	1949	16605	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	311.1361	316.9491	313.4025	200-SINGLEFAMILY	RM-1	RM-1	RM-1	0.3812	PERSON		TT LOT 6 PETERS CREEK BAYSE	230007831	230000348						CENTRAL AIR	GAS	UNDETERMINED	1012026
4110809	4110809	51	770	1401 CAMPBELL AVE SE	ROANOKE	VA	24013	AGUILAR MARIO ARENAS	1401 CAMPBELL AVE SE	ROANOKE	VA	24013	ROANOKE	95363	ROANOKE	002600	26	278.8937	115500	8200	123700	25000	2023-02-06	1	1	1910	2919	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	289.8276	293.6020	291.8514	200-SINGLEFAMILY	RM-1	RM-1	RM-1	0.0670	PERSON		LOT 25 BLK 14 E S L	230001237	150011058						CENTRAL AIR	GAS	UNDETERMINED	1012026
2221807	2221807	51	770	1406 ORANGE AVE NW	ROANOKE	VA	24017	BASHAM BARBARA	1406 ORANGE AVE NW	ROANOKE	VA	24017	ROANOKE	95363	ROANOKE	002501	25.0100	603.6998	98100	15100	113200		2026-05-16	1	1	1905	6499	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	295.8195	296.6019	296.1696	200-SINGLEFAMILY	RM-1	RM-1	RM-1	0.1492	PERSON		LOT 7 BLK 36 MEL	CONV000000							CENTRAL AIR	GAS	UNDETERMINED	1012026
4470101	4470101	51	770	0 GARDEN CITY BV SE	ROANOKE	VA	24007	CITY OF ROANOKE VIRGINIA	PO BOX 1451	ROANOKE	VA	24007	ROANOKE	95363	ROANOKE	002800	28	85457.4137		65800	65800		2003-10-24	1	1		919567	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	325.2698	419.9318	372.0712		151-VACANT-SFR-CITY		ROS	21.1096	GOVERNMENT	7212	ACREAGE GARDEN CITY			GOVT LOCAL	OPEN	OTHER	MILL MOUNTAIN PARK	LOCAL PARK				1012026
1313120	1313120	51	770	0 PATTERSON AVE SW	ROANOKE	VA	24018	HANK HEALEY LLC	3505 MUD LICK RD SW	ROANOKE	VA	24018	ROANOKE	95363	ROANOKE	001000	10	605.2239		10700	10700		2019-10-07	1	1		6506	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	295.1008	300.5619	296.4189	140-COMMERCIAL VACANT	I-1	I-1	I-1	0.1494	BUSINESS	3391	PT LOT 5 BLK 50 W E L	190010221	040020534									1012026
1250131	1250131	51	770	0 WINDSOR AVE SW	ROANOKE	VA	24015	HULLE JESSIAH STEVEN	749 WINDSOR AVE SW	ROANOKE	VA	24015	ROANOKE	95363	ROANOKE	001800	18	744.7029		36000	36000	237950	2021-07-29	1	1		8014	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	298.5902	306.7368	302.8746	100-VACANT LAND	RM-1	RM-1	RM-1	0.1840	PERSON		N 10 FT LOTS 11-12BLK 2 STRATFO…	210010305	210004985									1012026
5390113	5390113	51	770	4229 WELCOME VALLEY RD SE	ROANOKE	VA	24014	NEW HOPE CHRISTIAN CHURCH OF RO…	4229 WELCOME VALLEY RD SE	ROANOKE	VA	24014	ROANOKE	95363	ROANOKE	002900	29	19123.5288	926700	311900	1238600		2021-09-07	1	1		207136	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	404.5868	423.8367	411.2768		455-COMM/INDUST-RELIGIOUS		INPUD	4.7552	NONPROFIT	4921	PARCEL 1 MEYERS MAP						ROCKYDALE QUARRIES	B2B_TRANSPORTATION_AND_STORAGE_…				1012026
2021752	2021752	51	770	0 HARRISON AVE NW	ROANOKE	VA	24017	FORD MAVIS C	2320 DELAWARE AVE NW	ROANOKE	VA	24017	ROANOKE	95363	ROANOKE	002502	25.0200	340.2160		13700	13700	2500	2003-11-17	1	1		3679	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	293.6651	298.5142	295.3590	100-VACANT LAND	RM-1	RM-1	RM-1	0.0844	PERSON		LOT 11 G A	040002007	CONV000000									1012026
4340715	4340715	51	770	1567 RIVERDALE RD SE	ST AUGUSTINE	VA	32095	KAJA HOLDING 2 LLC	TRIGILD DLP CAPITAL ATT GWEN GE…	ST AUGUSTINE	FL	32095	ROANOKE	95363	ROANOKE	002800	28	696.7552	108100	31800	139900	6755	2015-09-09	1	1		7445	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	280.9124	282.0996	281.3618		200-SINGLEFAMILY		RM-1	0.1709	BUSINESS	2111	LOT 16 BLK 3 RIVERDALE											1012026
2322609	2322609	51	770	1902 MELROSE AVE NW	ROANOKE	VA	24014	CHOCKLETT PROPERTIES LLC	2372 HIGHLAND RD	ROANOKE	VA	24014	ROANOKE	95363	ROANOKE	002501	25.0100	362.2984	90500	11200	101700	27000	2014-07-07	1	1		3866	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	301.1719	304.7813	302.6526		200-SINGLEFAMILY		RM-1	0.0888	BUSINESS	5312	N PT LOT 8 BLK 70 MELROSE											1012026
1270803	1270803	51	770	687 BRANDON AVE SW	ROANOKE	VA	24015	MURRAY RUN PROPERTIES LLC	1320 LAKEWOOD DR SW	ROANOKE	VA	24015	ROANOKE	95363	ROANOKE	003000	30	2182.5100	151300	169200	320500		2025-04-03	1	1		21463	51161C	2026-01-08	AE		283.3374	288.9283	285.3047		400-COMMERCIAL/INDUSTRIAL		CG	0.4927	BUSINESS	8123	ACREAGE WINONA						WHEELER'S FAST SERVICE LAUNDRY …	LAUNDRY_SERVICE				1012026
4090204	4090204	51	770	28 CARDINAL RD SW	ROANOKE	VA	24014	MCCARD LLC	28 CARDINAL RD SW	ROANOKE	VA	24014	ROANOKE	95363	ROANOKE	002900	29	4069.0858	1192600	236700	1429300	1325514	2007-09-05	1	1		43746	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	351.7823	370.1122	360.5557		200-SINGLEFAMILY		R-12	1.0042	BUSINESS	3325	LOTS 4 5 C S BIRCHFIELD MAP											1012026
3090408	3090408	51	770	215 LIBERTY RD NE	ROANOKE	VA	24011	PARKWAY HOLDINGS LLC	410 FIRST ST SW	ROANOKE	VA	24011	ROANOKE	95363	ROANOKE	000500	5	709.5455	124400	24800	149200	347250	2020-05-04	1	1		7611	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	307.7374	309.2122	308.5591		300-MULTIFAMILY		R-5	0.1747	BUSINESS	4869	PARCEL 3A BLK 1 FRANKLIN MAP											1012026