Saved query b2cb90fa7402c944

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

32,210 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	usedesc	taxacres	naicscode	parceltype	accesstype	placename	placetype	lrversion
39071-230900006400	39	071	7406 MAD RIVER RD	HILLSBORO	OH	45133	7406 MAD RIVER RD	HILLSBORO	OH	45133	Highland	43190	Liberty	954700	9547	14010.9391	1	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	344.2746	357.3634	351.4778	685: Exm-Public Woship	3.4500	62421			COMMON GROUND COMMUNITY CHURCH	CHRISTIAN_PLACE_OF_WORSHIP	2026.2
39071-090900004001	39	071	3801 U S 50	LYNCHBURG	OH	45142	3801 U S 50	HILLSBORO	OH	45133	Highland	22204	Dodson	954700	9547	174459.6834	12	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	306.8545	316.8414	314.0655	499: Com-Other	42.5600	23816			HIGGINS STEEL ROOFING	HOME_SERVICE	2026.2
39071-301500039800	39	071	5901 HOLLADAY RD	HILLSBORO	OH	45133	5901 HOLLADAY RD	HILLSBORO	OH	45133	Highland	55048	New Market	955200	9552	423055.9010	7	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD				101: Agr-Cash-Grain Farm	105	111	GOVT STATE	CLOSED	DOBBS AG TRUCKING	FARM	2026.2
39071-062500025701	39	071	6810 FAIR RIDGE RD	HILLSBORO	OH	45133	6810 FAIR RIDGE RD	HILLSBORO	OH	45133	Highland	18168	Concord	955102	9551.0200	83849.7635	0	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	311.3710	337.8104	326.3729	101: Agr-Cash-Grain Farm	20.6900						2026.2
39071-452300053800	39	071	651 MOWRYSTOWN SARDINIA RD	SARDINIA	OH	45171	3180 S R 321	SARDINIA	OH	45171	Highland	84826	Whiteoak	955200	9552	5271.8826	2	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	296.9382	297.8733	297.3345	511: Res-Custom Code	1.2100						2026.2
39071-410900034700	39	071	4504 BRIGGS RD	HILLSBORO	OH	45133	6664 MAD RIVER RD	HILLSBORO	OH	45133	Highland	78344	Union	954700	9547	251820.8503	1	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	316.8481	320.9621	319.5403	101: Agr-Cash-Grain Farm	59.5000						2026.2
39071-301930502000	39	071	U S 62	EAST HILLSBORO	OH	45133	4769 MAD RIVER RD	HILLSBORO	OH	45133	Highland	55048	New Market	955101	9551.0100	1497.0108	1	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	348.0913	349.1625	348.7307	499: Com-Other	0.3700						2026.2
39071-321200005000	39	071	12295 LADD RD	HILLSBORO	OH	45133	12303 LADD RD	HILLSBORO	OH	45133	Highland	59500	Paint	954500	9545	5761.5375	0	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	284.6922	290.9834	288.2340	599: Res-Other	1.4800						2026.2
39071-251000014404	39	071	HARRY SAUNER RD	HILLSBORO	OH	45133	20483 HICKORY LAKE	LIVONIA	MI	48152	Highland	43190	Liberty	954800	9548	3313.7800	0	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	308.1386	312.0671	310.5479	400: Com-Vacant Land	0.8200						2026.2
39071-090800009000	39	071	405 BOYLE RD	LYNCHBURG	OH	45142	405 BOYLE RD	LYNCHBURG	OH	45142	Highland	22204	Dodson	954700	9547	11646.1708	2	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	298.7780	303.4166	301.5107	511: Res-Custom Code	3						2026.2
39071-271000115500	39	071	1003 NORTH ST	GREENFIELD	OH	45123	PO BOX 92 GREENFIELD 45123	GREENFIELD	OH	45123	Highland	46452	Madison	954400	9544	631.4474	1	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	286.8551	287.5787	287.1124	510: Res-Single Family	0.1600						2026.2
39071-492410601100	39	071	4 MAIN ST E	MOWRYSTOWN	OH	45133	PO BOX 84 MOWRYSTOWN 45155	MOWRYSTOWN	OH	45155	Highland	84826	Whiteoak	955200	9552	292.3803	0	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	303.2192	303.5298	303.3971	510: Res-Single Family	0.0700						2026.2
39071-231510300300	39	071	5950 IVY HILL RD	HILLSBORO	OH	45133	5950 IVY HILL RD	HILLSBORO	OH	45133	Highland	43190	Liberty	955200	9552	2098.6736	1	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	296.5462	299.4949	298.2835	510: Res-Single Family	0.5300						2026.2
39071-090830001800	39	071	2691-2701 SHARPSVILLE RD	LYNCHBURG	OH	45142	PO BOX 407 LYNCHBURG 45142	LYNCHBURG	OH	45142	Highland	22204	Dodson	954700	9547	5683.6033	2	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	314.4747	316.3727	315.8107	510: Res-Single Family	1.0500						2026.2
39071-381300027500	39	071	2149 OREBAUGH RD	LYNCHBURG	OH	45142	2206 OREBAUGH RD	HILLSBORO	OH	45133	Highland	69862	Salem	954700	9547	21305.5504	2	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	312.0193	314.0791	313.1788	511: Res-Custom Code	5						2026.2
39071-233300103600	39	071	226 WOODLAND DR	HILLSBORO	OH	45133	226 WOODLAND DR	HILLSBORO	OH	45133	Highland	43190	Liberty	954900	9549	1808.9669	1	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	339.9280	345.2333	342.9970	510: Res-Single Family	0.4400						2026.2
39071-301900032300	39	071	4726 STRAIN RD	HILLSBORO	OH	45133	4780 STRAIN RD	HILLSBORO	OH	45133	Highland	55048	New Market	955200	9552	92637.0344	3	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	322.5877	332.0021	328.8767	101: Agr-Cash-Grain Farm	23						2026.2
39071-331690100700	39	071	11498 HIGHLAND HILLS DR	HILLSBORO	OH	45133	325 WHISPERING PINES DR	LOVELAND	OH	45140	Highland	59500	Paint	955002	9550.0200	1115.0789	2	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	275.9112	281.6652	279.2886	599: Res-Other	0.2800						2026.2
39071-331650006000	39	071	6653 GOLDEN DOUBLOON LN	HILLSBORO	OH	45133	62 U S	HILLSBORO	OH	45133	Highland	59500	Paint	955002	9550.0200	1951.0405	3	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	303.7118	307.6833	305.3563	540: Res-Custom Code	0.4800						2026.2
39071-230900008600	39	071	5565 MURRAY RD	HILLSBORO	OH	45133	5565 MURRAY RD	HILLSBORO	OH	45133	Highland	43190	Liberty	954700	9547	9981.0399	1	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	357.1049	361.2634	359.5413	511: Res-Custom Code	2.5000						2026.2
39071-254200114500	39	071	402 WALNUT ST W	HILLSBORO	OH	45133	402 W WALNUT ST	HILLSBORO	OH	45133	Highland	43190	Liberty	954800	9548	1086.6085	3	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	341.8527	343.5024	342.4697	510: Res-Single Family	0.2700						2026.2
39071-381800030201	39	071	2169 S R 131	HILLSBORO	OH	45133	2169 S R 131	HILLSBORO	OH	45133	Highland	69862	Salem	955200	9552	6922.3239	3	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	307.4954	309.9407	309.1387	511: Res-Custom Code	1.6200						2026.2
39071-254200115000	39	071	314 WALNUT ST W	HILLSBORO	OH	45133	314 W WALNUT ST	HILLSBORO	OH	45133	Highland	43190	Liberty	954800	9548	614.7517	1	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	338.0991	339.3454	338.6951	510: Res-Single Family	0.1500						2026.2
39071-120200002200	39	071	8968 HIGHROCK RD	LEESBURG	OH	45135	8968 HIGHROCK RD	LEESBURG	OH	45135	Highland	26026	Fairfield	954600	9546	46297.0518	4	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	300.5629	311.8458	305.6421	512: Res-Custom Code	11.1600						2026.2
39071-110840603500	39	071	260 EASTERN AVE	LYNCHBURG	OH	45142	6275 MCMULLEN RD	LYNCHBURG	OH	45142	Highland	22204	Dodson	954700	9547	809.4233	1	39071C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	313.1219	313.8802	313.5921	510: Res-Single Family	0.2000						2026.2