We spent a few months here last year, as we were looking for a house to buy. The unit is on the lower level, but there are enough windows to make it seem open, and it was really well equiped for cooking, laundry, and TV internet connections. The location can't be beat, close to Green Lake, UW, not that far from downtown Seattle, and Fremont is a unique and colorful neighborhood.
Jeff and Sarah and their two kids are a nice family, and they are accessible for whatever you might need. We had a couple of unusual requirements, and they found a way to accommodate with no problem. Sometimes the biggest challenge was getting up early, as it is super comfortable and quiet, not much street noise. With kids and pets there is a little overhead noise, but it never lasts too long. I'd recommend this for a short or long term stay.