Saved query c77fc28212a10a4a

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

40,345 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	elevmin	elevmax	elevavg	usedesc	taxacres	naicscode	parceltype	accesstype	placename	placetype
39077-33001N010140000	39	077	S OLD STATE RD NORWALK 44857		OH	44857	WHITTLESEY AVE	NORWALK	OH	44857	Huron	57302	Norwalk	915600	9156	162383.0031	2	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	239.8405	247.2934	241.7747	640: Exm-Municipality	40.4000	71391	GOVT LOCAL	OPEN	BLUE HERON DISC GOLF COURSE	SPORT_FIELD
39077-330140020320000	39	077	269 W MAIN ST NORWALK 44857	NORWALK	OH	44857	NULL NULL	NULL	NUL	NULL	Huron	57302	Norwalk	915700	9157	15409.4480	2	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	205.4514	222.5718	214.9704	447: Com-Office	3.3800	722515			FIT SNACK SHOP	FOOD_AND_BEVERAGE_STORE
39077-140020010130100	39	077	237 ST RT 61 S MONROEVILLE 44847	MONROEVILLE	OH	44847	NULL NULL	NULL	NUL	NULL	Huron	32102	Greenfield	916100	9161	10677.8970	5	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	258.5075	262.1625	260.7618	511: Res-Custom Code	2.8800	111			ZIDAR FARMS	FARM
39077-030030030170000	39	077	2465 N RIDGE RD NORWALK 44857	NORWALK	OH	44857	NULL NULL	NULL	NUL	NULL	Huron	09148	Bronson	916500	9165	8172.6517	1	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	223.1504	237.2682	232.2065	511: Res-Custom Code	2.4000	31213			WAGNER WINERY	WINERY
39077-480040010410100	39	077	2205 US HWY 20 E COLLINS 44826	COLLINS	OH	44826	ERIE HURON COUNTY RURAL WATER A…	COLLINS	OH	44826	Huron	77158	Townsend	915400	9154	4166.5411	1	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	267.0931	268.9144	268.1028	630: Exm-Township	1	22131			NORTHERN OHIO RURAL WATER	WATER_UTILITY_PROVIDER
39077-510360010320000	39	077	US HWY 224 WILLARD 44890		OH	44890	NULL NULL	NULL	NUL	NULL	Huron	85232	Willard	916300	9163	910.4916	0	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	289.9783	290.7930	290.4632	400: Com-Vacant Land	0	45811			FARMHOUSE CREATIONS	FASHION_AND_APPAREL_STORE
39077-410040010100100	39	077	2723 PERU CENTER RD N MONROEVIL…	NORTH MONROEVILLE	OH	44847	NULL NULL	NULL	NUL	NULL	Huron	67006	Ridgefield	915900	9159	11343.7649	2	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	216.2642	227.1295	224.0149	511: Res-Custom Code	2.9400
39077-300010020260000	39	077	397 ST RT 18 NORWALK 44857	NORWALK	OH	44857	NULL NULL	NULL	NUL	NULL	Huron	57316	Norwalk	915600	9156	59414.5728	4	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	241.8401	248.4573	245.5617	111: Agr-CAUV-Cash-Grain Farm	14.3000
39077-330350070200000	39	077	213 E MAIN ST NORWALK 44857	NORWALK	OH	44857	NULL NULL	NULL	NUL	NULL	Huron	57302	Norwalk	915500	9155	1007.3024	1	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	219.0204	221.4898	220.1537	510: Res-Single Family	0
39077-250020010850000	39	077	5525 COOK RD NEW LONDON 44851	NEW LONDON	OH	44851	NULL NULL	NULL	NUL	NULL	Huron	54922	New London	916600	9166	101377.6095	3	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	285.3580	289.5106	286.8685	111: Agr-CAUV-Cash-Grain Farm	25.2300
39077-140010010580500	39	077	2335 MILL RD MONROEVILLE 44847	WILLARD	OH	44890	NULL NULL	NULL	NUL	NULL	Huron	32102	Greenfield	916100	9161	12512.7737	1	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	252.7830	266.6490	259.2970	560: Res-Mobile Home	3.2300
39077-330240020080000	39	077	68 S LINWOOD AVE NORWALK 44857	NORWALK	OH	44857	NULL NULL	NULL	NUL	NULL	Huron	57302	Norwalk	915600	9156	766.2184	2	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	222.5411	223.3396	222.9904	510: Res-Single Family	0
39077-16043B010570200	39	077	18 NEW ST GREENWICH 44837	GREENWICH	OH	44837	NULL NULL	NULL	NUL	NULL	Huron	32368	Greenwich	916400	9164	1670.7040	0	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	319.0556	320.4101	319.5630	640: Exm-Municipality	0
39077-490040020250000	39	077	4617 US HWY 20 E WAKEMAN 44889	WAKEMAN	OH	44889	NULL NULL	NULL	NUL	NULL	Huron	80472	Wakeman	915400	9154	6176.7080	4	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	269.9159	270.7011	270.2040	455: Com-Garage	2
39077-26019B050510000	39	077	63 N MAPLE ST NEW LONDON 44851	NEW LONDON	OH	44851	NULL NULL	NULL	NUL	NULL	Huron	54922	New London	916600	9166	560.0237	1	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	298.9158	299.4584	299.1643	560: Res-Mobile Home	0
39077-33009B020040000	39	077	160 E MAIN ST NORWALK 44857	NORWALK	OH	44857	NULL NULL	NULL	NUL	NULL	Huron	57302	Norwalk	915600	9156	1055.5413	2	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	221.5630	223.5036	222.2908	510: Res-Single Family	0
39077-310010040320300	39	077	830 SOUTH NORWALK RD E NORWALK …	EAST NORWALK	OH	44857	830 SOUTH NORWALK RD	NORWALK	OH	44857	Huron	57316	Norwalk	916500	9165	30845.9737	1	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	264.3649	266.7996	265.2347	511: Res-Custom Code	8.1300
39077-490020040170000	39	077	4220 HANFORD RD WAKEMAN 44889	WAKEMAN	OH	44889	NULL NULL	NULL	NUL	NULL	Huron	80472	Wakeman	915400	9154	1514.2677	1	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	262.6560	263.8383	263.2631	511: Res-Custom Code	0.4300
39077-330180010080000	39	077	43 W WASHINGTON ST NORWALK 44857	NORWALK	OH	44857	NULL NULL	NULL	NUL	NULL	Huron	57302	Norwalk	915800	9158	1017.5091	1	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	214.4141	215.3612	214.7702	510: Res-Single Family	0
39077-370010010660000	39	077	386 PERU CENTER RD N MONROEVILL…	WILLARD	OH	44890	PERU CENTER RD	MONROEVILLE	OH	44847	Huron	62246	Peru	915900	9159	242511.2811	2	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	239.8167	254.1295	248.2215	111: Agr-CAUV-Cash-Grain Farm	60.5000
39077-480010020090300	39	077	3380 CRANDALL RD COLLINS 44826	COLLINS	OH	44826	NULL NULL	NULL	NUL	NULL	Huron	77158	Townsend	915400	9154	5305.9184	1	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	280.1320	281.8800	280.9294	511: Res-Custom Code	1.4600
39077-510290020630000	39	077	120 HAYES ST WILLARD 44890	WILLARD	OH	44890	NULL NULL	NULL	NUL	NULL	Huron	85232	Willard	916200	9162	641.2153	1	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	276.5362	277.9176	277.3579	510: Res-Single Family	0
39077-120030010550200	39	077	PROSPECT RD NEW LONDON 44851	NEW LONDON	OH	44851	NULL NULL	NULL	NUL	NULL	Huron	27216	Fitchville	916500	9165	2575.5979	0	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	295.6051	297.0679	296.2707	501: Res-Custom Code	0.6800
39077-050020020040200	39	077	1090 ZENOBIA RD NORWALK 44857	NORWALK	OH	44857	NULL NULL	NULL	NUL	NULL	Huron	09148	Bronson	916500	9165	11523.8056	1	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	275.8838	277.1063	276.4075	501: Res-Custom Code	3.1100
39077-140040010390000	39	077	3971 EGYPT RD WILLARD 44890	WILLARD	OH	44890	NULL NULL	NULL	NUL	NULL	Huron	32102	Greenfield	916200	9162	8871.6654	1	39077C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	254.6643	266.2003	256.8112	511: Res-Custom Code	2.3500