What red flags should I look for that would lead me to see a property that has been sitting as an “unwise” investment

If they are not, that's a red flag.     

Just some food for thought on your hunt for the Red October.Are you looking hire an ttorney To teach you creative strategies And recommend Creative strategies  to you, or are you looking for a chain dog to implement your creative strategies?

The more I’m thinking about this the more red flags I’m thinking of.

Definitely get in contact with a lender who has a deep understanding of VA loans. 

My advice: target towns with average prices that fit your budget and then deep-dive into your research from there.Good luck with your search!

Over the last several years casinos have went up, Ford Field (Lions) and Comerica Park (Tigers) were erected and people who loved the city began brainstorming how to revive it.More recently, Little Ceaser's Arena (new home of Pistons and Red Wings) construction started and is due to open Sept this year.

A large, deep and qualified network of "intermediaries" to provide deal flow OR the ability to spend $5 -10K PER MONTH on obtaining that deal flow. 5.

Moving in and out of the current home could cause red flags for the lender.

Doing a deep dive into support tickets, around 40% were wifi related.