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
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, 1990/NUC-0372, GE-093-609-1648-01
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
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
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
≪Close to the beach and stores in Waikiki / 24 hours security desk/ Fully equipped kitchen & Free Wi-Fi≫
--------------This is a legal vacation rental...
Registration Number: TA-105-232-1792-01, 1231262058136, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Gorgeous City and Diamondhead View! In the heart of Waikiki - 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) ...
Registration Number: 1231262058118, 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
HEART OF WAIKIKI - ROYAL KUHIO 16th 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, 1231262058114, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
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
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 (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
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
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
