Refine Search
Sort by
$909,969
5 Beds 6 Baths 632050 MLS
New Construction in the beautiful community of Ballyshannon, featuring the Pearson Modern Farmhouse plan. This designer floorplan offers an open-concept kitchen with island, pantry, lots of cabinet space and quartz countertops. Family room with stunning gas fireplace connects to light filled morning room. The morning room walks out to the covered deck which features an exterior gas fireplace. Guest Suite with full bath. Private study with double doors off of entry foyer. Upstairs owner's suite with attached private bath featuring dual vanity sinks, walk-in shower, large soaking tub, and oversized walk-in closet. Second floor laundry room, three additional bedrooms, hall bath, and spacious bonus room. Partially finished basement with full bath. Attached three car garage.

8508 Robert Grant Drive, Union

$500,000
627960 MLS
One-of-a-kind property at a phenomenal price in Boone County, KY! 5.85-acre waterfront property located along the Ohio River & near Big Bone Lick State Park. Famously known as Jane's Saddlebag this property features a unique event venue, restaurant building with indoor/outdoor dining that could be converted to a single-family home, amphitheater, wine & spirts bar, previously used as the General Store building that could be an office/Airbnb/etc., playground, picnic shelter, & multiple themed buildings. Bring your business venue dreams to life or turn into your personal primary residence paradise or both! This unique property has endless possibilities. Perfect location for a weekend destination for camping, live music, delicious food, and family entertainment. Enjoy fishing, boating, kayaking, and other water activities from your own backyard. From the rolling hills, to the river, to the stunning evening sunsets, this property boasts stunning views year-round. Located at the end of Boat Dock Road by Boone's Landing and the Ohio River. Must see to fully appreciate everything this property has to offer!

13989 Ryle Road, Union

$452,500
3 Beds 3 Baths 626417 MLS
Located in the heart of Union this one of a kind home is situated on a private 4.84 acres, totally renovated 3/4 bedrooms, 2.5 baths, with all new flooring, new lights, New Roof, stone fireplace (wood burning) new cabinets, granite countertops and dog shower. Beautiful cedar (painted white) with black window frames and a stone fireplace and features to highlight exterior! Oversized 2 car garage. Space above garage was finished into a large primary suite with adjoining bath, walk in shower, ceramic tile and walk in closet with barn door, spiral staircase leading to 3rd floor with bonus room- could be used as hobby room, 4th bedroom or office. Large patio and front porch. Plenty of room for entertainment, more space up hill and behind home for trails, hunting or tiny cabin! This is truly a must see!

4184 Hathaway Road, Union

$3,912,000
5 Beds 8 Baths 626235 MLS
Welcome to Your Private Oasis on Omaha Trace! A Masterpiece of Luxury Living nestled upon 4.5 secluded acres within the esteemed Triple Crown Country Club Golf Community. This extraordinary Custom Built Estate showcases unparalleled quality & craftsmanship throughout. Step through the grand marble & limestone entry to 12,000 sqft of architectural brilliance that seamlessly blends classic charm with a contemporary flair. Features 5 BR, 5/3 Baths, 7 FP's, 2 Laundry Rms, 5 Car Gar. 1st Flr offers study, great rm, piano bar, gourmet quartz kitchen w/designer appl, wine grotto, hearth rm, suspended coffered ceiling, walk-in pantry, drop zone. Family Wing w/deluxe primary br, sitting rm, auto shades, coffee bar, his & her WIC - Marble Bathroom, steam shower-wall sprays, and 2 additional BR's w/ensuites. Fin LL Veranda includes media rm, game rm, play rm, exercise rm, 2 more BR's w/ensuites, 2nd Laundry Rm, billiards, caterer's ktcn, & pub w/walkout to outdoor living space w/private park, pergola, bocce ball, firepit, rock garden, gunite pool/spa, pool house w/full kitchen, bar, bath, FP, separate furnace, collapsible glass walls overlooking picturesque lake and golf course views!

10751 Omaha, Union

