Things to consider are pretty simple, if you can find a property jump on it, there is extremely little inventory and it is highly competitive with the majority homes on the market selling over ask in very few DOM.

(***Note: Emerald is EXTREMELY hard drying paint.

That would be extremely unusual. 

This actually makes your rental cash flow negative  Hi Bill, apologies in advance of this question as I am extremely new to all of this.

Will there be extremely good appreciation in the next few years do you think?

While certainly not as extreme as the examples in the article you shared, I've seen condo owners in many states hit with special assessments. 

We're hoping to bridge a large knowledge gap through various resources and I'm hoping this forum will share it's wealth of knowledge.Lastly, as with any post.. if anyone has any great Attorney or Realtor or any other party that should be involved a referral would be extremely helpful and greatly appreciated.Thanks in advance for you time.

They also were extremely rude and threatening to me during the inspection process.  

The city has definitely seen a rebirth in the last 10 to 20 years and the entry level is extremely low, that being said, you really have to develop a good team if you were going to be out of state.

I am looking in to a SFR brand new construction that offers live and work usage.