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 (city = 'Kekaha' OR postalCode = 'Kekaha' OR region like '%|Kekaha|%') AND sleeps>=1 order by rating desc LIMIT 0, 50
TVNC #4224
3 bedroom
5 bathroom
Sleeps 6
Hawaii> Kekaha
Hale La in Kekaha, Kauai~ TVNC-4251 TA-000-602-1120-01
5 bedroom
5 bathroom
Sleeps 11
Hawaii> Kekaha
Welcome to Hale Makai, our luxury beach home located on the beautiful and sunny west side of Kaua'i. We offer a host of amenities and a picturesque location for a relaxing and unforgettable vacation experience.
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kekaha
PROPERTY OVERVIEW:
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kekaha
TVNC #4224
3 bedroom
5 bathroom
Sleeps 6
Hawaii> Kekaha
TVRNC-1099
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Kekaha
Experience the best of Kauai at our vacation rental! Immerse yourself in the Garden Isle's beauty, boasting stunning beaches, breathtaking sunsets, hiking trails, parks, shopping, golf courses, and an array of island activities like Na Pali
3 bedroom
2 bathroom
Sleeps 4
Hawaii> Kekaha
“Please be informed that this transient vacation rental is located in the tsunami evacuation zone. Please follow the evacuation procedures listed in the photo section and posted at the apartment entrance."
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Kekaha
