Call Now 513-451-4800
my portfolio login
| Listing Information | |
|---|---|
| Price | $3,650,000 |
| Listing Number | 1814475 |
| Under Contract | |
| Driving Directions |
|---|
| From Loveland, N on SR 48, LF on Butterworth, property on Right after Loveland-Maineville Rd. Property is gated. |
| Agent Remarks |
|---|
| Discover unparalleled luxury in this exquisite John Hueber-built estate, perfectly nestled on 30+ acres, just 2.5 miles from the heart of downtown Loveland. Boasting over 6000 SF of meticulously crafted living space, the home features stunning Kentucky field stone, rich wooden beam accents, & state-of-the-art energy efficiency with a geothermal system. Indulge in outdoor living with covered patio, outdoor kitchen & breathtaking views of the gunite infinity saltwater pool & a serene stocked pond with a dock. The estate also features enchanting woods with picturesque waterfalls, perfect for peaceful strolls or private escapes. Car enthusiasts or those who appreciate space & functionality will appreciate the expansive garage space, offering 3 attached & 5 detached bays with a guest house suite providing a private retreat. A barn with a workshop adds versatility, whether for hobbies, storage/add'l workspace. Experience perfect blend of luxury, comfort & nature in this extraordinary estate. |
| General Information | |
|---|---|
| Property Type | Residential |
| Style | Single Family |
| County | Warren |
| Subdivision | Hamilton Twp |
| Zip Code | 45140 |
| School District | Little Miami Local S |
| Listing Number | 1814475 |
| Bedroom Information | ||
|---|---|---|
| Beds | 6 | |
| Master Bedroom | 19 x 17 | L: 1 |
| Bedroom 2 | 14 x 12 | L: 2 |
| Bedroom 3 | 14 x 12 | L: 2 |
| Bedroom 4 | 16 x 16 | L: Lower |
| Bedroom 5 | 15 x 13 | L: Lower |
| Bathroom Information | ||
|---|---|---|
| Baths | 7.4 | |
| Bath 1 | Full | L: 1 |
| Bath 2 | Full | L: 2 |
| Bath 3 | Full | L: Lower |
| Bath 4 | Full | L: Lower |
| Property Features | |
|---|---|
| Basement | Full |
| Garage | Attached, Detached, Side, Oversized |
| Cars | 8 |
| Parking | Driveway |
| Windows | Wood, Aluminum, Insulated, Double Hung, Casement |
| Heating | Geothermal |
| Cooling | Geothermal |
| Fireplace | Gas, Stone |
| Additional Information | |
|---|---|
| Levels | 1.5 Story |
| Construction | Brick, Stone |
| Architecture | Transitional |
| Gas | Propane |
| Water | Public |
| Sewer | Septic |
| Foundation | Poured |
| Occupancy | At Closing |
| Semi-Annual Taxes | $20,650.00 |
| Room Information | ||
|---|---|---|
| Entry | 21 x 10 | L: |
| Living | 25 x 19 | L: 1 |
| Dining | 18 x 14 | L: 1 |
| Kitchen | 26 x 17 | L: 1 |
| Breakfast | 17 x 8 | L: 1 |
| Family | 30 x 28 | L: Lower |
| Recreation Room | 16 x 14 | L: Lower |
| Study | 16 x 16 | L: 1 |
| Laundry | 11 x 8 | L: 1 |
| Additional Features | |
|---|---|
| Master Bedroom Info | Walkout, Other, Wood Floor, Bath Adjoins, Walk-in Closet, Dressing Area, Sitting Room, Fireplace, Window Treatment |
| Master Bath Info | Marb/Gran/Slat, Double Vanity, Bidet, Shower, Tub, Ceramic Tile, Built-In Shower Seat |
| Basement Details | Finished, Other, WW Carpet |
| Entry Features | Transom/Sidelit, Wood Floors, Open Foyer, Closet |
| Living Room Features | Walkout, Other, Wood Floors, Wet Bar, Fireplace, Bookcase |
| Dining Room Features | Other, Wood Floors, Chandelier, Walkout |
| Kitchen Features | Pantry, Wood Cabinets, Fireplace, Walkout, Marble/Granite/Slate, Wood Floor, Eat-In, Gourmet, Island, Counter Bar |
| Family Room Features | Wall-to-Wall Carpet, Other, Wood Floors, Bookcase, Wet Bar |
| Appliances | Oven/Range, Dishwasher, Refrigerator, Microwave, Garbage Disposal, Gas Cooktop, Double Oven, Convection Oven, Wine Cooler |
| Other Features | Ceiling Fan, 220 Volt, Fountain, Cable TV, Smoke Alarm, Recess Lights |