$920,000
5 Beds 4 Baths 615190 MLS
Fall in love with Sunset Farm, where 10 acres of wide-open space abound. This magnificent 5-6BR home offers the perfect blend of luxury, comfort, and functionality. Step inside the chef's kitchen, adorned with sleek quartz counters, double ovens, and a gas cooktop. The home's thoughtful design extends to the upper levels, featuring a 2nd floor laundry for utmost convenience. The walk-out lower level offers additional living and storage space. As you venture outside, a world of relaxation and entertainment awaits. Take a refreshing dip in the inviting heated, inground pool, basking in the warm sun as you unwind and soak in the tranquility of your surroundings. The wraparound front porch offers a serene retreat to enjoy your morning coffee or unwind with a book, while witnessing breathtaking sunsets that paint the sky with a kaleidoscope of colors. For those with a penchant for equestrian pursuits or a desire to embark on farming adventures, a generous 60x40 barn and chicken coop await, providing options for sustainable living. A .7 mile walking trail meanders through the property, inviting you to explore and connect with the beauty of nature at your own pace. When can you move in?

2677 Hathaway Road, Union

$900,000
4 Beds 4 Baths 614459 MLS
Looking for a little slice of Heaven? Come see this awesome, serene, park like setting! Beautiful custom built ranch with finished, walk-out basement that takes you right out to the in-ground pool! You'll be surrounded by the beauty of this property and the stocked lake! The pool is 18'x36' and is 4' deep from end to end. Two large out buildings with concrete floors,electric, camper/ welding plugs. One 14' door, one 10'door on the 36'x56' garage and a 10'door on the 24'x12'. Relax in this amazing home with 12' ceilings, kitchen with hardwood floors, 42''tall wall cabinets, double oven, Jen air gas cook top, DW, Frig, trash compactor, pantry, and island. 1st floor laundry w/plenty of storage! First floor owner's suite with trey ceilings, jetted tub, large shower, separate vanities and two walk-in closets. 4 large BR's and a Jack-in-Jill bath. Gas fireplace in living room. Many architectural touches throughout the house. Sit out in the 3 season room overlooking the pool and property. Media room in basement w/large family room, an office, BR and full bath. Large cedar closet, large storage room workshop w/walkout. First floor approx. 2896 sq. ft./fin basement approx 2000 sq

2841 Brian Drive, Union

$415,000
3 Beds 3 Baths 614432 MLS
Look no further for this incredible opportunity to own 5+ acres of peaceful living in the Ryle school district! Suited with multiple outbuildings, this impeccably maintained 3 bed, 2.5 bath home offers ample space to make this home your own. Open floorplan on the main floor and a great option for media/gameroom/theater room on the second floor. Beautiful, huge enclosed sunroom with a walkout to large concrete patio. Loads of closet space throughout the home including a useful mudroom in the back entry of the house. Detached garage with a large workshop wired with 3-phase electric, large barn with car maintenance pit and electric, storage building, small pool house/shed with electric and baseboard heating. This property offers a lot! City water will be available for hookup in the next 6-12 months. Come schedule your private showing today!

10160 Canoe Drive, Union

$2,750,000
4 Beds 8 Baths 609263 MLS
Perfectly peaceful paradise! Specifically understated elegance, this expansive estate feels as if it's perched in the clouds, nestled up on approximately 48 stunning acres with sweeping and inspiring views at every turn of the breathtaking countryside, wondrous pond and unrivaled sunsets! This classic and timeless custom designed home flows through three carefully curated levels which includes an indoor all-seasons resort-style extraordinary pool area. Designed and executed with attention to detail this home features uncompromising quality and appointments displaying remarkable craftsmanship, windows carefully executed throughout to capture the stunning views and natural light, soaring 20+ coffered and beamed ceiling, an impressive balcony, a true culinary kitchen with an abundance of prep and gathering space and direct access to the pool area, all generous rooms have ensuites with the primary suite on the first floor, an elevator and a lower level designed for an entertainer's dream. Also, a commercial size multi-use metal barn with water/electric, separate meter, 80x40. All with the convenience of being ~25 minutes to Downtown Cincinnati and CVG Airport. Truly exceptional!!

2820 Beaver Road, Union