The vehicle is over 6000 pounds GVWR and will be used nearly entirely for business (going to current rental and searching for new properties to acquire)."

I don't have a good understanding of your desires or what you are seeking.  

Doesn’t mean you can’t find a good deal, but from our quick search while we were there in May 2022, none of the places came close to meeting our criteria

The listings @Joel Oh showed weren't in the first 50 listings for my search.

Phase I of the development was in the more desirable city + Zip. 

You can also find real estate investing groups through meetup.com, Facebook, or a Google search.

My only concern is searching for the rent to value "1% rule". 

That also makes that scenario less desirable.  

Start by going to www.narpm.org to search their directory of managers.

I'd say just start your search with all 2-4 unit properties, and when you find one where the numbers make sense and it checks your other boxes (somewhere you actually want to live and house hack), then it probably makes sense.