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

255 Begley Road
Crab Orchard, KY 40419
Curtis Brown with Keller Williams Commonwealth - Stanford, original listing - (859) 721-2121

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,699,999
Beds: 6
Baths: Full: 2
Status: Active
SqFt: 3840 Square Feet
Agency: Keller Williams Commonwealth - Stanford
Agency Phone: (606) 669-6200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 156 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Located on a sprawling 156 acres, this magnificent property offers a unique opportunity to own a slice Paradise. Featuring a spacious 3,840 sqft charming single-family home with 6 bedrooms, 2 bathrooms, a full finished basement and ample space for any family. The large backyard provides a perfect sitting for outdoor gatherings and relaxation while the pristine pond adds a touch of tranquility to the scenery. This fully operational farm comes with multiple buildings for equipment and storage as well as a garage and another building with living quarters. this farm provides endless possibilities escape the hustle and bustle of city life and embrace the peace and serenity of country living. Multiple cover crops and deer stands are hunt ready if your looking to chase top class whitetail and other wild game. This property is truly a rare gem that offers a harmonious blend of natural beauty and modern amenities don't miss this opportunity to own your own countryside retreat. This beautiful Amish built house was completely modernized about three years ago. some of the key features that a buyer would want to know is this home has all new electrical with a 400 amp service to the house that includes all new wiring, lighting and lighting fixtures. All new waterlines from the meter to the house and throughout the house. All of the appliances are newer. This comes with two sets of washers and dryers. New frost freeze water spigot and water ran to the barn. The kitchen has a really good sized pantry. This home comes with two hot water heaters. With a full price offer some of the farm equipment including a tractor, most of the tools in the garage, a one year home warranty will convey to the buyer at closing. This property has a creek running through it, one beautiful pond as well as a smaller pond in the field that is great for watering livestock and wild game such as deer and turkey. There is three seeded Cover crops as well as a stick built deer blind, and a few tree stands that will stay and makes this property hunt ready. Specifics of the buildings are followed: the barn has water and electric and the dimensions are downstairs is 54 x 48. The upstairs is 54 x 30 also has a 54 x 11 lean to. the blue building has electric and the dimensions are 40 x 24 with a lean to/overhang. The small white building has electric and the dimensions are 8 x 10. the bigger white building has electric and water and the dimensions are 32 x 16. the pole barn has electric and water and the dimensions are 74 x 18.
MlsNumber: --
ListingId: 24008273


Listing Provided By: Keller Williams Commonwealth - Stanford, original listing
Phone: (606) 669-4638
Office Phone: (859) 721-2121
Agent Name: Curtis Brown
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 = 1066 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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
Mobile: (241) 555-1812
Beware of the Bear - Look I am a Hooman

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App