Saved query 6c0e849603cff9ec

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

20,346 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	placename	placetype	taxdistrict
39-13-02-243-005 000-007	18	077	102 W VAUGHN DR	MADISON	IN	47250	Jefferson	46008	Madison	966600	9666	1684.9784		18077C	2025-12-14	AE	FLOODWAY	137.0415	138.8389	137.5702	621	7224	GOVT LOCAL	OPEN	MADISON'S BBQ PARTY	MUSIC_VENUE	39007
39-13-03-112-013 000-007	18	077	801 W MAIN ST	MADISON	IN	47250	Jefferson	46008	Madison	966600	9666	1661.5712	4	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	146.6588	148.0604	147.4922	429	444			OLDE TYME MARKETPLACE	HARDWARE_HOME_AND_GARDEN_STORE	39007
39-13-02-213-012 000-007	18	077	409 POPLAR ST	MADISON	IN	47250	Jefferson	46008	Madison	966600	9666	181.5539	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	150.0565	151.7990	151.3956	481	54143			JANIE MAHONEY PHOTOGRAPHY AND D…	MEDIA_SERVICE	39007
39-13-02-124-031 000-007	18	077	423 E MAIN St	MADISON	IN	47250	Jefferson	46008	Madison	966600	9666	450.0678	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	151.2013	152.2500	151.8660	510						39007
39-08-23-100-015 000-007	18	077	638 TWIN FALLS DR	MADISON	IN	47250	Jefferson	46008	Madison	966500	9665	12241.6911	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	244.0040	263.2891	260.7694	510						39007
39-07-02-000-006 000-014	18	077	5970 W 500 N	MADISON	IN	47250	Jefferson	70398	Smyrna	966100	9661	154586.6567	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	226.5738	241.2165	236.6698	101						39014
39-08-28-111-010 000-007	18	077	2025 WILSON Ave	MADISON	IN	47250	Jefferson	46008	Madison	966400	9664	1049.4074	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	267.4826	268.2508	267.8796	510						39007
39-02-13-000-010 000-013	18	077	7499 E SR 62	CANAAN	IN	47224	Jefferson	69228	Shelby	966000	9660	1104.5490	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	187.5921	189.4800	188.6724	511						39013
39-04-36-000-016 000-004	18	077	6089 N SR 7	MADISON	IN	47250	Jefferson	41940	Lancaster	966100	9661	3317.6155	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	237.8632	245.2317	243.3299	511						39004
39-08-27-221-027 000-007	18	077	2124 ALLEN St	MADISON	IN	47250	Jefferson	46008	Madison	966500	9665	746.5621	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	273.9981	274.5008	274.2539	510						39007
39-08-30-000-025 000-006	18	077	1266 N BORCHERDING RD	MADISON	IN	47250	Jefferson	46008	Madison	966100	9661	5131.0644	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	247.5905	248.3441	248.0150	511						39006
39-08-23-300-011 000-007	18	077	2626 FRANKS Dr	MADISON	IN	47250	Jefferson	46008	Madison	966500	9665	3479.0330	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	266.3599	272.1610	269.5230	510						39007
39-08-27-112-025 000-007	18	077	314 MONTCLAIR ST	MADISON	IN	47250	Jefferson	46008	Madison	966500	9665	829.6141	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	276.8135	277.2676	277.0091	510						39007
39-08-06-300-006 004-006	18	077	5000 + N SR 7	MADISON	IN	47250	Jefferson	46008	Madison	966100	9661	89472.1128	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	248.4168	255.8927	253.1563	100						39006
39-14-12-223-011 000-003	18	077	264 N SYCAMORE Dr	HANOVER	IN	47243	Jefferson	31234	Hanover	966300	9663	909.6367	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	241.4851	242.2336	241.9228	510						39003
39-08-27-114-047 000-007	18	077	125 GREEN Rd	MADISON	IN	47250	Jefferson	46008	Madison	966500	9665	6265.8562	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	265.6037	271.3874	268.4504	510						39007
39-04-25-000-025 000-004	18	077	4090 W 700 N	MADISON	IN	47250	Jefferson	41940	Lancaster	966100	9661	3352.2328	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	253.0081	253.6123	253.2698	511						39004
39-04-13-000-003 000-004	18	077	9848 N BREEDING Rd	DUPONT	IN	47231	Jefferson	41940	Lancaster	966100	9661	4245.8694	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	247.6065	249.3694	248.5371	511						39004
39-13-02-221-038 000-007	18	077	408 BROADWAY ST	MADISON	IN	47250	Jefferson	46008	Madison	966600	9666	227.2959	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	150.7479	151.2483	151.0277	400						39007
39-13-06-200-017 000-002	18	077	140 AMBER WAVES BLVD	HANOVER	IN	47243	Jefferson	31234	Hanover	966100	9661	1172.8942	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	245.2925	245.9353	245.5983	510						39002
39-07-35-400-118 000-006	18	077	155 N HEREFORD Ln	MADISON	IN	47250	Jefferson	46008	Madison	966100	9661	2088.8570	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	237.7875	239.6951	238.8016	510						39006
39-14-13-334-018 000-002	18	077	4565 W CHAIN MILL CT	HANOVER	IN	47243	Jefferson	31234	Hanover	966300	9663	5528.2130	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	177.8943	229.6762	218.2473	510						39002
39-07-14-000-003 000-014	18	077	5289 W 400 N	MADISON	IN	47250	Jefferson	70398	Smyrna	966100	9661	309710.0642	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	233.7623	244.9851	239.5718	101						39014
39-08-28-113-043 000-007	18	077	1121 PINEHURST AVE	MADISON	IN	47250	Jefferson	46008	Madison	966400	9664	613.0433	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	263.7692	264.6284	264.0754	510						39007
39-07-11-000-017 001-014	18	077	4199 N 500 W	MADISON	IN	47250	Jefferson	70398	Smyrna	966100	9661	13596.4032	1	18077C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	241.4866	246.5761	244.2258	511						39014