Refine Search
Sort by
$619,999
4 Beds 3 Baths 643966 MLS
Beautiful full brick wrap home nestled on a private wooded cul-de-sac lot in Westbrook! This popular Mariemont floor-plan, crafted by Arlinghaus builders, features an attractive multi-gabled elevation w/ mature landscaping, covered front porch, massive extended driveway, plus a 3-car garage. 9 ft ceilings on the main level, tasteful décor, 6 panels doors w/ brushed nickel hardware, & cased windows throughout. Inviting foyer w/ leaded glass sidelights on front door, coat closet, LVT, & adjacent study w/ glass French doors. Open main living room boasts crown molding, LVT, ceiling fan, gas fireplace, built-ins, & peaceful wooded views. Gorgeous eat-in kitchen includes granite, tiled backsplash, island w/ pendulum lights, staggered cabinets w/ crown, SS appliances, LVT, & adjoining breakfast room w/ walkout. Family foyer has built ins and leads to the oversized garage. Huge primary suite enhanced by soaring cathedral ceilings, recessed lights, fan, walk-in closet, plus an awesome tiled bath w/ granite topped double vanity, garden tub, & shower. 2nd level family room w/ fan & convenient laundry room. 3 additional bedrooms w/ fans & walk in closets. Finished lower level includes LVT & walkout to the patio. 2 generously sized unfinished spaces in LL provide tons of storage or potential for many other uses. Enjoy the expansive composite deck featuring aluminum railings & tranquil wooded views overlooking the fenced rear yard. The additional lot offers a secluded ''Nature Getaway'' perfect for camping, outdoor activities, & firepit gatherings. Well established community w/ tree-lined streets, pool, & farmland views. Close proximity to shopping, restaurants, interstate, & the new high end entertainment district of the Union Promenade.

9350 Westfield Lane, Union

$599,000
4 Beds 4 Baths 643944 MLS
Look no more! Stunning home! Cul-de-sac! Rooms for days! Gourmet kitchen with counter bar and island! 1st floor study/office, gorgeous solarium. 18x15 hang out space for the kids over the garage! Open floor plan. Enjoy family time on the covered patio with stamped concrete! Fencing perfect for your pets. Three car garage with electric outlet for an EV car! Beautiful primary bath with large shower, soaking tub, dual sinks, updated lighting and his-hers large walk-in closets! Unfinished basement with appx, 1100 sf of space to finish plus rough-in! 8 mo old Furnaces and 8/9 yrs on two ACs. Check out all the upgrades in the attached feature sheet! Beautiful clubhouse to rent for parties or use the fitness center or pool!

2552 Beauregard Place, Union

$389,900
3 Beds 3 Baths 643916 MLS
Welcome home to this well maintained 5 year-old 3 bed 2.5 bath home with an upstairs loft in Ballyshannon. The large inviting front porch is the perfect way to welcome guests or sit and relax. The home offers over 2100 sq ft of well-designed living space with an open concept family, dining and kitchen space. Walkout onto your oversized deck (Freshly painted) overlooking your flat backyard. An additional room on the main floor could be used as a second living space, office, kids playroom or anything your needs require. A half bath completes the main floor. Upstairs you will find two large sized bedrooms with ample closet space and a primary retreat that is the perfect place to wind down at the end of the day with en suite complete with walk-in shower, soaking tub and double vanity. A large loft offers another unique flex space that could be turned into a 4th bedroom if needed. The unfinished basement is perfect for additional storage or future additional living space, complete with walkout. Enjoy all the natural light in the home, 5 yr old roof, HVAC and water heater and rest easy in a great location only minutes to the Union Promenade, and all that Union has to offer.

2344 Slaney Lane, Union

