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 '%puu poa%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Exquisite 2,000 SF Puu Poa Corner Unit with wrap around ocean views. Sleeps 6, Cal King & 2 Queen. Custom built in DVD & library, pool room day beds, entertainment centers & fully appointed kitchen....
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Spectacular 4th floor Penthouse Oceanfront Corner unit has breathtaking Ocean and Mountain views and is fully air conditioned. Completed 2018 contemporary, luxury renovation is exceptionally beautiful. This penthouse unit is arguably one of the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Puu Poa 105
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
It’s easy to find your bliss at this newly remodeled, ground-floor oceanfront escape (two ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Experience spectacular ocean views and dazzling sunsets, in your private luxury vacation residence. This condo is on the second level six steps down with ocean and mountain views. A/C in both bedrooms and open concept kitchen living room area. ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Princeville
Spanning 10 acres on the Hanalei Coast, Puu Poa is a perfect example of luxury condos in Princeville. The tier architecture of these condos provides a sense of privacy for the guest. Our condo offers spectacular ocean front views of the Pacific...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Our Oceanfront, Mountain and Sunset view is THE most famous on all of Kaua'i!!!
Newly renovated with A/C throughout unit. 4 split Mitsubishi units: one in each bedroom , one in kitchen/dining area and one in living room/atrium area.
If you ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Puu Poa 211 Air Conditioned unit is perfect for a relaxing vacation. This Princeville condo has spectacular Bali Hai and ocean views from the lanai, living room and indoor outdoor style atrium. Nicely furnished.
The three couches in the living ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
(NEW: As of July, 2021, we have installed a new air conditioning system).
This immaculate luxury condo, perched on an emerald bluff overlooking the Pacific Ocean, offers spectacular views of the surf and famous Bali Hai mountains. On Kauai's ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
COVD ALERT: YOU CAN NOW COME TO HAWAII STARTING OCT 15 WITH A NEGATIVE COVID TEST!
*Updated Magnificent Vacation Home
* Incredible Ocean Views, Sounds, & Breezes
* Directly on the Ocean, Bali Hai views
* Updated Kitchen, Hard Wood Floors
* ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
This Air Conditioned Puu Poa condo sits on an ocean bluff next door to the renowned Princeville Hotel. This luxury two bed, two-bath condo boasts 1900 square feet, spacious rooms, tasteful décor, fully equipped kitchen, all new furnishings, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
***Construction Area 03.01.22 - 04.01.22***
Welcome to Pu'u penthouse in the sky overlooking the endless reaches of the deep blue Pacific Ocean! Situated in the exclusive Princeville community! This luxe retreat is located near all the north ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
AC AND AIR PURIFIER WITH HEPA FILTER IN EACH BEDROOM AND THE LIVING ROOM!!!
Hawaiian Tax ID #
GE-207-001-1904-01
TA-207-001-1901-01
Princeville is the most prestigious area on the north shore of Kauai with all the amenities near by and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Luxury top floor penthouse in tropical paradise, with the most breathtaking oceanfront
views of the legendary Bali Hai coastline. From unit 411 on the far-right side of Puu
Poa, no need to crane your neck over the edge of the lanai to admire ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Enhanced COVID cleaning and disinfecting procedures for every check-in.
Working remotely and looking for a longer stay? Contact us for Thirty Days Plus discounts. Enhanced cleaning and disinfecting procedures for every check-in.
This ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Puu Poa 110 a spacious luxury ground floor unit in Pu'u Po'a - #110 offers immediate access to an acre of lawn, the swimming pool (without negotiating stairs and asphalt).
This beautiful condo features a freshly re decorated interior with new ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
