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 '%lani kai%') AND sleeps>=1 order by rating desc LIMIT 0, 15
This charming, ground-floor condo is perfect for a couple or individual who likes everything at their fingertips. Here, you can enjoy the convenience of a beautiful pool just a few steps from your private lanai. Begin each and every day of your ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Wailua
Enjoy this prime Poipu location and be only steps from popular Poipu Beach Park and Brennecke's beach! Nestled along a private side road with only access to the neighboring homes, you will enjoy being in the heart of Poipu Beach yet love the ...
- 2 bedroom
- 4 bathroom
- Sleeps 7
HI> Koloa
Located beachfront on the enchanting Hanalei Bay, Lani Kai ("Heavenly Ocean Home") is a newly remodeled four bedroom, three bathroom home ideal for a large family or couples traveling together wanting some well-deserved space. Recent renovations...
- 4 bedroom
- 3 bathroom
- Sleeps 8
HI> Hanalei
Oceanfront and impeccably furnished, this delightful condominium is conveniently located on the scenic Coconut Coast of Kauai's east side. Surrounded by gentle ocean breezes and swaying palm trees, the large lanai off the living area and front ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Wailua