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 4
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 ...
- 3 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...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
This is the one, bring the family and move-in! Fourth Night Free! - every Fourth Night Free between 8/15/2024 and 11/01/2024. Discount applied at final payment. Move-in to the Front Row!
Bldg. 16 - Unit #153 - A front-row, impeccable...
- 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
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
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 ...
- 2 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...
- 2 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, ...
- 1 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 ...
- 2 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 ...
- 1 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 ...
- 1 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 ...
- 2 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 ...
- 1 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...
- 1 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
