Self-contained studio with all the basics and a giant TV. The view is actually really nice, and sitting outside to eat is quite pleasant. The interior is not new or luxurious, but everything works. The building is pretty quiet, but there is a fair bit of noise from the road so earplugs helps with that. Communication with the owners was fast and they're very willing to help.
As long as you're happy to walk about 10 mins to North Sydney centre, the location works really well.