Union KY Real Estate, Homes for Sale With Fountain

Fairway-Front Entertainer's Haven*This Stunning Custom Built Home Sits In A Super Quiet CDS Street W/ The Perfect View of Hole #8 with a Side Panorama of Hole #9, In Prestigious Triple Crown CC*This Sun-Filled Retreat Is Built For Outdoor Families & Golf Enthusiasts-Where Morning Tee Times Roll Into Splashy Afternoons & Relaxed Evenings Under The Lights*The Resort-Style Backyard Is The Star: A 21,000-Gallon Heated Fiberglass Pool w/ Automatic Electric Cover (2023), New Dolphin Cleaner, New Chlorinator, And a 10-foot slide-Plus a Hot Tub (new motor 2024) Enclosed In The Screened In Porch*A 2nd Water Feature- Boulder-lined Fountain Pond w/ a 12-foot run-Sets a Tranquil Backdrop For Grill Nights & Gatherings*Outdoor Wood Burning Fireplace With 2 Woodpile Boxes*Amish Gazebo*Retractable Awning!*Extensive Landscape Lighting & a 67-Head Irrigation System Keep Everything Dialed-In and Game-Day Ready*Leaf Guard Screened Gutters*New Garage Door Motor Installed In June On Large Garage Door (w/5 yr warranty)*Inside, Fresh Professional Painting on the 1st & 2nd Floors (13k)*The Chef's Kitchen Features a 2023 Refrigerator, Dual Ovens, A Stovetop w/ Microwave (2012), & Updated Quartz countertops (2007)* Practical Upgrades--New HVAC ($24k), a Tankless Hot Water Heater (2014), and Whole-Home Water Filtration (2015)--Make Ownership Effortless*The 3-car Garage Is Fully Outfitted w/ Custom Cabinets, Upgraded Flooring, Storage Racks ($13k), And New Garage Doors (4K)* 7 window boxes with Automatic Irrigation Bring Vibrant Curb Appeal, & A Newer Washer & Dryer (2024) Add Everyday Convenience*Master Bath Also Comes With a Steam Shower (8k)*With Over $160,000 In Improvements, This Home Is Turnkey, & Built For Entertaining* Where Golf-Side Living Meets Backyard Adventure--Ready For Long Summers, Lively Weekends,& Easy Hosting*ADT Alarm System*Basement Is Partially Finished And Has Rough In.

960 Dustwhirl Drive, Union

$660,000

4 Beds ⋅ 3 Baths ⋅ 643215 MLS

Nestled on 5.5 picturesque acres, this stunning custom-built ranch by Adam Miller offers a spacious open-concept floor plan. Easy one-level living with a beautifully finished lower level. Step outside and enjoy your own private retreat with large, covered patio complete with a dining area, relaxing jacuzzi, a gazebo, pool, and deck area. A 22x31 pole building with electric offers space for storage or hobbies. Energy efficient ultra geothermal system. Pool and deck are currently being replaced following storm, expected to be complete in approximately three weeks.

2655 Longbranch Road, Union

$745,000

4 Beds ⋅ 4 Baths ⋅ 642704 MLS

Exceptional Custom-Built Brick Ranch nestled on its own private island setting within the prestigious Saint Leger section of Triple Crown! Offering luxury living, privacy, and upgraded amenities, this stunning 4 bedroom, 3.5 bath home features an oversized 3-car garage, gleaming hardwood floors throughout the main level, extensive crown molding, and both first floor and lower-level laundry rooms. The gourmet chef's kitchen showcases granite countertops, custom wood cabinetry, and high-end finishes, seamlessly flowing into the elegant formal dining room and spacious great room with fireplace -- ideal for everyday living and entertaining alike. The finished walk-out lower level is an entertainer's dream featuring wide plank flooring, wet bar, stone fireplace, custom built-ins, and direct access to the spectacular private resort-style backyard retreat. Enjoy ultimate outdoor living with lush professional landscaping, illuminated walkways, multiple paver patios, retractable awning, pergola, tranquil waterfall features, and exceptional privacy rarely found in Triple Crown. The study/4th bedroom is currently being used as a theater room, offering flexible living space to suit your lifestyle - perfect for a home office, media room, or guest suite. This property is is ideally situated just off the 17th hole with quick access to the golf course and clubhouse, this prime location combines luxury, convenience, and lifestyle. HOA-maintained lawn care with front and rear irrigation systems provide easy, low-maintenance living. A rare opportunity to own one of Triple Crown's most unique and luxurious homes -- Welcome Home!

10723 Saint Leger Circle, Union

$550,000

3 Beds ⋅ 4 Baths ⋅ 642221 MLS

