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, 50
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 8
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 8
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 6
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> Wailea
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 6
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
This property is hotel zoned, and not being affected by the recent proposed legislation.
Located in the highly sought after Wailea Beach Villas, this exquisite penthouse unit offers a lush tropical setting with views of the Pacific Ocean ...
- 4 bedroom
- 2 bathroom
- Sleeps 6
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
Wailea Beach Villas Penthouse 502 boasts a panoramic ocean vista, ideal for whale watching in the winter, and with spectacular sunset views all year long. This top floor penthouse has been exquisitely redecorated with an elegant, casual ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Beach Villas is simply the best of the best! Enter the community through the 24hr private guarded gate & drive down to the complimentary self parking in the indoor garage. Check-in and receive your key card from the lobby you'll be able ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Awaken to the sweet sounds of palm trees swaying in the tropical breeze from Wailea Beach Villas PH112. Spanning 2,500 square feet, this main level, corner villa fuses a Hawaiian vibe with warm, earthy interior tones. The wraparound lanai offers...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Wailea
Wailea Beach Villas Penthouse 301 offers an unparalleled vacation experience with its luxurious 2,500 square foot ocean view suite. Situated on the third floor and accessible via a private elevator, this penthouse ensures privacy and ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Wailea
Discover for yourself why D301 is one of the most requested Villas in our vacation rental collection. Impressive artwork by internationally known Maui artist Elan Vital provides a fabulous backdrop to the welcoming great room in rich jewel ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kihei
Features of our 2300 sq oceanview condo include:
Two full master suites
Second bedroom can have two twins or king sized bed
A den that closes off completely to sleep up two additional guests (either twin or king sized bed)
Private ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea-Makena
You will feel like a rock star in this oceanfront villa with its owner’s gold and platinum records displayed alongside a baby grand piano. Villa B101 sits oceanfront within a secluded garden area surrounding a private plunge pool. A short ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Wailea
Wailea Beach Villas Penthouse #302, with breathtaking views of the pristine Pacific Ocean, awaits. Take joy in the comfort of luxury and tranquility as it seamlessly infuses with lush tropical surroundings creating long lasting memories. ...
- 4 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Wailea Beach Villas is simply the best of the best! Voted #3 Resort in Hawaii by Conde Nast Reader’s Choice Awards 2019. Enter the exclusive community through the grand 24hr private guarded gate & drive down to the inviting and serene Lobby to...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Wailea
Features of our 3300 sq condo include:
Two full master suites
Second and Third bedroom can have two twins or king sized bed
Fourth Bedroom is queen sized bed
Waterworks Bathrooms with large soaking tub
Studio Becker Kitchen with...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Wailea-Makena
Wailea Beach Villas Penthouse 504 enjoys 180 degree views of the Pacific Ocean, Kaho‘olawe, Molokini crater, and Lanai. This generous two-bedroom, two-bathroom condo provides over 2500 sq. ft. of living space, outdoor lanai, entertaining ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea, Maui
Wailea Beach Villas F202 is where luxury, style and sophistication blend together in a stunning Maui location just above Wailea Beach. This immaculate villa showcases gorgeous blue ocean views while encompassing lush tropical trees and is sure ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Wailea
Welcome to Wailea Beach Villas Penthouse 205, an elegant retreat that showcases sophisticated furnishings, vibrant colors, and striking artwork. This family-friendly penthouse features three bedrooms and three full baths, offering ample space ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kihei
Wailea Beach Villas Penthouse 403 offers a luxurious escape with stunning ocean views and ample space for the whole family. Spanning 2,000 square feet, this penthouse features three bedrooms and three full bathrooms, making it an ideal holiday ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kihei
Wailea Beach Villas PH410 is a fourth floor penthouse suite that overlooks the central swimming pool with spectacular views of the Pacific Ocean and Wailea Beach, along with views of Kaho’olawe, Molokini and Lana'i.
From your private ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Welcome to Wailea Beach Villas Penthouse 105, where luxury living meets the breathtaking beauty of Maui. This elegant ocean view penthouse spans 2,500 square feet and features a spacious floor plan that flows seamlessly onto a generous lanai, ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Wailea
Welcome to Wailea Beach Villas D302! Recently renovated, this residence features a custom gourmet kitchen and dining area, offering a luxurious and spacious retreat in one of Maui's premier locations. Spanning over 2,900 square feet of indoor ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Wailea
