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 Beach Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Wailea Beach Villas Penthouse 406 is desirable for its remarkable Pacific Ocean and Island views. This upscale penthouse vacation rental features two bedrooms, two bathrooms, exotic hardwood furnishings, an incredible antiquities collection, and...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Penthouse 309 at Wailea Beach Villas offers a distinctive blend of luxury and cultural charm, making it an ideal vacation rental for families or groups of friends. This 2,520 square foot ocean view suite is located on the third floor and is ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Wailea
Penthouse 512 at Wailea Beach Villas offers an unparalleled top-floor experience with expansive ocean and island views, ideal for a Hawaiian dream vacation. This 3,000-square-foot home features a wrap-around lanai, providing one of the most ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kihei
Indulge in entertainment abound when vacationing in Wailea Beach Villas Penthouse 211. After you’ve spent an action-packed day at the beach or hiking one of Maui’s scenic trails, return to your vacation residence and discover some more ...
- 4 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maui
Welcome to Villa F201, an expansive vacation retreat that embodies upscale relaxation. Spanning a generous 3,676 square feet, this luxurious 3-bedroom, 3.5-bath villa is perfect for families or couples seeking a serene getaway.
Villa F201...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kihei
Wailea Beach Villas voted as one of the top 100 USA Hotels by the Conde Nast Traveler Readers Choice Awards!
Luxury awaits in this exquisite three bedroom, three full baths, 2500 square feet Penthouse Villa J205 with gorgeous ocean view. ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kihei
Welcome to Wailea Beach Villas Penthouse 209, a beautifully furnished 2,600 sq. ft. garden view suite that offers a serene escape overlooking the family pool. This open and airy vacation rental is designed for relaxation and leisure, featuring ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kihei
In Wailea Beach Villas PH307 you can immerse yourself in luxe tropical comforts blended with blue ocean views. This delightful Maui ocean view vacation residence will cultivate long lasting memories and leave you feeling rejuvenated upon ...
- 4 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Warm breezes and lush tropical gardens greet guests of Wailea Beach Villas E202 as the spacious and comfortably appointed interior blends seamlessly onto the private outdoor lanai. Contemporary neutral and earth-toned furnishings are ...
- 3 bedroom
- 4 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to Villa G302, your luxurious Hawaiian escape where relaxation meets elegance. This stunning ocean view villa features two walls of retractable sliding doors that seamlessly blend the open living area with a spacious corner lanai, ...
- 3 bedroom
- 4 bathroom
- Sleeps 4
Hawaii> Kihei
Curated with our guests in mind, Wailea Beach Villas PH111's outdoor elements are just as immaculate as the home’s interiors. Unwind and enjoy peekaboo views of the ocean along with tropical greenery from your private lanai. The pristine ...
- 4 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Experience the beauty of Maui in the luxurious Penthouse 210 at Wailea Beach Villas, a stunning retreat featuring two bedrooms and two bathrooms designed with tropical island elegance. This vacation rental welcomes families with its spacious ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Settle into your very own slice of Maui paradise with a stay in Wailea Beach Villas PH306. This exquisite two bedroom, two bathroom penthouse with exceptional ocean and island views are sure to inspire the luxury, comfort and serenity you ...
- 4 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Experience the very best in tropical island living from ocean view Wailea Beach Villas Penthouse 402. Revel in sweet sunsets and seasonal whale watching from your spacious, private lanai with scenic views of the Maui horizon, Molokini Crater and...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
RARE NOVEMBER OPENING - THANKSGIVING AVAILABLE
The best location in Wailea! Quick 2-minute walk to Wailea beach, shops, restaurants & the stunningly scenic Wailea Beach Path.
BOOKING CALENDAR/MINIMUM NIGHT STAY:
Our calendar...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kihei
Modern living, in one of the best locations at Wailea Beach Villas, with outer island and sunset views that are unmatched. Centrally located in the complex, and only steps away to both pools on property as well as the white sand beach and Wailea...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kihei
Marvel at the sophisticated style and décor of Wailea Beach Villas Penthouse 104, where a touch of Bali influence seamlessly merges with rustic undertones to create an unforgettable ambiance. The interior design captivates with elements like a ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Call this private piece of paradise home, which features panoramic views of Maui and the ocean below as well as luxurious interior elements everywhere you look. This contemporary vacation residence spans 2,500 square feet and captures the true ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Wailea
Upon entering your Wailea Beach Villas Ph207, you'll be captivated by the open floor plan, which seamlessly integrates a cozy living room, a quiet den with shoji screen doors, a gourmet kitchen, and a dining area. Sliding doors lead to a lanai ...
- 4 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Let the sounds of palm fronds brushing against each other in the gentle trade winds sing you to sleep this vacation. With relaxing views of the ocean and the manicured tropical landscaping, Wailea Beach Villas Penthouse 411 leaves no stone ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Wailea