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, 50
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. Be ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Kekaha
TVNC #4224 This one of a kind tropical gated oceanfront Luxury Estate offers the ultimate in beachfront island living and privacy on over an acre . With breathtaking ocean views and lush scent filled landscaping. The attention to ...
3 bedroom
5 bathroom
Sleeps 6
Hawaii> Kekaha
Hale La in Kekaha, Kauai~ TVNC-4251 Imagine spending your next vacation at one of the most beautiful properties on Kauai! Your days are filled with exploring miles of white sand beaches steps from your luxury vacation home, hiking the ...
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. Take your pick of ...
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: House, 2 Bedrooms, 1.25 Baths, (Sleeps 4) The Nene Nest, Kauai is a classic, sugar plantation- style cottage located on the always sunny West Side of Kauai. Just 152 steps from the ocean, it offers a true ...
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 Be advised: This ...
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 This is truly a one of a kind Hawaiian dream home. Stroll down the sand beach and find Hawaiian Paradise set on over an acre of beautiful tropical beachfront landscaping. This approx 5000 sq ft gated home has all the ...
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 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 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 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 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 ...
3 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
County of Kauai Rental License # TVNC 1004 State of Hawaii Business Registration #s GE-057-536-1024-01 & TA-057-536-1024-01 24 Hour contact (for emergencies only) is Cindy Driver @ 808-635-8252. Be advised: This transient vacation...
2 bedroom
1 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
“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." For your at-the-beach ...
1 bedroom
1 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