Saved query dd375fcf162d4599

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

26,939 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	usecode	usedesc	taxacres	naicscode	placename	placetype
39027-220110101B01000	39	027	104 W MAIN ST	BLANCHESTER	OH	45107	107 N BROADWAY ST	BLANCHESTER	OH	45107	Clinton	47670	Marion	964900	9649	545.5617	1	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	294.9298	295.5390	295.2391	499: Com-Other	499: Com-Other	0.1400	458	THE WATERMELON SEED CONSIGNMENT…	FASHION_AND_APPAREL_STORE
39027-290170129000000	39	027	1499 ROMBACH AVE	UNION	OH	45177	1763 HALPIN ROAD	CLARKSVILLE	OH	45113	Clinton	85792	Wilmington	964502	9645.0200	18977.6907	0	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	322.0815	325.3978	323.1562	685: Exm-Public Woship	685: Exm-Public Woship	4.6800	8131	DOVE CHURCH WILMINGTON	CHRISTIAN_PLACE_OF_WORSHIP
39027-220081513000000	39	027	839 E CHERRY ST	BLANCHESTER	OH	45107	619 S BOURBON ST	BLANCHESTER	OH	45107	Clinton	47670	Marion	964900	9649	14224.3704	2	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	296.1718	297.8577	297.1493	412: Com-Nursing Home	412: Com-Nursing Home	3.5300	6233	THE LAURELS OF BLANCHESTER	SENIOR_LIVING_FACILITY
39027-270011909000000	39	027	1361 GURNEYVILLE RD	UNION	OH	45177	1361 GURNEYVILLE RD	WILMINGTON	OH	45177	Clinton	78302	Union	964400	9644	33852.0029	5	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	301.9091	313.8052	309.7788	111: Agr-CAUV-Cash-Grain Farm	111: Agr-CAUV-Cash-Grain Farm	8.4600	23817	TH SOLUTIONS, LLC	HOME_SERVICE
39027-290240302000100	39	027	58 S WALNUT ST	WILMINGTON	OH	45177	C O CVS HEALTH CORP ONE CVS D	WOONSOCKET	RI	02895	Clinton	85792	Wilmington	964600	9646	6124.7136	1	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	306.2840	308.5064	307.4866	429: Com-Other	429: Com-Other	1.5200	45611	CVS PHARMACY	PHARMACY_AND_DRUG_STORE
39027-220101501000300	39	027	111 BOURBON ST	BLANCHESTER	OH	45107	7368 SR 123	BLANCHESTER	OH	45107	Clinton	47670	Marion	964900	9649	748.6464	2	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	290.9348	292.7285	292.2598	420: Com-Retail-Small	420: Com-Retail-Small	0.1800	54143	GUN LASER ENGRAVING	DESIGN_SERVICE
39027-270011918000000	39	027	1581 CURRY RD	UNION	OH	45177	46 S SOUTH ST	WILMINGTON	OH	45177	Clinton	78302	Union	964400	9644	129366.9690	9	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	309.0447	318.9457	314.8343	620: Exm-County	620: Exm-County	32.5400	488119	CLINTON COUNTY REGIONAL AIRPORT	AIRPORT
39027-220080904000000	39	027	940 CHERRY ST		OH	45107	2801 EAST BELTLINE NW	GRAND RAPIDS	MI	49525	Clinton	47670	Marion	964900	9649	163614.9012	8	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	296.2539	301.9786	298.7126	330: Ind-Manufacturing-Medium	330: Ind-Manufacturing-Medium	39.7000	4552	UFP PACKAGING	WAREHOUSE_CLUB_STORE
39027-290210202C00900	39	027	179 COLLEGE ST	WILMINGTON	OH	45177	179 COLLEGE ST	WILMINGTON	OH	45177	Clinton	85792	Wilmington	964600	9646	839.8376	1	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	313.3283	315.0529	314.3731	510: Res-Single Family	510: Res-Single Family	0
39027-160081301000000	39	027	299 SYCAMORE RD	JEFFERSON	OH	45148	299 SYCAMORE RD	MIDLAND	OH	45148	Clinton	38542	Jefferson	965000	9650	22798.1705	2	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	300.8992	302.6797	301.8788	511: Res-Custom Code	511: Res-Custom Code	5.6300
39027-250060241D00100	39	027	ROLFE DR	SABINA	OH	45169	290 ROSE AVE SABINA	SABINA	OH	45169	Clinton	66642	Richland	964300	9643	435.1093	0	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	317.0574	317.3497	317.1906	500: Res-Vacant Land	500: Res-Vacant Land	0.1000
39027-220101032000000	39	027	240 W FANCY ST	BLANCHESTER	OH	45107	240 W FANCY ST	BLANCHESTER	OH	45107	Clinton	47670	Marion	964900	9649	957.0740	1	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	286.5305	291.3077	289.8058	510: Res-Single Family	510: Res-Single Family	0.2000
39027-070031403000000	39	027	464 WEST RD	CLARK	OH	45146	230 N SYCAMORE ST	LYNCHBURG	OH	45142	Clinton	15238	Clark	965100	9651	21499.2305	1	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	318.2827	330.8544	325.3913	599: Res-Other	599: Res-Other	5.1300
39027-250060340000900	39	027	ROSHON AVE	SABINA	OH	45169	155 ROSHON AVE SABINA	SABINA	OH	45169	Clinton	66642	Richland	964300	9643	1053.1646	0	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	319.4749	320.2758	319.7157	500: Res-Vacant Land	500: Res-Vacant Land	0
39027-290230101018F00	39	027	724 MEAD ST	WILMINGTON	OH	45177	3802 N 27TH ST APT 128	PHOENIX	AZ	85016	Clinton	85792	Wilmington	964700	9647	680.7174	2	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	311.1437	311.9768	311.6903	510: Res-Single Family	510: Res-Single Family	0
39027-300031516000000	39	027	387 REEDER RD	VERNON	OH	45107	387 REEDER RD	BLANCHESTER	OH	45107	Clinton	79772	Vernon	964800	9648	37053.9228	3	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	286.5546	299.5212	296.1223	511: Res-Custom Code	511: Res-Custom Code	9.1700
39027-290150421000400	39	027	N MULBERRY ST	WILMINGTON	OH	45177	204 N MULBERRY ST	WILMINGTON	OH	45177	Clinton	85792	Wilmington	964600	9646	654.3412	0	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	304.7090	307.4469	306.3932	500: Res-Vacant Land	500: Res-Vacant Land	0
39027-015011008000000	39	027	152 LEBANON RD	ADAMS	OH	45113	152 LEBANON RD	CLARKSVILLE	OH	45113	Clinton	00226	Adams	964400	9644	10389.6546	3	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	260.4819	265.6899	264.0417	510: Res-Single Family	510: Res-Single Family	2.5000
39027-030060610000000	39	027	5979 SR 73	CHESTER	OH	45177	5979 SR 73 W	WILMINGTON	OH	45177	Clinton	13974	Chester	964400	9644	27677.9291	1	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	292.2269	303.8229	298.2127	510: Res-Single Family	510: Res-Single Family	6.8100
39027-350020703000000	39	027	715 SNOW HILL RD	WAYNE	OH	45169	715 SNOW HILL RD SABINA	SABINA	OH	45169	Clinton	82124	Wayne	964300	9643	8094.6058	1	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	316.8384	317.9161	317.3714	511: Res-Custom Code	511: Res-Custom Code	2
39027-210041110002400	39	027	HERITAGE WOODS DR	MARION	OH	45107	9916 COZADDALE MURDOCK RD	LOVELAND	OH	45140	Clinton	47670	Marion	964900	9649	5284.4632	0	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	292.3759	294.9913	293.7530	500: Res-Vacant Land	500: Res-Vacant Land	1.5100
39027-300040234000000	39	027	4092 PANSY RD	VERNON	OH	45113	4092 PANSY RD	CLARKSVILLE	OH	45113	Clinton	79772	Vernon	964800	9648	8095.3562	2	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	277.6906	279.9811	278.9518	511: Res-Custom Code	511: Res-Custom Code	2
39027-190051802000000	39	027	GANO RD	LIBERTY	OH	45177	PO BOX 271 WILMINGTON 45177	WILMINGTON	OH	45177	Clinton	43064	Liberty	964400	9644	51506.4886	0	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	312.9992	315.3810	313.9875	400: Com-Vacant Land	400: Com-Vacant Land	12.5300
39027-290210420000000	39	027	946 FIFE AVE	WILMINGTON	OH	45177	946 FIFE AVE	WILMINGTON	OH	45177	Clinton	85792	Wilmington	964700	9647	756.2546	1	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	319.8002	321.4787	320.7223	510: Res-Single Family	510: Res-Single Family	0.2300
39027-290211326A00800	39	027	445 S WALNUT ST	WILMINGTON	OH	45177	13801 WIRELESS WAY	OKLAHOMA CITY	OK	73134	Clinton	85792	Wilmington	964700	9647	536.8777	1	39027C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	314.2908	314.8101	314.6394	510: Res-Single Family	510: Res-Single Family	0