My friend unfortunately is going through a divorce and her mediation is happening soon. I'm a little out of the real estate learning and trying to get back into again. Is there a way to transfer the loan agreement to ...

Having LP equity involved pre-development isn't the type of compelling story that will garner that type of split.

Ultimately, it’s essential to consult with your lender to understand what’s best for your long-term goals and costs involved.

The Section 8 process involves more paperwork and effort upfront, but it can be a good long term strategy if you're looking for stability.

How do you know who does and doesn't know what risks are involved when they make an investment?

Multifamily can work although "no money down" on such properties usually involves a syndication which may be no money down (or low more likely) but given it's a partnership, isn't a 100% financed deal.Of course, no money down deals for flips still make sense, but that's a different matter entirely.

Are you guys still involved in it?

Real estate is transactional where people are involved so it won't be a black and white answer.The best to do is to find an agent that fits your needs and guide you through the process.

For an SBA hotel loan, the SBA may guarantee say 30% of the loan and a traditional bank takes the next 50%...total LTV/LTC of 80%...will vary by business but it's higher/better than the previous replies (otherwise, you would just get a traditional commercial loan without the SBA involved). 

As mentioned above get involved locally.