Saved query 378253d703a6d945

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

41/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '51' 
  AND countyfp = '023'

21,102 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	numfloors	bldgsqft	bedrooms	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	taxacres	ownertype	naicscode	legaldesc	book	page	placename	placetype	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
044F2-02-110-0050	6641	51	023	905 SPRING ST	IRON GATE	VA	24448	RUCKER RICKY E OR SHENANDOAH C	P O BOX 121	IRON GATE	VA	24448	BOTETOURT	93575	FINCASTLE	040100	401	541.1159	34900	-74600	-84600	129500	32500	2012-12-19	1	1	1993		1248	3	0	2	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	315.3236	316.3600	315.5459	10	MANUFACTURED	IG	0	PERSON		LOT 5-BLK 110 I G L	2654					HEAT PUMP	ELECTRIC	HEAT PUMP	CONCRETE BLOCK	COMPOSITION		2026.2	2024	TOWN OF IRON GATE
044F1-01-000-001B	6170	51	023	735 CALLIE MINES RD	CLIFTON FORGE	VA	24422	TIMBROOK ROGER OR MICHELLE	735 CALLIE MINES RD	CLIFTON FORGE	VA	24422	BOTETOURT	93575	FINCASTLE	040100	401	72540.4708	134200	-66900	-136300	339900			1	1	1999		2000	3	0	2	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	358.8587	378.0246	370.5192	20	SINGLE FAMILY	AR	17.4730	PERSON	7225	17 473 AC NEAR WESGATE SUB-DIV	376		WHIPPOORWILL BAKE SHED	CASUAL_EATERY		HEAT PUMP	ELECTRIC	HEAT PUMP	CONCRETE BLOCK	COMPOSITION		2026.2	2024	SHARON
044F2-03-730-0040	7063	51	023	513 WINTERGREEN AVE	CLIFTON FORGE	VA	24422	CARROLL CLARENCE K JR OR LIZA K	513 WINTERGREEN AVENUE	CLIFTON FORGE	VA	24422	BOTETOURT	93575	FINCASTLE	040100	401	1863.9927	130300	-134500	-144500	284800	125000	1997-07-15	1	1	1989		1520	3	0	2	51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	371.2376	381.2606	377.9800	10	SINGLE FAMILY	IG	0	PERSON		LOT 4-BLK 73 I G L	375					HEAT PUMP	ELECTRIC	HEAT PUMP	OTHER	COMPOSITION		2026.2	2024	SHARON
13897	107E(6)BK4-26	51	023	353 N ROME DR	ROANOKE	VA	24019	KLAMPFER RANDY J &	353 N ROME DR	ROANOKE	VA	24019	BOTETOURT	96159	VALLEY	040501	405.0100	1274.4227	235200	55000	0	290200			1	2	1991	0	1680				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				BETH D GRIFFIN			0.2960	PERSON		BOTETOURT SOUTH 26 IN 4 IN 1					1	Y	KLAMPER RANDY J & SHELIA D	Y	Y	Y	PAVED	2026.2	4640	150000108
28974	107M(1)42	51	023	275 TERESA LN	ROANOKE	VA	24019	JESSEE JOSEPH K & DEANA C	275 TERESA LANE	ROANOKE	VA	24019	BOTETOURT	96159	VALLEY	040402	404.0200	1972.8244	333700	48000	0	381700	224950		1	2	2003	0	2057				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							0.4700	PERSON		MOUNTAIN CREST LOT 42					0	Y	TRINITY PROPERTIES LLC	Y	Y	Y	PAVED	2026.2	5563
26270	87B(4)7	51	023	481 GRANDVIEW DR	TROUTVILLE	VA	24175	THACKER DAVE W & KIMBERLY R	481 GRANDVIEW DR	TROUTVILLE	VA	24175	BOTETOURT	90048	AMSTERDAM	040303	403.0299	8241.3128	532500	100000	0	632500	352000		1	2	1994	0	3110				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							2.0640	PERSON		WOODRIDGE 7 IN 4	160001				0	Y	GRSW STEWART REAL ESTATE TR	Y			PAVED	2026.2	18645	040007997
14755	107L(1)34	51	023	778 RAY ST	ROANOKE	VA	24019	SPENCER KEITH E & CRISTEN M	778 RAY ST	ROANOKE	VA	24019	BOTETOURT	96159	VALLEY	040501	405.0100	1867.7832	285700	45000	0	330700	187500		1	2	1997	0	2796				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							0.4590	PERSON		LAUREL MOUNTAIN LOT 34					0	Y	CLAY RONNIE L & KIMBERLY A	Y	Y	Y	PAVED	2026.2	5499
14404	107I(1)BK1-1	51	023	523 STAYMAN RD	ROANOKE	VA	24019	ATKINS WANDA K	523 STAYMAN RD	ROANOKE	VA	24019	BOTETOURT	96159	VALLEY	040402	404.0200	2076.2140	379300	60000	0	439300			1	3	1991	0	1757				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							0.5200	PERSON		STEEPLECHASE 1 IN 1 IN 1					1	Y	ATKINS EARL A & WANDA K	Y	Y	Y	PAVED	2026.2	5149	020007264
29001	103G(1)27	51	023	168 PIPER GLENN	BLUE RIDGE	VA	24064	GRUBBS ROBERT W & DANA W	168 PIPER GLENN	BLUE RIDGE	VA	24064	BOTETOURT	90384	BLUE RIDGE	040501	405.0100	4447.2671	447700	80000	0	527700	335000		1	5	2001	0	3702				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							1.1000	PERSON		COBBLESTONE 27 IN 1					3	Y	HORTON JAMES W JR & PAMELA A		Y		PAVED	2026.2	3172	010003204
12753	106-107	51	023	8663 RESERVOIR RD	ROANOKE	VA	24019	SANDERS BARBARA ANN	8663 RESERVOIR ROAD	ROANOKE	VA	24019	BOTETOURT	90048	AMSTERDAM	040402	404.0200	818.8810	105300	13200	0	118500			1	4	1959	0	1104				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							0.2000	PERSON		HOLLINS					3	Y	ANDERSON MOSES A		Y	Y	PAVED	2026.2	3240
11237	101B(4)7A	51	023	254 RIDGE RD	TROUTVILLE	VA	24175	KENNEMORE DENNIS & BARBARA	254 RIDGE RD	TROUTVILLE	VA	24175	BOTETOURT	96159	VALLEY	040402	404.0200	5191.2368	194000	41200	0	235200	123500		1	3	1984	0	1200				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							1.1500	PERSON		COALING					2	Y	FIRESTONE RONALD D & MELINDA S		Y		PAVED	2026.2	1504
14204	107G(2)704	51	023	173 TINKERVIEW DR	CLOVERDALE	VA	24077	JOWDY ELIAS C	231 DRAKE TRL	CLOVERDALE	VA	24077	BOTETOURT	96159	VALLEY	040402	404.0200	66.1240	109500	25000	0	134500			1	1	1987	0	864				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							0	PERSON		TINKERVIEW TOWNHPHASE II UNIT 7…					0	Y	HURD REGINIA ZEIDAN		Y	Y	PAVED	2026.2	4947	060003136
12153	103-26	51	023	551 CARDIGAN DR	BLUE RIDGE	VA	24064	DUNBAR ROBIN L	551 CARDIGAN DR	BLUE RIDGE	VA	24064	BOTETOURT	90384	BLUE RIDGE	040501	405.0100	2693.0998	91600	38000	0	129600			1	3	1991	0	1152				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							0.8260	PERSON		BLUE RIDGE					2	Y	DUNBAR STEPHEN L & ROBIN L LYLE		Y		PAVED	2026.2	2512
30481	62(7)3	51	023	98 GOAD RD	FINCASTLE	VA	24090	FLOYD PHILIP L & MARY G	98 GOAD DR	FINCASTLE	VA	24090	BOTETOURT	90528	BUCHANAN	040200	402	9494.5184	337400	50100	0	387500	294950		1	2	2007	0	2105				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							2.2660	PERSON		WHEATLAND ACRES NEW LOT 3					0	Y	ZION HILL LLC				UNPAVED	2026.2	13325
25190	76A(2)3	51	023	11898 LEE HWY	BUCHANAN	VA	24066	WILSON SUSAN S (RTOD)	635 AMMEN RD	FINCASTLE	VA	24090	BOTETOURT	90528	BUCHANAN	040200	402	4497.2825	121200	35700	0	156900			1	1	1983	0	1000				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							1.1100	PERSON		R L KNIGHTON SUB					0	Y	WILSON SUSAN S				PAVED	2026.2	17508	180000320
17571	19-20	51	023	1495 DAGGER SPRING RD	EAGLE ROCK	VA	24085	HAWKINS RONNIE M & WINNIE K	657 TEXAS HOLLOW RD	SALEM	VA	24153	BOTETOURT	93575	FINCASTLE	040100	401	3206.4295	10500	15000	0	25500	29900		1	10		0					51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							0.9800	PERSON		MILL CR		585 1420			10	Y	VEST THOMAS W SR & DORA F				PAVED	2026.2	8656
16808	109D(2)BK7-36	51	023	QUEEN REGENT COURT	BLUE RIDGE	VA	24064	YEAKLE AMY M (RTOD)	226 QUEEN REGENT CT	BLUE RIDGE	VA	24064	BOTETOURT	90384	BLUE RIDGE	040501	405.0100	2622.2158	0	37500	0	37500			0	0		0					51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							0	PERSON		HEATHERSTONE 36 IN 7					0	Y	YEAKLE AMY M		Y		PAVED	2026.2	7830	WB 1700001
26879	88F(1)41	51	023	120 MAGNOLIA LN	DALEVILLE	VA	24083	TARZIA NICHOLAS J & SHELIA P	120 MAGNOLIA LN	DALEVILLE	VA	24083	BOTETOURT	90048	AMSTERDAM	040304	403.0400	2172.2075	571800	80000	0	651800	500000		1	2	1999	0	4568				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							0.5400	PERSON		ASHLEY PLANTATIO41 IN 1					0		MULLINS JOSEPHINE M				PAVED	2026.2	19657
11372	101D-135	51	023	4816 LEE HWY	TROUTVILLE	VA	24175	SKJB PROPERTIES LLC	593 BRUNSWICK FORGE RD	TROUTVILLE	VA	24175	BOTETOURT	96159	VALLEY	040401	404.0100	3432.3287	366400	93300	0	459700	360000		1	6		0					51023C	2026-01-08	AE								0.8480	BUSINESS		TOWN OF TROUTVIL					6	Y	CONSOLIDATED PIPE & SUPPLY CO I…		Y	Y	PAVED	2026.2	1583
24766	75-103A	51	023	180 BLUE BIRD LN	FINCASTLE	VA	24090	SCHOEMAN CAROL F LIFE ESTATE	180 BLUE BIRD LANE	FINCASTLE	VA	24090	BOTETOURT	90528	BUCHANAN	040301	403.0100	5539.7056	320000	47300	0	367300			1	3	1991	0	1867				51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							1.2904	PERSON		MILL CREEK					1	Y	FERRIS VIRGINIA G				UNPAVED	2026.2	16921
044F1-01-000-001B	6170	51	023	735 CALLIE MINES RD	CLIFTON FORGE	VA	24422	TIMBROOK ROGER OR MICHELLE	735 CALLIE MINES RD	CLIFTON FORGE	VA	24422	BOTETOURT	93575	FINCASTLE	040100	401	6181.6011	270500	69400		339900			1	1	1999						51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	375.7726	386.0107	379.7859	20		AR	17.4730	PERSON		17.473 AC NEAR WESGATE SUB-DIV	376											2026.2		SHARON
25709	86-28	51	023	BLACKSBURG RD	TROUTVILLE	VA	24175	BAYNE CAROLYN L LIFE ESTATE	6492 BLACKSBURG RD	TROUTVILLE	VA	241756985	BOTETOURT	90048	AMSTERDAM	040304	403.0400	427.6532	0	8000	0	8000			0	0		0					51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							0.0700	PERSON		B B RD					0	Y	BAYNE CAROLYN L				PAVED	2026.2	18046
29828	37(1)8	51	023	BOTETOURT RD	FINCASTLE	VA	24090	BRYANT JAMES E JR ET ALS	2333 BLACKSBURG RD	FINCASTLE	VA	24090	BOTETOURT	93575	FINCASTLE	040100	401	20419.0562	0	59300	0	59300			0	0		0					51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							5.0450	PERSON		BETTY MAE BARGER PLAT NEW TRACT…					0	Y	BARGER CARL CLAIBORNE & BETTY				PAVED	2026.2	10058
16523	109-96	51	023	BLUE RIDGE BLVD	BLUE RIDGE	VA	24064	BIRD TERESA H	3344 BLUE RIDGE BLVD	BLUE RIDGE	VA	24064	BOTETOURT	90384	BLUE RIDGE	040502	405.0200	13282.8959	0	55400	0	55400			0	0		0					51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							3.9150	PERSON		GLADE CREEK	58 141				0	Y	HUTCHENS THOMAS E				PAVED	2026.2	7486
19825	48-89	51	023	ZION HILL RD	FINCASTLE	VA	24090	RICE PAUL S JR	PO BOX 506	DALEVILLE	VA	24083	BOTETOURT	93575	FINCASTLE	040100	401	33631.0498	0	24500	0	24500			0	0		0					51023C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD							7	PERSON		HUGHES HILL					0	Y	POFF J WESLEY				PAVED	2026.2	11196