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

4603 Ky 1803
Barbourville, KY 40906
C Eugene McCowan with WEICHERT REALTORS - Ford Brothers, original listing - (606) 878-7112

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $989,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2082 Square Feet
Agency: WEICHERT REALTORS - Ford Brothers
Agency Phone: (606) 878-7112

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 138 acre(s)
Property Type: Other-Farm
Year Built: 1969
Notes: In my 20+ years in real estate, I have never seen a more beautiful or immaculate farm. The all-brick 2000+ sq. ft. home has hardwood flooring throughout. Some of the home's impressive features include a beautifully renovated kitchen, spacious master bedroom with large sitting area, large walk-in closet and updated bath. The home uses free gas from an onsite gas well for heating and appliances. There is a 1300 sq. ft. basement which has been used as a woodworking shop. Near the house is a newly-built 1120 sq. ft. metal building, also using gas from the gas well, with a 320 sq. ft. covered front porch, designed for family fun or entertaining large groups of people. Directly across the street is a large, renovated barn, which could be ideal for a wedding venue. The surounding 70 acres of level, highly productive land is good for any type of crops and the 60+ acres of wooded hills has an abundance of wildlife including deer, turkey, and beaver. Added to this idyllic setting is a gently flowing creek at the foot of the hills. Being only 25 minutes from all four surrounding towns, the location is perfect! Property like this does not come around very often. Call today!
MlsNumber: --
ListingId: 25002047


Listing Provided By: WEICHERT REALTORS - Ford Brothers, original listing
Phone: (606) 309-3807
Office Phone: (606) 878-7112
Agent Name: C Eugene McCowan
Disclaimer: Copyright © 2025 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App