A guy who secretly loves his female 'friend', and may go out of his way to accommodate her (like moving her couch). Either the guy was shot-down early on and was placed in the friend-zone, or he never had the balls to ask her out and inadvertently placed himself in the friend zone.
John wasn't actually a real friend, he was just another orbital of yours. That's why he was being an ass to your boyfriend.
John is such an orbital. Look, he's moving a his hot friend's couch on his back!