Seller's Agent in 2024
Lee Robinson
Robinson Sotheby's International Realty
(513) 842-2224
1 in this area
160 Total Sales
Estimated Value: $3,039,316
4
Beds
8
Baths
--
Sq Ft
48
Acres
Highlights
- Barn
- Pool House
- View of Trees or Woods
- New Haven Elementary School Rated A
- Eat-In Gourmet Kitchen
- 48 Acre Lot
About This Home
As of January 2024Perfectly peaceful paradise! Specifically understated elegance, this expansive estate feels as if it's perched in the clouds, nestled up on approximately 48 stunning acres with sweeping and inspiring views at every turn of the breathtaking countryside, wondrous pond and unrivaled sunsets! This classic and timeless custom designed home flows through three carefully curated levels which includes an indoor all-seasons resort-style extraordinary pool area. Designed and executed with attention to detail this home features uncompromising quality and appointments displaying remarkable craftsmanship, windows carefully executed throughout to capture the stunning views and natural light, soaring 20+ coffered and beamed ceiling, an impressive balcony, a true culinary kitchen with an abundance of prep and gathering space and direct access to the pool area, all generous rooms have ensuites with the primary suite on the first floor, an elevator and a lower level designed for an entertainer's dream. Also, a commercial size multi-use metal barn with water/electric, separate meter, 80x40. All with the convenience of being ~25 minutes to Downtown Cincinnati and CVG Airport. Truly exceptional!!
Last Agent to Sell the Property
Robinson Sotheby's International Realty License #190017 Listed on: 11/04/2022
Co-Listed By
Britt Langman
Robinson Sotheby's International Realty License #198550
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $15,756
Year Built
- Built in 2007
Lot Details
- 48 Acre Lot
- Property fronts a private road
- Lot Has A Rolling Slope
- Heavily Wooded Lot
- Private Yard
Parking
- 3 Car Attached Garage
- Side Facing Garage
- Garage Door Opener
- Driveway
Property Views
- Pond
- Woods
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Stone
Interior Spaces
- 1.5-Story Property
- Open Floorplan
- Wet Bar
- Central Vacuum
- Sound System
- Built-In Features
- Bookcases
- Dry Bar
- Woodwork
- Crown Molding
- Beamed Ceilings
- Coffered Ceiling
- Tray Ceiling
- Cathedral Ceiling
- Ceiling Fan
- Recessed Lighting
- Chandelier
- Gas Fireplace
- Insulated Windows
- Picture Window
- Wood Frame Window
- Casement Windows
- Double Door Entry
- French Doors
- Panel Doors
- Family Room with Fireplace
- 5 Fireplaces
- Great Room
- Family Room with entrance to outdoor space
- Breakfast Room
- Formal Dining Room
- Den with Fireplace
- Loft
- Bonus Room
- Game Room Downstairs
- Storage Room
- Home Gym
Kitchen
- Eat-In Gourmet Kitchen
- Breakfast Bar
- Butlers Pantry
- Double Oven
- Electric Oven
- Gas Range
- Microwave
- Dishwasher
- Kitchen Island
- Granite Countertops
- Solid Wood Cabinet
- Disposal
- Instant Hot Water
Flooring
- Wood
- Carpet
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- Fireplace in Primary Bedroom
- En-Suite Primary Bedroom
- Walk-In Closet
- Granite Bathroom Countertops
- Dual Vanity Sinks in Primary Bathroom
- Jetted Tub in Primary Bathroom
- Primary Bathroom includes a Walk-In Shower
Laundry
- Laundry Room
- Laundry on main level
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Finished Basement Bathroom
- Stubbed For A Bathroom
Home Security
- Home Security System
- Security Lights
Accessible Home Design
- Accessible Elevator Installed
- Enhanced Accessible Features
Pool
- Pool House
- In Ground Pool
- Spa
Outdoor Features
- Pond
- Balcony
- Covered Patio or Porch
- Water Fountains
- Fire Pit
- Exterior Lighting
- Shed
- Outbuilding
- Outdoor Grill
Schools
- New Haven Elementary School
- Gray Middle School
- Ryle High School
Farming
- Barn
- Agricultural
Utilities
- Multiple cooling system units
- Central Air
- Heating System Uses Propane
- Propane
- Septic Tank
Community Details
- No Home Owners Association
Listing and Financial Details
- Assessor Parcel Number 042.00-00-012.13
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Nov 4, 2022
Closed on
Jan 22, 2024
Sold by
Schneider Michael and Schneider Tricia
Bought by
Kasselmann Emily and Kasselmann David
Seller's Agent
Lee Robinson
Robinson Sotheby's International Realty
Buyer's Agent
The Berens Team
Keller Williams Realty Services
List Price
$2,850,000
Sold Price
$2,750,000
Premium/Discount to List
-$100,000
-3.51%
Views
1067
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
$289,316
Avg. Annual Appreciation
5.85%
Original Mortgage
$1,500,000
Outstanding Balance
$1,473,751
Interest Rate
6.95%
Mortgage Type
New Conventional
Estimated Equity
$1,565,565
Purchase Details
Closed on
May 5, 2021
Sold by
Brewer Margaret Mary and Sutter Amy
Bought by
Schneider Michael and Schneider Tricia
Purchase Details
Closed on
Jun 6, 2019
Sold by
Sutton Michael T
Bought by
Schneider Michael and Schneider Tricia
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 | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Kasselmann Emily | $2,750,000 | 360 American Title Services | |
| Schneider Michael | -- | None Available | |
| Schneider Michael | $1,430,000 | None Available | |
| Schneider Michael | $1,430,000 | None Available |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Kasselmann Emily | $1,500,000 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 01/22/2024 01/22/24 | Sold | $2,750,000 | -3.5% | -- |
| 11/09/2023 11/09/23 | Pending | -- | -- | -- |
| 11/04/2022 11/04/22 | For Sale | $2,850,000 | -- | -- |
Source: Northern Kentucky Multiple Listing Service
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 | $15,756 | $2,268,400 | $900,000 | $1,368,400 |
| 2023 | $12,394 | $1,430,000 | $400,000 | $1,030,000 |
| 2022 | $12,227 | $1,430,000 | $400,000 | $1,030,000 |
| 2021 | $12,327 | $1,430,000 | $400,000 | $1,030,000 |
| 2020 | $12,468 | $1,430,000 | $400,000 | $1,030,000 |
| 2019 | $9,871 | $1,273,550 | $388,000 | $885,550 |
| 2018 | $9,818 | $1,273,550 | $388,000 | $885,550 |
| 2017 | $9,743 | $1,273,550 | $388,000 | $885,550 |
| 2015 | $9,631 | $891,490 | $5,940 | $885,550 |
| 2013 | -- | $891,491 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Lee Robinson
-
B
Seller Co-Listing Agent in 2024
Britt Langman
Robinson Sotheby's International Realty
-
The Berens Team
T
Buyer's Agent in 2024
The Berens Team
Keller Williams Realty Services
(859) 663-8464
36 in this area
278 Total Sales
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 609263
APN: 042.00-00-012.13
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 web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Ten-X are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers.
Listing information is deemed reliable, but not guaranteed.
Copyright 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Nearby Homes
- 2407 Beaver Rd Unit B
- 2441 Beaver Rd
- 12335 Crouch Rd
- 12822 Cleek Ln
- 12376 Ryle Rd
- 11126 Lakeview Dr
- 2619 Twin Hills Ct
- 4690 Setters Rd
- 10659 Mountain Laurel Way
- 3888 Hathaway Rd
- 1284 Brookstone Dr
- 10460 Enclave Dr
- BEDFORD Plan at Enclave at Courtney Estates
- CRESTWOOD Plan at Enclave at Courtney Estates
- KENDALL Plan at Enclave at Courtney Estates
- SEBASTIAN Plan at Enclave at Courtney Estates
- ALDRIDGE Plan at Enclave at Courtney Estates
- BRENNAN Plan at Enclave at Courtney Estates
- BENNETT Plan at Enclave at Courtney Estates
- ASH LAWN Plan at Enclave at Courtney Estates
- 2770 Beaver Rd
- 2800 Beaver Rd
- 16 Liberty Hills Dr
- 16 Liberty Hill
- 2740 Beaver Rd
- 2836 Beaver Rd
- 2720 Beaver Rd
- 3046 Beaver Rd
- 3070 Beaver Rd
- 2690 Beaver Rd
- 2930 Beaver Rd
- 3160 Beaver Rd
- 3130 Beaver Rd
- 2918 Beaver Rd
- 2847 Beaver Rd
- 2833 Beaver Rd
- 2869 Beaver Rd
- 2806 Beaver Rd
- 2859 Beaver Rd
- 2875 Beaver Rd