Saved query 1d0413979989f3e3

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

87,974 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	naicscode	placename	placetype	taxdistrict
20-11-09-158-013 000-015	18	039	603 W PIKE ST	GOSHEN	IN	46526	Elkhart	20746	Elkhart	000502	5.0199	830.2144	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	238.2231	239.8054	238.5679	420	B-3	458	CASPER'S COIN AND JEWELRY	FASHION_AND_APPAREL_STORE	20015
20-15-16-227-008 000-018	18	039	19084 MEADOWFLOWER DR	NEW PARIS	IN	46553	Elkhart	36972	Jackson	001000	10	1051.2353	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	248.5305	249.2564	249.0002	510		444	SEAL TECH SOLUTIONS	HARDWARE_HOME_AND_GARDEN_STORE	20018
20-11-10-178-011 000-015	18	039	416 STEURY AVENUE	GOSHEN	IN	46528	Elkhart	20746	Elkhart	000202	2.0200	7811.9215	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	243.9452	250.8945	247.4720	350		54	LM CORP.	PROFESSIONAL_SERVICE	20015
20-11-21-234-008 000-015	18	039	200 HIGH PARK AVE	GOSHEN	IN	46526	Elkhart	20746	Elkhart	000400	4	45115.3196	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	243.0035	245.6162	243.8752	680		6223	GOSHEN CENTER FOR CANCER CARE	SPECIALIZED_HEALTH_CARE	20015
20-06-07-279-027 000-012	18	039	1512 W INDIANA	ELKHART	IN	46516	Elkhart	14842	Concord	002300	23	562.2235	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	225.4725	226.0786	225.7077	510	R-3				20012
20-06-07-180-022 000-012	18	039	AVALON	ELKHART	IN	46516	Elkhart	14842	Concord	002300	23	308.6209	0	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	224.1567	224.6001	224.3198	500	R-2				20012
20-06-03-176-001 000-012	18	039	148 PARKER	ELKHART	IN	46516	Elkhart	14842	Concord	002900	29	1019.7948	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	229.4169	230.0271	229.7861	510	R-2				20012
20-11-06-402-012 000-015	18	039	1012 WILLIAM DR	GOSHEN	IN	46526	Elkhart	20746	Elkhart	000501	5.0100	965.9695	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	240.8749	241.3361	241.0967	510	R-1				20015
20-06-07-401-010 000-012	18	039	W INDIANA	ELKHART	IN	46516	Elkhart	14842	Concord	002300	23	484.3091	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	224.6666	225.5143	225.1168	599	R-5				20012
20-06-08-427-010 000-012	18	039	207 W GARFIELD	ELKHART	IN	46516	Elkhart	14842	Concord	002600	26	973.3719	2	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	228.7991	229.3325	229.0365	530	R-2				20012
20-06-08-430-019 000-012	18	039	1617 PRAIRIE	ELKHART	IN	46516	Elkhart	14842	Concord	002600	26	523.3729	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	229.4346	229.7444	229.5862	510	R-2				20012
20-06-04-353-013 000-012	18	039	617 MADISON	ELKHART	IN	46516	Elkhart	14842	Concord	002900	29	357.0936	0	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	229.2052	229.6108	229.3853	500	R-2				20012
20-11-11-176-016 000-015	18	039	S 29TH ST	GOSHEN	IN	46528	Elkhart	20746	Elkhart	000202	2.0200	659.4694	0	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	262.9674	264.3670	263.7976	509	R-2				20015
20-02-32-353-008 000-027	18	039	503 W SIMONTON STREET	ELKHART	IN	46514	Elkhart	57150	Osolo	001601	16.0100	445.0856	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	229.0382	229.5452	229.3289	510	R-2				20027
20-06-12-203-003 000-011	18	039	4811 EASTLAND	ELKHART	IN	46516	Elkhart	14842	Concord	001902	19.0200	8597.0405	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	230.2778	233.4187	231.7248	350	PUD				20011
20-06-16-134-019 000-012	18	039	2323 MATHER AVE	ELKHART	IN	46517	Elkhart	14842	Concord	002102	21.0200	530.9069	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	232.3097	232.6154	232.4646	510	R-2				20012
20-06-10-103-030 000-012	18	039	DENVER	ELKHART	IN	46516	Elkhart	14842	Concord	001901	19.0100	832.6961	0	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	229.0565	229.6681	229.2266	509	R-2				20012
20-06-04-282-005 000-012	18	039	1717 SUPERIOR	ELKHART	IN	46516	Elkhart	14842	Concord	002900	29	496.9733	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	229.3933	229.7580	229.5350	510	R-2				20012
20-11-10-357-009 000-015	18	039	415 S TENTH ST	GOSHEN	IN	46526	Elkhart	20746	Elkhart	000302	3.0200	644.3115	0	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	243.9953	244.4627	244.1427	650	R-1				20015
20-02-27-476-001 000-027	18	039	1843 CRABTREE LANE	ELKHART	IN	46514	Elkhart	57150	Osolo	001801	18.0100	2075.0015	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	233.3344	234.8620	233.8526	510	R-1				20027
20-06-08-402-007 000-012	18	039	529 W GARFIELD	ELKHART	IN	46516	Elkhart	14842	Concord	002600	26	754.4362	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	230.1679	230.7456	230.5401	510	R-2				20012
20-11-04-479-005 000-015	18	039	906 N 7TH	GOSHEN	IN	46528	Elkhart	20746	Elkhart	000202	2.0200	1514.4989	2	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	251.3556	252.3719	251.7929	510	R-1				20015
20-06-16-433-043 000-012	18	039	2945 KELSEY	ELKHART	IN	46517	Elkhart	14842	Concord	002102	21.0200	548.7224	2	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	232.1608	233.0209	232.7358	510	R-2				20012
20-11-23-427-002 000-015	18	039	2109 LINCOLNWAY EAST	GOSHEN	IN	46526	Elkhart	20746	Elkhart	000302	3.0200	64120.9615	1	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	244.7107	251.6902	247.9203	350	M-1				20015
20-05-12-226-018 000-006	18	039	GRUBER LN	ELKHART	IN	46514	Elkhart	13528	Cleveland	001501	15.0100	754.6488	0	18039C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	223.8093	225.3163	224.2579	640	R-1				20006