Turn around let down
A girl who looks really hot from the backside, but as soon as she turns around, you see that she's old, not attractive, ugly, etc....
That girl over there, I was checking her out until I saw the front. She was a turn around let down.