Saved query 5fd7d4e14c6810b7

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

10,765 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	zoningcode	zoningdesc	taxacres	ownertype	naicscode	legaldesc	book	page	placename	placetype	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	lrversion	taxyear	taxdistrict
056 01-01-06 00-0000	19406	51	775	1910 QUEENSMILL DR	SALEM	VA	24153	LESLIE NANETTE E	1910 QUEENSMILL DR	SALEM VA	VA	24153	SALEM	95547	SALEM	010502	105.0200	1171.4110	234700	13400	-56600	361300		2017-01-26	1	1	1981		2322	4	1	2	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	344.9480	347.6520	346.1096	NO	PRIVATE CITIZEN	COUNTY-R1.PDF	LOW DENSITY RESIDENTIAL	0.2894	PERSON		LT 7 BLK 6 SEC 6 WOODBRIDGE					1	CENTRAL AIR	GAS	CENTRAL AIR	CONTINUOUS FOOTING	ARCHITECTURAL SHINGLES	VINYL OR ALUMINUM	2026.2	2026	ROANOKE COUNTY
056 01-05-18 00-0000	19566	51	775	2010 STONE MILL DR	SALEM	VA	24153	PRICE BRADFORD D	2010 STONE MILL DR	SALEM VA	VA	24153	SALEM	95547	SALEM	010502	105.0200	934.6266	366300	0	-51000	468300	327500	2020-03-04	1	1	2006		2492	4	1	3	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	354.5358	360.3190	357.4147	NO	PRIVATE CITIZEN	COUNTY-R1.PDF	LOW DENSITY RESIDENTIAL	0.2309	PERSON		LT 18 SEC 18 WOODBRIDGE					1	HEAT PUMP	GAS/ELECTRIC	HEAT PUMP	CONTINUOUS FOOTING	ARCHITECTURAL SHINGLES	VINYL OR ALUMINUM	2026.2	2026	ROANOKE COUNTY
0613-83-254790	129-2-2	51	775	349 WILDWOOD RD		VA	24153	PRAHANS LLC		SALEM VA		24153	SALEM	95547	SALEM	010200	102	3086.5098	220400	348300		568700	495000	2020-09-29	1	1	1979	1	1820	0		2	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	326.2958	327.7165	327.2236	COMMERCIAL/INDUSTRIAL	COMMERCIAL IMPROVED	HBD	RESTAURANT	27443	BUSINESS	7225	PT TRACT A 0 63 AC W R CALFEE P…	200002697	100000100	GARCIA'S BISTRO - SALEM	RESTAURANT	0	UNDETERMINED	GAS	OTHER	NONE	RUBBER	BRICK	2026.2		902
0623-32-094450	126-3-15	51	775	1407 W MAIN ST		VA	24153	FRONTIER SALEM LLC		MIAMI FL		33133	SALEM	95547	SALEM	010200	102	3885.6269	1130500	896400		2026900	950000	2007-02-01	1	1	2007	1	11970	0		5	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	314.5888	315.9658	315.4766	COMMERCIAL/INDUSTRIAL	COMMERCIAL IMPROVED	HBD	RETAIL	41208	BUSINESS		0 946 AC WESTVIEW	070000418	215-135	GAMESTOP	BOOKS_MUSIC_AND_VIDEO_STORE	0	UNDETERMINED	GAS/ELECTRIC	OTHER	NONE	RUBBER	CINDERBLOCK/STUCCO	2026.2		902
0632-46-713446	248-6-1	51	775	1002 APPERSON DR		VA	24153	SALEM 1002 LLC		SALEM VA		24153	SALEM	95547	SALEM	010501	105.0100	505.8897	338300	47800		386100		2023-02-14	1	1	1960	1	2090	0		2	51161C	2026-01-08	AE		302.2180	302.8535	302.4832	COMMERCIAL/INDUSTRIAL	COMMERCIAL IMPROVED	HBD	MEDICAL OFFICE	5500	BUSINESS	7225	NW PT LT 3 BLK 5 SEC 1 ORCHARD …	230000275	150002073	BASTIANS BAR B Q & CATERING INC.	RESTAURANT	0	HEAT PUMP	GAS/ELECTRIC	OTHER	NONE	TAR/GRVL	DRYVIT	2026.2		910
0633-11-753061	159-4-6	51	775	626 TENNESSEE ST		VA	24153	CARSWELL SETH		SALEM VA		24153	SALEM	95547	SALEM	010300	103	626.7404	137600	35900		173500	175000	2023-11-21	1	5	1956	1	784	2		1	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	315.7120	317.5258	316.6788	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	ONE STORY	6750	PERSON		LT 14 S 15 FT LT 13 N 5 FT LT 1…	230002137	180002341			0	UNDETERMINED	GAS	OTHER	FULL-UNF	ARCH SHING	VINYL	2026.2		202
0633-16-837133	72-2-8.1	51	775	355 CRAIG AVE		VA	24153	SCHULTZ CARL N SCHULTZ BETTY M		SALEM VA		24153	SALEM	95547	SALEM	010100	101	860.7184	147500	41500		189000	31800	1977-06-15	1	5	1977	1	1040	3		1	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	331.5101	336.3876	334.6386	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	ONE STORY	9368	PERSON		LT 1 REVISED PLAT OF GREENWAY C…	48-592	44-254			0	UNDETERMINED	ELECTRIC	OTHER	FULL-UNF	COMP SHG	BRICK	2026.2		113
0632-52-687760	302-1-4	51	775	2553 S CLEARING RD		VA	24153	GERBERICH DEBORAH L		SALEM VA		24153	SALEM	95547	SALEM	010501	105.0100	538.7440	283400	45900		329300	375000	2025-10-15	1	6	1980	2	2144	3		3	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	341.2746	342.4012	341.7521	URBAN RESIDENTIAL	TOWNHOME	RMF	TOWNHOUSE	5585	PERSON		LT 2 MEADOWS OF RIDGEWOOD FARM	250002184	210001380			1	UNDETERMINED	GAS	OTHER	NONE	ARCH SHING	WOOD	2026.2		750
0633-93-337165	115-4-3	51	775	1712 VICTORIA ST		VA	24153	MILLER FREDERICK J MILLER SHARO…		HUDDLESTON VA		24104	SALEM	95547	SALEM	010100	101	1370.6840	161600	43000		204600	141450	2020-03-10	1	5	1958	1	1018	3		1	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	340.5887	355.4203	348.9828	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	ONE STORY	14400	PERSON		LT 3 BLK 4 MORWANDA PARK	200000612	180002097			0	UNDETERMINED	GAS	OTHER	FULL-UNF	ARCH SHING	BRICK	2026.2		204
0633-11-492934	146-9-4	51	775	521 TENNESSEE ST		VA	24153	VANDERPOOL MICHAEL WILLIAM		SALEM VA		24153	SALEM	95547	SALEM	010300	103	1393.6012	154700	67500		222200	222200	2026-03-04	2	8	1900	2	2178	4		2	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	316.6927	317.4968	317.1104	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	TWO STORY	14984	PERSON		LT 21A 0 344 AC SEC 18 SALEM IM…	260000386	PB16-39			0	UNDETERMINED	GAS	UNDETERMINED	QRTR	METAL	WOOD	2026.2		206
0633-12-709661	146-8-6	51	775	519 DELAWARE ST		VA	24153	WILLIAMSON JIMMY D		ROANOKE VA		24018	SALEM	95547	SALEM	010300	103	1030.2839	183600	54300		237900	505000	2022-01-05	1	10	1955	1	1611	4		2	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	317.2766	318.6292	318.0538	MULTI - FAMILY	DUPLEX	RSF	DUPLEX	11250	PERSON		LTS 19 20 N PT LT 18 8 FT LT 21…	220000029	322-251(F)			0	UNDETERMINED	ELECTRIC	OTHER	FULL-UNF	ARCH SHING	BRICK	2026.2		206
0623-92-448225	145-14-3	51	775	435 S BROAD ST		VA	24153	SMITH LINDA		SALEM VA		24153	SALEM	95547	SALEM	010300	103	1101.4577	139500	49700		189200	88799	2016-04-18	1	6	1908	2	1727	4		2	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	314.3344	315.0542	314.6877	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	TWO STORY	12012	PERSON		LT 70 DROPMORE OR BURWELL ADDN …	160000878	150002731			0	HEAT PUMP	ELECTRIC	OTHER	CRAWL SP	COMP SH	VINYL	2026.2		202
0622-82-210314	297-8-15	51	775	116 PAR DR		VA	24153	JOHNSON TIMOTHY S JOHNSON COURT…		SALEM VA		24153	SALEM	95547	SALEM	010501	105.0100	1508.4115	297900	56900		354800	268000	2018-08-07	1	9	1992	2	2728	4		25	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	383.2200	389.3743	386.8488	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	TWO STORY	16224	PERSON		LT 10 SEC 4 WEST CLUB FOREST	180001808	170-653			1	UNDETERMINED	GAS	OTHER	FULL	ARCH SHING	VINYL	2026.2		306
0632-45-333285	259-5-6	51	775	921 HOMESTEAD DR		VA	24153	CAPOBIANCO ROBERT N CAPOBIANCO …		SALEM VA		24153	SALEM	95547	SALEM	010501	105.0100	2350.2018	195500	57500		253000	271000	2023-01-17	1	6	1950	14	1348	2		2	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	304.5124	308.6519	306.8432	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	ONE PLUS STORY	25296	PERSON		LT 7 BLK 7 SEC 1 ORCHARD COURT	230000103	190002225			0	UNDETERMINED	GAS	OTHER	HALF-UNF	COMP SHG	BRICK	2026.2		305
0623-53-385439	124-3-14	51	775	123 VALLEYDALE AVE		VA	24153	WILSON ALEX G		SALEM VA		24153	SALEM	95547	SALEM	010200	102	847.5803	125800	48100		173900	139000	2020-11-20	1	4	1951	1	768	2		1	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	326.6771	329.6890	328.0674	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	ONE STORY	8880	PERSON		LT 13 BLK 6 SEC 1 LAKEVIEW PLACE	200003327	050003998(S)			0	UNDETERMINED	OIL	OTHER	CRAWL SP	ARCH SHING	VINYL	2026.2		104
0642-18-085676	224-2-1	51	775	913 DOMINION LN		VA	24153	JOHNSON JAMES LEE JR		SALEM VA		24153	SALEM	95547	SALEM	010300	103	728.5091	161300	44500		205800	85000	2000-10-31	1	6	1966	1	997	3		2	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	327.9372	328.9127	328.5361	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	ONE STORY	7700	PERSON		LT 16 BLK 2 BOULEVARD ESTATES	337-543	83-124(S)			0	UNDETERMINED	GAS	OTHER	FULL-FIN	COMP SHG	BRICK/	2026.2		204
0633-07-220147	61-1-7	51	775	237 HAWTHORN RD		VA	24153	HOLLINGSWORTH JUSTIN CRAIG STRA…		SALEM VA		24153	SALEM	95547	SALEM	010200	102	1977.3760	306200	81100		387300	385000	2021-01-28	1	7	1956	2	2054	3		2	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	329.4687	335.1737	332.4917	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	SPLIT	21911	PERSON		TRACT A 0 503 AC GOBBLE BELL RE…	210000295	PB9-16			1	UNDETERMINED	GAS	OTHER	HALF-FIN	ARCH SHING	WOOD/	2026.2		107
0623-54-286442	103-1-4	51	775	913 WATTS ST		VA	24153	SHIFLETT RAYMOND S LYONS TESSA		SALEM VA		24153	SALEM	95547	SALEM	010200	102	868.3434	210800	52600		263400	153000	2016-06-06	1	7	1951	165	1617	4		2	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	338.2804	339.9888	339.5555	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	ONE PLUS STORY	9432	PERSON		LT 12 BLK 2 LAKEVIEW PLACE SURV…	160001296	080001258(S)			1	UNDETERMINED	GAS	OTHER	FULL-UNF	ARCH SHING	BRICK/	2026.2		105
0632-13-008172	287-1-22	51	775	176 FOREST DR		VA	24153	WHITE ANTHONY M JONES SHARONDA R		SALEM VA		24153	SALEM	95547	SALEM	010501	105.0100	1890.4390	370800	70200		441000	350000	2016-08-03	1	8	1988	2	3292	5		32	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	341.4730	354.8877	347.8169	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	TWO STORY	20125	PERSON		LT 10 BLK 2 HIDDEN VALLEY FOREST	160001834	140001134			2	UNDETERMINED	GAS	OTHER	FULL-UNF	COMP SHG	BRICK	2026.2		310
0622-76-539624	243-2-10	51	775	711 BONNIE LN		VA	24153	FARON DAVID T FARON MITZI W		SALEM VA		24153	SALEM	95547	SALEM	010502	105.0200	2595.4345	251100	61600		312700	137300	1993-05-15	2	6	1993	1	1631	3		2	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	340.5306	349.2341	343.7975	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	ONE STORY	27621	PERSON		LT 42 BLK 4 SEC 2 KAREN HILLS	201-438	PB1-86			2	UNDETERMINED	GAS	OTHER	FULL-UNF	COMP SHG	BRICK	2026.2		304
0633-65-777772	82-2-1.17	51	775	28 HART DR		VA	24153	K K RENTALS LLC		ROANOKE VA		24018	SALEM	95547	SALEM	010100	101	429.3693	143200	34000		177200		2016-06-02	1	4	1984	2	1146	0		15	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	319.8762	320.6713	320.3990	URBAN RESIDENTIAL	TOWNHOME	RMF	TOWNHOUSE	4979	BUSINESS		LT 17 PARKDALE MANOR	160001270	160000249			0	UNDETERMINED	GAS	OTHER	NONE	ARCH SHING	BRICK	2026.2		750
0622-89-607566	201-6-2	51	775	516 BOWMAN AVE		VA	24153	STUMP JERRY W STUMP TERESA P		SALEM VA		24153	SALEM	95547	SALEM	010502	105.0200	615.3895	150000	38300		188300	50000	1998-03-06	3	4	1945	1	1260	3		2	51161C	2026-01-08	AE		305.8348	307.3008	306.3096	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	ONE STORY	6500	PERSON		PT SEC 25 SALEM DEVELOPMENT CO	280-322(S)(F)	41-105			0	UNDETERMINED	GAS	OTHER	CRAWL SP	COMP SHG	VINYL	2026.2		302
0613-42-939211	135-7-7	51	775	2640 JACKSON DR		VA	24153	DREWRY JO ANN		SALEM VA		24153	SALEM	95547	SALEM	010200	102	1325.6957	201400	50300		251700		2011-03-31	1	6	1964	1	1275	3		15	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	345.7135	348.0437	347.0998	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	ONE STORY	14250	PERSON		LT 15 BLK L SEC 1 BEVERLY HEIGH…	020005442*	241-767			2	UNDETERMINED	OIL	OTHER	HALF-FIN	ARCH SHING	BRICK	2026.2		100
0633-32-485257	147-2-8	51	775	840 MARYLAND AVE		VA	24153	SWEENEY EDMOND L SWEENEY SALLY A		SALEM VA		24153	SALEM	95547	SALEM	010100	101	1217.0008	140900	59400		200300		2025-06-20	2	5	1938	12	1066	3		1	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	347.7419	349.7601	348.9884	URBAN RESIDENTIAL	RESIDENTIAL IMPROVED	RSF	ONE PLUS STORY	13200	PERSON		N PT LTS 10-12 SEC 55 SALEM IMP…	250001228	130002592(S)			0	UNDETERMINED	ELECTRIC	UNDETERMINED	FULL-UNF	ARCH SHING	BRICK	2026.2		206
0623-91-195641	144-4-10.1	51	775	406 CHAPMAN ST		VA	24153	HALL RICHARD L		SALEM VA		24153	SALEM	95547	SALEM	010300	103	505.8015	249100	42600		291700	270000	2021-11-30	1	6	2006	2	1636	3		2	51161C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	315.7528	316.2365	315.9895	URBAN RESIDENTIAL	TOWNHOME	RSF	TOWNHOUSE	5691	PERSON		LT 101B JOHN A LAW SUBD RESUB L…	210003936	180001672			1	HEAT PUMP	GAS/ELECTRIC	OTHER	NONE	ARCH SHING	VINYL/BRICK	2026.2		750