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, 20
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
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 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
- 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
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
Westin Ka'anapali Ocean Resort Villas - 2 Bedroom Unit Sleeps 8
***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 ...
- 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
Westin Ka'anapali Ocean Resort Villas - 2 Bedroom Unit Sleeps 8!
*Stays starting on Friday, Saturday, or Sunday. *
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
Book our Amazing ...
- 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
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
