Refine Search
Map
Sort by
$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
$599,900
6 Beds ⋅ 6 Baths ⋅ 643097 MLS
Looking for a multi generational home? This spacious brick home offers 6 bedrooms, 4 full baths, 2 half baths, a 3 car garage, this includes a private lower level living suite with its own separate entrance. Nestled on a heavily wooded lot, the home features soaring ceilings, a large deck, and exceptional living space throughout. The main level showcases a dramatic two story great room, an open kitchen with breakfast area, a cozy den, and freshly refinished hardwood floors. Upstairs, the expansive primary suite provides a private retreat. The second bedroom includes its own en suite bath, while bedrooms three and four are connected by a Jack and Jill bath. The finished lower level is ideal for entertaining, featuring a spacious family room with a fireplace and wet bar, a half bath, and ample storage space. The private living quarters offer excellent flexibility for multi generational living, guests, or extended stays, complete with a living room/office, kitchen, bedroom, full bath, and private exterior entrance.

1114 Grindstone Court, Union
$750,000
5 Beds ⋅ 6 Baths ⋅ 642806 MLS
This breathtaking executive home in Union offers luxury finishes, exceptional flexibility, and multigenerational living potential in the highly desirable Triple Crown community. Featuring stone, brick, and shaker-style exterior accents, this meticulously maintained home blends elegant design with modern functionality and is truly move-in ready. Inside, the open floor plan is filled with natural light, gleaming upgraded hardwood floors, tray ceilings, recessed lighting, and custom built-ins throughout. The main living area is anchored by a stunning stone fireplace, creating a warm yet sophisticated atmosphere. The thoughtfully designed layout includes a first-floor bedroom with attached full bath, ideal for guests or multigenerational living, plus a private first-floor study with fireplace perfect for working from home or relaxing with a book. The chef's kitchen features granite countertops, a built-in gas range, stainless steel appliances, custom pendant lighting, and an oversized serving island with seating. The adjoining morning room provides the perfect space for casual dining and entertaining. Upstairs, enjoy a spacious second-floor family room, oversized laundry room, and a luxurious owner's suite with tray ceilings, walk-in closets, private sitting room, oversized dual vanity, soaking tub, and custom tiled shower. An additional upstairs bedroom includes its own private en-suite bath for added comfort and privacy. The finished lower level offers even more living space with a wet bar, new vinyl plank flooring, full bath, ingress/egress windows, and abundant storage--perfect for entertaining, recreation, guests, or extended living needs. Additional highlights include an oversized 3-car garage, flat low-maintenance yard, and hypoallergenic-friendly living environment. Conveniently located near shopping, dining, golf, parks, and major highways.

11184 War Admiral Drive, Union
$2,665,000
5 Beds ⋅ 6 Baths ⋅ 641952 MLS
NEW BUILD: 2025 Home Show Showcase Home! Designed around the power of five: 5 oversized garage spaces, 5 spacious bedrooms, 5 full baths (plus a half). Set on more than an acre with sweeping views of Triple Crown golf course hole #4 and the lake. Enjoy a covered deck with outdoor fireplace, perfect for year-round living. Inside, discover soaring ceilings, Bosch appliances, a spa-inspired primary suite, a grilling deck, and a huge walk-through pantry. The lower level is built for entertaining w/stunning bar area and ample gathering space, plus room to add a golf simulator. Located just steps from the new Publix and Triple Crown's premier amenities:luxury, lifestyle, and location in one exceptional home.

521 Affirmed Avenue, Union
$1,200,000
5 Beds ⋅ 6 Baths ⋅ 641176 MLS
Showcase of Homes, Custom built residence built by Our Farmer House. Perfectly positioned this new 5,200+ sq ft modern european-inspired farmhouse is a rare opportunity in Triple Crown. Designed to impress with 5 bedrooms, 5.5 baths, an oversized bunk room, private theater, and open concept living perfect for entertaining. The gourmet kitchen boasts GE Monogram appliances and a walk-in dream pantry. Vaulted ceilings with wood beams, rich hardwoods, and a spa-like primary suite add luxurious touches. 3-car garage, designer finishes, and a professionally landscaped backyard oasis. Set on the largest lot in community at 1.1 acres. 1200 sq ft of outdoor turf living and in Union's premier golf community just steps from the new Publix and Triple Crown's top tier amenities.

