A second home is great. A get away from the rat race of every day life.
But, it isn't all fun and games.
Remember this before buying...
There is regular maintenance to be done.
Grass to mow.
Leaves to rake.
Depending on the type of place you are thinking of there may be a dock to put in and take out and maintain.
It is going to be more work out of your weekends unless you have the extra money to hire it all out.
I am not trying to talk you out of a 2nd home...It is just I hate when you call me after a year or 2 and say it is to much to take care of.