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

663 Waller Branch Road
Louisa, KY 41230
Robert Earl Snedegar with United Country Land & Lifestyle Realty, original listing - (606) 336-0494

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,000,000
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 2200 Square Feet
Agency: United Country Land & Lifestyle Realty
Agency Phone: (606) 336-0494

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 231 acre(s)
Property Type: Other-Farm
Year Built: 1915
Notes: Kentukcy land for sale with Home, horse barns, horse riding track, hay barn, tool sheds and various other outbuildings. Acreage consist of hollows, woodlands, hillsides, creek bottoms and ridges. Marketable Timber. Great Whitetail and Turkey Hunting. Free Natural Gas to the property owner. Great access to Hwy 23 and within approx 5 miles of downtown Louisa, approx. 35 minutes to Ashland Ky and 45 minutes Huntington WV. Call today to view. Discover Your Sanctuary in the Heart of Eastern Kentucky Mountains<br /> <br /> Nestled amidst the breathtaking mountains of Eastern Kentucky, this older yet meticulously maintained home offers a rare opportunity to embrace the tranquility of nature on 230+/- acres of pristine wilderness. With wooded hollows, rolling hillsides, and majestic ridges as your backdrop, every moment spent here is an immersion in natural beauty.<br /> <br /> A Hunter's Paradise and Nature Lover's Haven<br /> <br /> For the outdoor enthusiast, this property is a dream come true. Enjoy the thrill of deer and turkey hunting amidst the lush woodlands. The marketable timber ensures both recreational and economic value for generations to come. Additionally, the property boasts the rare benefit of free natural gas, providing comfort and convenience to the discerning homeowner.<br /> <br /> Equestrian Excellence and Country Living<br /> <br /> Beyond its natural allure, this property caters to the equestrian lifestyle with horse barns, a riding track, hay storage, and equipment sheds. Whether you're a seasoned rider or a novice enthusiast, these facilities offer endless opportunities for training, leisurely rides, or competitions.<br /> <br /> Conveniently Located, Yet Serenely Secluded<br /> <br /> While offering the tranquility of country living, this property remains conveniently accessible. Situated within easy reach of Hwy 23, it ensures seamless connectivity to Ashland, Kentucky, and Huntington, West Virginia. Experience the best of both worlds - a serene retreat amidst nature's bounty, with urban amenities just a short drive away.<br /> <br /> Your Gateway to Serenity<br /> <br /> Escape the hustle and bustle of city life and embrace the serenity of mountain living. Whether you seek a secluded getaway, a recreational paradise, or a haven for equestrian pursuits, this property offers endless possibilities. Don't miss the chance to make this slice of Eastern Kentucky paradise your own.
MlsNumber: --
ListingId: 24011309


Listing Provided By: United Country Land & Lifestyle Realty, original listing
Phone: (606) 336-0494
Office Phone: (606) 336-0494
Agent Name: Robert Earl Snedegar
Disclaimer: Copyright © 2024 Lexington-Bluegrass 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 = 1061 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