Saved query 28e9719baf2ad4a3

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

42,429 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	parceltype	accesstype	iucnclass	placename	placetype
39009-P010010030100	39	009	0 WOLFE-BENNETT RD	YORK	OH	45764	15231 WOLFE BENNETT RD	NELSONVILLE	OH	45764	Athens	86982	York	972800	9728	3208.4250	0	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	297.4546	304.6465	302.5038	501: Res-Custom Code	501: Res-Custom Code	0.7200	1132	GOVT FEDERAL	RESTRICTED	OTHER	WAYNE NATIONAL FOREST	NATIONAL FOREST
39009-K010010044601	39	009	0 US RT 50	ROME	OH	45735	2829 W DUBLIN GRANVILLE RD	WORTHINGTON	OH	43085	Athens	68238	Rome	973600	9736	5277.9621	0	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	192.2789	199.8229	198.5276	610: Exm-Ohio	610: Exm-Ohio	1.3000	445131				MARATHON GAS	CONVENIENCE_STORE
39009-H010010055700	39	009	5919 W U S 50 HWY	LEE	OH	45710	11995 EL CAMINO REAL	SAN DIEGO	CA	92130	Athens	42420	Lee	973800	9738	6920.7421	1	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	232.1980	235.9968	235.0573	420: Com-Retail-Small	420: Com-Retail-Small	1.7100	4552				DOLLAR GENERAL	DISCOUNT_STORE
39009-L010010070700	39	009	4535 IRELAND RD	TROY	OH	45723	4535 IRELAND RD	COOLVILLE	OH	45723	Athens	77546	Troy	973600	9736	31583.7457	1	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	192.7761	248.8312	219.3151	511: Res-Custom Code	511: Res-Custom Code	8	23815				PETER HIGGS GENERAL CONTRACTING	HOME_SERVICE
39009-A029060001700	39	009	362 RICHLAND AVE	ATHENS	OH	45701	C O GREG HUNTER 129 N PATTERSON…	VALDOSTA	GA	31601	Athens	02750	Athens	973300	9733	945.5898	0	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	195.2224	213.7115	201.2617	400: Com-Vacant Land	400: Com-Vacant Land	0	2361				UNIVERSITY COURTYARD APARTMENTS	APARTMENT_BUILDING
39009-E010010026000	39	009	0 S CANAAN RD	CANAAN	OH	45701	RT 6 BOX 183	ATHENS	OH	45701	Athens	11220	Canaan	973700	9737	1683.5576	0	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	228.2970	231.2932	229.5741	685: Exm-Public Woship	685: Exm-Public Woship	0.3900
39009-N010010004809	39	009	4375 S R 56	NEW MARSHFIELD	OH	45701	4375 SR 56	NEW MARSHFIELD	OH	45766	Athens	81777	Waterloo	973800	9738	17655.1080	2	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	241.9353	269.2387	256.8156	511: Res-Custom Code	511: Res-Custom Code	4.3200
39009-A028340001700	39	009	32 AVON PL	ATHENS	OH	45701	32 AVON PLACE	ATHENS	OH	45701	Athens	02750	Athens	973400	9734	536.5539	1	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	196.3450	198.1156	197.4289	510: Res-Single Family	510: Res-Single Family	0
39009-H020030011400	39	009	5396 W CLINTON ST	ALBANY	OH	45710	5396 W CLINTON ST	ALBANY	OH	45710	Athens	42420	Lee	973800	9738	2051.4033	1	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	227.8880	229.4648	228.6522	510: Res-Single Family	510: Res-Single Family	0
39009-L010010081500	39	009	0 BRIMSTONE RD	TROY	OH	45723	25651 BRIMSTONE RD	COOLVILLE	OH	45723	Athens	77546	Troy	973600	9736	2298.4115	0	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	230.3894	235.9243	233.1588	100: Agr-Vacant Land	100: Agr-Vacant Land	0.4600
39009-P030030003500	39	009	0 FREDERICK ST	NELSONVILLE	OH	45764	315 TROPICALIA	JENSEN BEACH	FL	34957	Athens	86982	York	972700	9727	774.5855	0	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	234.1625	251.8825	240.8089	500: Res-Vacant Land	500: Res-Vacant Land	0
39009-N010090102600	39	009	0 MARSH ST	NEW MARSHFIELD	OH	45766	8345 MARSH ST	NEW MARSHFIELD	OH	45766	Athens	81777	Waterloo	973800	9738	809.2337	0	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	254.8571	259.2065	256.9117	500: Res-Vacant Land	500: Res-Vacant Land	0
39009-A029110007100	39	009	18 COVENTRY LN	ATHENS	OH	45701	18 COVENTRY LANE	ATHENS	OH	45701	Athens	02750	Athens	973300	9733	2426.6348	1	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	237.9911	247.8580	244.1353	510: Res-Single Family	510: Res-Single Family	0
39009-A027250005000	39	009	0 W UNION ST	ATHENS	OH	45701	ATHENS 45701	ATHENS	OH	45701	Athens	02750	Athens	973101	9731.0100	2258.7533	0	39009C	2025-12-11	AE	FLOODWAY	188.8239	194.6823	191.8984	670: Exm-Private College	670: Exm-Private College	10.7100
39009-A028270012200	39	009	140 GROSVENOR ST	ATHENS	OH	45701	140 GROSVENOR ST	ATHENS	OH	45701	Athens	02750	Athens	973000	9730	350.1784	1	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	220.8552	227.2190	224.3697	510: Res-Single Family	510: Res-Single Family	0
39009-A029190100700	39	009	14 WESTFIELD PL	ATHENS	OH	45701	14 WESTFIELD PL DR	ATHENS	OH	45701	Athens	02750	Athens	973300	9733	639.5389	0	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	242.3097	248.6138	245.4382	510: Res-Single Family	510: Res-Single Family	0
39009-N010010007000	39	009	4984 GUN CLUB RD	WATERLOO	OH	45701	ROUTE 1 BOX 486	ATHENS	OH	45701	Athens	81777	Waterloo	973800	9738	40579.7318	1	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	239.3633	272.8811	260.9234	599: Res-Other	599: Res-Other	10.0399
39009-N020020009901	39	009	0 CAMPBELL RD	WATERLOO	OH	45701	11 GRANVILLE	ATHENS	OH	45701	Athens	81777	Waterloo	973200	9732	32899.6146	0	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	256.1971	286.5121	272.7009	501: Res-Custom Code	501: Res-Custom Code	8.1000
39009-P010010045800	39	009	3352 MATHENY RD	YORK	OH	45764	3352 MATHENY RD	NELSONVILLE	OH	45764	Athens	86982	York	972800	9728	4017.2846	1	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	225.2280	244.1142	234.5101	561: Res-Custom Code	561: Res-Custom Code	0.8500
39009-C010010008800	39	009	0 S R 329	AMES	OH	45711	14969 SR 329	AMESVILLE	OH	45711	Athens	01770	Ames	973500	9735	1775.0683	0	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	196.0713	198.6356	197.2505	501: Res-Custom Code	501: Res-Custom Code	0.1100
39009-P010050103200	39	009	16954 PANCAKE RD	YORK	OH	45764	16945 PANCAKE RD	NELSONVILLE	OH	45764	Athens	86982	York	972700	9727	635.1834	0	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	221.5962	230.0525	224.9016	510: Res-Single Family	510: Res-Single Family	0
39009-N010010000401	39	009	5821 SR 56	WATERLOO	OH	45701	3521 BAILEY RD	ALBANY	OH	45710	Athens	81777	Waterloo	973200	9732	34232.5223	2	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	232.4788	250.7869	239.2257	511: Res-Custom Code	511: Res-Custom Code	8.4600
39009-P030180003500	39	009	0 ST JOHN ST	NELSONVILLE	OH	45764	177 ST JOHN ST	NELSONVILLE	OH	45764	Athens	86982	York	972700	9727	464.6183	0	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	226.4382	233.7556	229.7783	500: Res-Vacant Land	500: Res-Vacant Land	0
39009-B010010045901	39	009	2292 SAMS RD	ALEXANDER	OH	45710	2292 SAMS RD	ALBANY	OH	45710	Athens	01112	Alexander	973700	9737	65180.9554	2	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	231.9600	265.8985	245.8907	513: Res-Custom Code	513: Res-Custom Code	16.6800
39009-C010010017900	39	009	0 S R 329	AMES	OH	45711	8810 S WRIGHTSTOWN RD	AMESVILLE	OH	45711	Athens	01770	Ames	973500	9735	613.2927	0	39009C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	202.1654	203.4013	202.3798	500: Res-Vacant Land	500: Res-Vacant Land	0