Saved query 11fa8be857dc9e13

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

19,542 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
88-34-08-000-002 000-012	18	175	E SIDE N STATE ROAD 135	SALEM	IN	47167	Washington	50508	Monroe	967300	9673	24258.1746		18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	262.4367	272.1270	267.8224	610	1153	GOVT STATE	RESTRICTED	V	JACKSON-WASHINGTON STATE FOREST	STATE CONSERVATION AREA	88012
88-24-18-442-065 000-022	18	175	906 W MULBERRY ST	SALEM	IN	47167	Washington	81116	Washington	967500	9675	993.2487	2	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	245.3831	246.7092	245.9242	447	5239				STEVEN BREWER & COMPANY	FINANCIAL_SERVICE	88022
88-16-07-000-001 000-015	18	175	E & W SIDES FIRE LANE RD	PEKIN	IN	47165	Washington	61002	Polk	967200	9672	1248008.1317		18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD				610	1153	GOVT STATE	RESTRICTED	OTHER	CLARK STATE FOREST	STATE RESOURCE MANAGEMENT AREA	88015
88-25-18-000-011 001-004	18	175	89 N HOWELL RD	SALEM	IN	47167	Washington	25630	Franklin	967200	9672	5129.0770	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	284.6767	292.4513	288.3056	510							88004
88-24-12-332-014 000-021	18	175	4387 E CANTON RD	SALEM	IN	47167	Washington	81116	Washington	967600	9676	3986.0920	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	264.3837	266.0079	265.4180	510							88021
88-24-16-333-025 000-022	18	175	109 N BALL CT	SALEM	IN	47167	Washington	81116	Washington	967600	9676	1123.5284	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	241.7243	244.9276	243.3153	510							88022
88-16-08-000-001 003-015	18	175	12924 E HONEY RUN RD	PEKIN	IN	47165	Washington	61002	Polk	967200	9672	18934.4733	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	280.1157	303.0487	297.1324	510							88015
88-14-15-000-012 000-013	18	175	2395 E DAISY LN	SALEM	IN	47167	Washington	59580	Pierce	967701	9677.0100	249244.7826	3	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	239.5347	274.0924	254.3756	101							88013
88-24-18-000-021 002-022	18	175	113-120 LAND MARK DR	SALEM	IN	47167	Washington	81116	Washington	967500	9675	6515.6894	13	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	220.5049	229.0085	225.6987	401							88022
88-24-20-111-015 000-022	18	175	405 S FAIR STREET	SALEM	IN	47167	Washington	81116	Washington	967600	9676	2456.8374	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	239.3021	245.4705	242.2573	510							88022
88-24-18-114-015 000-022	18	175	114 W BRUCE STREET	SALEM	IN	47167	Washington	81116	Washington	967500	9675	882.4029	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	240.5059	243.1679	242.2418	510							88022
88-24-17-224-051 000-022	18	175	506 N HIGH STREET	SALEM	IN	47167	Washington	81116	Washington	967500	9675	1007.4515	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	237.2037	239.1413	238.2298	510							88022
88-25-06-000-036 000-004	18	175	5563 E STATE ROAD 56	SALEM	IN	47167	Washington	25630	Franklin	967200	9672	7369.4667	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	274.6292	276.9945	275.8415	540							88004
88-14-11-000-018 002-013	18	175	4590 S MARTINSBURG RD	SALEM	IN	47167	Washington	59580	Pierce	967701	9677.0100	56015.6307	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	271.4303	292.1447	282.8213	101							88013
88-14-16-000-002 006-013	18	175	1051 E MILLERS SAWMILL RD	PEKIN	IN	47165	Washington	59580	Pierce	967400	9674	7488.0757	2	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	268.7865	275.7322	272.4856	510							88013
88-04-12-000-010 000-008	18	175	4305 E MARTINSBURG FIRE RD	PALMYRA	IN	47164	Washington	37512	Jackson	967702	9677.0200	5975.1979	2	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	255.1477	265.6126	260.6983	510							88008
88-25-30-000-002 000-004	18	175	5687 E STATE ROAD 160	SALEM	IN	47167	Washington	25630	Franklin	967200	9672	5000.6505	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	254.2810	263.8296	260.0372	510							88004
88-35-22-000-015 006-005	18	175	8019 E NEW CUT RD	SCOTTSBURG	IN	47170	Washington	27594	Gibson	967200	9672	20724.0854	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	186.2353	198.8989	192.7012	541							88005
88-24-01-000-001 007-021	18	175	2940 N OLD STATE RD 56	SALEM	IN	47167	Washington	81116	Washington	967600	9676	5233.5404	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	265.7066	269.8466	267.7126	510							88021
88-23-23-000-020 000-021	18	175	3226 W STATE ROAD 56	SALEM	IN	47167	Washington	81116	Washington	967400	9674	124452.9499	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	234.6653	256.1214	249.1054	199							88021
88-33-33-000-013 005-009	18	175	5140 W ARROW RD	SALEM	IN	47167	Washington	38268	Jefferson	967300	9673	7219.8795	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	272.5446	276.1827	274.8352	511							88009
88-14-35-000-010 000-013	18	175	3841 E TRAINER LN	PEKIN	IN	47165	Washington	59580	Pierce	967702	9677.0200	321710.7517	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	224.0024	258.8928	240.1191	101							88013
88-03-06-000-017 003-017	18	175	7645 W DOHONEY RD	FREDERICKSBURG	IN	47120	Washington	61398	Posey	967400	9674	3485.5619	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	212.9707	214.8510	213.7876	541							88017
88-34-16-000-002 003-012	18	175	1940 E JACKSON RD RD	SALEM	IN	47167	Washington	50508	Monroe	967300	9673	71799.7121	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	172.7861	217.2532	185.4606	101							88012
88-02-03-000-010 004-019	18	175	150 W US HIGHWAY 150	HARDINSBURG	IN	47125	Washington	61398	Posey	967400	9674	3455.5079	1	18175C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	210.4313	215.3393	213.2412	511							88019