I am in the process of building a new site.

The site will largely a content site which, of course, drupal is perfect for.

In addition to the content, I am wanting to incorporate a db of providers dealing with the content.

I will want to include a link to a page with the same theme that will a list of links that will allow the user to drill down from state, to city to get a list of providers pulled from the db. I will want to use mod_rewrite on this to clean up the URLs and make them more indexable as well.

I also have a script that allows my visitors to search by their zip code and receive a list of the closest providers that I will need to incorporate into the site as well.

Finally, I may want to include some info from the provider db on some of the content pages

Is this something that is possible with Drupal without serious tweaking to the code so that everything works together properly and seamlessly? I've been doing a good bit of research and like what I see in drupal, but I'm unsure how much customization will be necessary to achieve what I want.

Thanks in advance!