@Rosalyn ScofieldI always suggest that investors and homeowners avoid home warranties.

My main concern is how to avoid activating the due-on-sale clause when transferring the deed.

The construction aspect of it, which many banks have swayed away from is the main piece you're going to be looking to find. 

And to avoid pitfalls. 

My goal is to achieve financial freedom by age 36 and to understand various aspects such as investing education, strategies, business planning, properties, marketing, and exit strategies.

What I am getting at, is if it is worrisome, or avoidable, as even a good deal(see scenario above) will raise DTI In that case, yes DSCR loans closed in an LLC will not report to personal credit and won't affect your DTI. 

Are there any red flags or common mistakes investors should avoid when reaching out?

Unless the price is well adjusted I would avoid structural issues all together.

EDUCATE YOURSELF - yes, it will take time, but will lead to a selection that better meets your expectations & avoids potentially costly surprises!

By doing this, you’ll avoid any surprises down the road and ensure the deal still makes sense for you financially.