@Hemal Adani.Did you end up pulling the trigger? 

Therefore, transferring our jointly owned investment property into my SMLLC would not trigger a due-on-sale clause?

At the end of the day you're only going to be as successful as that team allows you to be so I would definitely advise doing a deep dive and  visiting, if possible, who you'd be investing with and where before pulling the trigger. 

(Class B built in 2003)Would there be a rate change between the recourse and non-recourse with a springing trigger?

I have a Freddie Mac mortgage, so if I make this transfer, would it trigger the due-on-sale clause, or would the mortgage company allow it as long as I am the sole owner of the LLC?

I am sure someone has worked out the best workflows, triggers, messaging etc....

I did not end up pulling the trigger on any of them for that reason.

In Phoenix, I might call up a friend who invests in mixed-use properties south of Roosevelt Row, and that friend might know a local title rep who’s been working with out-of-state buyers who like to pull the trigger fast.

I’ve always wanted to renovate my investment properties, but it’s so hard to pull the trigger.

But it is the lowest down payment option, and likely the lowest rate option as well. one tidbit - condos don't usually like the STR piece, so make sure to do your DD in whatever area you're looking to buy in before puling the trigger.