We went to Sydney just for one night as our son had a competition in Northern Beaches. For an overnight trip, we really enjoyed our stay. The location is good, close to the Newport with a fantastic view over the beach. The house is new and clean.
The only thing we did not like is the smell in the bedroom which I guess coming from carpet (stale air). So once you have checked in, just let the windows open.
Otherwise, it's really a fantastic place for an overnight stay. We will be definitely coming back for an overnight stay.