Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2109 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2109 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2109 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

1318 County Road 32
Helena, OH 43435
Laura Lay with Howard Hanna, original listing - (440) 282-8002

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $439,000
Beds: 3
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1844 Square Feet
Agency: Howard Hanna
Agency Phone: (440) 282-8002

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1900
Notes: Welcome home to 1318 County Rd 32 in Helena, OH. Get ready to fall inlove with this beautiful farmhouse that has the perfect blend of rustic charm & modern comforts. Step onto your cozy front porch totake in all the rural scenic views. Through the original front door, you will be greeted with your new dream home that boast 3 bedrooms and 1.5 baths. The formal dining room has an abundance of natural lighting through the huge windows, and you will find the original fireplace in here as well. Onto the office , where you will see some of the beautiful built-ins that add so much character to the home. Next, you will find the open living room that looks into the remodeled kitchen which would be ideal for hosting. The kitchen has modern, white cabinets, and gorgeous white quartz countertops. Complete with an island and farmhouse touchless sink for your convienence. You will also find the full bath on the first floor complete with a tub/shower combo. Going upstairs, you will find the cutest nook, along with 3 spacious bedrooms and a half bath. The master bedroom has a huge walk in closet & great natural lighting! This home has it all. Outside you will find a brand new 60x80 pole barn with 14' garage doors built in 2023 with access to pull through the front and back. The older livestock barn is still in great condition, and is already set up with a hay loft, chicken coop, and tons of extra space for whatever you like! There is a 2+ car detached garage as well with an additional closed in room that has endless possibilities. Don't forget the enclosed gazebo off the patio of the garage that houses the huge hot tub. You will never get sick of these views! If you're looking for a tranquil environment and seeking a slower paced life you won't want to miss this !
MlsNumber: --
ListingId: 11366293


Listing Provided By: Howard Hanna, original listing
Phone: (419) 202-3762
Office Phone: (440) 282-8002
Agent Name: Laura Lay
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App