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 '%Waikiki Grand Hotel%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Legally permitted rental - 134 Kapahulu Ave #918
** For your health and safety, we utilize additional Sterilization procedures between reservations.
The unit is located in one of the most desirable and beautiful locations in Waikiki. This ...
Registration Number: TA-133-307-5968-01, GE-13
- 0 bedroom
- 1 bathroom
- Sleeps 3
HI> Honolulu
Legally permitted rental - 134 Kapahulu Ave #805
** For your health and safety, we utilize additional Sterilization procedures between reservations.
8th Floor Suite - Perfect location 2 mins to Waikiki Beach and Honolulu Zoo
Welcome to this ...
Registration Number: TA-101-976-6784-01, GE-10
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Honolulu