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, 50
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...
- 3 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina, Maui
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...
- 2 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 ...
- 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 ...
- 1 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...
- 3 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...
- 2 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...
- 3 bedroom
- 2 bathroom
- Sleeps 9
Hawaii> Lahaina
Facing the beachfront, The Westin Ka'anapali Ocean Resort Villas offers 4-star accommodations in Lahaina and features free bikes, fitness center and garden. Providing a restaurant, the property also has a terrace, as well as a sauna and a hot ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
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 ...
- 3 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 ...
- 3 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
The Westin Ka'anapali Ocean Resort Villas North
**************************************************************
Island view two-bedroom 1,230 square feet lockoff villa.
Features:
One-bedroom side of lockoff (750 square feet ...
- 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...
- 3 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 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
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
Luxurious 1 Bedroom Premium Villa at the Westin Kaanapali Resort Villas. Call for availability. All dates not available.
This luxurious one bedroom Island View villa features 750 square foot of interior living space and spectacular ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Only $469 a night (SAVE $470 usually $939 per night), that is about a 50% discount for the WESTIN Ka'anapali Ocean Resort Villas when booked as a week. $3,287. for 02/09/25 to 02/16/25. This is the only week and there are no changes in dates ...
- 1 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
- 1 bathroom
- Sleeps 4
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: ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Westin Ka'anapali Ocean Resort Beautiful 1 Bedroom OCEAN VIEW!
***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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Westin Kaanapali Ocean Resort Villas, Maui, Hawaii.
This Unit is an Oceanfront Unit -- on the beach -- not simply ocean view.
Likewise, within the Oceanfront category in this Westin complex, this unit is premier.
You are ...
- 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
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 North.
The villa is equipped with a gourmet ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Step up to a Ka'anapali vacation and embrace a welcoming abundance of resort amenities at The Westin Ka'anapali Ocean Resort Villas . While you can enjoy whale watching, snorkeling, sailing, windsurfing and scuba diving just steps away, there ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
A truly unforgettable getaway awaits you at The Westin Ka’anapali Ocean Resort Villas North. Discover the island of Maui's breathtaking beauty, culture and unique activities during your stay. Our resort boasts an ideal location between the ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Luxurious Oceanview Studio at the Westin Ka'anapali Resort Villas North!
This luxurious studio villa features 480 square foot of interior living space and affords delightful views of the Pacific Ocean. Enjoy the warm tropical breeze ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Set between North Ka’anapali Beach and the mountains of West Maui, this Lahaina, Hawaii resort features 6 outdoor pools. It has spacious villas with views of the ocean or island.
Westin Ka’anapali Ocean Resort Villas offers modern ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
Enjoy a luxury stay at a fraction of the price. You can save over 50% of the price when comparing my rate with a booking directly with the resort. I am unable to travel this year so take advantage of my ownership week at such a great price. If ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Spread out with the whole family in this spacious two-bedroom suite. If the majesty of Maui’s beaches and mountains weren’t enough to sell you on a trip to Hawaii, perhaps the allure of this world-class wellness resort will tip the scale. ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Welcome to the deluxe accommodations offered at the Westin Resort loc just North of Whalers Village & Lahaina. This lovely comprehensive tropical resort features a king size Heavenly bed in this premium BEACHFRONT 1 bedroom Suite, a sofa bed in ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Welcome to the deluxe accommodations offered at the Westin OCEAN VIEW resort just North of Whalers Village & Lahaina. This lovely comprehensive tropical resort features 2 king bedrooms, 2 sofa beds, 3 flat screen tv's, 2 full bathrooms each with...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
This delightful two-bedroom provides the perfect respite for the whole family.Tune out the grind and live your best life on gorgeous Maui, where pristine beaches and towering volcanic peaks combine for a natural setting that will take your ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Settle into the lap of luxury, where plush bedding assures pampered restfulness for the weary traveler.If the majesty of Maui’s beaches and mountains weren’t enough to sell you on a trip to Hawaii, perhaps the allure of this world-class ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Settle into the lap of luxury, where plush bedding assures pampered restfulness for the weary traveler.If the majesty of Maui’s beaches and mountains weren’t enough to sell you on a trip to Hawaii, perhaps the allure of this world-class ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
