Saved query 0676ade8811fe1f7

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

34/80

Live SQL

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

166,147 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	placename	placetype	lrversion
M5610005000019	39	017	GLENDALE	OH	CORNERSTONE UNITED METHODIST CH…	7600 PRINCETON GLENDALE RD	BUTLER	83150	WEST CHESTER	011112	111.1200	25172.5075	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	209.3947	225.0439	220.2334	685	NONPROFIT	2 2 6 SW COR	RESTORATION CHURCH	CHRISTIAN_PLACE_OF_WORSHIP	2026.2
Q6542084000012	39	017	YANKEE	OH	PILOT CHEMICAL CO	3439 YANKEE RD	BUTLER	49840	MIDDLETOWN	011300	113	104704.6694	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	202.8704	210.3133	206.6949	330	BUSINESS	16072 S 513.87 OF N 947.86	PILOT CHEMICAL COMPANY OF OHIO	MANUFACTURER	2026.2
M5620233000033	39	017	TAYLOR RIDGE	OH	CARUSO MEGAN E & DAVID R	5850 TAYLOR RIDGE DR	BUTLER	83150	WEST CHESTER	011129	111.2900	1575.9852	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	224.0344	233.1735	230.9866	510	PERSON	89 ENT THE SANCTUARY 1-C			2026.2
M5620130000164	39	017	DOUGLAS	OH	TAK CHRISTOPHER W	7140 DOUGLAS ST	BUTLER	83150	WEST CHESTER	011125	111.2500	793.2463	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	251.4887	253.1525	252.4467	510	PERSON	50 ENT			2026.2
B1320113000023	39	017	COLUMBUS	OH	LOCKER PEGGY D	2481 COLUMBUS DR W	BUTLER	33250	HANOVER	015000	150	1396.6989	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	224.8961	228.5794	227.3175	510	PERSON	256 ENT QUEEN AC			2026.2
M5620385000031	39	017	TRAVERSE	OH	SHIPLETT KATHY A	5206 TRAVERSE CT	BUTLER	83150	WEST CHESTER	011112	111.1200	2646.3528	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	233.4325	238.0301	236.1451	510	PERSON	284 ENT PROVIDENCE MANOR SEC 9			2026.2
A0700104000022	39	017	MARCEL	OH	DIXON KRISTIN M	10 MARCEL CT	BUTLER	25970	FAIRFIELD	010903	109.0300	1982.8352	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	194.6393	198.8214	197.1278	510	PERSON	10455 ENT			2026.2
R8000007000069	39	017	AUBURN	OH	FOLINO ALEC ANTHONY & MAVIS FOL…	407 AUBURN CT	BUTLER	77322	TRENTON	011800	118	1338.3845	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	202.9039	204.1362	203.7158	510	PERSON	3207 ENT			2026.2
E2220100000007	39	017	MIDDLETOWN	OH	881 MIDDLETOWN EATON ROAD LLC	MIDDLETOWN EATON RD	BUTLER	46340	MADISON	014300	143	2266.7396	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	251.7964	255.3785	253.1490	110	BUSINESS	7 ENT BURNSIDE SUB			2026.2
P6411115000008	39	017	EMERSON	OH	HOLLAND KENNETH J	881 EMERSON AVE	BUTLER	33012	HAMILTON	001002	10.0200	759.5631	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	197.5880	199.2521	198.2972	510	PERSON	19249 ENT			2026.2
P6411072000017	39	017	RANDOM	OH	SHELTON & SONS INC	RANDOM DR	BUTLER	33012	HAMILTON	001001	10.0100	3521.7516	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	208.4427	212.1765	210.7432	500	BUSINESS	30491 ENT RANDOM OAKS SEC 1			2026.2
A0700095000089	39	017	DAVID	OH	BROUGHTON ALEN CO TR & AMANDA C…	5722 DAVID PL	BUTLER	25970	FAIRFIELD	010910	109.1000	1463.1222	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	223.0043	226.1266	225.1770	510	TRUST	4754 ENT			2026.2
M5620151000005	39	017	OCEOLA	OH	CHAN GARY TR OF THE GARY CHAN I…	7657 OCEOLA LN	BUTLER	83150	WEST CHESTER	011127	111.2700	1816.1778	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	253.9968	255.7860	255.2893	510	TRUST	112 ENT LAKOTA HILLS			2026.2
H4100117000009	39	017	SANDRA	OH	OWENS BRYAN FRANKLIN TR ETAL	516 SANDRA DR	BUTLER	59241	OXFORD	010103	101.0300	1503.4023	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	271.9665	275.4498	273.9683	520	PERSON	1412 ENT			2026.2
P6411064000053	39	017	THALL	OH	DAVIDSON JOSHUA C & NICOLE D	1686 THALL DR	BUTLER	33012	HAMILTON	001001	10.0100	1511.8464	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	206.3221	209.0671	207.4588	510	PERSON	29289 ENT			2026.2
D2020187000039	39	017	RYAN	OH	INGRAM DANIEL J & LUREANA C	4276 RYAN CT	BUTLER	43050	LIBERTY	011134	111.3400	1687.2798	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	231.5484	233.8435	233.0340	510	PERSON	8 ENT RYAN ACRES			2026.2
P6412141000024	39	017	HILLCREST	OH	ALFRED LOIS	5 HILLCREST DR	BUTLER	33012	HAMILTON	001300	13	1001.3447	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	199.6236	205.1752	201.9179	510	PERSON	20110 ENT LESS N 174 FT			2026.2
A0700135000056	39	017	WEYMOUTH	OH	WILSON TIMOTHY A & SHARON L	30 WEYMOUTH PL	BUTLER	25970	FAIRFIELD	010912	109.1200	2345.7541	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	263.7523	265.6927	265.0810	510	PERSON	6703 ENT			2026.2
A0700196000086	39	017	MACK	OH	DEER RUN ESTATES OWNERS ASSN INC	MACK RD	BUTLER	25970	FAIRFIELD	010909	109.0900	4442.1163	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	218.8767	227.4092	223.9807	500	BUSINESS	9794 ENT			2026.2
M5620277000024	39	017	OLD STATION	OH	CARNES LEE R	6677 OLD STATION DR	BUTLER	83150	WEST CHESTER	011131	111.3100	2885.2522	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	210.6447	221.6641	217.7247	510	PERSON	189 ENT WEST CHESTER			2026.2
P6412042000010	39	017	HARTFORD	OH	PARTNERSHIPS FOR HOUSING INC	417 HARTFORD DR	BUTLER	33012	HAMILTON	014800	148	1574.0492	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	251.0132	259.3515	255.0985	680	BUSINESS	25564 ENT			2026.2
P6411052000155	39	017	KELLY	OH	PEART JACQUELINE S	79 KELLY CT	BUTLER	33012	HAMILTON	001001	10.0100	1348.6013	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	194.0792	195.6776	195.1390	510	PERSON	28133 ENT			2026.2
H4000122000106	39	017	MCGUFFEY	OH	JY HOMES LLC	650 MCGUFFEY AVE	BUTLER	59241	OXFORD	010103	101.0300	2037.0878	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	278.2287	280.3822	279.4111	401	BUSINESS	2076 ENT			2026.2
A0700220000091	39	017	MARSH	OH	POPE MICHAEL J JR & SONYA R	340 MARSH DR	BUTLER	25970	FAIRFIELD	010911	109.1100	1242.2069	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	172.5807	173.8306	173.2979	510	PERSON	12720 ENT			2026.2
M5620181000002	39	017	SUNDERLAND	OH	MCELROY JEANNETTE ELIZABETH & J…	9205 SUNDERLAND WAY	BUTLER	83150	WEST CHESTER	011110	111.1000	3448.0636	39017C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	220.9837	229.3411	225.7947	510	PERSON	259 ENT CRESTFIELD			2026.2