Estimated Value: $559,036 - $688,000
Executive Zaring-Ashville transitional in Legendary Run golf community with over 3700 sq ft of finished living space! Freshly painted and landscaped w/ sprinkler system! Loads of upgrades throughout! 1st flr Study (5th Bed Option) & solarium, hdwd flrs, 2 staircases, 2 story grt rm, & walk out to covered patio. 2nd flr bonus rm, lg master w/two walk-in closets, and luxury bath. Beautiful, fenced yard with spectacular views and lake setting. Tons of storage with partial finished bsmt, 1st flr laundry, and open fl plan. HOA community with access to pool/tennis/clubhouse. Hot tub included! New Roof (2022), New Water Heater (2021), Window Upgrades throughout! New Vinyl Siding (2021), Epoxy Garage Floor (2022), Whole House Humidifier (2023)
Last Agent to Sell the Property
Coldwell Banker Realty, Anders License #2018001723 Listed on: 03/07/2024
Home Type
Est. Annual Taxes
Year Built
Lot Details
HOA Fees
Parking
Property Views
Home Design
Interior Spaces
Kitchen
Flooring
Bedrooms and Bathrooms
Laundry
Outdoor Features
Utilities
Community Details
$489,900
Stunning 3,209 sq ft, 5-bedroom, 3.5-bath two-story home. Open-concept main floor boasts 9-ft ceilings, gourmet kitchen with oversized island, quartz countertops, and stainless steel appliances. Enjoy the vaulted ceiling sunroom, dining or office room. Beautiful hardwood floors throughout main level. Upstairs, find 4 spacious bedroomsall with walk-in closetsand a convenient laundry room. The
Alexandra Parker OwnerLand Realty, Inc.
$715,000
Completion date 5/1/25 for this 15 year, $600,000. Gold Leed certified tax abated townhomes. Spacious 2322 sq. ft. of luxurious living. Gourmet kitchen, quartz countertops, opens dining room, & great room, w/gas FP, & walkout to the large deck. Spacious owners suite, lg. WIC & bath, plus 2 additional guest rooms with en-suite full baths. Large lower level family room offers a walkout patio, &
Bruce Koehler Comey & Shepherd
$720,000
Completion date 5/1/25 for these 15 year, $600,000. Gold Leed certified tax abated townhomes. Spacious 2,322 sq. ft. of luxurious living. Gourmet kitchen, quartz countertops, open dining & great rooms w/gas FP, & walkout to the Lg. deck. Spacious owners suite, Lg. WIC & bath. Two additional guest rooms with en-suite full baths. The lower level family room offers a walkout & patio, wooded tree
Bruce Koehler Comey & Shepherd
$700,000
Completion date 5/1/25 for these 15 year $600,000. Gold Leed certified Tax abated townhomes. Spacious 2,322 sq. ft. of luxurious living. Gourmet kitchen, quartz countertops, open dining & great room w/gas FP & walkout lg. deck. Spacious owners suite, lg. WIC & bath, plus guest rooms with en-suite full baths. The 1st floor offers a spacious Guest suite & bath, with a walkout patio & wooded tree
Bruce Koehler Comey & Shepherd
$799,000
You'll find beautiful updates to this 4 BR/3.5 BA home with an unbeatable Sycamore Twp. location plus room to roam with 5500 + SF & 1/2 acre lot! Hardwoods on entire 1st floor, new carpet on 2nd floor, replacement windows throughout, HVAC replaced 2019. Kitchen renovated with white cabs, new appliances & granite tops. Finished LL w/ Rec Rm & Bonus Rooms for fitness/craft/media. Pergola & stamped
Helena Cameron Sibcy Cline, Inc.
$550,000
Stately westside estate located on 3 lots, totaling 2.23 manicured acres w/ park-like fenced backyard! Old world craftsmanship & charm intertwine w/ professional modern updates - the best of both worlds! Renovated gourmet kitchen w/ wine cooler, Thermador range + walnut hood, Subzero refrigerator, granite counters, quality cabinetry & fluted farmhouse sink + island sink. 1st floor primary suite
Sandra Wethington eXp Realty
$675,000
Stunning Brick Transitional 2-Story in Sought-After Legendary Run-a premier golf/pool community known for its elegance, charm, and active lifestyle! This beautiful transitional home seamlessly blends classic design with modern comfort. From the moment you arrive, the curb appeal captivates you with the landscaping, timeless architecture, and views of the golf course. Light-filled interior, fresh
Karen Bevins Sibcy Cline, Inc.
$615,000
Beautifully maintained in a sought after community! This home offers a blend of comfort, style and convenience. Enjoy the spacious 1st floor living, open concept that provides room for both relaxation and entertaining. Huge finished lower level with bedroom and full bath. Updates include: New Humidifier '25, AC '24 (with 12 year warranty), hall bathroom remodel '19, Quartz counters on both
Allison Hamilton Comey & Shepherd
$699,900
Located in the desirable Prestwick Place Subdivision, this 3-bedroom, 4.5-bath home offers over 3,300 sq ft of open-concept living space. Built in 2022 and minimally lived in, this home is as good as newif not betterfeaturing luxury upgrades throughout. Enjoy stunning hardwood floors, a stone fireplace, granite countertops, reverse osmosis water system, under-sink water filter, and a whole-house
Ragan McKinney Ragan McKinney Real Estate
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Klein Steven P | $660,000 | None Listed On Document | |
| Umberg Timothy | $379,000 | Ttai | |
| Murphy Michael S | $328,565 | -- |
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Klein Steven P | $370,000 | |
| Closed | Klein Steven P | $902,600 | |
| Previous Owner | Umberg Timothy | $250,000 | |
| Previous Owner | Umberg Timothy | $190,000 | |
| Previous Owner | Murphy Michael S | $60,000 | |
| Previous Owner | Murphy Michael S | $282,400 | |
| Previous Owner | Murphy Michael S | $262,850 |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 04/08/2024 04/08/24 | Sold | $650,000 | +4.0% | $207 / Sq Ft |
| 03/08/2024 03/08/24 | Pending | -- | -- | -- |
| 03/07/2024 03/07/24 | For Sale | $625,000 | +64.9% | $199 / Sq Ft |
| 02/18/2020 02/18/20 | Off Market | $379,000 | -- | -- |
| 11/20/2019 11/20/19 | Sold | $379,000 | -9.7% | $125 / Sq Ft |
| 10/24/2019 10/24/19 | Pending | -- | -- | -- |
| 09/16/2019 09/16/19 | Price Changed | $419,900 | -2.3% | $139 / Sq Ft |
| 08/22/2019 08/22/19 | Price Changed | $429,900 | -1.2% | $142 / Sq Ft |
| 06/17/2019 06/17/19 | For Sale | $435,000 | -- | $144 / Sq Ft |
| 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 | $6,439 | $149,560 | $29,510 | $120,050 |
| 2023 | $6,445 | $149,560 | $29,510 | $120,050 |
| 2022 | $6,501 | $120,750 | $23,800 | $96,950 |
| 2021 | $6,195 | $116,730 | $23,800 | $92,930 |
| 2020 | $6,172 | $116,730 | $23,800 | $92,930 |
| 2019 | $6,230 | $132,240 | $25,730 | $106,510 |
| 2018 | $6,232 | $132,240 | $25,730 | $106,510 |
| 2017 | $5,783 | $132,240 | $25,730 | $106,510 |
| 2016 | $6,005 | $117,010 | $22,750 | $94,260 |
| 2015 | $5,329 | $117,010 | $22,750 | $94,260 |
| 2014 | $5,329 | $117,010 | $22,750 | $94,260 |
| 2013 | $4,730 | $103,110 | $22,750 | $80,360 |
Seller's Agent in 2024
Heather O'Connor
Coldwell Banker Realty, Anders
(513) 885-0780
1 Total Sale
Seller Co-Listing Agent in 2024
Sondra Parker
Coldwell Banker Realty, Anders
(513) 886-2103
266 Total Sales
Buyer's Agent in 2024
Scott Oyler
Coldwell Banker Realty
(513) 547-2997
1,337 Total Sales
Buyer Co-Listing Agent in 2024
Brice Allen
Coldwell Banker Realty
(513) 255-8721
126 Total Sales
Seller's Agent in 2019
Karen Bevins
Sibcy Cline, Inc.
(513) 260-6272
87 Total Sales
Seller Co-Listing Agent in 2019
Peter Marx
Sibcy Cline, Inc.
(513) 919-4611
48 Total Sales
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1798253
APN: 27-28-14A-113
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