Camerdb real estate site

Project Description I bought a template from themeforest that I need to get customized for my needs. [login to view URL] I am going to need a SQL database whose schema I will provide A. GENERAL SETTINGS 1. Navigation Tab Home - linked to homepage Listings -See All Listings -Douala -Yaounde -Bamenda * Douala, yaounde, and Bamenda are all cities that should be read from a city table in the database. When I add another city, it should automatically be included in the dropdown menu under listings. Something like; <?php $cities = mysqli_query($cxn, "SELECT * FROM City"); while ($row = mysqli_fetch_array($cities)) { echo "<option value=".$row['City_ID'].">".$row['CityName']."</option>"; } ?> Agents - Link to agents page. Contact -FAQ (links to [login to view URL]) -Contact US (links to [login to view URL]) 2. Horizontal Filter Location Property Type Max Price 3. Quick Search and partners remain as is. B. PAGES 1. Properties: Should list all properties from database with cover image for each (a property can have more than one image) 2. Property-Detail: Clicking a property on the properties page should list details of that property including additional photos. link to email property to third party. 3. Agents: Should list all agents with cover image included 4. Agent-details: Show agent information and all properties associated with that agent 5. Contact us 6. Frequently asked questions (faq) 7. Register: reads user input from form and updates customer table in database * The following pages are for internal use. They may be accessible only by employees who are logged into the system. There is no link to log in anywhere on the public website so employees must have the url to a dashboard e.g [login to view URL] from which they can log in for access to commands that update the database. 8. Add-property 9. Add Agent 10. Add property Owner 11. Edit property I have attached a word file which contains screenshot of some html pages I edited showing what I want the final result to look like except for a few color changes I have not made yet. The bulk of the work is in creating the database and using php to communicate between the pages and the database. I will send all original website files. If necessary, i will also send the edited html pages I have so you can have a better understanding of the final layout and relevant content.