Saved query 18974b30e115c116

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

31,438 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	placename	placetype	taxdistrict
17-10-18-100-006 000-009	18	033	2417 COUNTY ROAD 56	AUBURN	IN	46706	DeKalb	36936	Jackson	020700	207	4875.8348	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	253.3259	257.7696	256.2826	510	R1	R1				17009
17-05-14-200-007 000-016	18	033	3346 COUNTY ROAD 19	AUBURN	IN	46706	DeKalb	64008	Richland	020200	202	8093.0949	3	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	278.9518	283.7547	280.8904	511	A1	A1				17016
17-12-21-100-003 000-015	18	033	6256 COUNTY ROAD 81	SAINT JOE	IN	46785	DeKalb	53784	Newville	020800	208	59172.0459	2	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	250.4877	257.2365	253.8181	101	A1	A1				17015
17-09-22-400-011 000-001	18	033	COUNTY ROAD 11A	GARRETT	IN	46738	DeKalb	09550	Butler	020700	207	1677.4929	0	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	260.0763	261.3441	260.6724	501	A2	A2				17001
17-01-02-100-002 000-004	18	033	1652 STATE ROAD 4	ASHLEY	IN	46705	DeKalb	22288	Fairfield	020100	201	8093.8724	3	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	295.8803	298.7573	297.7389	511	A2	A2				17004
17-09-09-300-005 000-011	18	033	5593 COUNTY ROAD 7	GARRETT	IN	46738	DeKalb	39636	Keyser	020601	206.0100	23903.5253	3	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	263.3851	267.3906	266.2298	101	A1	A1				17011
17-07-12-176-004 000-027	18	033	601 RE Jones Rd	Butler	IN	46721	DeKalb	84590	Wilmington	020300	203	59195.2758	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	263.8188	267.0401	266.0254	330			3334	THERMA-TRU	MANUFACTURER	17027
17-03-30-200-004 000-005	18	033	COUNTY ROAD 16	WATERLOO	IN	46793	DeKalb	25342	Franklin	020100	201	1434.4187	0	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	272.8207	275.4785	274.5503	501	A1	A1				17005
17-09-32-200-006 000-001	18	033	COUNTY ROAD 70	LAOTTO	IN	46763	DeKalb	09550	Butler	020700	207	35.6370	0	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	262.0889	262.2591	262.1632	100	A1	A1				17001
17-07-11-127-007 000-027	18	033	402 W MAIN ST	BUTLER	IN	46721	DeKalb	84590	Wilmington	020300	203	529.5638	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	267.5379	267.8582	267.6450	510						17027
17-06-32-352-013 000-025	18	033	326 LINCOLN ST	AUBURN	IN	46706	DeKalb	77228	Union	020500	205	426.6736	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	265.4435	265.7229	265.5823	499						17025
17-06-35-300-013 000-024	18	033	4850 County Road 41	Auburn	IN	46706	DeKalb	77228	Union	020400	204	134363.4836	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	264.6849	269.9555	267.4967	101						17024
17-06-31-429-007 000-025	18	033	711 S Indiana Ave	Auburn	IN	46706	DeKalb	77228	Union	020500	205	751.1432	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	264.1396	264.8217	264.4365	510						17025
17-04-33-100-010 000-023	18	033	2060 County Road 81	Butler	IN	46721	DeKalb	76598	Troy	020100	201	2846.7411	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	262.7621	265.3123	264.0605	541						17023
17-04-17-200-004 000-023	18	033	7966 County Road 8	Butler	IN	46721	DeKalb	76598	Troy	020100	201	162606.8457	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	265.8831	269.6020	267.9287	101						17023
17-06-10-126-054 000-008	18	033	365 Depot Xing	Waterloo	IN	46793	DeKalb	28836	Grant	020200	202	972.8421	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	271.5033	272.7267	272.2432	510						17008
17-06-31-433-012 000-025	18	033	807 S Indiana Ave	Auburn	IN	46706	DeKalb	77228	Union	020500	205	803.9951	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	263.3673	263.7762	263.5604	510						17025
17-07-02-489-006 000-027	18	033	James St	Butler	IN	46721	DeKalb	84590	Wilmington	020300	203	405.5111	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	262.7312	262.9676	262.8444	599						17027
17-06-28-355-005 000-025	18	033	100 Eckhart Ave	Auburn	IN	46706	DeKalb	77228	Union	020400	204	723.8103	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	265.8724	266.7223	266.3482	510						17025
17-06-29-404-007 000-025	18	033	400 Duryea Dr	Auburn	IN	46706	DeKalb	77228	Union	020400	204	3050.5025	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	259.0576	263.3272	261.8793	510						17025
17-06-03-305-002 000-008	18	033	165 W Union St	Waterloo	IN	46793	DeKalb	28836	Grant	020200	202	728.3032	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	273.8196	274.7460	274.2966	510						17008
17-05-10-300-002 000-016	18	033	3211 County Road 11	Corunna	IN	46730	DeKalb	64008	Richland	020200	202	12134.8715	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	277.5957	288.0722	283.3977	511						17016
17-07-32-200-001 000-026	18	033	5434 County Road 44	Auburn	IN	46706	DeKalb	84590	Wilmington	020300	203	4045.0311	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	257.7876	259.4927	258.4067	541						17026
17-09-04-401-057 000-013	18	033	909 Redwood Ct	Garrett	IN	46738	DeKalb	39636	Keyser	020601	206.0100	1368.1698	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	266.4688	268.1141	267.3635	510						17013
17-12-06-304-006 000-015	18	033	105 E College St	Butler	IN	46721	DeKalb	53784	Newville	020800	208	809.6490	1	18033C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	250.1052	251.2141	250.7191	540						17015