Now the area feels very safe, and very hip hipster bars are popping up along 14th street, heading north from Columbia Heights proper.

Yes, you need this information to properly screen them. 

Before you send them out make sure the property mgr sends a notice with the proper lead time so the tenant has no choice but to let them in.

Most of your problem looks like the posts were not properly set in the ground. 

But my main concern is understanding The HUD Home Store, how to bid properly, understand what is expected of me (besides paying for it) If I can get PreQualified here in Washington State to purchase a home lets say in Missiori for instance or Montana.

The key in commercial is to know the pluses and minuses of each asset class and to get the proper yield based on work involved and risk.

Does anyone have a trick to being able to properly market a property that is not yet fully rehabbed?

If there's a tenant in there, you have to be careful with proper noticing before terminating the tenancy if you want to avoid delays.  

It seems like it could have amazing value if fixed properly and is in a nice area where other homes are currently being fixed and built.Any input or guidance on how I can turn this discovery into something meaningful I would be glad to hear it.

Having to deal with that potential issue would motivate me to just make it all as new and proper as possible.