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

761 Corbins Bend Road
Columbia, KY 42728

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $365,900
Beds: 2
Baths: 2
Status: Active
SqFt: 1404
Agency: eXp Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1984
Notes: **Serenity at the Lake: A Rare Gem on Green River Lake** Discover unparalleled tranquility and charm at this RARE find on Green River Lake, offering a year-round, breathtaking view of Holmes Bend. This once-in-a-lifetime opportunity awaits the next fortunate owner who will call this serene retreat home. Located just 1 mile from Holmes Bend Marina by road, yet within eyeshot from the front porch swing and family room window, this property combines convenience with serene lakefront living. Set on a beautifully landscaped 1.43-acre lot, this home is a haven for nature lovers. Enjoy ample shade, room for gardening, and your own private fishing pond in the backyard, creating an idyllic sanctuary. The dining room, featuring a cozy brick fireplace, offers warmth and comfort during chilly times and can easily be converted into an additional living space. This serene abode includes 2 bedrooms and 2 full baths, each offering views of the lake or the peaceful backyard sanctuary. The primary bedroom boasts an ensuite bath equipped with a shower and elegant tile, while the main bath features a luxurious jetted tub and ceramic tile. The kitchen is fully equipped with modern appliances, including a stainless steel refrigerator, dishwasher, oven range, and microwave, all complemented by newer luxury vinyl flooring. The generous family room, with its gas-burning stone fireplace, provides an inviting space to cozy up while gazing out the large bay window overlooking the lake. Step through the French doors to the private, shaded deck, perfect for relaxation and outdoor gatherings. Adjacent to the kitchen, the sunroom, with its vaulted ceiling, abundant windows, and ceramic tile floor, offers easy access to the deck and yard, making it an ideal space for dining or a quiet retreat. The circular driveway leads to a spacious 3-car garage with a tall door for an RV or boat, double door, and a partial attic for storage with pull-down stairs. Electric garage door openers and ample room ensure convenience and functionality. Two separate sheds in the backyard provide additional storage for gardening tools and equipment, enhancing the ease of maintaining this beautiful property. Embrace the serenity of lakefront living with this exceptional home on Green River Lake. It's not just a property; it's a lifestyle where every moment is filled with peace and natural beauty. Don't miss the chance to make this serene retreat your own. Welcome to your lakeside haven.
MlsNumber: SC45582


Listing Provided By: eXp Realty LLC, original listing
Name: eXp Realty LLC
Phone: (888) 624-6448
Office Name: eXp Realty LLC
Office Phone: (888) 624-6448
Agent Name: Regina Schaal
Disclaimer: Copyright © 2024 South Central 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 = 998 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