$539,000
4 Beds 4 Baths 643896 MLS
Open House Sunday July 26 1-2 ;30 pm WOW! Welcome to your beautiful home... at the French Quarter, at Orleans in Union, KY! This Better than NEW, 4 Bedroom, 4 Bathroom, Two Story Dream Home is a rare opportunity that boasts 3 levels of living space. check out the Outdoor Private Deck, Outdoor living space w/paver patio large fenced in backyard, with upgraded landscaping Gourmet Kitchen, wet Bar, Sunroom, formal dining, breakfast area, oversized kitchen island, , grand primary bedroom w/ sitting area, primary remodeled bathroom Including designer's shower, oversized bedrooms, and walk in closets, large second story loft, area, full bathroom in lower level. Neighborhood amenities include community pool, wooded walking trails, community park w/ sand volley ball, tennis court, basketball court, picnic area, stocked ponds, and so much more! Coveted Union School district Cooper High, Ballyshannon Middle,

8397 Saint Louis Boulevard, Union

$865,000
6 Beds 5 Baths 643834 MLS
A home of this caliber is only offered in the prestigious community of Triple Crown Country Club. Thoughtfully designed for elevated living and unforgettable entertaining, this extraordinary executive residence blends timeless sophistication with exceptional comfort across every level. Soaring 10-foot ceilings, elegant architectural details, and expansive living spaces create a grand yet welcoming atmosphere from the moment you enter. The chef-inspired kitchen is beautifully appointed with high-end appliances, quartz countertops, abundant cabinetry, and an oversized pantry, flowing seamlessly into the impressive great room anchored by a stunning stone fireplace. A formal dining room provides the perfect setting for intimate dinners and holiday gatherings alike. Upstairs, each generously sized bedroom offers its own walk-in closet and adjoining bath, while the luxurious primary suite serves as a true private retreat featuring dual vanities, a spa-like soaking tub, and an extraordinary walk-in closet that feels more like a designer boutique than a closet. Beyond the interior, the resort-style outdoor living space was designed to rival a private retreat, complete with a fully equipped outdoor kitchen, bar, fireplace, and tranquil water feature, creating an unparalleled setting for entertaining beneath the stars. The finished walk-out lower level offers the ultimate destination for relaxation and recreation, currently serving as an incredible man cave with ample space for game days, movie nights, and gatherings, while also offering egress and flexibility for a future sixth bedroom. Meticulously maintained and beautifully updated, this exceptional residence delivers the luxury, scale, and lifestyle expected in one of Northern Kentucky's most prestigious communities, just moments from Triple Crown Country Club, premier dining, shopping, and convenient access to Cincinnati.

11120 War Admiral Drive, Union

$435,000
4 Beds 4 Baths 643822 MLS
Welcome to Harmony--one of Union's most sought-after communities! Enjoy resort-style amenities including 3 swimming pools, a clubhouse, fitness center, walking trails, lake, parks, playgrounds, and more. Perfectly located just 7 houses from the community park and playground, this beautifully updated 4-bedroom, 4-bath home offers the space, comfort, and convenience you've been looking for. A welcoming front porch and inviting entryway lead to a formal dining room and a spacious eat-in kitchen featuring abundant cabinetry, a large pantry, and plenty of room to gather. The kitchen flows seamlessly into the cozy family room with a fireplace. Upstairs, you'll find four bedrooms plus a versatile loft--ideal for a second living area, home office, playroom, workout space, or possible 5th bedroom. The newly finished basement provides even more room for entertaining, movie nights, and everyday living. Step outside to enjoy the spacious patio, charming trellis, and flat fenced backyard--perfect for relaxing, entertaining, or play. ✨ HVAC replaced in 2023 ✨ Roof replaced in 2023 Conveniently located near the Union Promenade, dining, shopping, I-75, and just minutes from the new Publix. This is more than a home--it's a chance to enjoy the lifestyle that makes Harmony such a special place to live.

9765 Soaring Breezes, Union

