Refine Search
Sort by
$343,568
3 Beds 2 Baths 615440 MLS
Brand new Drees Caywood floor plan in desirable Harmony Bluffs. The Drees Caywood is a 2nd floor 3 bedroom, 2 bath condominium, including an attached 2 car garage with a private entrance and covered deck. It has an open concept design with features like 9' ceilings, quartz countertops, a large kitchen island, walk-in pantry, painted cabinets, luxury vinyl plank flooring, stainless steel appliances, double vanity sinks in the primary bath, and 3 spacious walk-in closets. It's also equipped with DreeSmart technology, which includes a video doorbell, programable thermostat, wireless router, home automation hub, and smart lock. Enjoy community amenities such as an adult-only pool, kids splash area, outdoor amphitheater, fitness center, and walking paths. Conveniently located near Kroger Market Place and the highly anticipated shopping and restaurants of the Union Promenade entertainment district! All within Boone Country school district.

8519 Concerto Court, Union

$381,848
3 Beds 2 Baths 615438 MLS
The super spacious Drees Darden floor plan offers 3 bedrooms with walk-in closets, 2 bathrooms and a loft. This home offers a rare 2 car attached garage, private entrance and a covered deck with views of the Harmony lake! It has an open concept design with features like 9' ceilings, quartz countertops, a large kitchen island, walk-in pantry, painted cabinets, luxury vinyl plank flooring, stainless steel appliances, and double vanity sinks in the primary bath. It's also equipped with DreeSmart technology, which includes a video doorbell, programable thermostat, wireless router, home automation hub, and smart lock. Enjoy community amenities such as an adult-only pool, kid's pool and kids splash area, outdoor amphitheater, fitness center, and walking paths. Conveniently located near Kroger Market Place and just across the street from Union Promenade, the highly anticipated shopping and entertainment district! All within Boone Country school district.

8527 Concerto Court, Union

$329,000
3 Beds 2 Baths 615422 MLS
The super spacious Drees Darden floor plan offers 3 bedrooms each with a walk-in closet, 2 bathrooms and a loft. This home also offers a rare 2 car attached garage, private entrance and a covered deck with views of the Harmony lake! It has an open concept design with features like 9' ceilings, quartz countertops, a large kitchen island, walk-in pantry, painted cabinets, luxury vinyl plank flooring, stainless steel appliances, and double vanity sinks in the primary bath. It's also equipped with DreeSmart technology, which includes a video doorbell, programable thermostat, wireless router, home automation hub, and smart lock. Enjoy community amenities such as an adult-only pool, kid's pool and kids splash area, outdoor amphitheater, fitness center, and walking paths. Conveniently located near Kroger Market Place and just across the street from Union Promenade, the highly anticipated shopping and entertainment district! All within Boone Country school district.

8539 Concerto Court, 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