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 '%Waikiki Beach Tower%') AND sleeps>=1 order by rating desc LIMIT 0, 30
This is a fabulous newly renovated, with new owner, so we do not have many reviews yet. You will never want to leave!
Awesome ….well appointed, privately owned, beautifully furnished. Just remodeled, kitchen, new furniture, beds and ...
Registration Number: 260230070010, GE-072-016-8960-01, TA-072-016-8960-01
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Honolulu
Waikiki Beach Tower
Relax in this exclusive upper floor unit at the most luxurious vacation rental tower on the beach in Waikiki. This 1,200 SF newly renovated condo has the only open floor plan in the entire building and its sky high ...
Registration Number: 260030070083, TA-118-133-4016-01, GE-118-133-4016-01
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Honolulu
Brand new listing at Waikiki Beach Tower - no reviews yet, soon this will be full of 5-star reviews like our other properties.
Relax in this beautifully renovated unit with ocean views of Waikiki Beach. Wake up to the crystal blue ocean ...
Registration Number: TA-013-407-1808-01, 260030070029, GE-013-407-1808-01
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Honolulu
The pool, spa, and grill are currently closed until the end of July for repairs.
Check out the video in the photos.
One-of-a-kind luxuries two bedroom, two bath unit on the 23rd floor at the Waikiki Beach Tower. Exceptional ocean ...
Registration Number: 260230070073, GE-137-941-8112-01, TA-137-941-8112-01
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Honolulu
Located just across the street from the main stretch of Waikiki beach, with incredible ocean views from the 10th floor, you’ll be relaxing in no time at this 4-diamond AAA rated resort. Renovated in August 2021, this 2-bedroom, 2-bath condo ...
Registration Number: GE-067-035-7504-01, TA-067-035-7504-01, 260230070025
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Honolulu
Aston Waikiki Beach Tower2 bedroom unit Sleeps 6
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
Book our Amazing Luxury Villa & let The Timeshare Brokers, LLC make the booking process ...
Registration Number: TA-162-883-7888-01, 260230070000, GE-199-896-9344-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
