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, 50
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
The Best Property for the Best Price at this Exclusive World Class Destination!
Make this beautiful condo your next vacation spot!!! Enjoy this gorgeous second floor unit providing a 90 degree view of the ocean. Hear the waves splashing on ...
- 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
Please call or email us about the dates for your visit. You are welcome to island-hop or come and go as you please during your reservation.
This is The Pinnacle at Wailea Point. Brand new as of June 2023, third bedroom and fourth ...
- 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,...
- 4 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
Welcome to Wailea Point. A premier hospitality destination nestled between the Four Seasons Wailea Resort and the Fairmont Kealani Wailea. Featuring an optimal location near beaches, golf, restaurants and entertainment, each of the privately ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Wailea
Yes, you can enjoy a holiday and vacation stay at Wailea Point, the iconic red roofs on Maui's wonderful southern shore and it is said that 2503 is the 'best location in the whole property'. With a separate master suite downstairs, the whole ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Wailea
Welcome home to Wailea Point 2803 - A premier holiday home for you and your family to spread out and enjoy quality time together. A tranquil private lanai for evening BBQs and sunrise breakfast or just sit and enjoy whale watching from your ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Wailea
