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, rewritten_description,
(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 '%kauai beach resort%') AND sleeps>=1 order by rating desc LIMIT 0, 50
**Please read 'Other Things to Note' in listing** Capture the tranquility and beauty of the Garden Isle from this charming, centrally located condotel unit at the Kauai Beach Resort. From your private lanai, take in Kauai's lush landscape and
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lihue
Enjoy a delightful beach vacation at Kauai Beach Resort and Spa, a full-service oceanfront resort situated on 25 lush acres along Kauai’s longest strolling beach. This is a privately owned, immaculate ground floor unit steps from the ocean and
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lihue
Our unit is a privately owned hotel room located in the Outrigger Kauai Beach Resort and Spa.
Beautiful second floor unit in building 4 (closest building to the ocean), with an unobstructed view of the ocean. King bed with chaise lounge.
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lihue
Lihue vacation condo in Hanamaulu with kitchen and lanai
Kaua'i Beach Villas D 19, 1-Bedroom, 1-Bath, Ground Floor Unit with Private Lanai off of the Living Room, Walk to Beach.
No resort fees, free Wifi and free Parking!
Enjoy
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lihue
Beautiful remodeled Condo with breathtaking Ocean Views located at Outrigger, Kauai Beach Resort. Centrally located between Kauai’s North and South shores.
The room has 2 queen beds, a spacious bathroom, air conditioning, and a private
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lihue
Lihue vacation condo with kitchen and 2 lanai's
Kauai Beach Villas D 11, 2-Bedroom, 2-Bath, 3rd Floor Unit (no elevator) with Private Lanai off of the Living Room, Walk to Beach.
No resort fees, free Wifi and free Parking!
Enjoy
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lihue
Our unit is a privately owned hotel room located in the Outrigger Kauai Beach Resort and Spa.
Beautiful fourth floor unit with King bed. Lovely resort with amazing pools! Beautiful resort and ocean views from the room!!!
The
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lihue
Our unit is a privately owned hotel room located in the Outrigger Kauai Beach Resort and Spa.
This is a beautiful second floor unit with a view of the park and ocean behind it. Comfortable king bed with chaise lounge and
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lihue
Our unit is a privately owned hotel room located in the Outrigger Kauai Beach Resort and Spa.
This is a beautiful second floor unit with a view of the park and ocean behind it. Comfortable king bed with chaise lounge and
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lihue
Note: if the requested dates are not available, I also have three other rooms on the property, VRBO #579874, #666626, and #595354, vrbo#460973, #492665.
The Kauai Beach Resort - a gorgeous boutique is located along three miles of
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lihue
Welcome to Kauai Beach Resort! Come and enjoy our premium pool and ocean view studio suite! Located on the 5th floor, this beautifully renovated suite features stunning panoramic views visible from both queen beds and the lanai.
Nestled
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lihue
