Welcome to the forum and sorry to hear the bad news.
I reckon the sun roof is the bit that'll be hard to track down. Red is very popular along with black, and DSG and leather are both common also, but I personally haven't seen many with a sunroof. With climate control i'm not sure there is a need for it, other than to let in light.
I went for a new car as it was 100% my spec and not abused for the first year or so of it's life, plus i couldn't save enough on a year old model to make it worthwhile.
Discounts on new cars are minimal from dealers at best, but push your luck, hold tight and try to play a few dealers off against each other.
Go for an import if you want to save a bit but i think it is harder to spec your car, but mine is a UK car so i'm no expert here.
I would also recommend you add in xenon lights for better illumination, 18 inch wheels are very popular, and an arm rest is nice.
I'd be surprised if you can't find something close to your exact spec second hand, but I doubt you'll save much.