As you pull up to this stunning 3-bed/4-bath/ plus Den home you will be captivated by the classic red brick exterior w/the contrast of traditional elegance of the black shutters & black leaded glass front door & sidelight accented by the updated black exterior lighting. It is a true testament to traditional timeless beauty. The inviting front porch extends a warm welcome to come inside and explore the charm within. As you step through the front door you immediately feel a warm hug as you take in all the beauty of this professionally decorated home w/many upgrades including updated lighting, refinished hardwood flooring, freshly painted interior along w/custom closet in primary suite, custom pantry w/double doors, custom laundry room, new carpet, new roof. The two-story foyer seamlessly extends from the dining room into the vaulted living room. enhanced by the gas fireplace. The large kitchen with two islands, open to the eat-in- dining is perfect for entertaining friends and family. Mr. Chef says, ''This is a chefs dream kitchen with the gas range, custom kitchen cabinets that have numerous pull-out drawers giving you an endless amount of storage. The beautiful new sliding door brings in a lot more natural light connecting the inside out to the covered rear patio featuring a beautiful stone fireplace, ideal for entertaining. The rear patio offers enhanced privacy as a result of the newly landscaped yard. The first floor boasts a luxurious primary suite, providing convenience and privacy. The finished basement is an entertainer's dream, complete with a bar, a theatre room for movie nights, and a temperature-controlled wine cellar for wine enthusiasts. This pristine corner lot in an established neighborhood, surrounded by huge maple trees. The neighborhood has great amenities, including two community pools, tennis courts, & a playground, making it a perfect place for active lifestyles. This home is a perfect combination of elegance and comfort in a picturesque setti

1047 Bayswater Drive, Union

$615,000

5 Beds ⋅ 4 Baths ⋅ 640868 MLS

Welcome to 11813 Big Bone Rd Union KY! Nestled on 5.01 private wooded acres, this stunning property offers peaceful pond & wooded views along with exceptional indoor and outdoor living spaces, including a gazebo with electric, firepit, pond fountain, covered wraparound front porch & covered deck perfect for entertaining or relaxing in a serene setting; the property features an impressive 3 car attached garage, 2 car detached garage, and oversized carport ideal for boat, camper, or additional storage; inside, the home offers a versatile & spacious layout designed for multi-generational living with a first-floor bedroom/office/hobby room with two closets, a finished walkout basement complete with pool table (included), wet bar, half bath, workshop, and additional living space; the open kitchen is beautifully appointed with granite countertops, gas cooktop, double oven, two pantries & counter bar seating, flowing into a large living room with hardwood flooring, stone surround wood-burning fireplace, and walkout access to the covered deck overlooking the pond & woods; additional features include a formal dining room, first-floor laundry, spacious primary suite with walk-in closet, double bowl vanity, soaking tub, and separate shower, generously sized bedrooms including a fifth bedroom or second family room, backup generator, dual-zone HVAC system (first floor replaced 2020, second floor replaced 2021), hot water heater replaced in 2025, whole home air cleaner system, water filtration system, whole house attic fan, newer kitchen appliances & two 200 amp electrical panels, offering comfort, efficiency, and peace of mind throughout, plus the added benefit of low taxes and no HOA. All information is believed to be accurate but not guaranteed. Buyers to verify all data to their satisfaction. © 2026 apply. All Rights Reserved.: All content (data, photos, video) protected; no use, reproduction, retained or AI training without written permission of the listing brokerage

11813 Big Bone Church Road, Union

$539,900

4 Beds ⋅ 3 Baths ⋅ 638954 MLS

Beautiful 2-story Drees Chadwick floorplan offering a spacious open-concept design and thoughtful upgrades throughout! This home features 4 bedrooms, 2.5 baths, and a 3-car tandem garage, plus two fireplaces for added warmth and charm. The gourmet kitchen is a showstopper with new High GE Café appliances, double oven, gas cooktop, large island bar, tiled backsplash and flooring with abundant gorgeous cherry wood cabinetry—perfect for everyday living and entertaining. The inviting family room showcases soaring ceilings and a wall of windows that flood the space with natural light. Recent updates include brand-new hardwood floors, new carpet throughout second floor, a new roof (2024), and new front and rear doors, offering true move-in readiness. The basement has been completely framed and is ready for the new owner's finish out with their own personal touch, designed to include a rec room with fireplace, full bath, theater room, flex room, and ample storage. Enjoy outdoor living in the flat rear yard featuring a beautiful paver patio with serene, tree-lined views. Located in a highly desirable neighborhood offering a community pool, playground, and tennis courts. This home provides both lifestyle and convenience. Ideally situated with easy access to the interstate, CVG airport, and just minutes from the new Union Promenade Shops. 1-year home warranty included for buyers peace of mind. Truly a must-see. This home offers space, style, community amenities, and an unbeatable location! When can you move?

