Set on 5.23 PRIVATE ACRES with 570′ of pristine Geist Reservoir shoreline, this 21,000 sq ft gated waterfront estate redefines Midwestern luxury. A gas-lit, tree-lined drive leads to The Andretti Estate, featuring 9 bedrooms, 12 bathrooms, 7 fireplaces & surrounded by manicured lawns, wooded trails & sweeping open-water views. Inside, craftsmanship & technology merge seamlessly with integrated automation, a three-level elevator & advanced security enhancing everyday life. The main level unfolds with breathtaking vistas from every gathering space, including a fireside study that leads to the estate lounge with bar, billiards area & sitting rooms. The culinary space showcases dual kitchens: a discreet caterer’s kitchen is steps away from the primary, featuring commercial-grade appliances, a 14′ island, and seamless flow to a 38′ heated veranda with grilling area, retractable screens, and sweeping lake views. An elegant anteroom leads to the private owner’s wing with a relaxing reading room & coffee nook. A double-sided fireplace is shared with the primary bedroom, its curved walls framing lake views through a full wall of windows. A spa bath rests beneath a glass-tiled barrel ceiling, while 650 sq ft of closet space completes the suite. The upper level offers two wings, one with a loft & 2 en suite bedrooms, the other a guest wing with kitchen, living room, 2 en suite bedrooms, laundry & garage access. The resort-style walkout level presents a 15-seat bar, 700 bottle wine cellar, theater, arcade, billiards room, fitness studio, 4 bedrooms, 5 baths & 4 exterior exits. The outdoor space features a 50′ gunite pool with slide, jacuzzi, waterfalls, fire features, multiple patios, a children’s play cottage with HVAC & a 50′ three-slip boat dock. A newer carriage house includes two 900 sq ft apartments, each with a kitchen, en suite bedroom, living room, laundry & 2-car garage. 5,500 sq ft of climate-controlled garage space with 12+ bays completes this unparalleled estate.

Date Added: 10/13/25 at 5:00 am
Last Update: 5/29/26 at 6:28 pm

Location

  • Road/AccessHighway
  • Originating MLSmibor
  • School DistrictHamilton Southeastern Schools
  • CountyHamilton
  • HOA Amenities2650.0, Annually

Lot

  • TopographyLevel
  • Zoning5.23 Acres Pt Sec 10 Township 17 Range 5, 291510000026002020
  • Current UseAgricultural
  • ViewLake, Trees/ Woods, Water, View
  • FencingPartial, Gate, Security

Utilities

  • WaterPublic
  • SewerPublic Sewer
  • UtilitiesCable Connected, Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected, 200+ Amp Service, 220 Volts, 220 Volts in Garage, Circuit Breakers, Generator, Underground

Financial

  • Sourcemibor

Exterior

  • GeneralCarriage/ Guest House, Gas Grill, Fire Pit, Smart Light(s), Sprinkler System, Water Feature Fountain, Other, Outbuilding, Gunite, Heated, In Ground
  • StyleTraditional, Other
  • Other StructuresPorch, Screened, Patio, Covered
  • ParkingAttached, Detached, Asphalt, Concrete, Electric Gate, Electric Vehicle Service Equipment ( EVSE), Garage Door Opener, Gated, Heated Garage, Garage Faces Rear, Garage Faces Side, Storage, Other
  • PoolHeated, In Ground, Pool Cover, Salt Water, Waterfall

Interior

  • GeneralBath Sinks Double Main, Breakfast Bar, Built-in Features, Cathedral Ceiling(s), High Ceilings, Tray Ceiling(s), Kitchen Island, Elevator, Entrance Foyer, Paddle Fan, Hardwood Floors, Hi- Speed Internet Availbl, In- Law Arrangement, Eat-in Kitchen, Wired for Data, Pantry, Smart Thermostat, Walk- In Closet(s), Wet Bar, Wood Work Stain/ Painted
  • AppliancesGas Cooktop, Dishwasher, Dryer, ENERGY STAR Qualified Appliances, Disposal, Gas Water Heater, Humidifier, Exhaust Fan, Microwave, Double Oven, Gas Oven, Range Hood, Refrigerator, Bar Fridge, Free- Standing Freezer, Ice Maker, Washer, Water Purifier, Water Softener Owned, Wine Cooler
  • LaundryMain Level, Upper Level, In Basement, Sink
  • A/CCentral Air, Dual, High Efficiency ( SEER 16 +), Zoned
  • HeatingZoned, Forced Air, Natural Gas, High Efficiency (90%+ AFUE )
  • FireplaceTwo Sided, Basement, Bedroom, Library, Family Room, Gas Log, Great Room, Hearth Room, Living Room, Masonry, Primary Bedroom, Fireplaces: 7
  • BasementCeiling - 9+ feet, Exterior Entry, Finished, Storage Space, Walk- Out Access
  • Half Baths3

Construction

  • GeneralThree Or More, Concrete Perimeter, Poured Concrete
  • RoofingMembrane, Shingle

Schools

  • DistrictHamilton Southeastern Schools

Virtual Tour

powered by

What's Nearby?

Restaurants

Error: Failed to fetch Yelp data or received unexpected response format.

Coffee Shops

Error: Failed to fetch Yelp data or received unexpected response format.

Grocery

Error: Failed to fetch Yelp data or received unexpected response format.

Education

Error: Failed to fetch Yelp data or received unexpected response format.

Park

Error: Failed to fetch Yelp data or received unexpected response format.

Map