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,673,800 Zestimate®
$284/sqft
$5,256 Estimated rent
Home value
$1,673,800
$1.56M - $1.81M
$5,256/mo
Zestimate® history
Owner options
List your home for rent
$5,256/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,256/mo
Rent Zestimate®
Refinance and save
$9,032/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$9,032/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:
Listing updated:
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 & HOA
Community
- Security: Security System, Smoke Alarm
HOA
- Has HOA: No
Location
- Region: Maineville
Financial & listing details
- Price per square foot: $284/sqft
- Annual tax amount: $17,162
- Date on market: 9/18/2025
- 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 | ||
| 12/31/2009 | Sold | $325,000$53/sqft |
Source: Cincy MLS #1197678 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $17,154 -0.1% | $385,610 |
| 2024 | $17,164 +14.1% | $385,610 +27.7% |
| 2023 | $15,041 +1.1% | $301,980 0% |
| 2022 | $14,880 +4.9% | $301,983 |
| 2021 | $14,180 +34.1% | $301,983 +23% |
| 2020 | $10,572 -1.7% | $245,514 |
| 2019 | $10,750 +1.9% | $245,514 |
| 2018 | $10,548 +49.2% | -- |
| 2017 | $7,068 +4.9% | -- |
| 2016 | $6,737 -0.2% | -- |
| 2015 | $6,751 +0.8% | -- |
| 2014 | $6,696 +65.6% | -- |
| 2009 | $4,045 -2.4% | $107,380 |
| 2008 | $4,142 | $107,380 |
| 2007 | -- | $107,380 +51% |
| 2006 | -- | $71,120 -3.1% |
| 2005 | -- | $73,400 |
| 2004 | -- | $73,400 |
| 2003 | -- | $73,400 +15.5% |
| 2002 | -- | $63,560 |
| 2001 | -- | $63,560 +19.7% |
| 2000 | -- | $53,080 +6.3% |
| 1999 | -- | $49,920 |
Find assessor info on the county website
Neighborhood: 45039
Nearby homes
- $1,128,8004 bd3 ba-- sqft8810 Schlottman Rd, Hamilton Twp, OH 45039Off Market
- $714,9003 bd2 ba-- sqft8786 Schlottman Rd, Maineville, OH 45039Off Market
- $--6.74 Acres8665 S State Route 48, Maineville, OH 45039Off Market
- $366,730-- bd-- ba-- sqft8684 Schlottman Rd, Maineville, OH 45039Off Market
- $285,4003 bd1 ba1.4k sqft8894 Schlottman Rd, Maineville, OH 45039Off Market
- $279,4003 bd1 ba1.2k sqft8930 Schlottman Rd, Maineville, OH 45039Off Market
- $32,150-- bd-- ba-- sqft121 Schlottman Rd, Maineville, OH 45039Off Market
- $837,6002.74 Acres8684 Schlottman Rd, Maineville, OH 45039Off Market
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,673,800
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,673,800
- Ohio
- Warren County
- Loveland
- 45039
- 8810 Schlottman Rd
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Loveland Topics
