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 Beach Club%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Diamond Resort Kaanapali Beach Club -OCEAN VIEW 1 Bedroom Sleeps up to 5
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
Book our Amazing Luxury Villa & let The Timeshare Brokers, LLC make ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Bellani Vacations is happy to offer 1 bedroom villas at Ka'anapali Beach Club!
**Choose a Friday, Saturday, or Sunday for check-in, and enjoy a 7 night stay. We can typically book this resort in 7 night increments. Please use the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
We are able to offer 7 night weekly rentals with check-in 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. There ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
THIS IS A TIMESHARE RESORT.. What is available can change several times a day.
I offer weekly rentals. Longer periods of time can be reserved and are usually available if I reserve them a year in advance at the Ka'anapali Beach Club. KBC ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
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...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
IGNORE CALENDER. PLEASE AT LEAST READ THE FIRST 4 OR 5 PARAGRAPHS!!
DO NOT MAKE A BOOKING REQUEST FOR ANY DATES.
THIS IS BECAUSE THIS IS A TIMESHARE RESORT.Room accommodates up to 4 guests.
I SAY AGAIN, "DO NOT MAKE A ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> 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 TILL AFTER YOU HAVE ASKED OWNER...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
THIS IS A TIMESHARE RESORT.. What is available can change several times a day.
Please do not use the book it now button until
AFTER YOU HAVE ASKED OWNER A QUESTION REGARDING AVAILABILITY AND THEN I CAN
CHECK AVAILABILITY AND ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Please choose a Friday through Sunday check-in for a seven night stay.
Thank you for your interest in booking with Dash Realty Group, Windermere Florida.
Dash Realty Group is registered in Florida as a licensed Fla. Seller of Travel...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
This my timeshare and these are my set dates and they cannot be changed.
Kaanapali Beach Club
April 8-15 2023. 1 bedroom, Deluxe Ocean view.
June 23-30 2023. 2 bedroom, Ocean view.
The unit will be a 1 Bedroom unit, which ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Lahaina
Discover comfort in our beautifully appointed accommodations featuring a king size bed, sofa bed with Tempurpedic mattress, and full bathroom complete with garden bath and walk-in shower. Enjoy the convenience of the partial kitchen equipped ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Located on Maui's world famous Ka'anapali Beach, the Kaanapali Beach Club puts you in vacation paradise courtesy of the resort's prime waterfront location, vibrant tropical landscaping, first-rate amenities and exclusive array of leisure ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Spacious, posh one-bedroom with king bed will be your home base at Kaanapali Beach Club. Your suites comes complete with an in-room refrigerator, oversized tub and separate shower in the bath. Kick back and take in a breathtaking sunrise or ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
