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 '%Westin Ka\'anapali Ocean%') AND sleeps>=1 order by rating desc LIMIT 0, 30
Spectacular Westin amenities. Excellent Ka'Anapali beach, beachfront location in Lahaina. Accommodates up to 5 people. Perfect for rest, relaxation and fun. Enjoyable and fantastic pools with slide. Heavenly Westin bed and sofa sleeper, may ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> LAHAINA, MAUI
Westin Ka'anapali Ocean Resort Villas - Oceanview 2 Bedroom Unit Sleeps 8
***PLEASE MESSAGE HOST WITH ANY QUESTIONS YOU HAVE BEFORE 'INSTANT BOOKING' AND WE WILL PROMPTLY REPLY***
The Listing photos are stock photos that the resort...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Can book other dates just contact me first... Thanks
Spend one week in a beautiful OCEAN VIEW DELUXE VILLA at the Westin Ka'anapali Ocean Resort Villas. One of the deluxe ocean view units just steps from the beach, awesome ocean views. ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
One-Bedroom Villa (840 s.f.). In-suite kitchen & dining facility, TV & Wifi, laundry washer & dryer. Resort fees are included. The resort offers a full range of amenities and services: oceanfront swimming pools, hot pools, whirlpools, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Westin Ka'anapali Ocean Resort Villas - Ocean View 2 Bedroom Unit Sleeps 8
**PLEASE READ ENTIRE DESCRIPTION BEFORE REQUESTING RESERVATION**
Book our Amazing Condo & let The Timeshare Brokers, LLC make the booking process easy!
Key ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
The Westin Ka'anapali Ocean Resort Villas is a luxurious family-friendly Hawaii timeshare resort located on breathtaking North Ka'anapali Beach in Maui. This studio premium villa has a beautiful ocean view. It is elegantly furnished and boasts ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina, Maui
Westin Kaanapali Ocean Resort Villas, Lahaina, Maui, Hawaii.
This Unit is an Oceanfront Deluxe unit -- on the beach -- not simply ocean view.
Likewise, within the Oceanfront category, this unit is the premier unit. Hence, Westin ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Concierge Realty is proud to present luxury villas at Westin Ka'anapali Ocean Resort.
We are able to offer 7 night weekly rentals with check-in on Fridays, Saturdays, and Sundays only. This ad is for Sunday check-in only. Please inquire ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Enjoy a luxurious stay at this beautiful resort located on Ka'anapali Beach in Maui. It has gorgeous views of the Pacific Ocean and the islands of Lana'i and Moloka'i. You can relax by any of several pools while your children play in the kiddie...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Westin Ka'anapali Ocean Resort- 1 Bedroom Villa Sleeps 4!
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” BUTTON***
🌴 Escape to Paradise: Book Your Dream Vacation
📣 Important: Please Use ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
This island view luxury studio villa sleeps up to 4 with one king sized bed and one queen sized convertible sofa sleeper.
It is located in the Westin Kaanapali Ocean Resort Villas South.
The villa is equipped with a gourmet ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Westin Ka'anapali Ocean Resort Villas - 2 Bedroom Unit Sleeps 8
**PLEASE READ ENTIRE DESCRIPTION BEFORE REQUESTING RESERVATION**
Book our Amazing Condo & let The Timeshare Brokers, LLC make the booking process easy!
Key ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
The Westin Ka'anapali Ocean Resort Villas is a luxurious family-friendly Hawaiian timeshare resort located on breathtaking North Ka'anapali Beach in Maui. This studio premium villa has a beautiful ocean view. It is elegantly furnished and ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Bellani Vacations is pleased to offer luxury 2 bedroom villas at Westin Ka'anapali Ocean Resort Villas
Choose a Friday, Saturday, or Sunday for check in, and enjoy a 7 night stay. Please "Contact Host" to confirm availability, as the Vrbo...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Bellani Vacations is proud to offer 1 bedroom villas at Westin Ka'anapali Ocean Resort Villas
Choose a Friday, Saturday, or Sunday for check in, and enjoy a 7 night stay. Please "Contact Host" to confirm availability, as the Vrbo calendar...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Westin Ka'anapali Ocean Resort Villas - 2 Bedroom Unit Sleeps 9 with a rollaway bed/cot!
If rollaway bed/cot is needed, be advised that $30/day will be paid to the resort directly upon check out and needs to be requested/reserved prior to...
- 2 bedroom
- 2 bathroom
- Sleeps 9
Hawaii> Lahaina
Westin Ka'anapali Ocean Resort- 2 Bedroom Unit Sleeps 8! Stays starting on FRI,SAT, or SUN.
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” BUTTON***
🌴 Escape to Paradise: Book Your Dream ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Westin Ka'anapali 2 Bedroom Island View Sleeps 8
***PLEASE MESSAGE HOST WITH ANY QUESTIONS YOU HAVE BEFORE 'INSTANT BOOKING' AND WE WILL PROMPTLY REPLY***
The Listing photos are stock photos that the resort provides as all ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
***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 the booking process simple!
Before making a reservation request, kindly ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Welcome home to The Westin Ka'anapali Ocean Resort Villas and enjoy the luxury you deserve on vacation! The Westin Villas property is legendary with amazing pools coupled with an incredible location on prestigious North Ka'anapali Beach. This ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
OFFERING A GREATLY DISCOUNTED RATE DURING PREMIUM SEASON for this luxurious 2- bedroom 2 bathroom "adjoining" lock off OCEAN VIEW villa! Christmas in Hawaii!! DATES FOR 2024: Check in December 22, 2024 - Check out December 29, 2024.Total of 7 ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Westin Ka'anapali Ocean Resort Villas - 2 Bedroom Unit Sleeps 8!
*Stays starting on Friday, Saturday, or Sunday. *
**PLEASE READ ENTIRE DESCRIPTION BEFORE REQUESTING RESERVATION**
Book our Amazing Condo & let The Timeshare ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
PLEASE CHOOSE A FRIDAY THROUGH SUNDAY CHECK-IN DATE AND ENJOY A SEVEN-NIGHT STAY. ALL VACATIONS WILL BE IN SEVEN-NIGHT INCREMENTS.
Thank you for choosing Dash Realty Group of Windermere, Florida. We are a registered Fla. Seller of ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Westin Ka'anapali Ocean Resort- 2 Bedroom Unit Sleeps 8! Stays starting on FRI,SAT, or SUN.
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” BUTTON***
🌴 Escape to Paradise: Book Your Dream ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
2 Bedroom Direct Oceanfront Villa at The Westin Kaanapali Ocean Resort.
Two bedroom, two bathroom 1400 square foot villa featuring large balconies set off master bedroom and guest room with direct ocean front view of the Pacific and the...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Westin Ka'anapali Ocean Resort Villas- 1 Bedroom Unit Sleeps 4!
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” BUTTON***
🌴 Escape to Paradise: Book Your Dream Vacation
📣 Important: Please...
- 1 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Lahaina
Westin Ka'anapali Ocean Resort- 2 Bedroom Unit Sleeps 8 Ocean Front
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” BUTTON***
🌴 Escape to Paradise: Book Your Dream Vacation
📣 Important: ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Westin Ka'anapali Ocean Resort Beautiful 1 Bedroom OCEAN VIEW!
**PLEASE READ ENTIRE DESCRIPTION BEFORE REQUESTING RESERVATION**
*Stays starting on Fri, Sat, or Sun*
Book our Amazing Condo & let The Timeshare Brokers, LLC...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Westin Ka'anapali Ocean Resort Villas - 2 Bedroom Unit Sleeps 8!!
**Stays starting on Fri, Sat, or Sun**
*Please note that views depicted in pictures are not reflective of the unit view as units are assigned by the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay at this beautiful resort located on Ka'anapali Beach in Maui. It has gorgeous views of the Pacific Ocean and the islands of Lana'i and Moloka'i. You can relax by any of several pools while your children play in the kiddie ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
