Saved query 95975ab9246eb887

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

40/80

Live SQL

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

16,095 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	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
6	6-1	51	135	1331 SWEATHOUSE CREEK RD	AMELIA COURT HOUSE V	VA	23002	FAUBION KEVIN ET UX AMELIA COUR…	1331 SWEATHOUSE CREEK RD	AMELIA COURT HOUSE V	V	23002	NOTTOWAY	91710	4	000102	1.0200	32109.4056	195700	42700		238400	272000	2021-07-12	1	1	1975	1	1104	3		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	96.6054	107.5431	102.2051	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	7.8540	PERSON	2 AC TO 68-23-F2	278	4154	1	CENTRAL AIR	UNDETERMINED	CENTRAL AIR	CONC BLOCK	SHGLS		2026.2		02 JACKSON
10351	10351-1	51	135	18280 NAMOZINE RD	AMELIA COURT HOUSE	VA	23002	ELLIOTT ANGELA F ETUX	18280 NAMOZINE RD	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91560	3	000200	2	14776.6994	294700	67000		361700	320000	2019-11-04	1	1	2001	1	1352	2		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	99.8024	106.9915	103.5587	2001	SNGL FAM RES - SUBURBAN	RURAL PRESERVATION	18.7000	PERSON	N26E13E20E19S26W16	262	631		CENTRAL AIR	UNDETERMINED	UNDETERMINED	CONC BLOCK	COMP SHGLS		2026.2		FR NOTTOWAY CTY
4604	4604-1	51	135	3451 BENCHMARK TRL	AMELIA COURT HOUSE	VA	23002	BLANKS LARRY PI	3451 BENCHMARK TRAIL	AMELIA	VA	23002	NOTTOWAY	91560	3	000200	2	21920.6680	225800	36900		262700	339900	2022-04-11	1	1	2022		1600	3	1	2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	100.4599	106.9633	104.0877	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	5.0100	PERSON	BENCHMARK ESTATES	0168	117		CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONC BLOCK	SHGLS		2026.2		01 GILES
4570	4570-1	51	135	3400 BENCHMARK TRL	AMELIA	VA	23002	HATCHER PAUL A ETUX HATCHER SAN…	3400 BENCHMARK TRAIL	AMELIA	VA	23002	NOTTOWAY	91560	3	000200	2	25817.4900	178100	38900		217000	164950	2016-04-15	1	1	1989		1322	3	1	2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	98.6118	107.4897	104.1049	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	5.6500	PERSON	5 650 AC	0219	868	1	CENTRAL AIR	UNDETERMINED	CENTRAL AIR		SHGLS		2026.2		01 GILES
6917	6917-1	51	135	1341 SWEATHOUSE CREEK RD	AMELIA COURT HOUSE	VA	23002	INGE NICHOLAS	1341 SWEATHOUSE CREEK RD	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91710	4	000102	1.0200	8709.6508	194900	25000		219900	305000	2022-10-27	1	1	2022	1	1512	3		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	99.4746	105.5431	102.8467	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	2	PERSON	2 000 AC	01891	329		CENTRAL AIR	ELECTRIC	CENTRAL AIR	BRICK	COMP SHGLS		2026.2		02 JACKSON
6	278 / 4154	51	135	1331 SWEATHOUSE CREEK RD	AMELIA COURT HOUSE	VA	23002	FAUBION KEVIN ETUX	1331 SWEATHOUSE CREEK RD	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91710	4	000102	1.0200	8777.5455	195700	42700		238400	272000	2021-07-12	1	1	2010	1	1104	3		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	102.4919	107.4916	104.7875	1975	SNGL FAM RES - SUBURBAN	RURAL PRESERVATION	7.8540	PERSON	2 AC TO 68-23-F2	278	4154	1	CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONC BLOCK	COMP SHGLS		2026.2
7580	7580-1	51	135	3381 BENCHMARK TRL	AMELIA COURT HOUSE	VA	23002	STORY STEVENW	3381 BENCHMARK TRAIL	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91560	3	000200	2	19173.0381	236600	36900		273500	379900	2022-08-10	1	1	2022		1600	3		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	99.3810	106.8835	103.1517	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	5.0100	PERSON	BENCHMARK ESTATES	269	1479		CENTRAL AIR	ELECTRIC	CENTRAL AIR	BRICK	COMP SHGLS		2026.2		01 GILES
11044	11044-1	51	135	825 KNOTTY MILL LN	TROGDON	VA	23113	JAY ETUXX CREWE	PO BOX 1753	MIDLOTHIAN	VA	23113	NOTTOWAY	91560	3	000200	2	14314.1928	260100	26000		286100	46000	2022-02-09	1	1	2022		1953	3	1	2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	87.9352	98.6170	95.1664	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	3.5000	PERSON	KNOTTY MILL FR NOTTOWAY	279	3123		CENTRAL AIR	ELECTRIC	CENTRAL AIR	BRICK	COMP SHGLS		2026.2
10308	10308-1	51	135			VA	0	MILLS ROBERT E	18210 NAMOZINE ROAD	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91560	3	000200	2	7764.7362	310200	93800		404000			1	1	2005	1	2079	3	1	2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	99.0837	103.3636	101.5358	20-100 AC	AGRICULTURAL	RURAL PRESERVATION	40.4799	PERSON	FR NOTTOWAY CTY 40 480 AC	0	0	1	CENTRAL AIR	UNDETERMINED	CENTRAL AIR	CONCI BLOCK	METAL		2026.2		03 LEIGH
5631	5631-1	51	135	18191 NAMOZINE RD	AMELIA COURT HOUSE	VA	23002	SEMBER STEVEN ETUX	18191 NAMOZINE RD	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91560	3	000200	2	27570.0418	218800	34800		253600	282500	2021-05-03	1	1	2010		1548	3		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	98.1569	104.0662	101.0106	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	5.1740	PERSON	NOTTOWAYI LINE	280	6643		CENTRAL AIR	UNDETERMINED	CENTRAL AIR	BRICK	SHGLS		2026.2		01 GILES
10341	10341-1	51	135	9851 EDMONDS LN	BLACKSTONE	VA	23824	HAWKES QUAMAN M	512 E BROAD ST	BLACKSTONE	VA	23824	NOTTOWAY	91710	4	000102	1.0200	8757.3108	135800	27600		163400		2001-05-01	1	1	2002		984	3		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	95.7484	101.3026	98.4707	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	2.5299	PERSON	PARCEL 4 2 530 AC	257	859		CENTRAL AIR	UNDETERMINED	CENTRAL AIR	CONCI BLOCK	SHGLS	ALUM/VINYL	2026.2		02 JACKSON
6628	6628-1	51	135	3321 NOTTOWAY LN	AMELIA COURT HOUSE	VA	23002	HUX WILLIAM H JR ETUX	3321 NOTTOWAY LN	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91560	3	000200	2	26097.7014	165900	44100		210000			1	1	1990	2	1248	3	1	2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	94.8280	105.6966	99.8661	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	7.2500	PERSON	7 250 AC	0	0		CENTRAL AIR	UNDETERMINED	CENTRAL AIR	CONCI BLOCK	METAL		2026.2		01 GILES
7194	7194-1	51	135	372 KNOTTY MILL LN	CREWE	VA	23930	SIMPSON BRITTANY M	372 KNOTTY MILL LN	CREWE	VA	23930	NOTTOWAY	91560	3	000200	2	65272.8434	188800	31300		220100	188800	2021-06-15	1	1	2021		1752	3		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	83.7358	106.2612	97.2634	2015	SNGL FAM RES - SUBURBAN	RURAL PRESERVATION	5	PERSON	01 GILES	0	0		CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONC BLOCK	COMP SHGLS		2026.2		01 GILES
7759	7759-1	51	135	8901 EDMONDS LN	BLACKSTONE	VA	23824	COUSAR STEVE A ETUX	890 EDMONDS LANE	BLACKSTONE	VA	23824	NOTTOWAY	91710	4	000102	1.0200	7494.3289	155300	21500		176800		2001-05-11	1	1	1982		1649	3		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	95.6734	99.8400	97.6621	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	1.0100	PERSON	1 0162 AC	258	372		CENTRAL AIR	UNDETERMINED	CENTRAL AIR	CONCI BLOCK	COMP SHGLS		2026.2		02 JACKSON
5256	5256-1	51	135	1201 RICHMOND RD	AMELIA COURT HOUSE	VA	23002	ROBINSON THOMAS R	1201 RICHMOND RD	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91710	4	000102	1.0200	313490.0991	104700	172200	0	683700		2013-09-25	1	1	2001		1404	2		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	79.7414	107.2601	93.7715	AGR.- 100 AC OR MORE	AGR.- 100 AC OR MORE	RURAL PRESERVATION	120.6100	PERSON	120 610 AC 2027-2030	262	697		CENTRAL AIR	UNDETERMINED	UNDETERMINED		COMP SHGLS		2026.2		02 JACKSON
11347	11347-1	51	135	1320 RICHMOND RD	AMELIA COURT HOUSE	VA	23002	JAMES LETTIE	1350 RICHMOND RD	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91710	4	000102	1.0200	11895.1537	124100	23800		147900		2007-02-08	1	1	2018		1512	3		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	104.4123	108.4921	106.4652	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	RURAL PRESERVATION	2.0130	PERSON	2 013	276	567		CENTRAL AIR	ELECTRIC	CENTRAL AIR	CONC BLOCK	COMP SHGLS		2026.2		02 JACKSON
10458	10458-1	51	135	1240 OLD RICHMOND RD	AMELIA COURT HOUSE	VA	23002	SOBRITO CHARLES J ETUX	1240 OLD RICHMOND ROAD	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91710	4	000102	1.0200	56413.1617	276500	50100		326600			1	1	2003	2	2192	3		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	99.9583	109.5912	105.0160	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	11.4309	PERSON	11 4315 AC	267	3121		CENTRAL AIR	UNDETERMINED	CENTRAL AIR	CONCI BLOCK	SHGLS		2026.2		02 JACKSON
4121	4121-1	51	135	1201 SWEATHOUSE CKI RD	AMELIA COURT HOUSE	VA	23002	SOBRITO THOMAS W ETAL	1201 SWEATHOUSE CKI RD	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91710	4	000102	1.0200	43692.9949	298400	50100		348500			1	1	2002		1976	2		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	101.8729	109.3646	105.8848	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	11.4309	PERSON	11 4315 AC	151	452	1	CENTRAL AIR	UNDETERMINED	CENTRAL AIR	CONCI BLOCK	COMP SHGLS		2026.2		02 JACKSON
6299	6299-1	51	135	35161 NOTTOWAY LN	AMELIA COURT HOUSE	VA	23002	HODGSON JOSEPH MI ETUX	3516 NOTTOWAY LN	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91560	3	000200	2	8246.7363	156000	30100		186100			1	1	1989		1230	3		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	102.9976	105.9490	105.0475	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	2.5000	PERSON	2 500 AC	0209	631		CENTRAL AIR	WOOD	CENTRAL AIR	CONCI BLOCK	SHGLS		2026.2		01 GILES
3684	3684-1	51	135	174711 NAMOZINE RD	AMELIA COURT HOUSE	VA	23002	HASTINGS GEORGE CHRISTOPHER ETU…	17471 NAMOZINE ROAD	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91560	3	000200	2	13129.2163	250800	28200		279000	166000	2015-07-27	1	1	1995		1500			2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	98.4932	102.4145	100.7941	SNGL FAM RES SUBURBAN	DWELLING	RURAL PRESERVATION	3.2580	PERSON	3 258 AC	273	1759		CENTRAL AIR	UNDETERMINED	CENTRAL AIR		SHGLS		2026.2		01 GILES
2771	2771-1	51	135	3320 BENCHMARK TRL	AMELIA COURT HOUSE	VA	23002	OZMORE STEVEN C ET UX	P O BOX 839	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91560	3	000200	2	11085.8109	180700	28800		209500			1	1	1990		1419	3		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	102.7804	107.1671	105.4134	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	RURAL PRESERVATION	2.1800	PERSON	2 180 AC	0	0		CENTRAL AIR	UNDETERMINED	CENTRAL AIR	CONCI BLOCK	SHGLS		2026.2		01 GILES
11045	11045-1	51	135	581 KNOTTY MILL LN	AMELIA COURT HOUSE	VA	23002	WYATT KAREN E	POE BOX 506	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91560	3			38040.4456	202000	40300		242300		2018-06-06	1	1	1980	2	1728	3		3	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	76.3171	95.8752	85.3493	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	RURAL PRESERVATION	9.4750	PERSON	KNOTTYI MILL FR NOTTOWAY	0	0		CENTRAL AIR	UNDETERMINED	CENTRAL AIR	BRICK	COMP SHGLS		2026.2		01 GILES
6056	6056-1	51	135	3300 BENCHMARK TRL	AMELIA COURT HOUSE	VA	23002	BERRY ALLEN S ETUX	3300 BENCHMARK TR	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91560	3	000200	2	8456.4544	163400	28800		192200			1	1	1990	1	1274	4		2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	101.6866	106.1994	104.6475	SNGL FAM RES SUBURBAN	SNGL FAM RES SUBURBAN	RURAL PRESERVATION	2.1800	PERSON	BENCHMARK ESTATES	270	2284		CENTRAL AIR	ELECTRIC	CENTRAL AIR		COMP SHGLS		2026.2		01 GILES
3767	3767-1	51	135	2001 MILITARY RD	AMELIA COURT HOUSE	VA	23002	HAGUE JAMES M III	2001 MILITARY RD	AMELIA COURT HOUSE	VA	23002	NOTTOWAY	91710	4			207060.1808	518200	80700	0	723700			1	1	1994	1	2532	4	1	2	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	69.3739	105.2020	87.3889	AGRICULTURAL	AGRICULTURAL- 20-100 AC	RURAL PRESERVATION	39.7000	PERSON	39 700 AC 2029-2026	02	JACKSON					BRICK	METAL		2026.2	2029
11667	11667-1	51	135	4163 OLD SHORE RD	BLACKSTONE	VA	23824	COLEMAN RICHARD A JR	1186 EDMONDS LN	BLACKSTONE	VA	23824	NOTTOWAY	91710	4	000102	1.0200	8607.5267	18500	26500		45000			1	1	1955		980	3		1	51135C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	100.6202	103.9633	102.0209	1942	SNGL FAM RES - SUBURBAN	RURAL PRESERVATION	3	PERSON	FR NOTTOWAY 1 11	0	0					PIERS	COMP SHGLS		2026.2		02 JACKSON