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

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

85 N Main Street, Walton
$359,900
643157 MLS
Discover an exceptional investment opportunity in the heart of Walton, Kentucky! This 10-unit multifamily property, featuring a mix of 7 two-bedroom and 3 one-bedroom apartments, is perfectly positioned on N Main Street. Structurally sound with plenty of parking! Residents will enjoy easy access to local amenities, schools, and the highway. This building has a rich history in the city of Walton, as it was formerly the Walton School, serving the Walton Independent School District! New meters, valves, and shut off were replaced in 2024. The gas line has also been replaced to the street. This property presents a significant value-add opportunity. Currently, the building has been fully gutted, offering a blank canvas for a visionary investor to redesign it how they envision. With 14-foot ceilings, there's potential to create unique and desirable living spaces, and a few units could possibly be converted into 3-bedroom units. With generous lot dimensions and flexible redevelopment potential, the site is ideal for investors seeking value-add multifamily, mixed-use possibilities, or a full-scale reimagining. Seize the opportunity to transform this property into a highly desirable multifamily community and unlock its full investment potential!

85 N Main Street, Walton

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

633 Rivershore Drive, Hebron
$1,051,625
4 Beds ⋅ 5 Baths ⋅ 639902 MLS
Beautiful 7,500+/ sqft custom home nestled at the end of a private wooded cul-de-sac on a double lot. Perfect floor plan for entertaining. Dining room seats up to 20 guests. Loads of custom features. 9'-14' ceilings, Fluted cased door frames, arched door openings, hardwood throughout the first floor. Butlers pantry, wet bar between the formal living room and kitchen. The rear of the home has walls of windows overlooking the wooded yard. The chefs kitchen is open to the oversized family room and boasts a stone fireplace, coffered ceilings and built in cabinets. First floor primary suite has dual WIC, and large spa like bathroom. The incredible study is next to the primary with 14' coffered ceilings and loads of built in book cases. The second floor is expansive with three oversized bedrooms (all have access to a full bath). The lower level has 9' ceilings, a bar with a refrigerator, dishwasher, icemaker and microwave. Adjacent to the wine room. It is a huge room with loads of natural light. It also has a workout room, full bath and changing room that accesses the beautiful built in pool. The pool deck has a firepit and is adjacent to the covered porch. The unfinished portion ( approximately 1000 sqft) is perfect for a hobby. There is an additional stairway from the unfinished basement to the garage.

633 Rivershore Drive, Hebron

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

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

7535 Burlington Pike, Florence
$3,720,000
635853 MLS
One of the Area's Iconic Buildings with High Visibility on Burlington Pike (Route 18)*Over 19,000 square feet of Prestigious Quality Finished Space-Currently Finished as High End Salon w Spa Amenities & Nail Tech Area -Full Walkout/Glass Front Lower Level Last Used as Cosmetology School - 152 Parking Spaces - 2.8 Acres - Meticulous Condition * Low Maintenance Brick Exterior * Easy Access 1st & Lower Level * Multiple Bathrooms/Shower for Spa Area/Offices & Large Storage Rooms/Laundry & Kitchen Facilities - All Fixtures Can Be Included *Perfect Set Up for Med Spa/Wellness/Physical Therapy*Open Entry Foyer/Open Layout Offers Ease in Dividing for Rental Space*Other Zoning Includes: Parkway Corridor: Office, Medical and Institutional Uses - Large Entry Foyer Allows for Easy Division into Multiple Tenants*Expansive Lower Level Offers Endless Possibilities as Medical Rehab, Exercise Facility, Teaching Areas & More - Bring Your Business & Thrive in this Fast Paced Area of Florence - 1/2 Mile to I-75/Minutes to the Airport & Commercial District!

7535 Burlington Pike, Florence

How much is your home worth?

Get instant property value now!