This is a great location! We didn't rent a car for our vacation, so we relied on our feet and ride share (very available). We walked to the Fremont area for food and shops, and it's amazing to have the waterfront so close to the place!
As for the bnb itself, it's exactly how the photos are! Beautiful, airy, quiet neighborhood. I'd absolutely come again when we visit Seattle next.