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
$1,750,000
8810 Schlottman Rd, Maineville, OH 45039
5beds
6,160sqft
Single Family Residence
Built in 2010
17.36 Acres Lot
$1,883,100 Zestimate®
$284/sqft
$7,864 Estimated rent
Home value
$1,883,100
$1.79M - $1.98M
$7,864/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$7,864/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$7,864/mo
Rent Zestimate®
Refinance and save
$10,889/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$10,889/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat'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,883,100
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,883,100
- Ohio
- Warren County
- Loveland
- 45039
- 8810 Schlottman Rd