Here are a few ideas that might help you navigate this situation:Explore Financing Options: While you've mentioned not being keen on a second mortgage, there might be other financing options available.

Disclaimer - I am not an CPA or attorney but I became financially free doing this for myself after 10 years working as a w2 engineer :( and I am sick and tired of seeing highly educated and hard working professionals getting stuck in the rat race because we deserve financial freedom and the option to do more with it.If you are able to implement a real estate professional status tax strategy (REP) you can use passive losses from syndication deals to lower your ordinary W2 income.

I would really appreciate any feedback on options that may work in this type of arrangement. 

He has a ton of units in and around Worcester and in similar areas and is licensed and able to help find off-market and on-market options where you want to look.

This is not intended to be a discussion about the options for investment, rather how to conduct real estate settlements in non fiat currency.It is (or should be) evident by now that the status of the USD as the world's reserve currency (or at least our exorbitant privilege) will continue to be marginalized in the coming years (and decades) and that investors are factoring in elevated risks of currency inflation and debasement into and onto their portfolios. 

You will then have a few options with that rent money....you can put it into principal or you can start saving it to purchase yet another property.

There are third-party admin people that can help you set up and administer your solo 401k for a relatively inexpensive fee it's about $300 a year I currently use one company to do the same for my self-directed Roth IRA.I'm looking to go with the 401 option because I can do a 100% contribution up to $20,500 now.that's just a little over my net in one month on my rentals.

If you are interested in a market like KC there are some good options for you here.

Richmond is a wonderful place for real estate investing, with its expanding economy, variety of neighborhoods, and affordable property prices compared to bigger cities.If you want to further your real estate investment journey in Richmond, it's important to stay informed about market trends, connect with fellow investors, analyze properties thoroughly, consider various financing options, diversify your portfolio, manage your properties effectively, and stay well-informed about real estate investment strategies.

Will definitely explore the DSCR options.