This is more than a home-it's your private retreat. Escape to 17.3 acres of pure possibility- perfect for hobbyists, equestrians, farmers, or anyone craving space and privacy. This custom 5,000+ SF John Hueber built home offers 5 bedrooms, 3 baths, and a lifestyle that blends luxury with functionality. Inside, gleaming hardwood floors lead to a white, sunlit kitchen designed for hosting and gathering. The primary suite features a private porch with serene pond views, while the bonus room upstairs adds flexible space for work or play. Geothermal heating keeps comfort efficient year-round. The property is a dream for outdoor living-stocked pond, flowing creek, wooded trails, and 7 fenced fields for livestock. Historic 1800s barn, heated barn, chicken coop, 82x14 stall run with 5 turnouts, plus a feed/wash room make farm life easy. Attached 3-car garage with basement access and potential for up to 12 cars with lift installation. Relax on the 21x12 screened deck and watch nature unfold!
Sold for $1,750,000 on 10/24/25
$1,750,000
8810 Schlottman Rd, Maineville, OH 45039
5beds
6,160sqft
Single Family Residence
Built in 2010
17.36 Acres Lot
$1,884,700 Zestimate®
$284/sqft
$6,764 Estimated rent
Home value
$1,884,700
$1.79M - $1.98M
$6,764/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: October 24, 2025 at 11:44am
Listed by:
Kevin E Hildebrand 513-288-1488,
eXp Realty 866-212-4991,
Robyn L Rhein 513-288-1488,
eXp Realty
Bought with:
Derik A Steiner, 2014000301
Comey & Shepherd
Source: Cincy MLS,MLS#: 1855625
Originating MLS: Cincinnati Area Multiple Listing Service
Originating MLS: Cincinnati Area Multiple Listing Service
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Walkout, Wall-to-Wall Carpet
- Level: First
- Area: 221
- Dimensions: 17 x 13
Bedroom 2
- Level: First
- Area: 182
- Dimensions: 14 x 13
Bedroom 3
- Level: First
- Area: 110
- Dimensions: 11 x 10
Bedroom 4
- Level: Lower
- Area: 234
- Dimensions: 18 x 13
Bedroom 5
- Level: Lower
- Area: 208
- Dimensions: 16 x 13
Primary bathroom
- Features: Shower, Tile Floor, Double Vanity
Bathroom 1
- Features: Full
- Level: First
Bathroom 2
- Features: Full
- Level: First
Bathroom 3
- Features: Full
- Level: Lower
Bathroom 4
- Features: Partial
- Level: First
Dining room
- Features: Chandelier, Walkout, Wood Floor
- Level: First
- Area: 360
- Dimensions: 20 x 18
Family room
- Features: Walkout, Wall-to-Wall Carpet
- Area: 572
- Dimensions: 26 x 22
Kitchen
- Features: Pantry, Counter Bar, Eat-in Kitchen, Kitchen Island, Wood Cabinets, Wood Floor, Marble/Granite/Slate, Other
- Area: 238
- Dimensions: 17 x 14
Living room
- Features: Bookcases, Fireplace, Wood Floor
- Area: 440
- Dimensions: 22 x 20
Office
- Features: Wall-to-Wall Carpet
- Level: Lower
- Area: 120
- Dimensions: 12 x 10
Heating
- Mini-Split, Geothermal
Cooling
- Geothermal, Mini-Split
Appliances
- Included: Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer, Humidifier, Water Softener, Electric Water Heater
Features
- High Ceilings, Cathedral Ceiling(s), Recessed Lighting
- Doors: Multi Panel Doors
- Windows: Casement, Double Hung, Insulated Windows
- Basement: Full,Finished,Walk-Out Access,WW Carpet
- Number of fireplaces: 1
- Fireplace features: Stone, Wood Burning, Living Room
Interior area
- Total structure area: 6,160
- Total interior livable area: 6,160 sqft
Property
Parking
- Parking features: Driveway, Garage Door Opener
- Has attached garage: Yes
- Has carport: Yes
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered Deck/Patio, Deck, Patio, Porch
- Exterior features: Fire Pit
- Fencing: Metal,Wood
Lot
- Size: 17.36 Acres
- Dimensions: 17.36 Acres
- Features: Wooded, 10 to 19 Acres
- Topography: Lake/Pond,Level,Pasture,Rolling
Details
- Additional structures: Barn(s), Pole Barn, Shed(s), Stable(s), Workshop
- Parcel number: 1733302006
- Zoning description: Residential
- Other equipment: Radon System, Sump Pump
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Stone, Wood Siding
- Foundation: Concrete Perimeter
- Roof: Metal
Condition
- New construction: No
- Year built: 2010
Utilities & green energy
- Electric: 220 Volts
- Gas: None
- Sewer: Septic Tank
- Water: Public
- Utilities for property: Cable Connected
Community & neighborhood
Security
- Security features: Security System, Smoke Alarm
Location
- Region: Maineville
HOA & financial
HOA
- Has HOA: No
Other
Other facts
- Listing terms: No Special Financing,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 10/24/2025 | Sold | $1,750,000-12.5%$284/sqft |
Source:  Cincy MLS #1855625 Report a problem | ||
| 10/5/2025 | Pending sale | $1,999,999$325/sqft |
Source: Cincy MLS #1855625 Report a problem | ||
| 9/18/2025 | Price change | $1,999,999-21.6%$325/sqft |
Source: Cincy MLS #1855625 Report a problem | ||
| 8/13/2025 | Listed for sale | $2,550,000+218.8%$414/sqft |
Source: Cincy MLS #1851237 Report a problem | ||
| 7/20/2016 | Sold | $800,000+146.2%$130/sqft |
Source: Cincy MLS #1465115 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $17,164 +14.1% | $385,610 +27.7% |
| 2023 | $15,041 +1.1% | $301,980 0% |
| 2022 | $14,880 +4.9% | $301,983 |
Find assessor info on the county website
Neighborhood: 45039
Nearby schools
GreatSchools rating
- 7/10Little Miami Primary SchoolGrades: 2-3Distance: 2.2 mi
- 8/10Little Miami Junior High SchoolGrades: 6-8Distance: 4.6 mi
- 7/10Little Miami High SchoolGrades: 9-12Distance: 4.8 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,884,700
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,884,700