Has anyone stayed at this hotel? And is it near the clubs, bars and shopping? If not how far is it x

Always seen favourable comments about the Hotel. Yes, it is very convenient for everything you might require: near to the main beach, right in the middle of the main tourist área. I think you will be happy there!
http://www.booking.com/hotel/es/holtel-belvedere.en.html

Does it have a supermarket near it?

yes come out of hotel door and go left walk 50m and turn left walk 30m and its on your left a big spar supermarket.

What clubs and pubs r around this hotel? Is 007 club near by?

007 is about a 5 min walk and its a small disco bar not a club as such ,also your hotel is in a very quiet street with nothing around it but its only 10 mins walk to almost anywhere eg,beach,restaurants,portaventura,,bars etc