$590,000 Reduced! Motivated seller! Why wait to build when you can move into this spacious 5 bedroom home in the sought after Hampshire subdivision in Union with low Boone County taxes and community pool amenities. Offering approximately 5,000 square feet across three finished levels, this home blends elegance and comfort with incredible spaces for entertaining both indoors and outdoors. Highlights include a soaring two story living room, new roof, fresh paint, new furnace in 2023, and new carpet in the media room in 2025. The gourmet kitchen features granite countertops, an oversized center island, updated appliances, and a bright breakfast area. Step outside to the Trex deck overlooking a private backyard perfect for gatherings or quiet evenings. The primary suite includes a gas fireplace and a luxurious ensuite bathroom. The finished lower level is ideal for entertaining with a wet bar, media room, fifth bedroom, and full bath. Situated on a cul de sac with abundant natural light and backyard privacy. All information believed accurate but buyer to verify. 5 Beds ⋅ 4 Baths ⋅ 636394 MLS Reduced! Motivated seller! Why wait to build when you can move into this spacious 5 bedroom home in the sought after Hampshire subdivision in Union with low Boone County taxes and community pool amenities. Offering approximately 5,000 square feet across three finished levels, this home blends elegance and comfort with incredible spaces for entertaining both indoors and outdoors. Highlights include a soaring two story living room, new roof, fresh paint, new furnace in 2023, and new carpet in the media room in 2025. The gourmet kitchen features granite countertops, an oversized center island, updated appliances, and a bright breakfast area. Step outside to the Trex deck overlooking a private backyard perfect for gatherings or quiet evenings. The primary suite includes a gas fireplace and a luxurious ensuite bathroom. The finished lower level is ideal for entertaining with a wet bar, media room, fifth bedroom, and full bath. Situated on a cul de sac with abundant natural light and backyard privacy. All information believed accurate but buyer to verify. 2011 Holderness Drive, Union
$492,800 Stunning 4 BDRM, 4 Bath, Drees-Built Ashton on Hard to Find, .28 Acre Level Homesite in Desirable French Quarter/Orleans Neighborhood! Award Winning Longbranch Elementary, Ballyshannon Middle, & Cooper High School District/3 FINISHED LEVELS w/APPROX 3,100 SQ FT in Total Living Space/Remarkable Fit & Finish w/Meticulous Attention to Detail/Impressive Entry w/Multiple Closets, Side Staircase, & Arched Niche w/Decorative Window/Expansive Great RM w/3 Oversized Windows & Open to Kitchen Area/State of the Art Granite Kitchen w/Upscale Appliances Including Double Oven, Gas Cooktop, Refrigerator, Built-In Microwave, & Dishwasher/Kitchen has Large Island with Counter Bar, Upgraded Staggered Cabinetry, Pendant & Recessed Lighting, Lots of Counter Space, Pantry, Adjoining Breakfast Area, & French Patio Door Walkout to Patio & Beautiful, Rear Lot/Inviting Dining RM/1ST FL Laundry RM/Fabulous Primary Suite w/Soaring Ceilings, Lots of Closet Space & Adjoining Luxurious Bath/2ND FL Gathering RM/Plushly FIN LL w/REC RM, 1/2 Bath, & 2 Storage RM's/New Carpeting/Freshly Painted/Upgraded Trim Package/Low Tax Rate/+ MUCH MORE! Outstanding Location Close to CVG Airport & Downtown Cincinnati 4 Beds ⋅ 4 Baths ⋅ 633822 MLS Stunning 4 BDRM, 4 Bath, Drees-Built Ashton on Hard to Find, .28 Acre Level Homesite in Desirable French Quarter/Orleans Neighborhood! Award Winning Longbranch Elementary, Ballyshannon Middle, & Cooper High School District/3 FINISHED LEVELS w/APPROX 3,100 SQ FT in Total Living Space/Remarkable Fit & Finish w/Meticulous Attention to Detail/Impressive Entry w/Multiple Closets, Side Staircase, & Arched Niche w/Decorative Window/Expansive Great RM w/3 Oversized Windows & Open to Kitchen Area/State of the Art Granite Kitchen w/Upscale Appliances Including Double Oven, Gas Cooktop, Refrigerator, Built-In Microwave, & Dishwasher/Kitchen has Large Island with Counter Bar, Upgraded Staggered Cabinetry, Pendant & Recessed Lighting, Lots of Counter Space, Pantry, Adjoining Breakfast Area, & French Patio Door Walkout to Patio & Beautiful, Rear Lot/Inviting Dining RM/1ST FL Laundry RM/Fabulous Primary Suite w/Soaring Ceilings, Lots of Closet Space & Adjoining Luxurious Bath/2ND FL Gathering RM/Plushly FIN LL w/REC RM, 1/2 Bath, & 2 Storage RM's/New Carpeting/Freshly Painted/Upgraded Trim Package/Low Tax Rate/+ MUCH MORE! Outstanding Location Close to CVG Airport & Downtown Cincinnati 8663 Eden Court, Union
$649,800 OPEN HOUSE CANCELED - HOME IS PENDING. Stunning 4 BDRM, 4 Bath MASTERPIECE w/3 Car Garage (2 Spaces, but SQ FT of a 3 Car Garage) on Perfectly Appointed Homesite in Desirable Ballyshannon! Incredible Outdoor Paradise Offering the Ultimate Lifestyle Including Spectacular, Inground Pool w/Concrete Surround, APPROX 400 SQ FT 2-Tiered Deck w/Steps to Rear Lot, 180 SQ FT Patio, Aluminum Fencing, & Evergreen Treeline/3 FIN LEVELS w/APPROX 4000 SQ FT in Award Winning Longbranch, Ballyshannon, & Cooper School District/Close to CVG Airport & Cincy/Remarkable Fit & Finish w/Meticulous Attention to Detail/State of the Art Upgrades/Soaring, 2 Story Great RM has Fireplace w/Reclaimed Wood Accents & Mantle/9 FT Ceilings on 1ST FL & in LL/Lots of HDWD Flooring/Fantastic High-End Finishes/Impressive Entry/1ST FL Study w/French Drs, Crown Molding, & New Custom Built-In's/Gourmet Granite KIT w/Massive Island, Gas Range, Staggered, White & Java Cabinetry, & ADJ Breakfast Area/1ST FL Hearth RM/Mudrm w/Cubbies/Luxurious Owner's Suite/2ND FL Laundry/Plushly FIN LL w/Walkout, Granite Wet Bar, REC RM, Full Bath, & 2 Storage RM's/New Carpeting/New, Upgraded HVAC/New H2O Heater & Back Door/ + MORE! 4 Beds ⋅ 4 Baths ⋅ 633820 MLS OPEN HOUSE CANCELED - HOME IS PENDING. Stunning 4 BDRM, 4 Bath MASTERPIECE w/3 Car Garage (2 Spaces, but SQ FT of a 3 Car Garage) on Perfectly Appointed Homesite in Desirable Ballyshannon! Incredible Outdoor Paradise Offering the Ultimate Lifestyle Including Spectacular, Inground Pool w/Concrete Surround, APPROX 400 SQ FT 2-Tiered Deck w/Steps to Rear Lot, 180 SQ FT Patio, Aluminum Fencing, & Evergreen Treeline/3 FIN LEVELS w/APPROX 4000 SQ FT in Award Winning Longbranch, Ballyshannon, & Cooper School District/Close to CVG Airport & Cincy/Remarkable Fit & Finish w/Meticulous Attention to Detail/State of the Art Upgrades/Soaring, 2 Story Great RM has Fireplace w/Reclaimed Wood Accents & Mantle/9 FT Ceilings on 1ST FL & in LL/Lots of HDWD Flooring/Fantastic High-End Finishes/Impressive Entry/1ST FL Study w/French Drs, Crown Molding, & New Custom Built-In's/Gourmet Granite KIT w/Massive Island, Gas Range, Staggered, White & Java Cabinetry, & ADJ Breakfast Area/1ST FL Hearth RM/Mudrm w/Cubbies/Luxurious Owner's Suite/2ND FL Laundry/Plushly FIN LL w/Walkout, Granite Wet Bar, REC RM, Full Bath, & 2 Storage RM's/New Carpeting/New, Upgraded HVAC/New H2O Heater & Back Door/ + MORE! 5057 Loch Drive, Union
$677,000 COMPARE TO NEW! Remarkable, Ranch Home with APPROX 4000 SQ FT of Livable Space Including Finished Lower Level/4 BDRM, 3 Full Bath, 3 Car Garage Residence on an APPROX 1/2 Acre Premium Homesite in Red Stone Village! Perfectly Appointed at the End of a Beautiful Cul-De-Sac Street Backing Up to LASSING POINTE GOLF COURSE/Award Winning New Haven, Gray, & Ryle Schools/Low County Tax Rate/Covered Front Porch, Massive Rear Deck, & Hard to Find Private Setting/Open Airy Floorplan w/Lots of Natural Light/Elaborate Moldings/Soaring, 9 FT Ceilings Throughout/Hardwood Flooring/Desirable Design with Inviting GREAT RM Boasting Stone Fireplace & Wall of Windows/Spectacular, Gourmet KIT w/Granite Counters, Counter Bar, Gas Range, Stainless Steel Appliances, Staggered Cabinetry w/ Crown Molding, + Oversized Breakfast Area/1ST FL Laundry RM/Butler's Pantry/Amazing Primary Suite with Corner Windows & Adjoining Deluxe, Luxury Bath/Large Walk-In Closet with Closet Organizers/FINISHED LL w/Wet Bar in Pub Room, Recreation RM w/Walkout, True 4TH BEDROOM w/Closet & Egress Window, Adjacent Full Bath, + Tons of Storage/Oversized Windows/Silhouette Blinds//Lots of Recessed Lighting Throughout/ + MUCH MORE! 4 Beds ⋅ 3 Baths ⋅ 633475 MLS COMPARE TO NEW! Remarkable, Ranch Home with APPROX 4000 SQ FT of Livable Space Including Finished Lower Level/4 BDRM, 3 Full Bath, 3 Car Garage Residence on an APPROX 1/2 Acre Premium Homesite in Red Stone Village! Perfectly Appointed at the End of a Beautiful Cul-De-Sac Street Backing Up to LASSING POINTE GOLF COURSE/Award Winning New Haven, Gray, & Ryle Schools/Low County Tax Rate/Covered Front Porch, Massive Rear Deck, & Hard to Find Private Setting/Open Airy Floorplan w/Lots of Natural Light/Elaborate Moldings/Soaring, 9 FT Ceilings Throughout/Hardwood Flooring/Desirable Design with Inviting GREAT RM Boasting Stone Fireplace & Wall of Windows/Spectacular, Gourmet KIT w/Granite Counters, Counter Bar, Gas Range, Stainless Steel Appliances, Staggered Cabinetry w/ Crown Molding, + Oversized Breakfast Area/1ST FL Laundry RM/Butler's Pantry/Amazing Primary Suite with Corner Windows & Adjoining Deluxe, Luxury Bath/Large Walk-In Closet with Closet Organizers/FINISHED LL w/Wet Bar in Pub Room, Recreation RM w/Walkout, True 4TH BEDROOM w/Closet & Egress Window, Adjacent Full Bath, + Tons of Storage/Oversized Windows/Silhouette Blinds//Lots of Recessed Lighting Throughout/ + MUCH MORE! 2563 Twin Hills Court, Union
$308,575 Ask how you can lock your interest rate on this home today! Step into the Drees Homes Caywood—a stylish 3-bed, 2-bath condo in Harmony Bluffs. Enjoy open-concept living with 9' ceilings, quartz counters, a spacious island, walk-in pantry, and covered deck perfect for relaxing. The primary suite features double vanities and generous walk-in closets. Smart home features like a video doorbell and smart lock offer modern convenience. Enjoy community amenities like an adult-only pool, a kids' splash area, and scenic walking paths leading to a tranquil lake. Conveniently located near Kroger Marketplace and the vibrant Union Promenade, this home perfectly balances serenity and accessibility—all within the Boone County school district. Your dream lifestyle is waiting! 3 Beds ⋅ 2 Baths ⋅ 631986 MLS Ask how you can lock your interest rate on this home today! Step into the Drees Homes Caywood—a stylish 3-bed, 2-bath condo in Harmony Bluffs. Enjoy open-concept living with 9' ceilings, quartz counters, a spacious island, walk-in pantry, and covered deck perfect for relaxing. The primary suite features double vanities and generous walk-in closets. Smart home features like a video doorbell and smart lock offer modern convenience. Enjoy community amenities like an adult-only pool, a kids' splash area, and scenic walking paths leading to a tranquil lake. Conveniently located near Kroger Marketplace and the vibrant Union Promenade, this home perfectly balances serenity and accessibility—all within the Boone County school district. Your dream lifestyle is waiting! 8540 Concerto Court, Union
$445,000 Welcome home to this meticulously maintained gracious retreat! This property features 4 bedrooms at 3 FULL and 1 half bathrooms. This property boasts a chef's kitchen appointed with granite counter tops, island, stainless steel appliances and a gas cook top and an eat in area which opens up to the great room and is perfect for entertaining. The 1st floor also offers a formal dining room and home office with French doors. The second floor offers a spacious master with ensuite bath. The additional 3 bedrooms, loft and laundry are also on the second level. The finished basement is a perfect bonus for additional entertaining with a full wet bar! The rear patio offers a sheltered hot tub for your enjoyment. Mann/Gray/Ryle schools. This is a must see with immediate occupancy! 4 Beds ⋅ 4 Baths ⋅ 630499 MLS Welcome home to this meticulously maintained gracious retreat! This property features 4 bedrooms at 3 FULL and 1 half bathrooms. This property boasts a chef's kitchen appointed with granite counter tops, island, stainless steel appliances and a gas cook top and an eat in area which opens up to the great room and is perfect for entertaining. The 1st floor also offers a formal dining room and home office with French doors. The second floor offers a spacious master with ensuite bath. The additional 3 bedrooms, loft and laundry are also on the second level. The finished basement is a perfect bonus for additional entertaining with a full wet bar! The rear patio offers a sheltered hot tub for your enjoyment. Mann/Gray/Ryle schools. This is a must see with immediate occupancy! 10177 Cardigan Drive, Union
$660,000 Hurry as this home could be yours to enjoy the upcoming Holidays with Family and Friends. Spectacular 4 BR/3.5 BA on almost a 1/2 acre fenced, level, lot in prestigious Red Stone Village. Ryle HS. This fabulous home has over 4000 sf of finished space w/highly desirable 1st floor Master suite w/Adj bath and walk in closet. Freshly finished hardwood floors in the Entry, private Study, Dining room, 2 story Great Room, 1/2 bath, dinette and Kitchen.All 4 bedrooms are oversized. The 2 story Great room has a gas fireplace, a wall of windows and looks out to the private tree lined yard. Gourmet kitchen has a gas cook top, double wall ovens, pantry and not one but TWO 8 feet by 3 feet granite counter islands. 1st fl laundry attached to oversized 3 car garage. Lower level has a 4th bedroom, full bath, a 37 x 18 foot Family room with Billiard table, wet bar and a gorgeous Theatre room. Media room has 3 sets of tray ceilings for ''mood lighting'', and includes the projection equipment and the leather sectional.Central Vac.New furnace, new water softener. Home faces West. Welcome to your forever home. Immediate occupancy. 4 Beds ⋅ 4 Baths ⋅ 628681 MLS Hurry as this home could be yours to enjoy the upcoming Holidays with Family and Friends. Spectacular 4 BR/3.5 BA on almost a 1/2 acre fenced, level, lot in prestigious Red Stone Village. Ryle HS. This fabulous home has over 4000 sf of finished space w/highly desirable 1st floor Master suite w/Adj bath and walk in closet. Freshly finished hardwood floors in the Entry, private Study, Dining room, 2 story Great Room, 1/2 bath, dinette and Kitchen.All 4 bedrooms are oversized. The 2 story Great room has a gas fireplace, a wall of windows and looks out to the private tree lined yard. Gourmet kitchen has a gas cook top, double wall ovens, pantry and not one but TWO 8 feet by 3 feet granite counter islands. 1st fl laundry attached to oversized 3 car garage. Lower level has a 4th bedroom, full bath, a 37 x 18 foot Family room with Billiard table, wet bar and a gorgeous Theatre room. Media room has 3 sets of tray ceilings for ''mood lighting'', and includes the projection equipment and the leather sectional.Central Vac.New furnace, new water softener. Home faces West. Welcome to your forever home. Immediate occupancy. 10869 Crayton Way, Union
$417,500 Ask how you can lock your interest rate on this home today! The Drees Ventura is a stunning three bedroom townhome with a loft that effortlessly combines comfort and style. The first floor features a luxurious primary suite with a spacious bath and a huge walk-in closet, offering a peaceful retreat. The heart of the home is the kitchen, complete with a central island and large pantry, next to a cozy dining area and a bright family room with vaulted ceilings. A guest bedroom and full bath add privacy. Upstairs, a versatile game room overlooks the family room, along with a third bedroom and full bath. Relax on the covered patio or enjoy nearby dining and shopping at Union Promenade. All in Boone County schools. 3 Beds ⋅ 3 Baths ⋅ 628342 MLS Ask how you can lock your interest rate on this home today! The Drees Ventura is a stunning three bedroom townhome with a loft that effortlessly combines comfort and style. The first floor features a luxurious primary suite with a spacious bath and a huge walk-in closet, offering a peaceful retreat. The heart of the home is the kitchen, complete with a central island and large pantry, next to a cozy dining area and a bright family room with vaulted ceilings. A guest bedroom and full bath add privacy. Upstairs, a versatile game room overlooks the family room, along with a third bedroom and full bath. Relax on the covered patio or enjoy nearby dining and shopping at Union Promenade. All in Boone County schools. 9644 Venice Street, Union
$287,000 Ask how you can lock your interest rate on this home today! Brand new Drees floor plan in desirable Harmony Bluffs. The 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 pool and splash area, outdoor amphitheater, fitness center, and walking paths. Conveniently located near Kroger Marketplace and the highly anticipated shopping and restaurants of the Union Promenade entertainment district! All within Boone Country school district. 3 Beds ⋅ 2 Baths ⋅ 625581 MLS Ask how you can lock your interest rate on this home today! Brand new Drees floor plan in desirable Harmony Bluffs. The 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 pool and splash area, outdoor amphitheater, fitness center, and walking paths. Conveniently located near Kroger Marketplace and the highly anticipated shopping and restaurants of the Union Promenade entertainment district! All within Boone Country school district. 8481 Concerto Court, Union
$377,000 Fabulous, Upscale 3 BDRM, 3 Bath, 2 Car Garage, ONE STORY, END UNIT Superbly Situated on Scenic Homesite w/Picturesque Pond & Golf Course Views in Prestigious Triple Crown Country Club Community! Inviting, Extremely Private Setting Which is Truly an Entertainer's Dream/Relaxing Screened Porch & Expansive Deck/Lush 18 Hole Golf Course Community/Low County Taxes/This Generously Sized Landominium Boasting 2 FIN LEVELS (2,674 Living SQ FT), Soaring 10 FT Ceilings, & Oversized Windows w/Transoms Will Delight You/Impressive Entry/Spectacular, Sun-Filled, Great RM Offering Walls of Windows, Gas Fireplace, & Crown Molding/Great RM Could be LVR/DNR Combo/Fully Equipped KIT has Adjoining Breakfast Area, Counter Bar, Butler's Pantry, Crown Molding, & Newer Stainless Steel Appliances/Breakfast Area has Walkout to Amazing Deck & View/1ST FL Study with French Doors/1ST FL Primary Suite has Luxurious Bath w/Double Bowl Sinks, Whirlpool Tub, & Separate Shower/1ST FL Laundry RM/Plushly FIN LL w/REC RM, BDRM, Hobby RM, Full Bath, & Walkout to Porch/Cedar Closet/HDWD Flooring/Hard to Find 24x15 Storage RM/Award Winning New Haven, Gray, & Ryle Schools/ + MUCH MORE! Witness LIFESTYLE at it's Finest! 3 Beds ⋅ 3 Baths ⋅ 624176 MLS Fabulous, Upscale 3 BDRM, 3 Bath, 2 Car Garage, ONE STORY, END UNIT Superbly Situated on Scenic Homesite w/Picturesque Pond & Golf Course Views in Prestigious Triple Crown Country Club Community! Inviting, Extremely Private Setting Which is Truly an Entertainer's Dream/Relaxing Screened Porch & Expansive Deck/Lush 18 Hole Golf Course Community/Low County Taxes/This Generously Sized Landominium Boasting 2 FIN LEVELS (2,674 Living SQ FT), Soaring 10 FT Ceilings, & Oversized Windows w/Transoms Will Delight You/Impressive Entry/Spectacular, Sun-Filled, Great RM Offering Walls of Windows, Gas Fireplace, & Crown Molding/Great RM Could be LVR/DNR Combo/Fully Equipped KIT has Adjoining Breakfast Area, Counter Bar, Butler's Pantry, Crown Molding, & Newer Stainless Steel Appliances/Breakfast Area has Walkout to Amazing Deck & View/1ST FL Study with French Doors/1ST FL Primary Suite has Luxurious Bath w/Double Bowl Sinks, Whirlpool Tub, & Separate Shower/1ST FL Laundry RM/Plushly FIN LL w/REC RM, BDRM, Hobby RM, Full Bath, & Walkout to Porch/Cedar Closet/HDWD Flooring/Hard to Find 24x15 Storage RM/Award Winning New Haven, Gray, & Ryle Schools/ + MUCH MORE! Witness LIFESTYLE at it's Finest! 10414 Masters Drive, Union
$482,500 Located in prestigious Triple Crown, this lovely 4 bedroom, 2 1/2 bath, home is ready to welcome you! With three levels of living space, you'll enjoy an open family room with a gas fireplace, formal dining room, eat-in kitchen with granite counters, laundry room, breakfast area, office and half bath on the 1st floor. Conveniently accessible from the kitchen, the spacious back deck provides a serene view of the wooded yard. Located on the 2nd level, you'll find the spacious primary en-suite with jetted tub, 3 additional bedrooms, full bathroom & bonus room open to the back stairs. The finished lower level offers built ins, storage, walkout access and new LVP flooring. HVAC, water heater and roof are just 5 years old! Call today to schedule your private showing. 4 Beds ⋅ 3 Baths ⋅ 614762 MLS Located in prestigious Triple Crown, this lovely 4 bedroom, 2 1/2 bath, home is ready to welcome you! With three levels of living space, you'll enjoy an open family room with a gas fireplace, formal dining room, eat-in kitchen with granite counters, laundry room, breakfast area, office and half bath on the 1st floor. Conveniently accessible from the kitchen, the spacious back deck provides a serene view of the wooded yard. Located on the 2nd level, you'll find the spacious primary en-suite with jetted tub, 3 additional bedrooms, full bathroom & bonus room open to the back stairs. The finished lower level offers built ins, storage, walkout access and new LVP flooring. HVAC, water heater and roof are just 5 years old! Call today to schedule your private showing. 1105 Grindstone Court, Union