Refine Search
Map
Sort by
$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
$1,305,500
4 Beds ⋅ 4 Baths ⋅ 635629 MLS
Fischer Homes is proud to present a stunning new construction in the 2025 Showcase of Homes, located in the Affirmed neighborhood of Triple Crown. This home is the Winslow plan, featuring a stunning kitchen with butler's pantry, lots of gorgeous maple cabinets and quartz countertops. Family room with fireplace expands to light-filled morning room, which has walk out access to the covered patio. Luxury hardwood floors throughout home. Private study with double doors off entry foyer and formal dining area. Private primary suite offers dual vanities, garden tub, walk-in shower and an oversized walk in closet. Two additional bedrooms and and hall bath. Additional basement bedroom, full bath, exercise room and large finished living area with wet bar and walk out access to the back patio. Attached three car garage.

522 Affirmed Avenue, Union
$1,200,000
4 Beds ⋅ 5 Baths ⋅ 635279 MLS
Beautiful home in Triple Crown Country Club on the golf course with incredible pool and 4 car garage.

904 Caitlin Drive, Union
$1,175,000
3 Beds ⋅ 3 Baths ⋅ 635009 MLS
This is a one of a kind property! 74+/- acres, loads of privacy, 3 bedrooms and 3 bathrooms, one floor living ranch style home, all brick and approx 3080SF, large pond with dock, 2 pole barns (approx 20x30 and 60x100), a restored barn from 1800's, large covered stamped patio, front porch, shooting shed, 2 hunting stands made from silos, and loaded with picturesque views! This home has been meticulously cared for featuring hardwood floors throughout, recessed lights, crown molding, open floor plan, loads of natural light, Anderson windows, 3 car garage, skylights, very large bedrooms and laundry on main level. Primary bedroom has 2 walk in closets, walk out to stamped patio and adjoining bath with double vanity, soaking tub and separate shower. Lower level is unfinished with full working bathroom/shower, built in shelves and walkout to 2nd large covered patio. Shooting shed (lean-to style) would also be perfect for horses, goats or other animals. Large pole barn has pit in floor to pull car/equipment over for service/repair. Located less than 10 minutes to new Union Promenade, 15 minutes from I-75 and located in the Ryle School District.

11288 Big Bone Church Road, Union
$1,029,000
5 Beds ⋅ 5 Baths ⋅ 633829 MLS
Stunning custom all-brick home on a 1.1 acre private lakefront lot in the coveted Triple Crown community! This spacious 5 bed, 5 bath home features a gourmet kitchen, expansive back deck overlooking the lake, soaring 14' ceilings, a large primary suite with dressing room, finished walkout basement with wet bar, billiard and media room—perfect for entertaining or guests. Fish from your backyard in your private access lake as you enjoy this sprawling ranch with well-appointed living space, plus a 3-car garage and beautifully landscaped yard. Located on a quiet cul-de-sac, in one of Northern Kentucky's most desirable neighborhoods, with access to golf, pools, clubhouses, walking trails, and top-rated Boone County schools. A rare blend of luxury, space, and lifestyle—welcome home to Hyperion Ct!

1025 Hyperion Court, Union
$1,089,900
3 Beds ⋅ 5 Baths ⋅ 632731 MLS
The Sebastian by Drees is a thoughtful design with all the luxury touches you'd expect. The open arrangement of the family room with 10-foot ceilings, beams & stone fireplace opens to a gourmet kitchen with a working pantry. The family ready room features ample cabinet storage and dog bath for Fido! Enjoy higher ceilings in the finished lower level with walk-up that includes a den/bedroom, full bath & bar area with island and a wine cellar. The first-floor primary features a tray ceiling, luxurious bath with a free-standing tub and enormous walk-in closet. The extended outdoor living is highlighted by a stone fireplace. New Haven, Gray & Ryle schools.

530 Affirmed Avenue, Union
$1,004,776
4 Beds ⋅ 4 Baths ⋅ 629687 MLS
Entered as an outside sale... Sold when submitted.

