My husband might be temporarily relocating for a job that his company is doing in Stamford, Ct. Since my last child is off to college in the fall, I will be coming with my husband. Although I have never been to Rhode Island, except through the travel magazines, it looks like a great place. I have been to Connecticut many times and although I love it there, I was thinking about staying in the Rhode Island area, possibly buying a vacation home. What would be a convenient location to Stamford and a beautiful vacation spot in Rhode Island? Close to the water or near a small village are fine. Newport looks great, but definitely too long of a commute. Definitely want intimate shops and restaurants. Thanks so much in advance.