359447 Real Estate Site Development

I represent a European SEO company and we currently need to outsource the following web design. This project is for the development of an international real estate site for an agent based in Europe. We expect it to be based on tried and tested existing scripts that you already possess and customised to meet the following requirements. Here are the main features: 1) Technical: Hosting and domain already set up - Linux/Apache, CPanel, PHP, MySQL 2) Style of site: Very contemporary and state-of-the art, clean and simple, of same style as the following sites (but not a clone): [login to view URL] [login to view URL] We will provide details of colour scheme, logo and main photos. 3) Database: We will provide an existing MySQL database of properties together with some access routines. All property data is entered offline in a PC desktop application and stored on our server, so you do not need to supply a property input or management interface. The purpose of the website is to search and display properties only to meet site user criteria. 4) Multi-Lingual: The site must display data and have a visitor interface in 3 languages - English, German & Spanish The Database that we provide already has property data in 3 languages. The static data (text) on the site must be in 3 language files. We will give you the English version and we will translate this into the other 2 languages. So you only need to work with the English. 5) Template-Based: To accommodate the 3 languages on the site and be easy to modify by us, the site should be built using a template system. 6) Static Pages: Must generate static HTML pages for all properties, where necessary using Apache mod_rewrite 7) SEO Capability: A good SEO capability is critical in the site design. We do all the SEO ourselves, but the site must be designed with this in mind. For example: All pages in all 3 languages must possess unique <title> and <meta description> tags. These can be auto-generated from the database data. All pages (including all properties) in all 3 languages must be fully indexable by the search engines when spidering from the home page of the site. 8) Home Page We must be able to specify which properties we wish to highlight on the site home page (by specifying a unique property ID). 9) RSS Feeds The site must output 2 RSS feeds in XML format: a) Featured properties b) Most recent properties 10) Visitor Accounts Site visitors should be able to sign up to receive automatic alerts for properties matching their specified search criteria 11) Newsletter Signup When site visitors sign up to receive alerts, there should also be an option to receive the newsletter. This must integrate directly with our existing 3rd party autoresponder/mailing list management system. 12) Thumbnail generation The system should automatically generate thumbnails on-the-fly from the large-format database photos. 13) Watermark generation There should be an option to automatically add a watermark to large-format photos for display. The option can be turned on and off. 14) Mailing, printing, request details & social bookmarking For each property detail page, the facility should be available to a) Mail details to a friend, b) Print details in printer-friendly format, c) Request further details, d) Social bookmark (with range of options) Please supply example work of similar real estate projects. Project duration: 2 weeks Payment: Escrow When bidding, please confirm that you have read and understand these requirements. If you do a great job and we work well together, there is the possibility of more site development in the future. PM me if you need any more details or clarification.