506 Affirmed Avenue, Union
$1,175,000
6 Beds ⋅ 7 Baths ⋅ 640893 MLS
Welcome to 739 Cameron Ct, a stunning home on a quiet cul-de-sac with seasonal golf views of the 5th hole at Triple Crown Golf Course. Offering 7,600+ sq ft, this home blends luxury and function with 4-6 bedrooms, including two owner's suites and two private offices. A paver driveway leads to a 5-car garage with EV charging plus golf cart and bike storage garage. Inside, enjoy a dramatic 2-story family room with stone fireplace, built-ins, and abundant light, along with three fireplaces throughout. The gourmet kitchen features a 6-burner commercial-grade range, Sub-Zero refrigerator, and large walk-in pantry. The primary suite offers a spa-like ensuite with freestanding tub and jetted tile shower. The finished lower level includes a second kitchen, family room, bedroom, wine room, and more--ideal for guests or entertaining. Additional highlights include a solarium, exercise room, and custom mudroom. Outdoor living shines with two decks, covered patio, and firepit. Recent updates include a new roof, new carpet, and refinished hardwood floors. Conveniently located near shopping and dining, this home offers the space and features for a truly elevated lifestyle.

739 Cameron Court, Union
$2,250,000
6 Beds ⋅ 6 Baths ⋅ 640519 MLS
They say heaven is a Kentucky kinda place! Here is a rare opportunity to own one of Northern Kentucky's most unique and beautiful private estates. 83 acres of privacy and Ohio River views. Timeless charm throughout this 9000+ sqft home with 6 bedrooms, 5 full baths, completely renovated kitchen, bedroom balconies, 3 fireplaces, library, and details you rarely see in new homes. There are 2 barns and an additional outbuilding. Pond with a dock. Home generator. Water treatment system. Seller has maintained consisted service on mechanics of this home. This home is truly spectacular!

11213 E Bend Road, Union
$822,912
5 Beds ⋅ 6 Baths ⋅ 640429 MLS
New construction by Fischer Homes in the beautiful Ballyshannon community, This sophisticated design offers 4 bedrooms 4 full baths, and 2 half baths. The open-concept layout connects the spacious family room with expansive kitchen featuring large islands and generous pantry space. 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.

4030 Cullen Drive, Union
$1,325,000
6 Beds ⋅ 6 Baths ⋅ 639215 MLS
Located on the 11th fairway of Triple Crown Country Club, this exceptional home offers six bedrooms, four full baths, and two half baths, including a convenient outdoor pool bath. The first-floor primary suite is a true retreat, featuring a beautifully updated spa-like bathroom with heated floors. The renovated kitchen is equally impressive, showcasing an oversized island, custom cabinetry, and elegant countertops, perfect for both everyday living and entertaining. Thoughtful architectural details are found throughout the main level, including coffered and trey ceilings, hardwood flooring, a butler's pantry, and custom built-ins. Two separate staircases provide access to the lower level—one from the grand foyer and another from the garage—adding both function and convenience. The second floor offers three spacious bedrooms and two full baths, including a Jack and Jill layout. The finished lower level expands the living space with an updated wet bar, a large family room, two additional bedrooms (one currently used as an exercise room), a full bath, and an oversized storage room. Step outside to an entertainer's paradise with breathtaking golf course views, a heated pool with attached hot tub, an outdoor bar complete with built-in grills, an outdoor half bath, and a wood-burning fireplace with comfortable seating area. All of this is located within walking distance to Triple Crown Country Club, making this home the perfect blend of luxury, comfort, and lifestyle.

