I stayed here with my husband for a month. The apartment is truly cozy, with cute furniture, a large comfy bed and plenty of storage space. It has everything you could need for a longterm stay: extra linens, kitchenware, etc. The windows look over a back court of some sort, which makes the space relatively quiet: only very loud noises carry over from the actual street. During the day you can hear children playing on a nearby playground, but that isn't an issue at night. For a few days, there was some construction work in the unit above us, with music blaring for hours, which was a little annoying. The apartment is on the first floor right above the basement with the trash containers, and we did find small cockroaches in the bathroom every once in a while, but otherwise the place was well-cleaned for our move-in. In terms of location: it is close to most things you'd want to see in SF and there are plenty of good grocery and general stores nearby, as well as shopping centers in Union Square. There's also a lot of very good food nearby, and a bus stop within less than a block of the building. I would also add that it never felt dangerous, even at night. However, Tenderloin is tough: there is a very large homeless population around the building, the streets smell of urine and vomit, and you have to look closely under your feet to avoid stepping in feces. Also expect to see people shooting up drugs, sometimes right at the entrance to the building. If you have a car, this probably isn't the best choice: parking is very limited, mostly paid, and SF (and especially Tenderloin) is notorious for car break-ins.