used to describe someone who is totally the opposite of any one desirable trait, ie. someone who is very uncool, very ugly, very stupid etc.
generally used by those who are well-endowed with the particular trait they refer to, ie. supercool, beautiful, fit etc.
"oh lordy, look what tracey has done to her hair!"
"aye, she's such a fucking non"