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
- 2 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 DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
Book our Amazing Luxury Villa & let The Timeshare Brokers, LLC make the booking ...
Registration Number: 260020270000, TA-075-433-7792-01, GE-199-896-9344-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Summary:
This listing is for 2 Studio Suites at Club Wyndham Royal Garden at Waikiki
Each Studio Suite Features:
• Size: 311 - 381
• Kitchen: Partial
• Baths: 1
• Accommodates: 2 Guests
• Beds: King Bed - ...
Registration Number: GE-068-663-8592-01, 260160390000, TA-068-663-8592-01
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Honolulu
