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;

2385 Pikes Ridge Road
Columbia, KY 42728
Amanda Long with KELLER WILLIAMS HEARTLAND, original listing - (270) 685-3705

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,700,000
Beds: 3
Baths: Full: 3, ½: 3
Status: Active
SqFt: 2640 Square Feet
Agency: KELLER WILLIAMS HEARTLAND
Agency Phone: (270) 685-3705

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 88 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 2019
Notes: Welcome to the Lakeview Barn & Lodge where you, your friends and family are invited to a once in a lifetime opportunity featuring a Wedding Venue that overlooks the beautiful Green River Lake, 88 +/- acres of mainly woods, a Pond with a lightened fountain and water fall. The timber-framed barn features exterior and interior wood siding, a metal roof, vaulted ceilings, Mezzanine with spiral staircase, exposed wood and steel beams, sliding barn doors with picture windows overlooking the breathtaking views of Green River Lake, stained and sealed concrete floor, public Men's and Women's Restrooms, Hand Washing area, Warming Kitchen, Storage Room, Dressing/Lounge Room with Half-Bath, a 72' x 12' Covered Porch, HVAC, Industrial Ceiling Fans, Fire Pit and an additional Outdoor Wedding Ceremony Platform/Amphitheater. The Bridal Suite/Studio Apartment features; a Mini Kitchen, Full Bath, Hair/Makeup stations with counter space, vaulted ceilings, natural wood beams, a brick accent wall, and lots of natural lighting. The Lodge/Main House features and Open Concept Floor Plan with 3 Bedrooms, 2 Baths, Hardwood flooring, Tongue & Groove Vaulted Ceiling in the living area and in the Master Bedroom. The Master Bath features a free-standing tub and a custom stone walk-in shower, large vanity and walk-in closet. Lake views from all bedrooms and main living area. The kitchen offers stainless steel appliances including a refrigerator, gas stove, dishwasher and a walk-in Pantry. There is an office with built-in shelving and/or a storage room off the kitchen. The Laundry Room/Mudroom sits off the Bridal Suite leading into the house. Enjoy the Bonus Room in the Walk-out Basement. There are endless possibilities with this one. The house could easily be used as an Airbnb for those looking to make this an unlimited stream of income opportunity. All furnishings remain with the home, and the business for anyone interested. A MUST SEE! Proof of Funds are required for showings. Data believed correct; however, not guaranteed. Buyer to verify data prior to offer.
MlsNumber: --
ListingId: HK25000215


Listing Provided By: KELLER WILLIAMS HEARTLAND, original listing
Phone: (270) 403-4999
Office Phone: (270) 685-3705
Agent Name: Amanda Long
Disclaimer: Copyright © 2025 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 = 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 (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