Re "investment": it costs you c 15% on top of the price to buy, then if you want to sell almost the same 15% allowing for estate agent commission and taxes, so you would need to see an increase of between 25 % 30% to break even, let alone turn a profit. This does not account for any work needed or done to make it "yours", furnishing, removals...and you will have IBI, insurance, possibly community fees and regular painting.
I am not saying it is necessarily a bad idea for you, just don't kid yourself you are doing it to make or save money.
If you go on a holiday you spend £££whatever and hopefully enjoy it. One could look at a holiday home in the same way, an expense rather than an investment.