But if all went well, we could hand it over to the council on a long term lease. An estate agent has told us we could get 2000 euro per month rent if we went private. The council pays 80% rent so that would easily cover the mortgage and i wouldn't be too bothered if we didn't actually make a profit from it.
All of my friends (who have no financial background!), suggest i should try at all costs to keep the house.
You're being overly optimistic with the financials here, so I think you need to sit down & work them out.
My initial thoughts:
As an investment this is cashflow negative. That means on top of the rent, every month you'll have to put your hand into your own pocket to come up with the cash to pay tax.
I've assumed your income is over 35,300 here, so the rental profit will be taxed at higher rate. Over 5 years, it'll cost you 17,000
That's using 3% interest rate, and 1600 per month rent, but only allowing for 600 per annum expenses to cover insurance, assuming you rent to council. (If you rent privately, the rent will be higher, but so will the expenses).
At the lower rate of tax it just barely breaks even, from a cashflow perspective. But your income would need to be under 24k for it all to be at the lower rate.
On paper it's a profitable investment, and the payments are increasing the mount of equity you have in the property. But you're basically being 'forced' to save money every month. Unless you can commit to putting in 300 per month of your own money this will tie you down.
Apart from the financials, I'd suggest you're better to make a clean break while you're both on good terms, rather than being forced to sell at a time that doesn't suit in the future.