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 (`headline` like '%Kaanapali Royal%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Kaanapali Royal N-202 - Pride of ownership is readily apparent in this spacious 2-bedroom / 2-bath air-conditioned unit. With over 1,500 sf of living space, all on one level, the condominium underwent a full kitchen remodel plus new carpeting ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kaanapali
Welcome to our Kaanapali Royal Condo Unit !
**We owner manage our property**
Top Floor Unit. The Kaanapali Royal is a quite and gated luxury condo complex located on the 16th fairway of the Kaanapali Royal Golf Course located across from ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kaanapali, Maui
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
Hawaii> Lahaina
Completely remodeled December 2021 - With more than 1,500 sq ft of air-conditioned living space, this gorgeous condominium is ideally located directly on the Kaanapali Golf Course.
Kaanapali Royal B-102 features:
• Located on the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
The true spirit of aloha will long endure in your memories after your stay Kaanapali Royal Unit G-301. This updated 2 bedroom/2 bath two-story townhouse style floor plan has over 1,400 square feet of living space --- ideal for your Maui ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Discover Your Paradise Nestled in the Heart of Renowned Kaanapali, Maui! This spacious two-bedroom, two-bathroom condo is perfect for large families or groups of friends, featuring an oversized lanai ideal for relaxing while overlooking the lush...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Kaanapali Royal P301 is a sizeable 1,400 sq ft condo boasting some of the finest ocean views on the property. Perfectly situated overlooking the 16th tee of the Royal Kaanapali Golf Course, and towards the Pacific Ocean, this graciously sized ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
***Please be aware that Kaanapali Royal will replacing it's roof through September 2025. There will be NO construction between 12/19/24 - 3/3/25.
The complex has 15 buildings and there will be daytime noise through this period. The ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Kaanapali Royal E-302 --- Located in the heart of Kaanapali directly on the Kaanapali Golf course and easy walking distance to nearby beaches, restaurants and shopping, Kaanapali Royal E-302 is a spacious two-story townhouse style floorplan with...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Located directly on the 16th Fairway of the Kaanapali Golf course, Kaanapali Royal E-201 features a split-level floor plan with oversized lanai overlooking the golf course, Kaanapali and the Pacific. Air-conditioned and spacious living space ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kaanapali
Enjoy these luxury accommodations and travel in style. Why not stay in an unforgettable, updated condo with all the conveniences of home? You won't want to leave this little piece of paradise, which features a state-of-the-art kitchen with ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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
Hawaii> Lahaina
Kaanapali Royal is a highly sought after gated complex located on the world Famous Kaanapali Golf Course. One of the best locations in West Maui! This spacious condo is located on the top floor and offers views of the pool, golf course and peaks...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Experience the ultimate Maui getaway at Kaanapali Royal L101, a spacious ground-floor condo offering nearly 1,900 square feet of comfort and style. Perfect for families or groups, this beautiful two-bedroom, two-bathroom retreat comfortably ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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
Hawaii> Lahaina
Welcome to Kaanapali Royal Q302. This spacious 2 bedroom, 2 bathroom condo features central AC, 3 private lanai, and everything needed to feel at home. This beautiful coastal style condo can accommodate 6 people comfortably. Located in the heart...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaanapali
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
Hawaii> 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
Hawaii> Lahaina
Kaanapali Royal H-302 is a remodeled spacious two bedroom / two bath condominium with over 1,400sf of living space - two story townhouse style floor plan. Located on the Kaanapali Golf course, walk or take the trolley to the famous white sand ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2024 and receive a 4-door rental car from one of our major rental car agency partners. The Car is complimentary, you pay only ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
