Saved query b07ff77f032f4694

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

36/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '39' 
  AND countyfp = '061'

418,232 matching parcels

Data Preview

parcelid	statefp	countyfp	parcelcity	parcelstate	ownername	owneraddr	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	ownertype	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxdistrict
062001100004	39	061	MILFORD	OH	OHIO DIVISION OF NATURAL	BLDG C-4 FOUNTAIN SQ	HAMILTON	76028	SYMMES	027300	273	31208.4559	39061C	2025-12-11	AE	FLOODWAY	160.4196	166.5934	162.4931	610	GOVERNMENT	E REAR ST RTE 126 3.215 A	620	0110	GOVT STATE	RESTRICTED	V	MIAMIVILLE ACCESS SCENIC RIVER	STATE CONSERVATION AREA	2026.2	66
050000220021	39	061	KELLOGG	OH	THE BOARD OF PARK COMMISSION HA…	10245 WINTON RD	HAMILTON	01980	ANDERSON	027500	275	533.3459	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	229.9542	237.8614	234.1610	620	PERSON	REAR OLD ST RT 52 96	500	0022	GOVT LOCAL	OPEN		WOODLAND MOUND	LOCAL PARK	2026.2	42
052100070031	39	061	ELM	OH	TERRACE PARK VILLAGE OF	428 ELM RD	HAMILTON	76428	TERRACE PARK	027300	273	259143.9235	39061C	2025-12-11	AE	FLOODWAY	146.7645	160.7265	151.0620	640	GOVERNMENT	REAR ELM AVE AC IRR	521	0007	GOVT LOCAL	OPEN		WILDERNESS PRESERVE	LOCAL PARK	2026.2	107
050001020036	39	061	NORDYKE	OH	THE BOARD OF PARK COMMISSION HA…	10245 WINTON RD	HAMILTON	01980	ANDERSON	027500	275	363147.6719	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	184.8673	253.3056	229.2570	620	PERSON	NORDYKE RD 88.99 ACSSUR	500	0102	GOVT LOCAL	OPEN		WOODLAND MOUND	LOCAL PARK	2026.2	42
062902710011	39	061	MILFORD	OH	STATE OF OHIO	2045 MORSE RD BLDG	HAMILTON	76582	THE VILLAGE OF INDIAN HILL	027300	273	32732.7216	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	161.0139	179.6725	175.1929	610	GOVERNMENT	AC IRR RW FROM CLCUNNINGH	629	0271				LITTLE MIAMI BIKE TRAIL	RECREATIONAL_TRAIL_OR_PATH	2026.2	66
050000740071	39	061	MT CARMEL	OH	SPK PROPERTIES LTD	3241 MT CARMEL RD	HAMILTON	01980	ANDERSON	024901	249.0100	3330.0159	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	261.8183	265.7829	264.3960	442	BUSINESS	NS SR #32 0.822 AC W MOSL	500	0074				EASTGATE DENTAL EXCELLENCE	DENTAL_CLINIC	2026.2	42
050000300075	39	061	NORDYKE	OH	CALVARY CHAPEL A BIBLE	986 NORDYKE RD	HAMILTON	01980	ANDERSON	025103	251.0300	22913.8324	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	260.8319	267.5348	266.0392	685	NONPROFIT	NORDYKE RD 5.38 AC PT LOT	500	0030				CALVARY ALLIANCE CHURCH	CHRISTIAN_PLACE_OF_WORSHIP	2026.2	42
052900210002	39	061		OH	VILLAGE OF INDIAN HILL	6525 DRAKE RD	HAMILTON	76582	THE VILLAGE OF INDIAN HILL	027300	273	109559.3770	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	154.4464	172.7888	162.1118	640	GOVERNMENT		529	0021	GOVT LOCAL	OPEN		CAMP ROSS	LOCAL PARK	2026.2	70
062001200004	39	061		OH	VILLAGE OF INDIAN HILL	6525 DRAKE RD	HAMILTON	76028	SYMMES	027300	273	201764.2352	39061C	2025-12-11	AE	FLOODWAY	155.6380	172.7017	160.6437	660	GOVERNMENT		620	0120	GOVT LOCAL	OPEN		CAMP DENNISON	HISTORIC_SITE	2026.2	66
062000900096	39	061		OH	FENCE COMPANY-COMMERCIAL DIVISI…	9753 E KEMPER RD	HAMILTON	76028	SYMMES	024303	243.0300	8185.1696	39061C	2025-12-11	AE	FLOODWAY	166.7381	173.9742	171.4789	499	BUSINESS	SS EAST KEMPER RD 2.023 A	620	0090				THE FENCE COMPANY	HOME_SERVICE	2026.2	212
050000900030	39	061	MT CARMEL	OH	GRATSCH JOHN	4304 MT CARMEL RD	HAMILTON	01980	ANDERSON	024901	249.0100	12924.3311	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	172.4990	185.0048	175.5061	599	PERSON	ES MT CARMEL RD 3.195 AC	500	0090						2026.2	42
050000430311	39	061	MUSKEGON	OH	KOCH MICHAEL W &	1834 MUSKEGON DR	HAMILTON	01980	ANDERSON	025102	251.0200	1658.9426	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	271.3846	273.6044	272.2991	510	PERSON	MUSKEGON DR 70 X 147.97 I	500	0043						2026.2	42
050000500044	39	061	CLOUGH	OH	RACER JAMES TODD & SHARONE SUE	8678 CLOUGH PIKE	HAMILTON	01980	ANDERSON	025101	251.0100	2284.9733	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	261.1084	267.6554	265.1267	500	PERSON	NS CLOUGH 0.555 QR 666 DR	500	0050						2026.2	42
050000600221	39	061	DAMERON	OH	TEXTER RONALD J @ 3	4537 DAMERON LN	HAMILTON	01980	ANDERSON	025101	251.0100	1480.7288	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	260.2854	267.5779	262.9458	500	PERSON	DAMERON LN (REAR) 0.395 A	500	0060						2026.2	42
050000840005	39	061	MT CARMEL	OH	COMBS LLOYD B &	4770 BEECHWOOD FARMS DR	HAMILTON	01980	ANDERSON	024901	249.0100	7695.8583	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	220.9336	248.8520	238.9276	500	PERSON	MT CARMEL RD 1.800 AC MS	500	0084						2026.2	42
062001100033	39	061	FLETCHER	OH	CROUCH TERRY W	10223 FLETCHER RD	HAMILTON	76028	SYMMES	027300	273	13486.9122	39061C	2025-12-11	AE	FLOODWAY	159.8322	166.7413	163.5732	510	PERSON	FLETCHER RD 3.3370AC R1-T	620	0110						2026.2	66
050000400140	39	061	WHITEPINE	OH	FUTRELL THOMAS J	1128 WHITE PINE CT	HAMILTON	01980	ANDERSON	025103	251.0300	1326.2362	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	272.6481	274.2151	273.5752	510	PERSON	WHITEPINE CT 69.17 X 207.	500	0040						2026.2	42
050000300076	39	061	NORDYKE	OH	RANIERI ANTONIO VETO	807 NORDYKE RD	HAMILTON	01980	ANDERSON	027500	275	1863.1757	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	246.7565	251.7227	249.2565	510	PERSON	NORDYKE RD 105 FT IRR PT	500	0030						2026.2	42
050000430329	39	061	MUSKEGON	OH	FLAHERTY PATRICK J	1882 MUSKEGON DR	HAMILTON	01980	ANDERSON	025102	251.0200	1548.4937	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	266.3161	269.2244	268.2071	510	PERSON	70 X 241.21 IRR LOT 108 L	500	0043						2026.2	42
050000900027	39	061	MT CARMEL	OH	GORDON LORETTA L	4302 MT CARMEL RD	HAMILTON	01980	ANDERSON	024901	249.0100	18625.9947	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	172.4260	185.7171	177.8627	510	PERSON	BICKEL RD 4.64 AC SUR 177	500	0090						2026.2	42
050000600322	39	061	EIGHT MILE	OH	FROSCHAUER SCOTT & HEIDI	4535 DAMERON LN	HAMILTON	01980	ANDERSON	025101	251.0100	1693.8865	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	262.7094	267.7656	265.3044	599	PERSON	EIGHT MILE RD (REAR)0.418	500	0060						2026.2	42
062001100001	39	061	MILFORD	OH	STATE OF OHIO	505 S STATE ROUTE 741	HAMILTON	76028	SYMMES	027300	273	7047.3762	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	161.0139	172.9028	167.0013	610	GOVERNMENT	GLENDALE-MILFORD RD 570 X	620	0110						2026.2	66
050000740005	39	061	MT CARMEL	OH	MCSWAIN JEFFREY S	3300 MT CARMEL RD	HAMILTON	01980	ANDERSON	024901	249.0100	2097.5801	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	261.6503	262.7459	262.1150	510	PERSON	MT CARMEL RD 100 X 206.10	500	0074						2026.2	42
062001100030	39	061	FLETCHER	OH	MILLER DOUGLAS HARPER	751 LOU ANNE LN	HAMILTON	76028	SYMMES	027300	273	21643.8115	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	160.2092	167.2691	164.3304	510	PERSON	FLETCHER RD 5.2944 AC R1-	620	0110						2026.2	66
062000900017	39	061	LOVELAND	OH	WERNER LANDSCAPE SERVICES INC	10460 TRUSTEE RD	HAMILTON	76028	SYMMES	024303	243.0300	11452.5200	39061C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	166.7381	179.0634	174.2300	499	BUSINESS	ES MILL RD 3.00 AC PT LOT	620	0090						2026.2	212