The place was perfect and was exactly what we needed for a little escape.

Location: Santana Row is an awesome little community with plenty of restaurants, shopping, and beautiful landscaping. The unit was perched above a nice little cafe that we visited each morning.
Noise: Most of the shops shut down by 9:00 so we didn't have any noise issues. We were surprised how well insulated the condo was as we did not hear our neighbors from the unit even though you could hear dogs and kids in the hall way. You get an occasional motorcycle that you can hear as they rev engine (clearly over compensating).
Beds: There were two comfortable beds we pretty much stayed downstairs as my wife was 9 months pregnant and the flight upstairs was a little aggressive. The staircase would be the only thing I would be cautious of if you had small kids or an elderly couple.
Other: The Kitchen was stocked with all the basics you would need to cook simple meals. The couch and chairs in the living room were functional and comfortable. It was great to have Roku on the TV.
Overall we would definitely be back!