Refine Search
Map
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