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, 30
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 ...
- 0 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 4
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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 ...
- 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 ...
- 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 ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
Wyndham Kauai Beach Villas Resort 2 Bedroom Unit Sleeps 6
**PLEASE READ ENTIRE DESCRIPTION BEFORE REQUESTING RESERVATION**
Book our Amazing Timeshare & let The Timeshare Brokers, LLC make the booking process easy!
Key ...
- 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 ...
- 0 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 ...
- 0 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 ...
- 0 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 ...
- 0 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 ...
- 1 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 ...
- 1 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 ...
- 1 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 ...
- 1 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 ...
- 1 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 ...
- 1 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 ...
- 1 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 ...
- 1 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 ...
- 1 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 ...
- 1 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
