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, rewritten_description,
(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, 50
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
HEART OF WAIKIKI - ROYAL KUHIO 17th floor FREE WIFI! 1 bed 1 bath sleeps 4
Free WIFI + Local call: Wifi (1 Gbps)
Heart of Waikiki - Royal Kuhio (17th Floor)
Address: 2240 Kuhio Ave., #1709, Honolulu, HI 96815
1 Bed | 1 Bath
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)
Address: 2240 Kuhio Ave., #1710, Honolulu, HI 96815
1 Bed | 1 Bath | Sleeps 4
Beds: 2 Full-size beds + 1 Queen sofa bed
Size: 436 sq ft + 80 sq ft lanai
View: Partial ocean and
Registration Number: TA-105-232-1792-01, 1231262058136, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Heart of Waikiki - Royal Kuhio (17th Floor)
Address: 2240 Kuhio Ave., #1606, Honolulu, HI 96815
1 Bed | 1 Bath | Sleeps 4
Beds: 2 Full-size beds + 1 Queen sofa bed
Size: 444 sq ft + 80 sq ft lanai
View: Partial ocean and
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 17th floor.
Heart of Waikiki - Royal Kuhio (17th Floor)
Address: 2240 Kuhio Ave., #1712, Honolulu, HI 96815
1 Bed | 1 Bath | Sleeps 4
Beds: 2 Queen-size beds + 1 Queen sofa
Registration Number: TA-105-232-1792-01, 1260200580138, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Heart of Waikiki - Royal Kuhio (16th Floor)
Address: 2240 Kuhio Ave., #1604, Honolulu, HI 96815
1 Bed | 1 Bath | Sleeps 4
Beds: 2 Full-size beds + 1 Queen sofa bed
Size: 436 sq ft + 80 sq ft lanai
View: Partial ocean and
Registration Number: TA-105-232-1792-01, 1260200580116, 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)
Address: 2240 Kuhio Ave., #1602, Honolulu, HI 96815
1 Bed | 1 Bath | Sleeps 4
Beds: 2 Full-size beds + 1 Queen sofa bed
Size: 436 sq ft + 80 sq ft lanai
View: Partial ocean and
Registration Number: TA-105-232-1792-01, 1231262058114, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Heart of Waikiki - Royal Kuhio (17th Floor)
Address: 2240 Kuhio Ave., #1707, Honolulu, HI 96815
1 Bed | 1 Bath | Sleeps 4
Beds: 2 Full-size beds + 1 Queen sofa bed
Size: 436 sq ft + 80 sq ft lanai
Kitchen: Fully equipped with
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)
Address: 2240 Kuhio Ave., #1708, Honolulu, HI 96815
1 Bed | 1 Bath | Sleeps 4
Beds: 2 Queen-size beds + 1 Queen sofa bed
Size: 436 sq ft + 80 sq ft lanai
View: Partial ocean and
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)
Address: 2240 Kuhio Ave., #1713, Honolulu, HI 96815
1 Bed | 1 Bath | Sleeps 4
Beds: 2 Full-size beds + 1 Queen sofa bed
Size: 436 sq ft + 80 sq ft lanai
View: Partial ocean and
Registration Number: TA-105-232-1792-01, 1260200580139, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Heart of Waikiki - Royal Kuhio (23rd Floor)
Address: 2240 Kuhio Ave., #2302, Honolulu, HI 96815
1 Bed | 1 Bath | Sleeps 4
Beds: 2 Full-size beds + 1 Queen sofa bed
Size: 436 sq ft + 80 sq ft lanai
View: Partial ocean
Registration Number: TA-105-232-1792-01, 1260200580212, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Heart of Waikiki - Royal Kuhio (23rd Floor)
Address: 2240 Kuhio Ave., #2303, Honolulu, HI 96815
1 Bed | 1 Bath | Sleeps 4
Beds: 2 Full-size beds + 1 Queen sofa bed
Size: 436 sq ft + 80 sq ft lanai
View: Partial ocean and
Registration Number: TA-105-232-1792-01, 1260200580213, GE-105-232-1792-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
