This is my personal favorite. Its a 2 bedroom condo in Indian Rocks Beach, with view of water but its set back one building so its not technically waterfront. But you dont have to cross a street to get to the beach.
http://www.vacationrentals.com/listing/p7007074
Indian Rocks is just a couple miles from Clearwater and a few more to St Pete, but its a family beach with lots of walkable restaurants. We have stayed there many times. I can't tell you how many times we have watched dolphins play and seen schools of mantas, etc. It is just the coolest beach, and such a quick drive to other beaches too.