Saved query 8a3e191ed46d8dd3

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

43,457 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	totalvalue	saleamt	saledate	numbldgs	numunits	yearbuilt	numfloors	bldgsqft	bedrooms	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	ownertype	legaldesc	book	page	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
038 31B	3775-19-6307	51	015	285 PATTERSON MILL RD	GROTTOES	VA	24441	HOWDYSHELL ELIZABETH M	285 PATTERSON MILL RD	GROTTOES	VA	24441	AUGUSTA	94671	MIDDLE RIVER	070400	704	8050.1438	191800	70000	261800		1990-01-19	1	1	1992	1	1749	3	0	2	51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	365.6130	373.2489	370.2685	2.0010	PERSON	38 31B NEW HOPE S RT 778 2 001 …	1000	458	0	FORCED AIR	UNDETERMINED	FULL	CONCRETE	COMP SHINGLE	VINYL	2026.2	2027	02: MIDDLE RIVER
075B1 2 300	075B1 2 300	51	015	10 GEMSTONE DR		VA		THE SMITH REVOVCABLE TRUST	10 GEMSTONE DR	STUARTS DRAFT	VA	24477	AUGUSTA	95791	SOUTH RIVER	071101	711.0100	1117.4951	333600	65000	398600	251100	2014-11-13	1	1	2014	1	1697	3	0	2	51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0.2800	TRUST	75B1 2 300 STONE VALLEY PH 2 IV…	0	0	0	HEAT PUMP	ELECTRIC	HEAT PUMP	CONC/BLOCK	COMP SHINGLE	VINYL	2026.2	2027	06: SOUTH RIVER
059A 3 1	059A 3 1	51	015	40 HUGGINS CIR		VA		HASKINS JAMES PETER OR NORVA FA…	40 HUGGINS CIR	CRIMORA	VA	24431	AUGUSTA	94671	MIDDLE RIVER	070400	704	3984.7474	3100	47500	50600	22000	2000-06-14	1	1			0				51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				1.1540	PERSON	59A 3 1 PORT LOT 1 H J COFFMAN …	0	0								2026.2	2027	02: MIDDLE RIVER
076A 6 2 5	076A 6 2 5	51	015		UNASSIGNED	VA		SMITH ROBERT E SMITH DEBRA S	146 HILLSIDE DR	VERONA	VA	24482	AUGUSTA	95791	SOUTH RIVER	071202	712.0200	1197.1831		800	800	93000	2001-08-13	1				0				51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0.2700	PERSON	46C 7 4 6 RIVERSIDE HEIGHTS REV…	0	0								2026.2	2027	01: BEVERLEY MANOR
065A 1 2 7	065A 1 2 7	51	015		UNASSIGNED	VA		SMITH ROBERT E SMITH DEBRA S	146 HILLSIDE DR	VERONA	VA	24482	AUGUSTA	90272	BEVERLEY MANOR	070900	709	2073.4531		800	800	93000	2001-08-13	1				0				51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0.4500	PERSON	46C 7 4 6 RIVERSIDE HEIGHTS REV…	0	0								2026.2	2027	01: BEVERLEY MANOR
065A 5 D 3	065A 5 D 3	51	015		UNASSIGNED	VA		SMITH ROBERT E SMITH DEBRA S	146 HILLSIDE DR	VERONA	VA	24482	AUGUSTA	90272	BEVERLEY MANOR	070900	709	4465.7678		800	800	93000	2001-08-13	1				0				51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				1.0560	PERSON	46C 7 4 6 RIVERSIDE HEIGHTS REV…	0	0								2026.2	2027	01: BEVERLEY MANOR
026 71C	026 71C	51	015		UNASSIGNED	VA		SMITH ROBERT E SMITH DEBRA S	146 HILLSIDE DR	VERONA	VA	24482	AUGUSTA	94911	NORTH RIVER	070300	703	1671.2605		800	800	93000	2001-08-13	1				0				51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0.4300	PERSON	46C 7 4 6 RIVERSIDE HEIGHTS REV…	0	0								2026.2	2027	01: BEVERLEY MANOR
074 86B	074 86B	51	015		UNASSIGNED	VA		SMITH ROBERT E SMITH DEBRA S	146 HILLSIDE DR	VERONA	VA	24482	AUGUSTA	95335	RIVERHEADS	070900	709	37751.9149		800	800	93000	2001-08-13	1				0				51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				9.1900	PERSON	46C 7 4 6 RIVERSIDE HEIGHTS REV…	0	0								2026.2	2027	01: BEVERLEY MANOR
031 27B	031 27B	51	015		UNASSIGNED	VA		SMITH ROBERT E SMITH DEBRA S	146 HILLSIDE DR	VERONA	VA	24482	AUGUSTA	94999	PASTURES	070100	701	30967.3545		800	800	93000	2001-08-13	1				0				51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				7.6300	PERSON	46C 7 4 6 RIVERSIDE HEIGHTS REV…	0	0								2026.2	2027	01: BEVERLEY MANOR
027 68F	027 68F	51	015		UNASSIGNED	VA		SMITH ROBERT E SMITH DEBRA S	146 HILLSIDE DR	VERONA	VA	24482	AUGUSTA	94911	NORTH RIVER	070300	703	4138.3033		800	800	93000	2001-08-13	1				0				51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				1.0320	PERSON	46C 7 4 6 RIVERSIDE HEIGHTS REV…	0	0								2026.2	2027	01: BEVERLEY MANOR
020A 3 23	3768-38-1039	51	015	0	UNASSIGNED	VA	0	EASTERN TERMINALS INC	P O BOX 220	WEYERS CAVE	VA	24486	AUGUSTA	94671	MIDDLE RIVER	070300	703	318.2219	1100	21300	22400			1	1	0						51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	356.3450	357.1510	356.8974	0.1400	BUSINESS	20A 3 23 WEYERS CAVE 14 ACRE										2026.2
021A 5 36	021A 5 36	51	015		UNASSIGNED	VA		SMITH ROBERT E SMITH DEBRA S	146 HILLSIDE DR	VERONA	VA	24482	AUGUSTA	94999	PASTURES	070100	701	29200.0634		800	800	93000	2001-08-13	1				0				51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				7.0700	PERSON	46C 7 4 6 RIVERSIDE HEIGHTS REV…	0	0								2026.2	2027	01: BEVERLEY MANOR
061A 5 16	061A 5 16	51	015	UNASSIGNED ST		VA		GRAHAM ALFRED J OR ELIZABETH A	189 OAK ST	CRAIGSVILLE	VA	24430	AUGUSTA	94999	PASTURES	070100	701	398.8960		2700	2700	40000	2003-10-07	1				0				51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				0.0770	PERSON	061A 5 16 40FT RIGHT OF WAY	0	0								2026.2	2027	07: CRAIGSVILLE, TOWN OF
058 113P	058 113P	51	015		UNASSIGNED	VA		SMITH ROBERT E SMITH DEBRA S	146 HILLSIDE DR	VERONA	VA	24482	AUGUSTA	96271	WAYNE	070500	705	9886.2839		800	800	93000	2001-08-13	1				0				51015C	2026-01-08	AE					2.5000	PERSON	46C 7 4 6 RIVERSIDE HEIGHTS REV…	0	0								2026.2	2027	01: BEVERLEY MANOR
074 58H	074 58H	51	015		UNASSIGNED	VA		SMITH ROBERT E SMITH DEBRA S	146 HILLSIDE DR	VERONA	VA	24482	AUGUSTA	95335	RIVERHEADS	070900	709	17000.1345		800	800	93000	2001-08-13	1				0				51015C	2026-01-08	A					4.1240	PERSON	46C 7 4 6 RIVERSIDE HEIGHTS REV…	0	0								2026.2	2027	01: BEVERLEY MANOR
010 58A	010 58A	51	015		UNASSIGNED	VA		SMITH ROBERT E SMITH DEBRA S	146 HILLSIDE DR	VERONA	VA	24482	AUGUSTA	94911	NORTH RIVER	070200	702	8108.1312		800	800	93000	2001-08-13	1				0				51015C	2026-01-08	AE					2	PERSON	46C 7 4 6 RIVERSIDE HEIGHTS REV…	0	0								2026.2	2027	01: BEVERLEY MANOR
074 139V	3710-94-5247	51	015	0 GUTHRIE RD VA		VA	0	KNOX DARCY DWIGHT ORKASEY L	522 GUTHRIE RD	STAUNTON	VA	24401	AUGUSTA	95335	RIVERHEADS	070900	709	19711.4534	14400	70500	84900			1	1	0						51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	409.9750	420.8039	417.1322	5.2310	PERSON	74-139V W RT 252 DIV OF COYNER …										2026.2
058 141J		51	015	UNASSIGNED RD	WAYNESBORO	VA		WISEMAN MITCHELL N WISEMAN SYRE…	59 LIPTRAP LN	STUARTS DRAFT	VA	24477	AUGUSTA	96271	WAYNE	070601	706.0100	32364.7271		278500	278500	166667	2025-08-27	1				0				51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	388.9739	399.0400	393.7936	8	PERSON	DIVISION OF WISEMAN POR OF 31 1…										2026.2	2027	02: MIDDLE RIVER
054A 2 11 3	3703-18-8945	51	015	0	UNASSIGNED	VA	0	JORDAN ENTERPRISES LLC	4159 MORRIS MILL RD	SWOOPE	VA	24479	AUGUSTA	94999	PASTURES	070802	708.0200	603.3529		1400	1400			0		0						51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	500.3219	503.5299	502.4609	0.1719	BUSINESS	54A 2 11-3 BEVERLEY VILLAGE LOT…										2026.2
065A 1 4 8	3712-64-8434	51	015	0	UNASSIGNED	VA	0	MCDONALD P KEITHMCDONALD TRACEE…	3 WOODCREST RD	STAUNTON	VA	24401	AUGUSTA	90272	BEVERLEY MANOR	070900	709	1036.6738		2200	2200			0		0						51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	513.0689	527.3939	520.0989	0.2750	PERSON	65A 1 4-8 JOLLIVUE BLK 4 LOT 8										2026.2
085G1 1 14	3648-20-3851	51	015	0	UNASSIGNED	VA	0	DELASHMUTT CHARLES BSAMUEL ENGL…	4411 ROCK SPRING RD	ARLINGTON	VA	22207	AUGUSTA	95791	SOUTH RIVER	071201	712.0100	16214.0142		70900	70900			0		0						51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	455.9549	464.2460	460.1817	4.0900	PERSON	85G1 1 14 S RT 610 W SHERANDO 4…										2026.2
094 7	2676-23-4780	51	015	0	UNASSIGNED	VA	0	FITZGERALD CALVERT S ORMARY R	P O BOX 174	RAPHINE	VA	24472	AUGUSTA	95335	RIVERHEADS	071000	710	1880.6645		498800	498800			0		0						51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	557.0845	565.1226	562.6855	105	PERSON	94-7 NEAR ROCKBRIDGE CO LINE 10…										2026.2
039 65W	3795-37-3744	51	015	0	UNASSIGNED	VA	0	BLOSSER JERRY DEAN II	103 NORTHSHORE DR	BRIDGEWATER	VA	22812	AUGUSTA	94671	MIDDLE RIVER	070400	704	40618.9303		75000	75000			0		0						51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	397.2090	407.2049	402.9646	10.0399	PERSON	39-65W PROPERTY ALONG PAYNES RU…										2026.2
088 87B	2686-08-3264	51	015	0	UNASSIGNED	VA	0	BLUE RIDGE FARMS LLC	1085 WOOD LN	CHARLOTTESVILLE	VA	22901	AUGUSTA	95335	RIVERHEADS	071000	710	26370.4265		71900	71900			0		0						51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	557.0650	561.7000	559.4177	6	BUSINESS	88-87B E RT 81 64 NEAR SPOTTSWO…										2026.2
074 84	3710-21-8037	51	015	0	UNASSIGNED	VA	0	KERN THOMAS DJR TRUSTEE	353 GENEVA LN	CARY	IL	60013	AUGUSTA	95335	RIVERHEADS	070900	709	6065.7935		3200	3200			0		0						51015C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	417.9039	429.2040	425.8263	0.5000	TRUST	74-84 ADJ FRANK BOCOCK 500 ACRES										2026.2