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.
Est. $3,770 per month, based on comparable rentals
Sale and tax history for 10606 Brooks School Rd
Sale History
Tax History
Date
Event
Price
MIBOR as Distributed by MLS Grid #22067296
Oct 15, 2026
Sold
$9,243,820
$440/sq ft
Aug 18, 2026
Pending
—
May 29, 2026
Price Changed
$9,950,000
$474/sq ft
Feb 4, 2026
Price Changed
$10,948,500
$521/sq ft
Oct 13, 2025
Listed
$11,950,000
$569/sq ft
MIBOR as Distributed by MLS Grid #21443277
Dec 8, 2016
Sold
$2,165,000
$103/sq ft
Dec 2, 2016
Pending
—
Sep 15, 2016
Listed
$2,975,000
$142/sq ft
Geist Lakefront Estate with 5+ Acres. Gated & Wooded w/570 feet of Frontage on Open Water. Custom Built in 1990, expanded in '99 this Home has been extremely well maintained. All new Kitchen with 3 Sub Zeros. Almost 14,000 Sq Ft, 6 or 7 Bedrms, 8 Baths, 2 Laundry Rms, 7 Fireplaces, 3 Screened Porches, 6 Car Garage. Outstanding Main Level Master w/Sitting Rm, Grand Bath & 22x24 Custom Closet. 20x40 Gunite pool & Spa, Huge Paver Patio, Boat Docks. A Very Special Property w/Wonderful Lake Views.
MIBOR as Distributed by MLS Grid #21318400
Sep 15, 2016
Listing Removed
—
Mar 21, 2016
Price Changed
$3,200,000
$152/sq ft
Sep 18, 2015
Price Changed
$3,450,000
$164/sq ft
Oct 2, 2014
Listed
$3,685,000
$175/sq ft
MIBOR as Distributed by MLS Grid #21295876
Sep 13, 2014
Listing Removed
—
Jun 5, 2014
Listed
$3,995,000
$190/sq ft
MIBOR as Distributed by MLS Grid #21241244
Jun 5, 2014
Listing Removed
—
Jun 28, 2013
Listed
$4,450,000
$212/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$74,257 (+7.8%)
$1,008,000 + $5,019,500
$6,027,500
2024
$68,857 (−1.6%)
$1,008,000 + $5,019,500
$6,027,500
2023
$69,967 (+2.9%)
$935,000 + $4,375,900
$5,310,900
2022
$67,995 (+11.9%)
$935,000 + $4,382,300
$5,317,300
2021
$60,765 (+0.3%)
$935,000 + $4,027,000
$4,962,000
2020
$60,575 (+1.3%)
$935,000 + $3,381,400
$4,316,400
2019
$59,814 (+20.3%)
$858,000 + $3,419,600
$4,277,600
2018
$49,731 (+2.7%)
$858,000 + $3,397,600
$4,255,600
2017
$48,423 (+0.2%)
$935,000 + $1,190,100
$2,125,100
2016
$48,312 (−30.5%)
$935,000 + $1,190,100
$2,125,100
2015
$69,542 (−8.4%)
$1,058,200 + $2,226,000
$3,284,200
2013
$75,907
$1,058,200 + $2,212,900
$3,271,100
Public record
Public record
Zoning
Beds
4
Baths
10.5
Stories
2
Lot width
—
Lot depth
—
Lot size
5 Acres
Year renovated
2001
Sq. Ft.
19,710
Year built
1990
Style
Single Family Residential
County
Hamilton County
APN
291510000026002020
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 16, 2026.
R2
Residential District
The R2 District is intended to be provide for single-family homes in a lower density range of approximately 1.0 to 1.7 dwelling units per acre.
Permitted uses
Include but are not limited to:
Housing-Group
Housing-Single unit
Housing-Other
Infrastructure
Park & open space
Property details
Parking
Parking Information
Garage SqFt: 5500
Garage Parking Other: Finished Garage,Garage Door Opener,Keyless Entry,Service Door,Other
Parking Features: Attached, Detached, Asphalt, Concrete, Electric Gate, Electric Vehicle Service Equipment (EVSE), Garage Door Opener, Gated, Garage Faces Rear, Garage Faces Side, Storage, Other
Garage Spaces: 4
Has Garage
Interior
Virtual Tour
Interior Sq. Ft. Information
Building Area Total: 21010
Living Area: 21010
Main Level Sq. Ft.: 8521
Upper Level Sq. Ft.: 4816
Lower/Basement Level Sq. Ft (Finished): 7673
Bedroom Information
Primary Bedroom Description: Closet Walk in,Fireplace,Sitting Room
# of Upper Bedrooms: 4
# of Basement Bedrooms: 4
# of Bedrooms Main: 1
Beds MU: 5
Bedrooms MU: 5
Bathroom Information
# of Full Baths (Total): 9
# of Half Baths (Total): 3
# of Full Baths (Upper): 4
# of Full Baths (Main): 1
# of Full Baths (Basement): 4
# of Half Baths (Main): 2
# of Half Baths (Basement): 1
Half Baths MU: 2
Half Bathrooms MU: 2
Full Baths MU: 5
Full Bathrooms MU: 5
Primary Bathroom Description: Shower Stall Full,Sinks Double,Suite,Tub Full,Tub Full with Separate Shower
Room 1 Information
Room Type: Living Room
Room Dimensions: 24x22
Room Level: Main
Room 2 Information
Room Type: Dining Room
Room Features: Marble
Room Dimensions: 20x16
Room Level: Main
Room 3 Information
Room Type: Kitchen
Room Features: Marble
Room Dimensions: 30x28
Room Level: Main
Room 4 Information
Room Type: Laundry
Room Dimensions: 14x12
Room Level: Main
Room 5 Information
Room Type: Master Bedroom
Room Dimensions: 21x21
Room Level: Main
Room 6 Information
Room Type: Bedroom 2
Room Dimensions: 22x14
Room Level: Upper
Room 7 Information
Room Type: Bedroom 3
Room Dimensions: 22x14
Room Level: Upper
Room 8 Information
Room Type: Bedroom 4
Room Dimensions: 17x13
Room Level: Upper
Room 9 Information
Room Dimensions: 20x15
Room Level: Basement
Room 10 Information
Room Type: Library
Room Features: Marble
Room Dimensions: 19x16
Room Level: Main
Room 11 Information
Room Type: Foyer
Room Features: Marble
Room Dimensions: 16x12
Room Level: Main
Room 12 Information
Room Type: Sun Room
Room Dimensions: 38x13
Room Level: Main
Room 13 Information
Room Type: Great Room
Room Features: Marble
Room Dimensions: 52x34
Room Level: Main
Room 14 Information
Room Type: Hearth Room
Room Features: Marble
Room Dimensions: 28x20
Room Level: Main
Room 15 Information
Room Type: Living Room
Room Dimensions: 19x16
Room Level: Main
Room 16 Information
Room Type: Living Room
Room Dimensions: 25x14
Room Level: Main
Room 17 Information
Room Type: Enclosed Balcony
Room Dimensions: 27x10
Room Level: Upper
Room 18 Information
Room Type: Play Room
Room Dimensions: 36x16
Room Level: Upper
Room 19 Information
Room Type: Great Room
Room Dimensions: 19x17
Room Level: Upper
Room 20 Information
Room Type: Kitchen
Room Dimensions: 19x12
Room Level: Upper
Other Rooms Information
Rooms Upper: 8
Rooms Main: 12
Rooms Basement: 10
# of Rooms: 30
Laundry Room Information
Laundry Features: Main Level, Upper Level, In Basement, Sink
Cooling Information: Central Air, Dual, High Efficiency (SEER 16 +), Zoned
Interior Features
Interior Features: Breakfast Bar, Built-in Features, Cathedral Ceiling(s), High Ceilings, Tray Ceiling(s), Kitchen Island, Elevator, In-Law Floorplan, Eat-in Kitchen, Pantry, Smart Thermostat, Walk-in Closet(s), Wet Bar, WoodWorkStain/Painted
Appliances: Gas 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
Flooring: Hardwood
Areas Interior: Utility Room
Exterior
Building Information
Percent Optional Level Finished: 100
Exterior Features
Patio And Porch Features: Covered, Patio, Porch, Screened
Exterior Features: Carriage/Guest House, Gas Grill, Fire Pit, Smart Light(s), Sprinkler System, Water Feature Fountain, Other
Fence YN: Yes
Fencing: Partial, Gate, Security
Pool Information
Spa Features: Gunite, Heated, In Ground
Has Private Pool
Pool Features: Heated, In Ground, Pool Cover, Salt Water, Waterfall
Has Spa
Waterfront Information
On Waterfront
Waterfront Features: Dock, Lake Privileges, Lake Front, On Reservoir, Seawall, Water View, Waterfront
Farm Information
Horse Amenities: None
Property Information
Other Equipment: Generator, Irrigation Equipment, Security System, Smoke Alarm
Property Type: Residential
Property Condition: Updated/Remodeled
Other Structures: Outbuilding
Has View
Has Additional Parcels
Property Sub Type: Single Family Residence
Land Information
Acres: 5-10 Acres
Lot Information
Lot Size Acres: 5.23
Lot Features: Not In Subdivision, Mature Trees, Trees-Small (Under 20 Ft), Wooded
Utilities
Utility Information
Utility Prim Sewage Disp: Municipal Sewer Connected