$524,900
4 Beds 3 Baths 643808 MLS
Built in 2023, this Fischer Homes Avery plan in Ballyshannon delivers five levels of thoughtfully designed living -- without the construction timeline. 4 bedrooms, 2.5 baths. The two-story family room anchors the home with dramatic volume, flowing into an open kitchen with a large island and walk-in pantry -- built for people who actually gather. A dedicated recreation room sits just steps below, giving you flexible space for whatever your life calls for. The owner's suite lives on its own private level -- a genuine retreat. The shower has been upgraded, and the walk-in closet connects directly to the upstairs laundry room. That's not an accident -- that's a design win. Outside, a deck with steps leading to yard level and a black powder-coated aluminum fence make the backyard functional from day one. No projects. No contractors. Just move in. Community pool and amenities round out the package -- Ballyshannon delivers the neighborhood lifestyle without compromise. Refrigerator included. Fence done. Deck done. Shower upgraded.

4720 Donegal Avenue, Union

$817,679
4 Beds 5 Baths 643734 MLS
New construction in the beautiful Justify at Triple Crown community, featuring the stunning Pearson design. This sophisticated design offers 4 bedrooms, 4 full baths, and 1 half bath. The open-concept layout connects the spacious 2-story family room with expansive kitchen, featuring a large island, quartz countertops, and generous pantry space. The morning room walks outside to a covered patio fireplace. Included on the main floor is a generational suite complete with a full bath, laundry closet, and a private retreat room. Private study through French doors from the main entry foyer. The primary suite serves as a luxurious personal retreat with walk-in closet and en-suite bathroom. This home provides the perfect blend of style, comfort, and adaptability. The spacious 3-bay garage completes this exceptional home.

409 Flightline Drive, Union

$575,000
4 Beds 3 Baths 643714 MLS
Brand New Energy-Efficient Home by Arlinghaus Builders in Ballyshannon! The Rosewood floor plan delivers an open, airy layout and thoughtful upgrades throughout. Home Highlights: Covered deck perfect for relaxing or entertaining, High ceilings and luxury vinyl plank flooring throughout the main living areas, Gourmet kitchen with granite countertops, tile backsplash, large island, Double ovens, electric cooktop and stylish cabinetry, First-floor laundry for added convenience, Spacious first floor Owner's Suite: Features a large tiled shower, soaking tub, double vanity, and linen cabinet. A private retreat designed for relaxation, Second Floor Features: 3 generously sized bedrooms, each with walk-in closets, Full bathroom and versatile loft space ideal for a home office, playroom, or lounge, Energy-Efficient Features: Durable brick exterior, High-performance Trane gas heating system, Tankless water heater for endless hot water and lower utility cost.

6171 Vintage Fleet Lane, Union

$375,000
3 Beds 3 Baths 643661 MLS
Elevate your lifestyle in this stunning, fully renovated abode, where breathtaking luxury meets unparalleled excellence at every step. The kitchen is a true masterpiece, radiating splendor with sublime high-end features like gleaming quartz countertops, open shelving, premium gas range, a spacious pantry, a stylish farmhouse sink, and sleek stainless steel appliances. The interior of this magnificent home shines with a fresh coat of paint and is adorned with luxurious vinyl plank flooring throughout, exuding warmth and refined sophistication. Additional highlights includes a newer gas fireplace with upgraded mantel, conveniently located main floor laundry, upgraded Lenox furnace, Champion windows that allows for natural light. Finished basement, fenced back yard for entertaining and much more. It's located in the Ryle School District and close to shopping and restaurants, making it an ideal haven.

1230 Edinburgh Lane, Union

$453,000
4 Beds 4 Baths 643640 MLS
Now under construction by Arlinghaus Builders, this stunning new home is located in the highly desirable Ballyshannon community. This Jefferson floor plan offers an open-concept layout with numerous upgrades, including a finished walkout lower level. The inviting kitchen features granite countertops, stainless steel appliances, and a spacious island that seamlessly connects to the main living area--ideal for both everyday living and entertaining. A welcoming open foyer with elegant wood and iron spindle detailing sets the tone for the home, while a second-floor laundry and versatile loft add comfort and functionality. The luxurious primary suite is a true retreat, showcasing a double vanity, and a beautifully tiled shower. Enjoy the outdoors from the large deck with stairs leading to the finished walkout basement, complete with a family room and half bath. Tucked away on a peaceful wooded views, this brick-wrapped home offers the perfect blend of style, comfort, and privacy. Don't miss the opportunity to make this exceptional property yours--schedule a showing today!

