We stayed HERE (The Sands apartments) a couple of years ago – got a really great bargain in October half term (about £300 for the 4 of us I recall). All done out really nicely – luxury bathrooms, coffee machines, Bose stereo etc.
It is quite a (VERY STEEP) walk up the hill from Carbis Bay but not too far from the train station for quick journeys into St Ives.
We just called the owner directly and he did us a great deal that wasn’t available via his website. And when our little girls (1yr old at the time) broke things they just said ‘thanks for letting us know, don’t worry, there’s no charge’.
But – it isn’t ‘by the sea’ but has great views of it. And there are no real ale pubs unless you get the short train trip into St Ives.
And just noticed you don’t know the area – Carbis Bay is beautiful, golden sands and very well sheltered (we played on the beach in October).