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,
(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, 20
County of Kauai Vacation Rental License # TVNC-1076 - State of Hawaii Business Registration #s GE-047-578-3168-01 & TA-047-578-3168-01 - 24 hr guest contact: Keenan Driver @ 808-639-0772 (Guest emergencies only) Emergency # is also listed ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Kekaha
County of Kauai Rental License # TVNC 1074 - State of Hawaii Business Registration #s GE-075-701-4528-01 & TA-075-701-4528-01 - 24 hr guest contact: Keenan Driver @ 808-639-0772. Please do not call this # to book reservations.
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Kekaha
TVNC #4224
3 bedroom
5 bathroom
Sleeps 6
Hawaii> Kekaha
Hale La in Kekaha, Kauai~ TVNC-4251
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
County of Kauai License #TVNC 1188 - State of Hawaii Business Registration #s GE-143-222-7840-01 & TA-143-222-7840-01 - 24 hour guest contact: Keenan Driver @ 808-639-0772 (guest emergencies only) Please do not call this # to book ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kekaha
PROPERTY OVERVIEW:
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kekaha
** This property is an approved vacation rental Licensed by the County of Kauai. #TVNC-5007 **24 HOUR GUEST CONTACT: Keenan Driver 808-639-0772 (guest emergencies only) Please do not call this # to book reservations
3 bedroom
5 bathroom
Sleeps 6
Hawaii> Kekaha
This wonderful 3 bedroom, 2 bath for 8 Kekaha beach house, is located just 200 yards to the beach, just blocks from fabulous Kekaha Beach park, and just a 7 min drive to the road to the famous Polihale Coast! Kekah gets the least amount of rain ...
3 bedroom
4 bathroom
Sleeps 8
Hawaii> Kekaha
TVNC #4224
3 bedroom
5 bathroom
Sleeps 6
Hawaii> Kekaha
County of Kauai Vacation Rental License # TVNC 1099 - Hawaii Tax License #s GE-142-306-3552-01 & TA-142-306-3552-01 - 24 hr guest contact: Keenan Driver (808) 639-0772 (guest emergencies only) Please do NOT call this # to book ...
4 bedroom
4 bathroom
Sleeps 8
Hawaii> Kekaha
** This property is an approved vacation rental Licensed by the County of Kauai. Vacation Rental License # TVNC-5162 - State of Hawaii Business Registration #s GE-090-878-8736-01 & TA-090-878-8736-01. 24 hr guest contact: Keenan Driver @ ...
4 bedroom
4 bathroom
Sleeps 8
Hawaii> Kekaha
County of Kauai Vacation Rental License # TVNC 1358 - State of Hawaii Business Registration #s GE-061-616-9472-01 & TA-061-616-9472-01- 24 hr guest contact: Keenan Driver @ 808-639-0772 (guest emergencies only) Please do not call this # ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Kekaha
County of Kauai Rental License # TVNC 1004
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Kekaha
County of Kauai Vacation Rental License # TVNC 1100 - State of Hawaii Business Registration #s GE-058-798-3360-01 & TA-058-798-3360-01 - 24 hr. contact: Keenan Driver @ 808-639-0772 (For emergencies ONLY…please contact property manager by...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kekaha
This will truly be your home away from home vacation! Nestled in a quiet residential neighborhood, you'll be immersed in Kaua'i's ~island time~. Enjoy the less than two minute to walk to the beach for the unobstructed view of Ni'ihau and the ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Kekaha
County of Kauai Vacation Rental License # TVNC-5016 - State of Hawaii Business Registration #s GE-031-969-0752-01 & TA-031-969-0752-01
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Kekaha
County of Kauai Rental License # TVNC 4207 - State of Hawaii Business Registration # GE-057-536-1024-01 & TA-057-536-1024-01 - 24 Hour contact Cindy Driver 808-635-8252. (emergencies only). Please contact the property manager online for ...
2 bedroom
2 bathroom
Sleeps 5
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
** This property is an approved vacation rental Licensed by the County of Kauai. #TVNC-5005 ** - State of Hawaii Business Registration #s GE-136-502-6816-01 & TA-136-502-6816-01 - 24 HOUR GUEST CONTACT: Keenan Driver @ 808-639-0772 (guest ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kekaha
