Signs of this are poor lease quality, maybe M2M tenants, high expenses (unnecessary things like high trash bills, internet, cleaning, security).

Credit score can help you secure a great rate so make sure to get started on that if you aren't already.

For example, certain states like CA and MA have "claw-back" provisions, some states have withholding requirements, PA has some funky 1031 exchange laws, etc.Work with a rockstar QI (like @Dave Foster) and a real-estate-savvy tax professional to ensure you don't fall into any traps.

While I'm not entirely discouraged, I feel like I've invested significant resources (LLC, website, domain) without securing a deal that generates cash flow.Any advice or guidance would be greatly appreciated. 

Start with simple repairs, plan for vacancies, and ensure professional inspections. 

Aloha, In a market where the sale-to-list price is 97.9%, homes sold above list price is 18.7%, and homes with price drops is 51.4%, I’m exploring how to respectfully submit an offer with a 30% to 50% discount on the listing price.Beside from the following actions, are there any additional steps I can take to ensure my approach is considerate to both the seller and my agent?

Many of our clients have done this and secured much better terms....EricThis spreadsheet decision is based on what you can afford and when you expect interest rates to fall.

As a result, I am committed to ensuring that other investors and professionals do not experience similar issues in the future.

Do nothing...the tenant isn't renting that area and has no right to dictate how you use it as long as it poses no security/safety risk to them. 

Sometimes it’s the smartest move to gain liquidity and to secure your position with your remaining properties.