Saved query f174887d168ea948

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

40,650 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
87-12-34-209-002 000-019	18	173	8077 Rose Hill Dr	Newburgh	IN	47630	Warrick	56178	Ohio	030703	307.0299	1909.0760	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	133.6613	134.9830	134.5560	442	6214	ASCENSION MEDICAL GROUP ST VINC…	PRIMARY_CARE_OR_GENERAL_CLINIC	87019
87-08-36-100-404 000-020	18	173	Inderrieden Rd	Chandler	IN	47610	Warrick	56178	Ohio	030300	303	17348.4837	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	119.2255	123.1283	120.1818	610	6216	BIEBER SERVICES	HOME_SERVICE	87020
87-13-35-100-043 000-001	18	173	5344 S Yankeetown Rd	Boonville	IN	47601	Warrick	01540	Anderson	030502	305.0200	24800.0254	2	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	128.6098	154.1180	139.6580	541	6216	L & M EXCAVATING	HOME_SERVICE	87001
87-15-03-100-002 000-014	18	173	Main St	Newburgh	IN	47630	Warrick	56178	Ohio	030801	308.0100	2643.3806		18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	114.8215	121.1125	119.5033	426	722410	CRICKET'S	BAR	87014
87-15-03-109-016 000-014	18	173	217 Monroe St	Newburgh	IN	47630	Warrick	56178	Ohio	030801	308.0100	746.4086	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	122.2950	123.7227	122.8966	510				87014
87-12-22-201-021 000-019	18	173	3166 Logan Dr	Newburgh	IN	47630	Warrick	56178	Ohio	030707	307.0700	1115.0390	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	130.0195	132.2601	131.7171	510				87019
87-15-02-209-110 000-019	18	173	6155 Pfafflin Lake B	Newburgh	IN	47630	Warrick	56178	Ohio	030801	308.0100	7063.0778	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	119.5171	135.8214	131.2067	510				87019
87-12-28-102-058 000-019	18	173	4211 Hedgewood Ct	Newburgh	IN	47630	Warrick	56178	Ohio	030709	307.0899	1104.4997	1	18173C	2025-12-14	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	119.4372	120.5911	120.2744	510				87019
87-12-25-305-006 000-019	18	173	4999 Jamestown Dr	Newburgh	IN	47630	Warrick	56178	Ohio	030704	307.0400	976.4532	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	129.8958	135.8788	132.4480	510				87019
87-09-35-102-417 000-003	18	173	829 S Third St	Boonville	IN	47601	Warrick	06472	Boon	030601	306.0100	945.4945	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	120.9645	121.6349	121.2404	510				87003
87-12-27-404-027 000-019	18	173	4922 Bell Rd	Newburgh	IN	47630	Warrick	56178	Ohio	030709	307.0899	1930.1366	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	139.7062	145.8951	143.4225	599				87019
87-12-33-304-009 000-019	18	173	5711 Byerson Dr	Newburgh	IN	47630	Warrick	56178	Ohio	030709	307.0899	1883.9761	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	119.9678	121.1712	120.6277	510				87019
87-04-13-301-004 000-007	18	173	6800 Stanley Rd	Elberfeld	IN	47613	Warrick	29970	Greer	030200	302	36390.0519	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	133.4874	141.9434	137.8787	511				87007
87-12-29-304-142 000-019	18	173	10570 Merimac Dr	Newburgh	IN	47630	Warrick	56178	Ohio	030708	307.0800	693.9827	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	121.9563	123.0928	122.6913	510				87019
87-12-29-407-045 000-019	18	173	10455 Tecumseh Dr	Newburgh	IN	47630	Warrick	56178	Ohio	030708	307.0800	1683.3598	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	121.0319	122.2484	121.8966	510				87019
87-13-30-302-023 000-019	18	173	6440 Bryanna Ct	Newburgh	IN	47630	Warrick	56178	Ohio	030704	307.0400	1060.4923	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	116.6846	117.7059	117.3460	510				87019
87-13-26-202-002 000-002	18	173	1031 Turtle Bay Rd	Boonville	IN	47601	Warrick	06472	Boon	030502	305.0200	32085.7841	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	132.6949	143.9291	139.6621	599				87002
87-12-27-104-037 000-019	18	173	4077 Secretariat Dr	Newburgh	IN	47630	Warrick	56178	Ohio	030709	307.0899	1128.8576	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	119.5816	120.0222	119.8338	510				87019
87-09-23-400-056 000-002	18	173	Eby Rd	Boonville	IN	47601	Warrick	06472	Boon	030602	306.0200	16003.7780	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	133.3423	141.8250	137.5871	501				87002
87-12-23-105-086 000-019	18	173	3299 Pine Ridge Dr	Newburgh	IN	47630	Warrick	56178	Ohio	030707	307.0700	1642.7234	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	130.8094	132.5898	131.9406	510				87019
87-04-12-200-027 000-007	18	173	6311 St Rd 68	Lynnville	IN	47619	Warrick	29970	Greer	030200	302	9840.7177	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	126.2542	128.0293	126.8787	511				87007
87-04-05-302-001 000-007	18	173	10888 State Rd 68	Elberfeld	IN	47613	Warrick	29970	Greer	030200	302	10059.8454	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	132.5691	136.2029	134.1986	541				87007
87-16-01-201-001 000-001	18	173	6004 Boner Rd	Boonville	IN	47601	Warrick	01540	Anderson	030501	305.0100	103710.6638	2	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	111.9161	139.6589	116.3173	503				87001
87-09-35-102-303 000-003	18	173	811 S Second St	Boonville	IN	47601	Warrick	06472	Boon	030601	306.0100	645.6806	1	18173C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	120.3304	120.8086	120.5770	510				87003
87-12-28-102-054 000-019	18	173	4133 Hedgewood Ct	Newburgh	IN	47630	Warrick	56178	Ohio	030709	307.0899	861.5746	1	18173C	2025-12-14	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	119.1542	119.8304	119.5615	510				87019