6131 Vintage Fleet Lane, Union

$500,000
4 Beds 4 Baths 643619 MLS
This spacious home has 4352 finished square feet (this includes the basement). The first floor has beautiful hardwood floors throughout. The kitchen has been totally updated (2018) and there is a two story great room with a fireplace, formal living room, dining room and office with French doors. The second floor has all new carpet throughout and has a primary suite with a newly remodeled primary bathroom (2025). The finished walkout basement has a wet bar in the family room, a full bath and plenty of storage. Step outside to enjoy the private backyard oasis, complete with a spacious deck, large patio, and a hot tub that conveys with the home--perfect for year-round enjoyment. Additional major updates include a new roof (2022) and HVAC system (2019), offering peace of mind for years to come.

10996 War Admiral Drive, Union

$309,000
2 Beds 3 Baths 643609 MLS
Beautiful 2-story townhome featuring gorgeous hardwood floors, 2 spacious bedrooms, and 2.5 baths. The open-concept floor plan is perfect for entertaining, offering a spacious kitchen with a center island, breakfast nook, and plenty of cabinet space. Relax in the primary suite with a garden tub, and enjoy the versatility of the upstairs loft area. Convenient second-floor laundry adds to the home's functionality. Step outside to a private back porch overlooking a peaceful wooded setting. Located in a desirable community with exceptional amenities including a pool, clubhouse, playground, lake, and scenic walking trails. Conveniently located near shopping, dining, entertainment, and major highways--close to everything you need!

2034 Evening Star, Union

$590,000
5 Beds 4 Baths 643602 MLS
Ladies and gentlemen, let me introduce you to 10183 Lewis Ln.! Situated in a cul de sac in Hempsteade Manor - this property has EVERYTHING YOU COULD WANT! Spacious .67 AC lot is partially wooded and has a fenced back yard. GORGEOUS LANDSCAPING leads you to the fire pit where you will enjoy spending time with family and friends at the woods edge! This EXQUISITE home is IMMACULATE - attention has been paid to every detail. Thoughtfully designed to maximize living and entertaining space with STUNNING FINISHES. HARDWOOD FLOORING throughout the main level and BRAND NEW CARPETING on the upper level. This beauty features CROWN MOLDING, HARDWOOD FLOORING and versatile, SPACIOUS OPEN FLOOR PLAN! GOURMET KITCHEN FEATURES DOUBLE OVENS AND A BUTLER'S PANTRY THAT'S BETTER THAN PUBLIX! (You HAVE to see this)! The entire home is thoughtfully, intentionally & beautifully designed and decorated in a calm, soothing color palate. FULL WALKOUT BASEMENT IS MOSTLY FINISHED WITH WET BAR AND FULL BATH! HIGHLIGHTED WITH LUXURY VINYL FLOORING. Unfinished storage is immaculate and has sturdy, built-in storage. Lower level features a full bath, family room, wet bar, game area and hobby area (currently used as a home gym). Extra concrete has been poured to make parking for several cars easy and convenient. This home is a GEM! Need a home office, home gym, workshop, She Shed, Man Cave, hobby space? This versatile lower level area gives you EVERYTHING YOU NEED! New windows in 2023, new carpet in 2026, gutters with lifetime warranty, new furnace & heat pump 3/26. Boone Co. School District - RYLE, GRAY, MANN. Hempsteade is an upscale neighborhood and this home is a Drees Monroe model. Community features 2 pools, playground, tennis courts, lake and clubhouse. Located on a peaceful site on Lewis Ln. in Union - just minutes from the city and I-75. This one is MOVE-IN READY! CALL TODAY FOR A TOUR!

