I would like to create a property valuation wordpress site. I have a property database. The website needs to display information from my database. It needs to use certain filters and perform sums/averages on some of the values in the database. The database is big and contains around 16m properties. The website will also have a user account that will record the user details, saved properties and last viewed properties. A payment page (credit card and paypal) is also needed.
I also need some help to organize the data in the database in the most efficient way. Currently it is only in one table. (please also let me know if you know how to do this). This data will be updated monthly.
The website will have around 5 pages. URL need to be SEO friendly so search engine can crawl through the 16m property addresses. I will provide full UI design in psd and some CSS for buttons, borders, text boxes etc. you might have to adjust some.
If you can do this kind of work please PM me before accepting the project so that we can discuss first.