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, 30
They Wyndham Royal Garden at Waikiki is a european style resort with Hawaiian tropical appeal just 5 minutes away from legendary Waikiki Beach. Whether you decide to explore the beach, attractions, golf, shopping and dining options or just spend...
Registration Number: TA-130-542-0800-01, GE-130-542-0800-01, 1260160390000
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Honolulu
Summary:
CW Royal Garden at Waikiki | King Balcony Studio
• Size: 311 - 381
• Kitchen: Partial
• Baths: 1
• Accommodates: 2 Guests
• Beds: King Bed - 1
Room Amenities
• Hairdryer
• In Room Safe
•...
Registration Number: GE-068-663-8592-01, 260160390000, TA-068-663-8592-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
They Wyndham Royal Garden at Waikiki is a european style resort with Hawaiian tropical appeal just 5 minutes away from legendary Waikiki Beach. Whether you decide to explore the beach, attractions, golf, shopping and dining options or just spend...
Registration Number: TA-130-542-0800-01, GE-130-542-0800-01, 1260160390000
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
Summary:
CW Royal Garden at Waikiki | King Balcony Studio
• Size: 311 - 381
• Kitchen: Partial
• Baths: 1
• Accommodates: 2 Guests
• Beds: King Bed - 1
Room Amenities
• Hairdryer
• In Room Safe
•...
Registration Number: GE-068-663-8592-01, 260160390000, TA-068-663-8592-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
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, TA-097-684-8896-04
- 2 bedroom
- 2 bathroom
- Sleeps 6
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
*** 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
*** 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
*** 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
*** 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 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 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
*** 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
*** 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
*** 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
*** 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
*** 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
*** 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
*** 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
*** 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
*** 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
*** 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
*** 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
*** 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
Summary:
CW Royal Garden at Waikiki | King Balcony Studio
• Size: 311 - 381
• Kitchen: Partial
• Baths: 1
• Accommodates: 2 Guests
• Beds: King Bed - 1
Room Amenities
• Hairdryer
• In Room Safe
•...
Registration Number: GE-068-663-8592-01, 260160390000, TA-068-663-8592-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Summary:
CW Royal Garden at Waikiki | King Balcony Studio
• Size: 311 - 381
• Kitchen: Partial
• Baths: 1
• Accommodates: 2 Guests
• Beds: King Bed - 1
Room Amenities
• Hairdryer
• In Room Safe
•...
Registration Number: GE-068-663-8592-01, 260160390000, TA-068-663-8592-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
They Wyndham Royal Garden at Waikiki is a european style resort with Hawaiian tropical appeal just 5 minutes away from legendary Waikiki Beach. Whether you decide to explore the beach, attractions, golf, shopping and dining options or just spend...
Registration Number: TA-130-542-0800-01, GE-130-542-0800-01, 1260160390000
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu