$415,000 Welcome To Harmony's Most Beautiful BOHO Wonder - Drees Fulton Floorplan Boast 4 Bedrooms*4 Baths* New White Oak LVP Throughout First Floor*Kitchen Island & High-End Kitchenaid Appliances Stay*2 Flex Rooms on 1st Floor*2-Story Living Room Boast A Wall of Windows w/Gas Fireplace*Owner's Bath Beautifully Remodeled w/a Luxury Addition - California Closets*Transom Window & Custom Laundry Chute Added in Upstairs Hall Bath*Finished Lower Level with Walk-Out*Bourbon Bar To Stay*2 Large Storage Areas*Huge Composite Deck w/Under Decking & Large Covered Patio Overlooking A Private Wooded Backyard. The Community offers Tree-Lined Streets*3 Swimming Pools, Clubhouse, Fitness Center, Park, Playground, Walking Trails, Lake, and More! You Will Enjoy Family Activities including Summer Concerts overlooking the Lake! Don't Miss This One! Unbelievable Price! SADLY BACK ON THE MARKET AT NO FAULT OF SELLERS! 4 Beds ⋅ 3 Baths ⋅ 617537 MLS Welcome To Harmony's Most Beautiful BOHO Wonder - Drees Fulton Floorplan Boast 4 Bedrooms*4 Baths* New White Oak LVP Throughout First Floor*Kitchen Island & High-End Kitchenaid Appliances Stay*2 Flex Rooms on 1st Floor*2-Story Living Room Boast A Wall of Windows w/Gas Fireplace*Owner's Bath Beautifully Remodeled w/a Luxury Addition - California Closets*Transom Window & Custom Laundry Chute Added in Upstairs Hall Bath*Finished Lower Level with Walk-Out*Bourbon Bar To Stay*2 Large Storage Areas*Huge Composite Deck w/Under Decking & Large Covered Patio Overlooking A Private Wooded Backyard. The Community offers Tree-Lined Streets*3 Swimming Pools, Clubhouse, Fitness Center, Park, Playground, Walking Trails, Lake, and More! You Will Enjoy Family Activities including Summer Concerts overlooking the Lake! Don't Miss This One! Unbelievable Price! SADLY BACK ON THE MARKET AT NO FAULT OF SELLERS! 3829 Sonata Drive, Union
$522,000 This Triple Crown 5 bedroom 3 1/2 bath one owner beauty located in the Mann, Gray, Ryle District is loaded with so many great features and updates (See attached list). Open entryway, wood floors, office/study, formal dining room, two story great room with gas fireplace & wall of windows. Large, gorgeous Kitchen boasts granite counter tops, solid wood cabinets with crown molding accents, ceramic tile back splash and beautiful tile over cooktop, hardwood floors, ceiling fans, accent lighting. stainless steel appliances with slide in ceramic cooktop/oven, Large 1st floor primary bdrm with beautiful frameless glass enclosure to show off the stunning tiled shower cathedral ceilings, and 2 large walk-in closets. , luxury soaking tub w/jets surrounded by impressive tile, 2 separate gorgeous granite counter-tops, 10 foot ceiling with ceiling fan and tiled flooring., custom drapery and blinds. Enjoy solid wood cabinets with crown molding accents, ceramic tile back splash and beautiful showy tile over cooktop, wood floors, ceiling fans, accent lighting. . A huge trex deck w/ornate black iron railing overlooks the beautiful large, flat yard w/wooded rear view. 5 Beds ⋅ 4 Baths ⋅ 616106 MLS This Triple Crown 5 bedroom 3 1/2 bath one owner beauty located in the Mann, Gray, Ryle District is loaded with so many great features and updates (See attached list). Open entryway, wood floors, office/study, formal dining room, two story great room with gas fireplace & wall of windows. Large, gorgeous Kitchen boasts granite counter tops, solid wood cabinets with crown molding accents, ceramic tile back splash and beautiful tile over cooktop, hardwood floors, ceiling fans, accent lighting. stainless steel appliances with slide in ceramic cooktop/oven, Large 1st floor primary bdrm with beautiful frameless glass enclosure to show off the stunning tiled shower cathedral ceilings, and 2 large walk-in closets. , luxury soaking tub w/jets surrounded by impressive tile, 2 separate gorgeous granite counter-tops, 10 foot ceiling with ceiling fan and tiled flooring., custom drapery and blinds. Enjoy solid wood cabinets with crown molding accents, ceramic tile back splash and beautiful showy tile over cooktop, wood floors, ceiling fans, accent lighting. . A huge trex deck w/ornate black iron railing overlooks the beautiful large, flat yard w/wooded rear view. 10801 War Admiral Drive, Union
$566,500 Gorgeous better than new Arlinghaus Marietta floorplan in Westbrook Estates! Situated on a 1/2 acre fenced lot, this stately home is perfect for entertaining with gourmet open concept kitchen and family room with custom built in bookcases around the gas fireplace, surround sound, granite kitchen counters, smudge proof gallery appliances, double ovens, step in pantry w/ custom shelving, mudroom w/ cubbies from garage and an additional prep kitchen in the garage! This home also offers a formal dining room plus a private study with french doors perfect for the work-from-home lifestyle. Upstairs boasts the owners suite with huge walk in shower, double custom walk in closets and vanities. 3 additional huge bedrooms with custom walk in closets, spacious loft, and laundry room complete the 2nd floor. The unfinished basement is already set up to add additional entertaining space or mother in law suite equipped for a kitchenette or wet bar and full bath, with walkout to huge patio with fire pit. Smart home switches throughout enabled by Alexa, water purification system, tankless hot water heater and so much more! OPEN HOUSE scheduled for Sunday 7/27 from 12-2 pm! 4 Beds ⋅ 3 Baths ⋅ 615580 MLS Gorgeous better than new Arlinghaus Marietta floorplan in Westbrook Estates! Situated on a 1/2 acre fenced lot, this stately home is perfect for entertaining with gourmet open concept kitchen and family room with custom built in bookcases around the gas fireplace, surround sound, granite kitchen counters, smudge proof gallery appliances, double ovens, step in pantry w/ custom shelving, mudroom w/ cubbies from garage and an additional prep kitchen in the garage! This home also offers a formal dining room plus a private study with french doors perfect for the work-from-home lifestyle. Upstairs boasts the owners suite with huge walk in shower, double custom walk in closets and vanities. 3 additional huge bedrooms with custom walk in closets, spacious loft, and laundry room complete the 2nd floor. The unfinished basement is already set up to add additional entertaining space or mother in law suite equipped for a kitchenette or wet bar and full bath, with walkout to huge patio with fire pit. Smart home switches throughout enabled by Alexa, water purification system, tankless hot water heater and so much more! OPEN HOUSE scheduled for Sunday 7/27 from 12-2 pm! 9472 Riviera Drive, Union
$675,000 Well-loved full brick home on a quiet cul-de-sac street in Hempsteade Manor. Customized Drees Anniversary floor plan loaded w/ upgrades including rear 4ft bump out, 9ft ceilings throughout, 4 car garage, & oversized driveway. Inviting covered front porch. Open foyer w/ hardwoods & dual closets. Living room w/ crown adjoins formal dining room offering chair rail, tray ceiling w/ crown, & chandelier. 1st floor study w/ French doors & crown. Fully equipped eat in kitchen boasts oversized island, staggered wood cabinets, tiled floors, granite counters, backsplash, planning desk, & breakfast rm. Family room features 10ft ceilings, gas fireplace, & decorative transoms. Full length rear trex deck w/ beautiful wooded & lake views. Awesome rear fenced private yard! Incredible primary bedroom suite appointed by cathedral ceilings, walk in closets, plus adjoining tiled bath w/ double vanity, shower, & jetted tub. 4 more large bedrooms, & 2 additional tiled full baths on 2nd floor. Finished LL w/ high ceilings, full bath, walkout , tiled wet bar, & media room. Freshly painted, sound system in & outside, front & rear sprinklers, security system, new HVAC, & tons of storage! Ryle Schools! 5 Beds ⋅ 5 Baths ⋅ 615501 MLS Well-loved full brick home on a quiet cul-de-sac street in Hempsteade Manor. Customized Drees Anniversary floor plan loaded w/ upgrades including rear 4ft bump out, 9ft ceilings throughout, 4 car garage, & oversized driveway. Inviting covered front porch. Open foyer w/ hardwoods & dual closets. Living room w/ crown adjoins formal dining room offering chair rail, tray ceiling w/ crown, & chandelier. 1st floor study w/ French doors & crown. Fully equipped eat in kitchen boasts oversized island, staggered wood cabinets, tiled floors, granite counters, backsplash, planning desk, & breakfast rm. Family room features 10ft ceilings, gas fireplace, & decorative transoms. Full length rear trex deck w/ beautiful wooded & lake views. Awesome rear fenced private yard! Incredible primary bedroom suite appointed by cathedral ceilings, walk in closets, plus adjoining tiled bath w/ double vanity, shower, & jetted tub. 4 more large bedrooms, & 2 additional tiled full baths on 2nd floor. Finished LL w/ high ceilings, full bath, walkout , tiled wet bar, & media room. Freshly painted, sound system in & outside, front & rear sprinklers, security system, new HVAC, & tons of storage! Ryle Schools! 1113 Ashton Court, Union
$399,900 Impeccable Arlinghaus Built Two Story*Arbor Springs/Plantation Pointe Subdivsion*New Roof-July 2023*4 Spacious Bedrooms*2.2 Bathrooms*Beautiful Hardwood Floors*Large Great Room*Gas Fireplace*Crown Molding*Kitchen has New LG Appliances*Oven equipped w/Air Fryer*Huge Pantry*1st Floor Laundry*Spacious Bedrooms*Finished Basement*Walkout to Patio*Hot Tub*Firepit*Oversized Garage*.37 Acre Lot with Mature Trees providing privacy*Ryle School District*HOA includes the use of 3 Community Pools & Playground Square Footage and Lot Size is not guaranteed. 4 Beds ⋅ 4 Baths ⋅ 615300 MLS Impeccable Arlinghaus Built Two Story*Arbor Springs/Plantation Pointe Subdivsion*New Roof-July 2023*4 Spacious Bedrooms*2.2 Bathrooms*Beautiful Hardwood Floors*Large Great Room*Gas Fireplace*Crown Molding*Kitchen has New LG Appliances*Oven equipped w/Air Fryer*Huge Pantry*1st Floor Laundry*Spacious Bedrooms*Finished Basement*Walkout to Patio*Hot Tub*Firepit*Oversized Garage*.37 Acre Lot with Mature Trees providing privacy*Ryle School District*HOA includes the use of 3 Community Pools & Playground Square Footage and Lot Size is not guaranteed. 8953 Richmond Road, Union
$415,000 Gorgeous Fisher Home Blackstone Floor Plan*Amazing Open Floor Plan Ideal for Entertaining, 2 Story Entry*Huge Family Room*Stunning Gourmet Kitchen*Formal Dining Room*1st Floor Study and Sunroom*Huge Primary Suite/Adjoining Bath & Walk-In Closet*All Large Bedrooms*Partially Finished Lower Level w/Finished Study*Great Community with Pool & Play Area! A Must See! 4 Beds ⋅ 3 Baths ⋅ 615111 MLS Gorgeous Fisher Home Blackstone Floor Plan*Amazing Open Floor Plan Ideal for Entertaining, 2 Story Entry*Huge Family Room*Stunning Gourmet Kitchen*Formal Dining Room*1st Floor Study and Sunroom*Huge Primary Suite/Adjoining Bath & Walk-In Closet*All Large Bedrooms*Partially Finished Lower Level w/Finished Study*Great Community with Pool & Play Area! A Must See! 7036 O'Connell Place, Union
$559,000 Get ready to check off every item on your dream home checklist! This incredible home in Hempsteade Manor is a paradise. With three finished levels, a chef's kitchen featuring an oversized island, a majestic two-story great room, and a first-floor study with French doors, this home offers the perfect blend of luxury and functionality. All bedrooms come with adjoining baths, ensuring everyone has their own private oasis. Hardwood floors and extensive molding add a touch of elegance throughout. Step outside to a covered deck, open deck, and patio overlooking a tranquil yard. The lower level boasts an oversized family room with a wet bar, Murphy bed, full bath, and walkout, providing the ultimate space for entertainment. Additional features include a storage area with a second kitchen option and a three-car side entry garage. Enjoy the warmth of two fireplaces, the convenience of an irrigation system, and the security of an invisible pet fence. Located in the award-winning Mann/Gray/Ryle school district, this home is truly exceptional. When can you move in? 4 Beds ⋅ 5 Baths ⋅ 614645 MLS Get ready to check off every item on your dream home checklist! This incredible home in Hempsteade Manor is a paradise. With three finished levels, a chef's kitchen featuring an oversized island, a majestic two-story great room, and a first-floor study with French doors, this home offers the perfect blend of luxury and functionality. All bedrooms come with adjoining baths, ensuring everyone has their own private oasis. Hardwood floors and extensive molding add a touch of elegance throughout. Step outside to a covered deck, open deck, and patio overlooking a tranquil yard. The lower level boasts an oversized family room with a wet bar, Murphy bed, full bath, and walkout, providing the ultimate space for entertainment. Additional features include a storage area with a second kitchen option and a three-car side entry garage. Enjoy the warmth of two fireplaces, the convenience of an irrigation system, and the security of an invisible pet fence. Located in the award-winning Mann/Gray/Ryle school district, this home is truly exceptional. When can you move in? 9996 Cedarwood Drive, Union
$895,000 APPROX 1.3M TO DUPLICATE! PHENOMENAL 4 BDRM, 4 Bath, 3+ Car Side Entry Garage Masterpiece w/2 Owner's Suites on Lush .55 Acre Homesite Offering the Optimum LIFESTYLE in Prestigious Triple Crown Country Club Community! Award Winning New Haven, Gray, & Ryle Schools/Low County Tax Rate/Perfectly Appointed Near Winner's Circle Park on Premium Cul-De-Sac ST/Entertainer's Dream Boasting Incredible Outdoor Living/Expansive, Covered Front Porch, Massive, Rear Covered Deck w/Cathedral Ceilings & Floor to Ceiling Stone FP w/Uncovered Deck Area as well/Soaring, 9 FT Ceilings Throughout/ 3 Tray Ceilings/Desirable, 1st FL Study w/French Doors/Inviting GREAT RM/Spectacular, Gourmet KIT w/Double Oven, Granite Counters, Counter Bar w/Gas, 6 Burner Cooktop, Stainless Steel Appliances, 42 IN Cabinetry w/ Crown Molding, Multiple, Walk-In Pantries, & Oversized Breakfast Area/Relaxing SUNROOM/One of a Kind, 1ST FL Laundry RM, Mudroom, Craft RM w/Walls of Cabinetry, Desk Area, LG Closet, & Space for Refrigerator/2 Luxurious 1ST FL Owner's Suites/Fabulous Owner's Bath/Enormous Walk-In Closet/FIN LL w/Wet Bar, Lots of Windows, Walkout & Columned Accents/2 FP's/Built-In Speakers/+ MORE! BEST OF EVERYTHING 4 Beds ⋅ 4 Baths ⋅ 614444 MLS APPROX 1.3M TO DUPLICATE! PHENOMENAL 4 BDRM, 4 Bath, 3+ Car Side Entry Garage Masterpiece w/2 Owner's Suites on Lush .55 Acre Homesite Offering the Optimum LIFESTYLE in Prestigious Triple Crown Country Club Community! Award Winning New Haven, Gray, & Ryle Schools/Low County Tax Rate/Perfectly Appointed Near Winner's Circle Park on Premium Cul-De-Sac ST/Entertainer's Dream Boasting Incredible Outdoor Living/Expansive, Covered Front Porch, Massive, Rear Covered Deck w/Cathedral Ceilings & Floor to Ceiling Stone FP w/Uncovered Deck Area as well/Soaring, 9 FT Ceilings Throughout/ 3 Tray Ceilings/Desirable, 1st FL Study w/French Doors/Inviting GREAT RM/Spectacular, Gourmet KIT w/Double Oven, Granite Counters, Counter Bar w/Gas, 6 Burner Cooktop, Stainless Steel Appliances, 42 IN Cabinetry w/ Crown Molding, Multiple, Walk-In Pantries, & Oversized Breakfast Area/Relaxing SUNROOM/One of a Kind, 1ST FL Laundry RM, Mudroom, Craft RM w/Walls of Cabinetry, Desk Area, LG Closet, & Space for Refrigerator/2 Luxurious 1ST FL Owner's Suites/Fabulous Owner's Bath/Enormous Walk-In Closet/FIN LL w/Wet Bar, Lots of Windows, Walkout & Columned Accents/2 FP's/Built-In Speakers/+ MORE! BEST OF EVERYTHING 13022 Barbaro Drive, Union
$1,500,000 Welcome to your dream luxury home, where sophistication meets comfort & tranquility*This stunning property boasts the finest quality finishes, cutting-edge design & a prime location in one of NKY's most desirable neighborhoods*Upon entering, you will be greeted by the grand foyer that leads into the spacious & inviting living room, perfect for entertaining or relaxing*A gourmet chef's kitchen features top-of-the-line SS appliances, custom cabinetry & a lg center island, ideal for creating culinary masterpieces*The primary suite is a true oasis, offering a spa-like bathroom with a soaking tub, walk-in shower & a large walk-in closet*The property features a plethora of entertainment options, including a lg family room, a game room & a sauna steam shower*The expansive backyard offers an outdoor living area with a sparkling pool with a Smart Pool System & spa overlooking the tranquil stocked lake*This luxurious home also boasts high-end finishes, hardwood flooring, custom lighting, & state-of-the-art technology, including a home automation system that controls security, lighting, sound & climate*Central vac system, 3 car side entry garage, 2 laundry rooms & 4 Fireplaces. 5 Beds ⋅ 5 Baths ⋅ 614254 MLS Welcome to your dream luxury home, where sophistication meets comfort & tranquility*This stunning property boasts the finest quality finishes, cutting-edge design & a prime location in one of NKY's most desirable neighborhoods*Upon entering, you will be greeted by the grand foyer that leads into the spacious & inviting living room, perfect for entertaining or relaxing*A gourmet chef's kitchen features top-of-the-line SS appliances, custom cabinetry & a lg center island, ideal for creating culinary masterpieces*The primary suite is a true oasis, offering a spa-like bathroom with a soaking tub, walk-in shower & a large walk-in closet*The property features a plethora of entertainment options, including a lg family room, a game room & a sauna steam shower*The expansive backyard offers an outdoor living area with a sparkling pool with a Smart Pool System & spa overlooking the tranquil stocked lake*This luxurious home also boasts high-end finishes, hardwood flooring, custom lighting, & state-of-the-art technology, including a home automation system that controls security, lighting, sound & climate*Central vac system, 3 car side entry garage, 2 laundry rooms & 4 Fireplaces. 10782 Omaha Trace, Union
$2,750,000 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!! 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