Sub Prime loans are, in and of themselves, not bad.

I guess it would really depend on what your credit rating is, and WHY its bad but I would probably suggest working on this to begin with.

I have had good tenants and I have had really bad Tenants that make life miserable.

so i found a duplex but its in a bad neighborhood. from the looks of it i wouldn't have to do any work with them which is a plus. should i let the bad neighborhood stop me from making an offer? 

It's not a bad deal, I don't think I would do it.

You make your money when you buy, etc.If I were to buy a 3 br 2 bth single family in a desirable neighborhood, no repairs needed, traditional financing with a 30yr fixed rate mortgage, would i be making a bad investment if I purchased the property through a realtor?

You make your money when you buy, etc.If I were to buy a 3 br 2 bth single family in a desirable neighborhood, no repairs needed, traditional financing with a 30yr fixed rate mortgage, would i be making a bad investment if I purchased the property through a realtor?

Bad roofs, sketchy floor joists, it doesn't matter if the price is right.

They have just heard its bad or heard horror stories. 

You have to worry about things like guests trashing your space, noise to your neighbors that you can't control, getting bad reviews, etc.