You don't say what your budget is. So it's difficult to provide a good answer. Without my knowing more about your situation and/or budget I would advise NEGOTIATING with one of the extended stay hotels nearby. There's one in Westlake OH (5 min. from Rocky River) and one in North Olmsted (10 min. away).
If you write back and provide more info, I will respond. Maybe I can even help with your Cranberry home too. I am familiar with the area.