Create a Joomla Template

Dropped job needs to be completed asap. Design is complete in Photoshop [login to view URL] Top images are a slideshow. Images already sliced. Basic content pages and menus already built. Template needs to be built and some database work. This is an update to an existing site, some of the database work is already done. What we need are new database fields created. The home page content comes from listings in the database that are tagged as 'featured'. Approximately 5 other pages are also database listings, with each page a different category. When someone clicks on a property listing, we need a detailed listing similar to this layout [login to view URL] We also need a way to easily input the data on the backend. Each listing should have the ability to upload unlimited images and videos. To recap: 1- create site template 2 - created detailed listing layout 3 - update database with additional fields needed 4 - create approximately 6 pages that are basically all the same database query, some of which already exists (fields need to be updated) 5 - ability to add / update listings on the backend (or front end if that's easier/quicker) 6 - simple way to add in sponsors in sidebar Previous freelancer unable to complete project and the deadline quickly approaches. Your turnaround time is a big factor here.