I have given up on finding an apartment in San Francisco as we tried 5 times and all 5 were unavailable when we needed them :(
So the next best thing is a hotel with 2 adjoining rooms. I thought this would be prohibitively expensive but in the end it will cost roughly the same as the apartment would have and the location is fantastic - Union Square!
I have no idea if we are crazy being so close to a tram line but it will be handy