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 condo #3203 is a delightful ocean view home, complete with relaxing outdoor living space. Set in the gated community of Wailea Point, this Wailea condo is available for travelers looking for 30-day or longer rentals.Guests who enjoy...
- 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
The Pinnacle at Wailea Point. Brand new as of June 2023, complete remodel. It doesn't get any better than this - luxurious 3 Bedroom / 3+ bath residence with captivating ocean and neighbor island views that will impress every guest. Exquisite...
- 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
WE ARE OPEN in Wailea. Our communities of Maalaea, Kihei, Wailea, the North Shore, East Maui, Upcountry, and Central Maui; we all welcome you. Please have compassion and malama (care for) the island during your visit.
In the evening ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Wailea
