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:
Wouldn’t it be fun if Jurassic Park were real? This resort is the next best thing (think luscious jungle without the ferocious dinosaurs). The island of Kauai provided the background for the iconic Hollywood film, but this resort ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapa?a
Summary:
Wouldn’t it be fun if Jurassic Park were real? This resort is the next best thing (think luscious jungle without the ferocious dinosaurs). The island of Kauai provided the background for the iconic Hollywood film, but this resort ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapa?a
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
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
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
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
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
On the northern shore of Kauai, there's a beautiful plateau overlooking romantic Hanalei Bay. Amidst this splendor, you'll find the smaller and more private paradise of Ka'Eo Kai. This unit is huge with 1700 sq ft. A stroll along its winding ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
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
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
You’ll love the stylish decor of this charming place to stay. Club Wyndham Ka 'Eo Kai is nestled amid winding paths, tumbling waterfalls, bubbling streams and verdant gardens all overlooking Hanalei Bay. This resort feels more like an oasis ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
