Saved query 216a9d6074a890ec

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

45/80

Live SQL

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

62,074 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	bldgsqft	bedrooms	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	usecode	usedesc	zoningcode	taxacres	ownertype	legaldesc	book	page	heating	heatfuel	cooling	foundation	roofcover	lrversion	taxyear	taxdistrict
8033254	23 A 8B	54	003	474 RUEBUCK RD	CLEAR BROOK	WV	22624	RISSER JOHN D	474 RUEBUCK RD	CLEAR BROOK	VA	22624	BERKELEY	92754	SHENANDOAH	972101	9721.0100	124330.6728	551700	94600	-37600	721500	530533	2021-04-01	1	1	1991	3632	4	1	4	54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	2	SINGLE FAMILY	RA	5.9000	PERSON	5 90 ACRES	5533	0	HEAT PUMP	ELECTRIC	HEAT PUMP	CONCRETE	COMPOSITION	2026.2	2025	GAINESBORO
8004660	22 A 101	54	003	4455 APPLE PIE RIDGE RD	WINCHESTER	WV	22603	MANK DANA P TRUSTEE	4452 APPLE PIE RIDGE RD	WINCHESTER	VA	22603	BERKELEY	93388	VALLEY	971801	9718.0100	649997.2747	-67300	-238680	-711180	1116380		2023-12-26	1	1	1988	2970	4	1	2	54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	5	SINGLE FAMILY	RA	60	TRUST	60 00 ACRES	11262	0	HEAT PUMP	ELECTRIC	HEAT PUMP	CONCRETE BLOCK	COMPOSITION	2026.2	2025	STONEWALL
8006823	34 A 131	54	003	WOODSIDE RD	CLEAR BROOK	WV	22624	GRO-GREEN PROPERTIES LLC	3276 WOODSIDE RD	CLEAR BROOK	VA	22624	BERKELEY	92754	SHENANDOAH	972101	9721.0100	19329.3808	109200	12300		121500		2002-12-27	1	1	0					54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	2	NONE	RA	1.3700	BUSINESS	1.37 ACRES	22631	0						2026.2		STONEWALL
8004638	22 A 82A	54	003		UNASSIGNED	WV	25420	BELFORD GARY W	3925 DOMINION RD	GERRARDSTOWN	WV	25420	BERKELEY	93388	VALLEY	971801	9718.0100	6310.1064	500	8500		9000			1	1	0							—		2	NONE	RA	1.0600	PERSON	1.06 ACRES	506	566						2026.2		GAINESBORO
07006B02010000	07 6B020100000000	54	003	WINCHESTER AVE	MARTINSBURG	WV	25401	INWOOD VILLAGE HOMEOWNERS ASSOC…	115 N QUEEN ST	MARTINSBURG	WV	25401	BERKELEY	92754	SHENANDOAH	972105	9721.0500	30113.3308														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	630			12.4671	NONPROFIT	7.72 AC OPEN SPACE INWOOD VILL…	1356	610						2026.2		07
02003L07770000	02 3L077700000000	54	003	WILDERNESS RD	MARTINSBURG	WV	25403	WASHINGTON MANUEL H JR	77 CLARION CT	MARTINSBURG	WV	25403	BERKELEY	92526	POTOMAC	971103	9711.0300	371.9490														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	100			0.1548	PERSON	LOT 47 BLK 4 POTOMAC PARK	402	417						2026.2		02
06000600100000	06 6001000000000	54	003	ROTHWELL AVE	INWOOD	WV	25428	MESSICK HAROLD JR MESSICK RENATE	64 SHICKLE LN	INWOOD	WV	25428	BERKELEY	90006	ADAM STEPHENS	971600	9716	475.8530														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	100			0.1975	PERSON	LOT 69 R&L ADN 40X130	428	293						2026.2		06
02014P01360000	02 14P013600000000	54	003	54 CREIGHTON CT	MARTINSBURG	WV	25404	OSBORNE DIANNA L	54 CREIGHTON CT	MARTINSBURG	WV	25404	BERKELEY	92526	POTOMAC	971101	9711.0100	928.9569														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			0.3864	PERSON	.23 ACRE LOT 172 PHASE IV HAMMO…	WB129	134						2026.2		02
04038L00930000	04 38L009300000000	54	003	363 CORALBERRY DR	MARTINSBURG	WV	25401	CUOZZO JOANMARIE	363 CORALBERRY DR	MARTINSBURG	WV	25401	BERKELEY	92322	NORBORNE	971301	9713.0100	782.9621														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			0.3252	PERSON	.19 AC LOT 35 SEC 2 FERNWOOD	1093	73						2026.2		04
02001E05530000	02 1E055300000000	54	003		GREENCASTLE	WV	17125	SCOTT CHESTER SCOTT SARA	15489 SKYLINE DR	GREENCASTLE	PA	17125	BERKELEY	93388	VALLEY	971104	9711.0400	233.7563														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	109			0.0973	PERSON	BLK 93 LOT 29 JELLYSTONE RIVER …	1107	340						2026.2		02
08011A00640000	08 11A006400000000	54	003	71 ARISTIDES WAY	MARTINSBURG	WV	25404	DEAVERS ROBERT CARSON DEAVERS J…	71 ARISTIDES WAY	MARTINSBURG	WV	25404	BERKELEY	93171	TUSCARORA	971302	9713.0200	929.1525														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			0.3859	PERSON	.23 AC LOT 433 BRIDLE CREEK PHZ…	1284	546						2026.2		08
02009C00060000	02 9C000600000000	54	003	93 MICHELLE DR	HEDGESVILLE	WV	25427	DAYMUDE MICHAEL W	94 MICHELLE DR	HEDGESVILLE	WV	25427	BERKELEY	92526	POTOMAC	971105	9711.0500	4459.5870														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			1.8570	PERSON	1.10 AC LOT 6 SCENIC VIEW EST	1124	682						2026.2		02
01010F01320000	01 10F013200000000	54	003	EVANS RUN DR	MARTINSBURG	WV	25405	LAZARO ALVARO M	39 CHARDONNAY AVE	MARTINSBURG	WV	25405	BERKELEY	93388	VALLEY	971901	9719.0100	1377.4949														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	100			0.5712	PERSON	.36 AC LT O-1 PIKEVIEW AC NORTH	1336	317						2026.2		01
08000800150027	08 8001500270000	54	003	208 CHALCEDONY DR	MARTINSBURG	WV	25404	HESS SABRINA D LATINI ANGELA M …	208 CHALCEDONY DR	MARTINSBURG	WV	25404	BERKELEY	93171	TUSCARORA	971401	9714.0100	8034.1131														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			3.3379	PERSON	2.01 AC LOT 22 GREENSBURG ESTAT…	1408	571						2026.2		08
03003200040002	03 32000400020000	54	003	1387 HORNERS SAWMILL RD	INWOOD	WV	254280981	WRIGHT DAVID J JR	P O BOX 981	INWOOD	WV	254280981	BERKELEY	93388	VALLEY	971801	9718.0100	2293.4955														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	108			0.9499	PERSON	.49 AC OFF W/SIDE RT 24	464	624						2026.2		03
01019A01250000	01 19A012500000000	54	003	116 PONY CIR	MARTINSBURG	WV	25405	CHAPMAN HELEN B	116 PONY CIR	MARTINSBURG	WV	25405	BERKELEY	92754	SHENANDOAH	971901	9719.0100	299.3551														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			0.1239	PERSON	LOT 195 PHASE 5 TH MILLS FARM S…	846	172						2026.2		01
06003300220000	06 33002200000000	54	003	104 SPINNERS LN	MARTINSBURG	WV	25401	STENSON AMBER R	104 SPINNERS LN	MARTINSBURG	WV	25401	BERKELEY	92322	NORBORNE	971301	9713.0100	598.5237														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			0.2485	PERSON	.16 ACRE LOT 17 SECTION 2 DRY R…	1298	198						2026.2		06
06002301250000	06 23012500000000	54	003	109 EQUINOX WAY	FALLING WATERS	WV	25419	HALL BRIAN K HALL JUSTINE M	377 SUSSEX DR	FALLING WATERS	WV	25419	BERKELEY	93171	TUSCARORA	972002	9720.0200	668.9943														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			0.2775	PERSON	LOT 109 SEC 2 PHASE 4 PRENTISS …	1343	607						2026.2		06
07009D01750000	07 9D017500000000	54	003	360 WENDOVER DR	BUNKER HILL	WV	25413	HOGAN ROSA L	360 WENDOVER DR	BUNKER HILL	WV	25413	BERKELEY	92754	SHENANDOAH	972103	9721.0300	1596.6900														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			0.6607	PERSON	.39 ACRE LOT 107 SECTION D PH 3…	807	345						2026.2		07
04022E01430000	04 22E014300000000	54	003	338 AVALON TRL	HEDGESVILLE	WV	25427	BURGER ADAM D BURGER AMY L	338 AVALON TRL	HEDGESVILLE	WV	25427	BERKELEY	93388	VALLEY	971205	9712.0500	891.3491														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			0.3710	PERSON	.22 AC LOT 103 SEC 3 PHASE 2 ST…	1281	577						2026.2		04
01005M01330000	01 5M013300000000	54	003	87 SARGENT LN	MARTINSBURG	WV	25401	WASHINGTON HAROLD	87 SARGENT LN	MARTINSBURG	WV	25401	BERKELEY	93171	TUSCARORA	971901	9719.0100	724.7136														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			0.3005	PERSON	.18 AC LOT 47 PHASE 2 MCGINNIS …	1257	427						2026.2		01
04033S00190000	04 33S001900000000	54	003	587 BRAEBURN DR	MARTINSBURG	WV	254037558	TRAM VINCE C HUA HAN N	587 BRAEBURN DR	MARTINSBURG	WV	254037558	BERKELEY	92322	NORBORNE	971206	9712.0600	2270.5755														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			0.9437	PERSON	.56 AC LOT 19 PHASE 1 APPLE KNO…	1186	150						2026.2		04
04003900010004	04 39000100040000	54	003	6723 TUSCARORA PIKE	MARTINSBURG	WV	254035900	EARDLEY JOHN SR EARDLEY DONNA	6723 TUSCARORA PIKE	MARTINSBURG	WV	254035900	BERKELEY	92322	NORBORNE	971206	9712.0600	9339.3176														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			3.8783	PERSON	2.31 AC BASE N MTN	906	321						2026.2		04
01001900350026	01 19003500260000	54	003	1828 NADENBOUSCH LN	INWOOD	WV	25428	CAMPBELL DENNIS L CAMPBELL JUDY…	1828 NADENBOUSCH LN	INWOOD	WV	25428	BERKELEY	92754	SHENANDOAH	971901	9719.0100	4743.6324														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	101			1.9638	PERSON	1.19 AC LOT B PLAT OF SURVEY BA…	483	481						2026.2		01
04002200190000	04 22001900000000	54	003	95 BEN SPECK RD	HEDGESVILLE	WV	25427	HESS HELEN L	95 BEN SPECK RD	HEDGESVILLE	WV	25427	BERKELEY	93388	VALLEY	971205	9712.0500	1385.9395														54003C	2025-01-17	X	AREA OF MINIMAL FLOOD HAZARD	109			0.5767	PERSON	LOT #2 A. A. HESS LOTS 100X150	AB37	637						2026.2		04