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

2696 Wilmington Road
Lebanon, OH 45036
Michael Wages with Irongate Inc., original listing - (937) 748-0000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,000,000
Beds: 5
Baths: Full: 3, ½: 2
Status: Active
SqFt: 5552 Square Feet
Agency: Irongate Inc.
Agency Phone: (937) 748-0000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1992
Notes: Welcome to a charming country estate that stands as a testament to both history and luxury. Nestled in the serene Turtlecreek Township, this one-of-a-kind twelve-acre property (two parcels!) promises a lifestyle of tranquility and rustic elegance. Historic Roots & Modern Comforts The estate features not one, but two distinct homes, including a historic log structure that harkens back to a bygone era. The fenced pastures and multiple outbuildings offer ample space for your equestrian pursuits or farming dreams. Main Residence: A Blend of Warmth & Style The main home greets you with a welcoming wrap-around deck, an inground pool perfect for leisurely relaxation or grand entertaining. Step inside to discover a spacious abode that boasts five well-appointed bedrooms—the master suite conveniently located on the first floor, complete with a cozy fireplace insert, expansive walk-in closets, and a custom bath that features a luxurious walk-in shower and a classic claw-foot tub. Upstairs: A Haven of Light & Space Ascend to the second level where four additional bedrooms await, each endowing occupants with walk-in closets and a flood of natural light. The large bonus room offers versatile space for storage or play, while skylights above add a touch of celestial glow. First Floor: Designed for Living & Entertaining The first floor houses an office adorned with built-in bookshelves and cabinets, setting the stage for productivity and organization. The heart of the home unfolds in the large open family and dining area, complete with French doors that invite the outdoors in and facilitate seamless entertaining. The kitchen, a culinary artist’s dream, is remarkably spacious, featuring a massive island. The main home is heated with geo-thermal heat. <br /> Carriage House: A short stroll from the main house, complete with two bedrooms, a full bath, two living areas, a kitchen, and its own second-story deck. This includes a two-car garage, adding to the convenience and charm.
MlsNumber: --
ListingId: 907900


Listing Provided By: Irongate Inc., original listing
Phone: (513) 465-5474
Office Phone: (937) 748-0000
Agent Name: Michael Wages
Disclaimer: Copyright © 2024 Dayton Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 2120 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;
Real Estate Expert Photo for Andrea Zellner
Andrea Zellner
ASCIIColdwell Banker Realty
Call Today!: (513) 978-3454

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App