Saved query 68d6293b13eb9613

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

36/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '23' 
  AND countyfp = '009'

51,162 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	parceltype	accesstype	iucnclass	placename	placetype	lrversion
003-043-002	23	009		MOUNT DESERT	ME	09210	HANCOCK	47630	MOUNT DESERT	966000	9660	6661.3353	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		8.2853	14.9035	10.4858	GOVT FEDERAL	UNKNOWN	OTHER	ACADIA NATIONAL PARK EASEMENT	CONSERVATION EASEMENT	2026.2
072-002-000	23	009	HAPPYTOWN ROAD	ELLSWORTH	ME	09130	HANCOCK	23200	ELLSWORTH	965504	9655.0400	5408913.2336	23009C	2025-06-03	A						GOVT STATE	CLOSED	III	BRANCH LAKE	STATE PARK	2026.2
024-148	23	009		MOUNT DESERT	ME	09210	HANCOCK	47630	MOUNT DESERT	966000	9660	29795.7125	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		-0.2175	7.2999	3.7351				THE BUCKING LOBSTER	RESTAURANT	2026.2
005-013-001	23	009		MOUNT DESERT	ME	09210	HANCOCK	47630	MOUNT DESERT	966000	9660	5953.9165	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		21.0729	27.8703	25.0528				LAND & GARDEN PRESERVE	GARDEN	2026.2
007-019-000-000	23	009		LAMOINE	ME	09180	HANCOCK	38180	LAMOINE	966700	9667	85041.2407	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		7.4384	28.0027	17.0911				COVERED YANKEE INTERIORS	HOME_SERVICE	2026.2
004-006-K	23	009	OLD MILL STREAM ROAD	SULLIVAN	ME	09300	HANCOCK	74965	SULLIVAN	965700	9657	26381.3653	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		26.0088	32.8045	29.6898						2026.2
003-062	23	009	US HIGHWAY 1	SULLIVAN	ME	09300	HANCOCK	74965	SULLIVAN	965700	9657	220758.3260	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		3.7650	27.6448	18.2980						2026.2
091-016-000	23	009	BOR WAY	ELLSWORTH	ME	09130	HANCOCK	23200	ELLSWORTH	965504	9655.0400	146667.8992	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		74.3905	126.9718	104.2192						2026.2
107-017-000	23	009	JESSES BEACH WAY	ELLSWORTH	ME	09130	HANCOCK	23200	ELLSWORTH	965504	9655.0400	213872.0125	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		30.7299	42.0525	35.0632						2026.2
026-063	23	009		MOUNT DESERT	ME	09210	HANCOCK	47630	MOUNT DESERT	966000	9660	314.8129	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		17.6332	18.3397	17.9876				THE REDBOOK - DIRECTORY AND HAN…	PROFESSIONAL_SERVICE	2026.2
unknown	23	009		BROOKSVILLE	ME	09060	HANCOCK	07975	BROOKSVILLE	966500	9665	676.2174	23009C	2025-06-03	VE		11	-0.4583	0.8028	0.1792						2026.2
037-020	23	009		HOMESTEAD	ME	09040	HANCOCK	05700	BLUE HILL	966300	9663	2158.9847	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		36.8952	40.6480	38.3440						2026.2
006-004-001-001	23	009		LAMOINE	ME	09180	HANCOCK	38180	LAMOINE	966700	9667	6727.1461	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		0.6725	5.5213	3.3160						2026.2
007-029-000-000	23	009		LAMOINE	ME	09180	HANCOCK	38180	LAMOINE	966700	9667	365142.6647	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		-0.5417	15.8592	7.3910						2026.2
010-001-000-000	23	009		LAMOINE	ME	09180	HANCOCK	38180	LAMOINE	966700	9667	223610.1825	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		11.7112	31.2845	24.1981						2026.2
018-007-000-000	23	009		LAMOINE	ME	09180	HANCOCK	38180	LAMOINE	966700	9667	2414.8099	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		37.9278	41.7680	40.1022						2026.2
001-081-005-000	23	009		LAMOINE	ME	09180	HANCOCK	38180	LAMOINE	966700	9667	10935.3082	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		50.9338	54.5626	53.1382						2026.2
024-059-001	23	009		MOUNT DESERT	ME	09210	HANCOCK	47630	MOUNT DESERT	966000	9660	2046.0016	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		14.2581	20.0416	16.4508						2026.2
010-151-003	23	009		MOUNT DESERT	ME	09210	HANCOCK	47630	MOUNT DESERT	966000	9660	4851.6818	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		18.3538	27.2350	21.8786						2026.2
009-015-005-000	23	009		LAMOINE	ME	09180	HANCOCK	38180	LAMOINE	966700	9667	7831.0670	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		48.5823	54.7872	51.0253						2026.2
014-011-000-000	23	009		LAMOINE	ME	09180	HANCOCK	38180	LAMOINE	966700	9667	9583.6589	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		11.6790	19.1928	15.8582						2026.2
020-001-000-000	23	009		LAMOINE	ME	09180	HANCOCK	38180	LAMOINE	966700	9667	10856.1916	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		54.2600	65.3125	60.0334						2026.2
003-029-000-000	23	009		LAMOINE	ME	09180	HANCOCK	38180	LAMOINE	966700	9667	27086.0466	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		0.3852	30.7028	19.1346						2026.2
021-041	23	009		MOUNT DESERT	ME	09210	HANCOCK	47630	MOUNT DESERT	966000	9660	4951.4269	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		11.7299	18.2436	15.4057						2026.2
002-002-000-000	23	009		LAMOINE	ME	09180	HANCOCK	38180	LAMOINE	966700	9667	1586.8593	23009C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD		52.9011	55.5415	54.0329						2026.2