Estimated Value: $501,000 - $1,021,000
Spectacular custom blt Transitional nestled on a meticulous wooded lot. Open & airy innovative flr plan w/main fl mstr suite. Exquisite woodworking detail, gourmet kit, incredible fin LL,screened deck & 3 car motor rm. Wonderful surprises throughout!
Last Agent to Sell the Property
Coldwell Banker Realty License #0000238441 Listed on: 05/18/2015
Home Type
Est. Annual Taxes
Year Built
Lot Details
HOA Fees
Parking
Home Design
Interior Spaces
Kitchen
Bedrooms and Bathrooms
Finished Basement
Outdoor Features
Utilities
Community Details
$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
$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
$699,000
Stunning Renovation in Indian Hill Schools-Like a Brand-New Home. Note the redone Exterior-New Roof, Gutters, Windows, Driveway. Deck, Fountain, Garage Door,Newly Seed, Beautiful Wood Front Door and Large Porch. Inside there is a 100% New, Awesome Large Kitchen, 3.5 Luxurious Bathrooms, All New Floors, Stylish Light Fixtures/Hardware, and Ceiling Fans. Newly Finished Lower Level with a Spacious
Andrea Szames 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.
$590,000
This home is unbelievable! You're going to love it! Original owner of 3639sf well thought-out custom built home located on private cul-de-sac with spectacular .678 acres wooded lot, the view is soo tranquil especially from the 21x10 screened porch or composite deck. Beautiful landscaping and front yd sprinkler system. Full attached 1 bedrm apartment on 1st flr (liv rm, eat in Kit, bdrm, full
Maria Nicolls Hoeting, REALTORS
$874,900
This gem is absolutely gorgeous on the inside and out and it checks all of the boxes! Over 5,000 square feet and a true 5 bedroom home with a 3 car garage. Primary suite on the first floor and second bedroom with it's own attached full bath. Modern open floor plan with tall ceilings. Unbelievable kitchen with a huge island and built in eating area. Family room with a wet bar and fireplace.
Courtne Brass Coldwell Banker Realty
$577,900
New Construction with customizable finishes & 15 year tax abatement! This 2,000 sq. ft. modern 3 bed/3.5 bath home features 9' ceilings (2nd & 3rd floor), choice of quartz counter tops, LVP flooring, soft close cabinetry, Moen fixtures, SS LG smart appliances & Andersen windows. Spacious 20'x10' private rear composite balcony & 2 car attached garage. Amenities include community park, dog park,
Theodore Hoerstmann Traditions Building and Dev.
$695,500
Elegance meets function in this beautifully crafted two-story home. With four generous bedrooms, two full & two half bathrooms, and a versatile loft style den, there's room for everyone to work, play, and unwind. The finished lower level is the perfect place to relax, complete with wet bar, entertainment zone and walk out to a private backyard oasis complete with a paver patio and custom outdoor
Ron Bisher Coldwell Banker Realty
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Sweet Alison P | -- | Attorney | |
| Fahrendorf William F | $500,000 | Attorney | |
| Schneller Homes & Remodellers Inc | $190,000 | None Available |
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Phelan Sean R | $453,000 | |
| Closed | Sweet Alison P | $489,250 | |
| Previous Owner | Fahrendorf William F | $250,000 | |
| Previous Owner | Fahrendorf William F | $200,000 | |
| Previous Owner | Schneller Homes & Remodelers Inc | $3,970,000 |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 11/26/2015 11/26/15 | Off Market | $526,500 | -- | -- |
| 08/27/2015 08/27/15 | Sold | $526,500 | -4.3% | $186 / Sq Ft |
| 06/26/2015 06/26/15 | Pending | -- | -- | -- |
| 05/18/2015 05/18/15 | For Sale | $549,900 | -- | $194 / 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,260 | $229,971 | $23,100 | $206,871 |
| 2023 | $12,319 | $229,971 | $23,100 | $206,871 |
| 2022 | $10,887 | $165,848 | $27,720 | $138,128 |
| 2021 | $9,976 | $165,848 | $27,720 | $138,128 |
| 2020 | $10,075 | $165,848 | $27,720 | $138,128 |
| 2019 | $12,334 | $184,275 | $30,800 | $153,475 |
| 2018 | $10,990 | $184,275 | $30,800 | $153,475 |
| 2017 | $10,388 | $184,275 | $30,800 | $153,475 |
| 2016 | $9,995 | $174,552 | $30,492 | $144,060 |
| 2015 | $10,005 | $174,552 | $30,492 | $144,060 |
| 2014 | $10,023 | $174,552 | $30,492 | $144,060 |
| 2013 | $9,466 | $176,316 | $30,800 | $145,516 |
Seller's Agent in 2015
Guy Cagney
Coldwell Banker Realty
(513) 312-7900
2 in this area
54 Total Sales
Seller Co-Listing Agent in 2015
Patrick Cagney
Coldwell Banker Realty
(513) 319-7312
7 in this area
428 Total Sales
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1449661
APN: 550-0203-0201
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