I came across an interesting article the other day from Money Sense by Romana King that listed the 6 best and worst places to buy rental property in Canada. I decided to summarize her tables in one place:
I was recently living in Vancouver and would agree that the real estate prices there are ridiculously expensive. It would be very difficult to succeed as a real estate investor in Vancouver, however it's an awesome city to live in. Charlottetown on the other hand would be a much easier place to become a real estate mogul, given that you like potatoes and Ann of Green Gables.

The 11 Best Tips For Buying Your First Investment Property: