Refine Search
Sort by
12274 Gaines Way, Walton
$2,250,000
5 Beds ⋅ 7 Baths ⋅ 647945 MLS
Elegant European Manor Estate with Subtle French Provincial Influences, Set on 3.6 Beautiful Landscaped Acres & Offering Over 11,500+ SQ FT w/ Three Finished Levels. A Stately Brick & Stone Exterior, Defined by Arched Windows, Limestone Accents, & a Circular Drive Anchored by a Grand Multi-Tiered Fountain, Creates a Striking & Unforgettable Arrival. Inside, a Dramatic Two-Story Foyer with Sweeping Curved Staircase, Marble Flooring, & 10-Foot Mahogany Entry Door with Leaded Glass & Arched Transom Sets the Tone for Exceptional Craftsmanship. Exquisite Millwork, Elaborate Moldings, Statement Fireplaces, & Custom Bars are Complemented by Architectural Elements Sourced from Abroad. The Sunken Great Room is a True Showpiece with Hand-Finished Oak Paneling, Triple Arched Windows, & an Inglenook Fireplace Inspired by Ashford Castle in Ireland. The Kitchen Blends Warmth & Refinement with Custom Cabinetry, European Tile Accents, Generous Island, & Extraordinary Butler's Pantry with Illuminated Glass Display Cabinetry & Leaded Glass Transom. The Adjoining Keeping Room Features a Soaring Stone Fireplace & Reclaimed Beams, Creating a Dramatic Gathering Space with Old-World Charm. A Breathtaking Conservatory, Imported from England & Assembled by Craftsmen, Features a Vaulted Glass Ceiling & Panoramic Garden Views. A Screened Porch Extends Outdoor Living. The Home Offers 5-6 Bedrooms, 7 Baths, & 2 Studies. A Private Art Studio Apartment Above the Four-Car Garage Offers Flexibility for Guests or Creative Use. Outdoor Living Includes a Resort-Style In-Ground Pool with Limestone Coping & Lion Head Fountain, Cabana, Firepit, Curated Gardens, Chef-Inspired Herb & Vegetable Garden, Raised Beds, Winding Stone Paths, & a Waterfall-Fed Goldfish Pond with Stone Bridge, Creating a Serene Setting. Located Minutes from CVG Airport & Downtown Cincinnati, w/i the Award-Winning New Haven Elementary, Gray Middle, & Ryle High School District. See Photo Descriptions for Additional Detail.

12274 Gaines Way, Walton

1525 Trophy Court, Florence
$570,000
4 Beds ⋅ 6 Baths ⋅ 646776 MLS
Seller may consider contributing toward a 2/1 buyer down payment....Designer touches💕 ...Truly a must-see home, here are a few things the sellers love, LARGE CORNER LOT SPACED WELL FROM NEIGHBORING HOUSES, GIVING A PRIVATE FEEL; BACKYARD SITTING IN A QUIET, SECLUDED NEIGHBORHOOD ON A LOW-TRAFFIC STREET, YET 5 MINUTES FROM SHOPPING/RESTAURANTS/1-75/275 AND AN EASY COMMUTE TO THE AIRPORT AND .... PARK-LIKE LOCATION ON A GOLF COURSE. THE OVERSIZED SIDE ENTRANCE THREE-CAR GARAGE GIVES THIS BRICK HOME A PLACE FOR CARS AND TOYS. ONCE INSIDE, THE OWNERS MENTIONED THEY LOVED THE SPACIOUS ROOMS AND GREAT FLOOR PLAN, PERFECT FOR FAMILY AND ENTERTAINING. EACH BEDROOM HAS AN ADJOINING BATHROOM, LARGE CLOSETS WHICH ARE ALL LIGHTED. MAIN FLOOR EQUIPPED LAUNDRY NEAR THE KITCHEN, MAKING IT EASY TO MULTI-TASK, AND CLOSE TO THE BACK STAIRCASE LEADING TO THE TRUE MEANING OF A PRIVATE OWNER'S SUITE. AND THE FIREPLACE IN THIS SPACE JUST ADDS TO THE WARMTH. HAVING A FRONT AND REAR STAIRCASE HAS BEEN A PERFECT SETUP FOR RAISING A FAMILY. These are items you may love as well; however, the care this home has been given and the flexibility it offers make it the right choice for you to come and see how you would make this space your own. Elegant yet comfortable. 4 BEDROOMS, 3 FULL, 3 HALF BATHS, 3 FIREPLACES, COFFEE NOOK, BAR, MUSIC ROOM, BUILT-INS. Be Home for the Holidays! Make an offer today!

1525 Trophy Court, Florence

