Saved query 0427c6b50a3a5e13

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

43/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '54' 
  AND countyfp = '097'

20,413 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usedesc	taxacres	ownertype	legaldesc	book	page	lrversion	taxyear	taxdistrict
10 23000700000000	54	097	6790 HALL RD	BUCKHANNON	WV	26201	HALL JOSEPH STEPHEN & JANET WS	6790 HALL RD	UPSHUR	92745	SECOND	966600	9666	43343.8645	124400	34800		159200	1	1	54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	475.8680	499.8827	488.4453	ACTIVE FARM	14.2100	PERSON	14.21 SUR	WB47	349	2026.2	2026	UNION
10 23000700010000	54	097	6777 HALL RD	BUCKHANNON	WV	26201	HALL JOSEPH S & JANET WS	6777 HALL RD	UPSHUR	92745	SECOND	966600	9666	3724.0722	144000	30500		174500	1	1	54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	492.7667	502.0996	496.5108	RESIDENTIAL 1 FAMILY	0.9040	PERSON	0.904 SUR	273	127	2026.2	2026	UNION
10 17000300020000	54	097	DICK HALL RD	WESTON	WV	26452	WESTFALL MICHAEL & ELIZABETH	PO BOX 310	UPSHUR	92745	SECOND	966600	9666	5519.4481	90500	33200		123700	1	1	54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	435.0017	438.2720	437.0252	RESIDENTIAL 1 FAMILY	1.3600	PERSON	1.36 SUR (LOT B)	465	389	2026.2	2026	UNION
10 17000300030000	54	097	DICK HALL RD	BUCKHANNON	WV	26201	DANSELMI JOY & WENDELL GROSE	132 DICK HALL RD	UPSHUR	92745	SECOND	966600	9666	1992.7830	72300	23500		95800	1	1	54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	434.9434	437.6570	436.0598	RESIDENTIAL 1 FAMILY	0.4700	PERSON	0.47 AC SUR	488	547	2026.2	2026	UNION
10 17000300010000	54	097	MURPHY STATION RD	BUCKHANNON	WV	26201	THROPP CHAD A & PAMELA K HWS	2791 TETER RD	UPSHUR	92745	SECOND	966600	9666	2150.0780	134400	24800		159200	1	1	54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	437.9424	442.0288	439.9988	RESIDENTIAL 1 FAMILY	0.5500	PERSON	0.55 SUR	461	411	2026.2	2026	UNION
10 17004500000000	54	097	1378 MURPHY STATION RD	BUCKHANNON	WV	26201	ZIRKLE SANFORD & CLAUDIA HWS	1378 MURPHY STATION RD	UPSHUR	92745	SECOND	966600	9666	55826.9313	82900	35000		117900	1	1	54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	427.5165	453.6774	437.6402	ACTIVE FARM	14	PERSON	14 ACS SUR	388	486	2026.2	2026	UNION
10 23001200000000	54	097	RIVERVIEW RD	FAIRMONT	WV	26555	CUTRIGHT STEVEN L &	PO BOX 1973	UPSHUR	92745	SECOND	967100	9671	2623.8977	23500	31000		54500	1	1	54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	421.2440	427.2839	423.8752	RESIDENTIAL 1 FAMILY	1.3400	PERSON	1.34 SUR	407	365	2026.2	2026	UNION
10 23001300000000	54	097	RIVERVIEW RD	NEW CUMBERLAND	WV	26047	FRAKER ANDREW L/E	436 AZTEC LN	UPSHUR	92745	SECOND	967100	9671	3290.5657	15300	25900		41200	1	1	54097C	2025-01-17	A		420.6099	424.1072	422.7792	RESIDENTIAL 1 FAMILY	0.4800	PERSON	0.48 AC SUR	WB36	158	2026.2	2026	UNION
10 17000300000000	54	097	MURPHY STATION RD	WESTON	WV	26452	BUSH ROY D & JULIA	PO BOX 310	UPSHUR	92745	SECOND	966600	9666	16375.4876	112300	39600		151900	1	1	54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	435.3919	446.3294	441.9518	RESIDENTIAL 1 FAMILY	3.3700	PERSON	3.37 AC SUR	217	451	2026.2	2026	UNION
10 22002100010000	54	097	ISLAND RUN	BUCKHANNON	WV	26201	WENTZ GARY W & MARGARET M L/E	341 E PECKS RUN RD	UPSHUR	92745	SECOND	967100	9671	146288.1083	500	107900		108400	1	1	54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	485.3863	593.7532	545.5890	AUXILIARY IMPROVEMENTS	35.5500	PERSON	35.55 AC SUR	501	460	2026.2	2026	UNION
10 17002700000000	54	097	1666 MURPHY STATION RD	BUCKHANNON	WV	26201	BENDER RONALD L &	1722 MURPHY STATION RD	UPSHUR	92745	SECOND	966600	9666	111785.2247	59200	50600		109800	1	1	54097C	2025-01-17	A		425.2851	445.1562	429.9440	ACTIVE FARM	30.7600	PERSON	30.76 SUR	503	392	2026.2	2026	UNION
10 23001300010000	54	097	RIVERVIEW RD	GRAFTON	WV	26354	GILLESPIE CHARLES J &	252 BEAUMONT RD	UPSHUR	92745	SECOND	967100	9671	808.7724	20800	21900		42700	1	1	54097C	2025-01-17	A		422.1695	424.5815	423.6307	RESIDENTIAL 1 FAMILY	0.2500	PERSON	0.25 SUR	338	596	2026.2	2026	UNION
10 22001200000000	54	097	RIVERVIEW RD	WINDSOR	WV	17366	HIVNER BARRY B & ROSE M HWS	140 NEWCOMER RD	UPSHUR	92745	SECOND	967100	9671	192290.9050		149500		149500			54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	422.5235	561.6278	498.7373	RESIDENTIAL VACANT LAND	49.8200	PERSON	49.82 AC SUR	365	051	2026.2	2026	UNION
10 7000400000000	54	097	CLARKSBURG RD	ORANGE	WV	22960	WINKLER CHARLES A & MARLENE K	16180 MOUNTAIN TRACK RD	UPSHUR	92745	SECOND	966600	9666	203345.0121		149200		149200			54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	336.0613	450.7123	361.5507	RESIDENTIAL VACANT LAND	48	PERSON	48 AC SUR	416	60	2026.2	2026	UNION
10 17002800010000	54	097		BUCKHANNON	WV	26201	BENDER TERRY	1800 MURPHY STATION RD	UPSHUR	92745	SECOND	966600	9666	9521.7259		7300		7300			54097C	2025-01-17	A		423.1887	426.7340	425.0734	RESIDENTIAL VACANT LAND	3.3300	PERSON	3.33 SUR	555	58	2026.2	2026	UNION
10 23000800000000	54	097	HALL RD	BUCKHANNON	WV	26201	HALL JOSEPH STEPHEN & JANET WS	6790 HALL RD	UPSHUR	92745	SECOND	966600	9666	86843.3469		3900		3900			54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	472.2478	504.8605	488.5607	ACTIVE FARM	19.1940	PERSON	19.194 SUR	WB47	349	2026.2	2026	UNION
10 23001100000000	54	097	RIVERVIEW RD	CHARLESTON	WV	25301	GANDEE JAMES D REV TRUST	10 HALE ST	UPSHUR	92745	SECOND	967100	9671	632.6756		12000		12000			54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	422.3337	427.2448	424.6418	RESIDENTIAL VACANT LAND	0.6000	TRUST	0.60 SUR	485	223	2026.2	2026	UNION
10 17002800000000	54	097	MURPHYS STATION RD	BUCKHANNON	WV	26201	BENNETT JEREMY B & AMANDA WS	1665 MURPHY STATION RD	UPSHUR	92745	SECOND	966600	9666	21154.6592		700		700			54097C	2025-01-17	A		423.3477	426.1559	425.2023	ACTIVE FARM	6.6700	PERSON	6.67 SUR	555	58	2026.2	2026	UNION
10 16000400000000	54	097		BIG RUN	WV	26508	LYONS MORGAN H & HILDA RVC TR	134 SKYLINE DR	UPSHUR	92745	SECOND	966600	9666	296542.6411		276100		276100			54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	448.6308	534.9111	484.3302	LG. VACANT TRACTS W/UNKNOWN	95.2000	TRUST	95.2 FEE	WB47	626	2026.2	2026	UNION
10 22002100000000	54	097	ISLAND RUN	BUCKHANNON	WV	26201	WENTZ GARY W & MARGARET M HWS	341 E PECKS RUN RD	UPSHUR	92745	SECOND	967100	9671	81596.2526		79900		79900			54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	473.6246	558.4202	511.3726	RESIDENTIAL VACANT LAND	26.6200	PERSON	26.62 AC SUR	086	459	2026.2	2026	UNION
10 23001300020000	54	097		GRAFTON	WV	26354	GILLESPIE CHARLES J & MARY HWS	252 BEAUMONT RD	UPSHUR	92745	SECOND	967100	9671	1145.1102		800		800			54097C	2025-01-17	A		421.9146	424.0697	423.5091	RESIDENTIAL VACANT LAND	0.2640	PERSON	0.264 AC SUR	357	543	2026.2	2026	UNION
10 23001300030000	54	097	RIVERVIEW RD	BUCKHANNON	WV	26201	WOODY STEVEN W ET ALS	201 VICKSBURG RD	UPSHUR	92745	SECOND	967100	9671	287001.6426							54097C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	421.7654	555.7055	489.4186	RESIDENTIAL VACANT LAND	59.4000	PERSON	59.4 AC SUR	568	512	2026.2	2026	UNION
03 14001100070000	54	097			WV		PERRY PAULINE G	30 UPPER DRIVE	UPSHUR	91102	FIRST	966800	9668	302.9355	28800	9000	0	37800	1	1			—		446.2858	452.2236	449.1276	MOBILE HOME		PERSON	PART OF LOT 23A	0325	0371	2026.2	2018
07 6J000700090000	54	097			WV		SHAW CRYSTAL D	187 RANDOLPH ST	UPSHUR	93105	THIRD	966800	9668	1898.8401	0	500	0	500					—		489.5124	500.6376	495.5520	RESIDENTIAL VACANT LAND		PERSON	SUR 0.453	0554	0607	2026.2	2021
03 14002900010000	54	097			WV		BROWN JOSEPH R	49 UPPER DR	UPSHUR	91102	FIRST	966800	9668	278.1893	0	5200	0	5200					—		440.2263	446.9945	444.0626	RESIDENTIAL VACANT LAND		PERSON	EASTERN 1/2 LOT G SEC 1	0574	0030	2026.2	2018