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
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
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
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
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
STUDIO PREMIUM VILLA
480 SQUARE FEET* • SLEEPS UP TO 4 ADULTS
The guest side of your lockoff villa comfortably sleeps up to four adults and features these amenities:
King-sized Westin Heavenly® Bed
Westin Heavenly® ...
- 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
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
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
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
Settle into the lap of luxury, where plush bedding assures pampered restfulness for the weary traveler.Tune out the grind and live your best life on gorgeous Maui, where pristine beaches and towering volcanic peaks combine for a natural setting ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Cozy yet spacious. Intimate yet extensive. This one-bedroom features luxurious comfort for memories together and space to escape.Tune out the grind and live your best life on gorgeous Maui, where pristine beaches and towering volcanic peaks ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Spread out with the whole family in this spacious two-bedroom suite.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 breath away. ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Find your bliss in this luxurious space, where unequaled comfort provides an intimate refuge. 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...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Settle into the lap of luxury, where plush bedding assures pampered restfulness for the weary traveler. Tune out the grind and live your best life on gorgeous Maui, where pristine beaches and towering volcanic peaks combine for a natural setting...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Spread out with the whole family in this spacious two-bedroom suite.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 breath away. ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
