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 '%beachwalk%') AND sleeps>=1 order by rating desc LIMIT 0, 50
**We normally only book Friday to Friday and Saturday to Saturday. Some longer and shorter stays are available but please send email to check these stays before booking**
2 Bedroom, 2 Full Bath Condo located less than a 5 minute walk to ...
Registration Number: TA-066-198-2654-01, GE-058-171-2384-01
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
The Regency on Beachwalk Waikiki by Outrigger brings fresh contemporary style into the heart of Waikiki. Features custom hardwood flooring, floor to ceiling windows, beautifully appointed kitchens and dining area. This charming retreat is ...
Registration Number: TA-143-590-4512-01, 260030140000, GE-143-590-4512-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
