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 '%Nanea Ocean Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 15
GREATLY REDUCED PRICE!! New Year's Eve and January 4 and 5!!
NEW YEAR’S EVE - GREATLY REDUCED PRICE!!
BIG SALE PRICE!!
Large inviting living room, Gorgeous dining room, breathtaking large Master Bd Rm and ensuite bath with a large modern ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> Kaanapali
**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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Spacious two bedroom two bath island view villa, 1,260 sq. ft. residence that features one king bed and one queen bed, queen sleeper sofa, fully equipped kitchen with stainless steel appliances, washer and dryer, furnished lanai. A large ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Two-bedroom, two bath resort view villa, 1,260 sq. ft. residence that features two Westin Heavenly king-size beds, queen sleeper sofa, fully equipped kitchen, washer and dryer, furnished lanai. A large shower, vessel tub and double vanity await ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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....
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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 your interest in booking with Dash Realty Group, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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....
- 0 bedroom
- 0 bathroom
- Sleeps 6
HI> Lahaina
Please choose a Friday through Sunday check-in and enjoy a seven night stay.
Thank you for your interest in booking with Dash Realty Group, Windermere Florida.
Dash Realty Group is registered in Florida as a licensed Fla. Seller of Travel Ref....
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
2 Bedroom Villa 2 King, Sofa bed, Bathrooms: 2, Resort view, Balcony
Retreat into sumptuous luxury in our spacious, 1,260-square-foot two-bedroom villas. Combining signature Westin amenities with the comforts of home, these elevated ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
The Westin Nanea Ocean Villas are located on 16 acres of Maui's famous North Ka'anapali Beach. This puts you at the center of Maui's fun filled local activities and events as well as a variety of world class amenities right outside your villa ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Enjoy ultimate relaxation in this 2 bedroom waterfront villa at the beautiful Westin Nanea. Direct access to the beach (they'll even put up an umbrella for you) as well as a variety of pools great for adults and for children. Views straight out ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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 8
HI> Lahaina
Luxury Villas at Westin Nanea Ocean Villas. Situated on 16 acres of Maui’s of north Kaanapali Beach, The Westin Nanea provides a uniquely relaxing haven replete with culturally inspired programs and authentic Hawaiian experiences.
...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina