As a player Housham notably played as a midfielder from 1993 to 2007, notably in Football League for Scunthorpe United where he was part of the club that triumphed in the 1998/1999 Division Three Play-offs. He moved on to before Barrow before finishing his career with Brigg Town, who he later managed.
Housham was the product of the Scunthorpe United and was promoted to the first team squad in 1993. While at United he was part of the side that earned promotion to the Second Division via the playoffs. The majority of his football at Glanford Park was under the stewardship of Brian Laws. It was Laws who loaned him out initially to Barrow during the 1999–2000 season. He later moved to the club permanently before joining Brigg Town a year later.
He was appointed Player/Manager of Brigg in 2007, and shortly afterwards retired from playing to tackle his new position in a non playing capacity. In May 2011 he quit his post at Brigg and took up the role as youth team manager at his hometown club Gainsborough Trinity where he briefly worked under manager Brian Little until he replaced Little as caretaker manager in August 2011. Following five wins out of five in caretaker charge at The Northolme Housham was appointed as full time manager on 12 September 2011.
In his first season in charge Housham led Trinity to the Conference North play-offs after finishing 4th. They defeated F.C. Halifax Town over two legs before, despite being favourates they were beaten 1-0 by Nuneaton Town in the final. During the 2012–13 season Trinity reached the semi-final of the FA Trophy having defeated Barrow in the quarter finals. The Blues were drawn against Conference National promotion contenders Wrexham and despite drawing level they were beaten 3-1 away in the first leg. The following week Trinity came from behind to win 2-1 in the second leg, but despite applying a lot of pressure in the final stages they were unable to get a third goal to take the tie into extra time. Wrexham went on to play Grimsby Town in the final, with Trinity missing out on their first ever chance to play at Wembley Stadium.