10560 Enclave Drive, Union
$1,145,900
5 Beds ⋅ 3 Baths ⋅ 628644 MLS
Stunning home meticulously renovated*Set on 3.2 acres, this 5 BD home spans 5480sqft & showcases impeccable craftsmanship*A baker-inspired kitchen features top-of-the-line appliances & beautiful countertops*The 1st flr includes 2 spacious bedrooms, including an expansive Primary Suite that offers a spa-like ensuite featuring his & her walk-in closets, dual vanities, a soaking tub, a walk-in shower & a private walk-out to the patio*The Living Rm & Sunrm each feature a WBFP*All 5 BDs offer generous closet storage*One of the home's most remarkable features is the state-of-the-art music & recording studio, equipped with premium acoustics & soundproofing, this studio offers an exceptional environment for creativity*3-car garage with an unfinished studio/ loft with water & electric*Step outside to explore the meticulously landscaped grounds, featuring mature trees & a fully stocked pond with a filtration system making it safe for swimming while capturing rainwater*This lovely home offers the best of both worlds: a serene retreat steeped in history, yet fully equipped for modern living with its energy efficiency, solar panels, geothermal & Generac back-up power system*Reno list avail.

11240 Us Highway 42, 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
$1,100,000
5 Beds ⋅ 5 Baths ⋅ 625665 MLS
The Drees Crestwood is a thoughtful design with all the luxury touches you'd expect. The open arrangement of the family room with 12' ceilings and stone fireplace opens to a gourmet kitchen with a working pantry. The morning room showcases a beamed ceiling and fireplace. The family ready room features ample cabinet storage and dog bath for FIdo! Enjoy higher ceilings in the finished lower level with walkout that includes a den and wet bar. The first floor primary features a luxurious bath with a free standing tub @ enormous walk in closet. The extended outdoor living is highlighted by a stone fireplace. Ryle Schools

534 Affirmed Avenue, Union
$1,000,000
5 Beds ⋅ 4 Baths ⋅ 624649 MLS
Welcome to your Dream Home, in Highly Prestigious Triple Crown... Nestled center of the Cul-de-sac, on .72 acres of your OWN piece of private serenity. Imagine enjoying your morning cup of coffee, on your covered patio hearing birds chirping, the calming smooth sound of natural flowing water from your lake view, while emerging in the picturesque wooded view! very rare flat backyard! Allow me to take you into your Home... Starting from the Chandelier in your entry foyer, to 12' floor to ceiling stone fireplace in main living area, to the Premium Chef's Kitchen, with Butler's Pantry, Hidden walk-in Pantry, Quartz Counter tops, Kitchen Island, stainless steel appliances, Gas cook top, and built in ovens! Primary 1st level bedroom suite boasts 2 walk-in closets, stone fireplace, Primary bathroom, has dual vanities, relaxation Tub, and 2 headed oversized rain shower, on the lower level of this almost 6000 sq ft home enjoy your custom bar, Home Gym, and Personal Movie Theater! This 5 Bedroom, 4 Bathroom Ranch-Style Oasis is everything you now know you needed! Take a tour, Fall in Love, and Make this YOUR HOME TODAY! & be apart of The Triple Crown Country Club! Welcome Home

13035 Barbaro Drive, Union
$1,100,000
621481 MLS
Rare find on this 145+/- acres in Boone County*Contiguous acreage situated on the corner of Hathaway Rd & Riddles Run Rd*Heavily wooded & cleared areas*Perfect place to build your dream home with multiple building sites or develop your multi-generational homestead*Pole Barn with bunks & covered front porch, vintage barn, RV & RV pad*Recreational trails thru-out*Hunter's paradise*Multiple deer stands*Riddles Run Creek & multiple ponds*Water at the street*Electric pole on property*Fantastic views with tons of privacy*Zoned A-1*GIS Legal Description is 145.5 RIDDLES RUN RD (30-3A,3B) ALSO INCLUDES 030.02*Final acreage TBD by buyers title search*8.6 miles from Mt Zion/ I75 exit.

10008 Riddles Run Road, Union
$4,185,734
621342 MLS
Gorgeous 66 acres located in the heart of Union, Approx 250 Ft of road frontage on Hathaway Rd and 20 Ft on Old Union Rd. Currently zoned agricultural, zoning change in process of neighboring properties to SR1. Less than 5 minutes to restaurants, schools, shopping and I-75. Great development opportunity!

9944 Old Union Road, 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
$1,200,000
4 Beds ⋅ 4 Baths ⋅ 614374 MLS
24 Acres w/4 bedroom custom built brick home. Peaceful, private country setting amidst a lake, ponds, and woods. Lots of room to roam. Several outbuildings with 8 stall stable. Home has great room with WBFP, formal dining room and large solarium for lazy winter Sunday afternoons. Replace the front porch with a screened-in area for viewing the water. So much to offer and just minutes to schools and town. **Acreage to be surveyed for accurate total.

10650 Big Bone Church Road, Union
$1,500,000
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
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