I'm not sure what to do in this situation, whether to drop the deal and lose my earnest money or try to find another lender.

Lots of different options here.There is always a private money option - either a one that you find through referrals (like Roman Labos mentioned above) or you have a friend or family member that will finance the deal.

The best case deal for us would be to find an investor who is willing to buy the land and do a 10-year (or longer) rent-to-own agreement with us that includes them getting proceeds from the campground and event center and making a great profit over time. 

Hey @Kevin DuongAmenities and Needs:-Location i.e. close to amenities, parks, business, restaurants, bars.Similar features they would find in comparable rentals. 

Problem is that European countries like Portugal and Spain are following (or preceding) the negative STR regulations that you find in more and more places in North America.

You can find more info the group studying the issue here.

I cleared $10k on my first one.We ended up clearing $30k on the second one.The last flip was very stressful for my wife and she wants to keep our finances (HELOC) out of the next one.I am going to look to find a financing partner to cover the carrying costs of the next flip.On a $400k house (average for my area), the total investment would be $85-$95k and would be paid directly to the lender and subs/suppliers, not to me.I can bring the lender, as I have a good rep with the one I use.I will do all the rest.

How do I find new expanding and promising areas?

How do I find new expanding and promising areas?

Finish reading that book then share your findings with them.