7155 Thornwood Lane, Florence
$660,000
6 Beds ⋅ 6 Baths ⋅ 646747 MLS
Welcome to 7155 Thornwood Lane in Oakbrook--an impressive 6-bedroom, 6-bath home offering exceptional space and a versatile floor plan designed for both everyday living and entertaining. Step inside to beautiful hardwood floors, extensive millwork, built-ins and elegant ceiling treatments throughout. The spacious kitchen is a standout, featuring granite countertops, stainless steel appliances, a large center island flowing into the adjoining living spaces. The great room makes a statement with its dramatic coffered ceiling, stone fireplace, built-in cabinetry and wall of windows. With two primary bedrooms, this home offers outstanding flexibility. Also included are two laundry rooms and a generously sized finished basement expands the living space even further and includes a bonus room Outside, discover your own backyard oasis surrounded by mature trees. Enjoy the peaceful wooded setting from the deck, then follow the steps down toward the creek for a unique outdoor retreat.

7155 Thornwood Lane, Florence

11184 War Admiral Drive, Union
$725,000
5 Beds ⋅ 6 Baths ⋅ 646441 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

10826 Omaha Trace, Union
$2,195,000
5 Beds ⋅ 9 Baths ⋅ 646149 MLS
Experience luxury living at its finest in this extraordinary estate located in the prestigious Triple Crown community, Omaha Trace. Offering over 16,000 square feet of meticulously designed living space, this one-of-a-kind home impresses from the moment you enter with soaring ceilings and a stunning open floor plan filled with natural light. The main level features a spacious first-floor primary suite complete with a luxurious bath and expansive walk-in closets, 2 private home offices and an elegant formal dining room--perfect for both everyday living and entertaining. Three bars throughout the home elevate the entertainment experience. Upstairs, you'll find generously sized bedrooms each with its own ensuite bathroom, cedar closet along with a dedicated exercise room. The incredible finished lower level is an entertainer's dream, boasting a sauna, full basketball court, additional bedroom, a large living area, and a kitchenette. Step outside to your private oasis featuring a walkout to a beautifully landscaped yard, a patio designed for relaxation and gatherings. A 4-car garage completes this exceptional property. This is a rare opportunity to own a truly remarkable home in one of the area's most sought-after communities.

10826 Omaha Trace, Union

10725 Meadow Stable Lane, Union
$1,600,000
4 Beds ⋅ 6 Baths ⋅ 646140 MLS
Located on the 11th fairway of Triple Crown Country Club, this custom home is its own retreat. You will feel like you are on vacation as you sit on your expansive covered back patio, equipped with an outdoor kitchen, bathroom, and a gas fireplace looking out to the heated pool with attached hot tub and golf course. You can't get more private than this. Inside you will find 4 bedrooms, 3 full baths and two half baths. The first-floor primary suite has direct access out to the covered patio for your morning coffee and luxury spa-like bathroom with oversized walk-in shower. The 12x12 primary closet has custom built-ins and you can continue through to your primary first level laundry room. The open floorplan and architecture are breathtaking, from the coffered ceiling, curved dining beam, oak hardwood floors, to the large custom pantry. There's also a second guest suite with on-suite bath and walk-in closet located on main level. Just off the beautiful custom kitchen you will find the mud room with a second laundry washer/dryer. The open staircase leads down to the lower level. The finished lower level is an extension of the living and entertaining space with a wet bar (equipped with sink, dishwasher, and full-sized fridge), theater room, gym, wine cellar, half bath for guests, and two more bedrooms with a full bath. Just when you think you don't need any more space, the unfinished storage room(s) is massive. Imagine having this masterpiece within walking distance from Triple Crown Country Club.

10725 Meadow Stable Lane, Union

9768 Spruce Lane, Union
$650,000
4 Beds ⋅ 6 Baths ⋅ 645692 MLS
Welcome to your private retreat in the heart of Union! Nestled on a picturesque 1.8-acre lot, this impressive 4-bedroom, 5-bath home is the perfect blend of space and everyday comfort. Step inside to discover a thoughtfully designed layout featuring generous living areas, ideal for both entertaining and daily living. The spacious kitchen with granite counters, flows seamlessly into the main living spaces. This home is a custom built, brick two story with added touches like a pot filler, heated flooring in the primary bath, baths connected to every bedroom. New carpet installed prior to listing and a new Furnace and AC in July 2026! Outdoors, your backyard oasis awaits. Enjoy summer days by the inground pool and poolside kitchen, surrounded by expansive green space that offers endless possibilities--from outdoor entertaining to quiet evenings under the stars. The large lot provides both privacy and room to roam, a rare find in this desirable area. The 3-car garage provides plenty of room for vehicles, storage, or hobbies. Close proximity to schools, shopping, and dining plus a One year warranty for buyers peace of mind. The Walk-out basement has a finished half bath and is framed and ready to go if you choose. Space, privacy, and resort-style living--this is the one you've been waiting for.

9768 Spruce Lane, Union

1114 Grindstone Court, Union
$575,000
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

506 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

739 Cameron Court, 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

10713 Meadow Stable Lane, 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

10730 Omaha Trace, Union
$2,500,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

