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 (city = '96703' OR postalCode = '96703' OR region like '%|96703|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Mala Makani TVNC#1149
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Find yourself living the best life surrounded by lush tropical foliage, stunning ...
3 bedroom
4 bathroom
Sleeps 8
HI> Anahola
Hale Aloha… On The Sand TVNC-4185
Anaik Martin, is the property manager, lives nearby and is available 24 hours a day, 7 days a week, (808) 652-3410. Professionally cleaned and disinfected by a licensed ...
6 bedroom
7 bathroom
Sleeps 12
HI> Anahola
This beautiful beachfront Hawaiian-style beach house commands a spectacular 220 degree view of the ocean from every room and from its spacious ocean front lanai. This is Hawaii at it's best. Your own secluded beach spectacular ocean views. ...
2 bedroom
2 bathroom
Sleeps 6
HI> Anahola
Hale Aliomanu- a Private Beachfront Estate Home TVNC-4245
Anaik Matin, property manager, lives nearby and is available 24 hours a day, 7 days a week
Professionally cleaned and disinfected by a licensed company. There are at least 24 hours in ...
6 bedroom
6 bathroom
Sleeps 12
HI> Anahola
A Classic Kauai Cottage on Acres of Beautiful Grounds. Away from developments and the public. More Island Artsy Than Corporate. Watch the sunrise off the ocean horizon from bed. Enjoy quiet time under the shade of the Pink Tacoma
trees in the ...
1 bedroom
1 bathroom
Sleeps 2
HI> Anahola
Mahinani's Farm offers a unique experience for visitors to stay in a peaceful location tucked directly between the mountains and the ocean.
Our Tiny Studio Cabin is surrounded by soft rolling hills, giant royal palms, pines, coconut trees and ...
1 bedroom
1 bathroom
Sleeps 2
HI> Anahola
HALEKAI is privately owned by a Native Hawaiian family. We offer reasonably priced beach front accommodations. Our guests have exclusive use of the property assuring privacy. There are no other units on the property.
Aliomanu Bay offers great...
2 bedroom
2 bathroom
Sleeps 4
HI> Anahola
ONLY A DREAM AWAY...OLD HAWAII'S GIFT OF ALOHA!
With all the vacation rentals to choose from, why should you choose Skipper’s Beach Cabana? The answer is simple: if you want to experience your Kauai vacation in a town setting, choose ...
3 bedroom
3 bathroom
Sleeps 6
HI> Anahola
Hale Makai Beachfront Home located in Anahola on Kaua'i's north-east shore. Convenietly located between the towns of Kilauea to the north and Kapa'a to the east! Step out onto a sandy beach from your back door lanai in Anahola Bay, Kaua'i. We ...
3 bedroom
3 bathroom
Sleeps 6
HI> Anahola
Legally licensed short term vacation rental, TVNC#4308
GET Number: GE-096-531-0976-01; TAT Number: TA-096-531-0976-01
Welcome to your own private Hawaiian paradise!
Enjoy the abundant Aloha at the Ginger Beach House on Anahola Beach. You ...
4 bedroom
4 bathroom
Sleeps 10
HI> Anahola
This impressive home consists of three bedrooms, three baths, and 3,289 Sq Ft. of living space siting on pristine 2.5 acres of white sand beach frontage area. Moloa'a Bay was the site location for the TV pilot of "Gilligan's Island". Here is ...
3 bedroom
3 bathroom
Sleeps 7
HI> Moloaa
Sandcastles TVNCU#1305
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
This majestic home, Sandcastles, is fully equipped with three bedrooms on the main ...
3 bedroom
3 bathroom
Sleeps 6
HI> Anahola
And not only secluded, but only a four and a half minute walk to a gorgeous and private beach! (I know VRBO wrote “six minute walk” in the title, but I measured it once!). Gilligan's Beach Cottage is not like one of the houses packed into ...
1 bedroom
2 bathroom
Sleeps 2
HI> Anahola
At the south end of the property near the entrance is a detached separate 2nd story guest house consisting of 994 square feet of air-conditioned living area with 2 bedrooms plus a loft and 1 bath. On your return from the beach, shower off in the...
1 bedroom
1 bathroom
Sleeps 4
HI> Moloaa
"Hibiscus Hula Beach Cottage". Kauai Vacation Rental, Anahola, Kaua`i, Hawaii.
TAT ID#: TA-092-402-4832-01, TVNC#: 5067. On-island manager, Garden Island Properties LLC.
We have implemented enhanced cleaning and disinfecting guidelines as well...
2 bedroom
1 bathroom
Sleeps 4
HI> Anahola