Seller's Agent in 2025
Michelle Hudepohl
Coldwell Banker Realty
(513) 254-5440
45 in this area
175 Total Sales
Estimated Value: $775,000 - $814,000
4
Beds
5
Baths
4,106
Sq Ft
$194/Sq Ft
Est. Value
Highlights
- Eat-In Gourmet Kitchen
- Sitting Area In Primary Bedroom
- Partially Wooded Lot
- Mason Intermediate Elementary School Rated A
- Vaulted Ceiling
- Transitional Architecture
About This Home
As of April 2025A custom Robert Lucke Home resale with wood floors throughout. This stunning home features 4 bedrooms and 3 full bathrooms upstairs, including a guest room with an ensuite. The first floor boasts a spacious dining room with wood floors and a gorgeous light fixture, a first-floor study with built-in shelves and French doors, and an updated kitchen with an island and granite countertops. Enjoy the convenience of a laundry chute from 2nd floor which leads to a updated first-floor laundry room & a charming 3-season room you will most likely live in, leading to a gorgeous patio. The finished basement offers a kitchenette, half bath, large recreation room, and a versatile flex room perfect for a second office, arts and crafts room, or exercise space. Located in a beautiful neighborhood with trails throughout and a pool, this home is ideally situated near Voice of America Park, Liberty Center Mall, Costco, shopping, and restaurants.
Last Agent to Sell the Property
Coldwell Banker Realty License #2006000198 Listed on: 03/07/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $8,776
Year Built
- Built in 2002
Lot Details
- 16,148 Sq Ft Lot
- Cul-De-Sac
- Property has an invisible fence for dogs
- Sprinkler System
- Cleared Lot
- Partially Wooded Lot
HOA Fees
- $133 Monthly HOA Fees
Parking
- 3 Car Attached Garage
- Garage Door Opener
- Driveway
- On-Street Parking
Home Design
- Transitional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
Interior Spaces
- 4,106 Sq Ft Home
- 2-Story Property
- Wet Bar
- Bookcases
- Crown Molding
- Vaulted Ceiling
- Ceiling Fan
- Recessed Lighting
- Chandelier
- Gas Fireplace
- Vinyl Clad Windows
- Insulated Windows
- Double Hung Windows
- French Doors
- Panel Doors
- Entrance Foyer
- Great Room with Fireplace
- Formal Dining Room
- Game Room
- Sun or Florida Room
Kitchen
- Eat-In Gourmet Kitchen
- Oven or Range
- Microwave
- Dishwasher
- Kitchen Island
- Solid Wood Cabinet
- Disposal
Flooring
- Wood
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- Sitting Area In Primary Bedroom
- Walk-In Closet
- Dual Vanity Sinks in Primary Bathroom
- Jetted Tub in Primary Bathroom
Laundry
- Dryer
- Washer
- Laundry Chute
Finished Basement
- Basement Fills Entire Space Under The House
- Sump Pump with Backup
- Rough-In Basement Bathroom
Home Security
- Smart Thermostat
- Fire and Smoke Detector
Outdoor Features
- Patio
- Exterior Lighting
Utilities
- Forced Air Heating and Cooling System
- Humidifier
- Heating System Uses Gas
- 220 Volts
- Gas Water Heater
- Cable TV Available
Community Details
- Association fees include association dues, pool, professional mgt, walking trails
- Stonegate Mgmt 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
Mar 7, 2025
Closed on
Apr 9, 2025
Sold by
Bought by
Seller's Agent
Michelle Hudepohl
Coldwell Banker Realty
Buyer's Agent
Brianna Frappier-Schirmang
eXp Realty
List Price
$800,000
Sold Price
$800,000
Views
127
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
-$1,727
Avg. Annual Appreciation
-0.19%
Original Mortgage
$725,000
Outstanding Balance
$718,610
Interest Rate
6.76%
Mortgage Type
New Conventional
Estimated Equity
$79,663
Purchase Details
Closed on
Mar 3, 2003
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
$190,000
Interest Rate
6.07%
Mortgage Type
New Conventional
Purchase Details
Closed on
Nov 19, 2001
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 |
|---|---|---|---|
| $800,000 | Columbia Title Llc | ||
| $394,870 | -- | ||
| $72,000 | -- |
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 | $725,000 | ||
| Previous Owner | $190,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 |
|---|---|---|---|---|
| 04/15/2025 04/15/25 | Off Market | $800,000 | -- | -- |
| 04/09/2025 04/09/25 | Sold | $800,000 | 0.0% | $195 / Sq Ft |
| 03/09/2025 03/09/25 | Pending | -- | -- | -- |
| 03/08/2025 03/08/25 | For Sale | $800,000 | -- | $195 / 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 | $8,777 | $216,260 | $49,000 | $167,260 |
| 2024 | $8,777 | $216,260 | $49,000 | $167,260 |
| 2023 | $8,003 | $166,586 | $28,175 | $138,411 |
| 2022 | $7,900 | $166,586 | $28,175 | $138,411 |
| 2021 | $7,483 | $166,586 | $28,175 | $138,411 |
| 2020 | $7,589 | $144,858 | $24,500 | $120,358 |
| 2019 | $6,977 | $144,858 | $24,500 | $120,358 |
| 2018 | $7,001 | $144,858 | $24,500 | $120,358 |
| 2017 | $6,830 | $131,936 | $22,775 | $109,162 |
| 2016 | $7,035 | $131,936 | $22,775 | $109,162 |
| 2015 | $7,049 | $131,936 | $22,775 | $109,162 |
| 2014 | $7,340 | $128,090 | $22,110 | $105,980 |
| 2013 | $7,356 | $141,940 | $24,500 | $117,440 |
Source: Public Records
Agents Affiliated with this Home
-
Michelle Hudepohl
-
Brianna Frappier-Schirmang
Buyer's Agent in 2025
Brianna Frappier-Schirmang
eXp Realty
(513) 325-7569
1 in this area
7 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1833035
APN: 15-06-259-016
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
- 6460 Timbers Ct
- 5018 Ainsley Dr
- 6552 Twin Lakes Dr Unit 313B
- 4969 Colt Ln
- 6120 Greenbrier Glen
- 4842 Tillinghast Ct
- 5835 Bayswater Dr Unit 209G
- 6246 Lake Springs
- 5136 Birchwood Farms Dr
- 5920 Thornberry Ct
- 6126 Nicholas Way
- 6130 Nicholas Way
- 6668 Ashley Ct Unit 20
- 6370 Coverage Ct
- 6171 Nicholas Way
- 6364 Coverage Ct
- 6175 Nicholas Way
- 6160 Nicholas Way
- 6164 Nicholas Way
- 6172 Nicholas Way
- 6478 Caddies Way
- 6446 Caddies Way
- 6469 Shady Oak Ln
- 6496 Caddies Way
- 6483 Shady Oak Ln
- 6451 Shady Oak Ln
- 6430 Caddies Way
- 6441 Caddies Way
- 6403 Sunset Ct
- 6514 Caddies Way
- 6439 Shady Oak Ln
- 6493 Shady Oak Ln
- 6418 Caddies Way
- 6386 Sunset Ct
- 6385 Sunset Ct
- 6528 Caddies Way
- 6490 Shady Oak Ln
- 6494 Lilly Pad Ct
- 6404 Caddies Way
- 6456 Shady Oak Ln
Your Personal Tour Guide
Ask me questions while you tour the home.