Sheldon's place is exactly as described/pictured; what you see is what you get. Located right on "The Ave", it's in the thick of UW's backyard, surrounded by restaurants, coffee shops and various retail stores. The link (light rail) is a 10-15m walk through the UW campus, but it's not too bad as long as you're not hauling a ton of luggage.
Fair warning about the decibel level; you'll be staying in a college neighborhood, and while it isn't noisy during the week, it can get rowdy on the weekends, so keep that in mind. Folks who've lived in the city should know exactly what to expect. Overall, it's a great little spot and I'd recommend it!