Seller's Agent in 2025
Kevin Hildebrand
eXp Realty
(513) 509-5677
155 in this area
652 Total Sales
8810 Schlottman Rd Maineville, OH 45039
Hamilton Township Neighborhood
5
Beds
3.5
Baths
6,160
Sq Ft
17.36
Acres
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
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Sep 18, 2025
Closed on
Oct 24, 2025
Sold by
Lloyd Michael and Evans-Lloyd Sally
Bought by
Mazzaro Erin and Mazzaro Brett
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
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-98.20%
Original Mortgage
$750,000
Outstanding Balance
$750,000
Interest Rate
6.35%
Mortgage Type
New Conventional
Estimated Equity
$33,754
Purchase Details
Listed on
Sep 3, 2015
Closed on
Jul 20, 2016
Sold by
Henninger Lenore L
Bought by
Lloyd Michael and Lloyd Sally Evans
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
Henninger Lenore L and Scott Henninger G
Bought by
Henninger Lenore L and The Henninger Family Trust
Purchase Details
Closed on
Dec 6, 2011
Sold by
Henninger G Scott and Henninger Lenore L
Bought by
Henninger G Scott and Henninger Lenore L
Purchase Details
Closed on
Dec 31, 2009
Sold by
Haller Randall R
Bought by
Henninger G Scott and Henninger Lenore L
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
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $1,750,000 | None Listed On Document | |
| Trustee Deed | $800,000 | Attorney | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | Attorney | |
| Executors Deed | $325,000 | Lawyers Title |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $750,000 | New Conventional |
Source: Public Records
Property History
| 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 Compared to Growth
Tax History
| 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 |
|---|---|---|---|---|
| 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
32 in this area
154 Total Sales
-
Derik Steiner
Buyer's Agent in 2025
Derik Steiner
Comey & Shepherd
(513) 616-0365
4 in this area
29 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
11 in this area
38 Total Sales
-
Gina Dubell-Smith
Buyer's Agent in 2016
Gina Dubell-Smith
eXp Realty
(513) 477-1219
22 in this area
273 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 2025, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 8651 Schlottman Rd
- 8701 Schlottman Rd
- 8371 S State Route 48
- 8339 Maineville Rd
- 8203 S State Route 48
- 8203 Ohio 48
- 0 St Rt 48 Unit 934215
- 8177 Oh-48
- 8371 Ohio 48
- 8404 Gettysburg Ln
- 84 W Foster Maineville Rd
- 217 W Foster-Maineville Rd
- 225 W Fosters Maineville Rd
- 222 Deershadow Rd
- 8128 Sycamore St
- 0 S St Rt 48 Unit 1858823
- 382 Broadway St
- 171 Hildebrant Dr
- 7903 Hopkins Rd
- 1207 Durbin Terrace