Saved query ddd012016de6b489

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

31,811 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	naicscode	parceltype	accesstype	iucnclass	placename	placetype	taxdistrict
59-15-09-300-024 000-013	18	117	E OWL HOLLOW RD	PAOLI	IN	47454	Orange	71090	Southeast	951800	9518	173986.0727	0	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	220.0796	266.7463	251.1589	600	1153	GOVT FEDERAL	RESTRICTED	OTHER	HOOSIER NATIONAL FOREST	NATIONAL FOREST	59013
59-13-20-300-010 601-005	18	117	CO RD 1025 S	BIRDSEYE	IN	47513	Orange	37260	Jackson	951600	9516	325630.9811	1	18117C	2025-12-14	A		164.1351	190.0152	170.4106	600	7212	GOVT FEDERAL	RESTRICTED		PATOKA LAKE	RECREATION MANAGEMENT AREA	59005
59-11-23-400-021 603-011	18	117	CO RD 175 W	PAOLI	IN	47454	Orange	57798	Paoli	951600	9516	157079.8564		18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	206.5561	261.4216	241.7614	600	1153	GOVT FEDERAL	RESTRICTED	OTHER	HOOSIER NATIONAL FOREST	NATIONAL FOREST	59011
59-11-01-201-041 003-012	18	117	600 W MAIN ST	PAOLI	IN	47454	Orange	57798	Paoli	951700	9517	1667.8650	1	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	178.1847	184.1641	181.0344	430	722511				THE SUPERBURGER	RESTAURANT	59012
59-13-13-200-002 000-005	18	117	6538 W CO RD 875 S	FRENCH LICK	IN	47432	Orange	37260	Jackson	951600	9516	164341.6519	2	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	191.4629	232.4595	215.1449	101	721110				LITTLE LOG CABIN IN THE WOODS	HOTEL	59005
00-00-00-000-000 000-000	18	117			IN	47469	Orange	55152	Northwest	951400	9514	316798.0482	0	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	150.2198	221.2165	191.6188		1153	GOVT FEDERAL	RESTRICTED	OTHER	HOOSIER NATIONAL FOREST	NATIONAL FOREST	00000
59-06-36-211-040 000-012	18	117	142 W CHARLES ST	PAOLI	IN	47454	Orange	57798	Paoli	951400	9514	1021.7629	1	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	186.1627	187.9561	186.9936	510	8121				DONNA'S DOWN UNDER	PERSONAL_OR_BEAUTY_SERVICE	59012
59-14-20-400-038 600-004	18	117	CO RD 450 W	ENGLISH	IN	47118	Orange	29556	Greenfield	951600	9516	135330.8251		18117C	2025-12-14	A		164.1351	205.8196	175.2791	600	7212	GOVT FEDERAL	RESTRICTED		PATOKA LAKE	RECREATION MANAGEMENT AREA	59004
59-06-09-200-029 000-008	18	117	4765 N CO RD 350 W	ORLEANS	IN	47452	Orange	56826	Orangeville	951400	9514	4054.5960	2	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	179.4462	185.3118	181.9278	541							59008
59-06-02-300-033 000-009	18	117	1884 W CO RD 500 N	PAOLI	IN	47454	Orange	57042	Orleans	951300	9513	56377.5458	1	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	176.2306	190.5642	184.7043	101							59009
59-14-09-300-028 602-004	18	117	CO RD 350 W	PAOLI	IN	47454	Orange	29556	Greenfield	951600	9516	16099.2243	0	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	165.2801	191.9355	170.5042	600							59004
59-15-12-100-044 001-013	18	117	E CO RD 725 S	HARDINSBURG	IN	47125	Orange	71090	Southeast	951800	9518	1970.1156	0	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	243.3235	244.8342	244.1884	501							59013
59-14-05-103-013 000-004	18	117	WILD IRONWOOD ST	PAOLI	IN	47454	Orange	29556	Greenfield	951600	9516	579.1948	0	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	233.6608	237.8253	235.7312	599							59004
59-02-32-100-014 000-009	18	117	6814 N ST RD 337	ORLEANS	IN	47452	Orange	57042	Orleans	951300	9513	20063.9230	6	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	201.6475	205.1558	203.4197	101							59009
59-05-35-204-024 000-003	18	117	7983 W JAMES F BATEMAN DR	WEST BADEN	IN	47469	Orange	25990	French Lick	951500	9515	1844.3192	1	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	193.0361	206.0533	201.3297	510							59003
59-12-18-200-048 001-001	18	117	CO RD 200 S	FRENCH LICK	IN	47432	Orange	25990	French Lick	951600	9516	20722.8479	0	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	213.4606	234.5325	225.1452	100							59001
59-03-25-403-002 000-010	18	117	W JEFFERSON ST	ORLEANS	IN	47452	Orange	57042	Orleans	951300	9513	1279.7701	0	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	192.6217	196.1627	194.4700	500							59010
59-11-01-300-072 000-012	18	117	624 S GOSPEL ST	PAOLI	IN	47454	Orange	57798	Paoli	951700	9517	1879.3402	1	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	183.6739	190.6305	188.6984	511							ORANGE COUNTY SOLID WASTE MGMT …
59-11-02-400-029 002-011	18	117	605 S THOMPSON LN	PAOLI	IN	47454	Orange	57798	Paoli	951600	9516	2127.3328	1	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	194.4741	199.7659	197.1394	511							59011
59-12-31-200-020 000-005	18	117	CO RD 550 S	FRENCH LICK	IN	47432	Orange	37260	Jackson	951600	9516	147612.2628	0	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	157.8267	201.5997	176.4486	100							59005
59-06-15-110-002 000-011	18	117	3611 N CO RD 200 W	PAOLI	IN	47454	Orange	57798	Paoli	951400	9514	10764.7803	1	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	189.3015	196.6271	192.8568	510							59011
59-05-35-200-013 000-003	18	117	LEFFLER ST	WEST BADEN	IN	47469	Orange	25990	French Lick	951500	9515	2601.0470	0	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	174.2792	181.2294	177.3811	501							59003
59-11-01-300-044 000-012	18	117	1011 S PAOLI UNIONVILLE RD	PAOLI	IN	47454	Orange	57798	Paoli	951600	9516	3829.6258	1	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	187.2001	193.1575	189.4723	511							ORANGE COUNTY SOLID WASTE MGMT …
59-11-21-100-018 600-011	18	117	3511 CO RD 310 W	PAOLI	IN	47454	Orange	57798	Paoli	951600	9516	1358.3064	0	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	264.7901	269.6077	268.4910	640							59011
59-08-05-100-003 000-006	18	117	CO RD 750 E	ORLEANS	IN	47452	Orange	54648	Northeast	951300	9513	217066.7749	1	18117C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	224.4572	238.5643	233.0187	101							59006