Something else that I have been seeing, Sellers dont want anyone to view the property unless they accepted an offer.

It will save you a ton of money upfront and you'll gain the experience to upgrade to larger deals.  

these can produce good returns but best chance for success is for those that have experience in this area (I am a partner on an effort adding 8 ADUs, but it is not performing to the initial underwriting (underperforming) and it is an experienced team).good luck I get it, but not everyone has the opportunity of scale and building multiple units.

Do you have any experience with it?

I've had a positive experience.

When filing the LLC return, it is important to ensure that these liabilities are accurately reflected on the balance sheet.However, it's essential to note that distributing the refinance proceeds among LLC members could potentially be viewed as a taxable event if there is no intent to repay these amounts to the LLC.

But I would remain open to long-term rental as an option as this seems like a more stable option in terms of income, again this may be my inexperience talking.However, I have always  been somewhat risk averse and investing in real estate is always a big venture, in my opinion/experience, in terms of capital.

I haven't worked with any realtor/investor that has the same experience and skillset that he does for STR's to be honest with you.

Do you really think you have the skills and experience to handle a D (at best) neighborhood?

A renter for a stand alone rowhome is usually a different profile from a large apartment complex renter in my experience.