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, rewritten_description,
(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:
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
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
