select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`headline` like '%Sunset Kahili%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Watch stunning sunsets and the ever-changing ocean from our recently refurbished, bright, and airy unit at Sunset Kahili. This clean and comfortable open-area corner unit has an upgraded kitchen and bathroom with granite counter-tops; ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> 304
A spectacular ocean view from the living room, bedroom, kitchen, and lanai are a few of the features that you enjoy while staying in your paradise getaway. Along with these are a washer and dryer, cable TV and VCR, high-speed Internet (at no ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Koloa
Sunset Kahili 101 is nearly oceanfront on the lovely south shore, in the heart of Kauai's premier resort destination. The new owner has beautifully remodeled this unit with an eye for quality & comfort. Take advantage of the great price on this...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
This home is beautifully remodeled and the Ocean view is spectacular.
This one Bedroom, one Full Bath home is open, spacious, and bright. Gorgeous trade-winds. Dine in style on the large Ocean View Lanai. Also laze away the hours Whale and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Koloa
You will enjoy wonderful ocean views from every room of this beautiful condo. From your private lanai, watch for sea turtles and playful dolphins year-round as well as humpback whales in winter. These gentle giants migrate from Alaska each ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Poipu