In this case, with both the LL and the doughnut chompers being essentially non-responsive, tenants need to document the situation and send certified NOTICE to LL, the Chief of Police, and, if necessary, CC the local news media.Document the situation with letters, photos, and multiple written tenant statements.

I went by to take some additional photos and get some repair measurements and found that the back door was kicked in and house was ransacked.I called the listing agent but she didn't seem to interested in doing anything about it.What does the law say about this?

The listing will always be high but eventually the lenders will come down and in many cases you can get them to 85% and even lower with a good counter BPO (get rehab estimates and good photos to supplement your counter offer)

Here is the catch...if you find any sort of single family detached within your contract period you owe them a commission (the one that you signed for a SFD, not commercial).Also, what you could do is instead of write SFD (which is broad), write something like "SFD in Anycity".

The location is good and the apartments are easy to rent in my other building, next door.Another common thing that I keep hearing is that any of the serious buyers are tied up in other projects and I'm mostly getting the first time flippers looking to catch the wave of a good market.

I found out 3 days ago and I am obsessed with catching up to the market knowledgewise.

Screwing people will catch up to you. 

Does anyone have a solid connection to a photographer in Cincinnati who can take professional level photos of a rental and spruce them up in Photoshop?  

If you have 20 properties and you catch a bad run where 5 or more go vacant, your leverage will dictate how much you are floating for a period of time.  

In any case your own agent and/or the title company should catch this issue and know the law whether or not your wife will be required to sign because if your state requires it for property owned before marriage, it will not be transferrable without her signature.