Saved query 88182f19c4c071f1

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 = '18' 
  AND countyfp = '057'

149,802 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	zoningcode	zoningdesc	naicscode	parceltype	accesstype	placename	placetype	taxdistrict
29-16-06-000-013 002-007	18	057	0 Florida Rd	Fortville	IN	46040	Hamilton	22612	Fall Creek	110813	1108.1300	52843.5067	0	18057C	2025-12-14	AE	FLOODWAY	239.0447	244.5253	239.7303	620	FH		7212	GOVT LOCAL	OPEN	GEIST PARK	LOCAL PARK	29007
29-09-28-007-002 007-018	18	057	12702 Meeting House Rd	Carmel	IN	46032	Hamilton	13060	Clay	111009	1110.0900	857.4919	1	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	272.7344	273.8229	273.5096	430	PUD	PLANNED UNIT DEVELOPMENT	312120			DANNY BOY BEER WORKS	BREWERY	29018
29-13-11-209-005 000-018	18	057	10204 N College Ave	Carmel	IN	46280	Hamilton	13060	Clay	111104	1111.0400	1254.2479	2	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	255.2118	256.3272	255.8042	510	R-1	LOW TO MEDIUM DENSITY SINGLE FA…						29018
29-10-32-102-001 000-018	18	057	3645 E 126th St	Carmel	IN	46033	Hamilton	13060	Clay	111003	1110.0300	1497.0082	2	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	245.4840	248.1621	247.0236	510	R-1	LOW TO MEDIUM DENSITY SINGLE FA…						29018
29-06-32-004-014 000-015	18	057	17730 Gasparilla Ct	Westfield	IN	46062	Hamilton	82714	Westfield Washington	110516	1105.1600	794.4422	1	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	264.6242	265.9726	265.5060	510	SF-4	Single Family - 4						29015
29-10-26-004-027 000-018	18	057	13045 Abraham Run	Carmel	IN	46033	Hamilton	13060	Clay	110911	1109.1099	1115.0416	1	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	227.1758	229.9414	228.8186	510	S-1	SINGLE FAMILY RESIDENTIAL LARGE…						29018
29-10-17-010-058 000-015	18	057	3800 E 151st St	Carmel	IN	46033	Hamilton	82714	Westfield Washington	110515	1105.1500	7439.4467	0	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	253.7160	257.1434	254.3205	500	PUD	Planned Unit Development						29015
29-10-26-007-003 000-018	18	057	6875 Longest Dr	Carmel	IN	46033	Hamilton	13060	Clay	110911	1109.1099	2161.6035	1	18057C	2025-12-14	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	228.5885	230.1423	229.4568	510	S-1	SINGLE FAMILY RESIDENTIAL LARGE…						29018
29-04-08-000-009 000-017	18	057	16670 E 276th St	Atlanta	IN	46031	Hamilton	83906	White River	110102	1101.0200	19832.9055	3	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	252.9906	256.4506	254.2626	511	A-2	General Agriculture						29017
29-09-03-025-002 000-015	18	057	1283 Clairet Dr	Westfield	IN	46074	Hamilton	82714	Westfield Washington	110301	1103.0100	845.4624	1	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	280.1343	281.4592	281.0791	510	PUD	Planned Unit Development						29015
29-06-31-310-001 000-015	18	057	423 N East St	Westfield	IN	46074	Hamilton	82714	Westfield Washington	110401	1104.0100	1246.0692	2	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	270.2268	271.6589	271.1281	510	SF-3	Single Family - 3						29015
29-09-25-403-001 000-018	18	057	401 Emerson Rd	Carmel	IN	46032	Hamilton	13060	Clay	111011	1110.1099	1441.4964	2	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	254.9661	256.0063	255.6650	510	R-2	LOW TO MEDIUM DENSITY SINGLE FA…						29018
29-13-07-005-008 000-018	18	057	3871 Carwinion Way	Carmel	IN	46032	Hamilton	13060	Clay	111103	1111.0300	1413.3013	1	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	268.8212	271.9021	271.1666	510	S-2	LOW-DENSITY SINGLE FAMILY RESID…						29018
29-09-33-014-010 000-018	18	057	2345 Finchley Rd	Carmel	IN	46032	Hamilton	13060	Clay	111009	1110.0900	2513.6525	2	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	272.7219	273.7168	273.3264	510	PUD	PLANNED UNIT DEVELOPMENT						29018
29-09-11-000-003 000-025	18	057	220 E 161st St	Westfield	IN	46074	Hamilton	82714	Westfield Washington	110406	1104.0600	38782.6153	2	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	274.5322	278.3281	276.4261	101	AG-SF1	Agriculture - Single Family 1						29025
29-09-34-009-023 000-018	18	057	491 Dylan Dr	Carmel	IN	46032	Hamilton	13060	Clay	111009	1110.0900	1116.0575	1	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	261.3896	262.2137	261.9458	510	PUD	PLANNED UNIT DEVELOPMENT						29018
29-07-16-401-001 000-012	18	057	377 Hall Ct	Noblesville	IN	46060	Hamilton	54198	Noblesville	110505	1105.0500	12117.1467	2	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	232.1050	244.4298	237.8892	510	R-1	Low Density Residential						29012
29-06-32-033-016 000-015	18	057	4722 Peabody Way	Westfield	IN	46062	Hamilton	82714	Westfield Washington	110516	1105.1600	1404.3567	1	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	261.8075	263.7120	262.2734	510	PUD	Planned Unit Development						29015
29-01-30-000-015 000-001	18	057	0 Jerkwater Rd	Sheridan	IN	46069	Hamilton	69354	Sheridan	110303	1103.0300	40101.3985	0	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	287.6522	292.1807	289.1179	100	AG2	AG2 Agricultural Business						29001
29-14-07-112-049 000-018	18	057	2055 Fahey Dr	Carmel	IN	46280	Hamilton	13060	Clay	111104	1111.0400	758.6683	1	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	245.6215	248.2918	247.8164	510	R-1	LOW TO MEDIUM DENSITY SINGLE FA…						29018
29-04-29-000-021 000-017	18	057	0 Henry Gunn Rd	Noblesville	IN	46060	Hamilton	83906	White River	110102	1101.0200	75031.2349	0	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	244.4065	253.8142	250.6657	100	A-2	General Agriculture						29017
29-09-28-000-001 001-018	18	057	13513 Towne Rd	Carmel	IN	46032	Hamilton	13060	Clay	110909	1109.0900	19155.6616	1	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	274.8446	277.7797	276.1421	511	S-1	SINGLE FAMILY RESIDENTIAL LARGE…						29018
29-03-05-000-005 003-017	18	057	10475 E 296th St	Atlanta	IN	46031	Hamilton	83906	White River	110102	1101.0200	23519.2641	0	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	259.8016	262.6155	261.0616	101	A-2	General Agriculture						29017
29-06-32-001-033 000-015	18	057	17826 Grassy Knoll Dr	Westfield	IN	46074	Hamilton	82714	Westfield Washington	110516	1105.1600	726.7887	1	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	264.7385	265.8435	265.4040	510	SF-4	Single Family - 4						29015
29-09-25-401-008 000-018	18	057	136 York Dr	Carmel	IN	46032	Hamilton	13060	Clay	111011	1110.1099	1137.9128	1	18057C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	256.3941	257.3760	257.0675	510	R-2	LOW TO MEDIUM DENSITY SINGLE FA…						29018