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
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: TA-068-663-8592-01, 260160390000, GE-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, 1260160390000, GE-130-542-0800-01
- 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, TA-068-663-8592-01, 260160390000
- 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: TA-068-663-8592-01, 260160390000, GE-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, TA-068-663-8592-01, 260160390000
- 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
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: 1260160390000, TA-130-542-0800-01, GE-130-542-0800-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
Located along the Ala Wai canal, the resort boasts European-style gardens blended with the tropical appeal of Oahu. The outdoor pool, garden, media lounge, and sauna bring tranquility, while bustling Honolulu adventures abound beyond the ...
Registration Number: TA-212-767-6928-01,GE-212-767-6928-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