10183 Lewis Lane, Union

$722,525
5 Beds 5 Baths 643538 MLS
Welcome to this stunning 5-bedroom, 4.5-bath custom home situated on a beautiful wooded lot. Designed for both everyday living and entertaining, this home offers spacious living areas highlighted by soaring ceilings in the great room, creating an open and inviting atmosphere. The gourmet kitchen features granite countertops, custom cabinetry, stainless steel appliances, a large center island, pantry, and wet bar, while the bright four-season room provides the perfect place to relax and enjoy the private backyard setting. The thoughtful floor plan includes a main-level bedroom adjacent to a full bath and office, offering excellent flexibility for guests, multi-generational living, or a potential in-law suite. For added convenience, the home features laundry rooms on both the main level and lower level. The spacious primary suite features a large walk-in closet and an ensuite bath, while the additional bedrooms provide plenty of space for family and guests. The newly finished walkout lower level is truly a showstopper, featuring a huge entertaining island, kitchenette, game room, and dedicated theatre room--creating the ultimate space for gatherings, game days, and movie nights. Step outside to enjoy the in-ground pool, expansive deck, patio, and wooded views. Complete with a 3-car side-entry garage and access to walking trails leading to Ryle High School, this home offers an exceptional combination of space, comfort, entertainment, and flexibility.

10595 Mountain Laurel Way, Union

$227,000
2 Beds 2 Baths 643534 MLS
Open House canceled. Under contract. A beautiful townhome in the highly sought-after Promenade at Triple Crown, where convenience, value, and low-maintenance living come together perfectly. Nestled among mature trees with a peaceful wooded view, this well-appointed home offers access to scenic walking paths, creating an exceptional lifestyle at an unbeatable price. Inside, you'll find two spacious bedrooms upstairs, a full bath, along with generous closet space throughout. The heart of the home is the light-filled kitchen, featuring stainless steel appliances, abundant natural light, and an inviting atmosphere that makes it a joy to gather and entertain. Updated flooring flows throughout the home, complementing the large large living room with built-in features and a fireplace. Step outside to enjoy the private patio overlooking the tranquil wooded backdrop. The versatile lower level provides bonus space ideal for a home office, playroom, workout area, or additional living space--the possibilities are endless. An attached one-car garage offers exceptional convenience along with plenty of room for storage, hobbies, or outdoor gear. Offering the perfect blend of comfort, functionality, and location, this property truly has everything you need and more. Move-in ready and simply beautiful!

10828 Doral Court, Union

$525,000
4 Beds 3 Baths 643528 MLS
Welcome to 10704 Stone St., a Stunning Custom-Built Residence by renowned builder TW Jones, celebrated for uncompromising quality and timeless craftsmanship. Nestled in the prestigious Triple Crown golf course community, this 4-bedroom, 2.5-bath home sits on a private, quiet cul-de-sac surrounded by wonderful neighbors. Step inside to soaring 9-foot ceilings on the first floor that create an open, airy feel. The heart of the home features a gourmet granite island kitchen with beautiful hardwood floors, perfect for casual meals and entertaining. Adjacent is a cozy family room with a gas fireplace, ideal for relaxing evenings. All secondary bedrooms are exceptionally spacious, offering generous room for family, guests, or home offices. This thoughtfully designed home includes an expansive unfinished walkout lower level--already plumbed and ready for your personal vision. Finish it as a recreation room, home theater, additional bedrooms, or gym to instantly add significant living space and value. Highly sought-after location in the acclaimed Shirley Mann Elementary, Grey Middle, and Ryle High School district. Enjoy the tranquility and prestige of Triple Crown while being conveniently located to all amenities. A rare opportunity to own a premium custom home in one of the area's most desirable communities. Don't miss your chance to make this exceptional property yours!

