I would not approach it from the standpoint of I want to build container homes and then look for a site, I would have a site and think about what the best use of it would be and if it happened to be container homes then go for it.As John mentioned above appealing to the masses is the route to success here IMHO

$2.5B New Center by Henry Ford Health, Pistons owner and Michigan State Universityhttps://www.clickondetroit.com/news/local/2023/02/08/incredible-investment-in-our-city-25b-detroit-neighborhood-redevelopment-to-begin-in-2024/$1.5B Investment, 12,000 temp jobs, 6,000 New Jobs: District Detroit Developmenthttps://www.detroitnews.com/story/business/2022/11/15/district-detroit-1-5b-development-to-include-housing-retail-hotels/69649853007/$1.4B Total as Hotel Added to Hudson Sitehttps://www.detroitnews.com/story/business/2023/11/02/hudsons-site-hotel-plans-move-ahead-as-city-issues-permit/71426631007/$439M Gilbert Foundation investment in Detroithttps://www.henryfordmsu.org/news/september-2023/gilbert-family-foundation-announces-nick-gilbert-neurofibromatosis-research-institute$400M Investment, 517 New Jobs: Norway’s Nel Hydronhttps://businessfacilities.com/nel-hydrogen-will-build-400m-gigafactory-in-southeast-michigan#:~:text=In%20Southeast%20Michigan-,Nel%20Hydrogen%20Will%20Build%20%24400M%20Gigafactory%20In%20Southeast%20Michigan,green%20hydrogen%20using%20electrolyzer%20technology.$300M Huntington Place Renovations & New Detroit Hotel https://www.crainsdetroit.com/real-estate/huntington-place-renovations-new-hotel-deal-reached$200M Chase Investment in Detroithttps://www.axios.com/2023/09/28/detroit-rebound-jp-morgan-investment$44M Investment, 237 New Jobs: Bollinger Motorshttps://michauto.org/bollinger-motors-plans-44m-metro-detroit-investment/$21.5M Investment for Detroit west side Dexter Neighborhoodhttps://www.clickondetroit.com/news/local/2023/11/01/neighborhood-on-detroits-west-side-receives-more-than-215m-in-investments/$20.6M Investment, 186 New Jobs: BorgWarnerhttps://www.crainsdetroit.com/auto-suppliers/borgwarner-invest-206-million-create-186-jobs$11M, 200 New Jobs: Volkswagen Scout Brand Investment in Detroithttps://www.teslarati.com/volkswagen-scout-11-million-detroit-investment/New Detroit Developments to Be Excited Abouthttps://www.metrotimes.com/detroit/15-new-detroit-developments-to-be-excited-about-photos/Slideshow/32734721/327353923 International Companies Choose Detroithttps://www.detroitregionalpartnership.com/international-investment-comes-to-detroit-region/6 New Residential Developments in Detroithttps://detroitisit.com/6-new-residential-developments-in-detroit-to-know-about/Contact us with any questions you have.

Does anyone know of a reliable site or resource to check zoning laws for Airbnbs or STRs in general?

Think of it like a dating site in that its purpose is to just bring the interested parties together, but if love is to bloom, it will take some work.

It provides links to each county office's sites for when you're doing research. 

Applicant is ok to show me in person his account information on his laptop, but doesn’t want to put his user name and passwords to those sites into RentRedi application.

It is usually a tenant moving to a new area, because of a new job and they just want to be done with their trailer.I have had the disgruntled situation come up when I stopped using the on-site maintenance man and made him pay full lot rent like every one else.  

According to people who study the stock market, there is a common theme, "buy the rumor, sell the news."

I would make a site visit to where they live now and see how they treat the current property.

HUD publishes the Median Fair Market Rent on their web site for the entire country.