Title Page Background
DEBUG FN args: Array ( [0] => 1112 [1] => [2] => [3] => agent ) BEFORE: Site: 1112 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1112 Igate: njhud LocID: 1112 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1112 AND i.igate IN ('cahud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1112 [1] => [2] => [3] => lender ) BEFORE: Site: 1112 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1112 Igate: njhud LocID: 1112 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1112 AND i.igate IN ('cahud','usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1112 [1] => [2] => [3] => other ) BEFORE: Site: 1112 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1112 Igate: njhud LocID: 1112 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1112 AND i.igate IN ('cahud','usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

195 Cedar Ridge Ln
Willisburg, Washington, KY 40078
Steven P Wharton with Mcelroy Wharton & Boldrick RE LLC, original listing -

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $759,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2040 Square Feet
Agency: Mcelroy Wharton & Boldrick RE LLC
Agency Phone:

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 48 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 2009
Notes: 281 Cedar Ridge Lane -North Washington Co. (2 miles or less to the Blue Grass Parkway/Exit 42 -- only 40 min. to Louisville or Lexington) 48 ACRE FARM (selling as a whole), w/ 16 yr. old, custom-built ranch home (281 Cedar Ridge Ln.) featuring a full, walkout basement and a full perimeter, wrap-around, covered porch with hand-stamped concrete floor. Behind this home is a 4 bay (42'X 22') detached metal garage/building. This home has 3 bedrooms and 2 bathrooms on the first floor, a charming, very spacious great room and dining area adjacent to an "extremely tidy, custom kitchen" with an island (step-in pantry) and another dining area joining the kitchen. All kitchen appliances can remain. Also, on the first floor is a laundry/utility area, a small, private office area, AND a separate, small den at the front of the house. This floorplan has 2 bedrooms on one end of the home and the main suite (w/ gorgeous walk-in shower & spacious walk-in closet) on the other. The basement offers over 2,000 sq. ft. of climate-controlled space, unfinished, except for a full bathroom. The grounds and home have been beautifully maintained. Gorgeous, hand-scraped wood flooring, Geothermal (ground loop heat), boasting extreme efficiency and the views are "breath-taking." There is a SECOND RESIDENCE SITE complete with a 1976 Fairmont model, manufactured home measuring 14' X 70' (address is 170 Cedar Ridge Lane). This unit is in modest condition and in need of rehabilitation, however, it has complete septic system (new in 2004), county water service and electric service in place. Next to this home, is a wood-sided barn (46'X 35') and covered machinery/tool shed (48'X20'). Directly across the lane is a beautiful, well-stocked pond, just behind a productive garden spot. This 48 ACRE parcel offers excellent HUNTING, hiking, and farming opportunities. Most of the perimeter of the farm is fenced (fence condition is minimal to decent shape). 40% is gorgeous, open pasture land and 60% of the farm is woodland. ****NUMEROUS, GORGEOUS HOME SITES.***** All of this for $759,000.!!!
MlsNumber: --
ListingId: 11447569


Listing Provided By: Mcelroy Wharton & Boldrick RE LLC, original listing
Phone: (859) 336-3982
Agent Name: Steven P Wharton
Disclaimer: Copyright © 2025 My State MLS. 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => washington [3] => KY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: washington State: KY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: washington State: KY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1112 AND i.igate IN ('cahud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) 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