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, 30
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
Royal Kuhio - Located in Heart of Waikiki (legal short-term rental)
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, 1260200580139, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
- Located in Heart of Waikiki
※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 Bathroom 23rd ...
Registration Number: TA-105-232-1792-01, 1260200580212, GE-105-232-1792-01
- 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, 1260200580213, GE-105-232-1792-01
- 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: 1260200580219, TA-105-232-1792-01, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Royal Kuhio - Located in Heart of Waikiki
This unit includes 1 Parking stall.
1 Bedroom / 1 Bathroom 18th floor
Floor: 18th floor
Beds: 2 Full size beds + 1 queen size sofa bed
(AC in the living room, Fan in the ...
Registration Number: TA-139-088-6912-01, 260200580152, GE-139-088-6912-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
***Important Notice: We do not take any bookings over a year in advance. Please make an inquiry first to know if your desired dates are available.***
***Please inquire before booking. Dates are not confirmed until Owner/ Manager sends ...
Registration Number: 1231262058114, TA-105-232-1792-01, GE-105-232-1792-01
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
Enjoy city and peekaboo mountain views from this newly renovated, fully furnished studio with updated furniture and appliances! Located in the heart of world-famous Waikiki, in the luxurious Royal Kuhio building, amenities include recreational ...
Registration Number: GE-119-924-4800-01, 260200580069, TA-119-924-4800-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
***Important Notice: We do not take any bookings over a year in advance. Please make an inquiry first to know if your desired dates are available.***
***Please inquire before booking. Dates are not confirmed until Owner/ Manager sends ...
Registration Number: TA-105-232-1792-01, 1231262058114, GE-105-232-1792-01
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Honolulu
