Saved query 73352dc0d7820263

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

21,600 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	numunits	numfloors	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	naicscode	parceltype	accesstype	iucnclass	placename	placetype
39001-1020000063000	39	001	2492 CHAPPARAL RD WEST UNION 45…	TIFFIN	OH	45693	2045 MORSE RD	COLUMBUS	OH	43229	Adams	76768	Tiffin	770301	7703.0100	2388.5424	0			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	290.0816	299.4172	294.2757	680: Exm-Charitable	680: Exm-Charitable	0.5800	712190	GOVT STATE	CLOSED	V	CHAPARRAL PRAIRIE DEDICATED NAT…	STATE CONSERVATION AREA
39001-1970000002002	39	001	LOWER TWIN CREEK RD BLUE CREEK …	GREEN	OH	45616	830 LOWER TWIN CREEK RD	BLUE CREEK	OH	45616	Adams	31668	Green	770500	7705	11453.4452	1			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	167.7946	277.8262	195.8687	599: Res-Other	599: Res-Other	2.7400	3211	GOVT STATE	RESTRICTED	V	SHAWNEE STATE FOREST	STATE CONSERVATION AREA
39001-1660000015000	39	001	2119 CHURN CREEK RD	JEFFERSON	OH	45616	916 E HUGHEY ST	APOPKA	FL	32703	Adams	38486	Jefferson	770500	7705	4953.1850	0			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	261.0653	268.0345	265.1634	599: Res-Other	599: Res-Other	1.0700	3211	GOVT STATE	RESTRICTED	V	SHAWNEE STATE FOREST	STATE CONSERVATION AREA
39001-0550000067003	39	001	5300 STEAM FURNACE RD	PEEBLES	OH	45660	5300 STEAM FURNACE	PEEBLES	OH	45660	Adams	48888	Meigs	770100	7701	16396.3902	5	1	2	39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	246.2651	258.9271	253.0484	511: Res-Custom Code	511: Res-Custom Code	4.1100
39001-1173316003000	39	001	222 PLEASANT ST N	WEST UNION	OH	45693	P O BOX 518 WEST UNION 45693	WEST UNION	OH	45693	Adams	76768	Tiffin	770400	7704	409.8413	1			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	290.2549	292.2158	291.2890	510: Res-Single Family	510: Res-Single Family	0.1000
39001-1870000020000	39	001	101 TRACY RUN RD STOUT 45684	GREEN	OH	45684	1951 S LYNHURST DR	INDIANAPOLIS	IN	46241	Adams	31668	Green	770500	7705	7539.4979	1			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	165.1081	216.5018	179.6468	511: Res-Custom Code	511: Res-Custom Code	1.8000
39001-0740000006001	39	001	KIRKPATRICK RD WINCHESTER 45697	WAYNE	OH	45697	412 KIRKPATRICK RD	WINCHESTER	OH	45697	Adams	82012	Wayne	770302	7703.0200	446.0518	0			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	296.4621	297.3750	296.9175	501: Res-Custom Code	501: Res-Custom Code	0.1100
39001-0620000062000	39	001	SILVER LN	WINCHESTER	OH	45697	203 W MAIN ST	WEST UNION	OH	45693	Adams	85890	Winchester	770301	7703.0100	5976.3876	0			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	290.5594	292.1482	291.2678	501: Res-Custom Code	501: Res-Custom Code	1.5000
39001-1560000007000	39	001	1726 CLAYTON PIKE	SPRIGG	OH	45144	1726 CLAYTON PIKE	MANCHESTER	OH	45144	Adams	74069	Sprigg	770302	7703.0200	73476.2421	3			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	271.2505	290.0993	281.4731	101: Agr-Cash-Grain Farm	101: Agr-Cash-Grain Farm	18.5100
39001-0620000003001	39	001	1920 SR 137 WINCHESTER 45697	WAYNE	OH	45697	1920 SR 137	WINCHESTER	OH	45697	Adams	82012	Wayne	770301	7703.0100	22549.3677	2			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	272.6550	277.0848	274.4076	511: Res-Custom Code	511: Res-Custom Code	5.3300
39001-1173404009000	39	001	417-419 HICKORY ST WEST UNION 4…	WEST UNION	OH	45693	133 KIMBERLY DR WEST	WEST UNION	OH	45693	Adams	76768	Tiffin	770400	7704	553.2981	2			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	295.9512	296.7653	296.3663	562: Res-Custom Code	562: Res-Custom Code	0.1300
39001-0510000019000	39	001	1544 SR 770 SEAMAN 45679	SCOTT	OH	45679	1544 SR 770 SEAMAN	SEAMAN	OH	45679	Adams	71052	Scott	770200	7702	8045.5180	1			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	248.2092	259.8095	254.8553	599: Res-Other	599: Res-Other	1.9300
39001-0170000046001	39	001	SR 41 PEEBLES 45660	FRANKLIN	OH	45660	31596 SR 41	PEEBLES	OH	45660	Adams	28196	Franklin	770100	7701	14719.2541	0			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	222.6720	237.9389	233.0756	501: Res-Custom Code	501: Res-Custom Code	3.7100
39001-0483111002000	39	001	32 FAIRGROUND AVE	WINCHESTER	OH	45697	159 WILSON ST	NEWARK	OH	43055	Adams	85890	Winchester	770200	7702	1170.7873	1			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	300.4107	301.5101	301.0717	510: Res-Single Family	510: Res-Single Family	0.2900
39001-0470000051001	39	001	197 JEE RD WINCHESTER 45697	WINCHESTER	OH	45697	18167 STATE ROUTE 136	WINCHESTER	OH	45697	Adams	85890	Winchester	770302	7703.0200	45679.9201	3			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	296.3044	306.5422	302.6234	599: Res-Other	599: Res-Other	11.2400
39001-0680000028007	39	001	MEADOW LN PEEBLES 45660	MEIGS	OH	45660	125 MEADOW LN	PEEBLES	OH	45660	Adams	48888	Meigs	770500	7705	3255.4620	0			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	253.8759	258.3684	256.4353	501: Res-Custom Code	501: Res-Custom Code	0.7900
39001-0780000023006	39	001	3645 WHEAT RIDGE RD WEST UNION …	OLIVER	OH	45693	3735 WHEAT RIDGE RD	WEST UNION	OH	45693	Adams	58366	Oliver	770301	7703.0100	9267.7593	3			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	280.0066	291.9348	288.1302	511: Res-Custom Code	511: Res-Custom Code	2.2900
39001-0170000044000	39	001	31596 SR 41	FRANKLIN	OH	45660	31596 ST RT 41	PEEBLES	OH	45660	Adams	28196	Franklin	770100	7701	7825.4438	2			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	228.8294	236.5872	233.4165	511: Res-Custom Code	511: Res-Custom Code	1.9200
39001-0481407005000	39	001	19412 SR 136 WINCHESTER 45697	WINCHESTER	OH	45697	19412 SR 136	WINCHESTER	OH	45697	Adams	85890	Winchester	770200	7702	1072.5378	2			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	295.2570	296.1328	295.5925	510: Res-Single Family	510: Res-Single Family	0.2500
39001-0551302011000	39	001	38 VINE ST PEEBLES 45660	PEEBLES	OH	45660	P O BOX 1230 MOUNT VERNON 43050	MOUNT VERNON	OH	43050	Adams	48888	Meigs	770100	7701	327.4631	0			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	254.3070	254.7764	254.5443	685: Exm-Public Woship	685: Exm-Public Woship	0.1000
39001-0550000034000	39	001	26961 SR 41 PEEBLES 45660	PEEBLES	OH	45660	26823 SR 41	PEEBLES	OH	45660	Adams	48888	Meigs	770100	7701	67380.5720	0			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	246.6873	255.8434	250.1697	101: Agr-Cash-Grain Farm	101: Agr-Cash-Grain Farm	19.6900
39001-0150000056004	39	001	MCCLEESE RD PEEBLES 45660	PEEBLES	OH	45660	2735 CRUM RD	HILLSBORO	OH	45133	Adams	08350	Bratton	770100	7701	43614.1611	3			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	208.0255	235.1542	222.4961	101: Agr-Cash-Grain Farm	101: Agr-Cash-Grain Farm	10.8900
39001-1750000010000	39	001	15084 US 52 MANCHESTER 45144	MONROE	OH	45144	12 HOUNDSLOOTH LN	CHESTER SPRINGS	PA	19425	Adams	51268	Monroe	770600	7706	11019.7902	0			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	167.2682	185.4822	174.3319	101: Agr-Cash-Grain Farm	101: Agr-Cash-Grain Farm	2.7200
39001-1104000010000	39	001	12067 SR 348 OTWAY 45657	JEFFERSON	OH	45657	12075 SR 348 OTWAY	OTWAY	OH	45657	Adams	38486	Jefferson	770500	7705	742.6756	0			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	186.7633	187.4266	187.0797	500: Res-Vacant Land	500: Res-Vacant Land	0.1800
39001-0551332005000	39	001	107 COBLER ST	PEEBLES	OH	45660	70 ROSLIN DR	PEEBLES	OH	45660	Adams	48888	Meigs	770100	7701	673.7900	2			39001C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	254.2554	255.3142	254.8397	510: Res-Single Family	510: Res-Single Family	0.1700