The consensus you are encountering is there for a reason.

The older I get the less tolerant I become with tenant's pets given all the challenges I encounter.  

A C of O details what the legally permissable use is of the property.As an appraiser, I have encountered properties that were being used in a manner contrary to their C of O.

They cover almost all topics, situations, and investment styles you encounter in real estate investing.

Have 4 tenants living side-to-side, do you encounter more tenant-tenant issues to handle?

Has anyone encountered this and can help me with some remedies.

Rarely do I encounter hidden items of a large magnitude to justify going back to re-negotiate.If you are playing the numbers game on the MLS, then you are forced to make lots of offers and leave yourself some room for negotiating on counter offers.

They have no idea what the process is or how many pitfalls they may encounter, which is why a professional Realtor will always have business.

I also had my own Internet business, which brought in consistent income, so it did not take long for me to save for the down-payment on the next property.However, the problem I encountered was that lenders would not allow me to use business funds (non-W2 income) as down-payment.

I know how neighborhoods are assessed is relative but in general, if that is your strategy you are targeting the lowest yields in every deal you encounter.