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

290 Rosewood Drive
Lebanon, KY 40033

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $538,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2311
Agency: The Lancaster Agency Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2006
Notes: Here is a gorgeous custom-built home that catches your eye in the lavish Rosewood Estates neighborhood located next to the notorious Rosewood Golf & Country Club. Come on in to be greeted with a grand entrance from the foyer that showcases a sleek porcelain tile floor and robust crown molding. Then come relax in the cozy living room that is laid with a rich colored hardwood floor and is highlighted by the ornate gas-log fireplace and tremendous arched window that filters superb natural light and provides an incredible view of the lake! The kitchen is souped-up with an assortment of custom cabinets and features granite countertops, a beautiful island, a large pantry closet, and stainless-steel appliances. Rounding out the kitchen is an adorable breakfast nook offering breakfast with a view! Once meals are finished being prepared in the kitchen... bring those culinary delights into the formal dining room for an extravagant meal as this room has more first-class moldings, charming wainscoting walls, and a decorative tray ceiling. Conveniently located next to the kitchen is a sizable utility room supplemented with cabinet and counter space plus a handy sink! Nestled on its own wing of the home are 3 spacious bedrooms including a primary suite. The primary suite is furnished with his/her closets and is filled with more first-class finishes while the ensuite bathroom features a dual vanity and an amazing walk-in shower. There is another full bathroom off the hall to service the spare bedrooms and one of the bedrooms has snazzy built-ins for the option of having a nice home office. The tour continues down to the basement which offers an additional 1,023 Sq. Ft (+/-) of finished area. In the heart of the basement is an enormous recreation area for lots of fun and entertainment. The basement also has another generously sized bedroom and full bathroom plus lots of storage areas... not to mention the safe room and utility garage that is a perfect spot to keep the golf cart or work on those tinkering jobs. Then be sure to take a stroll through the enchanting courtyard on your way to the deck. Speaking of which... the deck is simply spectacular and is great for hosting and entertaining or just relaxing and taking in those stunning views of the lake... and just beyond the lake are more scenic views of the rolling countryside. You will also enjoy being able to sprawl out in the open backyard that backs right up to the lake. This place is even more beautiful in person and call CHASE LANCASTER to see it in person today!
MlsNumber: 11276354


Listing Provided By: The Lancaster Agency Inc, original listing
Name: The Lancaster Agency Inc
Office Name: The Lancaster Agency Inc
Office Phone: (270) 692-6748
Agent Name: Charles Lancaster, Jr
Disclaimer: Copyright © 2024 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

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