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 (`headline` like '%Nihilani%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Come stay in Hale Terra-a modern surf shack! A luxurious, beautifully furnished, split-level Nihilani floor plan. Nihilani 27A is in an interior building away from streets and traffic noise and just a short walk to the pool and BBQ area.
This 3...
- 3 bedroom
- 3 bathroom
- Sleeps 7
HI> Princeville
Come explore Paradise on the North Shore of Kauai while relaxing at Nihilani Princeville Resort. Nihilani means "near Heaven" which is exactly how you will feel during your stay. This lovely 1600 square foot townhome has 2 bedrooms, 2 living ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
HI> Princeville
This Nihilani unit is a beautifully decorated 2-bedroom, 2-bath Hawaiiana style home. The open floor plan includes a comfortable living room with a large flat-screen TV, a fully equipped gourmet kitchen with granite counter tops, and a spacious ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Townhome in Princeville, Nihilani Complex. Built in August, 2006, this 1874 square foot luxury unit is elegantly furnished, with three full bedrooms and 2.5 baths, including Jacuzzi bath in master bedroom.
The well-supplied gourmet kitchen, ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
HI> Princeville
PLEASE MAKE AN INQUIRY BEFORE BOOKING.
Aloha and welcome to Eddie’s Hula Hut! Don’t let the name fool you. Our spacious condo is fully furnished for your vacationing pleasure. You will quickly get yourself into vacation mode in our newly ...
- 4 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
Luxury House of Aloha Condo, Elegant Style at Affordable Price!
We want to welcome you to our House of Aloha and to become part of our Ohana (family). We have put together this house for you to enjoy while you're spending time on Kauai. We want...
- 4 bedroom
- 3 bathroom
- Sleeps 10
HI> Princeville
This beautifully furnished three-bedroom, two-story townhouse is ideally located near the pool and BBQ area, with space between you and your neighbors. With nearly 1900 square feet of living space, there is plenty of room for everyone to be ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
The Nihilani at Princeville is one of North Shore Kauai’s newest resort communities. The townhome units are spacious and equipped with all the finest amenities including central AC. Enjoy a covered lanai, one of the greatest resort pools in ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Come stay in Honu House! A luxurious, newly furnished, split-level Nihilani floorplan. Nihilani 8C is in an interior building away from streets and traffic noise and just a short walk to the pool and BBQ area.
This unit features hardwoods ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
Set amidst lush, garden landscape and just steps from the resort's tropical pool and poolside lounging area, it can be your base for all the activities Kauai has to offer, or you can spend your days relaxing, meditating or heading out for ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
koʻu hauʻoli ka hale i loko o Princeville (my happy home in Princeville) -
The Townhome complex of Nihilani is situated in the world-renowned Princeville Resort on the Garden Island of Kauai. The home is located in a neighborhood on a ...
- 3 bedroom
- 3 bathroom
- Sleeps 5
HI> Princeville
The Nihilani at Princeville is one of North Shore Kauai’s newest resort communities. The townhome units are spacious and equipped with all the finest amenities including central AC. Enjoy a covered lanai, one of the greatest resort pools in ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
