A unique waterfront property has hit the market in Kentucky, where homebuyers will get the chance to own an entire private quarry, complete with a 7-acre lake and a home perched on a bluff overlooking the “crystal clear” waters.
The centerpiece of the 27-acre site is a private home built in 2020 on the edge of a limestone cliff that was once part of an active quarry. Today, however, the property has been transformed into a private playground with a sparkling lake for fishing, swimming and boating.
The four-bedroom residence and surrounding grounds are located in Columbia, Kentucky. And The dazzling lake below first hit the market in June with an asking price of $1.2 million. That claim has now been reduced to $995,000.
Topping this week’s list of favorite homes, the waterfront retreat is surrounded by limestone cliffs. Inside, the 1,264-square-foot home features a modern, open floor plan.
Highlights include a stylish kitchen with granite countertops and a two-story living room with a fireplace, a loft above, and access to the covered outdoor patio with hot tub. It also features a private boat ramp for direct access to the lake, as well as a waterfront pavilion for entertaining and enjoying the breathtaking scenery.
The property last sold in 2014 for $59,500 before this custom home was built.
Other properties getting attention this week include a historic Queen Anne Victorian home in Michigan, a well-preserved Spanish-style estate in California, and a “house frame” in New Hampshire that’s being offered for about the price of a car!
Price: $2,375,000
Why it’s here: This Swedish country-style homestead features bright interior-inspired color palettes Carl Larssononce operated as a Lonesomeville Art Studio and Private Inn, offers future income potential.
Located in Portland’s Woodstock enclave, the adorable property includes a Victorian farmhouse, an art studio with a sleeping porch and an apartment above, and Portland’s “only known remaining original water tower.”
Offered for the first time in decades, the custom-built residence features many handcrafted details, including a clay tile fireplace; Tile work in the bathrooms, kitchen and art studio; stained glass windows; and a top-floor attic suite with a “hidden history.”
Outdoors, the picturesque landscape features “extraordinary” gardens, rose pergolas and a tree “from the 1905 World’s Fair.”
Kendall Bergstrom of Cascade Hasson Sotheby’s International Realty is the broker.
Price: $550,000
Why it’s here: The Hugh H. Richard House (Fossores Chapter House) is an eight-bedroom Victorian Queen Anne home in downtown Jackson’s historic district that was used as a religious retreat.
The 8,039-square-foot home is listed on the National Register of Historic Places and has four stories. Interior surprises include tin ceilings, hand-carved details in the hardwood floors, velvet wallpaper, curved walls, a hidden room and a grand Gothic staircase.
A macabre, skull-decorated room with a coffin-shaped key holder and a Polaroid photo wall complements the fascinating decor. Recent updates after tenants “maliciously” vandalized the apartment in 2022 include professionally cleaned basement walls, newly added or “completely renovated” bathrooms and extensive drywall repairs.
With “flexible zoning” allowing for retail, commercial offices, event space or mixed-use buildings, the property offers a unique opportunity to live and work. Or it could be used as a private home. According to the listing, the seller “will consider selling most of the interior furnishings and contents separately from the property.”
Susie Mohlman of Sproat Realty Professionals-J is the broker.
Price: $2,499,000
Why it’s here: Built in 1927, Casa Del Gado is a Spanish-style residence that has been carefully preserved and modernized.
The “timeless” property boasts valley and hill views and features exposed beams, vaulted wood ceilings, built-ins, large windows, custom woodwork and a striking circular stone fireplace. French doors in the dining room open to a private courtyard.
Additional highlights include a chef’s kitchen with breakfast nook, a primary retreat with patio access, and a lower level with an integrated bar and guest suite.
The private grounds include an in-ground pool, a two-car garage and a detached “bonus structure” that could be converted into a fitness center, home office or studio.
Andrew Dinsky of Equity Union is the listing agent.
Price: $47,000
Why it’s here: This is a cost-effective way to convert the existing “house frame” that requires “significant repairs” into the home of your dreams.
The remote structure of the lake region is “worth a look,” the listing says. It still needs a well, a sewage system, windows, floors, walls and a new roof. However, the conditions are there for the next buyer to get started.
Access to the 1.03-acre property is unclear as no paved roads are visible in the listing photos. Although the secluded location may seem too remote, shopping, dining and recreational opportunities are just minutes away.
Jeremy White of Berkshire Hathaway HomeServices Verani Realty is the real estate agent.
Price: $225,000
Why it’s here: It’s an affordable opportunity to purchase a fully furnished, whimsical “little oasis” that’s “full of happy surprises at every turn.”
With an artistic interior that needs some TLC, the colorful two-bedroom residence features wood ceilings, Mexican tile and hardwood floors, and custom painted walls. An eclectic kitchen features a vintage Glenwood stove, pedestal sink, and stained glass windows.
Also on the property are a cactus garden, a bird feeder, a koi pond in need of new liner, a greenhouse and several outbuildings.
Robyn Cord of Realty One Group Mountain Desert is the broker.
Price: $525,000
Why it’s here: The Converse House is a High Victorian Gothic style home built in 1870 for Col. Charles A. Converse.
The charming five-bedroom residence is listed on the National Register of Historic Places and is full of historic details. These include a seven-sided porch, built-in “preacher’s bench,” pocket doors, cedar cabinets, exposed beams, and a widow’s peak. Dramatic interiors include a walnut-paneled dining room, a lime green butler’s pantry, a red-orange study, a purple foyer, and a pretty pink bedroom. The covered porch with new hardwood floors would be a nice spot for morning coffee.
Located just steps from Washington Park, the tree-lined property also features a new slate patio, fountain, carriage barn and one-car garage.
Victoria Obrotsa of Re/Max Coast and Country is the listing agent.
Price: $225,000
Why it’s here: It’s an affordable chance to revitalize the former First Presbyterian Church and transform it into the building of your dreams.
Built in 1902, the 5,334-square-foot building features a pristine interior with original oak benches, stained glass, arched windows, a balcony and even a working pipe organ. The neo-Gothic, Victorian-style building could be used as an events center with a restaurant, an events venue or a single-family home with a loft. A lower level with multiple entries could be used “for a business setting”.
The property includes a fenced side yard and private parking space to the rear.
Ernest Duran of Keller Williams Integrity Real Estate is the listing agent.
Price: $195,000
Why it’s here: It is a well-preserved three-bedroom period villa which has been modernized with all modern conveniences whilst still retaining its historic charm.
Built in 1904, the 2,131-square-foot residence with wraparound porches still features mahogany-colored beadboard walls, 12-foot ceilings, a traditional dogtrot hallway, oversized windows and a grand sweeping staircase. An updated kitchen features granite countertops and modern appliances. The master bedroom is on the main level, while a converted attic provides additional storage and a guest bedroom.
The fenced property also has a detached double carport and a storage shed.
To Corley by Roberts Brothers Es Malbis is the listing agent.
Price: $1,150,000
Why it’s here: This “architecturally distinctive” 1982 Sandia Heights modern home features many original details.
Wall-to-wall carpets, beamed ceilings, elongated rectangular windows, wood accents, and stone details are found throughout the three-bedroom, multi-level home. Stunning highlights include a great room with a gas stove and built-in bar, as well as a raised master bedroom with a recessed wood-burning stove, walk-in closet and retro bathroom with stone-clad whirlpool tub and double sinks.
Multiple decks and terraces offer uninterrupted city views and overlook the 1.28-acre, two-parcel property.
Greg praiseworthy of Coldwell Banker Legacy is the listing agent.
Price: $995,000
Why it’s here: It’s a chance to purchase a 27.15 acre property in a quarry lake surrounded by dramatic limestone cliffs.
Built in 2020, the “remarkable” residence with a 1,264-square-foot open floor plan sits on a former quarry. The modern kitchen features granite countertops and the high-ceilinged great room features a floor-to-ceiling fireplace and access to a covered patio with a hot tub. The master suite also has direct access to the terrace.
A covered lakefront entertainment pavilion overlooks the private boat ramp to the lake. According to the listing, there is also potential for future expansion.
Tony Huynh of Keller Williams First Choice Realty is the real estate agent.
Get real estate news in your inbox
