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 '%Kauai Kailani%') AND sleeps>=1 order by rating desc LIMIT 0, 15
GOOD NEWS! Hawaii is open for travelers! Make sure you get a negative covid test within 72 hours of arrival and check all of the details on the Hawaii.gov website so you can have a safe an successful trip to Kaua'i.
PROPERTY DESCRIPTION
You've...
- 2 bedroom
- 1 bathroom
- Sleeps 6
HI> Kapaa
Open design and ground floor ease make this 635sf suite overlooking the pool a dreamy home away from home. Step from the lanai onto the tropical grounds for a walk after sharing nosh prepped in the modern kitchen. Perks include ceiling fans, ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
HI> KAPAA
You may never want to leave the oceanfront lanai of this 864 sq ft Kauai vacation home! Prepare meals in the upgraded kitchen with dishwasher, and then relax with WiFi and a flat screen TV. Other conveniences include a private den and ceiling ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> KAPAA
Cozy and contemporary, with wonderful views of the pool and landscaped grounds, this 684sf condo offers tasteful décor and furnishings. Enjoy a flat screen TV, WiFi, ceiling fans, private den and modern kitchen for cooking meals to share on the...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> KAPAA
Kauai Kailani Unit#213 is an ocean-front unit with wonderful ocean views. It is on the second floor, served by an elevator, and has two bedrooms and one bath. The remodeled open kitchen is fully stocked with dishes and cookware and features ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> KAPAA