select * from (Select a.`postalCode`,a.`uniturl`, `region`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `source`, `property_type`, `address`,round(price) as price,minimum_nights, `rating`, `review_count`,`latitude`, `longitude`,case when propertyName='' then trim(address) else CONCAT(CONCAT(propertyName,'(',trim(address)),'',')') end as addre,propertyName,
(6371 *
acos(
cos( radians( 21.2759167 ) ) *
cos( radians( `latitude` ) ) *
cos(
radians( `longitude` ) - radians( -157.8233677 )
) +
sin(radians(21.2759167)) *
sin(radians(`latitude`))
)
) as distance from `vacationrentalindex` a inner join vacationrentalindexfeed b on a.uniturl=b.unitUrl and a.headline!='' and a.thumbnailUrl!='' and b.enabled=1 and b.blocked=0 ) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`headline` like '%Honolulu Zoo%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Make this comfortable and convenient property your next Waikiki adventure! Relax by the pool, enjoy dinner with family at one of three on-site restaurants, or grab a pastry and morning coffee at the coffeehouse. And best yet, the sun, sand, and ...
- 3 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Honolulu
Spacious & Bright Apartment just 2 minutes walk to Waikiki Beach and only 5 minutes from the heart of Waikiki's shopping, dining and entertainment.
Our 1 bedroom apartment is quite unique in that as well as the comfy Queen bed in the bedroom,...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Looking for a beachfront getaway in Waikiki? Look no further than this convenient property! Just minutes from the most popular attractions, the excitement of Waikiki is all around you! And with comfortable amenities and authentic Hawaiian ...
- 3 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Honolulu
Your exciting family vacation or romantic escape starts here, right on the sands of Waikiki Beach! Just minutes from the best attractions, guests will also enjoy the resort pool with expansive sundecks and private cabanas as well as a poolside ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Your exciting family vacation or romantic escape starts here, right on the sands of Waikiki Beach! Just minutes from the best attractions, guests will also enjoy the resort pool with expansive sundecks and private cabanas as well as a poolside ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Come for the beaches, stay for the adventure! With comfortable amenities and convenience to local attractions, you’ll have everything you need for a relaxing getaway or exciting family vacation. Take a dip in the rooftop pool with views of ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
At this Waikiki boutique property, experience worry-free amenities, and exceptional service. Everything you need is right here--towels for the beach, coffee in the morning, and neon lights to swim by at night. Lounge on the sun terrace or take a...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Located next to the famous Waikiki Beach, our hotel offers more than just a stay; it’s an experience. Immerse yourself in the vibrant local culture with breathtaking views and easy access to iconic attractions like the Diamond Head hikes and ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
