A good friend of a good friend. Even if you tend to hang out in the same circles often, this person would only qualify as more of an acquaintance.
Not someone you would desire to hang out with alone. Either because you only talk to the person large group settings and never really directly bonded, or because it's someone with whom you share nothing in common (other than a similar friend) and it would be awkward and uncomfortable to spend time alone together.
Most often it is a significant other's best friend.