10704 Stone Street, Union

$500,000
4 Beds 4 Baths 643458 MLS
Full brick wrap home nestled on a private beautiful lot in Triple Crown! Oversized fenced yard appointed by mature trees, paver patio w/ firepit, & new covered deck making this private oasis perfect for entertaining. Newer front door w/ sidelights & transom in the open foyer. 9 ft ceilings & luxury vinyl plank flooring on main level. Large family room features gas fireplace, wall of windows, & walkout to the rear yard. Newly updated eat in kitchen boasts gorgeous high end cabinets w/ crown molding, recessed lights, island, tiled backsplash, & quartz counters. Large living & dining room plus convenient laundry w/ built ins on the 1st floor. Primary suite includes tray ceiling, ceiling fan, walk in closet, & adjoining tiled bath w/ garden tub, updated shower, & double vanity. 3 additional bedrooms w/ fans & 2nd tiled full bath on the 2nd floor. Recently finished lower level offers flexible living spaces comprised of a potential 5th bedroom w/ attached tiled full bath, recreational space w/ built in cabinets/bar, & 2 additional versatile spaces. Luxury vinyl planks floors in the finished basement. Modernized oil rubbed bronze door hardware throughout, new basement windows, tinted front windows, newer plumbing fixtures, & newer toilets. Added HVAC system 2021, 75 gallon hot water heater 2022, sump pump w/ battery backup 2020, Yeti radon system 2019, Leaf filter gutter guards 2020, neutralized paint 1st 2 floors 2026, & painted exterior 2023. Enjoy the newly planted 4 weeping willows & 3 green giant trees in the backyard. Sought after neighborhood w/ tons of green space, clubhouse, lakes, & community amenities. Triple Crown Country Club in the community offers dining, pool, clubhouse, & a pristine 18 hole golf course. Awesome location close to shopping, restaurants, & interstate.

10882 War Admiral Drive, Union

$500,000
4 Beds 4 Baths 643443 MLS
Everything feels brand new in this beautifully updated home! The completely renovated kitchen features new cabinets, quartz countertops, and brand-new stainless steel appliances, including a refrigerator, oven, and microwave. New flooring has been installed throughout both the main and second floors. The spacious primary suite includes updated vanities, a new toilet, and a custom closet organization system. The first-floor bathroom has also been refreshed with a new vanity and toilet. Throughout the home, you'll find all-new light fixtures and fresh paint, creating a bright, modern feel. Additional updates include a new garage door opener, a roof that is only 3 years old, and an HVAC system that is just 2 years old. Outside, enjoy a flat, fenced, tree-lined backyard perfect for relaxing or entertaining. Tucked away on a quiet cul-de-sac, this home truly offers the feel of buying new construction without the wait and with a gorgeous back yard!

10150 Hamlet Court, Union

$499,900
4 Beds 4 Baths 643409 MLS
Move before school starts to award winning schools with great neighbors, friendly Cul-de-sac and lots of kids. Boasting a prime location in Union, KY. this magnificent 2-story traditional home in the highly sought-after Hempsteade community offers the perfect blend of privacy & neighborhood amenities.Updated mechanics & shingles, situated on a quiet cul-de-sac street, the property features a premium, deep wooded private yard that is fully fenced & outfitted with high-end composite decking & an additional floating deck, creating an incredible outdoor oasis. Inside, you will find 3 fully finished levels of living space, beginning on the main floor with a formal dining room, front living room, convenient 1st-floor laundry & an expansive family room centered around a striking stacked-stone, wood-burning fireplace (with gas log ready option) that walks out directly to the deck. The updated gourmet kitchen is a chef's dream, featuring granite countertops, stainless steel appliances, double ovens, upgraded cabinetry with crown molding, a large island, pantry, and an inviting breakfast bay. Upstairs, the 2nd floor features massive bedrooms, all with generous walk-in closets, including a luxurious primary suite with soaring ceilings, dedicated sitting area, expanded walk-in closet & an updated luxury bath suite featuring porcelain plank flooring, upscale freestanding soaking tub & separate shower with stone surround. The finished basement takes entertaining to the next level, complete with full wet bar kitchenette and dedicated theater area with surround sound where the projector and screen stay with the home! Residents enjoy premier Hempsteade amenities including a community pool, tennis courts, playground & scenic community lake, minutes from Union Town Center & award-winning Mann, Gray, and Ryle schools. All info believed accurate but not guaranteed. Buyers to verify all data to their satisfaction. This listing content and text description are protected by copyright la

