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, 30
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
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
Professional Photos pending.... Reservations under 30 days are welcome, please contact Host for details. **Posted nightly rate is for a 4-week stay. Reservations of less than 4-weeks will be priced at a higher rate.
The Pinnacle at ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Wailea