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

215 John Evans Road
Oak Hill, OH 45656

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $459,900
Beds: 3
Baths: Full: 2, ½: 2
Status: Active
SqFt: 2514 Square Feet
Agency: Sherlock Homes Realty
Agency Phone: (740) 208-2095

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1999
Notes: Take advantage of this fantastic opportunity to own a stunning newer home with an even newer addition, offering 2,514 square feet of supremely finished living area in total. With virtually nothing left for the new owners to do but transfer utilities and move in, the current owners' attention to detail shines through with crown molding, solid six-panel doors, fluted casing, and upscale ceiling fans and light fixtures throughout. Speaking of utilities, enjoy the benefits of solar panels mounted to the detached garage which have reduced current electric costs (AEP) from approximately $3,600 per year to approximately $600 per year (solar panels will convey to new owners at an appropriate purchase price). Custom-crafted Amish built-in buffet and cabinetry in the dining room exactly matches the dining room table and chairs (built-in and table/chairs to convey to new owners). Find solid-surface countertops, custom cabinetry, subway tile backsplash, and top-of-the-line appliances in this sparkling kitchen with convenient breakfast bar. Nestled between the kitchen and attached garage find a slide-out waste receptacle beside the cleverly finished water heater surround and electrical service panel cover and a larger walk-in pantry with custom cabinetry and water softener only a few steps further. Attached garage features a ceiling-mounted radiant propane heater, window a/c, finished storage area with shelves for seasonal decorations, and space available for deep freezes, etc. Step onto the covered rear porch from the dining room to find a hot tub, space for outdoor furniture, and tastefully chosen outdoor ceiling fans and light fixtures. Upon entering the home, find a gorgeously finished built-in with LP gas log fireplace and custom barn doors to conceal a flat-screen television. Travel down the accessible 36" width hallway to discover bedrooms two and three and a lovely shared bath. The end of the hall is the beginning of your journey into a resplendent owners' suite, and reason for the recent addition, complete with bedroom, full bath with two closets, sitting area with LP gas log fireplace and four-pane thermal windows, and a private dressing room with vanity, built-in storage, and a walk-in closet of monumental proportions. Just beyond the sitting area, find a spacious rec. room with built-in desk and adjacent laundry room with half-bath, solid-surface countertops, and built-in drop-down ironing board. Behind the home, find a covered patio area at the start of the spacious four-bay detached garage with half bath, workshop, two-post lift, additional ceiling-mounted radiant LP heater, and a rear lean-to. Other features include a hardwired security system, a seven-course block foundation for a roomy crawlspace, double-width paved driveway with generous paved area behind home and detached garage, and much much more. To view all 57 photos of this property, copy and paste the following: https://bit.ly/215-John-Evans-RD
MlsNumber: --
ListingId: 178481


Listing Provided By: Sherlock Homes Realty, original listing
Phone: (740) 339-0973
Office Phone: (740) 208-2095
Agent Name: Matthew Ray
Disclaimer: Copyright © 2024 Huntington Board 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