Hawaii Lowest Hotel Rate - The most budget, bargain, cheap, discount and value hotel reservation center for Hawaii ( including Waikiki , Oahu , Maui , Kauai , Kona and Hilo ), Condominium and Resorts ( Hyatt Regency , Marriott Resort , Hilton Hotel , Outrigger Hotel , Westin Hotel , Prince Hotel , Holiday Inn and Sheraton Resort etc.)

9/5/2010

	Home	Terms	About	Contact

	Oahu
	Big Island
	Maui
	Kauai
	Lanai-Molokai
	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.

Price quote valid for today only. Click on the hotel name link for an "all seasons" price list.
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 h.status='A' AND r.status ='A' AND p.start <= #9/5/2010# AND p.end >= #9/5/2010# and r.status='A' AND h.area =8 GROUP BY r.htlid ORDER BY min(p.wdprice)
No Records Found