Greg's place is lovely and well-designed, and nicely located within walking distance of many shops and cafes. That said, it is on a main avenue (Fremont), with the attendant noise from trucks and vehicles. I am a city person yet even I was woken up several times by random car alarms or passing fire trucks in the middle of the night. And as others have noted, the walls are paper thin, so I heard my neighbor's alarm clock at 5:35am.
As I said, the apartment itself is quite nice and spacious but If you come, use earplugs or a white noise machine.