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 '%Palms at Wailea%') AND sleeps>=1 order by rating desc LIMIT 0, 20
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
Hawaii> Kihei
We completed our kitchen remodel in December 2023! Check out the photos!
Welcome to Palms at Wailea 503, your beautifully remodeled sanctuary in paradise! This is a two-bedroom two-bathroom condo in the prestigious Wailea Resort area. One...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Palms at Wailea #803 has all the comforts of home in a beautiful tropical setting. This unit features a fully equipped kitchen as well as an in-unit washer and dryer. You can keep cool with the split-system A/C, and complimentary wifi is ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Palms at Wailea 1904 is a nicely updated and well-located 2-bedroom, 2-bathroom condo in the beautiful area of Wailea. This condo is the perfect getaway for families or couples traveling together. It features a private lanai with lush garden ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
The Palms at Wailea 705, a 2 bedroom, 2 bath ground level unit, is your perfect Wailea location. Featuring Mediterranean accents and beautifully manicured grounds, you will be welcomed by the open and inviting living space. Complete with large ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Palms at Wailea 1203, offers the perfect location in Wailea. This 2-bedroom/2-bath ground-level unit surrounded by lush landscaping makes this a great Hawaiian retreat!
Ideally situated just uphill from gorgeous Keawekapu Beach, The Palms...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Palms at Wailea #205 is a fully remodeled, 2 bedroom / 2 bath unit with a tropical garden view, with a partial ocean view from the lanai and living room. Located on the ground floor, this spectacular condo has a fully equipped kitchen, Cable TV,...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
The fabulous Keawakapu Beach is just a short 10 min stroll. The Palms at Wailea is a gorgeous property with a large pool and hot tub. A magnificent view of the ocean from the pool area. Unit #1801 is a spacious 2 bd, 2 ba ground floor unit. It ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Why stay at a crowded hotel when you can have the entire condo to yourself? We are ready to welcome our guests back and are excited to again share Hawaii with you all.
If you are looking for a perfect get away in paradise, this is it! This ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maui
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...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Why stay at a crowded hotel when you can have the entire condo to yourself? We are ready to welcome our guests back and are excited to again share Hawaii with you all.
If you are looking for a perfect get away in paradise, this is it! This ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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
Hawaii> Wailea
Why stay in a crowded hotel when you can stay in this spacious, stunning, air conditioned 5 Star condo? The Palms at Wailea # 1903 has been completely renovated and has an absolutely fabulous location on Maui... on the sunny side of the island. ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Palms at Wailea #308 is a 1 bedroom, 2 bath unit on the second floor with split system A/C throughout. Over April to June, 2023 we completed a full renovation throughout the entire unit! The unit has retained a Hawaiiana feel in the Plantation ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Palms at Wailea 102 had a total top-to-bottom renovation in 2021, professionally designed and decorated, luxury at its finest. Enjoy amazing ocean views from the primary bedroom, living room, and lanai. This 2-bedroom/2-bath offers the perfect ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Palms at Wailea 1201! Perfect location in Wailea! This 2-bed/2-bath condo offers the perfect getaway for families or couples traveling together. Enjoy lounging or dining al fresco on your private lanai! Complete with seating for six. The floor ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Palms at Wailea #802 this spacious, tranquil 1022 sq ft unit is very spacious & comfortable. It’s fully furnished with travertine tile floors throughout the unit, has an expansive living room with ocean breezes and ceiling fans, a beautifully ...
- 1 bedroom
- 2 bathroom
- Sleeps 3
Hawaii> Wailea
Palms at Wailea #1507 is a spacious, beautiful condo with an ocean view located in the desirable inner courtyard just a short stroll to the picturesque pool, all without climbing steep stairs. Fully air conditioned with a 3 zone split system, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> Wailea
Beautiful Updates in 2022! Palms at Wailea #1508 is a recently updated upstairs ocean view 2 bedroom 2 bath unit in the world famous Wailea community villa. Second to none, this is the ultimate condo with a full kitchen, washer and dryer, new ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
