MLS #: 1165538   
Pending
Request More Information Show Me This Home
previous property photo picture 1 of 15 next property photo
Virtual Tour
View Map
Email a Friend
Print a Flyer
Estimate Payment
School Information
3815 Erie Ave
Cincinnati, OH 45208
About this property.
Price: $1,750,000
Property Type: Single Family
Style: 3 Story
County: Hamilton
School District: Cincinnati City SD
Bedrooms: 9
Bathrooms: 6 full, 2 half
Property Details
Construction: Brick,Stone
Lot: Of Record
Acres: 9.1999998
Heating: Hot Water
Cooling: Window Unit
Water: Public
Sewer: Public
Fireplaces: 3
Fireplace Type: Gas,Electric,Ceramic
Garage: Attached,Rear,Oversized
Garage: 3
Ceiling Fan,Smoke Alarm,Attic Storage,220 Volt,Fountain,Busline Near
Porch,Pool In-Ground,Wooded Lot - View: Woods
Master Bedroom32x19Level-2
Bedroom 218x15Level-2
Bedroom 315x12Level-2
Bedroom 416x13Level-2
Bedroom 511x8Level-2
Bedroom 6
Family Room16x12Level-1
Living Room32x18Level-1
Den15x13Level-1
Kitchen16x12Level-1
Dining Room19x16Level-1
Rec Room35x19Level-Lower
Laundry25x19Level-Lower
BasementFull,
Part Finished,
Walkout,
Fireplace,
WW Carpet
Entry18x14Level-1
Breakfast Room12x11Level-1
agentPhoto1
Michael Hinckley
Office: Hyde Park
Cell Phone: (513) 633-1886
Direct Phone: 513-533-8080
Voice Mail: (513) 483-4000
Office Phone: (513) 321-9944
Fax: 513-332-9096
Contact Me
Welcome to Stonecliff Estate! This unique Tudor-style home is situated on a picturesque nine-plus acre parcel in the heart of Hyde Park! Bordered by Forest Hill Drive and Hampton Lane across from Hyde Park Country Club, the property is an incredible opportunity for either a developer or a grand estate. The spacious manor home has a deep setback from Erie Avenue and is accessed by a long, woodland drive bordered by stone boulders. The home has nine bedroom, six full and two half baths and extraordinary period detailing throughout. Notable features include grandly proportioned rooms with hand-carved woodwork and mantles, mullioned casement windows, cathedral and beamed ceilings, and extensive use of marble and Rockwood tile throughout. With a distinctive old world charm and endless possibilities, this is a rare, one-of-a-kind opportunity.

East on Erie Avenue just past Hampton Lane

Copyright © 2005, Multiple Listing Services of Greater Cincinnati / All information is believed accurate but NOT guaranteed.
Copyright © 2005, Northern Kentucky Multiple Listing Service, Inc. / All information is believed accurate but NOT guaranteed.
The data relating to real estate for sale on this Web site comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc. and/or the Broker Reciprocity programs of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Coldwell Banker West Shell are marked with the Broker Reciprocity logo, or Broker Reciprocity house icon. The properties may not be all of the properties available through Broker Reciprocity.



Home | Contact Us | About Us | Careers | Site Map | Our Fair Housing Pledge
Terms & Conditions Privacy Policy
Kentucky Real Estate | Kentucky Condos | Kentucky Realtors
Indiana Real Estate | Indiana Condos | Indiana Realtors
National Real Estate