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
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
