Seller's Agent in 2026
Michelle Hudepohl
Coldwell Banker Realty
(513) 254-5440
175 Total Sales
5
Beds
4.5
Baths
8,006
Sq Ft
0.63
Acre Lot
Highlights
- Eat-In Gourmet Kitchen
- Sitting Area In Primary Bedroom
- Dining Room with Fireplace
- Mason Intermediate Elementary School Rated A
- View of Trees or Woods
- Wooded Lot
About This Home
As of May 2026Luxury and location converge at this extraordinary custom estate in prestigious Long Cove. Surrounded by signature canals and set on a private wooded lot, this exceptional home offers timeless architecture, rich wood detailing, and craftsmanship rarely found in today's luxury market. With approx. 8,000 total SF, this residence features elegant entertaining spaces, beautiful gathering areas, an unforgettable pub-style office, and 5 fireplaces that bring warmth and character throughout. The walkout lower level is designed for elevated living with a bar, fireplace, golf simulator, and fitness area. Outdoors enjoy the tiered patio, two story waterfall, and a serene fireplace setting. Ideally located in Mason School District, just minutes to I-71, The District, Whole Foods, Dorothy Lane Market, shopping, and dining.
Last Agent to Sell the Property
Coldwell Banker Realty License #2006000198 Listed on: 04/09/2026
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $25,368
Year Built
- Built in 2006
Lot Details
- 27,452 Sq Ft Lot
- Cul-De-Sac
- Level Lot
- Sprinkler System
- Wooded Lot
HOA Fees
- $311 Monthly HOA Fees
Parking
- 3 Car Attached Garage
- Garage Door Opener
- Driveway
Home Design
- Transitional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Stone
Interior Spaces
- 8,006 Sq Ft Home
- 2-Story Property
- Wet Bar
- Bookcases
- Crown Molding
- Beamed Ceilings
- Cathedral Ceiling
- Ceiling Fan
- Recessed Lighting
- Chandelier
- Wood Burning Fireplace
- Marble Fireplace
- Gas Fireplace
- Insulated Windows
- Window Treatments
- Wood Frame Window
- Casement Windows
- Double Door Entry
- French Doors
- Panel Doors
- Family Room with Fireplace
- Great Room with Fireplace
- Living Room with Fireplace
- Dining Room with Fireplace
- 5 Fireplaces
- Loft
- Views of Woods
Kitchen
- Eat-In Gourmet Kitchen
- Breakfast Bar
- Butlers Pantry
- Oven or Range
- Gas Cooktop
- Microwave
- Dishwasher
- Kitchen Island
- Quartz Countertops
- Solid Wood Cabinet
- Disposal
Flooring
- Wood
- Tile
Bedrooms and Bathrooms
- 5 Bedrooms
- Sitting Area In Primary Bedroom
- Main Floor Bedroom
- Walk-In Closet
- Dual Vanity Sinks in Primary Bathroom
- Bathtub
Laundry
- Dryer
- Washer
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Sump Pump with Backup
- Fireplace in Basement
Home Security
- Home Security System
- Smart Thermostat
- Fire and Smoke Detector
Outdoor Features
- Covered Deck
- Patio
- Outdoor Fireplace
- Exterior Lighting
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Programmable Thermostat
- 220 Volts
- Gas Water Heater
Community Details
- Association fees include association dues, clubhouse, exercise facility, landscapingcommunity, play area, pool, professional mgt, walking trails
- Stonegate 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
Apr 9, 2026
Closed on
May 26, 2026
Sold by
Bought by
Seller's Agent
Michelle Hudepohl
Coldwell Banker Realty
Buyer's Agent
Jolene Trombly
Coldwell Banker Heritage
List Price
$2,650,000
Sold Price
$2,525,000
Premium/Discount to List
-$125,000
-4.72%
Views
9
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
38.42%
Purchase Details
Closed on
Jul 24, 2009
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$920,000
Interest Rate
5.43%
Mortgage Type
New Conventional
Purchase Details
Closed on
Dec 17, 2008
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,590,000
Interest Rate
6.3%
Mortgage Type
Future Advance Clause Open End Mortgage
Purchase Details
Closed on
Sep 22, 2006
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,520,000
Interest Rate
6.58%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Dec 28, 2005
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,245,000
Interest Rate
6.4%
Mortgage Type
Fannie Mae Freddie Mac
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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $2,525,000 | Lawyers Title | |
| Warranty Deed | -- | First Title Agency | |
| Warranty Deed | $1,590,000 | Multi State Title Agency | |
| Warranty Deed | $1,900,000 | Classic Title Agency Llc | |
| Warranty Deed | $201,000 | None Available |
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 | Loan Amount | Loan Type |
|---|---|---|---|
| Previous Owner | $920,000 | New Conventional | |
| Previous Owner | $1,590,000 | Future Advance Clause Open End Mortgage | |
| Previous Owner | $1,520,000 | Purchase Money Mortgage | |
| Previous Owner | $1,245,000 | Fannie Mae Freddie Mac |
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 |
|---|---|---|---|---|
| 05/28/2026 05/28/26 | Sold | $2,525,000 | -4.7% | $315 / Sq Ft |
| 04/12/2026 04/12/26 | Pending | -- | -- | -- |
| 04/09/2026 04/09/26 | For Sale | $2,650,000 | -- | $331 / Sq Ft |
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 | $25,281 | $596,380 | $75,250 | $521,130 |
| 2024 | $25,421 | $596,380 | $75,250 | $521,130 |
| 2023 | $23,926 | $462,605 | $77,507 | $385,098 |
| 2022 | $23,486 | $462,606 | $77,508 | $385,098 |
| 2021 | $22,334 | $462,606 | $77,508 | $385,098 |
| 2020 | $25,567 | $449,131 | $75,250 | $373,881 |
| 2019 | $23,685 | $449,131 | $75,250 | $373,881 |
| 2018 | $23,717 | $449,131 | $75,250 | $373,881 |
| 2017 | $24,591 | $428,484 | $63,053 | $365,432 |
| 2016 | $25,321 | $428,484 | $63,053 | $365,432 |
| 2015 | $26,066 | $428,484 | $63,053 | $365,432 |
| 2014 | $26,066 | $408,080 | $60,050 | $348,030 |
| 2013 | $26,122 | $511,380 | $75,250 | $436,130 |
Source: Public Records
Agents Affiliated with this Home
-
Michelle Hudepohl
-
Sheri Elmore
Seller Co-Listing Agent in 2026
Sheri Elmore
Coldwell Banker Realty
(513) 404-5511
77 Total Sales
-
Jolene Trombly
Buyer's Agent in 2026
Jolene Trombly
Coldwell Banker Heritage
(513) 490-7871
23 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1874659
APN: 16-33-300-081
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
- 5576 Winding Cape Way
- 8678 Hampton Bay Place
- 9187 Nottingham Way
- 9024 Beacon St
- 5994 Meadow Harbor Dr
- 5983 Meadow Harbor Dr
- 8466 Tidemark Dr
- 8478 Tidemark Dr
- 9285 Leland Ct
- 5686 Farm Field Dr
- 8300 Cherrydale Ct
- 9493 Fox Run Dr
- 6208 Snidercrest Rd
- 5625 Baywatch Way
- 5625 Baywatch Way Unit 204
- 8896 Charleston Woods Dr
- 5655 Harbourside Dr
- 8612 Charleston Woods Dr
- 8017 Birchwood Ct
- 9867 Kensington Ln
Your Personal Tour Guide
Ask me questions while you tour the home.