this project is for a real estate agent, where it combines classic ASP, Ajax, MySQL and jquery.
User can search for properties in 3 ways:
1. by completing the search box and hit the “Search” button
2. select district from map together with search box criteria
3. by selecting “Areas” tab where all available areas will be listed
In case 1:
The search box is already built according to the prices of the properties in the DB. Then if user clicks “Search”, to go to the page with the search results that match the preselected search criteria.
In Case 3:
In this page, we have 5 districts and under each to list in 3 columns all available towns alphabetically. Each town to have a checkbox so user can select whatever town he wants. Again, if user doesn’t select a town and hits “Search” to show results according to the search box criteria for all towns in the database. If user selects a town OR towns, to show results for those towns and according to the search box criteria.
In Case 2: (Country Map and District Map to update automatically according to the search box criteria)
Districts have that effect where when you hover and IF there are entries in the DB for each district, to be able to click on it. If there are no entries, then not to show that effect and of course not to be a link. For example, if there are no entries for Nicosia district, then the district not to be a link. Also, if there are properties, then the district is a map. But, if user selects i.e. min price 200,000 and there aren't any properties in Nicosia in that range, then MAP to auto-update and remove the link from Nicosia district (ajax auto-update without refreshing the webpage)
Only Nicosia, when you click on it (assuming there are properties) the map changes and you see the “district map of Nicosia”. Also in the map, we need a back button for user to go back to the map of Cyprus. The properties are broken down in 3 major Areas of Nicosia as you see them on the map. Again, we need the hover functionality to work exactly like on the other map.
When user click lets, say, “City Center & Greater Nicosia”, to show a popup window with a list of all available towns and a checkbox for each town of that Area and below 2 options. A search button and also a link to say “Choose another area from the map” which will close this popup, keep the selections that user had and be able to open another Area with the popup again and those 2 links. When user clicks Search, it will search for the towns selected and together with the search box criteria.
For the other 4 districts, when user clicks on them (assuming there are properties) to show the same popup, as above, with all available towns and checkbox for each town for that district and the link “Choose another area from the map” and search button. Basically, the other 4 districts will not have the middle step of showing the district map of that District.
Search Results Page:
In the search results page, the entries are shown one under the other. We need to have a drop down menu with options to sort them according to high & low price, by no. bedrooms and town alphabetically. Also another drop box to select how many entries to show per page and paginate the results accordingly with page numbers and arrows to go to the next/last or previous/first
Deadline for this project is within 3-4 days once accepted. If within deadline and fully working, im happy to offer bonus as well
Thanking you in advance
9 freelancers are bidding on average $365 for this job
Certified IT Professionals with 10+ years of experience in delivering enterprise class web solutions, intranets, portals and business workflow solutions to clients worldwide. Please review the PMB for more information.
Hi sir, I'm a portuguese freelance webdeveloper. ASP (VBScript), VB and SQL Serve are my areas of expertise. Please get in touch to discuss my bid. Best Regards, Daniel Martins