select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
State of Hawaii Transient Accommodations Tax License #TA-094-662-2464-01. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910063
Royal Ilima A201 is located on Maui island, ranked #1 Best Luxury Destination in ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
HI> Wailea
State of Hawaii Transient Accommodations Tax License #TA-182-491-7504-01. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910044
Mer Et Soleil K408 is located on Maui island, ranked #1 Best Luxury Destination in...
- 4 bedroom
- 3 bathroom
- Sleeps 8
HI> Wailea
The best location in Wailea! Quick 2 minute walk to Wailea beach, shops, restaurants & the stunningly scenic Wailea Beach Path.
COVID19 - Please make sure you are up to date on Maui's COVID policies as they currently differ from the state of ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
HI> 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
HI> 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. Our ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Kihei
Legal Vacation Rental. 100 % REFUND Guaranteed if Cancelling is Due to the Reinstatement of Hawaii Mandatory 14 Day Quarantine without a 72 Hour Pre-Arrival PCR Testing Protocol!
Maui is open for vaccinated and or tested guests! Do Check the ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
HI> Wailea
Our home is a spacious 1980 square foot, 2 bedroom/2 bath Wailea Beach Villa with a den that functions as a third bedroom. Located directly above the upper pool with a spectacular garden and pool view, this spectacular unit offers a generous ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailea
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 Elevator
...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailea-Makena
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 2 subzero ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
HI> Wailea-Makena