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 (city = 'Princeville' OR postalCode = 'Princeville' OR region like '%|Princeville|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Commitment to clean - this home is professionally cleaned and disinfected between guests and there is a 24 hour minimum buffer between guests.
Escape to paradise in this oceanfront studio condo. Fall asleep to the sound of lapping waves or watch...
1 bedroom
1 bathroom
Sleeps 3
HI> Princeville
Wyndham Bali Hai Villas is located on the beautiful North Shore of Kauai which has more beaches than all of the other Hawaiian island's combined. People don't build anything taller than a coconut tree here. . Kauai is known as the Garden Isle ...
1 bedroom
2 bathroom
Sleeps 4
HI> Princeville
A comfortable 2BDRM Delux unit that sleeps up to 6. The Wyndham Bali Hai Villas Resort is located on the North Shore of Kauai. This beautiful unit is great for a couple get-away, families or a group of friends who want to share comfortable ...
2 bedroom
2 bathroom
Sleeps 6
HI> Princeville
Beautiful Princeville Resort that will allow you to enjoy beautiful Kauai in style! With everything, you could want in a resort Bali Hai offers that home away from home with all the extra perks! A comfortable 2BDRM Delux unit that sleeps up ...
2 bedroom
2 bathroom
Sleeps 6
HI> Princeville
LOCATION, PRIVACY & OUR COMFORTABLE BEAUTIFUL HOME.....Are just a few words that best describe this ground floor condo at Plantation at Princeville. Unit 1411 has two bedrooms and two full bathrooms. The Master Bedroom is spacious and opens to a...
2 bedroom
2 bathroom
Sleeps 6
HI> Princeville
GOOD NEWS! Hawaii is open for travelers! Make sure you get a negative covid test within 72 hours of arrival and check all of the details on the Hawaii.gov website so you can have a safe an successful trip to Kaua'i.
PROPERTY DESCRIPTION
Are ...
2 bedroom
2 bathroom
Sleeps 4
HI> 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 area.
This 3...
3 bedroom
3 bathroom
Sleeps 7
HI> Princeville
A comfortable 2BDRM Delux unit that sleeps up to 6. The Wyndham Bali Hai Villas Resort is located on the North Shore of Kauai. This beautiful unit is great for families or a group of friends who want to share comfortable accommodation with all...
2 bedroom
2 bathroom
Sleeps 6
HI> Princeville
GOOD NEWS! Hawaii is open for travelers! Make sure you get a negative covid test within 72 hours of arrival and check all of the details on the Hawaii.gov website so you can have a safe an successful trip to Kaua'i.
PROPERTY DESCRIPTION
Are ...
1 bedroom
2 bathroom
Sleeps 4
HI> Princeville
All travelers are responsible for investigating all travel restrictions to Kauai. Travelers are advised that travel restrictions to Kauai may be different than travel requirements to the State of Hawaii.
This spacious 2 bedroom, 2 bath private ...
2 bedroom
2 bathroom
Sleeps 4
HI> Princeville
A comfortable 2BDRM Delux unit that sleeps up to 6. The Wyndham Bali Hai Villas Resort is located on the North Shore of Kauai. This beautiful unit is great for families or a group of friends who want to share comfortable accommodation with all...
2 bedroom
2 bathroom
Sleeps 6
HI> Princeville
As seen on Kauai-TV this is an amazing 5 bedrooms, 4 Full Bathrooms. That’s 3 Master Bedrooms and 2 Guest Suites.
One full kitchen, one kitchenette, three living areas, and 5 lanais. And Aloha Glore!
From the moment you enter this house, ...
5 bedroom
4 bathroom
Sleeps 10
HI> Princeville
Our spacious 4 bedroom/4 bath home on the North Shore of Kauai in Princeville is the perfect spot to call home while on your dream vacation to Hawaii. Ideal for families, we are right near the Princeville walking path, allowing you to see the ...
4 bedroom
4 bathroom
Sleeps 10
HI> Princeville
This suite features a comfortable king bed in the bedroom, full kitchenette, induction cooktop, full bath, storage space, cable/smart TV, Netflix, high speed WiFi, washer and dryer, and beach gear. Situated in the Princeville Resort community ...
1 bedroom
1 bathroom
Sleeps 2
HI> Princeville
This beautiful, modern Kauai vacation home makes an excellent home base while exploring all the beauty and adventure Kauai has to offer. Located in Princeville, you will find yourself surrounded by beaches, mountains and North Shore hospitality....
2 bedroom
3 bathroom
Sleeps 6
HI> Princeville
