Really great with kids, there's tons of toys and books. Also if you're musical, there's a piano and a bunch of stringed instruments you can play.
One of our favorite things was being able to walk to a variety of good restaurants just a couple of blocks away. Even in 90+ degree heat we didn't have to load the kids in the car.
As for the backyard, we were there during the height of summer heat/humidity, so we didn't spend any time there.