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 (`propertyName` like '%Pali Ke Kua%') AND sleeps>=1 order by rating desc LIMIT 0, 30
PLEASE NOTE: We do NOT normally accept reservations for a duration of more than 30 days. If you are looking for a longer term reservation, please inquire first.
Beautiful Princeville Pali Ke Kua condo perched on a cliff overlooking Bali ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Pali Ke Kua #205, Princeville
Make yourself comfortable and relax as you enjoy the spectacular ocean and Makana Mountain views from Pali Ke Kua #205, located within the highly sought-after resort town of Princeville. Settle into island ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Near the edge of a bluff overlooking the ocean, this ground-floor condominium offers fabulous ocean and coastline views. Bali Hai, the landmark mountain made famous in "South Pacific," is just one of the awesome sights that guests enjoy here. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
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
Hawaii> Princeville
Pali Ke Kua 207, located in the exclusive neighborhood of Princeville on the North Shore of Kaua’i, is a resort condominium perched on top of a bluff 200 feet above the crystalline Pacific Ocean. Perfect for couples and small families, this ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Absolutely the best location in Princeville...can you say Paradise! Stunning Ocean views!
The condo is beautifully decorated with high end furnishings to help you relax as you take in the outrageous views and crashing surf below. This ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Pali Ke Kua #222, Princeville
Ideally located above the edge of the striking ocean bluffs of Princeville, Pali Ke Kua #222 has all of the features you could want in your island getaway with the benefit of stunning ocean views.
You...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Princeville
1 bedroom, 1 bathroom corner unit offering a cozy bamboo motif that resonates with 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...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
Pali Ke Kua #141, Princeville
Panoramic ocean and mountain views await you at Pali Ke Kua #141.
Spectacular Bali Hai sunsets and seasonal whale watching are all steps away from this 2-bedroom, 2-bath ground-floor unit. The ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Princeville
Pali Ke Kua #242, Princeville
Ideally located above the edge of the striking ocean bluffs of Princeville, Pali Ke Kua #242 has all of the features you could want in your island getaway with the benefit of stunning ocean views.
The...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Pali Ke Kua 113
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
This is what you think of when you think of Kauai: beautiful sunsets over the ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
Experiencing life in Pali Ke Kua is like nothing else on earth. This resort community is situated on the north shore of the picturesque island of Kauai, allowing you to enjoy the sweeping views of the Bali Hai Mountains while relaxing on your ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
When you walk through our newest Princeville condo at Pali Ke Kua, you’ll find a perfect match between its soothing colors, generous space and dazzling ocean views from the great room, kitchen and dining area. Step outside on the lanai and you...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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 on the extraordinarily beautiful North Shore of ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
When you walk through our newest Princeville condo at Pali Ke Kua, you’ll find a perfect match between its soothing colors, generous space and dazzling ocean views from the great room, kitchen and dining area. Step outside on the lanai and you...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
This beautiful ground floor condo has undergone a COMPLETE REMODEL!
The beautiful remodel features Quartzite counters. All new cabinets, Kitchen Aid stainless steel oven and dishwasher, along with a Café refrigerator. Beautiful new ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> Princeville
Pali Ke Kua #12, Princeville
Pali Ke Kua #12 is a 2 bedroom/2 bath condo, located in a park-like setting on the tropical grounds of the Pali Ke Kua complex in the residential and prestigious resort community of Princeville.
Open ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Perched on an ocean bluff near Hanalei Bay, Pali Ke Kua Unit #241 is a one-bedroom + loft, two-bath, second-floor unit with sweeping ocean views.
As of July 2021, there are 3 AC units in the condo. Please note this condo does not have ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
E Komo Mai (Welcome) to Pali Ke Kua 123! Situated on a bluff overlooking the Pacific Ocean, this remarkable vacation rental offers a front-row view of the majestic Makana mountain and some of the most iconic beaches on the North Shore of...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Pali Ke Kua is a 22-acre resort condominium project located on the lush north shore of Kauai, nestled in the upscale and private neighborhood of Princeville. It sits on a bluff 200 feet above the ocean and has breathtaking views of the north ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
This rare find in the Pali Ke Kua condominium complex has no one above or below you. Our mountain view remodeled home has it all. The exotic foliage creates a very private and quiet setting that looks out over the tropical gardens onto the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
When you walk through our newest Princeville condo at Pali Ke Kua, you’ll find a perfect match between its soothing colors, generous space and dazzling ocean views from the great room, kitchen and dining area. Step outside on the lanai and you...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
When you walk through our newest Princeville condo at Pali Ke Kua, you’ll find a perfect match between its soothing colors, generous space and dazzling ocean views from the great room, kitchen and dining area. Step outside on the lanai and you...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Pali Ke Kua #201 is an oceanfront condo with a master bedroom plus loft suite. 2 Baths, Sleeps 4.
LOCATION! LOCATION! LOCATION! Welcome to Pali Ke Kua #201, a stunning corner unit which showcases endless ocean vistas, views of Bali ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
