select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
Westin Ka'anapali Ocean Resort Villas - Oceanview 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 Point
s:
...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> 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
HI> Lahaina
The Westin Ka'anapali Ocean Resort Villas is a luxurious family-friendly Hawaii timeshare resort located on breathtaking North Ka'anapali Beach. This studio premium villa has a beautiful ocean view. It is elegantly furnished and boasts such ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina, Maui
Concierge Realty is proud to present luxury villas at Westin Ka'anapali Ocean Resort.
Check-in days are Friday, Saturday, Sunday for seven night stays.
Beyond the thoughtfully detailed and exceedingly comfortable Westin Ka'anapali villas ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
**PLEASE READ ENTIRE DESCRIPTION BEFORE REQUESTING RESERVATION**
Book our Amazing Condo & let The Timeshare Brokers, LLC make the booking process easy!
Key Points:
-You’re inquiring on a Timeshare for Rent.
-Please be aware that we ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Imagine yourself sitting on your private Lanai with the Pacific Ocean in front of you as a you sip a Mai-Tai watching the sunset. This is exactly the experience you will get at the Westin Ka'anapali Ocean Resort Villas in beautiful Maui in this...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Concierge Realty is proud to present luxury villas at Westin Ka'anapali Ocean Resort.
Check-in days are Friday, Saturday, Sunday for seven night stays.
Beyond the thoughtfully detailed and exceedingly comfortable Westin Ka'anapali villas ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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. The ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
The Westin Ka'anapali Ocean Resort Villas is a luxurious family-friendly Hawaii timeshare resort located on breathtaking North Ka'anapali Beach. This studio premium villa has a beautiful ocean view. It is elegantly furnished and boasts such ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Concierge Realty is proud to present luxury villas at Westin Ka'anapali Ocean Resort.
Check-in days are Friday, Saturday, Sunday for seven night stays.
Beyond the thoughtfully detailed and exceedingly comfortable Westin Ka'anapali villas ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina, Maui
This island view luxury studio villa sleeps up to 4 with one king sized bed and one queen sized convertible sofa sleeper.
It may be located in either the Westin Kaanapali Ocean Resort Villas North or South.
The villa is equipped with a gourmet...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> 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
HI> Lahaina
You are sure to enjoy a memorable vacation in this fully furnished, spacious retreat in an ocean view studio premium villa at The Westin Ka'anapali Resort Villas. Maui's boundless beauty and activity begin and end here!
The Studio Villa is 480 ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
This villa has a large lanai, TV/DVD/Stereo, a jetted tub, a king bed in a private bedroom and sleeper sofa in the living room, full kitchen with dishwasher, and a washer/dryer. Attached pictures show views from an oceanfront unit.
FREE: Wifi,...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
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 designates it...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> Lahaina
