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
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
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
Our collection of Maui vacation residences are HOTEL-Zoned or have LEGAL short-term rental permits. Reserve with Private Paradise Villas with confidence knowing you will be luxuriating in a location legally designated for visitor accommodations ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Wailea-Makena
Our collection of Maui vacation residences are HOTEL-Zoned or have LEGAL short-term rental permits. Reserve with Private Paradise Villas with confidence knowing you will be luxuriating in a location legally designated for visitor accommodations ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Wailea-Makena
Our collection of Maui vacation residences are HOTEL-Zoned or have LEGAL short-term rental permits. Reserve with Private Paradise Villas with confidence knowing you will be luxuriating in a location legally designated for visitor accommodations ...
- 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
Our collection of Maui vacation residences are HOTEL-Zoned or have LEGAL short-term rental permits. Reserve with Private Paradise Villas with confidence knowing you will be luxuriating in a location legally designated for visitor accommodations ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Wailea
Our collection of Maui vacation residences are HOTEL-Zoned or have LEGAL short-term rental permits. Reserve with Private Paradise Villas with confidence knowing you will be luxuriating in a location legally designated for visitor accommodations ...
- 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
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
Our collection of Maui vacation residences are HOTEL-Zoned or have LEGAL short-term rental permits. Reserve with Private Paradise Villas with confidence knowing you will be luxuriating in a location legally designated for visitor accommodations ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
