Saved query db95f6ec300d8910

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

0/80

Live SQL

SELECT * 
FROM "parcel_layer" 
WHERE statefp = '51' 
  AND countyfp = '690'

11,188 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	naicscode	parceltype	accesstype	placename	placetype	taxdistrict
050160000	25-4-1	51	690	1100 CHATHAM HEIGHTS ROAD	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000100	1	561.6415		51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	325.7554	329.0774	328.0890	7212	GOVT LOCAL	OPEN	HOOKER FIELD	LOCAL RECREATION AREA	Martinsville City
000448400	58-3-12R	51	690	1324 SOUTH MEMORIAL BOULEVARD	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000400	4	2095.6683	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	245.6548	252.9378	249.1634	5412			PAM HAIRSTON TAX SERVICES	FINANCIAL_SERVICE	Martinsville City
000456300	32-1-I-20	51	690	17 EAST CHURCH STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000300	3	144.7830	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	311.1023	311.8769	311.5838	8121			TEE'S BRAIDING CORNER	PERSONAL_CARE_AND_BEAUTY_STORE	Martinsville City
000223200	31-2-E-3	51	690	8 NORTH JACKSON STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000200	2	692.9106	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	280.7697	286.3291	283.2481						Martinsville City
000788300	68-2-P-22	51	690	1314 ROOT TRAIL	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000500	5	2137.6842	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	222.3333	239.1937	228.7171						Martinsville City
000668700	32-1-O-11	51	690	219 MOSS STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000300	3	1152.7884	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	291.3422	301.6480	299.0731						Martinsville City
000969900	60-12-20	51	690	116 VILLAGE STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000400	4	936.5229	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	251.0507	255.6384	253.3619						Martinsville City
000626900	71-6-38-20	51	690	909 CLARKE ROAD	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000500	5	1615.6983	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	225.4355	237.8130	233.8264						Martinsville City
000511700	11-1-24C24D25B	51	690	718 STULTZ ROAD	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000100	1	2299.0544	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	238.0384	251.9082	243.6384						Martinsville City
000483600	35-1-3-7	51	690	212 FAIRY STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000300	3	630.0571	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	303.4192	307.4187	305.5136						Martinsville City
000481700	34-4-4-5	51	690	203 FAIRY STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000300	3	514.2538	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	306.0549	310.4040	308.6281						Martinsville City
000720800	43-9-5B	51	690	603 SHORT STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000400	4	353.2839	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	301.0011	302.6439	301.8479						Martinsville City
000869600	39-9-3	51	690	1500 ROUNDABOUT ROAD	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000200	2	1054.2030	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	282.3775	288.4779	285.4744						Martinsville City
000135200	8-2-5-18	51	690	506 GLENDALE STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000100	1	897.1535	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	260.0607	264.1318	262.0950						Martinsville City
000315900	52-5-23A	51	690	1003 PAUL STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000400	4	589.4106	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	292.1355	297.1670	294.9701						Martinsville City
000961900	7-8-15B	51	690	914 ROYAL DRIVE	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000100	1	1496.3226	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	259.1180	266.9070	262.3050						Martinsville City
000862200	40-2-E-1	51	690	600 3RD STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000200	2	501.5464	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	282.2721	286.0768	284.3991						Martinsville City
000847900	84-4-Q-23	51	690	1005 RIVER FOREST PLACE	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000500	5	2024.8929	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	214.8524	232.8626	225.2546						Martinsville City
000780500	31-2-A-10	51	690	13 MASSEY STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000200	2	1206.4916	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	295.3439	299.1684	297.4457						Martinsville City
000471100	12-1-2	51	690	562 DILLARD STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000200	2	513.1495	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	249.7192	252.9207	251.2966						Martinsville City
000402600	71-2-34-14	51	690	1600 SAM LIONS TRAIL	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000500	5	2024.1498	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	226.1355	229.2183	228.5002						Martinsville City
000305000	50-1-1	51	690	1024 ASKIN STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000400	4	582.0787	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	270.8510	276.5606	274.0705						Martinsville City
000723800	40-2-C-40	51	690	508 2ND STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000200	2	1003.4305	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	277.3847	287.3775	282.7360						Martinsville City
000492600	85-1-R-26	51	690	1252 LANIER ROAD	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000500	5	3668.1687	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	214.2421	238.8026	230.1478						Martinsville City
000186900	50-2-C-20	51	690	1013 ASKIN STREET	MARTINSVILLE	VA	24112	Martinsville	94537	Martinsville	000400	4	662.0631	1	51089C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	270.1118	279.9726	275.9656						Martinsville City