My grandmother ran a shop and tea rooms in the rural seaside village she raised her family in. We’re talking the 60’s/70’s here. When she closed up, no one ever filled the void. The village has grown massively in the last ten years, lots of new build developments. it gets lots of tourists and has had lots of funding ploughed into it. But no shop and no tea rooms. Everyone has to go to the next bigger village over. After my grandmother died, my grandfather lived alone in a little cottage in the village which has been vacant since his death many years ago. The cottage would be ideal for a shop and tea rooms, there is room for out door dining and even parking. I’ve always wanted to move out there when my DCs were grown (all their friends/hobbies/school etc are in the town we live in now) and live by the beach. There are still lots of my extended family there. But it would take a fair whack of money to buy and make it suitable and it’s not money I would be a good candidate to lend to. I’m a lone parent, working self employed (which covid put the spanner in for the last 18 months!) and I don’t even own my own home, I rent. So no one in their right mind would lend to me. I reckon if I had about 5 years of solid self assessments and my youngest DC would be almost an adult I could do this. But chances are, someone else will have spotted the opportunity before then.
I guess I could do the lottery… 
What’s your dream that probably won’t happen?