Twitter
Facebook
Email
|
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.
| DAYS ON MARKET | 1 | LAST UPDATED | 7/13/2026 |
|---|---|---|---|
| YEAR BUILT | 1995 | COMMUNITY | K11 - Richwd/Un/Wal/Ver/SB |
| GARAGE SPACES | 4.0 | COUNTY | Boone |
| STATUS | Active | PROPERTY TYPE(S) | Single Family |
| Elementary School | New Haven Elementary |
|---|---|
| Jr. High School | Gray Middle School |
| High School | Ryle High |
| ADDITIONAL DETAILS | |
| AIR | Ceiling Fan(s), Central Air |
|---|---|
| AIR CONDITIONING | Yes |
| APPLIANCES | Dishwasher, Double Oven, Gas Cooktop, Microwave, Refrigerator |
| AREA | K11 - Richwd/Un/Wal/Ver/SB |
| BASEMENT | Finished, Full, Other, Storage Space, Walk-Out Access, Yes |
| CONSTRUCTION | Brick, See Remarks, Stone |
| EXTERIOR | Balcony, Fire Pit, Lighting, Other, Private Yard |
| FIREPLACE | Yes |
| GARAGE | Yes |
| HEAT | Propane |
| INTERIOR | Beamed Ceilings, Bookcases, Breakfast Bar, Built-in Features, Cathedral Ceiling(s), Ceiling Fan(s), Chandelier, Coffered Ceiling(s), Crown Molding, Double Vanity, Eat-in Kitchen, Entrance Foyer, Granite Counters, High Ceilings, Kitchen Island, Natural Woodwork, Pantry, Recessed Lighting, See Remarks, Soaking Tub, Stone Counters, Storage, Tray Ceiling(s), Vaulted Ceiling, Walk-In Closet(s), Wet Bar |
| LOT | 3.6 acre(s) |
| LOT DESCRIPTION | Level, Wooded |
| LOT DIMENSIONS | 3.6 Acres! |
| PARKING | Attached, Driveway, Garage, Garage Faces Side, Off Street, Oversized |
| POOL | Yes |
| POOL DESCRIPTION | In Ground |
| SEWER | Septic Tank |
| STORIES | 2 |
| STYLE | Traditional |
| UTILITIES | Underground Utilities |
| VIEW | Yes |
| VIEW DESCRIPTION | Trees/Woods |
| WATER | Public |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
| SATELLITE VIEW |
| / | |
We respect your online privacy and will never spam you. By submitting this form with your telephone number
you are consenting for John
Jr. to contact you even if your name is on a Federal or State
"Do not call List".
Listing provided by Jane Ashcraft-West, RE/MAX Victory + Affiliates
The data relating to real estate for sale on this web site comes in part from the Broker ReciprocitySM Program of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Coffmans Realty are marked with the Broker ReciprocitySM logo or the Broker ReciprocitySM thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers.
Listing information is deemed reliable, but not guaranteed.
Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Last Updated: 7/13/26 7:31 PM PDT
This IDX solution is (c) Diverse Solutions 2026.