Refine Search
Sort by
$2,450,000
5 Beds 7 Baths 644597 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

$364,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

$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

$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

$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

$3,950,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