Just as pictured, lovely place! About a 5 minute drive from the airport, and a 25 minute drive to downtown, Chinatown and the pier. The host was so pleasant and even though we had a delay and ended up only arriving to the place at 1 in the morning, he still came right away, showed us around and gave us recommendations on what's in the area.
The neighborhood felt safe.
There was noise from the airplanes but it didn't bother us. (Something to consider though if you are a light sleeper)