But if you sit down at a restaurant the food you are served could be poisoned by a careless chef. 

You could learn marketable skills that can put a roof over your head and food on your table.

When I search there are some commercial NNN properties which are around or over $1MM with corporate guaranteed leases for atleast 10 years and goes up to 20 years (like Fast food Restaurant chains, Banks, medical offices etc).

Food for thought.

You'll need to check with your municipalitySome additional food for thought:Lot splits in my area take a lot of time, patience and moneyYou can finance the construction of an owner-occupied 2-4 units with an FHA loan for as little as 3.5% down but the requirements are kind of onerous. 

My background is in ecological design, which you can find out more about in my profile, but in short it means I design and help create abundant edible landscapes that not only grow healthy food, but also enhance the ecology by purifying water, providing habitat for wildlife, and actually sequestering Carbon dioxide from the atmosphere in soil and plants.I have much gratitude to the creators of this space for creating something that is truly inspiring and brings people together.  

One year we discovered that mice were in our "private" closet, eating boxed and bagged food, while nesting in some towels. 

Drinks & food on me 👍🏾

It's been a lifelong goal of mine to have land to keep as many cars on as I want, to build a homestead, grow food (ie permaculture), etc.

But then you need to find food management which may be the more difficult thing to find of the two.I have not had as difficult of a time finding properties as you have described but that is probably because of the market I am in, the people I have partnered with, and the connections I have made over the past 4 years or so.I would suggest finding a mentor, bringing value, and then doing what your shows you to do.Good Luck.