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, rewritten_description,
(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, 50
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 quieter
Registration Number: GE-155-111-0144-01, TA-155-111-0144-01, 1260160390155000
- 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
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
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
