Balancing these responsibilities with the demands of this project, including finding suitable contractors, organizing communications, and ensuring timely responses, has proven to be quite demanding.In light of these circumstances, I am seeking insights on potential additions to my real estate team that could streamline this process and enhance its efficiency.

I would use the low appraisal as a negotiating opportunity and try to get them down on the price a little, then close the deal. 

Our close friends here have a home worth approximately $350,000 (in Panama, they adopted US currency as their currency, so all values are USD/Panamanian).

Non-governmental liens don't always go away like city liens, IRS liens, other federal liens.Title company or title attorney can help you research liens, or find someone to teach you how to do it.You can buy from the owner perhaps before the sale....you let title company or closing agent pay off taxes at closing....you don't do that yourself before you close.   

I want the STR to be close to the main national parks and still on the fence weather it needs to be rural or closer a city.

I’m afraid whomever told you this is far too light with their budgetary numbers.

I'm not sure where you can make 10% gross yields in Miami or any gross yield close to that unless you go for short-term rentals but I'll leave people who know that market to comment on that part.I love investing in Spain, especially in the Costa del Sol, which I call the Florida of Europe although most call it the California of Europe, alongside Portugal's Algarve.

All new LED lights and lite fixtures.

I'm closing shortly on a $2M ground up new construction co-living concept (Class A), where the tenant base will be all on MTR leases from 30 days to 180 days+, targeting the demographics that you mentioned above. 

I agree partnering is something I won’t take lightly, I really would want to collaborate with folks that are on the same page and have similar goals that align with my own