Very good spot, looks like new, however I suspect that although you may get a lot of car for your money the fact it is a Cat D write off may affect future values. This is probably factored into that price.
I think it looks lovely in the photos. If you can satisfy yourself that it's been properly fixed and you're planning on keeping it, who cares if the resale value is less. As you say, it's reflected in the purchase price.