The best place by far is airbnb. Also, if you have the time/desire, I highly recommend you learn how to game Priceline. Start here (pay very close attention to #9. What is a free re-bid?) and consult with Priceline maps like betterbidding.com and biddingfortravel.com. I highly recommend bidding weeks before, hotels get more expensive on Priceline as you get closer to your stay. It’ll take an hour or so to get up to speed, but I’ve stayed in hundreds of super nice hotels doing this.
Also, if you’re recording for an extended period of time, check craigslist.com for sublets in the Mission.