Saved query 943641b3417fa32f

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

166,152 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
39017-A0300171000001	39	017	3320 TYLERSVILLE RD HAMILTON 45…	FAIRFIELD	OH	45011	6028 TRENT CT	LEWIS CENTER	OH	43035	Butler	25984	Fairfield	011004	110.0400	24933.8737	1	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	194.2915	199.3100	196.8962	425: Com-Shopping Center-NHBD	425: Com-Shopping Center-NHBD	6.1800	42392	BRICKS & MINIFIGS HAMILTON	TOYS_AND_GAMES_STORE
39017-D2020290000012	39	017	7302 YANKEE RD MIDDLETOWN 45044	LIBERTY	OH	45044	PO BOX 60609 COLORADO SPRINGS 8…	COLORADO SPRINGS	CO	80960	Butler	43050	Liberty	011120	111.2000	24457.5028	0	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	260.5486	265.4663	262.8036	426: Com-Shopping Center-Comun	426: Com-Shopping Center-Comun	5.5000	8121	NICKIE WAGNER HAIRSTYLIST	PERSONAL_OR_BEAUTY_SERVICE
39017-Q6542037000037	39	017	1628 SMITH AVE	MIDDLETOWN	OH	45044	1628 SMITH AVE	MIDDLETOWN	OH	45044-5933	Butler	49840	Middletown	014100	141	480.5578	1	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	197.7877	198.6836	198.3886	685: Exm-Public Woship	685: Exm-Public Woship	0	8131	TRUE VICTORY CHURCH	CHRISTIAN_PLACE_OF_WORSHIP
39017-A0700012000098	39	017	5333 PLEASANT AVE FAIRFIELD 450…	FAIRFIELD	OH	45014	620 LIBERTY AVE 19	PITTSBURGH	PA	15222	Butler	25970	Fairfield	010910	109.1000	4387.1450	0	39017C	2025-12-11	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	180.9608	185.3864	183.5595	444: Com-Full Service Bank	444: Com-Full Service Bank	1.5600	52231	PNC MORTGAGE	FINANCIAL_SERVICE
39017-A0700103000011	39	017	135 DONALD DR	FAIRFIELD	OH	45014	135 DONALD DR	FAIRFIELD	OH	45014-3004	Butler	25970	Fairfield	010906	109.0600	1990.5635	2	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	194.9230	196.6220	195.7322	455: Com-Garage	455: Com-Garage	0	8111	RELATIVE AUTO SERVICE	AUTOMOTIVE_SERVICE
39017-P6411119000002	39	017	1204 MAIN ST	HAMILTON	OH	45013	2926 B FOSTER CREIGHTON DR	NASHVILLE	TN	37204	Butler	33012	Hamilton	001002	10.0200	7634.5346	2	39017C	2025-12-11	AE		193.0424	195.0733	194.1193	426: Com-Shopping Center-Comun	426: Com-Shopping Center-Comun	1.7200	4593	THE ILLUMINAUDI	FLOWERS_AND_GIFTS_STORE
39017-M5670038000024	39	017	9003 CINCINNATI DAYTON RD	OLDE WEST CHESTER	OH	45069	9003 CINCINNATI DAYTON RD	WEST CHESTER	OH	45069-3127	Butler	83150	West Chester	011109	111.0900	1107.5693	2	39017C	2025-12-11	AE		191.4520	192.9697	192.1937	510: Res-Single Family	510: Res-Single Family	0	5412	REISENBERG DONALD CPA	FINANCIAL_SERVICE
39017-P6462020000067	39	017	347 KENYON DR	HAMILTON	OH	45015	347 KENYON DR	HAMILTON	OH	45015-1935	Butler	33012	Hamilton	000100	1	687.6128	1	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	176.4798	177.1135	176.7878	510: Res-Single Family	510: Res-Single Family	0
39017-A0700128000135	39	017	252 KINGS RIDGE SQ	FAIRFIELD	OH	45014	252 KINGS RIDGE SQ	FAIRFIELD	OH	45014-8631	Butler	25970	Fairfield	010907	109.0700	1108.2423	1	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	227.2260	229.3188	228.7132	510: Res-Single Family	510: Res-Single Family	0
39017-P6421018000001	39	017	0 FRECHTLING ST	HAMILTON	OH	45011	345 HIGH ST STE 730	HAMILTON	OH	45011	Butler	33012	Hamilton	000300	3	831.3998	0	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	177.9399	179.2994	178.9894	640: Exm-Municipality	640: Exm-Municipality	0
39017-D2020044000001	39	017	4592 HAMILTON MIDDLETOWN RD	LIBERTY	OH	45011	4592 HAMILTON MIDDLETOWN RD	LIBERTY TWP	OH	45011-2354	Butler	43050	Liberty	011135	111.3500	4666.5092	1	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	236.6333	240.9570	238.5648	510: Res-Single Family	510: Res-Single Family	1.0800
39017-Q6511046000042	39	017	4305 JEWELL AVE	MIDDLETOWN	OH	45042	7733 PLEASANT VALLEY RD	CAMDEN	OH	45311-8944	Butler	49840	Middletown	012300	123	1196.8006	2	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	203.0270	204.0886	203.7064	510: Res-Single Family	510: Res-Single Family	0
39017-R8000009000181	39	017	322 E HOME AVE TRENTON 45067	TRENTON	OH	45067	322 E HOME AVE	TRENTON	OH	45067-1724	Butler	77322	Trenton	015100	151	673.9511	2	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	198.5550	199.2455	198.9643	510: Res-Single Family	510: Res-Single Family	0
39017-B1320116000029	39	017	2500 ISABELLA LN	HANOVER	OH	45013	2500 ISABELLA LN	HAMILTON	OH	45013-4807	Butler	33250	Hanover	015000	150	1636.3625	1	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	213.1818	216.6477	215.0354	510: Res-Single Family	510: Res-Single Family	0
39017-E2310002000030	39	017	0 SYCAMORE RD	TRENTON	OH	45067	4123 PARKLAKE AVE	RALEIGH	NC	27612	Butler	46340	Madison	015100	151	39271.4009	0	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	191.8370	194.2845	192.7001	110: Agr-CAUV-Vacant Land	110: Agr-CAUV-Vacant Land	18.4000
39017-M5620066000065	39	017	8517 ALLENDALE DR WEST CHESTER …	WEST CHESTER	OH	45069	8517 ALLENDALE DR	WEST CHESTER	OH	45069-3453	Butler	83150	West Chester	011111	111.1100	1382.5451	1	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	267.2977	269.2183	268.4901	510: Res-Single Family	510: Res-Single Family	0
39017-H4100036000004	39	017	92 STONE CREEK DR	OXFORD	OH	45056	92 STONE CREEK DR	OXFORD	OH	45056-9774	Butler	59241	Oxford	010102	101.0200	4826.3133	1	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	303.3430	307.8840	305.4959	510: Res-Single Family	510: Res-Single Family	0
39017-B1010009000014	39	017	2574 DARRTOWN RD HAMILTON 45013	HANOVER	OH	45013	3888 STILLWELL BECKETT RD	OXFORD	OH	45056-9338	Butler	33250	Hanover	015000	150	3784.8311	0	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	240.3568	244.6306	243.3705	499: Com-Other	499: Com-Other	0.9200
39017-A0700258000024	39	017	5796 HIGH POINT CT FAIRFIELD 45…	FAIRFIELD	OH	45014	1768 HAPPY VALLEY DR	FAIRFIELD	OH	45014-4706	Butler	25970	Fairfield	010910	109.1000	1257.9319	0	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	240.7449	243.8899	242.5358	500: Res-Vacant Land	500: Res-Vacant Land	0.3100
39017-P6411048000067	39	017	38 HERMAN AVE	HAMILTON	OH	45013	38 HERMAN AVE	HAMILTON	OH	45013-1734	Butler	33012	Hamilton	001001	10.0100	806.0541	1	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	190.6062	191.8474	191.2761	510: Res-Single Family	510: Res-Single Family	0
39017-R8000018000033	39	017	514 BRELSFORD AVE	TRENTON	OH	45067	514 BRELSFORD AVE	TRENTON	OH	45067-1128	Butler	77322	Trenton	011800	118	1025.7537	1	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	206.9893	208.5386	208.2163	510: Res-Single Family	510: Res-Single Family	0
39017-P6412040000072	39	017	112 SMALLEY BLVD	HAMILTON	OH	45013	PO BOX 13212 HAMILTON 45013-0331	HAMILTON	OH	45013-0331	Butler	33012	Hamilton	014800	148	2715.1368	1	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	232.1177	241.1428	239.2318	401: Com-Apartment- 4 to 19	401: Com-Apartment- 4 to 19	0
39017-P6462003000236	39	017	347 HOOVEN AVE	HAMILTON	OH	45015	347 HOOVEN AVE	HAMILTON	OH	45015-1734	Butler	33012	Hamilton	000200	2	494.9127	2	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	179.3096	179.7971	179.5364	510: Res-Single Family	510: Res-Single Family	0
39017-A0300070000161	39	017	6372 GLENMONT DR	FAIRFIELD	OH	45011	6372 GLENMONT DR	HAMILTON	OH	45011-5082	Butler	25984	Fairfield	011005	110.0500	836.2207	2	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	219.9804	221.3447	220.9659	510: Res-Single Family	510: Res-Single Family	0
39017-C1800008230033	39	017	76 ETHEL DR	MONROE	OH	45050	76 ETHEL DR	MONROE	OH	45050-1767	Butler	42672	Lemon	011200	112	1194.6084	0	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	228.4496	229.6352	229.0780	510: Res-Single Family	510: Res-Single Family	0