Expression used to imply a person with low intelligence or feeble minded; can also be used to describe a foolish act. Generally used to provide a negative response to a harebrained question.
"You know that woman you were chatting up last night? The one wearing chunky boots, a pinstripe suit and with the crew-cut? You'll have no lucky with her mate, she's on the bus to Hebden Bridge"