Best for short-term use, as rates are higher.Given your strong W2 income, excellent credit, and LLC structure, any of these should be feasible.

I have seen a lot of strong market appreciation as well so the ability to buy and renovate for a good ARV still remains. 

And I would think that future booked rentals is a strong indicator of what your intent is at present. 

We built out a Diligence tool that grabs data from multiple sources ( Paid and non-paid), aggregated together to give us data on multiple properties in that matter of minutes. 

Tampa offers strong cash flow, a high rental demand, and affordable housing, plus no state income tax.

It's competitively priced and the section 8 rent - if you choose to go that route - is very strong.) 

Strong mid-long term rentals, with a reasonable flip option?

In the Reno, NV multifamily market a 5%-6% cap rate is good because of the strong appreciation, job growth, and very limited future inventory.

However, given the current home prices and mortgage rates in areas like Natick and Framingham, I’m uncertain if rental income will cover costs like PMI or if these areas offer good potential for appreciation and equity growth.Any suggestions on areas that meet the 1% rent rule or have strong appreciation potential would be greatly appreciated!

While selling your properties could provide the liquidity you need, you definitely want to consider the tax implications, especially if any of the properties were held for less than 12 months, as those will be taxed at a higher short-term capital gains rate.However, if selling isn’t your only option, I would strongly recommend looking into a cash-out refinance.