A leading industry figure has warned buyers he believes the Sydney real estate downturn is almost at an end.