select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`headline` like '%Wailea Grand Champions%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Wailea Grand Champions Unit 174
Upgraded luxurious, comfortable, modern-Hawaiian, two-bedroom / two-bath second floor condo located in the Wailea Grand Champions. This unit is located on the golf course (past the 2nd tee) and boasts new ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea-Makena
Hawaii Tax ID: TA-144-497-4592-01
COMPLETELY REMODELED - GOLF COURSE & OCEAN VIEWS
Grand Champions #168 is a impeccably kept one-bedroom two-bath luxury villa with amazing golf course and limited ocean views. The unit is located on the 7th ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Wailea Grand Champions Unit 166
Luxurious, comfortable, updated modern two-bedroom / two-bath second floor condo located in the Wailea Grand Champions. This gorgeous unit has stunning ocean and golf course views.
The updated furnishings ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailea-Makena
Remodeled two bedroom condo at Wailea Grand Champions with fabulous views of the golf course. The fully equipped kitchen is perfect for enjoying meals in or for packing them for your day or adventure. The Kitchen is also open to the living and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailea
Why stay in Lahaina or Kihei when you can Vacation in a fabulous condominium on the sunny south coast of Maui. Located in the lush Wailea resort area, this Grand Champions air-conditioned villa is located on the second fairway of the Wailea Blue...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Wailea Grand Champions 26
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Wailea Grand Champions Villas 26 is a wonderful, single-level condo in a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
