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 '%island colony%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Fantastically located Waikiki studio with spacious lanai overlooking the palm-tree dotted Ala Wai canal. As part of the luxurious Island Colony community, our guests indulge in the spacious sun deck, bbq area, fitness center, pool and hot tub ...
Registration Number: TA-188-369-5104-01
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Honolulu
Fantastically located Waikiki studio with spacious lanai overlooking the palm-tree dotted Ala Wai canal. As part of the luxurious Island Colony community, our guests indulge in the spacious sun deck, bbq area, fitness center, pool and hot tub ...
Registration Number: TA-211-510-7328-01
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> HONOLULU