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 (`headline` like '%Nihilani%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Nihilani 16A is a beautifully decorated 2-bedroom, 2-bath, air conditioned plantation style condo. Set in a lush, garden setting, this spacious, one-story, 1,400-square-foot home is a destination where you can retreat into the relaxed Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> 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
Hawaii> Princeville
Three bedrooms with 1 King bed, 2 Queen beds, 3 full bathrooms, 2 lanai spaces, washer and dryer in unit, 2 car garage, upgrades throughout, beautifully decorated, close to resort amenities.
Wow! You will not be disappointed in this ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Princeville
This gorgeous 3 bedroom, 3 bath townhouse located in the Nihilani complex in Princeville is the perfect spot for your family vacation. Spacious and inviting, the home has air conditioning throughout, a fully loaded kitchen, a large living area ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Welcome to your dream vacation destination in Princeville, Kauai! Our two-story, three-bedroom condo offers the perfect blend of luxury, comfort, and convenience. Located minutes from the Makai Golf Course and Hanalei Bay, this property is a ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Introducing Nihilani at Princeville 34C, now available through Makana Kauai Properties.
Nihilani offers luxurious accommodations on the north shore of Kauai. These Princeville condos showcase a plantation-style architecture with ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
The award winning Nihilani at Princeville Resort is a spectacular newer condo community, beautifully landscaped and artfully designed. This spacious, two bedroom, two bath 1,400-square-foot home is close to the lovely pool that includes a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
This North Shore Kauai private condo rental features 2 Master bedrooms, Plus extra sleeping space in a Trundle in the Family Room, two dining and living areas, a large kitchen, and access to the Nihilani at Princeville resort ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> 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. ...
- 4 bedroom
- 3 bathroom
- Sleeps 10
Hawaii> Princeville
PROPERTY DESCRIPTION
Come stay in Hale Honu! A luxurious, newly furnished, split-level Nihilani floor plan. 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...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Three bedrooms with 1 King bed, 1 Queen bed and 2 twin beds, and queen sleeper sofa, 3 full bathrooms, 2 lanai spaces, washer and dryer in unit, 2 car garage, spacious living, garden views, fun resort amenities.
This spacious 3 bedroom, 3...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Princeville
This single level (upper floor- "2nd floor") townhome is tastefully decorated and has terrific artwork as well. With nearly 2000 square feet of living space, there is plenty of room for everyone to be together as well as have privacy for quiet ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> 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
Hawaii> Princeville
Three bedrooms plus den, 2 King beds and 2 twin beds, plus sofa sleeper, 2.5 bathrooms, 2 story town home, washer and dryer in unit, multiple lanai spaces, attached two car garage, great complex amenities.
This spacious 3 bedroom, 3 bath ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Princeville
Three bedrooms plus den with 1 king bed, 2 queen beds and 1 single bed, multiple lanai spaces, 2.5 bathrooms, washer and dryer in unit, 2 story town home, attached garage for one car, close to pool.
Very spacious, this 3 bedroom, 3 ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Princeville
Spacious and elegantly appointed, this new two-bedroom, two-bath villa is suited with a contemporary Hawaiian feel. With over 1,400 square feet of living space, Nihilani Villa 1A is the perfect home away from home.
This little piece of ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Our Nihilani unit is a brand new vacation rental, and has been recently renovated, including all brand new tile flooring throughout, furniture, paint, and décor. This unit is 1400 sq ft, 2bd, 2ba ground floor, end unit with open living spaces. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
