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 princeville%') AND sleeps>=1 order by rating desc LIMIT 0, 15
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 8
HI> Princeville
Concierge Realty is proud to present luxury villas at Westin Princeville Resort.
Check in on Friday, Saturday, and Sundays only with seven night increments.
Essence of Hawaii
This refreshing resort lies along a lush cliff on the north shore of...
1 bedroom
1 bathroom
Sleeps 4
HI> Princeville
Concierge Realty is proud to present luxury villas at Westin Princeville Resort.
Check in on Friday, Saturday, and Sundays only with seven night increments.
Essence of Hawaii
This refreshing resort lies along a lush cliff on the north shore of...
2 bedroom
2 bathroom
Sleeps 6
HI> Princeville
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 ...
1 bedroom
1 bathroom
Sleeps 4
HI> Princeville
Concierge Realty is proud to present luxury villas at Westin Princeville Resort.
Check in on Friday, Saturday, and Sundays only with seven night increments.
Essence of Hawaii
This refreshing resort lies along a lush cliff on the north shore of...
0 bedroom
1 bathroom
Sleeps 4
HI> Princeville
Enjoy a 1 week stay at the Westin Princeville Ocean Resort Villas timeshare in Kauai.
Please note: A reservation request is not a confirmed booking. Please make sure we confirm your booking before making any travel arrangements. All ...
1 bedroom
1 bathroom
Sleeps 4
HI> Princeville
Beautiful condo overlooking the cliffside with views of the Pacific Ocean in Princeville, Kauai. Two-bedroom lockout with one bedroom and one studio, each with spacious sleeping area, kitchenette with laundry unit included. Can sleep up to ...
2 bedroom
2 bathroom
Sleeps 8
HI> Princeville
The Studio Premium Villa overlooks acres of fragrant wildflowers and offers unparalleled views of the majestic mountains that frame the island's breathtakingly beautiful North Shore. Best of all, each villa features sliding glass doors that lead...
1 bedroom
1 bathroom
Sleeps 1
HI> Princeville
Beautiful condo overlooking the cliffside with views the Pacific Ocean in Princeville, Kauai. Two-bedroom lockout with one bedroom and one studio, each with spacious sleeping area, kitchenette with laundry unit included. Can sleep up to eight....
2 bedroom
2 bathroom
Sleeps 8
HI> Princeville, Kauai
Discover The Westin Princeville Ocean Resort Villas on North Shore Kauai. Situated by Hawaii's pristine beaches and cliffsides, our family-friendly ownership resort is near Anini Beach and a short drive from picturesque Hanalei Lookout. Explore ...
2 bedroom
2 bathroom
Sleeps 8
HI> Princeville
Essence of Hawaii
This refreshing resort lies along a lush cliff on the north shore of Kaua'i and blends into the inspiring beauty surrounding it. Resting two hundred feet above the Pacific Ocean, The Westin Princeville boasts plunge pools ...
1 bedroom
2 bathroom
Sleeps 4
HI> Princeville
This luxurious 2 bedroom oceanfront villa features 1311 sq. ft. of living space and comfortably sleeps up to 8 adults. Unlike most units, this is a fixed 2nd floor hammerhead unit directly oceanfront in building #7. The master bedroom is ...
2 bedroom
2 bathroom
Sleeps 8
HI> Princeville
Discover The Westin Princeville Ocean Resort Villas on North Shore Kauai. Situated by Hawaii's pristine beaches and cliffsides, our family-friendly ownership resort is near Anini Beach and a short drive from picturesque Hanalei Lookout. Explore ...
2 bedroom
2 bathroom
Sleeps 8
HI> Princeville
