People do not enjoy the moving process, so I bet they would stay, but if you are that nervous about this then RE is not for you.

I am also leaning towards Sacramento being a better bet which also gives me freedom to rent or move somewhere else without losing the property at a potential loss. 

I provide capital to flippers not borrow it.. but these scammers for sure take money from newbies who don't understand there are no private loans as these guys pitch.for selling your turn key  best bet is to align with one of the west coast marketing companies.. they will charge between 3 and 10k per sale.. as long as your organization checks out ..  

Oh and if the wife finds out about the girlfriend all bets are off.....

Athens would be a good bet in my opinion if you decide to invest in North Alabama outside of Huntsville or Madison if you want a mix of cash flow and appreciation potential.   

For me, in these higher-priced areas, I would rather not take a risk on betting that those  already high property prices will continue to rise.

Also, your best bet on its future. 

@Zariyan Sachedina If this is going to be a rental down the line, quartz would probably be a safe bet.

I was not planning on living in it and therefore I bet I cant get the 3.5% loan.  

I'll bet that they're not selling the best properties in their portfolio!