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 ...
- 2 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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Beachfront resort with relaxing spa services
Guests of this beach resort will appreciate convenient onsite amenities such as a spa tub and a fitness center.
Air-conditioned accommodations at this resort offer DVD players and safes. Rooms ...
- 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...
- 2 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 ...
- 2 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
