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 '%Kaanapali Royal%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Completely remodeled December 2021 - Ground level Ka'anapali Royal Two Bedroom / Two Bath - Unit B-102. With over 1,500 sf of air conditioned living space all on one level, this gorgeous condominium is ideally located directly on the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kaanapali
Ka'anapali Royal E-302 --- Located in the heart of Ka'anapali directly on the Ka'anapali Golf course and easy walking distance to the beaches, restaurants and shopping of Ka'anapali, Ka'anapali Royal E-302 is a spacious two story townhouse style...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
This beautiful remodeled condo has golf course and partial ocean views on the Ka'anapali Golf course. There are stairs only to this entrance-no elevators. The master bedroom and bathroom are upstairs with golf course views as well. 6 guests ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Two story large vacation condo on the 3rd floor walking distance to Whaler's Village and Kaanapali Beach. (Stairs to entrance). King bed in the master suite upstairs, king bed in the guest bedroom downstairs and a queen sofa sleeper for a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Enjoy Kaanapali at its finest! This condo is located directly on the 16th fairway of the Royal Kaanapali Golf Course. Kaanapali Royal is located in the heart of Kaanapali. Close to all your vacation needs. Superb ocean and island views. This ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
This spacious condo rental in Maui was just recently renovated as of June 2019! Right in the heart of Kaanapali! Kaanapali Royal P-301 boasts some of the finest ocean views on property. Perfectly situated overlooking the 16th tee of the Royal...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
First time offered as a rental unit! Walking distance to Kaanapali Beach (voted one of the best beaches in America) and Whaler's Village, a popular dining and shopping complex! The spacious, over 1700 square foot property sits on the 16th ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Aloha guests, Hawaii is opening up with new traveler guidelines. I recommend checking the state website for the most up to date information as it changes frequently. Currently there is a required Covid negative test result within 72 hours of ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
***Brand New Central Air Installed January 2019***
Experience five-star Maui luxury at an affordable price! This modern ground-floor unit at Kaanapali Royal features a spacious floor plan that opens to sweeping golf course views. Extensively ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
HI> Lahaina
Great Kaanapali Royal listing with ocean and sunset views. Third floor unit L303 with ocean views and views of golf course and Whalers Village. 4-7 occupancy: 4 adults 3 children, or 5 adults 1 child. See bed info we want you to be ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
HI> Lahaina
This spacious, beautiful end unit welcomes you to Kaanapali with EXPANSIVE RESORT AND GOLF COURSE VIEWS! The huge, private lanai boasts it's own BBQ for those nights when you want to enjoy dinner at home while gazing at sunset colors and starry ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
HI> Lahaina
Enormous vacation rental in the heart of the world famous Ka'anapali Beach area. New flooring and living room furniture as of January 2020! Our 2 story town-home is the perfect family vacation rental. Large floor plan with the master suite ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
Settle into your Hawaiian vacation in this easy access, ground floor unit with golf course views on the Ka'anapali Golf course. There are stairs only to this entrance-no elevators. 3 stairs lead down to living room and to master bedroom. The ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Lahaina
This beautiful Maui home, B-301 features a townhouse style floor plan with the master bedroom and bath located upstairs for maximum view and privacy. Its spacious rooms and split level living area add to its volume and elegance. Beautifully ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
