Invest in Cashflow or Appreciating property?

[Suzanne Laird]

I've been debating this for so long and I just can't decide what's best. I live in Greater Vancouver, Canada.. Would it be best to invest in a non-appreciating duplex that cashflows well (in Saskatoon or Edmonton- compare to midwest for US folks) or a non-cashflowing detached home in the coastal region of Vancouver area (think Seattle!) where there is tons of appreciation but NO cashflow. We would have to supplement the rent for a few years, but these properties are million dollar homes with great value. I'm so torn. what would you do? We have a decent amount to put in for a down payment (200k) but would stay with the 20% downpayment if going with a cheaper property (400-600k). We want to maximize our money to go as far as possible. Help please!! thank you so much for any responses!!!