9899 Burleigh 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

$835,000

5 Beds ⋅ 5 Baths ⋅ 634572 MLS

STUNNING EXECUTIVE SYTLE HOME IN THE RESERVE SECTION OF TRIPPLE CROWN. This luxury option filled 5-bedroom, 5 full bath home checks all your boxes. With approximately 6500 square feet of finished living area, this home is an entertainer's dream. Just turn on your player piano and host a great evening with family and friends. This home features top of the line selections, 2 stone fireplaces, 2 private offices, a media room, a covered outdoor space with a stone gas fireplace and a large fenced in lot. The beautiful large gourmet kitchen with 42'' shaker cabinets, solid surface counter tops and top of the line appliances is sure to please. This home has been meticulously taken care of and all the work has been done for you. THE PHOTOS SPEAK FOR THEMSELVES. Schedule your showing today and come see it!! This home is priced well under the cost of reproduction and is ready to be enjoyed.

1520 Authentic Court, Union

$715,000

3 Beds ⋅ 3 Baths ⋅ 634371 MLS

3 Bedroom 3 Full Bath...The property was PENDING WHEN SUBMITTED.

962 Riva Ridge Lane, Union

$715,000

5 Beds ⋅ 5 Baths ⋅ 630677 MLS

Nestled in the prestigious Triple Crown community, this 5-bedroom, 5-bathroom executive-style home is a true entertainer's dream. Featuring soaring 10ft ceilings, the open floor plan flows seamlessly throughout, with a gourmet kitchen that is equipped with all-new, high-end appliances, granite counters and huge pantry, formal dining room, stone fireplace, and mudroom on the main floor! Upstairs, each spacious bedroom boasts a walk-in closet and adjoining bathroom. Primary suite has large walk in closet, separate vanities and wonderful soaking tub. The outdoor entertainment area is truly a standout, complete with an outdoor kitchen, bar, fireplace, and a serene water fountain, making your entertaining dreams a reality! The full finished walk-out basement adds even more living space, perfect for a home theater or recreation area with room (and egress) to add a 6th bedroom. This home is just minutes from the expressway and the vibrant entertainment district of Union, KY. Experience the best of executive living in this stunning, meticulously designed and maintained home.

11120 War Admiral Drive, Union

$506,000

3 Beds ⋅ 4 Baths ⋅ 628044 MLS

Thoughtful design and refined detail join modern convenience here. 1st floor primary ensuite, superior remodel of kitchen, primary bath & lower level(media room, wet bar w/beer tap, built-in shelves with secret entrance to storage area AND a temperature controlled wine room with 600 bottle capacity +25 feet of shelving for bottle spirits!), pinterest worthy covered patio w/stone fireplace, plantation shutters, custom pull-out kitchen drawers, amish built primary bath cabinetry, newer garage doors & gutters(including gutter guards), professional landscaping, fountain, newer HVAC, tankless water heater, water softener, meticulously maintained. Pool community, located in the award winning Shirley Mann/Gray/Ryle school district. When can you move in?

1047 Bayswater 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

$595,000

5 Beds ⋅ 5 Baths ⋅ 622655 MLS

Outstanding custom built showplace on a quiet cul-de-sac in Triple Crown. Attractive full brick home featuring soldiered brick, multiple dramatic gables & stone accents. Lush mature landscaping w/ irrigation system in this beautiful garden oasis. 2 story foyer, living room w/ hardwood floors could be used as a study, large formal dining room w/ trae ceiling, crown & hardwoods. Popular 1st level family room boasts soaring vaulted ceiling, hardwoods, stone accented gas fireplace & wooded views. Fully equipped eat in kitchen includes granite, tiled backsplash, large corner pantry, SS appliances, island, & adjoining breakfast room w/ walkout. 1st floor primary suite w/ gas fireplace, walkout, trae ceiling, overhead fan, & adjoining gorgeously updated tiled bath! 2nd level includes 3 large bedrooms w/ fans, adjoining baths, & 2 w/ walk in closets. 3 car garage & convenient main level laundry. Fully finished lower level is incredible offering a stunning wet bar, rec room w/ walkout, exercise room, 5th bedroom/office, & 4th full bath. Enjoy private wooded views from the multi tiered Trex deck w/ aluminum railings & outdoor kitchen w/ grill & fridge. Well maintained & move in ready!

10705 Stone Street, Union

$725,000

4 Beds ⋅ 3 Baths ⋅ 620432 MLS