10713 Meadow Stable Lane, Union
$2,750,000
6 Beds ⋅ 7 Baths ⋅ 638209 MLS
Magnificent English Tudor home boasting over four acres and nestled in a beautiful, wooded setting overlooking a lake front in Triple Crown. This 6 bedroom, 5 full and 2 half bath home was planned to showcase hand craftmanship in the tradition of the Arts and Crafts era begun in England the latter half of the 19th century. This two-story distinctive brick home has a multi gabled roof featuring dormers, small pane windows with three tall chimneys. Two tiers of steps lead to an oversized mahogany door with leaded restoration glass panels. The entry foyer floor has a custom wooden design inlay. Hardwood floors run throughout the first level. This home has 5 wood burning fireplaces, handcrafted cabinetry throughout and a primary suite which includes a sitting room, walk in closet and luxurious bath. The kitchen is designed with custom cabinetry, granite countertops, ''Wolf'' gas range cooktop on the center island, ''Sub-Zero'' refrigerator and double ovens. The living room has newly added remote custom draperies. Finished lower level with parquet oak flooring, custom bar, wine cellar, steam room and much more. An English Garden with fishponds and a waterfall leading to a spectacular gunite pool are just a few of the amazing features in the rear of the home. This house is certainly a must see for the right buyers.

10730 Omaha Trace, Union
$1,075,000
4 Beds ⋅ 6 Baths ⋅ 637113 MLS
Sprawling Custom Luxury Jobe Builders Stone and Brick 7,999 Sq Foot Ranch In The Heart Of After Triple Crown, The Only Private 18 Hole Golf Community in NKY*Sellers Have Recently Spent 200k On Renovations*Crown Molding Throughout Entire Home*Brand New Luxury Kitchen With Huge White Granite Island, 42 Inch Cabinets, High End Appliances*Hardwood Flooring Has Been Refinished and Is Stunning*235K In Renovations*New Paint*The Primary Suite Is Calling Your Name, High Ceilings With Lighting, Huge Walk In Closet, Fire Place, And A Brand New Grandeur Primary Bath That Will Make Your Jaw Drop*New Double Granite Vanities, New Tile Flooring, New Tile Shower*Office W/ Built Ins And Tons Of Natural Lighting For Those Who Work From Home*Kick Back And Relax By the Fire In Y0ur Covered Screened In Deck While Enjoying The Privacy Of Your Private Back Yard*Also Newer Paver Patio Added*Basement Is Fully Finished With 2 Entrances, Walk Out By The Covered Lower Level Patio and Garage Side Entry*Basement Is an Entertainers Dream, Billiards Room, Fire Place, Wet Bar, Wine Vault, Huge Living Room, Special Financing Incentives available on this property from SIRVA Mortgage.

10851 Charismatic Lane, Union
$849,900
5 Beds ⋅ 6 Baths ⋅ 634706 MLS
Experience estate living in Triple Crown Justify Reserve with the Vanderburgh. This versatile two-story plan offers open & spacious living with a formal dining room & home office located off the foyer. The open arrangement of the family room & kitchen make entertaining a breeze. The gourmet kitchen features stacked cabinets extending to the 10' ceiling as well as a wood vent hood, quartz countertops & an inviting casual dining area. A main level bedroom with full bath is perfect for overnight guests. Upstairs you will find 3 additional bedrooms each with a walk-in-closet, a hall bath with a double bowl vanity & an additional bath in bedroom 2. The second level primary suite boasts two walk in closets, a super-sized shower & double bowl vanity. Experience the openness of the elevated ceiling height in the lower level with the extended finished rec-room & wet bar. Enjoy cool evenings by the outdoor fireplace on the deck. This home is located in the desirable New Haven, Gray & Ryle school district.

738 Man O'War Boulevard, Union
$909,969
5 Beds ⋅ 6 Baths ⋅ 632050 MLS
New Construction in the beautiful community of Ballyshannon, featuring the Pearson Modern Farmhouse plan. This designer floorplan offers an open-concept kitchen with island, pantry, lots of cabinet space and quartz countertops. Family room with stunning gas fireplace connects to light filled morning room. The morning room walks out to the covered deck which features an exterior gas fireplace. Guest Suite with full bath. Private study with double doors off of entry foyer. Upstairs owner's suite with attached private bath featuring dual vanity sinks, walk-in shower, large soaking tub, and oversized walk-in closet. Second floor laundry room, three additional bedrooms, hall bath, and spacious bonus room. Partially finished basement with full bath. Attached three car garage.

