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;

478 Bentwood Lane
Falls Of Rough, KY 40119

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $289,900
Beds: 2
Baths: 1
Status: Active
SqFt: 924
Agency: REAL DEAL REALTY LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2020
Notes: BIG PRICE REDUCTION AND A $10K INCENTIVE!!! Motivated Sellers! Offering a $10k appliance allowance!!! These 2 gorgeous corner lots in Bentwood Subdivision are perfect for entertaining inside and out. Inside this 924 sq' home, you'll find an 11' bourbon bar which is plumbed and wired for a kitchen. **The Sellers are offering a $10,000.00 KITCHEN ALLOWANCE!!! The main bar has a copper top and under counter stainless 2 bay sink. The back bar has a re-purposed walnut top, an antique mirror and black stainless beverage fridge. Seller upgraded the finishes in this home using 6" trim and crown molding, to recessed lighting and plumbing fixtures. There are windows galore with a beautiful southern exposure for lots of Winter sunshine and the Bentwood wildlife in your yard. A cozy wood stove with a stone backdrop heats the whole house and garage. The sellers think Winter is almost as much fun as Summer. *(central HVAC provided by electric heat pump keeps temperatures more than comfortable.) Well thought out floor plan has 2 bedrooms without closets so call them sleeping areas if you must. The bathroom has custom screen-printed wallpaper, a vanity with a concrete sink and a gorgeous 6’ soaking tub! The garage is 26x26 with 8' tall doors and 10' ceilings for easy boat storage. It also has a 13' workbench and a murphy bed for that one extra guest. Must see to appreciate! This has been a food and beverage bar to accommodate large crowds. So MANY options to utilize this space. Outdoor space is beautifully manicured with a semiprivate entrance through the side of the home. The front of the home that faces the lakeside has a large sturdy deck with built in seating. No lawn chairs are necessary. An area has been designed for the fire pit which does not interfere with traffic in or out of the home. Flat enough and with space for a volleyball net, corn hole or other outside lawn activities. This can be a perfect home, just as it is, for those wanting to play on the lake all day and grill a little at night or roast brats over the gianormous custom fire pit! Needing to bring a senior closer to you, yet let them live on their own? With this easy upkeep inside and perfect for pets, with the custom stained concrete floors, the issue of steps and mobility is practically eliminated. Photos can’t begin to describe how it makes you feel when you walk in. I have never seen anything like this on Rough River Lake. Who knows? You MAY start a trend
MlsNumber: HK23002361


Listing Provided By: REAL DEAL REALTY LLC, original listing
Name: REAL DEAL REALTY LLC
Phone: (270) 257-8818
Office Name: REAL DEAL REALTY LLC
Office Phone: (270) 257-8818
Agent Name: Dottie Watson
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