Stunning 4 Bedroom, 3 Full Bath, 3 Car Garage, Custom Ranch Home in Desirable Triple Crown! 2015 Parade of Homes w/Too Many Upgrades to List! GEOTHERMAL HVAC System w/Low Utility Costs!! Main Level Features Primary Bedroom, Walks out to Covered Deck & EnSuite Bath that is an Absolute Show Stopper! 2nd Bedroom w/EnSuite Bath. Open & Airy Living Area w/Amazing Natural Lighting, Hardwood Floors & Fireplace. Dream Kitchen Complete w/Waterfall Quartz Countertops, Bosch Appliances & Pantry w/your Very Own Herb Growing Center. 1st Floor Laundry & DropZone off Garage w/Desk. Lower Level Complete w/Full Kitchen, Hardwood Floors, 2 Spacious Bedrooms w/WIC's, Full Bathroom, Family Room with Tons of Windows. Could be Perfect Teen, Guest, or In-Law Suite! Fantastic Natural Light, Walks Out to Multiple Patios w/Soothing Waterfall Pond & Fire Pit. Tons of Unfinished Space for Storage. Huge Cul de Sac Lot. One-of-a-Kind Home offers 9Foot Ceilings on Both Levels, California Closets, Smart Home Technology & Indoor/Outdoor Speaker System, Maintenance Free Decking, Lawn Sprinklers, Epoxy Garage Floors, Custom Trim & Moldings. Owners Favorite Feature-Amazing Panoramic Sunrises from Covered Deck

1605 Big Brown Court, Union

$670,000

3 Beds ⋅ 3 Baths ⋅ 616019 MLS

STUNNER - Maintenance free ranch and completely UPDATED! Seller spent $300,000 in recent redo. Gorgeous kitchen and all baths remodeled to the studs! HUGE list of improvements: new hardwood floors, new windows, new paint,... see full list in docs. Enjoy one floor living and the lake view from screened porch! Lower level has great entertainment space w/ bar.

962 Riva Ridge Court, Union

$735,000

3 Beds ⋅ 3 Baths ⋅ 614959 MLS

Welcome to 10823 St. Leger. This Tim Burks Cavalcade Home is all about first floor living. 3 Beds, 2.5 baths. First Floor Primary Suite with walkout to deck. Primary Bath has extra large walk-in closet, granite top vanity, beautiful custom mirror & light fixtures & glass shower. Gourmet Granite Kitchen w/ newer Stainless Refrigerator, Microwave & Double Ovens. Kitchen Island is a must have for family events. Lots of beautiful Hdwd Floors throughout. Planning Desk/Butlers Pantry area leads to First Floor Laundry, cabinets for storage & Utility Sink. Living Room features high ceilings, wall of windows, custom built in bookcases and gas fireplace. True 4 Season Room on First Floor with Wood Flooring, Wainscoting & Mini Split Unit for extra comfort. Walks out to Deck. New carpet in Living Room, Dining Room, Primary Bedroom & First Floor Study. The lighting in this home is stunning! Gorgeous view from the deck is the Golf Course/15th Hole & 2 Ponds. A great spot for morning coffee. Lower Level features Family Room 2 additional bedrooms, full guest bath w/linen closet/Rec Room/Full Wet Bar w/beautiful new granite, gas fireplace & lg storage area. Whole House Generator

10823 Saint Leger Circle, Union

$900,000

4 Beds ⋅ 4 Baths ⋅ 614459 MLS

Looking for a little slice of Heaven? Come see this awesome, serene, park like setting! Beautiful custom built ranch with finished, walk-out basement that takes you right out to the in-ground pool! You'll be surrounded by the beauty of this property and the stocked lake! The pool is 18'x36' and is 4' deep from end to end. Two large out buildings with concrete floors,electric, camper/ welding plugs. One 14' door, one 10'door on the 36'x56' garage and a 10'door on the 24'x12'. Relax in this amazing home with 12' ceilings, kitchen with hardwood floors, 42''tall wall cabinets, double oven, Jen air gas cook top, DW, Frig, trash compactor, pantry, and island. 1st floor laundry w/plenty of storage! First floor owner's suite with trey ceilings, jetted tub, large shower, separate vanities and two walk-in closets. 4 large BR's and a Jack-in-Jill bath. Gas fireplace in living room. Many architectural touches throughout the house. Sit out in the 3 season room overlooking the pool and property. Media room in basement w/large family room, an office, BR and full bath. Large cedar closet, large storage room workshop w/walkout. First floor approx. 2896 sq. ft./fin basement approx 2000 sq

2841 Brian Drive, 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

Browse All Properties for Sale with Fountain

Union Real Estate & Homes With Fountain