Saved query 6d6caa2a6ddcbc39

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

17,865 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	landvalue	totalvalue	saledate	numbldgs	numunits	yearbuilt	numfloors	bldgsqft	bedrooms	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	zoningdesc	taxacres	ownertype	legaldesc	book	placename	placetype	fireplaces	heating	heatfuel	cooling	foundation	siding	lrversion	taxdistrict
21886	58 55 6 42	51	075			VA	0						GOOCHLAND	91682	4	400102	4001.0200	757.9687				1	1	2025	1	1806	2	1	2	51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	55.9842	58.8815	57.3804	5	RESIDENTIAL		SUBURBAN RESIDENTIAL	0.1900		42				1	HEAT PUMP	ELECTRIC	100	BRICK	HARDIPLANK	2026.2	3
34 A 11		51	075	0 TABSCOTT RD	KENTS STORE	VA	23084	KENNEY STEVEN A JANICE D	4966 TABSOCTT RD	KENTS STORE	VA	23084	GOOCHLAND	91232	1	400500	4005	121610.0146	45000	45000	2002-04-24	3		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	110.7771	136.1008	123.7005	20		A-1		10.0030	PERSON	DB 463-976 AC 10 003	463									2026.2
22021	58 54 7 38	51	075			VA	0						GOOCHLAND	91832	5	400101	4001.0100	724.7097				1	1	2024	150	2162	4		3	51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	59.6792	61.6207	60.9521	2	RESIDENTIAL		PRIME ECONOMIC DEVELOPMENT	0.1790		38					HEAT PUMP	ELECTRIC	100	BRICK	HARDIPLANK	2026.2	1
24 A 22C		51	075	0 UNASSIGNED		VA		PURDY DAVID C ET AL	6314 RIDGEWAY RD	RICHMOND	VA	23226	GOOCHLAND	91232	1	400500	4005	79847.1665	88000	88000	2000-04-24	0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	123.0132	141.1590	131.9656	20		A-1		22	PERSON	DB 406-448 AC 22 0	406									2026.2
34 A 12		51	075	0 COVERED BRIDGE RD	KENTS STORE	VA	23084	FOOLS GOLD LLC	2425 GRENOBLE RD	HENRICO	VA	23294	GOOCHLAND	91232	1	400500	4005	3126364.6295	444700	444700	2010-04-24	8		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				60		A-1		296.4500	BUSINESS	DB 794-798 AC 296 45	829									2026.2	BOWLESVILLE
15577	5 24 C	51	075		1	VA	23093						GOOCHLAND	91232	1	400500	4005	442401.1323				3	1	1991	1	2160	0	1	0	51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				6	WAREHOUSE		RURAL ENHANCEMENT AREAS	107.4000						0			0	SLAB	METAL	2026.2	6
10382	55 1 14T	51	075		1	VA	23160						GOOCHLAND	91532	3	400300	4003	1369230.9781				76	1	1900		17336	0	0	0	51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				7	COMMERCIAL		RURAL ENHANCEMENT AREAS	1122.9930				JAMES RIVER CORRECTIONAL CENTER	JAIL_OR_PRISON	0			0			2026.2	2
19635	26 1 22A	51	075			VA	0						GOOCHLAND	91232	1	400500	4005	109.1703				0	0	0		0	0	0	0	51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	106.1543	106.7755	106.4971	2			RURAL ENHANCEMENT AREAS	0.0001		CEMETERY				0			0			2026.2	4
16967	48 1 58ATW	51	075			VA	0						GOOCHLAND	91682	4	400102	4001.0200	188.1269				0	0	0		0	0	0	0	51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	81.5739	82.0894	81.8364	4			INDUSTRIAL	0						0			0			2026.2	3
10443	57 1 34G	51	075			VA	0						GOOCHLAND	91832	5	400200	4002	569.3142				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	87.1132	87.9464	87.6195	7			SEMI PUBLIC	0.0859		CEMETERY										2026.2	3
22044	58 55 7 4	51	075			VA	0						GOOCHLAND	91682	4	400102	4001.0200	802.9907				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	54.4555	58.0566	56.5739	5			SUBURBAN RESIDENTIAL	0.2000		LOT 4										2026.2	3
15400	17 1 36A	51	075			VA	0						GOOCHLAND	91232	1	400500	4005	1580.0283				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	85.7627	88.3912	87.7986	7			SEMI PUBLIC	0		CEMETERY										2026.2	4
14073	12 1 44A	51	075			VA	0						GOOCHLAND	91232	1	400400	4004	434.5243				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	97.7276	99.0701	98.5485	7			SEMI PUBLIC	0		CEMETERY										2026.2	6
15252	39 1 15F1	51	075			VA	0						GOOCHLAND	91232	1	400500	4005	676.5886				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	94.3838	96.4898	95.5413	7			SEMI PUBLIC	0		CEMETERY										2026.2	4
21948	58 55 5 50	51	075			VA	0						GOOCHLAND	91682	4	400102	4001.0200	904.1462				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	61.8100	63.5998	62.6872	5			SUBURBAN RESIDENTIAL	0.2200		50										2026.2	3
676	11 1 33T	51	075			VA	0						GOOCHLAND	91232	1	400500	4005	108295.8654				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	94.7759	109.2005	101.9625	5			RURAL ENHANCEMENT AREAS	30		TOWER SITE										2026.2	6
15657	33 1 11B	51	075			VA	0						GOOCHLAND	91532	3	400200	4002	949.6986				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	104.0180	105.8080	105.0135	7			SEMI PUBLIC	0		CEMETERY										2026.2	3
14087	16 1 43A	51	075			VA	0						GOOCHLAND	91232	1	400500	4005	653.5755				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	98.7949	99.7793	99.2029	7			SEMI PUBLIC	0		CEMETERY										2026.2	4
14645	12 14 E4A	51	075			VA	0						GOOCHLAND	91232	1	400500	4005	304.5778				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	113.2588	114.3331	113.8528	7			SEMI PUBLIC	0		CEMETERY										2026.2	6
16022	28 1 95D	51	075			VA	0						GOOCHLAND	91382	2	400400	4004	439.9785				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	80.9027	84.7093	81.6781	2			RURAL ENHANCEMENT AREAS	0.0700												2026.2	4
2523	42 1 82A	51	075			VA	0						GOOCHLAND	91382	2	400400	4004	1043.5408				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	84.9721	88.1718	86.2479	2			VILLAGE CORE	0.2300												2026.2	5
11098	50 6 3	51	075			VA	0						GOOCHLAND	91382	2	400400	4004	9763.9585				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	82.8056	92.5461	88.5386	2			RURAL ENHANCEMENT AREAS	2.1700												2026.2	4
22082	58 55 7 42	51	075			VA	0						GOOCHLAND	91682	4	400102	4001.0200	312.3875				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	55.9525	58.3671	56.9532	5			SUBURBAN RESIDENTIAL	0.0800		LOT 42										2026.2	3
15965	13 23 2	51	075			VA	0						GOOCHLAND	91382	2	400400	4004	84686.1484				0		0						51109C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	97.5481	115.1576	106.9153	5			RURAL ENHANCEMENT AREAS	20.0900												2026.2	6
21675	21 1 8 A	51	075			VA	0						GOOCHLAND	91382	2	400400	4004	55.7000				0		0						51075C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	106.4591	106.9100	106.6387	2			RURAL ENHANCEMENT AREAS	0.0001		CEMETERY										2026.2	5