Hi,
1. If you use nvarchar(max) it can store upto 2GB of string in one column. so if that is the only argument to use MySQL for for one of the tables, you can re-consider it. If we do this, we can also remove the need of comple architecture of referring SQL Server table fields from MySQL table, etc.
2. I did not understand the difference between Keyword search and category search.
3. There is a lot of functionality involved in this project, and it is not as small as 2 pages website. Here is a list of all the functionalities -
Login / Signup
Keyword search
Category Search
Search result
Asynchronous paging
Share
Add to wishlist
Show wishlist
Photo Album
Google Map
Nearest tourist attractions
Show distance
Show reviews
Write Review
To develop and test all this functionality we will need about a month.
We have a strong experience in c#, google maps, sql server, jquery ajax, which are required for this project.
Please let me know if any questions. Get back to me if you want to discuss further.
Thanks,
Paresh