URL Best Practices (for site with millions of records)

[akin67]

We have a company information database where we also list companies located in a specific building/property. We plan to add more information to these pages basically to create a Property/building database. From an SEO standpoint, what is the best URL structure? Please note we will have information on millions of properties, across the US. Currently this is an example of what we are displaying http://www.buzzfile.com/Lists/Companies-located-at-45-Broadway,-New-York,-NY,-10006/6959468

When we change this, we plan to also migrate to https. For the above page, we are considering changing it to something like the following:

1 - https://www.buzzfile.com/Property/45-Broadway,-New-York,-NY,-10006/6959468

2  https://www.buzzfile.com/Property/6959468

Most users will search for these pages by address. What do you recommend we change our URLs to in order to get maximum SEO lift?

Thank you,

[Dalerio-Consulting]

As you can also read from the article on Moz here, the optimal URL structure would be the semantically structured url, the one that includes the keywords, as it is a factor that affects your site's SEO.

Depending on the keywords that you will be targeting for every page, there might be an even better option of choosing your URL structure, but between the options you provide, the first one is much better for SEO:
  https://www.buzzfile.com/Property/45-Broadway,-New-York,-NY,-10006/6959468

Daniel Rika - Dalerio Consulting
https://dalerioconsulting.com/
info@dalerioconsulting.com

[abtechgroup]

Isn't New-York just a waste of url length? Shouldn't it be New-York-City,-NY? And you're busting the recommended url length. Adrian