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

487 Strange Road
Hodgenville, KY 42748

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $567,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1140
Agency: eXp Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential
Year Built: 2019
Notes: Discover your dream property on this expansive 7.4 acre oasis, offering an ideal blend of tranquility and convenience. His modern and well-maintained residence, constructed in 2019, provides the perfect backdrop for a relaxed and comfortable lifestyle. The heart of this home is a spacious living room and kitchen area featuring breathtaking 15 ft. Vault ceilings, creating a sense of openness and grandeur. The ample natural light that floods the space adds to the inviting atmosphere. With 2 full baths and 2 generous bedrooms, this home offers a comfortable and practical layout. The master bedroom boasts a walk-in closet and an attached bath, ensuring privacy and convenience for the homeowners. Technology enthusiasts will appreciate the fiber internet connectivity, allowing for seamless work and entertainment options. Additionally, the front porch is equipped with smart-controlled lights, ensuring ambiance at your fingertips. The property is further secured with a security camera and alarm system. For pet lovers, the dog fenced area attached to the home provides a safe space for your furry friends to roam freely. The property includes 2 pasture areas and 16ft gates, offering space for potential agricultural pursuits. The 24x32 barn on the property provides additional storage space and a run-in shelter for animal or equipment protection. Adding to the greatness, most furniture, the kitchen appliances, washer/dryer, mule, zero turn mower, and tiller all stay with the property. This property could potentially be zoned for Commerical use, making it an excellent investment property. Located just off Lincoln Parkway but tucked away on a peaceful back road, you’ll enjoy the best of both worlds! Easy access to town and all your essential amenities, while still relishing the tranquility of rural living. This property is ready to become the canvas for your ideal lifestyle. Don’t miss this rare opportunity town a piece of paradise that combines modern comforts with the serenity of the countryside.
MlsNumber: SC45022


Listing Provided By: eXp Realty LLC, original listing
Name: eXp Realty LLC
Phone: (888) 624-6448
Office Name: eXp Realty LLC
Office Phone: (888) 624-6448
Agent Name: Nita Logsdon
Disclaimer: Copyright © 2024 South Central Kentucky 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