Saved query 99df543d0fc5aa75

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

98,538 matching parcels

Data Preview

parcelid	statefp	countyfp	parcelstate	ownername	owneraddr	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	ownertype	legaldesc	parceltype	accesstype	placename	placetype	lrversion
276406 00CA	39	025	OH	LEGENDARY RUN BUILDERS INC	GRAND CYPRESS CT	CLERMONT	62540	PIERCE	041505	415.0500	4478.3870	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	259.2655	264.7388	262.8394	500	BUSINESS	GRAND CYPRESS AT LEGENDARY RUN …	PRIVATE	RESTRICTED	LEGENDARY RUN GOLF COURSE	PRIVATE PARK	2026.2
272813E126	39	025	OH	GOLF LEGENDARY RUN OHIO LLC	915 E LEGENDARY RUN	CLERMONT	62540	PIERCE	041505	415.0500	224384.3802	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	256.5727	273.2903	266.8995	463	BUSINESS	SPLIT SD 282813E126.	PRIVATE	RESTRICTED	LEGENDARY RUN GOLF COURSE	GOLF_COURSE	2026.2
323019B038	39	025	OH	U S A	MACEDONIA RD	CLERMONT	76155	TATE	041900	419	298369.4632	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	223.5068	261.8061	238.5992	600	GOVERNMENT		GOVT STATE	RESTRICTED	EAST FORK STATE PARK	STATE PARK	2026.2
032018D003	39	025	OH	U S A	2232 SLADE RD	CLERMONT	04157	BATAVIA	041001	410.0100	323723.8775	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	221.6997	259.6062	245.4542	600	GOVERNMENT		GOVT STATE	RESTRICTED	EAST FORK STATE PARK	STATE PARK	2026.2
323020K022	39	025	OH	U S A	WILLIAMSBURG BANTAM RD	CLERMONT	76155	TATE	041900	419	226764.2497	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	221.6997	260.3314	234.1776	600	GOVERNMENT		GOVT STATE	RESTRICTED	EAST FORK STATE PARK	STATE PARK	2026.2
022003A078	39	025	OH	STATE OF OHIO	STATE ROUTE 222	CLERMONT	04157	BATAVIA	041002	410.0200	12313.8923	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	165.2609	168.9427	168.0593	610	GOVERNMENT	ROW					2026.2
182518A169	39	025	OH	DEPT OF NATURAL RESOURCES	BRANCH HILL MIAMIVILLE RD	CLERMONT	49322	MIAMI	040401	404.0100	40418.0313	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	165.9486	189.9337	173.7820	610	GOVERNMENT	RAILROAD					2026.2
012016D017	39	025	OH	U S A	ELKLICK RD	CLERMONT	04157	BATAVIA	041001	410.0100	456697.3219	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD				600	GOVERNMENT		GOVT STATE	RESTRICTED	EAST FORK STATE PARK	STATE PARK	2026.2
523504C031	39	025	OH	U S A	TWIN BRIDGES RD	CLERMONT	85302	WILLIAMSBURG	040900	409	853527.2599	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD				600	GOVERNMENT		GOVT STATE	RESTRICTED	EAST FORK STATE PARK	STATE PARK	2026.2
182518B206	39	025	OH	STATE OF OHIO	INTERSTATE 275	CLERMONT	49322	MIAMI	040405	404.0500	33755.4393	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	207.9263	237.1440	228.5987	610	GOVERNMENT						2026.2
ROW	39	025	OH			CLERMONT	50176	MILFORD	040500	405	278324.9956	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	153.8283	211.5231	174.4716						NELA BREAD & PASTRY	CASUAL_EATERY	2026.2
ROW	39	025	OH			CLERMONT	49322	MIAMI	040301	403.0100	145328.7238	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	212.7473	249.4761	231.7094						MIAMI TRAILS HOA	SOCIAL_OR_COMMUNITY_SERVICE	2026.2
ROW	39	025	OH			CLERMONT	50176	MILFORD	040500	405	43523.6153	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	169.2230	173.8153	172.2815						LABCORP	DIAGNOSTIC_SERVICE	2026.2
ROW	39	025	OH			CLERMONT	31010	GOSHEN	040203	402.0299	57438.0280	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	240.0503	257.0649	254.8033						BLISSFUL BITES	CASUAL_EATERY	2026.2
403106F012	39	025	OH	BRATH PAUL D ETAL	BINNING RD	CLERMONT	78288	UNION	041307	413.0700	490556.3743	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD				199	PERSON						2026.2
403106E028	39	025	OH	EVANS GRAVEL INC	4985 BARRETT RD	CLERMONT	78288	UNION	041307	413.0700	541620.4312	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD				499	BUSINESS						2026.2
473402L073	39	025	OH	FALGNER JOSEPH C & CATHY	FAYETTEVILLE RD	CLERMONT	82110	WAYNE	040101	401.0100	41979.3640			—		295.7587	299.5492	297.6174	100	PERSON						2026.2
ROW	39	025	OH			CLERMONT	49322	MIAMI	040302	403.0200	26638.1795	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	229.7361	240.4888	235.9546								2026.2
ROW	39	025	OH			CLERMONT	04157	BATAVIA	041104	411.0400	10681.1411	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	260.5753	267.6341	264.4503								2026.2
ROW	39	025	OH			CLERMONT	04157	BATAVIA	041105	411.0500	11923.0217	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	260.6217	266.0993	263.4907								2026.2
ROW	39	025	OH			CLERMONT	31010	GOSHEN	040203	402.0299	35633.0683	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	233.3950	243.0621	236.4841								2026.2
GAP	39	025	OH			CLERMONT	49322	MIAMI	040401	404.0100	73874.0528	39025C	2025-12-11	AE	FLOODWAY	161.0139	167.4627	162.7225								2026.2
ROW	39	025	OH			CLERMONT	31010	GOSHEN	040203	402.0299	35973.5255	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	220.7164	233.4688	230.0869								2026.2
ROW	39	025	OH			CLERMONT	49322	MIAMI	040303	403.0299	16539.4726	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	248.2726	257.5585	252.8636								2026.2
ROW	39	025	OH			CLERMONT	78288	UNION	041307	413.0700	11499.1205	39025C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	234.1028	249.4742	243.1111								2026.2