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 '%Nanea Ocean Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Luxurious 2BR- 2 Bath Unit; Resort view, full resort access. Oceanfront at Ka'anapali. Offered for 7 nights from from Friday, December 22 to Friday, December 29, 2023 AND in 2024 from Friday December 20 to Friday December 27.
...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Concierge Realty is proud to present luxury villas at Westin Nanea Ocean Villas.
RESERVATIONS AVAILABLE IN SEVEN NIGHT INCREMENTS ONLY WITH CHECK-INS ON FRIDAYS, SATURDAYS or SUNDAYS.
Newly opened in Spring of 2017, this stunning ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Westin Nanea Ocean Villas - 1 Bedroom Unit Sleeps 4
***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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Please choose a Friday through Sunday check-in and enjoy a seven-night stay. Please use the "Ask Manager A Question" option prior to booking for accurate rates/availability.
Thank you for choosing Dash Realty Group of Windermere, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Beautiful Condo/Villa with Views, with easily accessible beach on 16 acres of resort in Lahaina, Maui, HI. Two-bedroom with two baths, with spacious sleeping area, kitchenette with laundry unit included. Can sleep up to six. Perfect space to ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Stunning Oceanfront Two Bedroom/Two Bath Condo. Guaranteed Unit #8410 (Fourth Floor, Oceanfront Center Unit). Huge Oceanfront Lanai/Balcony off the Living Room. Both bedrooms are likewise oceanfront -- both squarely and fully face the ocean....
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
An incredible oasis set next to a protected park, Westin Nanea Ocean Villas are built with amazing attention to detail and comfort. The two bedroom 1260 sq. ft. villas have two private Heavenly King bed rooms with thier own on-suite bathrooms....
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Westin Nanea Ocean Villas- 3 Bedroom Unit Sleeps 8-9!
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” BUTTON***
🌴 Escape to Paradise: Book Your Dream Vacation
📣 Important: Please Use the ...
- 4 bedroom
- 2 bathroom
- Sleeps 10
Hawaii> Lahaina
The Westin Nanea Villas is Kaanapali’s newest beachfront resort. The resort features 390 elegantly appointed 1, 2, and 3 bedroom modern luxury villas. Explore the area’s many sights and attractions from the Westin’s prime West Maui ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Westin Nanea Ocean Villas - 3 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 booking process ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Westin Nanea Ocean 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 Use the ...
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
Grand one-to-three-bedroom villas, each with private balconies, separate living/dining areas and plush bedding assure a heavenly repose.
Zipline across jungle, snorkel with the dolphins, and rediscover your best self in ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
This is an owner offering a 7-night stay for check-in on July 5, 2024.
The Westin Nanea Ocean Villas offers two types of view categories: Island or Oceanfront. This specific offering is for an Island view. Not an Oceanfront ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Two Bedroom Villa picturesque Maui Views from furnished private lanai. New stainless steel appliances, washer and dryer, Kitchen fully equipped. Enjoy whale-watching, snorkeling wind surfing scuba diving just steps away....
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maui
Grand one-to-three-bedroom villas, each with private balconies, separate living/dining areas and plush bedding assure a heavenly repose.
Zipline across jungle, snorkel with the dolphins, and rediscover your best self in ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Situated near Historic Lahaina Town, The Westin Nanea Ocean Villas, Ka'anapali is near Kahekili Beach Park, The Forbidden Coast and other attractions in Maui, Hawaii. This family-friendly beach resort is a short drive from museums, shops and ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
