Our Brokerage's Active Listings

$650,000 (USD)
Active

Union Area Single Family Home

Active

10509 Killarney Drive Union, KY 41091

4 Bed
3 Baths
2332 sqft
MLS# 643625
,Welcome to your own private piece of paradise! This gorgeous full-brick ranch home sits on nearly 3 acres, offering the peaceful feel of country living while being just minutes from the Promenade, I-75, the Greater Cincinnati/Northern Kentucky International Airport, and downtown Cincinnati. Located in the desirable Mann, Gray, and Ryle School Districts, this property perfectly blends privacy, convenience, and timeless charm.

This sprawling ranch features breathtaking lake views, 4 bedrooms, 3 full bathrooms, two wood-burning fireplaces, a finished lower level, and an oversized 4-car garage with two separate entrances and two deep bays. There is an incredible amount of space both inside and out for everyday living and entertaining, including a formal dining room, formal living room, spacious kitchen with breakfast area, and a lower-level family room.

The primary suite bathroom has been beautifully transformed with a professional remodel featuring a large walk-in shower with a built-in seat, double vanity, and elegant tile backsplash. Throughout the home, you'll find classic details that add warmth and character, including natural woodwork, beamed ceilings, and hardwood floors.

Step outside and enjoy the expansive grounds, stunning lake views, and plenty of space to relax or entertain, complete with an above-ground pool. Whether you're enjoying quiet mornings overlooking the water or hosting family and friends, this exceptional property offers a rare combination of acreage, location, and charm. This is truly a place you'll be proud to call home.
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Dawn Craven, Coldwell Banker Realty
$600,000 (USD)
Active

Marengo Area Single-Family Home

Active

4494 County Road 15 Marengo, OH 43334

7 Bed
4 Baths
2048 sqft
MLS# 226021482
Discover the perfect blend of country charm, flexibility, and opportunity on this picturesque 4+ acre property, now featuring a new roof installed in 2026. Surrounded by beautiful rural views and located just minutes from everyday conveniences, this unique property offers an ideal setup for multi-generational living, extended family accommodations, home-based business use, rental income potential, or simply room to spread out and enjoy a peaceful lifestyle.
Located just one mile from Groovy Plants Ranch and surrounded by beautiful farmland views, you'll enjoy the peacefulness of country living while remaining close to shopping, dining, and freeway access.
The main home offers 2,048 sq ft with 4 bedrooms, 2.5 baths, beautiful hardwood floors, a formal dining room, cozy family room, spacious eat-in kitchen, and a large first-floor flex room that could serve as a home office, playroom, or potential fifth bedroom.
A bright four-season room connects the home to the oversized 3.5-car garage. Above the garage, a separate 1,456 sq ft accessory apartment with private entrance provides exceptional flexibility. Ideal as an in-law suite, guest quarters, or corporate rental, it features 3 bedrooms, a full bath, spacious family room, eat-in kitchen with stainless steel appliances, and a 3 seasons room leading to a private fenced yard. A chair lift is included for added accessibility.
Outside, a restored 50' x 60' x 25' barn with electric offers incredible potential for a workshop, hobby farm, storage, studio, or small business use. Relax on the front deck overlooking open farmland or entertain on the rear deck while taking in breathtaking sunset views.
Whether you're looking for a property that can accommodate extended family, generate supplemental income, support your hobbies, or simply provide room to roam, this unique offering combines space, versatility, and country charm in a truly beautiful setting.
Listing Courtesy of COLUMBUS OH MLS / Listed By: Craig Buehler, Coldwell Banker Realty
$560,000 (USD)
Active

Logan Area Single-Family Home

Active

75 Hill Street Logan, OH 43138

5 Bed
6 Baths
3678 sqft
MLS# 226021517
Welcome to the White Pillars Inn, an extraordinary historic home proudly listed on the National Register of Historic Places. Meticulously maintained to preserve its original charm and character, this iconic property sits on approximately one acre overlooking the picturesque town of Logan. Offering a rare blend of history, hospitality, and the natural beauty of Hocking Hills.
Operating successfully as a beloved bed-and-breakfast under its current owner since 1998, this remarkable residence features five spacious bedrooms, each with its own private en-suite bath, plus an additional half bath for guests. Rich architectural details, timeless craftsmanship, and period character can be found throughout the home, creating an atmosphere that is both elegant and inviting.
Every inch of the property reflects thoughtful care and pride of ownership, from the stately exterior and welcoming wraparound porches to the warm, comfortable gathering spaces inside. Guests and owners alike enjoy peaceful surroundings, scenic views, and easy access to the area's renowned hiking trails, waterfalls, wineries, and attractions that make Hocking Hills one of Ohio's premier destinations.
Whether you're seeking a unique private residence, or a turnkey hospitality business in the region's most treasured landmarks, White Pillars Inn offers a truly exceptional opportunity. Steeped in history and cherished by visitors for decades, this one-of-a-kind property is ready for its next chapter. Schedule your private showing today and experience the timeless beauty yourself!
Listing Courtesy of COLUMBUS OH MLS / Listed By: Aaron "Tyler" Devoll, Coldwell Banker Realty