Waterfront properties have become increasingly sought after as second homes, offering tranquil views and a distinct lifestyle.