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 '%whalers cove%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Luxury waterfront Condo with fantastic view! Unit 135 at Whalers Cove is a waterfront condo. Elegant furnishings and great amenities throughout add to the comfort and enjoyment of its guests.
This gorgeous, upscale Condo resides on the
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Koloa
Important Note: The Whalers Cove pool and hot tub will be temporarily closed from August 15–29, 2025, for necessary repairs. These dates are subject to weather conditions, and while we aim to complete the project within this timeframe, delays
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Koloa
Whalers Cove, overlooking the sparkling Pacific Ocean, is a secluded 32 unit oceanfront hideaway boasting a heated aquamarine pool and a Jacuzzi tub in the master bath. The ultimate luxurious condominium on Kauai! Comfortable and spacious, fully
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
