If I buy a second hand house and I am not a first time buyer for say €400,000 I will pay S.D. at 7.5% of the full amount, right??
Is there anything I can offset against this to reduce the S.D.??
No assuming that you are an owner occupier. If you were an investor then you could offset the SD on purchase when calculating your CGT liability on any eventual resale.