Saved query 42adfa34aff5c646

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

38,207 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	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	ownertype	naicscode	legaldesc	parceltype	accesstype	iucnclass	placename	placetype	taxdistrict
006427	R006427	51	195	467 FRONT ST W	COEBURN	VA	24230	CLARK NELL		COEBURN	VA	24230	Wise	91438	2	931500	9315	14325.0272	44100	93600	44100	49500	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	626.3367	672.3201	648.9834	3.9120	PERSON	722515	GUEST RIVER 3.912 AC.				RAINBO	CAFE	C
040259	R040259	51	195		ABINGDON	VA	24210	CF HIGHLANDS LLC	C/O THE NATURE CONSERVANCY	ABINGDON	VA	24210	Wise	91438	2	931600	9316	101995.4462		207200		207200		51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	735.5376	825.5159	794.0961	258.9940	BUSINESS	3211	WI-0144A GIBSON, GEORGE 258.994…	NGO	CLOSED	OTHER	CUMBERLAND FOREST	PRIVATE CONSERVATION	L
039183	R039183	51	195		NORTON	VA	24273	PARAMONT CONTURA LLC		NORTON	VA	24273	Wise	91438	2	931600	9316	433.1546		6200		6200		51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	781.6077	794.4248	788.2847	7.7300	BUSINESS	1132	WI-0210 B RICHARDSON, N.J. 7.73	NGO	CLOSED	OTHER	CUMBERLAND FOREST	PRIVATE CONSERVATION	L
007496	R007496	51	195	5610 CREEK HILL RD	SAINT PAUL	VA	24283	SUTHERLAND HOWARD SCOTT		SAINT PAUL	VA	24283	Wise	91738	4	931700	9317	6848.2617	113700	126400	113700	12700	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	864.0043	874.5618	870.2027	1.8420	PERSON	45911	SANDY RIDGE 1.842 AC.				CREEK HILL GUNSMITHING	SPORTING_GOODS_STORE	L
009593	R009593	51	195	CRANES NEST RD	CHARLOTTE HALL	MD	20622-0762	MEADE ELIZABETH H		CHARLOTTE HALL	MD	20622-0762	Wise	91438	2	931500	9315	9235.8212		22700		22700		51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	627.7504	669.7008	643.0269	9.0800	PERSON	3211	SANDY RIDGE 9.08 AC.	NGO	CLOSED	OTHER	CUMBERLAND FOREST	PRIVATE CONSERVATION	L
004637	R004637	51	195	16600 BROAD ST	RICHMOND	VA	23220	STONEBRIAR APARTMENTS LLC	C/O VHDA ATTN: YVETTE JONES	RICHMOND	VA	23220	Wise	91738	4	931700	9317	350.2672	829900	849900	829900	20000	10	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	453.2908	455.2994	454.0534	0	BUSINESS	23814	15-16 BK. 5 ST. PAUL				STONEBRIAR APARTMENTS	HISTORIC_SITE	SP
020994	R020994	51	195	14530 DRY FORK RD	COEBURN	VA	24230	MARY MARTIN PRESBYTERIAN CHURCH		COEBURN	VA	24230	Wise	91738	4	931600	9316	5007.9034	248100	303100	248100	55000	2	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	453.2739	462.1096	455.3991	0	NONPROFIT	8141	CHURCH ON DRY FORK						L
016822	R016822	51	195	5233 SKEENS RIDGE RD	BIG STONE GAP	VA	24219	HOOKER DANIEL KEITH		BIG STONE GAP	VA	24219	Wise	91588	3	931300	9313	20848.6178	186600	220000	186600	33400	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	492.2961	564.8297	523.9777	2.6440	PERSON		2.644 AC SURVEY BUTCHERS RIDGE						RI
008128	R008128	51	195	4000 WATERTHRUSH RD	COEBURN	VA	24230-9733	STURGILL PAMELA P		COEBURN	VA	24230-9733	Wise	91738	4	931500	9315	1972.1762	12000	21500	12000	9500	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	601.0272	607.8161	604.2526	0.5100	PERSON		NR. COEBURN 0.51 AC.						L
003619	R003619	51	195	8607 ORBY CANTRELL HWY	WISE	VA	24293	RUBERT JAMES E JR		WISE	VA	24293	Wise	91438	2	930800	9308	434.1134	59700	64700	59700	5000	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	501.9513	504.4374	502.6789	0.1400	PERSON		INDIAN CREEK 6185 SQ.FT.0.14 AC.						RO
038907	R038907	51	195	9213 MOUNTAIN LAUREL ST	WISE	VA	24293	DUTTON REGAN G		WISE	VA	24293	Wise	91438	2	930900	9309	1867.9179	94000	127000	94000	33000	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	762.6759	770.0451	766.2545	0.4600	PERSON		L 9 MTN MEADOWS SUB .460 AC YEL…						G
040055	R040055	51	195	9960 GREENWOOD CIR	WISE	VA	24293	PAYNE NORMAN TROY		WISE	VA	24293	Wise	91738	4	931400	9314	1528.6673	224200	284200	224200	60000	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	771.5111	772.8709	772.2529	0.4100	PERSON		L 11 BEAR CRK SUB PHASE II .410…						G
038508	R038508	51	195	14684 SANDY RIDGE RD	ST PAUL	VA	24283	MEFFORD MARSHA LYNN		ST PAUL	VA	24283	Wise	91738	4	931700	9317	3088.4664	72500	82200	72500	9700	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	856.9295	863.9620	860.4050	0.6810	PERSON		.681 AC SURVEY SANDY RIDGE						L
016435	R016435	51	195	3116 WILLIS RD	BIG STONE GAP	VA	24219	ARMSTRONG MICHAEL		BIG STONE GAP	VA	24219	Wise	91588	3	931300	9313	10377.1501	171300	197800	171300	26500	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	546.5909	603.5839	572.5508	2	PERSON		WILDCAT 2.00 AC.						RI
043260	R043260	51	195	11903 CHIPMUNK DR	POUND	VA	24279	MULLINS JEFFREY NATHANIEL		POUND	VA	24279	Wise	91288	1	930700	9307	1609.4247	117900	123200	117900	5300	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	552.4723	561.0664	559.3290	0.3930	PERSON		0.393 AC SURVEY MILL CREEK						RO
013099	R013099	51	195	112 BAKER AVE SE	WISE	VA	24293	ABSHER MARY		WISE	VA	24293	Wise	91438	2	931400	9314	1362.5668	90800	102800	90800	12000	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	742.2824	744.6685	743.1761	0	PERSON		PCL. E WISE						W
031808	R031808	51	195	3918 TATE SPRINGS RD	BIG STONE GAP	VA	24219-0464	STURGILL ELIZABETH ANN		BIG STONE GAP	VA	24219-0464	Wise	91588	3	931300	9313	3218.4962	108600	121100	108600	12500	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	505.3392	517.9553	510.6651	0.8090	PERSON		WILDCAT .809 AC (LESS PCL HWY)						RI
032158	R032158	51	195	8081 SOUTH FORK RD	WINSTON SALEM	NC	27127	NEWTON BERNARD JAMES JR		WINSTON SALEM	NC	27127	Wise	91288	1	930800	9308	2951.9579	15000	23000	15000	8000	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	474.9515	516.2310	488.5194	0.7100	PERSON		.71 AC POUND RIVER						P
013458	R013458	51	195	611 MULLINS ST NW	WISE	VA	24293	RUMBERGER ERIC D		WISE	VA	24293	Wise	91438	2	930900	9309	2905.7744	80700	110800	80700	30100	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	753.9068	762.8526	757.4473	0.6760	PERSON		WISE 0.676AC SURVEY						W
016645	R016645	51	195	116 E 27TH ST S	BIG STONE GAP	VA	24219-0054	GALLOWAY WAYNE		BIG STONE GAP	VA	24219-0054	Wise	91588	3	931300	9313	250.1032	26100	35600	26100	9500	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	467.8682	468.8108	468.5103	0	PERSON		(27TH ST) N 1/2 L 19-20 BK. 215…						RI
003955	R003955	51	195	5803 NORTH FORK RD	POUND	VA	24279	SHORTT RONALD		POUND	VA	24279	Wise	91288	1	930800	9308	26690.6653	12000	31200	12000	19200	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	503.8433	591.4014	546.5717	17	PERSON		N.F. POUND R 8AC+10AC (LESS 1AC)						RO
036502	R036502	51	195	8756 FRONTIER RD	WISE	VA	24293	BURKE J B		WISE	VA	24293	Wise	91438	2	931400	9314	3219.6578	80400	88400	80400	8000	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	645.8042	653.0314	648.6095	0.8169	PERSON		.817 AC DUNCAN GAP						G
021673	R021673	51	195	6102 STARBUCK LN	BIG STONE GAP	VA	24219	SKEEN PAMELA J		BIG STONE GAP	VA	24219	Wise	91588	3	931300	9313	1282.3066	71700	83700	71700	12000	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	534.0214	543.7087	539.2137	0.3500	PERSON		LOT&ROW CRACKERS NECK (15,104 S…						RI
037481	R037481	51	195	13138 CRAB ORCHARD RD	COEBURN	VA	24230	ROBERTS DAVID WAYNE		COEBURN	VA	24230	Wise	91738	4	931600	9316	1956.9287	10000	16500	10000	6500	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	605.0242	610.6412	608.0214	0.5300	PERSON		0.53 AC SURVEY TRACT #1 CRAB OR…						L
021636	R021636	51	195	5127 BACK VALLEY RD	BIG STONE GAP	VA	24219	HAMILTON ROY E		BIG STONE GAP	VA	24219	Wise	91588	3	931300	9313	6925.6757	326100	350000	326100	23900	1	51195C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	509.3324	530.8121	523.1757	1.7180	PERSON		PT. TR. 6 J.L. BLEVINS PROP.						RI