A semi-detached house is too expensive, about 1 million, and too big.
240m2 + basement costs for 240m2 + basement. Whether these are 2 horizontally or vertically stacked apartments does not initially affect the price. A semi-detached house becomes more expensive if you want 2 completely separate technical systems, but that does not have to be the case here. I am also not thinking of a classic mirrored semi-detached house, but one with 2 individual "halves" that can definitely overlap.
For example, the apartment for the parents almost entirely on the ground floor and only, for example, one room for visitors or nursing services on the upper floor. The main apartment with "only" dining room and kitchen on the ground floor and the living rooms upstairs.
By the way, for this size, I consider 800k completely unrealistic in Augsburg.
240m2 * 3500€/m2 is already 840k + basement 100k + additional construction costs.
Yes, it will end up at 1 million. One way or another.