Click on your destination city
for a list of hotels and room prices
Click on a hotel name to display more information. Click on to display other room types.
SELECT r.htlid, min(p.wdprice) as price FROM (prices p INNER JOIN rooms r ON p.roomid = r.id) INNER JOIN hotels h ON h.id=r.htlid WHERE p.start <= #7/4/2009# AND p.end >= #7/4/2009# AND p.promotion=1 GROUP BY r.htlid ORDER BY min(p.wdprice) No Records Found
Price quote valid for today only. State taxes are not included. Hotel reserves right to modify prices.
Copyright
2002 Hotel On Sale. All rights reserved.
Produced by Algoritmia.com
<
to display other room types.