A mansion in Co Limerick with a private lake has sold for nearly €2m less than its asking price three years ago.