great alternative way to look at it. thats sort of how i was leaning with my logic. like i would rather keep a good tenant for a long time and "lose" some market value but guarntee no vacancy. i figure i could write in a large penalty for cancellation too prior to term ends.

I understand that location is super nuanced, but before delving in on a micro scale I wanted to know what the big overall picture is in your Opinion!

I have 2 locations in mind to purchase my first investment property: 1. 

Renovations may have a major influence on the property's value in some locations while having less of an effect in others.Comparable Sales: To estimate the possible value gain from improvements, look for recent comparable sales (comps) in the neighborhood.

I could really use some guidance on how to approach this.To provide some context, the building is in a premium location, with easy access to lakes, restaurants, bars, grocery stores, and public transportation.

Need to be in a good location and have good management; otherwise, you will lose money. 

What  city/cities are the options located in?

Even if it seems financially attractive, factors like the property's location and condition will impact on the level of challenges and the frequency you will experience. 

This is not legal advice please consult with you attorney).Consider a step-by-step process increasing the pressure on the tenant with each step while accumulating documentation (which will be needed in Eviction Court):As per the prior comment, first contact the State Agency sponsoring/funding the Section 8 payments and document for them all the issues to see if a resolution can be reached.

Can we locate it with in driving distance of the new Intel plant ?