How long does SEO take for a brand new website?

Longer than for an established site. A new domain has no history or links, so Google has little reason to trust it yet. Expect SEO to build gradually over many months. That is why we often recommend paid search alongside it in the early stages.