Saved query ccb3a9222ba51ff0

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

18,573 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	placename	placetype	taxdistrict
69-02-20-332-101 000-017	18	137	137 MAIN ST	BATESVILLE	IN	47006	Ripley	42336	Laughery	968500	9685	1393.3156	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	297.4313	298.0364	297.7530	444	52213	PNC BANK	BANK_OR_CREDIT_UNION	69017
69-08-19-223-012 000-010	18	137	525 NORTH MAIN ST	MILAN	IN	47031	Ripley	25612	Franklin	968900	9689	618.8418	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	300.9445	302.3246	301.9058	510	52213	UNITED COMMUNITY BANK	BANK_OR_CREDIT_UNION	69010
69-07-05-100-013 000-001	18	137	8743 EAST CO RD 1250 NORTH	SUNMAN	IN	47041	Ripley	00478	Adams	968402	9684.0200	4083.5496	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	302.4784	307.8705	305.8520	540				69001
69-02-20-443-002 000-017	18	137	BOEHRINGER ST	BATESVILLE	IN	47006	Ripley	42336	Laughery	968500	9685	3521.1119	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	288.0557	292.4204	289.5809	401				69017
69-09-01-400-010 001-009	18	137	6753 E CO RD 600 NORTH	MILAN	IN	47031	Ripley	25612	Franklin	968401	9684.0100	23096.8628	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	302.0888	305.0975	303.5339	101				69009
69-14-25-200-005 002-021	18	137	3306 S FARMERS RETREAT RD	DILLSBORO	IN	47018	Ripley	81008	Washington	968900	9689	21361.5919	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	282.1472	288.9889	287.3889	141				69021
69-14-15-400-015 001-021	18	137	1655 SOUTH CO RD 450 EAST	DILLSBORO	IN	47018	Ripley	81008	Washington	968900	9689	20998.1277	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	294.5802	300.1174	298.2550	101				69021
69-02-19-441-015 000-017	18	137	601 WASHINGTON ST	BATESVILLE	IN	47006	Ripley	42336	Laughery	968500	9685	1494.6025	2	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	291.3443	294.8054	293.4142	520				69017
69-17-07-400-015 003-005	18	137	6758 SOUTH CO RD 175 EAST	VERSAILLES	IN	47042	Ripley	08362	Brown	968700	9687	11028.8230	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	292.9625	296.6213	295.6056	510				69005
69-13-11-100-006 000-014	18	137	614 W U.S 50	VERSAILLES	IN	47042	Ripley	38754	Johnson	968800	9688	1878.8956	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	295.0341	295.8953	295.6317	510				69014
69-06-08-100-002 001-015	18	137	11536 N DELAWARE RD	BATESVILLE	IN	47006	Ripley	42336	Laughery	968500	9685	27525.4700	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	292.1742	298.1038	296.5842	101				69015
69-13-13-200-005 064-014	18	137	210-212 SPENCER LN	VERSAILLES	IN	47042	Ripley	38754	Johnson	968800	9688	1580.8990	2	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	298.1587	298.8683	298.5424	419				69014
69-09-28-100-001 001-013	18	137	2690 NORTH STATE RD 129	MILAN	IN	47031	Ripley	38754	Johnson	968800	9688	3841.8181	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	303.2412	304.7214	304.0507	510				69013
69-13-12-221-019 000-014	18	137	219 N ADAMS ST	VERSAILLES	IN	47042	Ripley	38754	Johnson	968800	9688	3721.6577	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	286.7108	292.3771	289.5729	510				69014
69-14-21-100-001 003-013	18	137	2072 S COUNTY ROAD 400 E	DILLSBORO	IN	47018	Ripley	38754	Johnson	968900	9689	42525.2050	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	295.9507	304.9750	301.2941	512				69013
69-02-29-221-063 000-017	18	137	612-614 CENTRAL AVE	BATESVILLE	IN	47006	Ripley	42336	Laughery	968500	9685	859.5885	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	296.0366	296.7231	296.4800	520				69017
69-09-23-100-008 000-009	18	137	3551 NORTH CO RD 600 EAST	MILAN	IN	47031	Ripley	25612	Franklin	968900	9689	16537.9334	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	303.7035	304.8569	304.2287	510				69009
69-12-11-300-010 001-018	18	137	527 S COUNTY ROAD 700 W	HOLTON	IN	47023	Ripley	57276	Otter Creek	968700	9687	251032.0606	2	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	272.3354	279.9044	278.1312	101				69018
69-13-10-400-010 004-013	18	137	CO RD 50 S	VERSAILLES	IN	47042	Ripley	38754	Johnson	968800	9688	62094.4448	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	289.5895	297.2038	295.0984	100				69013
69-02-20-333-106 000-017	18	137	311 SOUTH PARK AVE	BATESVILLE	IN	47006	Ripley	42336	Laughery	968500	9685	947.6804	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	296.9467	297.7531	297.2614	510				69017
69-17-28-800-023 000-005	18	137	9458 S CO RD 375 E	CROSS PLAINS	IN	47017	Ripley	08362	Brown	968900	9689	122524.6439	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	271.1808	287.6266	280.2218	101				69005
69-02-20-331-019 000-017	18	137	321 N PARK AVE	BATESVILLE	IN	47006	Ripley	42336	Laughery	968500	9685	928.2861	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	287.8886	293.8347	290.8940	510				69017
69-08-20-600-015 000-009	18	137	8224 E STATE ROAD 350	MILAN	IN	47031	Ripley	25612	Franklin	968900	9689	12547.3400	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	299.9013	304.5297	302.5638	510				69009
69-17-01-800-009 000-005	18	137	5478 SOUTH FARMERS RETREAT RD	DILLSBORO	IN	47018	Ripley	08362	Brown	968900	9689	229399.5362	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	226.8371	274.7968	261.5183	101				69005
69-06-04-100-003 001-002	18	137	12697 NORTH CO RD 400 EAST	BATESVILLE	IN	47006	Ripley	00478	Adams	968402	9684.0200	20126.1194	1	18137C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	293.7617	299.9377	298.2463	511				69002