8508 Robert Grant Drive, Union
$574,000
4 Beds ⋅ 6 Baths ⋅ 627962 MLS
Meticulously maintained home in Cooper School District, huge house with 4+ Bedrooms (plus 2 finished rooms in bsmt that owner uses for bedrooms), 5 Full and 1 half baths. Walk in to a soaring 2 story foyer with a formal living room & dining room to each side, molding galore, into a grand 2 story Family Room with gas fireplace & coffered ceiling. Large kitchen with SS appliances, island, walk out to beautiful deck and fenced in yard. Every Bedroom has it's own full bath and walk in closet. Primary Bedroom is a wing upon itself with Sitting area, Dressing area, en suite bath with Walk in Shower, Soaking Tub, 2 vanities & 2 humongous walk in closets! Owner offering $10,000 concession towards new flooring! Finished basement (1212 SF of 4674 Total finished SF) includes massive great room with a walk out, full bath, and 2 other finished rooms, and 395 SF of unfinished storage space. New roof in 2022, new AC in 2022 & new gas furnace in 23, and new refrigerator 2022. See Upgrade Document and Floor Plans for a comprehensive view of all amenities that this home has to offer! It even has an EV charging station in the garage!

8652 Marais Drive, Union
$2,450,000
5 Beds ⋅ 6 Baths ⋅ 626832 MLS
Experience Resort-Style living in this Remarkable Custom Built Brick & Stone Ranch! Situated on nearly an acre lot overlooking the 1st green of prestigious Triple Crown Country Club! The circle drive w/artistic water features & dramatic stone entry welcome your guests into this 7116 sqft home that embodies sophistication & elegance! The interior boasts a neutral modern decor, complimented by Restoration Hardware lighting. Features 5 BR, 5/1 Baths, 2 FP's, 2 Laundry Rms, 4.5 Car Gar. First floor offers quartz piano bar, executive study, great rm w/beamed ceiling & stoned archways, auto shades, gourmet granite kitchen w/instant hot water, Sub Zero/Wolf appl, walkout to covered veranda w/FP & automated retractable screen system & trex deck w/view rails. Fin LL includes fully equipped bar w/GE Cafe appl, dining rm, speakeasy-bourbon rm, game rm, media rm, with walkout to your own private paradise including heated gunite pool, stamped concrete patio, relaxing water feature, fire bowls, expansive outdoor kitchen/bar/grill w/automated louvered pergola & gas firepit surrounded by lush landscape, mature trees w/irrigation system, outdoor app controlled lighting & golf course views.

10831 Omaha Trace, Union
$3,912,000
5 Beds ⋅ 8 Baths ⋅ 626235 MLS
Welcome to Your Private Oasis on Omaha Trace! A Masterpiece of Luxury Living nestled upon 4.5 secluded acres within the esteemed Triple Crown Country Club Golf Community. This extraordinary Custom Built Estate showcases unparalleled quality & craftsmanship throughout. Step through the grand marble & limestone entry to 12,000 sqft of architectural brilliance that seamlessly blends classic charm with a contemporary flair. Features 5 BR, 5/3 Baths, 7 FP's, 2 Laundry Rms, 5 Car Gar. 1st Flr offers study, great rm, piano bar, gourmet quartz kitchen w/designer appl, wine grotto, hearth rm, suspended coffered ceiling, walk-in pantry, drop zone. Family Wing w/deluxe primary br, sitting rm, auto shades, coffee bar, his & her WIC - Marble Bathroom, steam shower-wall sprays, and 2 additional BR's w/ensuites. Fin LL Veranda includes media rm, game rm, play rm, exercise rm, 2 more BR's w/ensuites, 2nd Laundry Rm, billiards, caterer's ktcn, & pub w/walkout to outdoor living space w/private park, pergola, bocce ball, firepit, rock garden, gunite pool/spa, pool house w/full kitchen, bar, bath, FP, separate furnace, collapsible glass walls overlooking picturesque lake and golf course views!

