In reply to Sl@te Head:
There's a motel in downtown Squamish, forget what It's called might just be Squamish motel, there's the Howe Sound Inn and Brew Pub although I don't know how much a room is but could quite easily find out for as I know a lot of people in Squamish. It's also the place most climbers will go to after a day out for a beer cos they make their own and it's awesome and their patio has a great view of the grand wall ! There's the Sea to sky hotel in Garbaldi it's a 30mon cycle or a 10min drive from downtown and the main climbing. Where are you planning on doing youre climbing? If its on the chief or in the grand wall forest you will still need to walk or cycle or drive out of downtown and 5-10mins down the highway. There also may be a motel or youth hostel in Valleycliffe.
Hope this helps.
Andy