Saved query 28164b435a6cfa2d

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 = '39' 
  AND countyfp = '021'

26,631 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	naicscode	placename	placetype
39021-C072100012100400	39	021	129 S MAIN ST	MECHANICSBURG	OH	43044	PO BOX 97 MECHANICSBURG 43044	MECHANICSBURG	OH	43044	Champaign	30982	Goshen	011505	115.0500	71855.6097	4	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	315.0843	321.8258	318.4053	112: Agr-CAUV-Livestock Farm	112: Agr-CAUV-Livestock Farm	18.9200	1122	NORVALL HUNTER FARM	HISTORIC_SITE
39021-C072100010803000	39	021	103 W RACE ST	MECHANICSBURG	OH	43044	103 W RACE ST	MECHANICSBURG	OH	43044	Champaign	30982	Goshen	011505	115.0500	538.8378	1	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	327.1314	329.3125	328.3765	510: Res-Single Family	510: Res-Single Family	0	455	ELEVEN GENERAL STORE	DISCOUNT_STORE
39021-K482500041903100	39	021	120 N MAIN ST	URBANA	OH	43078	122 N MAIN ST URBANA	URBANA	OH	43078	Champaign	79086	Urbana	010500	105	291.9759	0	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	320.7712	321.4126	321.0056	444: Com-Full Service Bank	444: Com-Full Service Bank	0	516120	1069THEBULL	RADIO_STATION
39021-J351000440003200	39	021	3544 ST RTE 56	MECHANICSBURG	OH	43044	3544 STATE ROUTE 56	MECHANICSBURG	OH	43044	Champaign	78274	Union	011504	115.0400	3590.7030	1	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	377.0877	379.5830	378.6247	511: Res-Custom Code	511: Res-Custom Code	0.9900
39021-L431200580000200	39	021	E ST RTE 296	WAYNE	OH	43009	5283 E ST RTE 296 CABLE	CABLE	OH	43009	Champaign	82096	Wayne	010100	101	11389.4184	0	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	363.4713	374.8176	368.5027	501: Res-Custom Code	501: Res-Custom Code	2.8900
39021-K482500040402907	39	021	503 RAILROAD ST	URBANA	OH	43078	1818 PENWOOD PL	MARYSVILLE	OH	43040	Champaign	79086	Urbana	010400	104	985.3102	1	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	314.4974	315.1769	314.8335	530: Res-Three Family	530: Res-Three Family	0
39021-I300900400003311	39	021	2770 E KANAGY RD	SALEM	OH	43009	2770 E KANAGY RD	CABLE	OH	43009	Champaign	69820	Salem	011501	115.0100	4046.5424	2	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	355.2812	356.1380	355.7066	511: Res-Custom Code	511: Res-Custom Code	1.1200
39021-K482500041612800	39	021	315 N EDGEWOOD AVE	URBANA	OH	43078	301 N EDGEWOOD AVE URBANA	URBANA	OH	43078	Champaign	79086	Urbana	010400	104	584.9020	1	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	315.1312	317.7859	316.8158	510: Res-Single Family	510: Res-Single Family	0
39021-J361010300001200	39	021	5043 ST RTE 4	MECHANICSBURG	OH	43044	5049 ST RTE 4	MECHANICSBURG	OH	43044	Champaign	78274	Union	011504	115.0400	4064.4822	1	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	322.4060	323.9143	322.9101	599: Res-Other	599: Res-Other	1
39021-K482500030300700	39	021	740 PARK LN	URBANA	OH	43078	740 PARK LN URBANA	URBANA	OH	43078	Champaign	79086	Urbana	010500	105	1236.2111	1	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	325.9019	328.1175	327.4865	510: Res-Single Family	510: Res-Single Family	0
39021-G220710240000400	39	021	5236 WILLOW DALE RD	URBANA	OH	43078	5236 WILLOW DALE RD URBANA	URBANA	OH	43078	Champaign	46760	Mad River	011001	110.0100	4184.6398	2	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	327.3074	334.1667	331.4398	511: Res-Custom Code	511: Res-Custom Code	1.1200
39021-G210711310002615	39	021	THACKERY RD	SPRINGFIELD	OH	45502	7784 THACKERY RD	SPRINGFIELD	OH	45502	Champaign	46760	Mad River	011001	110.0100	6581.3493	1	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	341.8819	349.2941	345.6608	599: Res-Other	599: Res-Other	1.7200
39021-K482500031915800	39	021	211 E WARD ST	URBANA	OH	43078	211 E WARD ST URBANA	URBANA	OH	43078	Champaign	79086	Urbana	010500	105	579.7656	1	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	320.2271	321.2813	320.9304	510: Res-Single Family	510: Res-Single Family	0
39021-G220710180001800	39	021	WILLOW DALE RD	SPRINGFIELD	OH	45502	WILLOW DALE RD URBANA	URBANA	OH	43078	Champaign	46760	Mad River	011001	110.0100	2656.5892	1	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	342.6169	344.3967	343.5808	599: Res-Other	599: Res-Other	0.7300
39021-E110510360002000	39	021	13340 ST RTE 55	ST PARIS	OH	43072	13340 ST RTE 55 ST	ST PARIS	OH	43072	Champaign	37702	Jackson	010200	102	18441.7333	2	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	337.5279	345.3915	341.6103	511: Res-Custom Code	511: Res-Custom Code	4.6200
39021-K411111090000607	39	021	2600 SHORT CUT RD	URBANA	OH	43078	2568 SHORT CUT RD URBANA	URBANA	OH	43078	Champaign	79086	Urbana	011504	115.0400	5259.9158	0	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	345.7633	349.0566	347.1266	501: Res-Custom Code	501: Res-Custom Code	1.4100
39021-K482500041400200	39	021	331 MOSGROVE ST	URBANA	OH	43078	331 MOSGROVE ST URBANA	URBANA	OH	43078	Champaign	79086	Urbana	010400	104	691.3949	2	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	311.8413	312.6620	312.1448	510: Res-Single Family	510: Res-Single Family	0
39021-C060300480004408	39	021	BRIGNER RD	MECHANICSBURG	OH	43044	3264 BROOKVIEW WAY	COLUMBUS	OH	43221	Champaign	30982	Goshen	011505	115.0500	3575.4167	0	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	352.7366	367.8385	362.9400	501: Res-Custom Code	501: Res-Custom Code	0.7000
39021-K482500031908800	39	021	301 E CHURCH ST	URBANA	OH	43078	301 E CHURCH ST 303 URBANA	URBANA	OH	43078	Champaign	79086	Urbana	010500	105	468.8493	3	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	320.1520	320.6466	320.3486	520: Res-Two Family	520: Res-Two Family	0
39021-L431200520001805	39	021	5235 EVANS RD	URBANA	OH	43078	5235 EVANS RD URBANA	URBANA	OH	43078	Champaign	82096	Wayne	010100	101	4359.6429	2	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	390.6433	391.8879	391.2436	511: Res-Custom Code	511: Res-Custom Code	1.3600
39021-K482500011400200	39	021	422 S MAIN ST	URBANA	OH	43078	422 S MAIN ST URBANA	URBANA	OH	43078	Champaign	79086	Urbana	010600	106	676.9988	2	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	318.0764	319.0810	318.5970	520: Res-Two Family	520: Res-Two Family	0
39021-E142000010801800	39	021	W FIRST ST	CHRISTIANSBURG	OH	45389	12 N MAIN ST	CHRISTIANSBURG	OH	45389	Champaign	37702	Jackson	010200	102	502.1105	1	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	337.0104	338.2020	337.7165	400: Com-Vacant Land	400: Com-Vacant Land	0
39021-K482500041906400	39	021	W COURT ST	URBANA	OH	43078	W COURT ST URBANA	URBANA	OH	43078	Champaign	79086	Urbana	010500	105	1534.1949	0	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	319.5627	321.1896	320.4574	685: Exm-Public Woship	685: Exm-Public Woship	0
39021-A010113020000100	39	021	9000 CEMETERY RD	DE GRAFF	OH	43318	12939 COUNTY ROAD 3	QUINCY	OH	43343	Champaign	00212	Adams	010200	102	37595.1712	2	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	340.3594	346.1611	343.8722	511: Res-Custom Code	511: Res-Custom Code	9.2100
39021-G210711250000204	39	021	ST RTE 55	URBANA	OH	43078	6672 ST RTE 55 URBANA	URBANA	OH	43078	Champaign	46760	Mad River	011001	110.0100	1174.7424	0	39021C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	341.0914	343.3556	342.3188	501: Res-Custom Code	501: Res-Custom Code	0.3600