This site was created for MacInfo web. It was a test project with purpose to create a hotel and resort catalogue. The site was created using Drupal 7
Usually it's a good idea to implement something in Drupal if you want a powerful and custom search engine
Drupal uses a feature called views, which is essentially a mechanism that controls the database queries. That will give you a complete control over to what appears on each page. Using SQL is another alternative if one knows the exact database-table structure in Drupal, which can be quite complicated
Another feature is taxonomy that creates categories of items(Hotels, resorts etc). So when we find something we can always see all relative items
The downside is the enormous list of modules that was implemented, some of them support other modules!
The key here is find the right mix: which modules work good together and put only the necessary