I've lived in Cincinnati for the majority of my life but always a little North of the city.

Can't have any major surprises with those numbers.Days on market is another thing to check.I'm not much help with your financing issue.

The biggest problem getting comps is that the property is right by Blue Ridge Blvd which is a major thoroughfare and it appears to be a dividing line between a nicer area to the southeast with homes selling for $90k-$100k+ and a lower-priced area (where your property is) to the northwest with homes ranging from $50k-$80k.

This is a fix and flip with major renovations required to take full advantage of this property.  

House needs major rehabilitation work." 

I know the investors (LP's) will be getting the majority of the cash flow and the back end profits but is this typical to charge an upfront fee at closing for all the work involved? 

We typically focus on making sure major systems are up, and then begin unit upgrades on a rolling basis.And thanks for the suggestion guys- I have emailed Sean.

A very wealthy great town with a great school system and no major crime. 

Yes, I've had bad experiences but the overwhelming majority of the time they work out well.

The majority landlord tenant relationships don't end this way, but if does, you're prepared.Let your tenants know how you handle emergencies.