We just stayed at this gorgeous property, and would highly recommend it. The photos in the listing don't do it justice.
To have 7 people stay in the place might be a little tight, but it's doable. The 2nd bedroom has a set of twin beds with trundles beneath, but but the trundles deployed, you've pretty much used up all the floor space. Like I said, it's doable. We are a family of 5. We were in the master, 2 sons (6'2" and 6'4") were in the 2nd bedroom, and the daughter slept on the very comfortable chaise in the living room. It worked out perfectly.
The views from the apartment are breathtaking.... nothing less. We were able to watch the America's Cup boats flying across the bay from afar. It's a short ride down to where the event is headquartered, if you want to get a closer look. In fact, it's a short walk or ride to most of what the city has to offer.
Parking is also a breeze, since you can park immediately beneath the building. The owners have everything very well organized, and are wonderful to work with. Very responsive!
The kitchen is perfect for storing your favorite beverages and munchies, but I think the owners would tell you that they don't intend it to be a place where you're going to turn out gourmet meals every night. That would be silly, with all the amazing restaurants in the city, many immediately proximate to the property.
The furnishings in the apartment are beautiful. Floor to ceiling mirrors reflect the views. The light coming in is wonderful.
You're in for a treat!