Good evening,
To reasonably accommodate your wishes for the house, about 150 sqm are needed. With clever planning, all rooms on the ground floor and upper floor would fit in a reasonable size. I would place the study in the attic, which should sensibly be bought "ready for conversion." Since you plan to have children only in 5-8 years, your wife can use a children’s room in the waiting loop of the upper floor as a study until then. You would therefore have enough time to fully develop the attic ;-)
Regarding the price information - TEUR 350 with basement - you can safely forget about that figure. For the 150 sqm plus conversion-ready attic, I am already at TEUR 245 on a slab foundation and without painting work, flooring, or additional construction costs; not to mention the basement (let alone finished as living space), garage, or land.
I can only guess who gave you these bait offers; they are not realistic values. Also, the plots in the rural surroundings of Cologne - where, by the way - are far from cheap nowadays.
Rhenish greetings
Building expert, on the go