Saved query 3c3459cca90dfae8

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 = '39' 
  AND countyfp = '043'

45,921 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	naicscode	parceltype	accesstype	placename	placetype
39043-5400911000	39	043	114 LAKESHORE KELLEYS ISLAND 43…	KELLEYS ISLAND	OH	43438	PO BOX 828 KELLEYS ISLAND 43438	KELLEYS ISLAND	OH	43438	Erie	39662	Kelleys Island	041900	419	598.0344	2	39043C	2025-12-11	AE	COASTAL FLOODPLAIN	580	175.5257	178.9247	177.0940	499: Com-Other	499: Com-Other	0.1600	488310			PORTSIDE MARINA	MARINA
39043-5601179011	39	043	300 WATER ST SANDUSKY 44870	SANDUSKY	OH	44870	300 E WATER ST UNIT 3-C	SANDUSKY	OH	44870	Erie	70380	Sandusky	040802	408.0200	2774.8700	1	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		177.3161	179.1755	178.1025	550: Res-Condo	550: Res-Condo	0	71212			LAKEVIEW CONDOS	HISTORIC_SITE
39043-5864015000	39	043	MILLS SANDUSKY 44870		OH	44870	222 MEIGS ST	SANDUSKY	OH	44870	Erie	70380	Sandusky	041000	410	10034.6332	0	39043C	2025-12-11	AE			174.9738	177.2231	176.3895	640: Exm-Municipality	640: Exm-Municipality	2.4000	8141	PRIVATE	RESTRICTED	MILLS CREEK GOLF COURSE	PRIVATE PARK
39043-3203356008	39	043	1101 LAKECREST SANDUSKY 44870	SANDUSKY	OH	44870	5101 MENARD DR	EAU CLAIRE	WI	54703	Erie	61714	Perkins	041400	414	63974.9985	2	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		181.1683	183.7100	182.6320	422: Com-Discount Store	422: Com-Discount Store	15.7600	6216			KEYME LOCKSMITHS	HOME_SERVICE
39043-5601174056	39	043	401 SHORELINE SANDUSKY 44870		OH	44870	17047 ALBION RD	STRONGSVILLE	OH	44136	Erie	70380	Sandusky	040802	408.0200	19242.5146	4	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		175.2705	177.3312	176.4966	550: Res-Condo	550: Res-Condo	0	712190			SANDUSKY SHORELINE PARK	PARK
39043-3203494028	39	043	1105 RAMADA SANDUSKY 44870		OH	44870	PO BOX 7300 EL DORADO 71731	EL DORADO	AR	71731	Erie	61714	Perkins	041900	419	4024.1781	1	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		184.1052	185.1990	184.6763	452: Com-Auto Service	452: Com-Auto Service	1	457110			MURPHY USA	GAS_STATION
39043-5500153000	39	043	174 SUNSET SANDUSKY 44870	SANDUSKY	OH	44870	174 SUNSET DRIVE	SANDUSKY	OH	44870	Erie	70380	Sandusky	041900	419	1828.4449	1	39043C	2025-12-11	AE	COASTAL FLOODPLAIN	577	174.9347	177.0219	176.1351	510: Res-Single Family	510: Res-Single Family	0
39043-5500120000	39	043	1538 WILLOW SANDUSKY 44870	SANDUSKY	OH	44870	542 KIMBERLY CT	BAY VILLAGE	OH	44140	Erie	70380	Sandusky	041900	419	1038.9049	1	39043C	2025-12-11	AE	COASTAL FLOODPLAIN	577	175.6898	177.3059	176.3594	510: Res-Single Family	510: Res-Single Family	0
39043-5702004000	39	043	1933 FIFTH ST SANDUSKY 44870	SANDUSKY	OH	44870	11586 174TH CT NE	REDMOND	WA	98052	Erie	70380	Sandusky	040700	407	1010.2052	3	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		176.0354	176.4334	176.2520	510: Res-Single Family	510: Res-Single Family	0
39043-3201613000	39	043	2823 HINDE AVE SANDUSKY 44870	SANDUSKY	OH	44870	2823 HINDE AVE	SANDUSKY	OH	44870-5957	Erie	61714	Perkins	041900	419	724.5607	1	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		178.6067	179.2687	178.9109	510: Res-Single Family	510: Res-Single Family	0
39043-3900661032	39	043	707 ELIZABETH HURON 44839	HURON	OH	44839	707 ELIZABETH DR	HURON	OH	44839	Erie	37030	Huron	041900	419	29544.4948	14	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		176.5819	183.8977	181.7032	550: Res-Condo	550: Res-Condo	0
39043-5802260000	39	043	3301 VENICE RD SANDUSKY 44870	SANDUSKY	OH	44870	3301 VENICE RD	SANDUSKY	OH	44870	Erie	70380	Sandusky	040900	409	633.2874	1	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		180.1593	180.8057	180.5242	510: Res-Single Family	510: Res-Single Family	0.1600
39043-3203410000	39	043	4928 RICHMOND CIR SANDUSKY 44870	SANDUSKY	OH	44870	4928 RICHMOND CIRCLE	SANDUSKY	OH	44870	Erie	61714	Perkins	041900	419	664.3268	2	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		189.8637	191.0321	190.4644	510: Res-Single Family	510: Res-Single Family	0
39043-4900090000	39	043	802 CRESCENT HURON 44839	HURON	OH	44839	400 DUN RD	CHILLICOTHE	OH	45601	Erie	37030	Huron	040400	404	736.0900	1	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		177.9035	178.7219	178.1926	510: Res-Single Family	510: Res-Single Family	0
39043-4300081000	39	043	209 ATWOOD HURON 44839	HURON	OH	44839	209 ATWOOD PL HURON	HURON	OH	44839	Erie	37030	Huron	040500	405	601.5645	1	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		179.3149	179.9684	179.6922	510: Res-Single Family	510: Res-Single Family	0
39043-3100430000	39	043	141 MAIN CASTALIA 44824	CASTALIA	OH	44824	141 MAIN ST	CASTALIA	OH	44824	Erie	47572	Margaretta	041701	417.0100	566.3352	1	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		192.0707	192.7697	192.5219	510: Res-Single Family	510: Res-Single Family	0
39043-5701615000	39	043	447 PARKER DR SANDUSKY 44870	SANDUSKY	OH	44870	3317 RODS DR	SANDUSKY	OH	44870	Erie	70380	Sandusky	040700	407	69.8833	0	39043C	2025-12-11	AE	COASTAL FLOODPLAIN	576	174.4373	175.2276	174.7148	599: Res-Other	599: Res-Other	0
39043-5601199000	39	043	326 MADISON ST SANDUSKY 44870	SANDUSKY	OH	44870	326 E MADISON ST	SANDUSKY	OH	44870	Erie	70380	Sandusky	040801	408.0100	247.7439	1	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		182.9434	183.1510	183.0711	510: Res-Single Family	510: Res-Single Family	0
39043-3901076019	39	043	708 MARINERS HURON 44839	HURON	OH	44839	708 MARINER VLG	HURON	OH	44839-1034	Erie	37030	Huron	041900	419	2340.8772	1	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		174.9126	177.3250	176.7325	550: Res-Condo	550: Res-Condo	0
39043-3901026013	39	043	532 MARINER HURON 44839	HURON	OH	44839	532 MARINER HURON	HURON	OH	44839	Erie	37030	Huron	041900	419	2443.4026	1	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		174.7231	177.5265	176.1325	550: Res-Condo	550: Res-Condo	0
39043-2900222000	39	043	7509 SKADDEN SANDUSKY 44870	SANDUSKY	OH	44870	1701 SHERMAN AVE UNIT 2	CINCINNATI	OH	45212	Erie	32578	Groton	041800	418	11535.5466	2	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		218.7606	221.9168	220.2628	510: Res-Single Family	510: Res-Single Family	3.2800
39043-1200333003	39	043	12002 LAKE VERMILION 44089	VERMILION	OH	44089	12002 W LAKE RD	VERMILION	OH	44089	Erie	79730	Vermilion	040200	402	3955.7714	1	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		181.6248	183.5313	182.2316	510: Res-Single Family	510: Res-Single Family	1.0400
39043-3202753033	39	043	1412 JULIANNE SANDUSKY 44870	SANDUSKY	OH	44870	1412 JULIANNE CIRCLE	SANDUSKY	OH	44870	Erie	61714	Perkins	041900	419	6628.3804	1	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		183.0295	186.1953	184.2463	550: Res-Condo	550: Res-Condo	0
39043-3000316000	39	043	COMANCHE SANDUSKY 44870	SANDUSKY	OH	44870	2131 COMANCHE TR	SANDUSKY	OH	44870	Erie	47572	Margaretta	041702	417.0200	374.8988	1	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		176.1900	176.4985	176.3291	500: Res-Vacant Land	500: Res-Vacant Land	0
39043-5705367000	39	043	1313 PARISH SANDUSKY 44870	SANDUSKY	OH	44870	1313 E PARISH ST	SANDUSKY	OH	44870	Erie	70380	Sandusky	041200	412	996.7920	3	39043C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD		180.1563	180.7165	180.3478	510: Res-Single Family	510: Res-Single Family	0.2500