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 (`propertyName` like '%Pali Ke Kua%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Escape to Pali Ke Kua 108 and enjoy ocean views and a relaxing environment in this ground floor condo.This bright and sunny condo has an island style, open concept living room, dining room and kitchen, all with beautiful panoramic ocean views. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Princeville
Pali Ke Kua #215
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Admire breathtaking sunset views from your oceanfront lanai at this fabulous ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Relax, Enjoy and soak up the natural beauty of the North Shore of Kauai. This is a great place to create wonderful, unforgettable memories of your honeymoon, family vacation or that special getaway.
Pali Ke Kua 1 is a wonderful 2 bedroom, 2 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Pali Ke Kua Association advised us today that the unit next door 224 will be undergoing renovation starting March 7 through early June, 2022
Pali Ke Kua 223 has amazing views of the ocean, Hanalei, and the most incredible sunsets ever.
Right on ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Pali Ke Kua 214 is a beautifully renovated condo with granite counter tops, cherry wood cabinets, newly redesigned bathrooms and berber carpeting in the living room and bedrooms. This renovation was completed December 2013.
Come and enjoy ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
1 bedroom, 1 bathroom corner unit offering a cozy bamboo motif that resonates old Hawaii and when times were simple. The idyllic getaway from the fast paced crowds, and ultra modern world of hotel rooms. Ocean views from every room. Curl up on ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Princeville
This Pali Ke Kua townhouse condo is located in the town of Princeville on the lush North Shore of Kauai. The North Shore is known for its beautiful tranquil beaches and majestic mountain peaks. The world famous Na Pali Coast is located here on ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
From its oceanfront perch Pali Ke Kua 103 boasts unparalleled panoramic Hanalei Bay, Pacific Ocean and Bali Hai Mountain sunset views. The world class views are said to be the most spectacular in the extraordinarily beautiful North Shore of ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Princeville
Near the edge of a bluff overlooking the ocean, Pali Ke Kua 106 is a favorite with many guests who return each year. Comments in the guest book reflect how much they enjoy vacationing here in their 'home away from home' and some have even said ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Princeville
Beautiful Pali Ke Kua # 109 condo boasts one of the most beautiful views in the world. Reserve your unforgettable Kauai vacation today!
Pali Ke Kua Resort is the perfect spot for a getaway! Located in the heart of Princeville, Kauai, close to ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Princeville
Pali Ke Kua #3
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
With a gorgeous lanai that opens to views of the mountains and the manicured gardens of ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Enjoy the peace and beauty of the expansive Pacific Ocean from your tropical Kauai vacation rental. Pali Ke Kua is a 22-acre resort located on the lush north shore of Kauai, nestled in the upscale and private neighborhood of Princeville. It sits...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Pali Ke Kua 202 boasts spectacular and unbeatable ocean and Bali Hai mountain views!! This Hawaiian Style unit features 2 bedrooms and 2 full baths, comfortable living room area and a fully equipped kitchen. The lanai looks out to the ocean and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Pali Ke Kua #102
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
We invite you to be our guests in our “Iki Māhele O Ka Lani…Little Slice of ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Princeville
Experience stunning panoramic views of the Pacific ocean and Mt. Makana (“Bali Hai”) at this upgraded private & spacious condo in Princeville. This luxe retreat is located near all the attractions the infamous north shore offers. Enjoy the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
