Estimated Value: $888,000 - $1,112,000
Stunning custom built in desirable Sterling Run Farms, minutes from CHCA, Harpers Point, & more. Nearly 6,000 sqft of Luxury Living in Sycamore Twp. 2 Story Foyer & Living Rm w/ Fireplace & BuiltIns. Gourmet Kitchen, Granite, Stainless Appliances, Gas Range, & Island. Owner's Suite w/ Oversized Bath, Custom Shower & 2 Walkin Closets. Family Room w/ Stone FP walks out to Covered Enclosed Deck. Finished lower level w/ Rec Rm, Bonus Rm & Full Bath. New Roof 2020, 2x HVAC 2021, Water Heater 2019.
Last Agent to Sell the Property
Keller Williams Seven Hills Re License #2014002297 Listed on: 02/26/2022
Home Type
Est. Annual Taxes
Year Built
Lot Details
HOA Fees
Parking
Home Design
Interior Spaces
Kitchen
Bedrooms and Bathrooms
Outdoor Features
Utilities
Community Details
$779,000
This 5,300ft2 of living space is an impeccably maintained Custom Home, in Sterling Run Farms. This is a Must See !!! Large Lot. Outdoor Living. Newer Mechanicals, roof and updates. Large Gourmet Kitchen with Island. Walk to the Silver Spring House and CHCA
Jeffrey Olinger Coldwell Banker Realty
$799,900
Location! Location! Location! Stately! Well Maintained!Brick!Approx.5,494 SQFT!2Story,4BD,2Full,2Half Bath & Finished Lower Level!2Car Oversized Garage!.485Acre!Private Park Like Setting!Stunning 2Story Open Foyer,Updated Kitchen W/WD Cbnts,Island,Pantry,Granite Cntrtps & SS Appliances!Breakfast Bay Overlooking Gorgeous BKYD!Formal LivingRM & DiningRM!GreatRM W/Beamed Ceiling,FP W/Hearth &
Toni Louis RE/MAX Preferred Group
$950,000
Just Hit the Market! Welcome to this custom built home nestled in Hartland, one of the area's most sought after neighborhoods. This residence is defined by its exceptional craftsmanship, intricate trim detailing and architectural charm. Inside you will appreciate the dual staircases leading to the second level, along with two well placed half baths on the first level! The heart of the home
Tom Canning Comey & Shepherd
$850,000
Rare Find in Sycamore Schools w/ a 1stFlr Primary Suite in Sought-after Hartland! Beautifully Updated Gourmet Kit feat Gorgeous Quartz & SS Appl Open to Fam Rm w/Vaulted Ceiling & w/o to Deck & Paver Patio in the Lg, Level Backyard. 1st Flr Stdy. Gleaming Hdwd Flrs throughout 1st Flr. Upstairs Boasts 4 Spacious Bdrms w/Convenient 2ndFlr Lndry (addt'l LL Lndry). Fin LL includes a Rec Rm & Full Ba,
Diane Tafuri Sibcy Cline, Inc.
$990,000
Located in Calumet Farm in Symmes Township, 11506 Stablewatch Ct is one of the largest homes in the neighborhood, on nearly half an acre. This five-bedroom, four full and two half-bath home offers over 6,000 finished square feet with key upgrades throughout. The first-floor primary suite adds privacy and function, and the home features high ceilings, custom woodwork, and three fireplaces. The
Lanxi Song Keller Williams Seven Hills Re
$1,189,900
Ask how you can lock your interest rate on this home today! The open and airy Drees Ash Lawn plan features 2 story high ceilings, covered outdoor living area, and a first floor guest suite. Located in the award winning Sycamore Community Schools, Sycamore Woods is minutes to Harpers Point shopping and city parks.
Jacqueline Bowen Drees / Zaring Realty
$995,000
Exceptional, high quality custom built ~4,600sf 5 bedroom, 4-1/2 bath brick contemporary home in Sycamore Schools! From the open entryway to the soaring ceiling with wall of windows in the great room, you will know this is a special property! 1st floor primary suite w/ unique illuminated ceiling detail, luxurious bath & walk-in closet, 3 bedroom suites on the 2nd floor + 1st floor laundry. Open
James Pitzer Coldwell Banker Realty
$1,250,000
Nestled in the heart of the Terwilligers Run Estates, this stunning 5-bed, 4.5 bath home blends modern luxury with timeless comfort. Extensively renovated, it boasts a state of the art kitchen w/ Thermador Stainless Steel appliances, marble & copper countertops and a spacious island perfect for entertaining. All bathrooms have been beautifully remodeled and master suite offers a serene retreat
Judith Warren Home Information Network, Inc.
$785,000
Beautifully appointed and spacious, this 5 bedroom, 4.5 bath former Homearama custom two-story home offers luxurious living in sought-after Indian Springs. The updated gourmet kitchen features quartz countertops, a large island, stainless steel appliances, and a sunny breakfast roomperfect for everyday living and entertaining. Enjoy abundant living space with formal living and dining rooms,
Beth Brown Clul eXp Realty
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Heath Julia A | $795,000 | Fletcher Michael C | |
| Suh Kendall | $560,000 | Ltoc | |
| Boykins Billy C | $494,900 | -- | |
| Ott Gary Y | $480,500 | -- |
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Heath Julia A | $112,000 | |
| Open | Heath Julia A | $515,000 | |
| Previous Owner | Suh Kendall H | $464,000 | |
| Previous Owner | Suh Kendall | $500,000 | |
| Previous Owner | Suh Kendall | $400,000 | |
| Previous Owner | Boykins Billy C | $345,000 | |
| Previous Owner | Boykins Billy C | $200,000 | |
| Previous Owner | Boykins Billy C | $300,000 | |
| Previous Owner | Ott Gary Y | $214,600 | |
| Closed | Ott Gary Y | $163,800 |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 04/14/2022 04/14/22 | Sold | $795,000 | 0.0% | $133 / Sq Ft |
| 03/11/2022 03/11/22 | Pending | -- | -- | -- |
| 02/26/2022 02/26/22 | For Sale | $795,000 | -- | $133 / 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 | $12,767 | $278,250 | $46,305 | $231,945 |
| 2023 | $12,805 | $278,250 | $46,305 | $231,945 |
| 2022 | $12,105 | $211,253 | $45,885 | $165,368 |
| 2021 | $11,780 | $211,253 | $45,885 | $165,368 |
| 2020 | $11,937 | $211,253 | $45,885 | $165,368 |
| 2019 | $11,414 | $185,311 | $40,250 | $145,061 |
| 2018 | $10,796 | $185,311 | $40,250 | $145,061 |
| 2017 | $10,181 | $185,311 | $40,250 | $145,061 |
| 2016 | $11,517 | $207,760 | $38,955 | $168,805 |
| 2015 | $11,635 | $207,760 | $38,955 | $168,805 |
| 2014 | $11,584 | $207,760 | $38,955 | $168,805 |
| 2013 | $10,751 | $196,000 | $36,750 | $159,250 |
Seller's Agent in 2022
James Harris
Keller Williams Seven Hills Re
(513) 509-1888
3 in this area
205 Total Sales
Seller Co-Listing Agent in 2022
Peter Chabris
Keller Williams Seven Hills Re
(513) 708-3000
7 in this area
1,127 Total Sales
Buyer's Agent in 2022
Jack Wolking
Comey & Shepherd
(513) 527-3800
1 in this area
67 Total Sales
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1730080
APN: 600-0012-0064
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