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, 30
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
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
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
Nestled among the links of Kaanapali's two championship golf courses, this two bedroom / two bathroom condo is located right in the heart of the famous Kaanapali Beach Resort and is close to everything! Enjoy golf, shopping, beaches and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
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
Kaanapali Royal P301 is a sizeable 1,400 sqft 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
This large beautiful two bedroom, two bathroom condominium, surrounded by lush, tropical landscaping makes Kaanapali Royal a beautiful retreat in paradise. With a pool, jacuzzi and tennis/pickleball, it is located in a gated community for your ...
- 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
Villa Q102 is located in the classic Kaanapali Royale Resort situated in a private end villa with tremendous privacy and space. The rate for this unit reflects the age and originality of this property. Although cleanliness and working order is ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
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
At almost 1,900 square feet, this ground-floor condo provides ample room for six guests and offers all the amenities of home. The large lanai, propane grill, proximity to the pool, and an outdoor dining set that comfortably seats six to seven ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Two-story large vacation condo on the 3rd floor and within walking distance to Whaler's Village and Kaanapali Beach and features one of the best ocean views at The Kaanapali Royal.
Downstairs there is a king bed in the second bedroom ...
- 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
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
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
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
This stunning, two-story townhouse in the heart of Kaanapali offers convenient access to the area's attractions and sweeping views of Kaanapali Golf Course, the Pacific Ocean and islands beyond. The open layout is tastefully designed and has ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Welcome to paradise at Kaanapali Royal L201! This luxurious two-bedroom, two-bathroom condominium offers the perfect blend of contemporary elegance and the tranquility of Hawaiian island living. Nestled within the prestigious Kaanapali Royal ...
- 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