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-%' or registration_number like '%TA %') AND (`address` like '%2410 Cleghorn St%' ) order by rating desc LIMIT 0, 15
Waikiki Skytower #2904 (3-night minimum)
Enjoy magnificent Pacific Ocean views from this contemporary, updated high-floor, one-bedroom condo ...
Registration Number: GE-058-916-6592-01, TA-05
-
1
bedroom
-
1
bathroom
-
Sleeps 3
HI>
Honolulu
Waikiki Skytower #1103 - (30-night minimum) ALL MONTHLY RESERVATIONS ARE SUBJECT TO APPROVAL.
TRAVEL ALERT: Travelers must have negative ...
Registration Number: GE-100-358-5536-01, TA-10
-
1
bedroom
-
1
bathroom
-
Sleeps 4
HI>
Honolulu
Waikiki Skytower #1804 (3-night minimum)
Enjoy this newly remodeled (2017) high floor condo with partial Pacific Ocean views! Light and ...
Registration Number: TA-185-720-2176-01, GE-18
-
1
bedroom
-
1
bathroom
-
Sleeps 4
HI>
Honolulu
Special Offer (Description):
((( Free Starbucks Coffee of Denny's Hawaiian Breakfast)))....
For bookings that are made after 3/6/19 (and not for ...
Registration Number: TA-086-715-1632-01, GE-08
-
1
bedroom
-
1
bathroom
-
Sleeps 4
HI>
Honolulu
Waikiki Skytower #1803 (3-night minimum)
Enjoy this contemporary high floor condo with partial Pacific Ocean and Diamond Head views (694 sq.ft....
Registration Number: GE-036-408-6272-01, TA-03
-
1
bedroom
-
1
bathroom
-
Sleeps 4
HI>
Honolulu
Beautifully remodeled in 2018, this rainforest themed one bedroom can accommodate either a couple or a family and friends with a rollout living ...
Registration Number: GE-116-872-8064-01, TA-13
-
1
bedroom
-
1
bathroom
-
Sleeps 4
HI>
Honolulu
A private condo near Waikiki Beach and just moments away from the International Market Place! Waikiki Vista in the Waikiki Skytower features ...
Registration Number: GE-028-382-8224-01, TA-02
-
1
bedroom
-
1
bathroom
-
Sleeps 4
HI>
Honolulu
