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 Beach Club%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Reservations available in weekly increments with arrivals and departures on Fridays, Saturdays and Sundays only.
Kaanapali Beach Club is in the heart of Kaanapali. You will be immersed in the best of Maui the moment you step out of your suite. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Kaanapali Beach Club is an amazing property with a beautiful swimming pool with a great slide for the kids 🐚humongous hot tub 🛁seats 24 ,made out of lava🌋 stone beautiful gardens🌺 fitness room. Roof top Putt Putt a golf ! Ping pong ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
THIS IS A TIMESHARE RESORT.. What is available can change several times a day.
TILL AFTER YOU HAVE ASKED OWNER A QUESTION REGARDING AVAILABILITY AND THEN I CAN
CHECK AVAILABILITY AND GIVE YOU AN ACCURATE QUOTE
RATE LISTED IN ADD IS FOR A ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
PLEASE DO NOT RELY ON CALENDAR FOR AVAILABILITY! THIS IS A TIMESHARE RESORT. Diamond's owner calendar does not sync with VRBO. What is available can change several times a day.
DO NOT USE
ONLINE BOOKING UNTIL CONTACTING ME FIRST THROUGH ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
HI> Lahaina
Located on the beautiful island of Maui, you will enjoy this tropical paradise and the many activities designed for the whole family. The resort offers spacious 1 bedroom villas, this one has an SCENIC VIEW, beautiful pool including adult only ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kaanapali
PLEASE DO NOT RELY ON CALENDAR FOR AVAILABILITY! THIS IS A TIMESHARE RESORT. Diamond's owner calendar does not sync with VRBO. What is available can change several times a day.
PLEASE DO NOT USE
ONLINE BOOKING TILL AFTER YOU HAVE ASKED OWNER A...
- 1 bedroom
- 1 bathroom
- Sleeps 5
HI> Lahaina
PLEASE DO NOT RELY ON CALENDAR FOR AVAILABILITY! THIS IS A TIMESHARE
RESORT AND THEREFORE DATES COME AND GO EVERY DAY. PLEASE DO NOT USE
ONLINE BOOKING. CONTACT ME FIRST REGARDING AVAILABILITY AND THEN I CAN
CHECK AVAILABILITY AND GIVE YOU ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
HI> Lahaina
PLEASE DO NOT RELY ON CALENDAR FOR AVAILABILITY! THIS IS A TIMESHARE RESORT. Diamond's owner calendar does not sync with VRBO. What is available can change several times a day.
PLEASE DO NOT USE
ONLINE BOOKING TILL AFTER YOU HAVE ASKED OWNER A...
- 1 bedroom
- 1 bathroom
- Sleeps 5
HI> Lahaina
PLEASE DO NOT RELY ON CALENDAR FOR AVAILABILITY! THIS IS A TIMESHARE RESORT. Diamond's owner calendar does not sync with VRBO. What is available can change several times a day.
PLEASE DO NOT USE
ONLINE BOOKING TILL AFTER YOU HAVE ASKED OWNER A...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Aloha 🌺
Kaanapali Beach Club now owned by Hilton 🥰🏖🎉
All One Bedrooms Sleep 4 with Privacy ;) priced here is a scenic view room upgrades to Oceanview are addntl based on season and Availability🌺🐝
This resort has one of the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> lahania
This property is one of the best resorts on Kaanapali Beach!Need a car too? We have a Jeep Compass , seats 5 with luggage booked separately not included .
All one-bedroom units sleep 4 privately and have a huge garden tub in the bathroom with 2 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
PLEASE DO NOT RELY ON CALENDAR FOR AVAILABILITY! THIS IS A TIMESHARE RESORT. Diamond's owner calendar does not sync with VRBO. What is available can change several times a day.
I offer rentals from a min. of 5 days up to a max. of 2 months at ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
HI> Lahaina
Reservations available in weekly increments with arrivals and departures on Fridays, Saturdays and Sundays only.
Kaanapali Beach Club is in the heart of Kaanapali. You will be immersed in the best of Maui the moment you step out of your suite. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Thank you for Visiting Chimera Vacations LLC.!
We look forward to welcoming you to prime waterfront location, vibrant tropical landscaping, first-rate amenities and exclusive array of leisure activities.
Please verify availability prior to ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Located on Maui's western shore just minutes from beaches and downtown Lahaina and Whaler's Village. Relax by the pool, enjoy breakfast at the resorts restaurant, have a cocktail in the open air cafe or poolside, or get your workout in at the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
