From Sydney to Singapore, residential property investors are looking to up-and-coming urban hotspots for strong returns.