Luxurious living in Sycamore Township offers everything expected and more! Featuring rich hardwood, gourmet kitchen, expansive 4 season room showcasing vaulted ceiling and hearth leading to outdoor dreamscape with gazebo, hot tub, and fire pit. Dual staircase leads upstairs to find the owner's suite boasting vaulted ceiling and fireplace, adjoining bath with jetted tub, all bedrooms with custom closets, plus bonus room perfect for a playroom or extra office. Lower level entertainment is a breeze with custom bar and fully equipped theater room plus bedroom with full bath. Indian Hill schools and minutes to shopping, dining, and interstate.
Last Agent to Sell the Property
Laurie Marra
eXp Realty License #2006006036 Listed on: 10/05/2024
Home Type
Est. Annual Taxes
Year Built
Lot Details
Parking
Home Design
Interior Spaces
Kitchen
Bedrooms and Bathrooms
Laundry
Finished Basement
Outdoor Features
Utilities
Community Details
$1,200,000
Located in the Prestigious Indian Hill School District ? Heitmeyer Farms Beautiful and understated, this expansive 4 to 6 bedroom, 4.5-bath home features two luxurious primary suites. A stunning addition showcases a fabulous first floor master suite with dressing area. The open kitchen flows seamlessly to the hearth and breakfast areas. This space is ideal for everyday living and
Karan Heuer Coldwell Banker Realty
$1,499,000
This one of a kind custom Everlasting Estates LLC build is luxury living at its finest. With over 5,800 sq.ft. your dream home boasts 10 ft. ceilings throughout with an expansive and open 18 ft. coffered ceiling great room, finished basement with wet bar, 4 car garage, second floor walkout/roof deck, and several other custom finishes. The desirable location is in Madeira central business district
Leah Thamann Coldwell Banker Realty
$1,349,900
World class private sanctuary sitting 250 ft off-street in the heart of Montgomery! Gorgeous transitional with expansive spaces, an open floor plan of approx 6000+ sq ft, 3 levels of luxury, and incredible outdoor living areas to enjoy including an inground pool & greenhouse with multiple patios and porches! 1st floor primary & study! Oversized bedrooms! 2nd floor loft! Chef's kitchen with maple
Julia Packer Wesselkamper Coldwell Banker Realty
$1,195,000
One of the best building opportunities in all of Madeira (if not the Tri-State) with Blackwelder Custom Homes. Over 2,800sf (3,000+sf if you opt to finish the room above the garage) hardwood throughout the first floor, study, large open concept kitchen with custom Shaker style full overlay cabinets and granite counters, dining area with walkout to back porch + 2 story living room ceiling. Primary
Michael Hines Coldwell Banker Realty
$1,175,000
Rare opportunity in Foxchase OF Madeira! This 4-BDRM/4.5 BTH offers elegance & functionality in premier location! Discover HDWD floors throughout most of main level. The private office provides the perfect work setup, while the formal living/dining rooms offer sophisticated spaces for entertaining. The beautiful kitchen features SS appls, 2 ovens, warming drawer, butler's pantry w/bev frig.
Linda deStefano Sibcy Cline, Inc.
$1,200,000
This gorgeous multi-generational home is a true gem in Indian Hill. It's the perfect balance of luxury, space, and functionality for a multi-generational family. Nearly on 1 acre, the property provides is private yet is ideally located on a quiet lane (Dot Avenue) next to the IH Swim Club (Madeira Schools). 7 bedrooms and 5.5 bathrooms with over 5,500 SQ FT of finished space. The highlight is the
Elizabeth Mahoney Sibcy Cline, Inc.
$1,200,000
Multiple Offers Notice - Highest and Best Offers are due by Saturday, 5/31/2025 at 2:00PM. We will do our best to respond by 3:00PM. Please reach out to the listing agent with any questions. Welcome to this stunning custom-built home in the sought-after Camargo Canyon neighborhood of Madeira. Situated on just over an acre, this expansive residence offers 5 bedroomswith a potential 6th in the
Andrew Hersey Fiv Realty Co Ohio LLC
$1,500,000
Rare opportunity in Rollman Reserve in cul-de-sac setting! Designed for one floor living, the limestone entry & walls of windows throughout frame the views of perennial gardens. The chef's kitchen has top-of-the-line Wolf & SubZero appliances while the two story great room offers stunning sky views. Relish dual primary luxury baths, including marble flooring, to pamper yourself. The custom
Barry Kaplan Comey & Shepherd
$1,700,000
Stunning New Construction in Amberley Village on 2.6 acres. Over 4,500 sf of finished space. Massive covered porch and wooded views. Finished basement and 2nd story bonus room or possible 5th bedroom. Rare acreage and central location. Enjoy the 100 Acre park view of Amberley Green from your front porch. Fall Completion.
Patrick Gunning Coldwell Banker Realty
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $1,400,000 | None Listed On Document | |
| Survivorship Deed | $870,000 | Old Town Title Agency | |
| Limited Warranty Deed | -- | Attorney | |
| Limited Warranty Deed | -- | Attorney | |
| Limited Warranty Deed | -- | Attorney | |
| Warranty Deed | $755,000 | Chicago Title Insurance Co | |
| Warranty Deed | $575,700 | -- |
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $1,260,000 | New Conventional | |
| Previous Owner | $300,000 | New Conventional | |
| Previous Owner | $510,400 | New Conventional | |
| Previous Owner | $185,600 | New Conventional | |
| Previous Owner | $510,400 | New Conventional | |
| Previous Owner | $532,824 | Credit Line Revolving | |
| Previous Owner | $216,000 | New Conventional | |
| Previous Owner | $150,000 | Future Advance Clause Open End Mortgage | |
| Previous Owner | $417,000 | New Conventional | |
| Previous Owner | $417,000 | Unknown | |
| Previous Owner | $250,000 | Credit Line Revolving | |
| Previous Owner | $265,000 | Unknown | |
| Previous Owner | $359,000 | Unknown |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 11/07/2024 11/07/24 | Sold | $1,400,000 | 0.0% | $184 / Sq Ft |
| 10/06/2024 10/06/24 | Pending | -- | -- | -- |
| 10/05/2024 10/05/24 | For Sale | $1,400,000 | +60.9% | $184 / Sq Ft |
| 03/10/2021 03/10/21 | Off Market | $870,000 | -- | -- |
| 11/30/2020 11/30/20 | Sold | $870,000 | -5.4% | $188 / Sq Ft |
| 10/17/2020 10/17/20 | Pending | -- | -- | -- |
| 09/14/2020 09/14/20 | For Sale | $919,900 | -- | $199 / 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 | $11,869 | $304,231 | $56,256 | $247,975 |
| 2023 | $11,940 | $304,231 | $56,256 | $247,975 |
| 2022 | $14,655 | $305,659 | $45,808 | $259,851 |
| 2021 | $14,275 | $305,659 | $45,808 | $259,851 |
| 2020 | $12,731 | $305,659 | $45,808 | $259,851 |
| 2019 | $11,975 | $268,122 | $40,184 | $227,938 |
| 2018 | $12,000 | $268,122 | $40,184 | $227,938 |
| 2017 | $11,442 | $268,122 | $40,184 | $227,938 |
| 2016 | $11,499 | $257,044 | $38,721 | $218,323 |
| 2015 | $11,144 | $257,044 | $38,721 | $218,323 |
| 2014 | $11,075 | $257,044 | $38,721 | $218,323 |
| 2013 | $10,829 | $242,495 | $36,530 | $205,965 |
Seller's Agent in 2024
Laurie Marra
eXp Realty
(513) 259-4215
2 in this area
85 Total Sales
Buyer's Agent in 2024
Brynn Fossett
Comey & Shepherd
(513) 290-8928
9 in this area
98 Total Sales
Seller's Agent in 2020
Judy Recker
Sibcy Cline
(513) 500-7003
26 in this area
56 Total Sales
Buyer's Agent in 2020
Ron Garland
Comey & Shepherd
(513) 703-4945
1 in this area
124 Total Sales
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1820351
APN: 600-0060-0324
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