About ten years ago, my DP and I bought what can only be described as a dilapidated cottage that had been sitting on the market for three years. People in the village (it’s a very small village) told us the cost of repairs had put buyers off, and that younger locals weren’t especially interested in staying somewhere so 'dead' and were leaving for better job opportunities (and facilities).
We bought it as we knew we could turn it into a lovely place, we renovated it (my DP is very handy and did a lot of the 'less skilled' work), and now we use it as a second home as well as letting it out as a holiday cottage to help pay towards the fixed bills. It doesn’t get huge numbers of bookings because it really only appeals to people looking for peace and quiet, but we love spending time there. We both WFH, so we can work from there too.
Because of a number of factors, we only manage to stay there between 3 and 7 nights every six weeks, even though we’d like to go more often. If you have a second home, how often do you actually go and stay there?