A one-of-a-kind waterfront estate has been brought to the market in Kentucky, where homebuyers are being given the chance to own an entire private quarry, complete with a 7-acre lake and a house that is perched on a cliff overlooking its “crystal-clear” waters.
At the heart of the 27-acre spread is a private dwelling that was built in 2020 on the edge of a limestone bluff that once made up part of an active rock quarry. Today, however, that property has been transformed into a private playground, complete with a glittering lake designed for fishing, swimming, and boating.
Located in Columbia, KY, the four-bedroom residence, its surrounding land, and the dazzling lake beneath first came on the market in June with an asking price of $1.2 million. That ask has now been lowered to $995,000.
The waterfront retreat, which has shot to the top of the week’s most popular homes list, 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 area above, and access to the covered outdoor deck with hot tub. It also has a private boat ramp for direct lake access, along with a waterfront pavilion designed for entertaining and soaking in the stunning scenery.
The property last sold for $59,500 in 2014, before this custom home was built.
Other properties grabbing attention this week include a historic Queen Anne Victorian in Michigan, a well-preserved Spanish-style estate in California, and a “house frame” in New Hampshire offered for about the price of a car!
Price: $2,375,000
Why it’s here: This Swedish country-style farmstead, with bright interior color palettes inspired by Carl Larsson, once operated as the Lonesomeville Art Studio and Private Inn, offering future income potential.
The delightful compound is located in Portland’s Woodstock enclave and includes a Victorian farmhouse, an art studio with a sleeping porch and apartment above, and Portland’s “only known remaining original water tower.”
Offered for the first time in decades, the custom 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 story.”
Outdoors, the picture-perfect scenery includes “extraordinary” gardens, rose pergolas, and a tree “from the 1905 World’s Fair.”
Kendall Bergstrom of Cascade Hasson Sotheby’s International Realty is the listing agent.
Price: $550,000
Why it’s here: The Hugh H. Richard House (Fossores Chapter House) is an eight-bedroom Queen Anne Victorian located in downtown Jackson‘s Historic District that has been used as a religious retreat.
Listed on the National Register of Historic Places, the 8,039-square-foot home has four stories. Interior surprises include the tin ceilings, hand-carved details in the hardwood floors, velvet wallpaper, curved walls, a hidden room, and a grand Gothic staircase.
A macabre room decked out in skulls, with a coffin-shaped keyholder and Polaroid photo wall, adds to the intriguing decor. Recent updates, after renters “maliciously” trashed the place in 2022, include professionally cleaned basement walls, newly added or “completely renovated” bathrooms, and extensive drywall repairs.
With “flexible zoning” allowing for retail, commercial office, event space, or mixed-use development, the property offers a unique live-work opportunity. Or it could be used as a private residence. According to the listing, the seller will “consider selling most interior furnishings and contents separately from the real estate.”
Susie Mohlman of Sproat Realty Professionals-J is the listing agent.
Price: $2,499,000
Why it’s here: Built in 1927, Casa Del Gado is a Spanish-style residence that has been thoughtfully preserved and updated.
Offering valley and hillside views, the “timeless” estate features exposed beams, vaulted wood ceilings, built-ins, expansive windows, custom millwork, and an eye-catching rounded stone fireplace. French doors in the dining room open to a private courtyard.
Other highlights include a chef’s kitchen with a breakfast nook, a primary retreat with patio access, and a lower level with a built-in bar and guest suite.
The private lot includes an in-ground pool, a two-car garage, and a detached “bonus structure” that could be transformed into a fitness center, home office, or studio.
Andrew Dinsky of Equity Union is the listing agent.
Price: $47,000
Why it’s here: Here’s an inexpensive chance to transform the existing “house frame”—which requires “significant repairs”—into the home of your dreams.
The remote Lakes Region structure is “worth a look,” according to the listing. It still needs a well, septic system, windows, flooring, walls, and a new roof. However, the bones are in place to get the next buyer started.
Access to the 1.03-acre lot is unclear, as no paved roads are shown in the listing photos. While the isolated location may seem too secluded, it’s just minutes away from shopping, dining, and recreation.
Jeremy White of Berkshire Hathaway HomeServices Verani Realty is the listing agent.
Price: $225,000
Why it’s here: It’s an affordable chance to buy a fully furnished, quirky “little oasis” that is “full of happy surprises at every turn.”
The colorful two-bedroom residence, with an artistic interior needing some TLC, includes wood ceilings, Mexican tile and hardwood floors, and custom painted walls. An eclectic kitchen has a vintage Glenwood stove, a pedestal sink, and stained-glass windows.
Also found on the property are a cacti garden, a bird estuary, a koi pond needing a new liner, a greenhouse, and several outbuildings.
Robyn Cord of Realty One Group Mountain Desert is the listing agent.
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.
Listed on the National Register of Historic Places, the charming five-bedroom residence is full of period details. They include a seven-sided front porch, a built-in “preacher’s bench,” pocket doors, cedar closets, exposed beams, and a widow’s peak. Dramatic interiors include a walnut-paneled dining room, a lime-green butler’s pantry, a red-orange home office, a lilac foyer, and a pretty pink bedroom. The covered porch, with a new wood floor, would be a nice spot for morning coffee.
Located steps away from Washington Park, the tree-lined lot also features a new slate patio, a fountain, a carriage barn, and a 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 resurrect the former First Presbyterian Church and transform it into the building of your dreams.
Built in 1902, the 5,334-square-foot building has an untouched interior with original oak pews, stained glass, arched windows, a balcony, and even a working pipe organ. The Victorian Gothic Revival building could be used as an event center with restaurant, a performance venue, or a single-family residence with a loft. A lower level with multiple entries could be used “for a business setting.”
The property includes a fenced-in side courtyard and private parking at the rear.
Ernest Duran of Keller Williams Integrity Real Estate is the listing agent.
Price: $195,000
Why it’s here: It’s a well-preserved three-bedroom antique that has been updated with all the modern conveniences while still retaining its historic charm.
Built in 1904, the 2,131-square-foot residence, with wraparound porches, still features mahogany-toned beaded board walls, 12-foot-high ceilings, a traditional dogtrot hallway, oversized windows, and a grand curved staircase. An updated kitchen has granite countertops and modern appliances. The primary bedroom is on the main level, while a finished attic offers extra storage and a guest bedroom.
The fenced-in property also has a detached double carport and storage shed.
Kay Corley of Roberts Brothers Es Malbis is the listing agent.
Price: $1,150,000
Why it’s here: This “architecturally distinctive” Sandia Heights contemporary, built in 1982, features many original details.
Wall-to-wall carpeting, beamed ceilings, elongated rectangular windows, wood accents, and stone details can be found throughout the multilevel three-bedroom home. Jaw-dropping highlights include a great room with a gas stove and built-in bar, and an elevated primary bedroom with a sunken wood-burning stove, walk-in closet, and retro bathroom with a stone-encased jetted tub and dual-sink vanity.
Multiple decks and terraces, offering uninterrupted city views, overlook the two-parcel 1.28-acre property.
Greg Lobberegt of Coldwell Banker Legacy is the listing agent.
Price: $995,000
Why it’s here: It’s the chance to buy a 27.15-acre quarry lake estate surrounded by dramatic limestone cliffs.
Built in 2020, the “remarkable” residence with a 1,264-square-foot open floor plan, sits on a former rock quarry. The modern kitchen has granite countertops, and the great room, with a cathedral ceiling, has a floor-to-ceiling fireplace and access to a covered deck with a hot tub. The primary suite also has direct terrace access.
A covered lakeside entertaining pavilion overlooks the private boat ramp to lake. There is also potential for future expansion, according to the listing.
Tony Huynh of Keller Williams First Choice Realty is the listing agent.
Get real estate news in your inbox
Disclaimer: The information provided on this website is for educational and informational purposes only and should not be considered financial, investment, or legal advice. Stock markets, real estate, and other financial instruments involve significant risks, and past performance does not guarantee future results. You should conduct your own research and/or seek advice from a licensed financial advisor before making any investment decisions. The website owner is not liable for any financial losses or damages arising from the use of the information presented here.
About The Author
