Project Detail

Description

Attention: Web Developer
Must speak English and provide sample work I need this project done ASAP

I need a CMS (Content Management System) or perhaps something like PHP Nuke or Joomla site for the following..
I have purchased a pre-built website that is currently running at the following url see sample at www.aaatrophy.com and I want to build a template to nestle (place) the pre built site into, a graphical frame with menus in the left gutter that allows me to have my own pages and have the pre-built site sitting inside see example of graphical frame template here www.centertrophy.com/ .

What I am looking for is the ability to use a management system to dynamically add pages by defining certain keywords and have the dynamic system do the following:
1) automatically create new url with new keyword(s)
2) automatically create H1 title for each page with new keyword(s)
3) automatically create alt title for page with new keyword(s)
4) automatically create alt description for each page with new keyword(s)
5) automatically create keywords for each page with new keyword(s) imported from data base
6) automatically update site map upon creation of new page(s)

Example: we have a page for widgets in New Orleans with matching SEO info titles, keywords, description, H1 title, page content, url www.sample.com/new-orleans-widgets.htm and when we add a new page and enter the new city and or product we get the new results. example san fransico (for the city) and whatchamacallits for the product. RESULTS:
wwww.sample.com/san-francisco-whatchamacallits.htm is the results along with all other items of SEO relevance for the new page I need this ASAP and if you have samples of one you have built similar please provide here.

We would like to be able to simply use a data base to import each new city and product to dynamically create thousands of new pages so interface must be simple and accurate.
I will only consider those that will provide sample project they have built similar and references.
I am not really concerned with graphics as much as the ability to dynamically do the things mentioned in job posting. I need some specifics from you on that portion of job as stated I am buying the site I just need a template that will allow me to optimize any and every page on my side and then point to the appropriate page on the site I am purchasing. I want to be able to use a data base to import example cities and the template with cms that will help place all the keywords, H1's etc from imported data

By H1 I am referring to the actual title that is displayed on page viewers see. I need this to change automatically H1 is simply the size of the title. So that is my angle speed and ease of adding additional pages to the site is my concern as there will ultimately be several thousand pages. Can you possibly give me a brief description what will happen and how each one of the following works when changing from one city to the other and from widgets to whatchamacallits.

My goal is to create a lot of pages fast that are somewhat seo (optimized) from the imported fields inside the database. Hope this all makes sense!