Saved query aaf7bb0ec669be38

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 = '26' 
  AND countyfp = '019'

23,099 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	numunits	numfloors	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	ownertype	naicscode	legaldesc	parceltype	accesstype	iucnclass	placename	placetype	taxyear
14747	26	019			MI	49640	UNITED STATES NATIONAL PARK SER…			Benzie	44240	LAKE	000200	2	161338.5316	0	1		26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	177.7729	212.8842	184.1792			GOVERNMENT	7212	LOT 0	GOVT FEDERAL	RESTRICTED	IB	SLEEPING BEAR DUNES WILDERNESS …	WILDERNESS AREA	2015
	26	019			MI	49635	NON-GOVERNMENTAL ORGANIZATION			Benzie	08840	BLAINE	000500	5	159912.7336	0	2		26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	194.5960	265.5314	230.5739	7240	NATURE_RESERVE	PERSON	8141	LOT 0	NGO	OPEN	V	GREEN POINT DUNES	PRIVATE CONSERVATION	2015
10-018-011-00	26	019		,	MI	49640	NATIONAL PARK SERVICE	9922 FRONT ST	EMPIRE, MI 49630	Benzie	44240	Lake	000200	2	2440.7943				26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	181.5386	183.7795	182.1412		402, RESIDENTIAL-VACANT	PERSON	7212		GOVT FEDERAL	RESTRICTED	V	SLEEPING BEAR DUNES NATIONAL LA…	NATIONAL LAKESHORE OR SEASHORE
14253	26	019	5313 BIRCH POINT ROAD	BEULAH	MI	49617				Benzie	07600	BENZONIA	000300	3	190031.0061	0	1		26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	181.5894	187.2482	182.8912	7240	NATURE_RESERVE			LOT 0						2015
12-101-107-00	26	019	12276 CRYSTAL MOUNTAIN DRIVE	THOMPSONVILLE, MI 49683	MI	49683	GRAHAM, RICHARD B JR & LISA C (…	34466 SHELLYE COURT	WESTLAND, MI 48185	Benzie	85160	Weldon	000500	5	1510.4956				26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	240.4072	241.1352	240.6898		401, RESIDENTIAL-IMPROVED	PERSON	7211		PRIVATE	RESTRICTED		RED PINE RETREAT	LODGING
12-101-066-00	26	019	7919 OTTAWA COURT (PVT)	THOMPSONVILLE, MI 49683	MI	49683	SMITH-HIETIKKO, ANGELA D	159 MAYFIELD AVE NE	GRAND RAPIDS, MI 49503	Benzie	85160	Weldon	000500	5	1305.3504				26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	245.7768	247.4361	246.6254		401, RESIDENTIAL-IMPROVED	PERSON	71392		PRIVATE	RESTRICTED		CRYSTAL MOUNTAIN GOLF COURSE AN…	PRIVATE PARK
14270	26	019	3748 GRACE ROAD	FRANKFORT	MI	49635				Benzie	32180	GILMORE	000500	5	161767.2408	6	1	1	26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	236.1416	262.4844	254.9197					LOT 0						2015
2023086	26	019	5012 MOLLINEAUX ROAD	FRANKFORT	MI	49635				Benzie	07600	BENZONIA	000300	3	161434.5850	0	3		26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	182.6696	212.3749	188.3473					LOT 0						2015
15653	26	019			MI	49640				Benzie	64760	PLATTE	000200	2	162127.1810	0	1		26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	259.0547	265.0528	261.2836					LOT 0						2015
14999	26	019			MI	49683				Benzie	17120	COLFAX	000102	1.0200	158592.7152	0	1		26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	244.8597	248.3416	245.7583					LOT 0						2015
10-340-000-00	26	019		,	MI	49640	NORTH SHORE PLATTE LAKE SITE CO…	2875 BELARE DRIVE	TRAVERSE CITY, MI 49684	Benzie	44240	Lake	000200	2	2628.0669				26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	178.1556	181.7645	180.7279		001, RETIRED SPLIT/COMBINE	BUSINESS	2361
02-506-040-00	26	019	7198 CLARK STREET	BEULAH, MI 49617	MI	49617	MANORWOOD PROPERTIES LLC	555 S OLD WOODWARD AVE STE 705	BIRMINGHAM, MI 48009	Benzie	07600	Benzonia	000300	3	509.4281				26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	184.8496	186.2892	185.8844		401, RESIDENTIAL-IMPROVED	BUSINESS	531311
01-190-059-00	26	019	20761 WHITE OAK DRIVE	LAKE ANN, MI 49650	MI	49650	P&C HOLDINGS, LLC	2670 HERRON ROAD	FRANKFORT, MI 49635	Benzie	01640	Almira	000101	1.0100	2134.8897				26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	269.4519	274.3652	272.4040		401, RESIDENTIAL-IMPROVED	BUSINESS	5232
01-028-021-00	26	019	BURNT MILL ROAD	LAKE ANN, MI 49650	MI	49650	STATE	PO BOX 30448	LANSING, MI 48909	Benzie	01640	Almira	000101	1.0100	63174.3691				26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	236.9871	247.8131	240.9109		402, RESIDENTIAL-VACANT	BUSINESS	3122
14941	26	019			MI	49683				Benzie	17120	COLFAX	000102	1.0200	162058.5892	0	1		26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	251.9786	254.2504	252.9080					LOT 0						2015
13899	26	019			MI	49643				Benzie	40700	INLAND	000101	1.0100	163514.7619	0	2		26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	219.3471	246.1697	240.4522					LOT 0						2015
08-070-003-00	26	019		,	MI	49643	INLAND TOWNSHIP	19668 HONOR HIGHWAY	INTERLOCHEN, MI 49643	Benzie	40700	Inland	000102	1.0200	250.7331				26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	258.7704	259.1919	258.9812		006, PERMANENT REFERENCE DDA/TI…	GOVERNMENT	2372
12-031-003-00	26	019		BENZONIA, MI 49616	MI	49616	STATE	PO BOX 30448	LANSING, MI 48909	Benzie	85160	Weldon	000500	5	322773.8520				26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	225.9990	236.7857	230.1130		102, AGRICULTURAL-VACANT	BUSINESS	3122
14026	26	019			MI	49617				Benzie	39000	HOMESTEAD	000200	2	162212.9945	0	1		26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	244.4787	257.1483	253.3584					LOT 0						2015
02-102-011-00	26	019	2027 BENZIE HIGHWAY	BENZONIA, MI 49616	MI	49616	DC ACQUISITION COMPANY	950 WOODWARD HEIGHTS	FERNDALE, MI 48220	Benzie	07600	Benzonia	000500	5	8675.6531				26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	193.5685	197.6977	195.6989		201, COMMERCIAL-IMPROVED	BUSINESS	3159
15142	26	019			MI	49616				Benzie	85160	WELDON	000500	5	163028.2262	0	8		26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	194.8265	216.1242	206.5364					LOT 0						2015
1000378	26	019			MI	49640				Benzie	64760	PLATTE	000200	2	257736.5777	0	2		26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	266.0993	290.3458	283.1686					LOT 0						2015
10-030-038-30	26	019	SYLVAN ROAD (PVT)	FRANKFORT, MI 49635	MI	49635	TRANQUILL, GARY TRUST	345 SYLVAN ROAD	FRANKFORT, MI 49635-8520	Benzie	44240	Lake	000400	4	4060.8128				26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	184.8358	194.3360	187.3714		402, RESIDENTIAL-VACANT	TRUST
51-010-385-00	26	019	508 MICHIGAN AVENUE	FRANKFORT, MI 49635	MI	49635	MANZARI, LUIGI (LE)	508 MICHIGAN AVE	FRANKFORT, MI 49635	Benzie	30260	Frankfort	000400	4	557.6422				26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	215.4878	216.5450	215.7908		401, RESIDENTIAL-IMPROVED	PERSON
09-014-008-01	26	019	4462 WALLAKER ROAD	BENZONIA, MI 49616	MI	49616	GRUSS, ALLEN	4462 WALLAKER ROAD	BENZONIA, MI 49616	Benzie	42000	Joyfield	000500	5	16372.1137				26019C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	232.9585	243.9467	238.4171		401, RESIDENTIAL-IMPROVED	PERSON