stoop faced

To be extremely drunk or intoxicated, to the point of having to leave a party/club to sit on a nearby stoop to recover.

Damn, that guy sitting on that stoop is definitely stoop faced.