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 (registration_number like '%TA-%' or registration_number like '%TA %') AND (`headline` like '%palms waikiki%') AND sleeps>=1 order by rating desc LIMIT 0, 30
Are you ready to experience paradise?
Then check out this remodeled and charming condo suite in the Aqua Palms Waikiki, is located just a single block from the beach and a short stroll to Ala Moana Center and the Hawaii Convention Center....
Registration Number: 260120030027, TA-186-140-8768-01, GE-186-140-8768-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Legally permitted rental - 1850 Ala Moana Blvd #321
** For your health and safety, we utilize additional Sterilization procedures between reservations.
A super comfortable remodeled unit, this 2x Queen bed Studio suite at The Palms...
Registration Number: GE-026-848-6144-01, 260120030047, TA-026-848-6144-01
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Palms at Waikiki - Unit #702 on the 7th floor: This newly remodeled suite at the Palms at Waikiki is located at the edge of Waikiki. Floor-to-ceiling sliding glass doors allow an abundance of natural sunlight. Sweeping views of Waikiki can are ...
Registration Number: TA-199-022-8480-01, 260120030131, GE-199-022-8480-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Waikiki ! 8 th floor views private balcony with breathtaking OCEAN and DIAMOND GHEAD views with table /chairs provided for lounging.
Easy easy access to popular shops and restaurants from this charming place to stay.
2 Queen bed ...
Registration Number: GE-034-075-4432-02, TA-034-075-4432-01, 1260120030172
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Summary:
Boutique Hotel centrally in Waikiki. Just across the street from the Hilton Hawaiian Village and just few minutes walk to Waikiki Beach, restaurants, bars and shopping. Bright and clean studio with a balcony where you can relax with ...
Registration Number: 1260120030205, GE-123-883-5200-01, TA-123-883-5200-01
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
Your family will be close to everything when you stay at this centrally-located Palms Waikiki studio with balcony offering Ocean, City and Diamond Head views. Plus we have a pool and offer Free Parking!
King bed & Sofabed Studio...
Registration Number: 260120030228,TA-013-258-9568-02,GE-013-258-9568-02
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
King bed plus additional Sofabed make this modern Studio suite at the Palms in Waikiki great for a group of up to four guests. The added bonus of a free parking spot in the building will save you money and time hunting for parking as you return ...
Registration Number: TA-013-258-9568-02, 260120030037, GE-013-258-9568-02
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
