Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3315 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3315 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3315 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

2890 Lee Road
Shaker Heights, OH 44120
Susan Hodali with Mentor, original listing - (440) 951-1410

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $625,000
Beds: 6
Baths: Full: 3, ½: 2
Status: Active
SqFt: 5147 Square Feet
Agency: Mentor
Agency Phone: (440) 951-1410

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1914
Notes: This impeccable 1914 Shaker Heights colonial-style house offers the perfect blend of classic elegance and modern comforts. Set back from the street, it offers a private and peaceful setting, perfect for enjoying the tranquility of your surroundings. Step inside to discover gleaming hardwood floors throughout, enhancing the warm and inviting atmosphere. With 6 spacious bedrooms and 5 baths, this home is designed for both family living and entertaining. The butler’s entrance connects the dining room to a large kitchen, complete with abundant cabinetry. Enjoy your morning coffee in the lovely morning room, bathed in sunlight, or unwind in the living room, featuring a cozy wood-burning fireplace and walls of windows that flood the space with natural light.The main floor also boasts an enclosed sunroom that provides a serene retreat. With over 3,200 sq ft of living space, this home is perfect for gatherings with friends and family. Venture upstairs to find 4 generously sized bedrooms, including a primary suite with an en-suite bathroom,walk-in closet, and its own fireplace. A bedroom connects to a versatile room ideal for a playroom, nursery, or home office. A full bathroom conveniently serves two of the bedrooms on this floor. The 800+sq ft third floor adds even more space,featuring 2 bedrooms, a wardrobe room, a full bathroom, and a hallway lined with storage drawers.The walk-up basement includes sitting areas, a half bath, a workshop, and a spacious laundry area. The backyard oasis wraps around the property, featuring an array of plants, trees, and shrubs, creating a peaceful retreat. With a sprinkler system in both the front and back yards, maintaining your outdoor sanctuary has never been easier.Additional highlights include a bi-level garage for extra storage space and located just moments from shopping, dining, hospitals, public transportation, museums, and more.With extensive updates throughout, this home is ready for you to move in and make it your forever home!
MlsNumber: --
ListingId: 5070067


Listing Provided By: Mentor, original listing
Phone: (440) 520-0190
Office Phone: (440) 951-1410
Agent Name: Susan Hodali
Disclaimer: Copyright © 2024 Coldwell Banker Schmidt REALTORS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3315 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Katerina Alix Michalopoulos
Katerina Alix Michalopoulos
ASCIICENTURY 21 Premiere Properties
Call Today!: (216) 704-6020

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App