SELECT H.HotelID,H.City,H.Allocation FROM Hotels H, Prices P WHERE (H.HotelIsActive = 1) AND (H.HotelID=P.frHotelID) ORDER BY City SELECT * FROM Classification ORDER BY ClassificationID ASC SELECT * FROM Hotels WHERE (HotelIsActive = 1) ORDER BY Allocation DESC, HotelName SELECT * FROM Hotels WHERE (HotelIsActive = 1) ORDER BY Allocation DESC, frClassificationID ASC ORDER BY Allocation DESC, HotelName Canada Hotels Tourism Guide

List By ABC - List By Stars

Online Booking
Hotels with availability and real-time confirmation
 


Request
Hotels upon request only
(availability and confirmation within 24 hours)
 
SELECT DealID FROM Deals WHERE (frHotelID = #GetHotels.HotelID#) AND (DealIsActive = 1) AND (DealEndDate >= #Now()#) SELECT PriceID FROM EXDeals WHERE (frHotelID = #GetHotels.HotelID#) AND (DealIsActive = 1) AND (SeasonEnd1 >= #Now()#)
 #GetHotels.HotelName# #GetHotels.City#
Deals  


#SiteCap#byclick.com offers 2 ways of booking:
1. ONLINE booking, for which you get a real time confirmation.
2. REQUEST, for which you get a confirmation within 24 hours
(or 48 hours on weekend and holidays).

Get Local Prices
    Deal Direct with our associates in #siteCap# who negotiate best hotel deals locally!  
100% Privacy
    We do not share your personal data with anybody!  
100% Security
    We use SSL Secure Server for secured booking.  
100% Security
    Get the total price of your reservation right away.
No hidden charges.