After a summer of floods and the declaration of another la nina the idea of buying a house in a flood zone may seem absurd