select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`headline` like '%Royal Kahana%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Beautifully furnished condo has all of the amenities you would want on a tropical vacation (washer/dryer in the unit)! The suite has a gorgeous ocean view and fully furnished with elegant island décor. The kitchen and bathroom have been fully ...
0 bedroom
1 bathroom
Sleeps 4
HI> Lahaina
We just finished a complete remodel of the kitchen and the living room, yes everything is new. If you are looking for future dates that are blocked contact me.
Stop!! You found it!! The best studio condo at the Royal Kahana based on the view,...
0 bedroom
1 bathroom
Sleeps 2
HI> Kahana
Lovely one bedroom home conveniently located on the first floor of the Royal Kahana Resort with a view of the ocean and pool from the lanai. This oceanfront resort is one of Maui’s best-kept secrets. We clean and sanitize the property before ...
1 bedroom
1 bathroom
Sleeps 4
HI> Lahaina
Our lovely one bedroom Maui vacation condo is situated on a half mile stretch of uncrowded white sandy beach in the beachfront community of Kahana. A first rate beach community conveniently located between the fabulous resort areas of Kaanapali...
1 bedroom
1 bathroom
Sleeps 4
HI> Maui
"Recently Upgraded Royal Kahana Resort 1003"
A perfect location with all the comfort and affordability best describe this studio ocean view condominium. Ideal for a couple or small family of three persons, our lovely upgreaded air-conditioned ...
0 bedroom
1 bathroom
Sleeps 3
HI> Lahaina
Pride of Ownership - nicely upgraded! Great ocean views will greet you from this upgraded air-conditioned studio condominium located on the sixth floor of the oceanfront Royal Kahana Resort. The living room area has a king sized bed, sofa ...
0 bedroom
1 bathroom
Sleeps 3
HI> Lahaina
The Royal Kahana Resorts boast one of the best locations in West Maui / Kahana area. The Royal Kahana is situated on a quiet 1/2 mile of oceanfront. We share our oceanfront with visiting turtles and the passing whales. The whales visit from ...
1 bedroom
1 bathroom
Sleeps 4
HI> Lahaina
Wake up each morning to views of the beautiful Pacific and enjoy a breakfast filled with tropical fruit and fresh island coffee on your private lanai in this comfortable ocean view condominium. Unit 1209 is designed specifically for a couple ...
1 bedroom
1 bathroom
Sleeps 3
HI> Kahana
Royal Kahana is a beachfront resort on the West side between the Ka'anapali and Kapalua! This studio unit has King bed and twin sleeper sofa. Fully equipped kitchen with granite counters tops and full size appliances. Flat screen high ...
1 bedroom
1 bathroom
Sleeps 3
HI> Kahana
Royal Kahana Studio 1104
Wake up each morning to views of the beautiful Pacific and the island of Molokai resting on the horizon. You will enjoy a breakfast filled with tropical fruit and fresh island coffee on your private lanai in this ...
0 bedroom
1 bathroom
Sleeps 2
HI> Lahaina
Fabulous and in high demand, ground level condo with all the luxuries of home. This spacious studio suite (unit #119) is elegantly furnished with beautiful island décor. Royal Kahana 119 has a private lanai with a spectacular ocean view, a ...
0 bedroom
1 bathroom
Sleeps 4
HI> Lahaina
This one bedroom Royal Kahana 7th floor air-conditioned condominium is situated on the ocean between Ka'anapali and Kapalua and features fantastic ocean views from the living room & bedroom. Enjoy fabulous sunsets from your oceanfront lanai ...
1 bedroom
1 bathroom
Sleeps 3
HI> Lahaina,Maui
Our beautiful two bedroom 2 bathroom second floor suite has the perfect location to watch the sunset across the beautiful Maui ocean, come and watch the whales breaching from December through April! This spacious unit is fully furnished with ...
2 bedroom
2 bathroom
Sleeps 7
HI> Lahaina
Royal Kahana #409 offers stunning ocean and sunset views and features comfortable high-end designer décor throughout. The kitchen and bathroom are newly remodeled and modern. The bedroom features an ultra comfortable King size bed. There is ...
1 bedroom
1 bathroom
Sleeps 4
HI> Lahaina
Gorgeous, freshly REMODELED condo has all of the amenities you would want on a tropical vacation (washer and dryer in the unit)! The suite has a gorgeous ocean view and is fully furnished with elegant island décor. There is a comfy king sized ...
1 bedroom
1 bathroom
Sleeps 4
HI> Lahaina