I am looking for a CPA that knows the STR Loophole and can help us with offsetting our W2 income and is taking new clients.

Also, curious if there are any other workarounds or loopholes that can get you around this legally.Another question is, is it worth getting an STR property in areas that you know will do well but have these type of regulations in place?

That is a massive loophole in the system, take advantage of it

Telling people to avoid their responsibilities by looking for a loophole in the lease document?"

There are a few areas of Japan real estate (most stable tenants in the world, insanely low interest rates, steady cash flow, big time tax loopholes, very cheap and reliable property management) which if taken advantage of properly can yield you big returns, but I don't think abandoned houses are one of them.

I went down to zoning, and the guy pointed out a rare loophole and I was able to get my use permit to use it as an elder care facility finally!

I agree with @Stephanie - stop wasting time with taking advantage of this loophole... make you payments and just refi at these ridiculous low rates while you can.

Others say the know loopholes, or the "right way" to do it.

This could be short term rentals via the "short term rental loophole" or real estate professional status for commercial deals 

Keeping up with and adhering to these regulations can be time-consuming and may require legal assistance.Amidst these challenges, there is a glimmer of optimism for investors - the short-term rental tax loophole.