Saved query 4e6ba0e12d2096d6

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

33,790 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	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	taxacres	ownertype	legaldesc	book	page	placename	placetype	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
131-7-5	08622	51	035	406 ALPINE CREST RD	AXTON	VA	24054	LEONARD TERY EUGENE LEONARD CLI…	3470 IRISBURG RD	AXTON	VA	24054	CARROLL	94175	LAUREL FORK	080501	805.0100	2695.4750	83400	30000		113400		2023-07-26	1	1	1980	1	840	2	1	51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	843.7399	848.4715	846.7828	2	2-SINGLE FAMILY SUB(.01-19.99)		0	PERSON	COM1 131 - 7 - 5	1220 503				1	BASEBOARD	ELECTRIC	UNDETERMINED	STONE FOUNDATION	ASPHALT SHINGLES	VINYL SIDING	2026.2	2025	2
341-4-37	21833	51	035	310 OAK ST	HILLSVILLE	VA	24343	MONDIE JAMES B MONDIE PATRICIA	310 OAK ST	HILLSVILLE	VA	24343	CARROLL	95087	PIPER GAP	080200	802	1809.7688	71800	16000		87800		2024-12-13	1	1	1955	1	955	3	1	51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	743.9804	748.7473	747.3115	1	1-SINGLE FAMILY URBAN		0.4540	PERSON	OAK ST	1250 612				1	HEAT PUMP	ELECTRIC	HEAT PUMP	SLAB	ASPHALT SHINGLES		2026.2	2025	06
39-A-25D	33137	51	035	1745 HUNTERS RIDGE RD	HILLSVILLE	VA	24343	MARCUM JEREMIAH MARCUM SARAH	1745 HUNTERS RIDGE RD	HILLSVILLE	VA	24343	CARROLL	95071	PINE CREEK	080100	801	45736.1098	219300	65400		284700	270000	2020-11-04	1	1	2005	1	1664	2	2	51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	748.9362	779.5417	769.3704	2	2-SINGLE FAMILY SUB(.01-19.99)		11.2734	PERSON	RD 638	1149 664					HEAT PUMP	ELECTRIC	HEAT PUMP	SLAB	ASPHALT SHINGLES		2026.2	2025	3
138-A-37	15910	51	035	1664 SOAPSTONE RD	GALAX	VA	24333	SAWYERS CHANNING BOND PAMELA	1694 SOAPSTONE RD	GALAX	VA	24333	CARROLL	95087	PIPER GAP	080601	806.0100	1896.4378	5300	12000		17300		2020-10-05	1	1	1976	1	695	3	2	51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	772.2280	784.6743	775.7195	2	2-SINGLE FAMILY SUB(.01-19.99)		0.4700	PERSON	COM1 138 - A - 37	1147 174				1	BASEBOARD	ELECTRIC	UNDETERMINED	SLAB	METAL		2026.2	2025	4
154-A-136	00562	51	035	13635 FANCY GAP HWY	CANA	VA	24317	HERDMAN ERIK	13635 FANCY GAP HWY	CANA	VA	24317	CARROLL	93551	FANCY GAP	080604	806.0400	2444.3768	53200	11500		64700	31500	2020-04-21	1	1	1968	1	1064	2	1	51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	443.8679	447.3522	446.0826	2	2-SINGLE FAMILY SUB(.01-19.99)		0.5758	PERSON	HWY 52	1135	365				CENTRAL AIR	OIL	UNDETERMINED		ASPHALT SHINGLES		2026.2	2025	1
119-A-12D	33211	51	035	1309 WORRELL MEMORIAL RD	LAUREL FORK	VA	24352	SUPAN STEPHEN RICHARD SUPAN AND…	1309 WORRELL MEMORIAL RD	LAUREL FORK	VA	24352	CARROLL	94175	LAUREL FORK	080501	805.0100	3999.7549	181700	17000		198700	12500	2021-06-22	2	1	2021	1	1215	2	2	51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	825.0585	830.9395	828.9811	2	2-SINGLE FAMILY SUB(.01-19.99)		1	PERSON	RD 643	1168 275					HEAT PUMP	ELECTRIC	HEAT PUMP		COMP SH		2026.2	2025	2
51A-4-3	17032	51	035	3631 POPLAR CAMP RD	KING	VA	27021	LARGEN HOWARD LEE JR	115 REDWOOD BEND	KING	NC	27021	CARROLL	96007	SULPHUR SPRINGS	080200	802	3174.1659	14400	12000		26400		1991-05-28	1	1	1980	1	2700			51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	786.7799	797.6154	793.5186	4	COMMERCIAL/INDUSTRIAL	COMMERCIAL	0	PERSON	LOTS 3 4	046	0262										2026.2	2025	05
36A-2-59	11804	51	035		SHERWOOD FOREST	VA	24343	WEBB ROBERT D WEBB LINDA M	56 AMELIA LN	HILLSVILLE	VA	24343	CARROLL	95071	PINE CREEK	080100	801	1574.8441	1200	12000		13200	7500	2006-08-17	1	1	1960					51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	817.9367	821.9410	820.6714	2	SINGLE FAMILY SUB(.01-19.99)	RESIDENTIAL	0.3630	PERSON	LOT 59	784	256										2026.2	2025	03
109-21-1	35069	51	035	121 TWIN FORKS LN	WOODLAWN	VA	24381	HANKS CECIL HANKS JANET	121 TWIN FORKS LN	WOODLAWN	VA	24381	CARROLL	95087	PIPER GAP	080401	804.0100	5469.8704	15200	17000		32200	13500	2011-02-08	1	1						51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	794.2354	813.6646	806.6844	2	SINGLE FAMILY SUB(.01-19.99)	RESIDENTIAL	1.3244	PERSON	LOT 1	915	479										2026.2	2025	04
153-A-64A	28091	51	035	743 SANDY RIDGE RD	CANA	VA	24317	HAWKS GINGER LEIGH	743 SANDY RIDGE RD	CANA	VA	24317	CARROLL	93551	FANCY GAP	080603	806.0300	1356.9024	1000	1000		2000		2018-01-05	1	1						51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	476.2725	480.5772	477.8076	2	SINGLE FAMILY SUB	RESIDENTIAL	0.3300	PERSON	RD 935	WB 110	388										2026.2	2025	01
36-1-10	11806	51	035	218 WORREL ESTS	HILLSVILLE	VA	24343	DALTON CHARLES C DALTON KACEY R	218 WORREL ESTATES	HILLSVILLE	VA	24343	CARROLL	95071	PINE CREEK	080100	801	2523.8954	8000	8000		16000	22500	2022-05-25	1	1						51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	823.1637	830.1784	827.0130	2	SINGLE FAMILY SUB	RESIDENTIAL	0	PERSON	PART OF MAIN LOT	1195	387										2026.2	2025	03
139-8-34	33120	51	035	111 QUEENS RD	FT PIERCE	VA	34949	STEWART THOMAS N LONG KIM E	111 QUEENS RD	FT PIERCE	FL	34949	CARROLL	95087	PIPER GAP	080402	804.0200	21211.7666	26800	12000		38800		2013-10-16	1	1						51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	854.2597	881.9158	869.7202	2	2-SINGLE FAMILY SUB(.01-19.99)	RESIDENTIAL	5.2230	PERSON	FORESTGREEN ADDITION TRACT 34	978	980										2026.2	2025	4
37A-2-4	11185	51	035	8825 DOUBLE CABIN RD	HILLSVILLE	VA	24343	BURNETT KELI	8825 DOUBLE CABIN RD	HILLSVILLE	VA	24343	CARROLL	95071	PINE CREEK	080100	801	2004.5006		10000		10000		1993-11-19	1							51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	778.7453	785.7404	783.2316	2	SINGLE FAMILY SUB(.01-19.99)	RESIDENTIAL	0	PERSON	LIBERTY HILLS LOT 4	050	0631										2026.2	2025	3
20-A-76C	35085	51	035	RD 768	FLOYD	VA	24091	TURMAN JOHN MICHAEL TURMAN WAND…	PO BOX 497	FLOYD	VA	24091	CARROLL	95071	PINE CREEK	080100	801	380.1304	-3200	300	-3200	3500		2009-11-10								51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	713.5876	727.7494	720.9656	2	2-SINGLE FAMILY SUB(.01-19.99)	RESIDENTIAL	0.0920	PERSON	BK PG 885 965	885	965										2026.2	2026	03
129E-12-1-206	03280	51	035	785 CRYSTAL SPRINGS DR	FANCY GAP	VA	24328	COOK CHARLES ANDREW 70 MIDDLETO…	785 CRYSTAL SPRINGS DR	FANCY GAP	VA	24328	CARROLL	93551	FANCY GAP	080603	806.0300	935.3635		8000		8000		2024-12-04								51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	697.3747	711.9108	704.4904	2	SINGLE FAMILY SUB(.01-19.99)	RESIDENTIAL	0	PERSON	LOT 206	WB 129	603										2026.2	2025	01
129F-4-G6	04144	51	035		CASCADE	VA	27249	DEVELOPMENT PROPERTIES LLC	6753 FRIEDENS CHURCH RD	GIBSONVILLE	NC	27249	CARROLL	93551	FANCY GAP	080603	806.0300	984.2735		3000		3000		2015-10-09								51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	723.3964	735.2097	729.3470	2	SINGLE FAMILY SUB(.01-19.99)	G-6	0	BUSINESS	LOT G-6	1023	584										2026.2	2026	1
122-A-111	15381	51	035	416 BOXWOOD LN	GALAX	VA		JONES NICOLE A	416 BOXWOOD LN	GALAX	VA	24333	CARROLL	95087	PIPER GAP	080402	804.0200	2346.9867	102200	15000		117200	97000	2021-05-28	1	1						51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	832.5111	839.1865	836.9512	2			0.5220	PERSON		1166 116		FREEDOM MOTORSPORTS INC.	VEHICLE_PARTS_STORE								2026.2		4
76-A-219	20276	51	035	75 IVY LN	FRIES	VA		MOORE TIMOTHY PEARY &	75 IVY LN	FRIES	VA	24330	CARROLL	96007	SULPHUR SPRINGS	080300	803	1390.2060	156200	20000		176200	85000	2007-07-23	1	1						51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	741.2002	749.6461	746.0537	2			0.3300	PERSON	OFF RD 758	816 375											2026.2		5
128-4-3	13090	51	035	736 OLD APPALACHIAN TRL	FANCY GAP	VA		HONEYCUTT RICKY WAYNE	736 OLD APPALACHIAN TRL	FANCY GAP	VA	24328	CARROLL	93551	FANCY GAP	080603	806.0300	1769.9158	113700	16000		129700	180000	2021-09-20	1	1						51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	880.7113	886.0740	883.6500	2			0	PERSON	RD 608	1176 111											2026.2		4
95B-2-9	32683	51	035	3681 CRANBERRY RD	WOODLAWN	VA		REECE NINA M	3681 CRANBERRY RD	WOODLAWN	VA	24381	CARROLL	95087	PIPER GAP	080401	804.0100	1975.3202	110600	20000		130600	13500	2003-10-28	1	1						51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	777.9108	781.3329	779.6939	2			0.4850	PERSON	ROY HILL S/D	687 021											2026.2		4
32-A-38	18266	51	035	257 TALL TREE LN	AUSTINVILLE	VA		LAWSON JOHN W &	753 TOPAZ DRIVE	MAX MEADOWS	VA	24360	CARROLL	96007	SULPHUR SPRINGS	080300	803	144689.3637	7800	93600		101400	19000	1991-01-14	1	1						51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	728.3162	780.0569	754.5196	5			35	PERSON	RD 796	414 0444											2026.2		5
48-4-19	29674	51	035	160 KNOB HILL LN	WOODLAWN	VA		WALLS BEVERLY LYNN &	160 KNOB HILL LN	WOODLAWN	VA	24381	CARROLL	96007	SULPHUR SPRINGS	080300	803	4392.0045	94200	15000		109200	85000	2024-02-26	1	1						51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	793.1848	808.8683	801.5634	2			1.0620	PERSON	RD 740	1232 749											2026.2		5
113B-4-5-31	14025	51	035	133 COUNTY TOP LN	FANCY GAP	VA		PETERSON TONY R &	12014 GROVE CROSSING DR	HUNTERSVILLE	NC	28078	CARROLL	95087	PIPER GAP	080402	804.0200	3418.6057	210500	15000		225500	211000	2023-12-29	1	1						51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	951.8329	985.7403	971.1174	2			0	PERSON	WOODED ACRES	1229 986											2026.2		4
125-A-50A	33770	51	035	355 BOWIE RD	WOODLAWN	VA		DAVIS ROBERT R &	355 BOWIE RD	WOODLAWN	VA	24381	CARROLL	95087	PIPER GAP	080402	804.0200	20140.3335	364500	29900		394400	8500	2006-06-05	1	1						51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	800.9124	826.6965	812.9154	2			4.9760	PERSON		777 001											2026.2		4
40-A-76	7334	51	035	815 DUGSPUR RD	DUGSPUR	VA		TODD DOUGLAS C &	815 DUGSPUR RD	DUGSPUR	VA	24325	CARROLL	94175	LAUREL FORK	080501	805.0100	2410.0895	137700	15200		152900	140000	2007-07-02	1	1						51035C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	813.3331	819.2816	816.0536	2			0.6400	PERSON	RD 638	814 386											2026.2		2