Saved query ce161b0772e85f49

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

101,260 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	taxacres	ownertype	naicscode	legaldesc	book	page	taxdistrict
16152810097	39	165	8507 OVERLOOK DRIVE	MAINEVILLE	OH	45039	BOARD OF TOWNSHIP	OVERLOOK DR	Warren	21238	DEERFIELD	032010	320.1000	837.0017	0	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	214.4577	225.1037	220.7479	630	0	GOVERNMENT	2372	FOSTER PARK LOT 348-350	0	0	9
16053540010	39	165	559 LAKESHORE DRIVE	MAINEVILLE	OH	45039	SUNRISE LAKE CLUB	559 LAKESHORE DR	Warren	33068	HAMILTON	032203	322.0299	1250.7782	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	227.4885	229.6474	229.0625	559	0	NONPROFIT	6112	SUNRISE LAKE BL A LOT 2 C A	281	752	26
16362510020	39	165	522 WEST CHURCH STREET	MASON	OH	45040	STATE OF OHIO FORFEITED L	MASON RD	Warren	48188	MASON	031907	319.0700	583.6553	0	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	249.0403	250.2914	249.5131	500	0	GOVERNMENT	1131	STEWARTS LOT 21	158	187	11
16144060060	39	165	2296 HOLLY ROAD	LOVELAND	OH	45140	CARTER WILLIAM E ISAB	CEDAR DR	Warren	21238	DEERFIELD	032010	320.1000	930.6341	0	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	216.8530	220.8076	219.2158	500	0	PERSON		LOVELAND PARK LOT 566-570	0	0	9
15063260070	39	165	6399 ROSEMONT LANE	MASON	OH	45040	GUPTA AASHVINI	6399 ROSEMONT LN	Warren	21238	DEERFIELD	031908	319.0800	1945.3319	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	261.5429	263.6605	262.7873	510	0.4807	PERSON		ROSEMONT 4 LOT 100	3290	870	8
16032010420	39	165	270 ANTIETAM BOULEVARD	MAINEVILLE	OH	45039	GEGESHIDZE IRAKLI	270 ANTIETAM BLVD	Warren	33068	HAMILTON	032202	322.0200	654.5610	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	239.4616	240.5577	240.2017	510	0.1603	PERSON		LIBERTY SPRINGS 5 LOT 123	5584	283	32
15063260160	39	165	6600 EVERGREEN COURT	MASON	OH	45040	DOBROWSKI MARK	6600 EVERGREEN CT	Warren	48188	MASON	031908	319.0800	1522.3034	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	262.5109	264.1850	263.6004	510	0.3637	PERSON		ROSEMONT MANOR LOT 31	5339	360	11
16121790170	39	165	5449 KINGS RIDGE WAY	KINGS MILLS	OH	45034	HEAGEN JOSEPH W	5449 KINGS RIDGE WAY	Warren	21238	DEERFIELD	032003	320.0299	1511.8301	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	229.7863	234.4338	231.9590	510	0.3734	PERSON		KINGS MEADOWS LOT 6	5456	770	9
16224550050	39	165	3294 SOCIALVILLE-FOSTERS ROAD	MAINEVILLE	OH	45039	FORGHAM SAMANTHA J	3294 SOCIALVILLE-FOSTER RD	Warren	21238	DEERFIELD	032003	320.0299	1317.9229	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	252.4753	255.8896	254.5370	510	0	PERSON		STRAWBERRY HILL LOT 12	5297	666	9
17242020110	39	165	5115 APPALOOSA CIRCLE	MORROW	OH	45152	STEGEMAN ROBERT W MAR	5115 APPALOOSA CIR	Warren	33068	HAMILTON	032206	322.0600	857.9411	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	205.7476	209.4241	207.9315	510	0.2015	PERSON		SADDLEBROOK 1 LOT 45	3590	80	26
12251770270	39	165	4649 OAKLAND COURT	MASON	OH	45040	WINDEMERE HOMEOWNERS	OAKLAND CT	Warren	48188	MASON	031905	319.0500	7616.2481	0	39165C	2025-12-11	AE	FLOODWAY	219.9621	227.4865	222.5986	559	1.8776	PERSON		WINDEMERE P U D 4 LOT C A 114	4271	469	11
13263510330	39	165	1391 ARAPAHO DRIVE	MORROW	OH	45152	WILLIS RYAN JESSIE K	1391 ARAPAHO DR	Warren	78610	UNION	032100	321	6170.5044	2	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	233.3394	240.7523	238.7712	510	1.5156	PERSON		SHAWHAN TRAILS 4 LOT 64	3583	906	66
16351760060	39	165	518 DUANE DRIVE	MASON	OH	45040	MOUNTS RICHARD H SUSA	518 DUANE DR	Warren	48188	MASON	031904	319.0400	2005.6734	2	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	252.5234	255.3020	254.5698	510	0	PERSON		MANHASSET VILLAGE 5 LOT 119	1283	141	11
17363190440	39	165	297 EVERWOOD DRIVE	MAINEVILLE	OH	45039	BICKEL DAVID L CHERYL	297 EVERWOOD DR	Warren	33068	HAMILTON	032204	322.0400	899.7370	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	254.6025	256.7617	255.9711	510	0.2220	PERSON		MICHELS FARM 4 LOT 266	3317	175	26
16361170040	39	165	5829 GRAZING COURT	MASON	OH	45040	MARTIN ALEXANDER J	5829 GRAZING CT	Warren	48188	MASON	031908	319.0800	1581.6101	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	252.6939	254.0811	253.4471	510	0.3902	PERSON		BIRCHWOOD FARMS 5 LOT 120	966	754	11
12193700050	39	165	3892 GRANITE COURT	MASON	OH	45040	VIDWANS MAKARAND V	3892 GRANITE CT	Warren	48188	MASON	031905	319.0500	1481.0053	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	238.8885	241.1607	240.3125	510	0.3660	PERSON		WEATHERSTONE 1 LOT 35	3769	177	11
14303000090	39	165	125 SETTLEMYRE ROAD	OREGONIA	OH	45054	FISHER KELLY ELIZABETH	SETTLEMYRE RD	Warren	81690	WASHINGTON	031100	311	18670.8722	0	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	296.3532	303.7356	300.0551	501	5	PERSON		MS- 828	1115	966	85
17343150160	39	165	503 FAWN COURT	MAINEVILLE	OH	45039	O BRIEN JOHN M GWENDO	503 FAWN CT	Warren	33068	HAMILTON	032205	322.0500	777.6318	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	245.7129	247.2529	246.7146	510	0.1913	PERSON		SALT RUN MEADOW BL C LOT 72	1129	831	32
16241760460	39	165	708 SHERWOOD GREEN COURT	MASON	OH	45040	JELN ENTERPRISES LLC	708 SHERWOOD GREEN CT	Warren	48188	MASON	031905	319.0500	112.7308	0	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	247.8535	248.6783	248.0898	550	0	BUSINESS	3212	SHERWOOD GREEN CON 2 LOT 34	4913	856	11
15063550260	39	165	6476 GLENSTONE WAY	MASON	OH	45040	BANERJEE RAJU C	6476 GLENSTONE WAY	Warren	21238	DEERFIELD	031908	319.0800	1512.9706	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	265.2133	266.7956	265.9945	510	0.3738	PERSON		ROSEMONT SOUTH LOT 62	5558	385	8
14021000050	39	165	2895 ST RT 133	MORROW	OH	45152	COLLINS MICHAEL W	2897 ROUTE 133	Warren	81690	WASHINGTON	031100	311	15153.7288	3	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	273.3339	284.3772	281.6259	511	3.7354	PERSON		CEDAR RIDGE ESTATE 1 LOT 8	5105	840	74
12322400190	39	165	3478 BROKEN RIDGE DRIVE	MASON	OH	45040	LOCKHART BRAD S	3478 BROKEN RIDGE DR	Warren	48188	MASON	031907	319.0700	10682.6617	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	216.3173	226.6698	221.3818	510	2.6500	PERSON		CROOKED TREE EST 4-A LOT 101	2243	20	11
17364550430	39	165	771 GRANDE OAKS DRIVE	MAINEVILLE	OH	45039	VESCIO MICHAEL A JR	771 GRANDE OAKS DR	Warren	33068	HAMILTON	032205	322.0500	830.3505	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	248.4898	250.2587	249.5599	510	0.2043	PERSON		TWENTY ONE OAKS LOT 12	5654	32	26
17292510190	39	165	6501 NORTH ANDOVER WAY	MAINEVILLE	OH	45039	CHUMBLEY CHRISTOPHER	6501 NORTH ANDOVER WAY	Warren	33068	HAMILTON	032205	322.0500	1183.0324	1	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	256.6811	258.2260	257.4409	510	0.2916	PERSON		WEDGWOOD BLK G LOT 276	4080	659	26
12012060042	39	165	456 LEBANON ROAD	SOUTH LEBANON	OH	45065	EVE DARBIE GREER	LEBANON RD	Warren	78610	UNION	032100	321	465.6954	0	39165C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	196.3345	197.1694	196.5661	500	0	PERSON		MCBURNEYS ADD LOT 9	4431	827	68