Refine Search
Map
Sort by
$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