10751 Omaha, Union
$799,900
7 Beds ⋅ 6 Baths ⋅ 624327 MLS
Triple Crown! The Bennett is a two-story home that is spacious and open with an abundance of options to choose from. This home showcases an open arrangement with a large family room, spectacular kitchen with generous island and a spacious dining area. The primary suite includes a luxurious spa-like bath and large walk-in closet. In the finished basement, you'll enjoy entertaining with a large rec room plus an additional bedroom.

770 Man O' War Boulevard, Union
$899,900
5 Beds ⋅ 6 Baths ⋅ 622035 MLS
The Brennan provides exceptional space and is full of charm and curb appeal. Upon entering the foyer, you will be greeted by a generous home office or study. This provides the perfect place for the telecommuter or a stylish space for greeting clients. As you venture into the heart of the home, you will discover an open and airy family room, kitchen and dining space that opens to a covered porch with stone fireplace. The vaulted beamed ceiling in family room accents the floor to ceiling stone fireplace. The luxurious first floor owner's suite with a spa-like bath and generous closet space is a ''must have.'' On the opposite side of the central living area, a secluded first floor bedroom with an adjacent full bath is perfect for overnight guests. And the family foyer with adjoining laundry room will keep your personal items organized. The second level features two additional bedrooms and a loft. An additional bedroom and full bath are finished in the lower level with a rec room that walks out to your gorgeous large backyard.

10440 Enclave Drive, Union
$670,500
5 Beds ⋅ 6 Baths ⋅ 621025 MLS
Exceptionally maintained 5BR, 6BA home with a generous layout and a 3-car garage, situated on a quiet cul-de-sac street. The open floor plan includes a first-floor generational suite, seamlessly connecting the living, dining, and kitchen areas to create a warm and inviting space for both gatherings and daily life. Revel in the contemporary kitchen featuring granite countertops and stainless steel appliances, with ample storage provided by a spacious pantry. The fully finished basement becomes the focal point for entertainment, boasting a wet bar and a sizable projector screen. Outdoor enjoyment is enhanced by the covered deck, patio, and fenced-in backyard. Refer to the attached Miscellaneous document for a detailed list of upgrades that elevate this home above the ordinary.

10609 Pegasus Court, Union
$650,000
7 Beds ⋅ 6 Baths ⋅ 620830 MLS
Check out this showstopper!! This beautiful Drees Vanderburgh has so much to offer and you just need to see it in person to truly appreciate it! It offers 7 bedrooms, one of which is on the main level with its own bathroom. There are 5 full bathrooms and 1 half bath. The owners recently finished the basement which offers even more space to host family and friends! Do you like to cook and entertain? Well, this home is perfect for just that. Unleash your inner chef with a gas cooktop, beautiful granite countertops and newly installed backsplash. You can cook up a delicious meal while your company hangs out at the kitchen island or large family room. This home also has a nice flat fenced in backyard that would be perfect for a pool! Located on a cul de sac in the Longbranch/Ballyshannon/Cooper School District. This one will not last long so schedule your showing today!

3713 Iberville Court, Union
$1,850,000
5 Beds ⋅ 7 Baths ⋅ 617464 MLS
This was sold when submitted. Sold when submitted.

10816 Silver Charm Lane, Union
$1,065,000
6 Beds ⋅ 6 Baths ⋅ 616423 MLS
Wait until you see this breathtaking home overlooking the 7th hole in Triple Crown, on a private cul de sac street*6 bedrooms, 5 full and 1 half bathrooms*Oversized garage space including tandem spot holds up to 5 vehicles*Rear 6th garage for potential golf cart storage or lawn equipment*Completely remodeled eat in kitchen with custom cabinetry& upgraded appliances, walk in pantry, granite countertops, hammered copper sink*Open living room with gas fireplace and cathedral ceiling*First floor pub with phenomenal wet bar & stonework & walk out*Dreamy first floor primary bedroom suite-Heated marble flooring throughout bathroom and sizeable walk in closet that walks out to deck!*Fully finished, walk out lower level, complete with wet & dry bars, theater room, and fitness room*Large composite deck and patio ideal for entertaining features outdoor kitchen, stone fireplace &hot tub*Control 4 Sound System with custom lighting throughout home*Truly luxury living at its finest

834 Bay Colt Lane, 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