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

450 Colyer Road
Bronston, KY 42518
Tonya M. Crawford with RE/MAX LakeTime Realty, original listing - (606) 679-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,100,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5823 Square Feet
Agency: RE/MAX LakeTime Realty
Agency Phone: (606) 679-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 16 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Luxury Custom Home!! Currently under construction, over 5800 sq ft, this massive lake lodge sits on 16 +/-<br /> private acres with 1000 linear feet of level LAKEFRONT, boasting a vaulted front porch with wood double door<br /> entry, 5 bedrooms and 5.5 baths this home has 2 ensuite bedrooms on the main level, spacious with tiled showers, Main primary is oversized and has a custom walk-in closet, luxury full bath with heated floors and access to a private covered and screened deck overlooking Lake Cumberland. The open floor plan great room offers a large stone fireplace, vaulted ceilings, large wall of windows, and access to a private covered and screened deck. The custom design gourmet kitchen offers high end fixtures, soft close cabinets, quartz countertops, custom island and stainless steel appliances. Spacious Laundry room located on the main level with a designated office. Cozy, spacious quarters for your guests are located upstairs. This space offers a full bathroom, family room and a spacious bedroom. The full finished walk out basement offers 12 foot ceilings, a large full service bar with massive granite countertop, gorgeous custom cabinetry, ice machine, multiple drink<br /> refrigerators, open space for entertaining, bedroom with ensuite and a mechanical room. Two sliding glass<br /> doors take you to the lower level patio where you can enjoy the outdoor gas fireplace and cook dinner on the<br /> built-in grill. If this isn't enough there is a 40 by 60 detached boat or RV garage with concrete floors and 14 foot<br /> doors. 2 HVAC units and 2 hot water heaters. Additional entrance to acreage possible on the east side of<br /> property. This property is a golf cart ride from Woodson Bend Resorts 18 hole Championship Golf Course.
MlsNumber: --
ListingId: 24024455


Listing Provided By: RE/MAX LakeTime Realty, original listing
Phone: (606) 271-2571
Office Phone: (606) 679-7653
Agent Name: Tonya M. Crawford
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 = 1097 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 Brandi King
Brandi King
ASCIILake Cumberland Real Estate Pros
Call Today!: (541) 998-1455

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App