I like the Philadelphia area for flips . you want to be in areas where there's jobs as well as rentals needed in high demand 

Completed high value renovations to boost market value - new roof, etc., What was the outcome?

This seems high.

Yes, Kai Lai the buyers agent at New Western was incredible to work with, highly recommend.

Now you can afford furniture in spite of the high mortgage rates.

Future plans to make cosmetic upgrades over time as units become vacant to maximize future cash flows by increasing rents and finishing apartments to a high level that will encourage long term tenancy.

I highly suggest you check it out.

Regarding your situation, the appreciation strategy for real estate investment is compelling, especially in a high-demand market like Vancouver.

A highly skilled Guatemalan (my preference) or Mexican laborer will cost you $150 per day.  

I considered SFH where I'd rent out all the rooms and keep one to myself, but this seems risky since I'll realistically be away for months at a time and couldn't manage the unit/other tenants.Then I came across some listings that appear to be hotel rooms for sale, with basically the facilities I need (a bed, toilet, kitchen), a price point I can handle (270-500k$, I'd do 20% down), and fairly high HOAs (~1500$/m?).