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 '%Wyndham Ka%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 5 bedroom
- 3 bathroom
- Sleeps 10
Hawaii> Princeville
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
Wyndham Kauai Beach Villas Resort 2 Bedroom Unit Sleeps 6
***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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lihue
Please note this property offers seven-night rentals with arrival days of Fri/Sat/Sun. Contact us directly to inquire on availability for shorter/longer stays or alternate arrival days.
Feel the Anini Bay ocean breezes at your beautiful 2...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 6 bedroom
- 4 bathroom
- Sleeps 12
Hawaii> Princeville
This is a full-service resort. Your check-in procedures will model that of a hotel and your room number will be assigned during check in.
LET THE WAVES BE YOUR COMFORT~
The Coconut Coast in Kauai is the perfect backdrop for ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lihue, Kauai
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 9 bedroom
- 6 bathroom
- Sleeps 18
Hawaii> Lihue
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 9 bedroom
- 6 bathroom
- Sleeps 18
Hawaii> Lihue
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 9 bedroom
- 6 bathroom
- Sleeps 18
Hawaii> Lihue
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 9 bedroom
- 6 bathroom
- Sleeps 18
Hawaii> Lihue
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 6 bedroom
- 4 bathroom
- Sleeps 12
Hawaii> Lihue
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 6 bedroom
- 4 bathroom
- Sleeps 12
Hawaii> Lihue
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 6 bedroom
- 4 bathroom
- Sleeps 12
Hawaii> Lihue
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 6 bedroom
- 4 bathroom
- Sleeps 12
Hawaii> Lihue
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 6 bedroom
- 4 bathroom
- Sleeps 12
Hawaii> Lihue
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 6 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Lihue
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 6 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Lihue
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 6 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Lihue
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 6 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Lihue
Summary:
The Coconut Coast in Kauai is the perfect backdrop for your island adventures. Plus you can choose how urban or outdoorsy your trip will be. Enjoy the benefit of a beachfront resort location with convenient access to the island’s ...
- 6 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Lihue
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 12 bedroom
- 8 bathroom
- Sleeps 24
Hawaii> Princeville
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 12 bedroom
- 8 bathroom
- Sleeps 24
Hawaii> Princeville
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 12 bedroom
- 8 bathroom
- Sleeps 24
Hawaii> Princeville
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 12 bedroom
- 8 bathroom
- Sleeps 24
Hawaii> Princeville
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 12 bedroom
- 8 bathroom
- Sleeps 24
Hawaii> Princeville
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 15 bedroom
- 10 bathroom
- Sleeps 30
Hawaii> Princeville
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 10 bedroom
- 10 bathroom
- Sleeps 30
Hawaii> Princeville
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 15 bedroom
- 10 bathroom
- Sleeps 30
Hawaii> Princeville
Summary:
Escape to a serene South Pacific paradise overlooking the breathtaking Anini Bay on the mesmerizing north shore of Kauai. Our resort offers a tranquil retreat where you can immerse yourself in the natural beauty and tranquility of ...
- 15 bedroom
- 10 bathroom
- Sleeps 30
Hawaii> Princeville
Experience South Pacific paradise at Club Wyndham Ka Eo Kai on Kauai's North Shore. Relax by the tranquil main pool or explore scenic jogging paths in the beautiful Princeville community. Enjoy world-class golf nearby and consult friendly ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
This is a full-service resort. Your check-in procedures will model that of a hotel and your room number will be assigned during check in.
LET THE WAVES BE YOUR COMFORT~
The Coconut Coast in Kauai is the perfect backdrop for ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lihue, Kauai
This is a full-service resort. Your check-in procedures will model that of a hotel and your room number will be assigned during check in.
LET THE WAVES BE YOUR COMFORT~
The Coconut Coast in Kauai is the perfect backdrop for ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lihue, Kauai
Welcome to Club Wyndham Ka Eo Kai Resort – Studio Deluxe Unit
Escape to the serene beauty of Kauai’s North Shore at Club Wyndham Ka Eo Kai Resort, a peaceful retreat in the heart of Princeville. Surrounded by lush tropical landscapes, ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
