Is it like long term hold and wait approach ?

I've never stayed in a hotel or short term rental where I couldn't control the temperature.

Short-term is to move into the space by January 2022 (as my lease ends then) and live there for at least 1-2 years.If I get the duplex, I would house-hack until it was my time to move somewhere else and rent both spaces within the duplex.

Tons of recreation as well so could be good for a short term rental or medium rental

It's a means of producing income, not long-term wealth. 

Vanilla) 0% Down and 0% interest, 20 year term, Sellers's Asking Price- 8.314 Million-This would be ideal, the monthly Finance payment to Seller would be 23,094.44 and the Rents will cover that and leave another 10k in cashflow.

This will be a short amount of information in regards to me using the VA Home loan benefits.

I am under contract on a property.

The only way to have leads pouring in is to rank #1-3 and preferably #1 across tons of varied search terms. 

I'm not a lawyer, and I'm not in your state, so take this with a grain of salt but-If "accepted an offer" means that you signed a legally binding contract that doesn't provide you with an out, then the short answer is no, you cannot legally cancel the sale.