We've rented many vacation home at the beach and this is the best one so far - definitely the cleanest and most well equipped of them all. We brought our clothing, toiletries, and food for the week. Pretty much everything else was provided.
The house itself is nothing fancy, just a basic split level with four bedrooms, but it has a lot of nice touches in the things that matter. Renovated bathrooms and kitchen...Comfortable living area...New, good quality windows that keep out any outside noise if needed..Nice deck overlooking a level yard on a corner lot... Comfortable mattresses (with memory foam toppers)... Walking distance to Scarborough beach.
I have various allergy issues, but did very well here because of the central air, wood floors, and mattress covers, plus the fact that the whole house was clean.
The owners were friendly and attentive to our needs. We texted to ask if they had a bicycle tire pump and one showed up later that day!
As far as the area goes - beyond Narragansett and Point Judith, our favorite was the various parks on Jamestown Island.