select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) as vw where 1 and round(price)>0 and bedrooms>=0 and (registration_number like 'TA-%') AND (`headline` like '%royal kuhio%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Royal Kuhio 1309 with King Bed, FREE Parking/WiFi, mins to BEACH!
Free Wifi, Free Parking, 1 bedroom unit with a FULL KITCHEN (oven and dishwasher) in CENTER of Waikiki. Enjoy this unit in a building full of amenities.....pool, gym, pool table...
Registration Number: TA-163-729-6128-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
**PLEASE READ ENTIRE DESCRIPTION BEFORE REQUESTING RESERVATION**
Book our Amazing Condo & let The Timeshare Brokers, LLC make the booking process easy!
Key Points:
-You’re inquiring on a Timeshare for Rent.
-Please be aware that we ...
Registration Number: TA-163-729-6128-01, GE-19
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
Royal Kuhio 25F/City & Ocean View from Lanai/with parking Great location condo.
Great and extremely convenient location.
You can literally walk to all the must see places in Waikiki.
The apartment was roomy and the view from the balcony is ...
Registration Number: TA-028-622-9504-01, GE-02
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
