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, 50
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 are available in weekly (7 night) increments with arrivals and departures on Fridays, Saturdays, and Sundays only.
Newly opened in Spring...
- 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
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
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 6
Hawaii> Lahaina
Three-bedroom villa at The Westin Nanea Ocean Villas. Includes 3 king beds, 1 sofa bed, 2 bathrooms, full kitchen, and washer/dryer. Sleeps 8. Situated on 16 acres of Maui's North Kā‘anapali Beach, The Westin Nanea Ocean Villas provides a ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
One-bedroom villa at The Westin Nanea Ocean Villas. Includes 1 king bed, 1 sofa bed, 1 bathroom, full kitchen and washer/dryer. Sleeps 4. Situated on 16 acres of Maui's North Kā‘anapali Beach, The Westin Nanea Ocean Villas provides a uniquely...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing rates to direct resort bookings.
Units are managed and maintained by the resort. Upon arrival, guests will check in at the resort’s ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
No resort fee, no parking fee!
Opening in 2017, Westin Nanea is the last and final beach front opening in Kaanapali. Retreat into sumptuous luxury in our spacious, 1,260-square-foot two-bedroom villas. Combining signature Westin amenities...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Equisite - Westin Kaanapali Ocean Resort Villas - Full Resort Access
Attention to detail is what makes the Westin Ka'anapali Ocean Resort Villas such a remarkable resort. Perched on 26 lush acres with breathtaking views of the Pacific ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Lahaina
Unwind and build lasting memories in this lovely 2 bedroom villa situated on Maui's North Kā'anapali Beach. This property offers a great escape with full resort amenities. Each room is configured with a king bed, while the living room ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Marriottu2019s Maui Ocean Club - Lahaina Villas is one of the most popular timeshare resorts - and for good reason! Kids and kids-at-heart will get a kick out of the resort's 3.5-acre super pool complete with a water slide, waterfalls, and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
A state of relaxation and repose - firsthand at The Westin Nanea Ocean Villas! Set on twenty-six acres of lush, tropical land and infused with a variety of Hawaiian design elements, The Westin Nanea Ocean Villas blends a top-notch vacation ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Experience - a state of relaxation and repose - firsthand at The Westin Nanea Ocean Villas! Set on twenty-six acres of lush, tropical land and infused with a variety of Hawaiian design elements, The Westin Nanea Ocean Villas blends a top-notch ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy the glamour of this stylish, upscale place. Experience u201cNaneau201d - a state of relaxation and repose - firsthand at The Westin Nanea Ocean Villas! Set on twenty-six acres of lush, tropical land and infused with a variety of Hawaiian ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
This delightful two-bedroom provides the perfect respite for the whole family.
Zipline across jungle, snorkel with the dolphins, and rediscover your best self in year-round-gorgeous Maui. Jeweled with spectacular beaches and adorned with ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Cozy yet spacious. Intimate yet extensive. This one-bedroom features luxurious comfort for memories together and space to escape.
Zipline across jungle, snorkel with the dolphins, and rediscover your best self in year-round-gorgeous ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
With three wonderfully-appointed bedrooms and space to spare, this deluxe suite is a flawless respite for all your guests.
Zipline across jungle, snorkel with the dolphins, and rediscover your best self in year-round-gorgeous Maui. ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Concierge Realty is proud to present luxury villas at Westin Nanea Ocean Villas.
Reservations are available in weekly (7 night) increments with arrivals and departures on Fridays, Saturdays, and Sundays only.
Newly opened in Spring...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Welcome to the deluxe accommodations offered at the Westin Nanea Resort just North of Whalers Village & Lahaina. This lovely comprehensive tropical resort features 2 king size heavenly beds in each of the 2 bedrooms, blackout curtains for that ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Nestled in Lahaina, this delightful resort offers 2 bedrooms with 2 king beds, 2 bathrooms with a jetted bathtub, and a cozy living room with a sofa bed. Guests can enjoy amenities like AC, WiFi, and a fitness room during their stay. The serene ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
This vacation villa is located at the impressive Westin Nanea Ocean Resort on famous Ka'anapali beach, in west Maui. It is a modern ocean front paradise with a fun boardwalk along the gorgeous beach. The Villa has access to all resort amenities...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Entire place
You'll have the entire condo to yourself and will only share it with other guests in your party.
The Westin Nanea Ocean Villas, Ka'anapali
At The Westin Nanea Ocean Villas, Ka'anapali, spend the day on the beach where ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
