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

1222 Mountain View Drive
Falls Of Rough, KY 40119

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $619,000
Beds: 3
Baths: 3
Status: Active
SqFt: 3328
Agency: BLUEGRASS REALTY PROS, INC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2001
Notes: The Rough River Lake retreat is a picturesque haven nestled on approximately 1.4 acres of land, boasting direct access to the tranquil waters of Rough River Lake via its own boat dock. This inviting property provides over 3,300 sq. ft. of meticulously designed living space, featuring 3 bedrooms for a comfortable and spacious retreat. Upon arrival, guests are welcomed by an expansive front porch, setting the tone for a warm and inviting atmosphere. The main living room impresses with its soaring vaulted ceiling and a cozy propane fireplace, creating a perfect gathering space for family and friends. The heart of the home lies in the spacious eat-in kitchen, adorned with new granite countertops, cabinets, and a pantry closet for convenient storage. The all-season room offers a unique charm with tongue and groove knotty pine walls and ceiling, showcasing picturesque views through new casement windows. Outdoor enjoyment is enhanced by a new 26 x 16 deck, complete with a roof over the grill area and a propane line for seamless entertaining. The primary bedroom serves as a private retreat, featuring a large walk-in closet and a luxurious en-suite bathroom with a double sink vanity, heated whirlpool tub, and a spacious shower. The finished basement adds versatility to the property, offering a living area with a stunning 17 ft rock wall and a 200-year-old mantle, complemented by a fireplace with a double wall stainless steel flue liner. Additional amenities include a third bathroom, a laundry room, a storm shelter area, and a versatile room suitable for an office or craft room. Outdoor enthusiasts will appreciate the 16 x 20 enclosed outdoor kitchen under a 30 x 40 new metal roof, while the insulated garage (30 x 40) adds practicality to the property. Modern conveniences such as internet access throughout, a new roof, HVAC system, tile floors, added insulation, new fireplace insert, and fresh paint contribute to the overall appeal. The property's attention to detail is evident in its double-wall, double-hung windows with casement crank outs and full screens, ensuring a seamless connection with the natural surroundings. This retreat on Rough River Lake seamlessly blends charming features with modern amenities, providing an ideal setting for both relaxation and entertaining against the stunning backdrop of Rough River Lake. Seller is providing a One Year Home Warranty to the buyer.
MlsNumber: HK24000886


Listing Provided By: BLUEGRASS REALTY PROS, INC, original listing
Name: BLUEGRASS REALTY PROS, INC
Phone: (270) 982-2400
Office Name: BLUEGRASS REALTY PROS, INC
Office Phone: (270) 982-2400
Agent Name: Chrystal Sadler
Disclaimer: Copyright © 2024 Heart of 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.


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 = 1040 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;
Real Estate Expert Photo for Sarah Smith
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App