SELECT h.hotel_id, hotel_name, star_rating
FROM hotels h
INNER JOIN hotel_areas_assoc haa ON (h.hotel_id = haa.hotel_id)
WHERE haa.area_id = 1023 AND star_rating <= "2.5" AND star_rating > "1.0"
ORDER BY RAND()
LIMIT 0, 1SELECT h.hotel_id, hotel_name, star_rating
FROM hotels h
INNER JOIN hotel_areas_assoc haa ON (h.hotel_id = haa.hotel_id)
WHERE haa.area_id = 1023 AND star_rating <= "5.0" AND star_rating > "3.5"
ORDER BY RAND()
LIMIT 0, 1
OAHU - Book Hawaii Hotels - i4hawaii
Overview of OAHU Hotels
Home to the North Shore, Pearl Harbor, Diamond Head and Waikiki Beach,
the island of Oahu is unlike any other. With a population of around
900,000, the island of Oahu houses nearly 75% of all Hawaiian
residents. It's like a mini Tokyo or San Francisco in the middle of the
Pacific and, as a result, excitement abounds. There's never a dull
moment. From shopping and dining to hiking and snorkeling, Oahu has it
all in spades. And, with its nearly perfect climate "a perpetual late
spring with 82 degree days almost year round" you'll understand why
nearly a million people choose to call this place home.
Waikiki Beach
is one of the busiest places on the planet. The vibe is urban, youthful
and energetic. There are tons of places to shop (from bargain to couture) and the nightlife is terrific. If you're looking for
excitement in your Hawaiian vacation, and don't mind the crowds,
Waikiki/Honolulu is perfect.
The North Shore
With its monster waves, surfers, tropical jungles, waterfalls and
mysterious Hawaiian temples, this section of Oahu lives up to the hype.
The pace is very laidback and most visitors come for the scenery,
swimming, snorkeling/diving, surfing and beautiful beaches. Though only
60 minutes from Waikiki, The North Shore seems a world away from the
hustle and bustle of Honolulu.
The Waianae Coast For luxury travelers in search of total seclusion, this part of Oahu has only one resort: JW Marriott Ihilani Resort & Spa.
Proudly serving 1,399,582 happy customers.
Call (800) 997-1423 to speak with an i4hawaii specialist.