Saved query c4cc4809bc470332

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

48/80

Live SQL

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

7,624 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	taxacres	ownertype	naicscode	book	page	parceltype	accesstype	placename	placetype	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear
796621357100000	796621357100000	51	570	131 SADLER AVE		VA	23834	CROWDER JOHN W IV	131 SADLER AVE	SOUTH CHESTERFIELD	VA	23834	COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830300	8303	28834.7808						2009-07-22	0							510039	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	15.6947	24.7964	19.9806	SD		0.5800	PERSON		8801	446					2	UNDETERMINED	2	BB	CS	BK	2026.2
795622508700000	795622508700000	51	570	903 LAKEVIEW RD		VA	23834	KOLLMAN WILLIAM L CAROL T	17000 ROUTE 1	SOUTH CHESTERFIELD	VA	23834	COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830300	8303	15495.2308						2019-11-15	0							510039	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	24.7533	28.9152	27.1642			0.2060	PERSON		12525	950			COLONY WOOD	HISTORIC_SITE			0				2026.2
4200020A010		51	570	904 COLONIAL AVE	COLONIAL HEIGHTS	VA	23834						COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830500	8305	572.2175	161600	161600	161600	0	100000	2019-11-01	1	1	1950	1406	4	0	1			—		27.4239	28.9064	28.1729		SINGLE FAMILY										CENTRAL AIR	OIL	OTHER		COMPOSITION		2026.2	2025
39000100069		51	570	306 LAFAYETTE AVE	COLONIAL HEIGHTS	VA	23834						COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830500	8305	761.3578	189600	189600	189600	0	115000	2015-03-24	1	1	2014	1058	3	0	2			—		28.4400	29.1538	28.8527		SINGLE FAMILY										HEAT PUMP	ELECTRIC	HEAT PUMP		OTHER		2026.2	2025
795622765300000	795622765300000	51	570	901 LAKEVIEW RD		VA	23834	KOLLMAN WILLIAM L CAROL T	17000 ROUTE 1	SOUTH CHESTERFIELD	VA	23834	COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830300	8303	12524.8666						2019-11-15	0							510039	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	24.9264	28.4254	27.2880			0.4590	PERSON		12525	950							0				2026.2
795623291200000	795623291200000	51	570	927 LAKEVIEW RD		VA	23834	LOPEZ ADOLFO DANIEL	927 LAKEVIEW AVE	SOUTH CHESTERFIELD	VA	23834	COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830300	8303	2493.0822						2024-10-09	0							510039	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	26.5911	27.8011	27.2760			0.4300	PERSON		14688	0384							0				2026.2
795626236600000	795626236600000	51	570	503 FAIRMONT DR		VA	23834	KESTER J G KESTER R L TRS	3637 LAURA RD	SOUTH CHESTERFIELD	VA	23834	COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830300	8303	832.0323						2017-08-21	0							510039	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	27.4692	28.0839	27.7705			0.2100	TRUST		11726	136							0				2026.2
38000106002		51	570	107 ARLINGTON AVE	COLONIAL HEIGHTS	VA	23834						COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830500	8305	513.6634	31500	31500	31500	0	179950	2021-11-08	1	1	1925	2552	4	0	2			—		29.3606	29.8134	29.6231		SINGLE FAMILY												OTHER		COMPOSITION		2026.2	2025
6605070A014		51	570	125 OLD BRICKHOUSE LN	COLONIAL HEIGHTS	VA	23834						COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830100	8301	1245.8622	372100	372100	372100	0	379000	2021-05-24	1	1		2726	4	0	3			—		8.8133	9.8837	9.1960		SINGLE FAMILY										FIREPLACE	ELECTRIC	OTHER				2026.2	2025
68103100009		51	570	1116 PLEASANT DALE AVE	COLONIAL HEIGHTS	VA	23834						COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830100	8301	762.0192	202600	202600	202600	0			1	1	1972	1470	4	1	1			—		17.6312	18.4689	18.2077		SINGLE FAMILY										UNDETERMINED	UNDETERMINED	OTHER		COMPOSITION		2026.2	2025
21000208021		51	570	2106 WAKEFIELD AVE	COLONIAL HEIGHTS	VA	23834						COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830400	8304	673.6500	130700	130700	130700	0			1	1	1947	783	2	0	1			—		23.9920	25.0871	24.6887		SINGLE FAMILY										HEAT PUMP	ELECTRIC	HEAT PUMP		COMPOSITION		2026.2	2025
795627471200000	795627471200000	51	570	505 FAIRMONT DR		VA	23834	STEWART JONATHAN P	304 BILTMORE DR	COLONIAL HEIGHTS	VA	23834	COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830300	8303	1161.0084						2015-08-03	0							510039	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	25.4353	26.8106	26.2116			0.2870	PERSON		10948	279							0				2026.2
794623925600000	794623925600000	51	570	3800 LAKEVIEW RD		VA	23834	BEVCO LLC	12040 LAYTON DR	GLEN ALLEN	VA	23059	COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS			3434.7263						2000-11-21	0							510039	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	25.5109	28.4863	26.8906			0.5669	BUSINESS		3950	4							0				2026.2
47000100025		51	570	903 FLORAL AVE	COLONIAL HEIGHTS	VA	23834						COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830500	8305	696.8490	136800	136800	136800	0	207000	2025-05-05	1	1	1943	836	2	0	1			—		23.6180	26.4102	25.3742		SINGLE FAMILY																2026.2	2025
43000600003		51	570			VA		CITY GOVERNMENT					COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830500	8305	7176.1102																—		17.8992	19.9107	19.1073				PERSON				GOVT LOCAL	OPEN	RECREATION AREA	LOCAL PARK							2026.2
2100010I010		51	570	2102 BOULEVARD		VA							COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830400	8304	674.0126																—		24.7693	26.2786	25.4434					7225					LITTLE CAESARS PIZZA	RESTAURANT							2026.2
18000300005		51	570			VA							COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830300	8303	2967.4662																—		20.4104	21.4611	20.7940					6216					DISCOVERY WORLD DAY CARE CENTER	HOME_SERVICE							2026.2
0200020001B		51	570	3628 BOULEVARD		VA							COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830300	8303	744.6047																—		12.3841	13.2724	12.7068										DABHI K MD	OUTPATIENT_CARE_FACILITY							2026.2
	798621426200000	51	570			VA							COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830400	8304	2611.5123							0							510039	2026-01-08	AE	FLOODWAY	13.0115	16.1015	14.5175																		2026.2
	796622071000000	51	570			VA							COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830300	8303	13649.7489							0							510039	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	20.9388	27.5650	24.9091																		2026.2
	802628452400000	51	570			VA							COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830200	8302	43572.9951							0							510039	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	0.2926	8.9210	1.9909																		2026.2
		51	570			VA		CITY GOVERNMENT					COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830100	8301	136920.8535																—		-0.0536	9.0454	2.5503				PERSON				GOVT LOCAL	OPEN	UNKNOWN PARK	LOCAL PARK							2026.2
		51	570			VA		CITY GOVERNMENT					COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830300	8303	13220.2627																—		7.1657	22.4134	17.3342				PERSON				GOVT LOCAL	OPEN	LAKEVIEW PARK	LOCAL PARK							2026.2
		51	570			VA		STATE OF VIRGINIA					COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830400	8304	3698.8547																—		0.6486	9.5269	3.6067				GOVERNMENT				GOVT STATE	CLOSED	VIRGINIA OUTDOORS FOUNDATION PR…	OTHER EASEMENT							2026.2
29001000002		51	570			VA							COLONIAL HEIGHTS	90948	COLONIAL HEIGHTS	830400	8304	4465.7281																—		27.2035	28.7597	27.9602										FLAGSTOP CAR WASH	AUTOMOTIVE_SERVICE							2026.2