Refine Search
Sort by
8434 Concerto Court, Union
$417,959
3 Beds ⋅ 3 Baths ⋅ 616076 MLS
New ranch-style townhome with a finished lower level and 2 car attached garage. Stunning lake views from the covered deck and patio. The Drees Brandywine has 3 bedrooms and 3 baths. It has an open concept design with features like 9' smooth ceilings quartz countertops, a large kitchen island, walk-in pantry, painted cabinets, luxury vinyl plank flooring, stainless steel appliances, double ovens, 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.

8434 Concerto Court, Union

8438 Concerto Court, Union
$429,083
3 Beds ⋅ 3 Baths ⋅ 615608 MLS
New ranch-style townhome with a finished lower level and 2 car attached garage. Stunning lake views from the covered deck and patio. The Drees Brandywine has 3 bedrooms and 3 baths. It has an open concept design with features like 9' smooth ceilings quartz countertops, a large kitchen island, walk-in pantry, painted cabinets, luxury vinyl plank flooring, stainless steel appliances, double ovens, 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 kid's 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.

8438 Concerto Court, Union

8519 Concerto Court, Union
$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

8527 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

8539 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

4649 Donegal Avenue, Union
$497,604
4 Beds ⋅ 3 Baths ⋅ 615249 MLS
Gorgeous new Avery Western Craftsman plan by Fischer Homes in beautiful Ballyshannon featuring an open concept design with an island kitchen with stainless steel appliances, upgraded cabinetry with 42 inch uppers and soft close hinges, quartz counter tops, pocket office, walk-in pantry and walk-out morning room to the large patio and all open to the soaring 2 story family room. Included rec room in step-down level. Homeowners retreat is on its own level with an en suite that includes a double bowl vanity, garden tub, separate shower and mega huge walk-in closet. The laundry room is also on this level. There are 3 additional secondary bedrooms that share a centrally located hall bath. Full basement with full bath rough-in and a 2 bay garage.

4649 Donegal Avenue, Union

8547 Concerto Court, Union
$329,900
3 Beds ⋅ 2 Baths ⋅ 614947 MLS
Brand new Drees Caywood floor plan in desirable Harmony Bluffs. The Drees Caywood is a 2nd floor 3 bedroom, 2 bath condominium, including 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.

8547 Concerto Court, Union

4741 Donegal Avenue, Union
$749,000
4 Beds ⋅ 4 Baths ⋅ 613680 MLS
Jaw-dropping new Pearson Modern Farmhouse plan by Fischer Homes in beautiful Ballyshannon featuring a unique generation living area and bedroom w/full bath and 2 walk-in closet and can be accessed from inside the home and outside. Formal living room could function as a dining room. Huge open concept area with a well appointed island kitchen with high end built-in stainless steel appliances, upgraded cabinetry with 42 inch uppers and soft close hinges, upgraded quartz counters, walk-in pantry and walk-out morning room all open to the soaring 2 story family room. Covered patio with outdoor fireplace. Upstairs homeowners retreat with an en suite with 2 separate vanities, freestanding tub, large walk-in shower and massive walk-in closet with laundry room access for easy laundry days. There are 2 additional bedrooms each with a walk-in closet, jack-n-jill bathroom and loft. Full basement with full bath rough-in and a 2 bay garage.

4741 Donegal Avenue, Union

2820 Beaver 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

How much is your home worth?

Get instant property value now!