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 '%Palms at Wailea%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Aloha and welcome to our retreat in Wailea, Maui, the heart of paradise. Your Hawaiian vacation will be nothing short of spectacular when you stay in Unit 1510, Palms of Wailea ocean view condo. There are many reasons our guests consider our ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
BRAND NEW 80K renovation and all new decor. Hawaiian Contemporary design with Room and Board, Crate and Barrel and The Beach House decor with touches of Hue.
Our Calendar is always current so if there is nothing available at this condo check ...
- 1 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailea
***At the end of the day, March 25, 2022, the Safe Travels Hawai‘i program will conclude. Beginning March 26, 2022, there will be no COVID-related requirements for arriving domestic passengers. Travelers arriving in Hawai‘i directly from ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea
Our Calendar is always current so if there is nothing available at this condo check out The Palms 201 # VRBO 2050379 or Grand Champions 178 # VRBO 2491672 check both out to see which one works better for you or available dates.
Stunning 30 K ...
- 1 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailea
Hawaii Tax ID: TA-144-497-4592-01
QUIET PRIVACY IN PARADISE - BEAUTIFUL GARDEN/OCEAN VIEWS
The Palms #902 is a luxurious one-bedroom two-bath upstairs villa tucked away in a private and quiet corner in one of the nicest locations on the ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Perfectly located in beautiful upscale Wailea, The Palms at Wailea is within walking distance of magnificent white sand beaches, fine dining, & shopping, yet tucked away off the beaten path allowing privacy & relaxation.
This spacious, ...
- 1 bedroom
- 2 bathroom
- Sleeps 3
HI> Wailea
The world is changing, and we are changing with it. We have taken the time to revamp our practices to ensure a clean and safe environment for all of our guests and staff.
We have added very detailed cleaning checklists and have also implemented ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Maui
Located in the Kihei/Wailea area, in the world-famous Wailea Resort community, The Palms at Wailea complex boasts a beautiful pool, hot tub and is conveniently located close to the Shops of Wailea, luxury hotels, stylish boutiques, great ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Maui Luxury Vacation Rental -
Relax & Recharge
Welcome to the highest sales price unit at The Palms at Wailea. The Palms 1202. The reason is simple. It has the best and widest ocean and garden views in the complex. This spacious top floor unit ...
- 2 bedroom
- 4 bathroom
- Sleeps 4
HI> Wailea
SEE CALENDAR FOR AVAILABLE DATES
NEW UPDATED CONDO PHOTOS POSTED Sept. 2, 2021.
The Palms at Wailea #207 ground floor luxury condo.
Recent updates of new furnishings, decor, turtle artwork, 2 spa style lounge chairs, LG Washtower washer and ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea
The world is changing, and we are changing with it. We have taken the time to revamp our practices to ensure a clean and safe environment for all of our guests and staff.
We have added very detailed cleaning checklists and have also implemented ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailea
This 3 bedroom 3 bath multi level condominium apartment is like a private home! From the entry you can step up to the open living area with a ocean view lanai. The spacious living area can easily accommodate a family get together with the ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Wailea
Palms at Wailea #1503 is one of the best located condos in this property; situated in the inner circle providing views out to Maalaea Bay, West Maui Mountains and the island of Lanai. This magnificent view is reflected from the wall to wall ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea
Palms at Wailea #308 is a 1 bedroom, 2 bath unit on the second floor with split system A/C throughout, a fully equipped kitchen, washer and dryer, 2 flat-screen TVs, DVD, telephone with free calls to the continental US and Canada, and free Wifi....
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea
You're sure to have a fabulous stay! This luxury Palms at Wailea unit is located near the spectacular pool and jacuzzi and all the amenities this popular complex affords.
This 2 bedroom 2 bath unit is immaculate and beautiful and comes equipped...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Kihei
