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 '%Wailea Point%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Wailea Point #3203 offers a luxurious and serene retreat with stunning ocean views, located in the exclusive gated community of Wailea Point. This elegant condo is perfect for those seeking privacy and a minimum stay of 30 nights, providing an ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea-Makena
2 bedrooms, 2 full bathrooms recently renovated property with breathtaking ocean views. Sit and sip on the lanai or on the lawn and take in the peace. Very low density of guests that gives you unmatched privacy at the 3 communal pools, hot tubs ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Why not treat yourself to the best? Please call or email us about the dates for your visit.
This is The Pinnacle at Wailea Point. Brand new as of June 2023, third bedroom and fourth bathroom private loft added. Treat yourself because ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Wailea
Summary:
Discover luxury living at Wailea Point Resort, nestled between prestigious resorts, this oceanfront paradise promises the ultimate South Maui experience. Our 3-bed luxury condo offers four bathrooms, in-suite laundry, two workspaces,...
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Kihei
Wailea Point is the ultimate in privacy and elegance for those seeking stays of 30 nights or longer. For shorter stays, please select from one of our other beautiful Wailea resort properties.
The finest development in the finest ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
