If it's on the MLS, investors have direct access to it via the listing agent or their own agent, so why would be able to buy it cheap and the resell it into the same market that it's already sitting for sale on?

These pros often have direct access to property owners and can recommend your services whenever opportunities pop up.So, cozy up to these professionals.

However, it's always a good idea to address any potential issues upfront to avoid complications during the sales process.In short, if your property is currently insured and meets all building codes, replacing the secondary roof may not be necessary.

With my current circumstances, I want to use my VA home loan to house hack and become more savvy with the opportunity as a first time homebuyer.

Looking for networking and knowledge sharing opportunities.

As long as you can take title to it within 180 days from when you close the sale of your old property.Or you could do a Reverse Construction exchange where the QI takes title to the lot (before you do) and then the builder builds on it. 

While I played there around the Stadium I always felt could be a growth opportunity and was curious if this would still be the case?

I hope you'll rethink your lease term to provide you with more stable/predictable cash flow as well as the opportunity to reevaluate pricing annually.  

Is this shift here to stay, or is it a window of opportunity? 

Take a closer look at Cleveland and Columbus for excellent investment opportunities.