Saved query 5bad22ccbeead80a

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

16,071 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	bldgsqft	bedrooms	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	zoningdesc	taxacres	ownertype	legaldesc	book	page	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear
689694854000000	689694854000000	51	145	21531 GENITO RD		VA	23120	FRANCISCO STEPHEN L SHARON L	2021 GENITO RD	MOSELEY	VA	23120	POWHATAN	91415	2	500102	5001.0200	2307.0513						1997-07-01	0							51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	100.2044	103.6614	101.5339	SD				0	PERSON		0	0	2	UNDETERMINED	3	BB	CS	FC	2026.2
687691209500000	687691209500000	51	145	1060 TURKEY RIDGE DR		VA	23120	DUTY GLENN D ROBIN C	1060 TURKEY RIDGE DR	MOSELEY	VA	23120	POWHATAN	91415	2	500102	5001.0200	15129.8813						2011-12-09	0							51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	73.9335	95.6103	84.8479	SD				3.0080	PERSON		9595	349	2	UNDETERMINED	1	BB	CS	BC	2026.2
5791-59-7154		51	145	6554 BLENHEIM RD	POWHATAN	VA	23139						POWHATAN	91865	5	500400	5004	78553.7632	89660	89660	89660	0	266500	2023-08-22	1	1	1988	1456	3	0	2			—		94.9170	112.9719	103.7697		MANUFACTURED								HEAT PUMP	ELECTRIC	HEAT PUMP		SHINGLE		2026.2	2025
5792-65-8088		51	145	2375 MOSBY RD	POWHATAN	VA	23139						POWHATAN	91865	5	500400	5004	6604.6845	106230	106230	106230	0	354000	2025-04-08	1	1	2024	1737	3	0	3			—		88.0447	101.2247	93.9498		SINGLE FAMILY								HEAT PUMP	ELECTRIC	HEAT PUMP		SHINGLE		2026.2	2025
6755 79 0403	331	51	145	0 UNASSIGNED	POWHATAN	VA	23139	BATES LEWIS					POWHATAN	91865	5	500201	5002.0100	22548.4086		117500		117500		2024-02-07	1			0				51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	81.1506	92.4366	87.6652	200V		A-10	NO	6	PERSON	PT LAWTON									2026.2
7712 57 3942	5010	51	145	2499 VENITA RD	MIDLOTHIAN	VA	23113	GOODE RICHARD LAURA					POWHATAN	91265	1	500101	5001.0100	2025.6359		68100		68100		2024-02-07	1			0				51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	63.9630	67.7966	66.2395	200V		A-10	NO	0.5000	PERSON	VEST									2026.2
6790 88 8021	7606	51	145	0 UNASSIGNED		VA		LONG COLBY					POWHATAN	91415	2	500102	5001.0200	2367.5650		40400		40400	225000	2020-04-07	2			0				51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	87.3307	90.9789	89.1347	200V		R-U	NO	0.0000	PERSON	HOLLY HILLS LOT 6 BL G SEC B									2026.2
7700 28 3472	15076	51	145	1551 OAKBRIDGE DR STE C		VA		ROBERTS MORRIS LLC					POWHATAN	91415	2	500102	5001.0200	265.1871	423600		40300	463900	549100	2011-11-21	1	1		0				51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	89.9148	91.1002	90.5521	400C		I-1	NO	0.0000	BUSINESS	OAKBRIDGE PARK SUITE C PHASE I									2026.2
6700 86 6384	5225	51	145	5904 OLD BUCKINGHAM RD		VA		NICE TIMOTHY D					POWHATAN	91865	5	500400	5004	9802.8769		65200		65200	120000	2024-03-04	0			0				51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	100.6297	111.6887	106.2876	200V		A-10	NO	2.4220	PERSON	MCLAURINE									2026.2
6725 36 2829	151	51	145	0 UNASSIGNED		VA		MCGEE MITCHELL E					POWHATAN	91865	5	500400	5004	9297.8921		14200		14200	1500	2024-10-01	0			0				51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	49.3218	79.3445	65.6294	200V		A-10	NO	1.3000	PERSON	PT BELMEAD									2026.2
6703 78 4800	14949	51	145	0 MILES RD	POWHATAN	VA	23139	PALMORE FLOYD W JR OLIVIA J					POWHATAN	91865	5	500400	5004	8737.1021		900		900			0			0				51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	97.2946	102.4960	100.3756	200V		A-10	NO	2.0710	PERSON	ROUTE 722 PARCEL F									2026.2
6740 82 1111	12170	51	145	0 UNASSIGNED		VA		FINNEY-AMADO ROBIN M TRS					POWHATAN	91715	4	500202	5002.0200	61302.0781		141300		141300	42600	2003-05-19	0			0				51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	67.4545	86.5817	77.8766	200V		A-10	NO	12.1600	TRUST	PT FINNEY PCL 8B									2026.2
6711 50 1973	5636	51	145	1782 BEECH DR		VA		THIENAMAN DIANE FERGUSON ET ALS					POWHATAN	91865	5	500400	5004	1059.3994		5100		5100		2024-02-07	0			0				51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	92.0943	95.0382	93.8800	200V		A-10	NO	0.0000	PERSON	HIDEAWAY LAKES LOT 1 BLOCK V									2026.2
6793 59 9824	10040	51	145	0 UNASSIGNED		VA		HAGERTY JOHN V					POWHATAN	91265	1	500101	5001.0100	4276.5784		11400		11400	88000	2003-02-19	0			0				51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	76.5855	79.9181	78.5743	200V		A-10	NO	1.0570	PERSON	PT GATHRIGHT REMAINDER OF ST MA…									2026.2
6770 33 0127	17280	51	145	0 SCHROEDER RD		VA		WED LAND HOLDINGS LLC					POWHATAN	91415	2	500102	5001.0200	10250.7288		119000		119000	1650000	2023-07-21	0			0				51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	108.3264	112.0295	110.3770	200V		A-10	NO	2.5330	BUSINESS	SCHROEDER									2026.2
698702866200000	698702866200000	51	145	1400 ANDEAN LN		VA	23112	MATTISON BYRON LEE LISA AMARAL	1400 ANDEAN LN	POWHATAN	VA	23139	POWHATAN	91415	2	500102	5001.0200	8773.0747						2024-10-15	0							51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	66.2138	80.9675	75.0840					1.2320	PERSON		14693	0531			0				2026.2
698701149600000	698701149600000	51	145	1850 HICKORY SHADE DR		VA	23112	BEECHWOOD INC	612 HUGUENOT TRL	MIDLOTHIAN	VA	23113	POWHATAN	91415	2	500102	5001.0200	22371.6199						1998-10-28	0							51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	65.0918	89.4728	73.4121					3.1589	BUSINESS		3409	370			0				2026.2
692697740900000	692697740900000	51	145	2111 MOSELEY RD		VA	23120	SPERRY JOHN B JR	1723 OAK POINT RD	CHARLESTON	SC	29412	POWHATAN	91415	2	500102	5001.0200	3192.1499						1996-12-06	0							51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	90.5904	96.8405	93.7749					0.8350	PERSON		2970	397			0				2026.2
700704640500000	700704640500000	51	145	18300 W COUNTY LINE RD		VA	23112	SPILLER GUY W	18500 W COUNTY LINE RD	MIDLOTHIAN	VA	23112	POWHATAN	91415	2	500102	5001.0200	10480.4346						2021-04-20	0							51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	74.2995	88.6962	85.2386					2.5890	PERSON		13369	164			0				2026.2
694698718900000	694698718900000	51	145	1905 HICKORY SHADE DR		VA	23120	HOPKINS DONALD C JOANN M	1905 HICKORY SHADE DR	MOSELEY	VA	23120	POWHATAN	91415	2	500102	5001.0200	3096.3268						1996-12-06	0							51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	82.4806	89.7740	87.4810					0.7630	PERSON		2970	397			0				2026.2
705709910700000	705709910700000	51	145	17602 MIDLOTHIAN TPKE		VA	23113	NEW COUNTY LINE FARM LLC	1318 PAGE RD	MIDLOTHIAN	VA	23113	POWHATAN	91265	1	500101	5001.0100	6928.0461						2014-01-27	0							51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	85.7965	96.2521	92.3668					1.7120	BUSINESS		10460	737			0				2026.2
702705005600000	702705005600000	51	145	18203 W COUNTY LINE RD		VA	23112	WARREN REGINA W TRUSTEE	18201 W COUNTY LINE RD	MIDLOTHIAN	VA	23112	POWHATAN	91415	2	500102	5001.0200	294.2653						2023-07-18	0							51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	82.7608	83.8847	83.3394					0.0720	TRUST		14320	278			0				2026.2
706709486100000	706709486100000	51	145	17550 MIDLOTHIAN TPKE		VA	23113	NEW COUNTY LINE FARM LLC	1318 PAGE RD	MIDLOTHIAN	VA	23113	POWHATAN	91265	1	500101	5001.0100	12497.5597						2014-01-27	0							51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	73.4899	87.7943	81.1615					3.2630	BUSINESS		10460	737			0				2026.2
694698022600000	694698022600000	51	145	1909 FAWN LN		VA	23120	PAYNE PAULA M PITTMAN J H	1909 FAWN LN	MOSELEY	VA	23120	POWHATAN	91415	2	500102	5001.0200	5907.5878						2003-03-04	0							51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	82.1473	90.2813	87.1499					1.4100	PERSON		4945	871			0				2026.2
702706700800000	702706700800000	51	145	18026 W COUNTY LINE RD		VA	23112	FRAME PAUL EDWIN SANDRA H	18024 W COUNTY LINE RD	MIDLOTHIAN	VA	23112	POWHATAN	91415	2	500102	5001.0200	1308.9376						1998-03-20	0							51145C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	86.5028	87.7979	87.2255					0.3230	PERSON		3233	365			0				2026.2