You can typically secure shorter term 3-5 year fixed rate permanent financing for this with lower leverage, or if you're feeling riskier you could go with a higher leverage, more expensive floating rate bridge loan.

By the end of the rotation, I’ll have some say in where my company places me permanently, and I’d like to make an informed decision that aligns with my real estate goals.

I can convert the construction loan to permanent and have  a national tenant with a long term lease  with a high cap rate and hold for a better time to sell.

He needs referrals to mortgage brokers for construction to permanent lending in NY.

This can become a risk for both you and your ability to sell.As for things to talk to HOA about, beyond the permanent exterior colors/finishes, I would also ask about things like dumpsters and potentially port-o-let's that may be needed during rehab.  

Must be on permanent foundation 3.

It'll be hard to permanently live in a trailer/RV/van discreetly in any of these neighborhoods. 

Not enough time has elapsed to tell if the glue will be a permanent fix. 

One thing you might consider if it works for you is buying a hack and living in one of the bedrooms or use that as your permanent address for a year, until you get it up and running and then do it again...and again...until you tap out on time to manage. 

If you've got a fat stack of cash to work with, you can make all-cash offers on "as-is" properties with a fast closing, no contingencies, and get properties for 75% of market value that way.