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 '%Lawai Beach Resort%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Lawai Beach Resort 1 Bedroom Sleeps 4
**PLEASE READ ENTIRE DESCRIPTION BEFORE REQUESTING RESERVATION**
Book our Amazing Timeshare & let The Timeshare Brokers, LLC make the booking process easy!
Key Points:
-You’re inquiring on a ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Koloa
•On Kauai’s sunny South Shore across the street from one of the island’s best snorkeling spots
• Near great dining, the famous Poipu Beach Park, Spouting Horn, Allerton Gardens, Maha’ulepu, and the brand new Kukui’ula Shopping Center...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Koloa
Welcome to Lawai Beach Resort 1 bedroom condo
Located across the Pacific Ocean on the south shore of Kauai, the resort is set on 7 acres overlooking one of the best snorkeling and surfing spots, Lawai Beach.
- Three swimming pools and spas...
- 1 bedroom
- 1 bathroom
- Sleeps 6
HI> Koloa
Enjoy spectacular views from sunrise to sunset from the lanai of your oceanfront Kauai condo. Lawai Beach Resort overlooks one of the best snorkeling and surfing beaches on Kauai, making it a favorite vacation spot for everyone. There are three ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Koloa
All the splendor of this iconic oceanfront setting spreads before you. Uninterrupted panoramas of this world famous surf spot featuring the marine acrobatics of both wildlife and skilled local surfers! We own several timeshare weeks in several ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Koloa
Lawai Beach Resort ; 1 Bedroom Suite
....
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Koloa
