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 = 1049 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1049 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1049 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

1836 Ellis Rd
Eminence, KY 40019
Team Roberts with Torrey Smith Realty Co., LLC, original listing - (502) 633-0220

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $675,000
Beds: 5
Baths: Full: 2, ½: 1
Status: Active
SqFt: 4800 Square Feet
Agency: Torrey Smith Realty Co., LLC
Agency Phone: (502) 633-0220

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: FARMHOUSE CHARMER SITTING ON 2.36 ACRES JUST OUTSIDE OF TOWN!! This grand beauty has all of the character & space you have been searching for. The wrap around porch is idyllic for relaxing & taking in the surrounding views of countryside. Step into the large foyer with staircase & see the old world details that distinguish this home from the rest, including 10 ft ceilings, ornate wood trim, wood flooring, pocket door room separators, & a second staircase at back of home. Walking through you see that the spacious open rooms flow easily & have loads of natural light. The living room leads to a family/ sitting room with fireplace & large dining room. The kitchen has great work space with 2 pantries & newer appliances that include a gas stove with griddle & convection options. The first floor also includes an updated addition to the home that is the Primary Bedroom with double closets & ensuite bathroom that has a huge custom shower, laundry room, & is wheelchair accessible. The second bedroom on this level also has access to this bathroom. In addition the main level includes a great office space, half bath, & an amazing entertaining/relaxation space in the 24x30 screened in porch that is off the kitchen. There are front & rear staircases to access the second floor which leads you to 3 bedrooms with hard wood floors, elevated ceilings, & one having a large walk in closet space. The second floor full bath includes a claw foot tub & a great SECOND LAUNDRY ROOM!! This home has been well maintained with many of the big ticket items being newer including new roof last year, gutter guards, newer vinyl siding, & water heater just replaced. This home also includes a HEAT MASTER wood burning heating system option that brings the electric bill down drastically. By using this system you can heat the home & water with energy efficient wood burning abilities so the spacious home will never be cold in the winter & your large family will never run out of hot water all while keeping money in your pocket! Outside there are 2 outbuildings for storage & mature trees for shade. All of this on a private 2.36 acres surrounded by peaceful farmland. Property is in Shelby County but is a short drive to Shelbyville or Eminence. Property also has area where there was a previous trailer, so there is buried water access & separate septic tank that possibly could be used for a new construction garage/building. Call us to see this large family home in a great location with all the privacy you have been looking for!
MlsNumber: --
ListingId: 1672628


Listing Provided By: Torrey Smith Realty Co., LLC, original listing
Phone: (502) 321-5325
Office Phone: (502) 633-0220
Agent Name: Team Roberts
Disclaimer: Copyright © 2024 Greater Louisville 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.


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 = 1049 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App