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 = 2070 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 = 2070 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 = 2070 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;

8249 County Road 167
Kenton, OH 43326
Debra Doll with Oakridge Realty & Auction Co., original listing - (419) 991-2020

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $425,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3754 Square Feet
Agency: Oakridge Realty & Auction Co.
Agency Phone: (419) 991-2020

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: MAJESTIC AND STUNNING!! This 5 bedroom 3 1/2 bath 2 story brick home on approximately 3 acres is ready to welcome the new family! <br /> If you are looking for a home with lots of space inside and out, this is it! <br /> Walk in and find open concept living with a magnificent kitchen boasting incredible Amish made cabinets, a large island, granite countertops, and lovely hardwood floors. There is a large space for family dining and opens into the family room area. The formal dining area is perfect for family get togethers and the additional living room is perfect for relaxation. <br /> Next find an incredible sunroom to entertain or enjoy afternoon naps, 2 bedrooms on the first floor with a primary bedroom and en suite, and a smaller bedroom. The other 3 bedrooms are located on the second floor. The staircase is original and shows the beauty of the hardwood and design. <br /> The huge laundry room is on the first floor and there is also a washer dryer hook up in the basement. <br /> All appliances stay! <br /> This home has a standing seam roof and Anderson vinyl windows, <br /> You have even more space with a partially finished basement. Central air is approximately 5 years old. <br /> You will have plenty of parking space with a 2 car attached garage and a massive concrete driveway designed with a welcoming approach. The large covered front porch and large back patio are all you need for enjoying the evenings in the country watching the wildlife. <br /> Professional landscaping completes this gorgeous home. <br /> Owner is putting in a new septic system. The home will be parceled with approximately 3.0 acres. <br /> You don't want to miss your chance to see this magnificent property!!!
MlsNumber: --
ListingId: 305108


Listing Provided By: Oakridge Realty & Auction Co., original listing
Phone: (419) 674-3342
Office Phone: (419) 991-2020
Agent Name: Debra Doll
Disclaimer: Copyright © 2024 West Central Association of Realtors. 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