Your in laws are proposing you and your husband enter into terrible investments because it's what would be most convenient for them and their family (like the member who lives rent-free in the duplex).

If they need financial assistance and you want to help, fine. Cut them a check.

But buying houses with them is a really bad idea.