Saved query c95b666c7b83541b

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

41/80

Live SQL

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

14,336 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	staticbfe	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	taxacres	ownertype	naicscode	legaldesc	book	page	placename	placetype	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
26B 1 49	26B 1 49	51	119	868 GLOUCESTER RD	SALUDA	VA	23149	HWH ASSOCIATES	P O BOX 120	SALUDA	VA	23149 0120	MIDDLESEX	95559	SALUDA	951000	9510	3665.7894	-62200	-310900	-390900	408700	199500	1997-02-01	1	1	1990	1	0	0	4	0	51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		28.3414	29.6127	29.1323	400C	COMMERICAL/INDUSTRAL - COM	GB	0.8100	PERSON	5313	842 AC	264	101	LAWYERS TITLE	REAL_ESTATE_SERVICE	0	HEAT PUMP	ELECTRIC	HEAT PUMP	BRICK	METAL/TIN	VINYL	2026.2	2025	3
4252	5044	51	119	186 BUTYLO RD		VA		CURTIS PHYLLIS A	P O BOX 129	SALUDA	VA	23149	MIDDLESEX	94023	JAMAICA	950900	9509	19068.2238	63900	31700		95600	13700	1998-01-07	1	1	2003	1	1352	3	0	2	51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		30.8780	36.6243	34.2061	200T	SFD - SUBURBAN - MH	A-2	3.5000	PERSON		ADJ HALL						CENTRAL AIR	ELECTRIC	CENTRAL AIR	PIERS	COMP SHINGLE		2026.2	2025
38 240	1655	51	119	1109 BARRICKS MILL RD	WAKE	VA	23176	KING BARRY	2109 LYDELL DRIVE	RICHMOND	VA	23228	MIDDLESEX	95079	PINE TOP	951100	9511	8011.6804	-44900	0	-50000	55100		2013-08-30	1	1			0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		12.1330	16.1448	14.6558	200V	SINGLE FAMILY SUBURB - VAC	LDR	1.7500	PERSON		1 75 AC	13	1541										2026.2	2025	2
44 1 5B	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95079	PINE TOP	951200	9512	7805.5606	541000	343800		884800	15000	1993-09-01	1	1			0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		-0.0900	9.5750	4.7017	200V	SINGLE FAMILY SUBURB - VAC	R	2.0600	PERSON		2 06 AC D24 992	0	0										2026.2	2025	2
26A 1 3	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95559	SALUDA	951000	9510	3662.7297	15900	100000		115900	15000	1993-09-01	1	1			0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		-0.0900	18.0880	8.7120	200V	SINGLE FAMILY SUBURB - VAC	R	0.4100	PERSON		41 AC	0	0										2026.2	2025	3
8 35	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	94023	JAMAICA	950900	9509	1502404.9531	4300	549100		553400	15000	1993-09-01	1	1			0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD					200V	SINGLE FAMILY SUBURB - VAC	R	370	PERSON		370 00 AC LUCA	0	0	MUSICA SOLIS	MEDIA_SERVICE								2026.2	2025	1
8 23	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	94023	JAMAICA	950900	9509	235282.0436		86000		86000	15000	1993-09-01	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		0.1309	25.7806	16.0424	200V	SINGLE FAMILY SUBURB - VAC	R	62	PERSON		62 00 AC	0	0										2026.2	2025	1
40 385A	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95079	PINE TOP	951200	9512	2618.1217		30000		30000	15000	1993-09-01	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		-0.0900	3.3275	0.4417	200V	SINGLE FAMILY SUBURB - VAC	R	1.0960	PERSON		1 096 AC	0	0										2026.2	2025	2
41 44 298	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95079	PINE TOP	951200	9512	629.4480		30000		30000	15000	1993-09-01	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		1.6980	2.1161	1.9222	200V	SINGLE FAMILY SUBURB - VAC	R	0	PERSON		LOTS 298 300	0	0										2026.2	2025	2
41 42 6	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95079	PINE TOP	951200	9512	737.4832		10000		10000	15000	1993-09-01	1				0				51119C	2026-01-08	AE		5	0.8906	1.2481	1.0438	200V	SINGLE FAMILY SUBURB - VAC	R	0	PERSON		LOT 6	0	0										2026.2	2025	2
29 1 1B	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95559	SALUDA	951100	9511	16898.3911		24600		24600	15000	1993-09-01	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		0.7688	11.0193	10.1917	200V	SINGLE FAMILY SUBURB - VAC	R	4.9187	PERSON		4 9187 AC	0	0										2026.2	2025	3
26 51	2792	51	119	0 TIDEWATER TRL	SALUDA	VA	23149	DRAGON RUN LTD C O PITTS LUMBER…	P O BOX 6	SALUDA	VA	23149 0006	MIDDLESEX	95559	SALUDA	951000	9510	40997.7427		287400		287400		1992-10-01	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		20.9045	27.5015	24.6443	400V	COMMERICAL/INDUSTRAL - VAC	LI	78.9110	BUSINESS		78 91 AC LUCA	214	427										2026.2	2025	3
36 53B	16957	51	119	225 HEALYS RD	LOCUST HILL	VA	23092	REED BRYANT KATRINA A R S BRYAN…	1007 LOVES LN	SALUDA	VA	23149	MIDDLESEX	95559	SALUDA	951000	9510	65041.3852		61600		61600		2024-09-27	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		8.1593	23.6496	18.1302	200V	SINGLE FAMILY SUBURB - VAC	LDR	16.7900	PERSON		16 79 AC	1459	0										2026.2	2025	3
41 9 4	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95079	PINE TOP	951200	9512	3484.7462		4000		4000	15000	1993-09-01	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.4101	3.8230	3.5917	200V	SINGLE FAMILY SUBURB - VAC	R	0	PERSON		LOT 4	0	0										2026.2	2025	2
19 7 22	86	51	119	0 BURRELLS MARINA RD		VA	0	JONES BRYAN	4000 BRANTLEY DRIVE	AUSTELL	GA	30106	MIDDLESEX	95559	SALUDA	951000	9510	2144.8852		2000		2000	15000	2020-08-07	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		7.0033	8.1829	7.2712	400V	COMMERICAL/INDUSTRAL - VAC	LDR	0	PERSON			1408	1408										2026.2	2025	3
37A 5 93	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95079	PINE TOP	951000	9510	796.3120		15000		15000	15000	1993-09-01	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		3.0688	3.6774	3.3315	200V	SINGLE FAMILY SUBURB - VAC	R	0	PERSON			0	0										2026.2	2025	2
37A 2 55	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95079	PINE TOP	951000	9510	827.5369		1200		1200	15000	1993-09-01	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		9.2628	9.8651	9.5309	200V	SINGLE FAMILY SUBURB - VAC	R	0	PERSON			0	0										2026.2	2025	2
45 7	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95079	PINE TOP	951200	9512	275.7131		200		200	15000	1993-09-01	1				0				51119C	2026-01-08	AE		5	0.8163	1.1570	0.9694	200V	SINGLE FAMILY SUBURB - VAC	R	0	PERSON			0	0										2026.2	2025	2
ROW	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95559	SALUDA	951000	9510	25406.8925					15000	1993-09-01	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		1.9187	7.0714	5.4718	200V	SINGLE FAMILY SUBURB - VAC	R	0	PERSON			0	0										2026.2	2025	0
ROW	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95559	SALUDA	951000	9510	21155.2112					15000	1993-09-01	1				0				51119C	2026-01-08	AE		6	2.5297	10.7270	7.4956	200V	SINGLE FAMILY SUBURB - VAC	R	0	PERSON			0	0										2026.2	2025	0
26A 2 14	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95559	SALUDA	951000	9510	486.5664					15000	1993-09-01	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		10.3736	12.5127	11.3334	200V	SINGLE FAMILY SUBURB - VAC	R	0	PERSON			0	0										2026.2	2025	3
17 59	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	94023	JAMAICA	951000	9510	924549.1497		450800		450800	15000	1993-09-01	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD					200V	SINGLE FAMILY SUBURB - VAC	R	231.7300	PERSON		231 73 AC LUCA	0	0										2026.2	2025	1
37 48	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95079	PINE TOP	951000	9510	279.1252					15000	1993-09-01	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		16.0785	18.0941	17.0517	200V	SINGLE FAMILY SUBURB - VAC	R	0	PERSON			0	0										2026.2	2025	2
41 44 121	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95079	PINE TOP	951200	9512	717.1170					15000	1993-09-01	1				0				51119C	2026-01-08	VE		7	-0.1199	1.9964	0.9479	200V	SINGLE FAMILY SUBURB - VAC	R	0	PERSON			0	0										2026.2	2025	2
41 33 4	2685	51	119	0 APPLE BLOSSOM LN		VA	0	SEARS KATHERINE D ETAL	2519 OILVILLE RD	ROCKVILLE	VA	23146 2001	MIDDLESEX	95079	PINE TOP	951200	9512	1169.1918					15000	1993-09-01	1				0				51119C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD		-0.0500	3.1018	2.4805	200V	SINGLE FAMILY SUBURB - VAC	R	0	PERSON			0	0										2026.2	2025	2