I've been in this location probably ten times over the last year for a large renovation project. I've had nothing but good experiences. The owner or manager is usually there and is really pleasant & helpfull. I would definately reccomend this place, particularly if you can buy your paint & gear on an account which will save you some cash.
Location: great ( if downtown is your goal)
Service: very pleasant (with the exception of the one valet who took literally 30 minutes to find our car)
Room: small but adequate (I can now attest to other reviewers comments, watch your forehead when you sit on the toilet.)
Other guests: Picture drunken bellowing of Beatles tunes from next room alternating with very loud discussion of the movie "Underworld". Followed up by clearly audible porn screening....
Skip this one if you actually want to sleep.