Refine Search
Map
Sort by
$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
$321,050
614475 MLS
Build on your own Lot!! Large 8.178 Acre private wooded Lot in Union! Access from shared private driveway off Big Bone Road. Subject to conveyance and restrictions document. England Subdivision Lot 1A

10540 Big Bone 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
$1,200,000
4 Beds ⋅ 4 Baths ⋅ 614374 MLS
24 Acres w/4 bedroom custom built brick home. Peaceful, private country setting amidst a lake, ponds, and woods. Lots of room to roam. Several outbuildings with 8 stall stable. Home has great room with WBFP, formal dining room and large solarium for lazy winter Sunday afternoons. Replace the front porch with a screened-in area for viewing the water. So much to offer and just minutes to schools and town. **Acreage to be surveyed for accurate total.

10650 Big Bone Church Road, Union
$358,000
4 Beds ⋅ 3 Baths ⋅ 614025 MLS
Large Brick Two-Story Home*7.5 Acres*Unique Floor Plan*Potential for Multi-Family*4 Bedrooms*3 Full Bathrooms*Huge Family Rm/Kitchen Combo* Fireplace*Flex Living or Dining Rm. Lower Level 2nd Kitchen*Large Laundry*Oversized Garage*Primary Bedroom w/Full Bath*New Roof 2021*Water Pump & Water Heater 2023*Electric Furnace appx 4 yrs*A/C 2022*Newer Vinyl Plank Flooring & Carpet*

11174 Big Bone Church Road, Union
$575,702
4 Beds ⋅ 2 Baths ⋅ 612540 MLS
23 acres with over 900 ft of road frontage on Camp Ernst Rd. Development potential. Fantastic sunset views to West. Zoned A1 & A2. Walking distance to Boone Co Arboretum. Bring your horses. There is a horse run-in and stables. There is room for adding more stables. Newer fencing. Seller says there is a spring that even in the driest days, water still runs. About the highest point in Boone County providing great sunset views. Tear down house and replace with your custom home or rehab or both. Seller will cooperate in 1031 Exchange. Hot water outdoor wood furnace as optional heat source. 2 barns. Walk to Boone County arboretum.

9315 Camp Ernst Road, 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