Saved query 9dbad73eb72749e7

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

26,862 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
39039-I020111000501	39	039	1340 W HIGH	DEFIANCE	OH	43512	1340 W HIGH ST	DEFIANCE	OH	43512	Defiance	56014	Noble	958500	9585	56856.9712	7	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	201.4457	214.7047	211.9755	447: Com-Office	447: Com-Office	13.5200	54	THE BOCKELMAN COMPANY	PROFESSIONAL_SERVICE
39039-A070029002900	39	039	5855 5751 5921 DOMERSVILLE	DEFIANCE	OH	43512	RT 4	DEFIANCE	OH	43512	Defiance	00268	Adams	958100	9581	82545.2020	7	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	222.7388	226.0149	224.2365	650: Exm-Board of Education	650: Exm-Board of Education	20.1500	611110	TINORA HIGH SCHOOL	HIGH_SCHOOL
39039-B012111001900	39	039	2350 BALTIMORE ZELLER CORP ANNE…		OH	43512	LIMA 45801	LIMA	OH	45801	Defiance	21322	Defiance	958600	9586	18897.3944	1	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	210.2020	215.4209	213.5986	610: Exm-Ohio	610: Exm-Ohio	4.5199	922120	HIGHWAY PATROL	POLICE_STATION
39039-J110019C00600	39	039	E SECOND		OH	43512	1924 E SECOND ST	DEFIANCE	OH	43512	Defiance	66670	Richland	958800	9588	862.6736	0	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	218.8767	219.4187	219.1392	400: Com-Vacant Land	400: Com-Vacant Land	0	611692	KEY DRIVING SCHOOL	SPECIALTY_SCHOOL
39039-E200005A02601	39	039	BUCKSKIN		OH	43526	2923 BUCKSKIN RD	HICKSVILLE	OH	43526	Defiance	35112	Hicksville	958200	9582	297.5247	0	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	244.9826	247.1010	246.1023	500: Res-Vacant Land	500: Res-Vacant Land	0	444	BUCKSKIN TREE FARM	HARDWARE_HOME_AND_GARDEN_STORE
39039-I020141A06400	39	039	343 ARLETA	DEFIANCE	OH	43512	343 ARLETA ST	DEFIANCE	OH	43512	Defiance	56014	Noble	958500	9585	1125.2718	1	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	217.5404	218.0296	217.8248	510: Res-Single Family	510: Res-Single Family	0
39039-B014147003800	39	039	426 HIGHLAND	DEFIANCE	OH	43512	426 HIGHLAND DEFIANCE	DEFIANCE	OH	43512	Defiance	21322	Defiance	958800	9588	389.2691	1	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	211.0297	211.6849	211.1878	510: Res-Single Family	510: Res-Single Family	0
39039-J090033000101	39	039	27844 HAGY	DEFIANCE	OH	43512	27844 HAGY RD	DEFIANCE	OH	43512	Defiance	66670	Richland	958900	9589	5273.2328	0	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	223.9684	224.6842	224.3052	511: Res-Custom Code	511: Res-Custom Code	1.3000
39039-B014144004600	39	039	35 MAIN	DEFIANCE	OH	43512	35 MAIN ST	DEFIANCE	OH	43512	Defiance	21322	Defiance	958800	9588	599.3331	1	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	206.8822	207.8093	207.4111	510: Res-Single Family	510: Res-Single Family	0
39039-I130012000806	39	039	8401 ST RT 66	DEFIANCE	OH	43512	1809 TIFFIN CT	DEFIANCE	OH	43512	Defiance	56014	Noble	958100	9581	15233.1770	1	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	216.4048	217.7970	217.2200	420: Com-Retail-Small	420: Com-Retail-Small	3.7400
39039-E200002000903	39	039	5618 HUBER	HICKSVILLE	OH	43526	5618 HUBER RD	HICKSVILLE	OH	43526	Defiance	35112	Hicksville	958400	9584	17400.9204	1	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	235.9236	242.0243	238.5901	511: Res-Custom Code	511: Res-Custom Code	4.3000
39039-E060009006201	39	039	105 HATTERY	HICKSVILLE	OH	43526	5085 THIEL RD	HICKSVILLE	OH	43526	Defiance	35112	Hicksville	958300	9583	7124.3946	2	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	228.4994	229.4057	228.8872	510: Res-Single Family	510: Res-Single Family	1.7500
39039-B012087002200	39	039	927 HOLGATE	DEFIANCE	OH	43512	927 HOLGATE AVE	DEFIANCE	OH	43512	Defiance	21322	Defiance	958600	9586	550.1684	0	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	211.6020	212.4787	212.0297	510: Res-Single Family	510: Res-Single Family	0
39039-A070023000101	39	039	29133 GERKEN	DEFIANCE	OH	43512	29133 GERKEN RD	DEFIANCE	OH	43512	Defiance	00268	Adams	958100	9581	26190.8281	2	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	216.8495	219.7103	218.5641	511: Res-Custom Code	511: Res-Custom Code	6.4700
39039-L150034000703	39	039	16820 GIPE	NEY	OH	43549	16820 GIPE RD NEY	NEY	OH	43549	Defiance	81200	Washington	958200	9582	20275.0359	3	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	213.9012	216.7187	215.4535	511: Res-Custom Code	511: Res-Custom Code	5.0100
39039-B014144008800	39	039	80 CALVIN	DEFIANCE	OH	43512	80 CALVIN ST	DEFIANCE	OH	43512	Defiance	21322	Defiance	958800	9588	419.6831	1	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	206.5053	207.8798	207.5536	510: Res-Single Family	510: Res-Single Family	0
39039-B012096004300	39	039	653 JACKSON	DEFIANCE	OH	43512	653 JACKSON AVE	DEFIANCE	OH	43512	Defiance	21322	Defiance	958600	9586	701.3255	2	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	210.5956	211.4831	211.0744	510: Res-Single Family	510: Res-Single Family	0
39039-I130005001100	39	039	7939 TRINITY	DEFIANCE	OH	43512	7939 TRINITY RD	DEFIANCE	OH	43512	Defiance	56014	Noble	958200	9582	3288.9790	1	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	214.7020	215.8729	215.4053	511: Res-Custom Code	511: Res-Custom Code	0.8100
39039-J090028000300	39	039	27480 STANDLEY	DEFIANCE	OH	43512	27480 STANDLEY RD	DEFIANCE	OH	43512	Defiance	66670	Richland	958100	9581	3968.6706	1	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	225.6003	227.6447	226.7383	511: Res-Custom Code	511: Res-Custom Code	1
39039-F120003C01200	39	039	HIGHLAND CENTER	DEFIANCE	OH	43512	14072 HIGHLAND CENTER RD	DEFIANCE	OH	43512	Defiance	35196	Highland	958900	9589	2022.8744	0	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	221.9272	222.5732	222.1881	599: Res-Other	599: Res-Other	0
39039-K140013000501	39	039	3147 ST RT 66	DEFIANCE	OH	43512	R 2	DEFIANCE	OH	43512	Defiance	76772	Tiffin	958100	9581	6437.2556	1	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	214.3989	217.9060	216.7510	511: Res-Custom Code	511: Res-Custom Code	1.5000
39039-L150029000803	39	039	5354 COY	NEY	OH	43549	14212 SCOTT RD BRYAN	BRYAN	OH	43506	Defiance	81200	Washington	958200	9582	8071.7214	1	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	219.2633	220.0513	219.6726	560: Res-Mobile Home	560: Res-Mobile Home	2
39039-F120004A00200	39	039	27831 WATSON	DEFIANCE	OH	43512	27831 WATSON RD	DEFIANCE	OH	43512	Defiance	35196	Highland	958900	9589	1838.4241	2	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	221.3715	222.1136	221.7542	510: Res-Single Family	510: Res-Single Family	0
39039-I020141A05700	39	039	333 RIVERDALE	DEFIANCE	OH	43512	333 RIVERDALE DR	DEFIANCE	OH	43512	Defiance	56014	Noble	958500	9585	1194.5377	1	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	217.2297	218.1999	217.8511	510: Res-Single Family	510: Res-Single Family	0
39039-I130015D04300	39	039	1264 BEARPAW	DEFIANCE	OH	43512	1264 BEARPAW DR	DEFIANCE	OH	43512	Defiance	56014	Noble	958100	9581	1610.9758	1	39039C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	211.5101	212.5565	212.1981	510: Res-Single Family	510: Res-Single Family	0