Saved query 4345e78236794851

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

25,456 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelstate	ownername	owneraddr	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	heating	heatfuel	foundation	roofcover	siding	lrversion	taxdistrict
156G 5 1	156G 5 1	51	009	163 FERNWOOD DR	VA	CREWS BRENDA A	175 JANE TER	AMHERST	91800	5	010504	105.0400	2785.2372	250700	274700	247700	30000	81850	2022-02-28	1	1	2002	0	1485	3	0	2	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	234.8192	239.9016	237.6620	1	SINGLE FAMILY SUBURB	LIMITED RESIDENTIAL	0.6790	PERSON	LOT 1 FERNWOOD SECTION II 156G …	2/230	HEAT PUMP	ELECTRIC	CONCRETE	HEAVY COMP SHINGLE	VINYL	2026.2	ELON
139D 2 9	139D 2 9	51	009	178 NORTHRIDGE PL	VA	VAGNER LASZLO GEORGIANNA	178 NORTHRIDGE PL	AMHERST	91650	4	010401	104.0100	3936.2141	251800	262100	235100	43700	123415	2004-11-01	2	1	2004	0	1287	3	0	2	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	242.1100	249.4987	245.7808	1	SINGLE FAMILY SUBURB	LIMITED RESIDENTIAL	0.9000	PERSON	LOT 9 SECTION 2 PLEASANT RIDGE …	2/369	HEAT PUMP	ELECTRIC	BRICK	COMP SHINGLE	VINYL	2026.2	ELON
146 A 54	146 A 54	51	009	142 LEFTWICH RD	VA	BARTH BRADLEY J LEIGH S	142 LEFTWICH RD	AMHERST	91500	3	010300	103	2090.6777	272920	459600	234300	263920	354000	2011-03-02	1	1	1924	0	1945	3	1	1	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	197.2194	205.8242	201.7426	6	AGR/UNDDEV 20-99 ACR	A1R1	47.5000	PERSON	NEAR ELON 146 A 54	B/222	HEAT PUMP	ELECTRIC	STONE	COMP SHINGLE	WOOD/FRAME	2026.2	ELON
149 A 61	149 A 61	51	009	1339 IZAAK WALTON RD	VA	JONES MELISSA C DEAN	1339 IZAAK WALTON RD	AMHERST	91200	1	010600	106	3366.2517	195300	222300	195300	27000		2008-07-02	1	1	1977	0	1188	3	0	2	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	244.7748	252.8344	249.7162	0	SINGLE FAMILY SUBURB	LIMITED RESIDENTIAL	0.6899	PERSON	NEAR BRIGHTWELLS MILL 149 A 61	358/94	HEAT PUMP	ELECTRIC	CONC/BLOCK	COMP SHINGLE	BRICK	2026.2	MADISON
137 A 84	137 A 84	51	009	421 IRON BRIDGE RD	VA	CAMPBELL HORCE LEMUEL	421 IRON BRIDGE RD	AMHERST	91500	3	010300	103	9523.1706	215100	249200	213100	38100		2007-08-30	1	1	1965	0	1260	3	0	2	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	214.1674	231.7539	224.2555	1	SINGLE FAMILY SUBURB	AGRICULTURE/RESIDENT	2.0200	PERSON	NEAR MONROE 137 A 84		FORCED AIR	OIL	CONC/BLOCK	COMP SHINGLE	VINYL	2026.2	ELON
74 1 B	74 1 B	51	009	178 RANDALL RD	VA	KIGER JANE T	739 CHINOOK PL	AMHERST	91500	3	010100	101	5606.1100	17400	45000	17400	27600	70500	2017-06-13	1	1	1957	0	414	2	0	1	51009C	2026-01-08	A		286.7189	324.2899	300.9418	2	SINGLE FAMILY SUBURB	AGRICULTURE/RESIDENT	1.2000	PERSON	LOT B DANCING CREEK 74 1 B		SPACE HEAT	WOOD	PIERS	COMP SHINGLE	WOOD/FRAME	2026.2	PEDLAR
122A 1 11	122A 1 11-18	51	009	164 KIMBERLEA RD	VA	DALTON JAMES W JR MONICA P	164 KIMBERLEA DR	AMHERST	91500	3	010300	103	15627.7604	267817	310600	239600	99217	280000	2021-12-03	1	1	1957	0	1500	4	0	3	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	253.5260	258.9505	255.9982	1	SINGLE FAMILY SUBURB	AGRICULTURE/RESIDENT	10.7700	PERSON	LOTS 11-18 KIMBERLEA 122A 1 11-…		FORCED AIR	OIL	CONC/BLOCK	COMP SHINGLE	BRICK	2026.2	ELON
147C 8 A 91	147C 8 A 90-93	51	009	184 OAK GROVE DR	VA	YOUNG MARCO R	184 OAK GROVE DR	AMHERST	91650	4	010402	104.0200	1606.3667	177800	212700	177000	36500	128000	2017-07-21	1	1	1958	0	1278	4	0	1	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	254.7064	274.7978	269.2532	1	SINGLE FAMILY SUBURB	GENERAL RESIDENTIAL	1.4500	PERSON	LOTS 90-93 MIDWAY HTS 147C 8 A …		FORCED AIR	OIL	CONC/BLOCK	COMP SHINGLE	BRICK	2026.2	ELON
138B 5 2	138B 5 2	51	009	129 TROY LN	VA	BRYANT KATHY CAMPBELL	182 TROY LANE	AMHERST	91650	4	010401	104.0100	1383.1861	142300	162500	138500	27800		2017-12-29	1	1	1973	0	1056	3	0	1	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	270.9475	275.8500	274.1996	1	SINGLE FAMILY SUBURB	GENERAL RESIDENTIAL	0	PERSON	LOT 2 COOLWELL MANOR 138B 5 2		HEAT PUMP	ELECTRIC	CONC/BLOCK	COMP SHINGLE	BRICK	2026.2	ELON
156E 5 29	156E 5 29	51	009	168 ERIN DR	VA	BANE MICHAEL A DEBORAH L T	168 ERIN DR	AMHERST	91800	5	010504	105.0400	2164.3495	187276	210700	186700	24576		2021-07-23	1	1	2000	0	914	2	0	2	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	242.0106	250.4390	246.0751	1	SINGLE FAMILY SUBURB	LIMITED RESIDENTIAL	0.5160	PERSON	LOT 29 VANNMEADE SD SEC 1 156E …		HEAT PUMP	ELECTRIC	BRICK	METAL/TIN	VINYL	2026.2	ELON
96A7 4 8 11	96A7 4 8 11-13,45-47	51	009	145 CHURCH ST	VA	MARTIN EDWARD D	145 CHURCH ST	AMHERST	91350	2	010201	102.0100	305.5477	158400	176400	158400	18000	150000	2023-06-22	1	1	1969	0	768	2	0	1	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	201.5540	207.4171	203.3869	1	SINGLE FAMILY URBAN	GENERAL RESIDENTIAL	0	PERSON	LOTS 11 12 13 45 46 47 BLK A 96…		BASEBOARD	ELECTRIC	CONC/BLOCK	COMP SHINGLE	VINYL	2026.2	TOWN OF AMHERST
156B 6 B 27	156B 6 B 26-29	51	009	173 MAPLE DR	VA	LINDSTROM KEVIN M	173 MAPLE DR	AMHERST	91200	1	010600	106	552.8930	106736	124300	103300	24436	66000	2014-10-01	2	1	1948	0	820	2	0	1	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	233.1526	244.8513	241.1795	1	SINGLE FAMILY SUBURB	GENERAL RESIDENTIAL	0	PERSON	LOTS 26-29 BLK B MAPLE LAWN 156…		HEAT PUMP	OIL	CONC/BLOCK	COMP SHINGLE	ALUMINUM	2026.2	MADISON
67A 1 82	67A 1 81,82	51	009	1852 N AMHERST HWY	VA	DAVIS RICHARD NEIL	580 WOLF TRAP RD	AMHERST	91200	1	010100	101	2306.7687	315500	356500	314500	43000	190000	2005-04-04	1	1	1972		0	0	9	5	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	211.5906	221.7437	218.2217	3	MULTI FAMILY	AGRICULTURE/RESIDENT	0	PERSON	LOTS 81 82 WILLIAMS SUB DIV 67A…		NONE	NO HEAT		NONE	BASEBOARD	2026.2	TEMPERANCE
120 A 5B	120 A 5B	51	009	121 MOUNT TABOR DR	VA	CHURCH MT TABOR UNITED METHODIST	2530 W PERCH RD	AMHERST	91500	3	010300	103	1034.7500	116900	137400	116400	21500			1	1	1939	0	1152	3	0	1	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	245.4132	250.5228	248.4879	0	SINGLE FAMILY SUBURB	AGRICULTURE/RESIDENT	0	NONPROFIT	PARSONAGE 120 A 5B		HEAT PUMP	ELECTRIC	CONC/BLOCK	COMP SHINGLE	ASBESTOS	2026.2	PEDLAR
156A1 7 158	156A1 7 153-158	51	009	197 TRIPLE OAK CIR	VA	WILSON WANDA RENEE NAIDRA NATHA…	197 TRIPLE OAK CIR	AMHERST	91800	5	010504	105.0400	408.4206	203204	221700	200700	23504		2026-01-15	1	1	1955	0	1228	4	0	2	51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	232.3155	235.6245	234.2327	1	SINGLE FAMILY SUBURB	GENERAL RESIDENTIAL	0.4730	PERSON	PT OF LOTS 153 158 KIDDHURST AC…		HEAT PUMP	ELECTRIC	CONC/BLOCK	HEAVY COMP SHINGLE	BRICK	2026.2	ELON
149 A 4A	149 A 4A	51	009		VA	ADAMS ROBERT S JUDY C	209 EWERS LN	AMHERST	91200	1	010402	104.0200	3358.7080	2500	30000		32500			1	1	0		0				51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	227.8115	233.3464	231.0283	0	SINGLE FAMILY SUBURB	GENERAL RESIDENTIAL	1	PERSON	OFF RT 701 149 A 4A	659/527						2026.2	ELON
161 A 76A	161 A 76A	51	009		VA	CEMETERY	135 STORY DR	AMHERST	91200	1	010600	106	1319.3258		3000		3000	500	2006-01-20	0		0		0				51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	243.0843	250.5912	246.7949	1	OTHER	GENERAL RESIDENTIAL	0.3810	NONPROFIT	REMAINDER OF PARCEL 1 ON WRIGHT…	702/286						2026.2	MADISON-TAX EXEMPT
136 A 74	136 A 74	51	009		VA	CONNELLY DANNY W SHARON W	351 BURGESS RD	AMHERST	91500	3	010300	103	3853.8191		6000		6000	7350	2010-11-24	0		0		0				51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	206.1486	223.8984	215.4750	1	SINGLE FAMILY SUBURB	LIMITED RESIDENTIAL	0.8300	PERSON	LOT ON 130 NEAR ELON 136 A 74	1/447						2026.2	ELON
34 A 41A	34 A 41A	51	009		VA	BATEMAN DOUGLAS C SR JOANNA G RL	16452 LONGVIEW DR	AMHERST	91500	3	010100	101	229821.1643	1920	109200		111120		2023-09-20	1	1	0		0				51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	410.3298	551.0063	481.4149	1	AGR/UNDDEV 20-99 ACR	AGRICULTURE/RESIDENT	45.4810	PERSON	LONG MTN ON RT 60 TRACT D SEE D…	3/47						2026.2	PEDLAR
160 A 41	160 A 41	51	009		VA	TLC PROPERTIES INC	1545 PATRICK RD NE	AMHERST	91800	5	010505	105.0500	2090.5114		1200		1200	1692	2010-07-01	0		0		0				51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	199.3957	219.8058	206.2364	1	SINGLE FAMILY SUBURB	GENERAL RESIDENTIAL	0	BUSINESS	PT OF LOT 119 ADJ CHUMBLEY 160 …							2026.2	MADISON HGT SANITARY
46 A 8	46 A 8	51	009		VA	GILBERT MARK H RONALD D	174 SUGAR HILL TUNNEL RD	AMHERST	91500	3	010100	101	156945.7467		72000		72000	75000	2008-09-26	0		0		0				51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	437.2965	660.2166	525.8435	1	AGR/UNDDEV 20-99 ACR	AGRICULTURE/RESIDENT	40	PERSON	WEST OF ALLWOOD 46 A 8							2026.2	PEDLAR
37 A 12A	37 A 12,12A	51	009		VA	FITZGERALD ROBERT F II	354 MOUNT PLEASANT RD	AMHERST	91350	2	010100	101	19217.3206		48700		48700	54000	2016-09-30	0		0		0				51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	234.8114	263.5524	254.6422	1	AGR/UNDDEV 20-99 ACR	AGRICULTURE/RESIDENT	25.4930	PERSON	ON RT 617 THRASHERS CREEK RD SE…	3/69						2026.2	TEMPERANCE
148B A 2	148B A 2	51	009		VA	MOSS JAMES W JR	191 HILLCREST CIR	AMHERST	91650	4	010402	104.0200	4103.4000		6200		6200	140800	2016-08-10	0		0		0				51009C	2026-01-08	A		236.5474	241.9408	238.3246	4	SINGLE FAMILY SUBURB	LIMITED RESIDENTIAL	1.0400	PERSON	LOT 3 NEAR HOLIDAY INN 148B A 2	688/90						2026.2	ELON
128 A 6	128 A 6	51	009		VA	WRIGHT WILLIAM R PEARL C	159 POPLAR GROVE CIR	AMHERST	91200	1	010202	102.0200	159039.4335		143600		143600	89250	2013-06-07	0		0		0				51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	192.7000	247.8603	218.2495	2	AGR/UNDDEV 20-99 ACR	AGRICULTURE/RESIDENT	39.8820	PERSON	WEST OF WALKERSFORD ON LARKIN M…	4/17						2026.2	COURT HOUSE
156 A 26	156 A 25D,26	51	009		VA	MERRILL ROBERT NANCY FRANKO	229 HILLTOP DR	AMHERST	91800	5	010504	105.0400	6954.3751		13600		13600	261000	2024-03-01	0		0		0				51009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	207.5290	224.2653	213.1349	2	SINGLE FAMILY SUBURB	GENERAL RESIDENTIAL	2.2599	PERSON	PARCEL ADJ LAKEVIEW 156 A 25D,26	418/273						2026.2	ELON