1779 Tanner Road, Hebron
$550,000
5 Beds ⋅ 6 Baths ⋅ 637848 MLS
Discover this incredibly unique property set on over 4 acres w/breathtaking views. Just a few features are an elevator, 3 outbuildings, 2 w/electric, one is a huge 60'x40', 4 Fireplaces, 2 screened porches, gleaming hardwood floors, geothermal heat, fresh paint, a huge, finished walk out lower-level w/wet bar & separate wet bar room. The vaulted great room w/soaring ceilings & dual fireplaces creates a stunning focal point, while walls of windows frame the panoramic scenery. The huge eat in kitchen has its own fireplace, bay windows & enormous pantry overlooking the wooded views. The first-floor primary suite features a beautiful fireplace, private walkout to the patio, a study, walk in closet, 3 additional closets & an adjoining bath. Additional updates include professional waterproofing & Rhino exterior. With beautiful wood floors, architectural charm, & remarkable views from every angle, this one-of-a-kind retreat is truly unforgettable.

1779 Tanner Road, Hebron

1727 Coachtrail Drive, Hebron
$795,000
5 Beds ⋅ 6 Baths ⋅ 637417 MLS
Experience luxury living in Rivershore Farms! Nestled on a picturesque 1.57-acre lot, this stunning home blends timeless elegance with modern comfort. The first-floor primary suite offers a serene retreat with a completely renovated bath featuring a custom tile shower and soaking tub. Gleaming hardwood floors flow throughout the main level, where a dramatic two-story living room with fireplace and a formal dining room with crown molding set the stage for entertaining. The open kitchen and hearth room serve as the heart of the home, featuring a massive island, KitchenAid appliances, double sinks, a planning desk, a walk-in pantry, and a beautiful stone fireplace. Upstairs, you'll find three spacious bedrooms and two full baths. The finished lower level is designed for both fun and function, including a custom wet bar, gaming area, exercise room, fifth bedroom, full and half baths, and a second laundry room. Outdoor living shines with a large deck, a patio with hot tub, and a fire pit area, perfect for relaxing or hosting gatherings. A three-car garage completes this exceptional home.

1727 Coachtrail Drive, Hebron

10851 Charismatic Lane, 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

738 Man O'War Boulevard, Union
$824,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

8508 Robert Grant Drive, 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

8652 Marais 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

10831 Omaha Trace, 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

5265 Whitton Road, Petersburg
$1,235,000
6 Beds ⋅ 6 Baths ⋅ 626754 MLS
No, you are not dreaming! This 2 years new custom built Drees masterpiece on 10.3 acres could be yours! You will fall in love with the grand entrance, open floor plan, and beautiful finishes. Not a detail was missed with this stunning kitchen featuring quartz countertops, a gas cooktop, large island, farm sink, and an eat in kitchen. Enjoy time with your loved ones in the two story living room with an incredible stone fireplace and large windows showcasing a beautiful view. The first floor also offers a primary suite with an impressive bathroom, a second bedroom with an ensuite, formal dining, family ready room (laundry), and a flex space that could be utilized as an office or playroom. Head upstairs to find three spacious bedrooms and two additional full bathrooms. In the lower level you will enjoy a family room, wet bar, exercise space, and an additional bedroom and full bathroom. Take advantage of the outdoor space by relaxing on the front porch, enjoying a fire on the covered patio or having dinner on the oversized deck. Located in Boone Co SD and less than 30 minutes to downtown Cincinnati and CVG airpot- this property is the perfect blend of privacy and convenience!

5265 Whitton Road, Petersburg

10751 Omaha, 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

598 Rivershore Drive, Hebron
$950,750
6 Beds ⋅ 6 Baths ⋅ 625422 MLS
ENTERTAINER'S DREAM! Remarkable 6+ BDRM, 6 Bath, 3 Car Garage Residence Boasting Luxurious Living! Perfectly Appointed on a 1.73 ACRE Homesite Boasting PANORAMIC RIVER VIEWS, Incredible In-Ground Pool, & Suspended, Oversized Patio! Custom Built by Krumpelman Builders Who are Known for Elaborate Moldings, Upscale Appointments, & Outstanding Fit & Finish/5,832 FINISHED SQ FT on 3 LEVELS/Close to Greater NKY/Cincinnati Airport & Downtown Cincinnati/Enjoy a Wonderful LIFESTYLE w/One of the Best Views in the Northern KY Area in Most Desirable Rivershore Farms/Residential ELEVATOR Offering 1 Story Living in a 2 Story Home/Wide Hallways/Accessible Baths/Remarkable LVR RM, DNR RM, & Hearth RM/Gourmet Kitchen has 42 Inch Cabinetry, Solid Surface Countertops, (12 x 9 Pantry w/Additional Sink & Desk Area), Black Appliances, Double Oven, & Island w/Seating/Hard to Find, 1ST FL Primary Suite w/Fabulous River View, Walk-In Closet, & Adjoining Full Bath w/Walk-In Shower & Soaking Tub/1st Floor Laundry RM + Mudroom w/Cubbies/Plushly FIN LL w/Nice Bedroom, Full Bath, Spectacular Recreation RM, Storage Rooms, Kitchen/Bar Area, Lots of Windows, & French Patio Door Walkout/9 FT Ceilings/+ MUCH MORE!

598 Rivershore Drive, Hebron

10440 Enclave Drive, 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

10609 Pegasus Court, 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

3713 Iberville 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

How much is your home worth?

Get instant property value now!