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, 20
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: 1260120030172, TA-034-075-4432-01, GE-034-075-4432-02
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Are you ready to experience paradise?
Then check out this remodeled and charming condo suite in the Aqua Palms Waikiki, which is located just a single block from the beach and a short stroll to Ala Moana Center and the Hawaii Convention ...
Registration Number: TA-186-140-8768-01, GE-186-140-8768-01, 260120030027
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
TMK 2-6-012-003 2022/ELOG-1168(LM)
Welcome to your Deluxe (renovated 2020) Aqua Palms Waikiki studio with sea views, along with views over Fort De Russy Park and across to Diamond Head.
Your Deluxe studio includes:
* ...
Registration Number: GE-135-286-7840-01, TA-135-286-7840-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
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: TA-026-848-6144-01, 260120030047, GE-026-848-6144-01
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Boutique Hotel centrally located 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 nice...
Registration Number: GE-123-883-5200-01, TA-123-883-5200-01, 1260120030205
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
This modern and spacious studio unit has two queen-size beds. Our central location within a short walk to the beach, puts you in the heart of Waikiki's vibrant energy with a plethora of world-class dining, shopping, and entertainment options. ...
Registration Number: 1260120030131, GE-199-022-8480-03, TA-199-022-8480-03
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
