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 '%royal kuhio%') AND sleeps>=1 order by rating desc LIMIT 0, 20
HEART OF WAIKIKI - ROYAL KUHIO 17th floor FREE WIFI! 1 bed 1 bath sleeps 4
※Parking is available at $30/night upon request and advanced payment is required. Please request parking via email at least three (3) business days in advance. ...
Registration Number: TA-105-232-1792-01, GE-105-232-1792-01, 1260200580130
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Royal Kuhio - Located in Heart of Waikiki 23rd floor
※Parking is available at $30/night upon request and advanced payment is required. Please request parking via email at least three (3) business days in advance.
1 Bedroom / 1 ...
Registration Number: TA-105-232-1792-01, 1260200580214, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
HEART OF WAIKIKI - ROYAL KUHIO 17th floor FREE WIFI! 1 bed 1 bath sleeps 4
※Parking is available at $30/night upon request and advanced payment is required. Please request parking via email at least three (3) business days in advance. ...
Registration Number: TA-105-232-1792-01, 1260200580128, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
King size bed in bedroom. Fully equipped kitchen. TVs in bedroom and living room
This is a corner view unit with windows on 2 sides and a furnished lanai facing the ocean with a southwest exposure to the Pacific Ocean and Diamond Head. Great...
Registration Number: 260200580190, TA-093-609-1648-01, 90/TVU-0939, GE-093-609-1648-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
This property is a 30-day minimum rental and is professionally managed by Ali'i Beach Rentals.
ENHANCED PROTOCOLS : We have revised our protocols to include contactless check-in & check-out, professional EPA approved non-toxic ...
Registration Number: GE-008-530-3296-01, TA-008-530-3296-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
This property is a 30-day minimum rental and is professionally managed by Ali'i Beach Rentals.
ENHANCED PROTOCOLS : We have revised our protocols to include contactless check-in & check-out, professional EPA approved non-toxic ...
Registration Number: GE-009-936-0768-01, TA-009-936-0768-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Discover Waikiki Bliss at HOME Honolulu - Royal Kuhio 1309
Embark on an unforgettable Hawaiian escape at our meticulously designed vacation rental, situated at the heart of vibrant Waikiki. Located at 2240 Kuhio Ave #1309, this King ...
Registration Number: GE-188-537-6512-01, TA-188-537-6512-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
HEART OF WAIKIKI - ROYAL KUHIO 17th floor FREE WIFI! 1 bed 1 bath sleeps 4
※Parking is available at $30/night upon request and advanced payment is required. Please request parking via email at least three (3) business days in advance. ...
Registration Number: TA-105-232-1792-01, GE-105-232-1792-01, 1260200580131
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Located in Heart of Waikiki (legal short-term rental) 17th floor
1 Bedroom / 1 Bathroom 17th floor
※Parking is available at $30/night upon request and advanced payment is required. Please request parking via email at least three (3) ...
Registration Number: TA-105-232-1792-01, 1260200580135, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
HEART OF WAIKIKI - ROYAL KUHIO 17th floor FREE WIFI! 1 bed 1 bath sleeps 4
※Parking is available at $30/night upon request and advanced payment is required. Please request parking via email at least three (3) business days in advance. ...
Registration Number: TA-105-232-1792-01, GE-105-232-1792-01, 1260200580127
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
HEART OF WAIKIKI - ROYAL KUHIO 17th floor FREE WIFI! 1 bed 1 bath sleeps 4
※Parking is available at $30/night upon request and advanced payment is required. Please request parking via email at least three (3) business days in advance. ...
Registration Number: TA-105-232-1792-01, GE-105-232-1792-01, 1260200580132
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
This property is a 30-day minimum rental and is professionally managed by Ali'i Beach Rentals.
ENHANCED PROTOCOLS : We have revised our protocols to include contactless check-in & check-out, professional EPA approved non-toxic ...
Registration Number: GE-064-711-1680-01, TA-064-711-1680-01
- 1 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Honolulu
Royal Kuhio - Located in Heart of Waikiki 17th floor.
※Parking is available at $30/night upon request and advanced payment is required. Please request parking via email at least three (3) business days in advance.
1 Bedroom / 1 ...
Registration Number: TA-105-232-1792-01, 1260200580138, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
***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 simple!
Before making a reservation request, kindly ...
Registration Number: TA-163-729-6128-01, GE-199-896-9344-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Royal Kuhio 25F/City & Ocean View from Lanai/with parking Great location condo.
Great and extremely convenient location.
You can literally walk to all the must see places in Waikiki.
The apartment was roomy and the view from the ...
Registration Number: TA-028-622-9504-01,+GE-028-622-9504-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Royal Kuhio - Located in Heart of Waikiki 16th floor3
※Parking is available at $30/night upon request and advanced payment is required. Please request parking via email at least three (3) business days in advance.
Studio/1 ...
Registration Number: TA-105-232-1792-01, 1260200580116, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
HEART OF WAIKIKI - ROYAL KUHIO 17th floor FREE WIFI! 1 bed 1 bath sleeps 4
※Parking is available at $30/night upon request and advanced payment is required. Please request parking via email at least three (3) business days in advance. ...
Registration Number: TA-105-232-1792-01, 1260200580129, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Royal Kuhio - Located in Heart of Waikiki (legal short-term rental) 17th floor
※Parking is available at $30/night upon request and advanced payment is required. Please request parking via email at least three (3) business days in ...
Registration Number: TA-105-232-1792-01, GE-105-232-1792-01, 1260200580133
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
HEART OF WAIKIKI - ROYAL KUHIO 17th floor FREE WIFI! 1 bed 1 bath sleeps 4
Located in Heart of Waikiki (legal short-term rental) 17th floor
※Parking is available at $30/night upon request and advanced payment is required. Please ...
Registration Number: TA-105-232-1792-01, GE-105-232-1792-01, 1260200580134
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
HEART OF WAIKIKI - ROYAL KUHIO 17th floor FREE WIFI! 1 bed 1 bath sleeps 4
※Parking is available at $30/night upon request and advanced payment is required. Please request parking via email at least three (3) business days in advance. ...
Registration Number: TA-105-232-1792-01, 1260200580137, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu