I am not a lender but I do not think you will be able to get any financing based on cashflow let alone STR cashflow. 

It will cover your mortgage if you have one and basic liability but not much more than that.

Through a construction and purchase loan with a hard money lender.

He is willing to hold some mortgage. 

Did you work with any real estate professionals (agents, lenders, etc.) that you'd recommend to others?

See my other post:  https://www.biggerpockets.com/forums/517/topics/1196510-any-creative-lenders-for-6-unit-high-dscr-property-fast-close-needed?

Check in with @Joseph Chiofalo for what is referred to as a 'Foreign national' mortgage. 

I'm a military veteran that came to San Antonio in 2018 as part of a military PCS and loved it so much, we decided to make it our permanent home.I'm also a fellow real estate investor and a mortgage lender, so I'd be happy to be resource for you as you're preparing to make your move here. 

For conventional financing, condos need to be 'warrantable' if the condo or HOA doesn't meet those guidelines it is 'non-warrantable' and there are alternative or Non-QM (non conventional) lenders that offer financing.

Also, maybe check in with @Joseph Chiofalo for some very useful lender specific loan programs.