How can I approach them and find out what the status is and what should my angle be?

It could be a lot easier to get 1 loan rather than 6 mortgages and you get the added benefit of having to pay expenses and management on only a single property rather than multiple spread across a wide area.

So far I've just tried going on Redfin and zooming out really wide and clicking on random counties haha.

You can check out the store, https://www.biggerpockets.com/store, which has books endorsed by BP that cover a wide range of topics. 

or should I look at this at a completely different angle?

I am like an analytical guru....can run the numbers 6 ways to Sunday and back with all the angles and options. 

If most people are flying to your destination, it's much harder to get 15-30 or more people together, and those larger homes stand less of a chance.While I've done a bit of research in Galveston, definitely not enough to answer your question.Another angle to consider if it's legal from a short-term rental and ordinance perspective, buy a home with a number of large bedrooms, and create exterior doors to each of them, put in a kitchenette with a microwave and mini-fridge, and rent them separately, in particular if most/all of them can have en-suite bathrooms. 

Im in the top 1% of agents nation wide.....and when I buy or sell in another market, I still hire a local agent. 

Just my 2cents By double wide you mean a mobile home?

A few of us are interested in buying land in New Orleans/Kenner, prefer utilities in order to install double wide manufactured homes.