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, 30
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 new photos!
Welcome to Palms at Wailea 503, your beautifully remodeled sanctuary in paradise! Nestled in the prestigious Wailea Resort area, this two-bedroom two two-bath ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Newly updated spacious 2 bedroom condo in upscale resort of Palms at Wailea with full AC throughout the unit. The beautiful condo is located in a private corner, yet very close to the ocean-view pool. With a peek-poo ocean view large patio most ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Beautiful ocean views greet you as you enter our updated condo. Two large lanais for dining and relaxing, a 7 minute walk to the ocean, a 3 minute walk to the pool, and a 15 minute walk to the Shops At Wailea. Condo has a new mattress, new ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> KIHEI
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! Nicely updated and great Wailea location! This 2bed/2bath condo offers the perfect getaway for families or couples traveling together. Take in the lush garden views from your private lanai. Spend the day lounging with your ...
- 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 2bedroom/2bath ground level unit surrounded by the lush landscaping make this a great Hawaiian retreat!Ideally situated just uphill from gorgeous Keawekapu Beach, The Palms at ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Discover the pinnacle of luxury island living in Wailea Maui, where this newly remodeled 2-bedroom, 2-bathroom condo in the prestigious Palms of Wailea complex awaits discerning guests. Unit 1406 is not just a place to stay; it's an upscale ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
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
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
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. We just completed a full renovation throughout the entire unit! The unit has retained a Hawaiiana feel in the Plantation Style. Kitchen ...
- 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 2bedroom/2bath offers the perfect ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Palms at Wailea 1201! Perfect location in Wailea! This 2bed/2bath condo offers the perfect getaway for families or couples traveling together. Enjoy lounging or dining al fresco on your private lanai! Complete with BBQ and seating for six. The ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Palms at Wailea #1005 is a ground floor ocean view 1 bedroom 2 bath unit with a full kitchen, washer and dryer, room AC in the master bedroom and ceiling fans throughout. It has complimentary high speed internet service and a private barbecue. ...
- 1 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, a beautifully remodeled gourmet kitchen with all ...
- 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
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
Palms at Wailea #305 is a ground floor 2 bedroom, 2 bath unit close to the pool. It features split system air conditioning throughout the unit, a fully-equipped kitchen, washer & dryer, 2 flat-screen televisions, telephone with long distance to ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Fabulous condo! This luxury Palms at Wailea unit is located near the spectacular pool and jacuzzi and all the amenities this popular complex affords.This central air condition 2 bedroom 2 bath unit is immaculate and beautiful and comes equipped ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
If you are looking for a perfect get away in paradise, this is it! This luxury Palms at Wailea unit is located near the spectacular pool and Jacuzzi and all the amenities this popular complex affords.This spacious fully air-conditioned two ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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 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
Luxury awaits at this beautifully decorated Palms at Wailea condo. With open and inviting floor plan there is plenty of room to spread out after a day of enjoying all that Maui has to offer. Private ground floor location makes this the perfect ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei