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 '%Point at Poipu%') AND sleeps>=1 order by rating desc LIMIT 0, 20
I only have a reservation for the date specified. Other dates can be acquired if they are far enough out.
Mar 15-22 Oceanfront View. Best view.
Cloaked in natural beauty, The Point at Poipu is a dream vacation destination on the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
This is a timeshare property that is available for 7 nights in 2024. I have a reservation for an Ocean Front unit July 5-12, but we can check for availability on other dates. Contact me with your desired dates and I will check the availability....
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
CONTACT ME FIRST REGARDING AVAILABILITY AND THEN I CAN
CHECK AVAILABILITY AND GIVE YOU AN ACCURATE QUOTE. PLEASE DO NOT USE
ONLINE BOOKING.
THIS IS A TIMESHARE RESORT AND THEREFORE DATES COME AND GO EVERY DAY; DO NOT RELY ON ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Diamond Resorts Point at Poipu- 2 Bedroom Unit Sleeps 6
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
Book our Amazing Luxury Villa & let The Timeshare Brokers, LLC make the booking ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Please choose a Friday through Sunday arrival and enjoy a 7-night stay.
Our rates are based on garden/island view, ocean view/ oceanfront villas may be available depending on your travel dates.
Thank you for choosing Dash Realty ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Beautiful and spacious 2 bedroom/2 bath condo at The Point at Poipu on Kauai's sunny south shore. The entire resort was remodeled and updated in 2017-2018. These fully equipped and furnished units sleep 6 comfortably. Full kitchen, W/D, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
The Point at Poipu 2 Bedroom Sleeps 6
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
Book our Amazing Luxury Villa & let The Timeshare Brokers, LLC make the booking process ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Diamond's owner calendar does not sync with VRBO. What is available can change several times a day, but this is a confirmed reservation available.
If you are interested in other dates please email me so that I can CHECK AVAILABILITY AND ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
The Point at Poipu is an oceanfront resort with elegance and is a dream vacation destination on the southernmost tip of Kauai. The resort overlooks the polished sands of Shipwreck Beach and is secluded among lush landscape. After a day of ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa, Kauai
This oceanfront Resort provides a magnificent view of the Pacific Ocean. The Point at Poipu Resort is located in the South Shore of Kauai, Hawaii. The resort is a large family-oriented oceanfront property with significant amenities. It is ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
You won't want to leave this charming, one-of-a-kind place. Flowing waterfalls, a crystal clear Koi pond, and hundreds of tropical plants make The Point at Poipu appear the stuff of the dreams. Nestled in over twenty acres of lush tropical ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Immerse yourself in the dreamlike beauty of The Point at Poipu, where flowing waterfalls, a crystal-clear Koi pond, and lush tropical gardens transport you to a paradise that feels almost unreal. Set on over twenty acres overlooking the stunning...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
*** Sanitation/Cleaning Update ***
At Diamond Resorts, the safety and well-being of our guests and team members is of utmost concern. We remain diligent in our commitment to provide a safe, hospitable environment for all who visit our ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kauai
