Saved query accc49fb3e846067

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

37/80

Live SQL

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

35,849 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	taxacres	ownertype	legaldesc	book	page	fireplaces	heating	heatfuel	cooling	foundation	roofcover	lrversion	taxyear	taxdistrict
190-117-14	30201	51	173	118 E MAIN ST	MARION	VA	-120	WOODEN PICKLE PROPERTIES LLC	120 E MAIN ST	MARION	VA	24354	SMYTH	94991	PARK	030600	306	243.9344	210000	50000		260000	10	2022-05-10	1	1	1913	2	1980	0	1	0	51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	659.2708	659.7761	659.4964	400C	COMMERICAL/INDUSTRAL - COM	0	BUSINESS	MAIN ST PT LOT 13-14 190 117 13B	1084	683	0	CENTRAL AIR	GAS	CENTRAL AIR	CONCRETE	METAL	2026.2	2026	0M
169-57-A-54A	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	94991	PARK	030302	303.0200	171.4910	0	0	-5000	10000	25000	1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	705.2734	706.8676	706.2919	740V	LOCAL GOVT - VAC	0	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	0M
189-93-6	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	94991	PARK	030301	303.0100	423.2795	0	4400	-600	5600		1986-10-16	1	1	0	1	0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	651.2435	653.5131	652.1964	740V	LOCAL GOVT - VAC	0	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	0M
231-132-14	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	95479	ROYAL OAK	030600	306	659.6745	0	4900	-100	5100	5750	1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	671.8674	685.4439	677.5897	740V	LOCAL GOVT - VAC	0	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	0M
64-4-3A	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	90832	CHILHOWIE	030702	307.0200	67.6750		5000		5000	124000	1986-10-16	1	1	0	1	0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	705.7061	709.1147	707.7054	740V	LOCAL GOVT - VAC	0.0200	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	03
55A-3-13	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	94895	NORTH FORK	030701	307.0100	1273.9613	0	-11800	-16800	21800		1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	601.0062	603.1569	602.2778	740V	LOCAL GOVT - VAC	0	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	03
190-88-60	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	94991	PARK	030301	303.0100	84.2001	0	-145000	-150000	155000	165000	1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	668.4633	670.5165	669.3686	740V	LOCAL GOVT - VAC	0	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	0M
53D2-9-21	51322	51	173	0 UNASSIGNED	CHILHOWIE	VA		BONHAM JAMES B III	PO BOX 922	CHILHOWIE	VA	24319	SMYTH	90832	CHILHOWIE	030701	307.0100	288.8363		12000		12000		2000-01-01	1	1		1	0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	612.6497	618.3648	613.9341	100V	SINGLE FAMILY URBAN - VAC	0	PERSON	MOUNTAIN ADD LOTS 21-24 53D2 9 …	56	605		OTHER	GAS				2026.2	2026	0C
58H-1-2	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	95479	ROYAL OAK	030600	306	120.6188		5000		5000	55500	1986-10-16	1	1		1	0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	730.2344	730.6049	730.3897	740V	LOCAL GOVT - VAC	0.2700	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	06
48-3-1A	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	90104	ATKINS	030100	301	319.5847		5000		5000	3000	1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	701.1920	709.8969	703.0626	740V	LOCAL GOVT - VAC	0.0900	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	05
13-1-2-2B	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	94895	NORTH FORK	030100	301	1223.5913		5000		5000	10	1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	734.7507	741.2750	737.0356	740V	LOCAL GOVT - VAC	9.8400	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	02
228-106-8	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	94991	PARK	030600	306	337.1611		5000		5000	175000	1986-10-16	1	1		1	0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	663.1791	666.3887	665.1378	740V	LOCAL GOVT - VAC	0	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	0M
209-111-23	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	94991	PARK	030301	303.0100	390.3069		5000		5000	165000	1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	641.0250	646.3059	645.3652	740V	LOCAL GOVT - VAC	0.5699	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	0M
53D3-A-52	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	90832	CHILHOWIE	030701	307.0100	875.7377		5000		5000		1986-10-16	1	1		1	0				51173C	2026-01-08	AE		588.9429	593.5374	592.3312	740V	LOCAL GOVT - VAC	0	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	0C
76-A-6B	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	90832	CHILHOWIE	030702	307.0200	1872.3039		5000		5000		1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	671.5296	682.1009	678.2187	740V	LOCAL GOVT - VAC	0.3800	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	03
210-124-14	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	95479	ROYAL OAK	030600	306	299.3614		5000		5000		1986-10-16	1	1		1	0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	658.0809	668.3418	664.3357	740V	LOCAL GOVT - VAC	0	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	0M
29-A-100C	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	95551	SALTVILLE	030200	302	1046.9178		5000		5000	25000	1986-10-16	1	1			0				51173C	2026-01-08	AE		529.6867	531.9105	530.3592	740V	LOCAL GOVT - VAC	0.3500	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	02
58D-1-9	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	95479	ROYAL OAK	030500	305	463.7192		5000		5000	58100	1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	779.3104	796.0545	786.6333	740V	LOCAL GOVT - VAC	0	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	06
55E-1-2	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	94895	NORTH FORK	030301	303.0100	1278.7437		5000		5000		1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	623.8706	634.4679	628.7149	740V	LOCAL GOVT - VAC	0	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	04
170-67-20	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	94991	PARK	030302	303.0200	233.8744		5000		5000		1986-10-16	1	1		1	0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	693.2061	694.2677	693.9319	740V	LOCAL GOVT - VAC	0	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	0M
71F-8-75	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	95511	RYE VALLEY	030500	305	195.7431		5000		5000	17500	1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	796.3289	796.9236	796.6777	740V	LOCAL GOVT - VAC	0	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	07
58C-1-24E	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	95479	ROYAL OAK	030500	305	379.2321		5000		5000		1986-10-16	1	1		1	0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	797.6694	807.2990	802.3037	740V	LOCAL GOVT - VAC	17.5600	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	06
56C-9-7A	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	94895	NORTH FORK	030301	303.0100	225.2204		5000		5000	5000	1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	680.8965	687.6372	685.3716	740V	LOCAL GOVT - VAC	0.3900	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	04
47D-1B-35	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	90104	ATKINS	030500	305	940.5700		5000		5000	18900	1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	716.8982	721.0210	720.0136	740V	LOCAL GOVT - VAC	9.4500	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	05
66A-3-38A	1031	51	173	0 UNASSIGNED	CHILHOWIE	VA		TOWN OF CHILHOWIE	P O BOX 5012	CHILHOWIE	VA	24319	SMYTH	95511	RYE VALLEY	030702	307.0200	365.8780		5000		5000	190000	1986-10-16	1	1			0				51173C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	690.4420	692.3302	691.1460	740V	LOCAL GOVT - VAC	0	GOVERNMENT	R R ST LOT 1 14 53D3 A 69	366	3		OTHER	GAS				2026.2	2026	07