Saved query 4016af09877e8817

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

37/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '51' 
  AND countyfp = '057'

10,251 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	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	taxacres	ownertype	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	fireplaces	heating	heatfuel	cooling	foundation	roofcover	lrversion	taxyear
62 A 17	62 A 17	51	057	31056 BETHLEHEM RD	CHAMPLAIN	VA	22438	GREGG DILLON ALEXANDER	31056 BETHLEHEM ROAD	CHAMPLAIN	VA	22438	ESSEX	94879	NORTH	950600	9506	14500.3985	344800	73200	1500	415000	350000	2021-09-01	1	1	1972	1	2353	3	1	3	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	46.7296	56.7199	53.2047	200R	SINGLE FAMILY	RP	4	PERSON	BETHLEHAM	1459	727							HEAT PUMP	ELECTRIC	HEAT PUMP	CONCRETE BLOCK	COMPOSITION	2026.2	2025
48 A 3	48 A 3	51	057	94 HOLLYWOOD FARM RD	FREDERICKSBURG	VA	22405	MURPHY BRIAN E	50 RUBINS WALK	FREDERICKSBURG	VA	22405	ESSEX	94879	NORTH	950600	9506	127717.9200	0	15400		15400	847740	2024-11-15	1	0	0		0	0	0	0	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	41.5432	59.6813	52.5357	500V		RP	28	PERSON	NAULAKLA FOGG 1744	240004474	56	GOVT STATE	CLOSED	OTHER	VIRGINIA OUTDOORS FOUNDATION EA…	CONSERVATION EASEMENT					0		2026.2	2025
1440	2365	51	057	2607 DESHA RD		VA		VIRGINIA HABITAT FOR HUMANITY L…	P O BOX 4826	CHARLOTTESVILLE	VA	22905	ESSEX	90720	CENTRAL	950700	9507	4825.9386	142100	29100		171200	34300	2016-06-20	1	1	1983	1	1222	3	1	1	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	39.7938	41.4309	40.2291	200R	SFD - SUBURBAN - RES	A-2	1.5000	NONPROFIT	ADJ HARRIS	151	575						1	UNDETERMINED	ELECTRIC	NO COOLING	CONCRETE BLK	COMP SHINGLE	2026.2	2025
48 1 1B	48 1 1B	51	057	15033 PASSING RD	BOWLING GREEN	VA	22427	GOTT RANDALL G SR KENNA G	15033 PASSING ROAD	BOWLING GREEN	VA	22427	ESSEX	94879	NORTH	950600	9506	17300.2478	105800	82700	3200	182100	37800	2002-10-17	1	1	1970	1	2104	6	0	1	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	42.9494	55.0295	51.9732	200R		RP	4.9429	PERSON	PASSING	603	109										10		2026.2	2025
6779	7481	51	057	662 GRANARY RD		VA		DAVIS TALLIE EUGENE	P O BOX 819	TAPPAHANNOCK	VA	22560	ESSEX	96027	TAPPAHANNOCK	950700	9507	1082.9765	55700	25000		80700		1991-07-09	1	1	1950	1	600	2	0	1	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	6.8827	7.7111	7.4977	100R	SFD - URBAN RES	CG2	0	PERSON	RICHMOND BEACH LOT 16	183	736							UNDETERMINED	ELECTRIC	NO COOLING	PIERS	COMP SHINGLE	2026.2	2025
48 1 1	48 1 1	51	057		BOWLING GREEN	VA	22427	GOTT ALLEN	PO BOX 186	BOWLING GREEN	VA	22427	ESSEX	94879	NORTH	950600	9506	38481.6947	15000	105400		120400	30200	2004-05-14	1	1	0		0	0	0	0	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	38.6088	53.8902	47.2906	200V		RP	10.0570	PERSON	PASSING	683	668										0		2026.2	2025
48 A 2	48 A 2	51	057	174 KINGS HWY	FREDERICKSBURG	VA	22405	MURPHY BRIAN E	50 RUBINS WALK	FREDERICKSBURG	VA	22405	ESSEX	94879	NORTH			507668.8221	0	65900		65900	847740	2024-11-15	1	0	0		0	0	0	0	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				600V		RP	120.2500	PERSON	NAULAKLA CL-008 GOODWIN-KAY	240004474	700	GOVT STATE	CLOSED	OTHER	VIRGINIA OUTDOORS FOUNDATION EA…	CONSERVATION EASEMENT					0		2026.2	2025
48 1 2	48 1 2	51	057	15033 PASSING RD	BOWLING GREEN	VA	22427	GOTT RANDALL G KENNA G	15033 PASSING ROAD	BOWLING GREEN	VA	22427	ESSEX	94879	NORTH	950600	9506	56474.8964	0	133900		133900	44500	2004-05-14	1	0	0		0	0	0	0	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	43.7615	57.9550	52.1770	200V		RP	14.8200	PERSON	PRATTS WOODS	683	670										0		2026.2	2025
48 A 1	48 A 1	51	057	15 YACHT HAVEN DR	COCOA BEACH	VA	32931	KENNEDY CARY ANDREW JR	15 YACHT HAVEN DR	COCOA BEACH	FL	32931	ESSEX	94879	NORTH	950600	9506	340801.8446	0	44600		44600	162000	2006-02-28	1	0	0		0	0	0	0	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	40.7389	61.7143	54.0584	500V		RP	81	PERSON	NAULAKLA	814	923										0		2026.2	2025
62 A 18	62 A 18	51	057	5357 RICHMOND RD	WARSAW	VA	22572	MARSHALL ILONA	5357 RICHMOND ROAD	WARSAW	VA	22572	ESSEX	94879	NORTH	950600	9506	352401.7545	0	393100		393100	103000	2016-08-31	1	0	0		0	0	0	0	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	37.3461	58.3228	50.3934	500V		RP	56	PERSON	BETHLEHEM	1240	94										0		2026.2	2025
47 A 2	47 A 2	51	057	2555 SUPPLY RD	CARET	VA	22436	NEW SITE CONSTRUCTION LLC	26175 RESERVATION LANE	RUTHER GLEN	VA	22546	ESSEX	94879	NORTH	950600	9506	10900.3773	0	47800		47800	8250	2025-08-27	1	0	0		0	0	0	0	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	54.6104	61.9377	59.2725	200V		RP	1.2800	BUSINESS	NAULAKLA	250003599	415										0		2026.2	2025
2147	3036	51	057	3142 MT LANDING RD		VA		JOHNSON JOSEPHINE LIFE ESTATE	P O BOX 1431	TAPPAHANNOCK	VA	22560	ESSEX	90720	CENTRAL	950700	9507	2560.2887	113900	13300		127200		2023-03-01	1	1	1966	1	960	2	0	1	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	41.9387	43.7070	43.2334	200R	SFD - SUBURBAN - RES	A-2	0.4970	PERSON	ADJ SCOTT								1	CENTRAL AIR	ELECTRIC	OTHER	CONCRETE BLK / CRAWL	COMP SHINGLE	2026.2	2025
9901	87314	51	057	605 LUMBEE INDIAN RD		VA		MCGIRT LARRY	P O BOX 615	MILLERS TAVERN	VA	23115	ESSEX	95751	SOUTH	950800	9508	13157.1753	110000	39600		149600	100000	2012-06-15	1	1	1990	1	1924	0	0	1	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	42.4494	49.5487	47.0305	200R	SFD - SUBURBAN - RES	A-2	3.3060	PERSON	MCGIRT FAMILY DIVISION NORTHERN…								0	CENTRAL AIR	ELECTRIC	CENTRAL AIR	SLAB	COMP SHINGLE	2026.2
61 3 2	61 3 2	51	057	29340 HUSTLE RD	CARET	VA	22436	SEAL NANCY MARLETTE TAYLOR	29340 HUSTLE ROAD	CARET	VA	22436	ESSEX	94879	NORTH	950600	9506	13723.1478	0	2900		2900	18200		1	0	0		0	0	0	0	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	50.6737	57.5470	55.6176	200V		RP	5.1900	PERSON	CLARK SUBD	57	18										0		2026.2	2025
47 A 1	47 A 1	51	057	16825 MACANTHRA DR	CHARLOTTE	VA	28213	TAYLOR HENRIETTA	16825 MACANTHRA DR	CHARLOTTE	NC	28213	ESSEX	94879	NORTH	950600	9506	35653.4785	0	114800		114800	67000		1	0	0		0	0	0	0	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	49.2997	61.9965	56.2204	200V		RP	15	PERSON	A T FARMER	0	0										0		2026.2	2025
48 A 11	48 A 11	51	057	15033 PASSING RD	BOWLING GREEN	VA	22427	GOTT RANDALL G KENNA G	15033 PASSING ROAD	BOWLING GREEN	VA	22427	ESSEX	94879	NORTH	950600	9506	36161.7703	0	101300		101300	6000		1	0	0		0	0	0	0	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	47.9963	59.4050	56.6739	200V		RP	9.2600	PERSON	PASSING	425	384										0		2026.2	2025
9464	86858	51	057	8657 HOWERTON RD		VA		TILLERY BETTY B	P O BOX 164	CENTER CROSS	VA	22437	ESSEX	95751	SOUTH	950800	9508	5690.5814	203800	24700		228500	179500	2008-03-12	1	1	2006	1	1400	3	0	2	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	27.0526	29.9631	29.4144	200R	SFD - SUBURBAN - RES	A-2	1.1299	PERSON	ADJ CLARKSON									CENTRAL AIR	ELECTRIC	CENTRAL AIR	BRICK	COMP SHINGLE	2026.2
8448	85769	51	057	439 LAUREL SPRINGS RD		VA		EARHART JAMES M	800 LAUREL SPRINGS RD	HUSTLE	VA	22476	ESSEX	94879	NORTH	950600	9506	48349.2329	267600	76500		344100	60000	2016-08-09	1	1	2024		1637	3		2	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	29.6425	46.6370	42.5888	200R	SFD - SUBURBAN - RES	A-1	12.9800	PERSON	WINSTON WOODS LOT 8	290	595							HEAT PUMP	ELECTRIC	HEAT PUMP	CONCRETE BLK	COMP SHINGLE	2026.2
8799	86135	51	057	186 THE LEVEL		VA		REYNOLDS WANDA ANN	P O BOX 166	CARET	VA	22436	ESSEX	94879	NORTH	950600	9506	5018.0963	85300	28500		113800	104500	2005-12-21	1	1	2002	1	2052	4	0	2	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	49.6043	51.1685	50.3048	200T	SFD - SUBURBAN - MH	A-2	1.0670	PERSON	THE LEVEL SUBDIVISION LOT 2									CENTRAL AIR	UNDETERMINED	CENTRAL AIR	CONCRETE BLK	COMP SHINGLE	2026.2
8556	85879	51	057	717 CRALLE AVE		VA		BALDERSON CATHERINE A	P O BOX 1983	TAPPAHANNOCK	VA	22560	ESSEX	96027	TAPPAHANNOCK	950700	9507	891.7599	137500	34200		171700		1975-08-01	1	1		1	1261	2	1	1	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	7.4459	7.8275	7.6451	100R	SFD - URBAN RES	R2	0	PERSON	32B 18 A 17								0	CENTRAL AIR	OIL	CENTRAL AIR	CONCRETE BLK	COMP SHINGLE	2026.2
2332	3207	51	057	3749 SUNNYSIDE RD		VA		MARTIN GERTRUDE	3751 SUNNYSIDE RD	ST STEPHENS CHURCH	VA	23148	ESSEX	94879	NORTH	950600	9506	4651.0967	61600	30200		91800		2020-04-22	1	1		1	1800	0	0	0	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	48.5727	50.1410	49.4376	400C	COMM - INDL	A-2	1	PERSON	ADJ RANSOME	154	540									NO COOLING	CONCRETE BLK	COMP SHINGLE	2026.2
48 A 10B	48 A 10B	51	057			VA	0	CEMETERY				0	ESSEX	94879	NORTH	950600	9506	2555.1481	0	1000		1000	1000		1	0	0		0	0	0	0	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	56.2838	58.2582	57.2849	790V		RP	0.0000	NONPROFIT	WALTER MAY VAUGHAN TRACT	0	0										0		2026.2	2025
9763	87175	51	057	2063 MT LANDING RD		VA		PARR JOSEPH R JR	P O BOX 1113	TAPPAHANNOCK	VA	22560	ESSEX	90720	CENTRAL	950700	9507	3898.5302	7500	40800		48300		2009-07-10	1	1		1	2144	0	0	0	51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	24.9744	32.0885	29.6363	400C	COMM - INDL	A-2	1.0880	PERSON	WOODLAND LOT 4D											NO COOLING		METAL	2026.2
5329	6097	51	057	0 ASHDALE RD		VA		WALLACE DENEESE ROSE B	5867 RICHMOND HWY	TAPPAHANNOCK	VA	22560	ESSEX	95751	SOUTH	950800	9508	9489.3735		32700		32700	57000	2026-03-24	1	1	2470	2	2470				51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	34.7237	37.9293	36.2262	200V	SFD - SUBURBAN - VAC	A-2	1.8130	PERSON	AGNES ROBINSON ESTATE LOT 1														2026.2	2025
7889	85196	51	057	1523 GORDONS MILL RD		VA		ROCK OF AGES HOLINESS CHURCH	PAULS CROSS ROADS	TAPPAHANNOCK	VA	22560	ESSEX	90720	CENTRAL	950800	9508	1778.3197	205500	78600		284100		2020-04-22	1	1		1					51057C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	40.5626	42.5588	41.5713	760C	RELIGIOUS - COMM	A-2	0	NONPROFIT	ADJ PAULS CROSS ROADS 0 39 ACRES											NO COOLING	CRAWL	COMP SHINGLE	2026.2