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, 30
This upscale Ocean View Extravaganza penthouse features 2 bedroom 2 bath, exotic hardwood furnishings, incredible antiquities collection and amazing ocean view. State of the art gourmet kitchen, floor-to-ceiling windows and lanai built-in ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Wailea Beach Villas Penthouse 504 is named The Maui Ocean View for its panoramic 180 degree views of the Pacific Ocean, Kaho‘olawe, Molokini crater and Lanai. This generous two-bedroom, two-bath unit provides over 2500 sq. ft. of living space,...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea, Maui
Penthouse 309 is a uniquely designed 3-bedroom, 3-bath private vacation home. The enclosed den is complete with a sofa bed, making this Penthouse suite ideal for larger families or groups of friends traveling together. Ocean views can be ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kihei
Aloha and Welcome to Azure Azul M212 a Partial Ocean View Villa at Wailea Beach Villas, a newly refreshed and re-decorated 3 bedroom 3 bath ocean view ultra-lux resort residence located within the Wailea Beach Villas Resort on Wailea Beach, Maui...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Wailea-Makena
Situated on the 4th floor of the penthouse/tower building of the Wailea Beach Villas Resort, Sea Breeze Suite offers expansive and superlative direct west-facing panoramic Pacific Ocean, Wailea Beach and Sunset views. Guests will enjoy a ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Wailea-Makena
Select Regal Mandalay M511 and come enjoy a once-in-a-lifetime opportunity. Set on the top floor of the tower building at Wailea Beach Villas, guests of M511 have one of the best panoramas available - even better than that viewable from many of ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maui
C201 Castaway Cove Ocean View Villa has been recently decorated and upgraded to create an all-new living environment. The property owners have spared no expense in working with our team of professionals to create a uniquely elegant, comfortable ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Wailea
Aqua Lani J305 is a stunning, upscale Wailea Beach Villa. J305 was recently enhanced with the addition of a three-piece Natuzzi-brand Italian white leather sofa set to the great room, along with additional sofas and lounging/seating added to the...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Wailea
The expansive vacation villa F201 breathes upscale relaxation. With a generous 3,676 sq feet of upscale luxury living, this 3 bedroom 3.5 bath is highly recommended for families or couples. Villa F201 is a decorator's delight blending themes of...
- 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
Penthouse 209 is a tastefully furnished, open and airy 2,600 sq. ft. 3-bedroom garden view suite overlooking the family pool.
An expansive, tiled great room is ideal for a leisure gathering with a seamless blend of indoor/outdoor living when ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kihei
Immerse yourself in luxe tropical comforts blended with bountiful, blue ocean views. This delightful Maui ocean view vacation residence will cultivate long lasting memories and leave you feeling rejuvenated upon departure. Centrally located on ...
- 2 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
Arrange to have us pre-stock your refrigerator because once you arrive at Villa G302, you may not want to leave. Two walls of retractable sliding doors expand the open living area onto the corner, ocean view lanai, complete with built-in Viking ...
- 3 bedroom
- 4 bathroom
- Sleeps 4
Hawaii> Kihei
Curated with our guests in mind, this modern villa’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 Wailea ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
This Wailea Beach Villas suite penthouse features 2 bedroom, 2 bath tropical island appointments and comfortable over- stuffed furniture. Den offers a sofa bed and privacy curtains to convert into a 3rd bedroom. Lanai has bonus Partial ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Wailea Beach Villas Penthouse 301 Features:
2500 Sq. Ft. Ocean View Penthouse Suite
Third floor accessed by private elevator
3 bedrooms / 3 bathrooms
King bed in master bedroom and second bedroom
Two twin beds in third ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Wailea
Settle into your very own slice of Maui paradise with a stay in Wailea Beach Villas PH306. This exquisite two bedroom, two bath penthouse villa with exceptional ocean and island views are sure to inspire the luxury, comfort and serenity you ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Experience the very best in tropical island living from ocean view Wailea Beach 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 the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
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 opens 1 year in advance. Please reach out if you...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kihei
Situated on the 5th TOP FLOOR of the penthouse/tower building of the Wailea Beach Villas Resort, Sea La Vie L510, a fully redecorated and remodeled 2.5 bedroom, 2 bath suite, offers expansive and superlative direct west-facing panoramic views of...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
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
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
Luxury 3-Bedroom Wailea Beach Villa - Your Hawaiian Paradise Awaits!
Prepare for an extraordinary escape to Wailea, where luxury harmonizes with the untouched beauty of Maui. This exclusive 3-bedroom, 3-full bath penthouse beach villa ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kihei
This top floor 3 bedroom 3 bath Penthouse has an incredible wrap around corner lanai set up to enjoy outdoor dining or sunbathing. Ocean Views are abundant from Master and 2nd bedrooms as well as the living, dining and kitchen areas.Ocean View, ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kihei
Sun Splash Villa C301 is a newer vacation villa rental opportunity within the Wailea Beach Villas, a residential villa resort set directly on Wailea Beach, on the leeward sunny side of Maui Island.
C301, a top floor corner full ocean view...
- 3 bedroom
- 4 bathroom
- Sleeps 6
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
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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Wailea