10108 Brandsteade Court, Union

$589,900
4 Beds 4 Baths 643388 MLS
Gorgeous 4-bedroom, 4-bath two-story with three car tandem garage in the highly sought-after Ryle School District. Nestled on a quiet cul-de-sac in Hampshire. This beautiful home backs up to a scenic wooded view and offers exceptional indoor and outdoor living spaces. The backyard is an entertainer's dream, featuring a spacious patio, covered pergola with TV screen, and an almost-new state-of-the-art hot tub that can remain with the home. Inside, a stunning two-story foyer welcomes you with abundant natural light. The first floor features a private study with custom built-ins, an elegant dining room with wainscoting, refinished hardwood floors throughout, extensive crown molding, and a beautifully updated staircase with exposed wood treads and iron balusters. The recently renovated kitchen showcases expanded white quartz countertops, matching quartz backsplash, additional cabinetry, newer appliances, and a gourmet five-burner gas range. The kitchen flows seamlessly into the dramatic two-story family room, highlighted by a gas fireplace, custom wood accent wall, and a wall of windows overlooking the private backyard. Upstairs you'll find four generously sized bedrooms, including a spacious primary suite with vaulted ceilings, a luxurious ensuite bath, and a large custom-designed walk-in closet. The finished lower level offers a large rec room and walkout, an additional office or craft room with custom built-ins, an incredible theater room featuring high-end video equipment and two storage areas. This truly move-in ready home combines luxury, comfort, and exceptional upgrades in one of Northern Kentucky's most desirable locations.

10336 Easymoor Court, Union

$1,549,000
5 Beds 7 Baths 643373 MLS
Welcome to Royal Castle Way -- A street featuring only six luxury estates, each nestled on 2-5 sprawling acres with a grand, castle-inspired entrance. Once through the entrance, you're immediately welcomed by a breathtaking pond with a dramatic fountain that illuminates beautifully at night. Perfectly positioned throughout the estate, nearly every room captures sweeping panoramic views of the water, creating a serene setting. This home has been meticulously maintained and updated, featuring a new roof, complete bathroom remodel, refinished hardwood floors, fresh paint and carpet throughout and priced significantly under the $1.9M 2026 appraisal, this home offers exceptional value and move-in-ready comfort. It features distinctive details, including a stunning 20-foot grand porte- cochere topped by a 1,400-square-foot Loft with its own climate control. Perfect for entertaining, studio, or a private guest suite. The Kitchen features a chef-inspired layout, complemented by a spacious dining room, a sun-drenched breakfast room with dual skylights, and a walk-in pantry. A soaring two-story fireplace, clad in marble anchors the great room. The owner's wing serves as a private sanctuary, with its own cozy sitting room, fireplace, and a secluded balcony. The main office offers an elegant spiral staircase leading to a hobby room/secondary office, creating a unique and highly functional workspace. A 5-foot-wide grand staircase leads to the ultimate entertainment retreat. designed for both relaxation and recreation with a private theatre room, dedicated pool table area, full bar, card and gaming nook, and a versatile playroom or fitness space. An additional ensuite bedroom offers privacy and comfort, complete with a full luxury bathroom and spa-inspired steam shower. Double doors open to a spacious patio and one of the prettiest yards in Boone County. All ideally situated within the region's fastest-growing premier luxury residential corridor.

2424 Royal Castle Way, Union