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

4280 Lexington Road
Lancaster, KY 40444
Kim Hurst with Kentucky Properties Realty Group, original listing - (859) 548-2007

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,790,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 6068 Square Feet
Agency: Kentucky Properties Realty Group
Agency Phone: (859) 548-2007

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 30 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Welcome to your personal oasis, where elegance meets tranquility. <br /> <br /> This stunning property features a 6,000+ sq. ft. residence with a 6 car garage, 9400+ sq ft metal barn with 2100+ sq. ft. of living space all sitting on 30+ acres!<br /> <br /> The main resident boasts five spacious bedrooms and four and a half lavish baths, perfectly designed for both comfort and sophistication. As you step inside, be greeted by the grand entry featuring coffered, tray ceilings that set the tone for this exquisite home. The expansive dining room offers the perfect setting for unforgettable gatherings featuring a wood accent wall, while the rich wood flooring throughout the main living areas enhances the warmth and charm of the space.<br /> <br /> The gourmet kitchen is a chef's delight, equipped with top-of-the-line built-in appliances, an oversized island, ample custom European cabinetry, a butler's pantry, and walk -in pantry for all your culinary needs. Whether you're preparing a casual meal or hosting an elegant dinner party, this space seamlessly flows into the inviting living room w/vaulted ceilings flanked w/wood beams, a brick fireplace & large windows that bathe the area in natural light & offer picturesque views of the surrounding landscape.<br /> <br /> The main-floor primary suite is a true retreat, showcasing breathtaking views of the lush landscape and shimmering inground pool. Indulge in the en-suite bathroom, complete with dual vanities, two generous walk-in closets, a porcelain-tiled shower, and a separate soaking tuba perfect escape after a long day. Additionally on the main floor, there is a beautiful office space with custom built-in cabinets, two spacious bedrooms complete with a large walk-in closet, providing ample storage and organization. Enjoy the convenience of en-suite bathrooms, each featuring double sink vanities and sleek, step-in tile showers, creating a spa-like retreat for your guests. <br /> <br /> Upstairs, entertain at a custom wood bar with brick accent wall, wood shelving and a sitting area for more seating . There is also an exercise room and 2 additional bedrooms with walk-in closets and a full bathroom with tiled shower, double vanity, and soaker tub. <br /> <br /> When you step outside to your private paradise, enjoy the sprawling outdoor area featuring an extensive covered outdoor living space featuring a coffered ceiling, a stone, gas fireplace, a stunning inground pool, hot tub and cabana area surrounded by lush landscaping, ideal for summer entertaining or quiet relaxation. The expansive grounds provide plenty of space for recreational activities, gardening, or simply enjoying the beauty of nature.<br /> <br /> But wait...there's more! If you wanted to host your own weddings, reunions, need storage or an event space, you will love the 86x120 metal building finshed out with a storage area, roughed in bar area and a barndominium with kitchen, great room, fireplace, 2 bedrooms and 1.5 baths-perfect for guests to enjoy their own private space. <br /> <br /> Set on over 30 acres of pristine land, this luxurious property offers privacy and endless possibilities. Imagine exploring nature trails, cultivating your own gardens, or even creating your own equestrian facilities. Whether you envision hosting lavish soirées by the pool or enjoying serene evenings under the stars, this home is designed for a lifestyle of leisure and elegance.<br /> <br /> Don't miss the opportunity to make this dream home your reality. Come experience the perfect blend of luxury, comfort, and natural beauty!
MlsNumber: --
ListingId: 24025445


Listing Provided By: Kentucky Properties Realty Group, original listing
Phone: (859) 983-6051
Office Phone: (859) 548-2007
Agent Name: Kim Hurst
Disclaimer: Copyright © 2024 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.


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 = 1037 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 (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App