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 '%Alihi Lani%') AND sleeps>=1 order by rating desc LIMIT 0, 15
ALIHI LANI. This small, six unit complex called a 'Real Gem' by the Ultimate Kauai Guidebook. Enjoy endless views from our oceanfront pool. The front landscaped area also has two gas grills and comfy lawn furniture. We are named 'Premier Hosts' ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
ALIHI LANI. This small, 6 unit complex is a 'Real Gem', according to the Ultimate Kauai Guidebook. Enjoy endless views from our oceanfront pool. The front landscaped area also has two gas grills and comfy lawn furniture.
OCEANFRONT. Our premium...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Koloa
This incredible Ocean Front Home is the height of Poipu Luxury!
Two Bedrooms and Two full Bathrooms, with vast Ocean View and Spectacular Sunsets. Boutique Community offering only 6 homes. Private, quite and gorgeous!...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Koloa
May we welcome you to Alihi Lani at Poipu. Our beautiful, condominiums located in the heart of Kauai's sunny south shore! Alihi Lani. or 'Beautiful Horizon Views', aptly describes the magnificent ocean panorama of Hawaiian sunsets, majestic ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Poipu
You will love the expansive and breath taking Ocean View. Alihi Lani is a private boutique condo community with the use of the gorgeous Poipu Athletic Club. The home is ground floor, and a corner unit. This spacious condo with two master ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Koloa
