Based on what you're describing Misquamicut and Newport would fit your bill nicely.

That being said, you're behind the 8 ball if you're looking to get a place for July. I would be not m my decision first and foremost on what you can find that's stilll available to rent.