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 '%Royal Garden at Waikiki%') AND sleeps>=1 order by rating desc LIMIT 0, 20
The Royal Garden at Waikiki is a luxurious and intimate condo-hotel. The moment you enter the lobby, you’re embraced by stunning Italian marble walls, columns and floors. Unlike the large, crowded hotels, this is a relaxed setting in a ...
Registration Number: GE-155-111-0144-01, 1260160390155, TA-155-111-0144-01
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
NOTE: THIS IS A LEGAL VACATION RENTAL
Warmest Aloha and thank you for taking the time to visit our listing.
Welcome to this privately owned Royal Garden at Waikiki suite on the 18th floor of the European-style Wyndham Resort with a...
Registration Number: GE-007-788-9536-01, TA-007-788-9635-01
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
*** Sanitation/Cleaning Update ***
Wyndham resorts have always met the highest standards of cleanliness, and now we are exceeding those standards with enhanced cleaning protocols and disinfecting measures, including the use of ...
Registration Number: GE-075-433-7792-01, TA-097-684-8896-04
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
*** Sanitation/Cleaning Update ***
Wyndham resorts have always met the highest standards of cleanliness, and now we are exceeding those standards with enhanced cleaning protocols and disinfecting measures, including the use of ...
Registration Number: GE-075-433-7792-01, 1260160390155, TA-075-433-7792-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Wyndham Royal Garden at Waikiki - 1 Bedroom - Sleeps 4
**PLEASE READ ENTIRE DESCRIPTION**
Book our Fabulous Condo & let The Timeshare Brokers, LLC make the booking process simple!
Key Points:
-The Timeshare Brokers ...
Registration Number: TA-075-433-7792-01, GE-199-896-9344-01, 260020270000
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
