Seller's Agent in 2025
Kevin Hildebrand
eXp Realty
(513) 509-5677
636 Total Sales
8810 Schlottman Rd Maineville, OH 45039
Estimated Value: $1,711,334
5
Beds
3.5
Baths
6,160
Sq Ft
$278/Sq Ft
Est. Value
Highlights
- 17.36 Acre Lot
- Wooded Lot
- Cathedral Ceiling
- Covered Deck
- Ranch Style House
- Wood Flooring
About This Home
As of October 2025This 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!
Last Agent to Sell the Property
eXp Realty License #0000409383 Listed on: 09/18/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $17,162
Year Built
- Built in 2010
Lot Details
- 17.36 Acre Lot
- Wood Fence
- Aluminum or Metal Fence
- Wooded Lot
Home Design
- Ranch Style House
- Poured Concrete
- Metal Roof
- Wood Siding
- Radon Mitigation System
- Stone
Interior Spaces
- 6,160 Sq Ft Home
- Bookcases
- Cathedral Ceiling
- Recessed Lighting
- Chandelier
- Wood Burning Fireplace
- Stone Fireplace
- Insulated Windows
- Double Hung Windows
- Casement Windows
- Panel Doors
- Living Room with Fireplace
- Bonus Room
- Screened Porch
- Home Gym
Kitchen
- Eat-In Kitchen
- Breakfast Bar
- Oven or Range
- Microwave
- Dishwasher
- Kitchen Island
- Solid Wood Cabinet
Flooring
- Wood
- Tile
Bedrooms and Bathrooms
- 5 Bedrooms
- Walk-In Closet
- Dual Vanity Sinks in Primary Bathroom
Laundry
- Dryer
- Washer
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Sump Pump
Home Security
- Home Security System
- Fire and Smoke Detector
Parking
- Garage
- Detached Carport Space
- Garage Door Opener
- Driveway
Outdoor Features
- Covered Deck
- Patio
- Fire Pit
Utilities
- Mini Split Air Conditioners
- Humidifier
- Mini Split Heat Pump
- Geothermal Heating and Cooling
- 220 Volts
- Natural Gas Not Available
- Electric Water Heater
- Water Softener
- Septic Tank
- Cable TV Available
Community Details
- No Home Owners Association
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Sep 18, 2025
Closed on
Oct 24, 2025
Sold by
Bought by
Seller's Agent
Kevin Hildebrand
eXp Realty
Buyer's Agent
Derik Steiner
Comey & Shepherd
List Price
$1,999,999
Sold Price
$1,750,000
Premium/Discount to List
-$249,999
-12.5%
Views
60
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$38,666
Avg. Annual Appreciation
-3.33%
Original Mortgage
$750,000
Outstanding Balance
$750,000
Interest Rate
6.35%
Mortgage Type
New Conventional
Estimated Equity
$961,334
Purchase Details
Listed on
Sep 3, 2015
Closed on
Jul 20, 2016
Sold by
Bought by
Seller's Agent
Elizabeth Poling
Sibcy Cline, Inc.
Buyer's Agent
Gina Dubell-Smith
eXp Realty
List Price
$999,000
Sold Price
$800,000
Premium/Discount to List
-$199,000
-19.92%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.81%
Purchase Details
Closed on
Sep 3, 2014
Sold by
Bought by
Purchase Details
Closed on
Dec 6, 2011
Sold by
Bought by
Purchase Details
Closed on
Dec 31, 2009
Sold by
Bought by
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $1,750,000 | None Listed On Document | ||
| $800,000 | Attorney | ||
| -- | None Available | ||
| -- | Attorney | ||
| $325,000 | Lawyers Title |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $750,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 10/24/2025 10/24/25 | Sold | $1,750,000 | -12.5% | $284 / Sq Ft | |
| 10/04/2025 10/04/25 | Pending | -- | -- | -- | |
| 09/18/2025 09/18/25 | For Sale | $1,999,999 | +150.0% | $325 / Sq Ft | |
| 10/18/2016 10/18/16 | Off Market | $800,000 | -- | -- | |
| 07/20/2016 07/20/16 | Sold | $800,000 | -10.8% | -- | View Prior Sale |
| 06/18/2016 06/18/16 | Pending | -- | -- | -- | |
| 06/06/2016 06/06/16 | Price Changed | $897,000 | -5.6% | -- | |
| 04/21/2016 04/21/16 | Price Changed | $950,000 | -4.9% | -- | |
| 09/03/2015 09/03/15 | For Sale | $999,000 | -- | -- |
Source: MLS of Greater Cincinnati (CincyMLS)
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $17,179 | $385,610 | $173,100 | $212,510 |
| 2024 | $17,179 | $385,610 | $173,100 | $212,510 |
| 2023 | $15,056 | $301,983 | $113,501 | $188,482 |
| 2022 | $14,892 | $301,984 | $113,502 | $188,482 |
| 2021 | $14,192 | $301,984 | $113,502 | $188,482 |
| 2020 | $10,584 | $0 | $0 | $0 |
| 2019 | $10,762 | $0 | $0 | $0 |
| 2018 | $10,538 | $0 | $0 | $0 |
| 2017 | $7,068 | $0 | $0 | $0 |
| 2016 | $6,755 | $0 | $0 | $0 |
| 2015 | $6,751 | $0 | $0 | $0 |
| 2014 | $6,696 | $0 | $0 | $0 |
| 2013 | $6,576 | $0 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Kevin Hildebrand
-
Robyn Rhein
Seller Co-Listing Agent in 2025
Robyn Rhein
eXp Realty
(513) 288-1488
164 Total Sales
-
Derik Steiner
Buyer's Agent in 2025
Derik Steiner
Comey & Shepherd
(513) 616-0365
25 Total Sales
-
Elizabeth Poling
Seller's Agent in 2016
Elizabeth Poling
Sibcy Cline
(513) 254-3301
2 Total Sales
-
Jackie Rumsey
Seller Co-Listing Agent in 2016
Jackie Rumsey
Coldwell Banker Realty
(513) 257-5213
33 Total Sales
-
Gina Dubell-Smith
Buyer's Agent in 2016
Gina Dubell-Smith
eXp Realty
(513) 477-1219
272 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1855625
APN: 17-33-302-006
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 8661 Schlottman Rd
- Lot 3 Schlottman Rd
- Lot 2 Schlottman Rd
- 8600 Ohio 48
- 8651 Schlottman Rd
- 0 St Rt 48 Unit 934215
- 495 Antietam Blvd
- 217 W Foster-Maineville Rd
- 8252 Sibcy Rd
- 829 Hamlin Dr
- 619 Fox Chase Way
- 8183 Sibcy Rd
- 413 Hennepin Dr
- 8007 Acorn Trail
- 8171 Cheltenham Ct
- 289 Hennepin Dr
- 8179 Worcester Dr
- 1130 Linford Cir
- 321 Heftner Cir
- 8042 Laurelwood Dr
- 8767 Schlottman Rd
- 8769 Schlottman Rd
- 8775 Schlottman Rd
- 8827 Schlottman Rd
- 8777 Schlottman Rd
- 8779 Schlottman Rd
- 8787 Schlottman Rd
- 8845 Schlottman Rd
- 8697 Schlottman Rd Unit 9.645ac
- 8697 Schlottman Rd Unit 10.0514
- 8697 Schlottman Rd Unit 3.3326
- 8697 Schlottman Rd Unit B
- 8697 Schlottman Rd Unit A
- 8697 Schlottman Rd
- 8700 Schlottman Rd
- 8877 Schlottman Rd
- 8894 Schlottman Rd
- 8899 Schlottman Rd
- 8915 Schlottman Rd
- 8930 Schlottman Rd
Your Personal Tour Guide
Ask me questions while you tour the home.