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 Grand Champions%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Located on the world-class Wailea Blue Golf Course. Our Wailea Grand Champions condo has been newly redecorated and furnished with decor that depicts the beauty of Hawaii and our rich Hawaiian culture. As a local family who live on island, we ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Our beautifully appointed condo is perfect for a family (6 maximum), a couple or two couples (as there are 2 primary bedroom suites, each with a king size bed, private bath and flatscreen ). The condo features a spacious living and dining area ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Wailea Grand Champions 71 is a beautifully updated ground-floor vacation rental that offers both fairway and ocean views from the living room and private lanai. This spacious two-bedroom, two-bath condo comfortably accommodates up to six guests,...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Wailea Grand Champions 159 is a beautifully updated three-bedroom vacation rental located along the fairway of the Wailea Blue Golf Course. This ground-floor condo offers a spacious layout with three bedrooms and two bathrooms, making it ideal ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Wailea
Wailea Grand Champions 88 offers breathtaking views that will never cease to amaze. Enjoy your morning coffee on the lanai while watching golfers hit approach shots onto the putting green below. If you glance to your left, you’ll be treated to...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Bldg. 16 - Unit #153 - A front-row, impeccable 3 Bedroom + 2 Bathroom paradise condominium at the Wailea Grand Champion Villas. This is a prime example of what Wailea Grand Champion Golf Villas has to offer in a 3 bdrm + 2 bath category. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
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...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Wailea Grand Champions 75 is an exceptional vacation rental situated in the picturesque Wailea region of Maui. This luxurious property promises an unforgettable escape with its blend of elegance, comfort, and stunning natural beauty.
Upon...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Grand Champions 31 is a recently updated vacation rental that offers a perfect blend of comfort, style, and convenience in the heart of Wailea. This two-bedroom, two-bathroom condo features modern upgrades including granite countertops, ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Wailea
Wailea Grand Champions 43 is a stunning vacation rental nestled in the heart of Wailea, offering a luxurious escape with breathtaking views and unparalleled comfort. This elegantly designed property is ideal for those seeking both relaxation and...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Wailea Grand Champions Villa 73 is a recently renovated vacation rental that offers a perfect blend of luxury, comfort, and stunning views in the heart of Wailea, Maui. As you enter the villa, you're greeted by a bright and spacious great room, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Do your Maui vacation right! Wailea Grand Champions 95 is surrounded by tropical landscaping and rolling green fairways, that serve as a constant reminder that you are vacatioing in paradise. This vacation rental offers a perfect blend of ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Wailea Grand Champions 97 is a premier vacation rental located in the serene tourist retreat of Wailea. This exquisite property combines elegant design with modern amenities to provide a truly exceptional getaway experience.
Upon arrival ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Villa 104 at Wailea Grand Champions Villas is a beautiful Maui vacation rental that offers an exceptional blend of style, comfort, and convenience. This modern and hip condo boasts stunning golf course views and thoughtfully curated interior ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Grand Champions Villa 111 is a spacious two-bedroom, two-bath vacation rental condo that accommodates up to six guests, making it an ideal choice for families or friends traveling together. The first bedroom features a comfortable ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Wailea Grand Champions 116 is a luxurious vacation rental located along the southern coast of Maui in the desirable tourist area of Wailea. This beautifully appointed one-bedroom, two-bathroom condo accommodates up to four guests, making it ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Grand Champions 121 is ground-floor vacation bliss. Enjoy the easy convenience of transporting beach equipment, groceries, golf clubs, and vacation souvenirs from your rental car to your vacation rental. Designed with comfort in mind, the...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Grand Champions 140 is a remarkable vacation rental nestled in the upscale Wailea community of Maui. This charming property combines elegance with comfort, offering a luxurious retreat that is perfect for both relaxation and ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Relax on your private lanai at Grand Champions #152, perched upon the second-floor, and enjoy views of manicured fairways, putting greens, and tee boxes as golfers tackle the Wailea Golf Course. This vacation rental is ideally situated to ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
