Nasty Turnkey looking to purchase then fix

[Kwadwo Banahene]

I found a duplex with tenants currently living in it which needs a lot of work. One unit is ok and looks to have minor repairs needed to be done. The other unit is downright disgusting with carpet which was peed on by the pet, holes in the wood panel walls, mildew and mold all around the bathroom, and a general bad vibe from just walking around the place. I was looking to purchase this property with a conventional loan, then rehab it. I feel like I am way too excited to call myself a real estate investor to think clearly about this deal. Do you think this is a good purchase or no?