Germany: high taxes, declining population, cold weather causing retirees to go south. I don’t like it as a long term real estate investment. Why not just go with upstate NY?
The NYT used to have regular articles about 2nd homes in Europe that would describe the mortgage and property tax situation at the end. I think you’d have to put about half down as a foreigner. The one time transaction costs and taxes were often very high.