Saved query a0ab948a18f79e55

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

21,141 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	yearbuilt	bldgsqft	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	ownertype	naicscode	legaldesc	placename	placetype
31389	88-33A	51	023	70 BROAD ST	DALEVILLE	VA	24083	DALEVILLE TOWN CENTER APARTMENT…	2903 BOULEVARD ST STE A	COLONIAL HEIGHTS	VA	23834	Botetourt	90048	Amsterdam	040303	403.0299	17119.1619	16940700	1059300	18000000	1000000	2012-12-06	0			51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	408.7913	413.4925	411.1819	4.2370	BUSINESS	31412	DALEVILLE TOWN CENTER PH1 CORE …	YOGA DALEVILLE	FITNESS_STUDIO
15785	108D 2 BK1-8	51	023	250 ROYCE RD	TROUTVILLE	VA	24175	DOWNEY ROGER G & SHARON L	250 ROYCE RD	TROUTVILLE	VA	24175	Botetourt	90384	Blue Ridge	040501	405.0100	3311.7656	322700	50000	372700	183000	1999-11-01	1	1990	2678	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	343.1193	356.3451	351.3273	0	PERSON		STEPPING STONE 8 IN 1 IN 1
22566	65A 23 11	51	023	115 CHENAULT ST	BUCHANAN	VA	24066	NGUYEN HA THI NGOC &	115 CHENAULT ST	BUCHANAN	VA	24066	Botetourt	90528	Buchanan	040200	402	1100.4591	224800	33000	257800	279900	2022-04-06	1	2005	2140	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	292.2541	302.4895	298.0550	0.2870	PERSON		JEFFERSON HILLS 11 IN 2
26814	88B 3 PT2-5	51	023	86 CHAROLAIS CIR	TROUTVILLE	VA	24175	ALLEN DANIELLE R &	86 CHAROLAIS CIR	TROUTVILLE	VA	24175	Botetourt	90048	Amsterdam	040303	403.0299	1780.8817	312900	50000	362900	262950	2018-10-10	1	1990	2630	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	448.0765	457.6976	453.1426	0.4590	PERSON		KESWICK FMS 5 IN 2 IN 1
13095	107-112	51	023	163 GIBSON LN	CLOVERDALE	VA	24077	CLARK KENNETH L	163 GIBSON LN	CLOVERDALE	VA	24077	Botetourt	90048	Amsterdam	040402	404.0200	8727.6587	96600	49600	146200	95000	2011-06-21	1	1950	915	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	353.7633	368.8466	360.9089	2.2000	PERSON		CLOVERDALE
22504	65A 2 1A	51	023	20314 MAIN ST	BUCHANAN	VA	24066	HAMMONS KLAY K & EMILY	20314 MAIN ST	BUCHANAN	VA	24066	Botetourt	90528	Buchanan	040200	402	1101.2078	149600	13000	162600	248500	2024-05-01	1	1920	1460	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	268.3003	275.1269	273.0519	0	PERSON		TOWN OF BUCHANANCHURCH LOT
26447	87F 1 12	51	023	167 HOLLYMEADE LN	DALEVILLE	VA	24083	DUCKWORTH JEFFREY W & PAMELA A	167 HOLLYMEADE LN	DALEVILLE	VA	24083	Botetourt	90048	Amsterdam	040303	403.0299	5347.8024	496600	85000	581600	385000	2009-07-31	1	1990	3504	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	400.5480	410.0802	405.6297	1.3440	PERSON		HOLLYMEADE 12 IN 1
15549	108A 1 BK9-4	51	023	100 BEACHVIEW LN	TROUTVILLE	VA	24175	MCCARTHY CHRISTOPHER & ANGELA M	100 BEACHVIEW LN	TROUTVILLE	VA	24175	Botetourt	90384	Blue Ridge	040501	405.0100	1992.5057	192900	45000	237900	279950	2025-05-30	1	1993	1296	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	366.4329	376.3583	370.6712	0	PERSON		RAINBOW FOREST 4 IN 9
30086	109 8 22B	51	023	425 HUFTON BROOK LN	BLUE RIDGE	VA	24064	WEDDLE CODY & SARA GRACE	425 HUFTON BROOK LANE	BLUE RIDGE	VA	24064	Botetourt	90384	Blue Ridge	040502	405.0200	34011.7346	341800	92000	433800	365000	2020-09-01	1	2004	2511	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	395.0758	421.8486	410.2590	8.4309	PERSON		WINDY HILL ESTATES NEW LOT 22B
25286	77-54	51	023	1880 MOUNTAIN VALLEY RD	BUCHANAN	VA	24066	MONTGOMERY LARRY E & ANGEL G	1880 MOUNTAIN VALLEY RD	BUCHANAN	VA	24066	Botetourt	90528	Buchanan	040200	402	124835.6641	370500	134700	505200	400000	2007-05-18	1	1996	3016	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	354.2966	400.9060	377.6229	30.9130	PERSON		LITTLE MT
26697	88-82D	51	023	2545 TRINITY RD	TROUTVILLE	VA	24175	HAWKINS LUCIAN W & BRIDGETTE A	2545 TRINITY RD	TROUTVILLE	VA	24175	Botetourt	90048	Amsterdam	040304	403.0400	8312.9006	322400	64100	386500	320000	2015-05-22	1	2003	2234	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	440.2012	452.7987	444.7035	2.0130	PERSON		TRINITY
16276	109-221	51	023	326 ARCH VALLEY LN	BLUE RIDGE	VA	24064	OLD DUDLEY FARM LLC	251 ARCH VALLEY LN	BLUE RIDGE	VA	24064	Botetourt	90384	Blue Ridge	040502	405.0200	185899.1453	65100	142700	207800		2020-03-27	1	1920	1354	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	351.0259	402.2401	373.1628	46.6550	BUSINESS	1122	BLUE RIDGE
17310	17A 3 1 2	51	023	98 MALCOM DR	EAGLE ROCK	VA	24085	MACKEY JOE & ELLEN	1335 BOONE DR	BEDFORD	VA	24523	Botetourt	93575	Fincastle	040100	401	3273.7313	88600	50000	138600	130000	2017-12-05	1	1940	782	51023C	2026-01-08	AE	FLOODWAY	280.8161	287.9257	284.7517	0	PERSON		H M & LELIA VISE1 & 2 IN PLAT 2
12269	103A 1 BK1-9	51	023	114 BIRCH DR	BLUE RIDGE	VA	24064	WILGUS THOMAS HAYDEN & DONNA EL…	114 BIRCH DR	BLUE RIDGE	VA	24064	Botetourt	90384	Blue Ridge	040501	405.0100	1882.3788	221600	40000	261600	191350	2016-07-29	1	1970	2226	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	425.7942	434.4884	430.9454	0	PERSON		WHITE OAK ESTATE9 IN 1 IN 1
12354	103A 5 BK9-5	51	023	239 PIN OAK DR	BLUE RIDGE	VA	24064	ROUPE JOSHUA &	239 PIN OAK DR	BLUE RIDGE	VA	24064	Botetourt	90384	Blue Ridge	040501	405.0100	2617.2973	305200	40000	345200	372000	2023-08-10	1	2003	1740	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	445.4783	461.8473	454.7197	0	PERSON		WHITE OAK ESTATES 5 IN 9 IN 1
26167	87B 1 8	51	023	25 SURRY CT	DALEVILLE	VA	24083	WEAVER JUSTIN M & JESSICA R	25 SURRY CT	DALEVILLE	VA	24083	Botetourt	90048	Amsterdam	040303	403.0299	3770.0644	371900	58500	430400	451000	2022-06-02	1	2008	2302	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	401.6049	411.8833	406.3267	0.9590	PERSON		JAMESTOWN LOT 8
10265	100A 1 BK12-4	51	023	717 AZALEA RD	DALEVILLE	VA	24083	PRATT WILLIAM D	717 AZALEA RD	DALEVILLE	VA	24083	Botetourt	90048	Amsterdam	040303	403.0299	1826.5477	296800	48000	344800	284000	2020-11-12	1	1970	2094	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	397.5943	406.5049	402.4232	0	PERSON		TINKERVIEW GARDE4 IN 12
29014	108 17 38	51	023	268 WHITE TAIL DR	ROANOKE	VA	24012	LIAN VAN M	268 WHITE TAIL DR	ROANOKE	VA	24012	Botetourt	90384	Blue Ridge	040502	405.0200	5098.6687	573600	75000	648600	626000	2023-06-28	1	2008	3948	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	371.3959	391.2393	383.8311	1.2500	PERSON		DEER HAVEN SEC III LOT 38
13880	107E 6 BK3-3	51	023	92 RAY ST	ROANOKE	VA	24019	SPARKS ANTHONY & KATHERINE	92 RAY ST	ROANOKE	VA	24019	Botetourt	96159	Valley	040501	405.0100	1333.5187	267600	55000	322600	192000	2011-09-16	1	1991	1944	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	351.9018	357.3648	354.9544	0.3008	PERSON		BOTETOURT SOUTH 3 IN 3 IN 1
13644	107C 2 BK3-8	51	023	160 STAYMAN RD	ROANOKE	VA	24019	MORGAN EMILY J	160 STAYMAN RD	ROANOKE	VA	24019	Botetourt	96159	Valley	040402	404.0200	1954.5123	295500	45000	340500	193500	2017-08-25	1	1990	1440	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	386.9528	398.0020	392.2754	0	PERSON		APPLE TREE VILLA8 IN 3 IN 1
11612	101E 5 BK1-2	51	023	178 ASPEN DR	DALEVILLE	VA	24083	WAYMACK RAYMOND A III & ASHLEY N	178 ASPEN DR	DALEVILLE	VA	24083	Botetourt	90048	Amsterdam	040303	403.0299	2001.7019	375200	70000	445200	258000	2015-02-06	1	1986	2354	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	386.3164	389.8059	388.7567	0.4980	PERSON		CEDAR RIDGE SUBD2 IN 1 IN 3
19874	49 1 3	51	023	1567 TIMBER RDG	BUCHANAN	VA	24066	HOGANCAMP JASON SR & TRACEY	1567 TIMBER RIDGE	BUCHANAN	VA	24066	Botetourt	90528	Buchanan	040100	401	65145.4275	270900	125600	396500	490000	2024-01-19	1	1975	1752	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	351.9987	387.0936	376.2822	16.0970	PERSON		CEDAR ACRES LOT 3
22105	65 9 D	51	023	2502 PICO RD	BUCHANAN	VA	24066	MOSS RACHEL	2502 PICO RD	BUCHANAN	VA	24066	Botetourt	90528	Buchanan	040200	402	20785.9468	140100	36700	176800	181000	2021-11-09	1	1958	1196	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	351.3658	366.9110	359.6113	4.6670	PERSON		THELMA AUSTIN PLTRACT D
13619	107C 2 BK 2-4	51	023	139 APPLE TREE RD	ROANOKE	VA	24019	NEIGHBORS JOHN J & ANGELA L	139 APPLE TREE ROAD	ROANOKE	VA	24019	Botetourt	96159	Valley	040402	404.0200	2484.9439	295300	45000	340300	159000	2005-03-28	1	1977	2141	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	387.7279	393.0602	390.8447	0	PERSON		APPLE TREE VILLAGE 4 IN 2 IN 1
15852	108E 1 12	51	023	139 HIGH RIDGE CIRCLE	TROUTVILLE	VA	24175	BRESLIN WILLIAM & SABRA B	139 HIGH RIDGE CIRCLE	TROUTVILLE	VA	24175	Botetourt	90384	Blue Ridge	040501	405.0100	9303.8957	408600	80500	489100	261000	2003-08-15	1	1976	4400	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	351.9382	375.1676	366.4215	2.2900	PERSON		RAINBOW ESTATES LOT 12