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, 50
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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
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...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Welcome to Palms at Wailea 2304. Come to Wailea to enjoy the most beautiful beaches and best restaurants Maui has to offer. Get ready to make long-lasting memories while relaxing at this recently updated two-bedroom condo at the beautiful Palms...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
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
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 ...
- 4 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
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 ...
- 3 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 #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 ...
- 2 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-conditioned 2-bedroom, 2-bath unit is immaculate and beautiful and ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
If you are looking for a perfect getaway 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 ...
- 3 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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Luxury awaits at this beautifully decorated Palms at Wailea condo. With an open and inviting floor plan, there is plenty of room to spread out after a day of enjoying all that Maui has to offer. The private ground floor location makes this the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
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
Hawaii> Kihei
Palms at Wailea #307 is a tastefully remodeled, spacious 1Bd/2Ba unit with all the comforts of home! It is conveniently located on the ground floor and it is a close walk to the picturesque resort pool. The unit has split system A/C in the ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Welcome to Palms at Wailea 703, your luxurious oasis in the heart of Wailea Resort, Maui's premier destination. This ground-floor, fully air-conditioned condo offers over 1,400 square feet of meticulously upgraded space. Every inch of this ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Escape to paradise at The Palms at Wailea Hotel & Resort! Our Mediterranean-style condo rental is nestled on a hillside, offering breathtaking views from the 2 porches! This unit accommodates up to 4 guests, complete with access to a community ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea-Makena
Welcome to our Wailea Condo at the Palms of Wailea. Our condo is a large 1200 square foot newly renovated two bedroom, two bathroom condo that is walking distance to some of the best beaches in the world. For your convenience, we provide beach ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kihei
#2104 is a spacious and recently refreshed 2-bedroom, 2-bathroom condo in Maui with fun tropical accents and cozy comfort. It offers approximately 1500 sq. ft. of living area, including a large lanai. This unit features central air conditioning ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Palms at Wailea #1105 you can enjoy beautiful ocean views and outdoor dining from your large lanai. This property has a fully equipped kitchen, washer and dryer, AC in the master bedroom and ceiling fans throughout. For those who like to stay ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Palms at Wailea #1101 is an ocean view ground floor 2 bedroom 2 bath condo with a full kitchen, washer and dryer, high speed wireless, and is fully air conditioned. It can sleep up to 6 people.
The ocean views from Palms at Wailea #1101 are ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Palms at Wailea #1902 is an upstairs 2 bedroom 2 bath unit which sleeps 6 and has an open, spacious floor plan. It features air conditioning throughout, a full kitchen, washer and dryer, and high speed internet. Stainless steel oven and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
The name PALMS AT WAILEA aptly describes the feel of this beautiful complex. Located above the pristine shores of Keawakapu Beach, this impeccably furnished home will provide comfort, luxury, and plenty of room to spread out while you explore ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Hawaii Tax ID: TA-144-497-4592-01
QUIET PRIVACY IN PARADISE
The Palms #901 is a luxurious one-bedroom two-bath ground floor villa tucked away in a private and quiet corner in one of the nicest locations on the property. Often ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Palms at Wailea 2206, offers the perfect location in Wailea. This 2-bedroom/2-bath unit surrounded by the lush landscaping make this a great Hawaiian getaway!
As you enter you will immediately be drawn to the fantastic views! Your large ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Palms at Wailea #1207 is a lovely ground-floor unit at a much sought-after complex. It is a spacious 2 bedroom, 2 bath unit with a fully equipped kitchen, renovated bathrooms, new flooring throughout, washer and dryer, and wifi. The primary ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
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. In addition there is ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Welcome to our magnificent Oceanview retreat, nestled within the highly coveted Palms at Wailea. This nicely updated ground floor 1-bedroom, 2-bath unit promises an idyllic Hawaiian escape, complete with all the essential comforts and amenities ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Fabulous condo! This luxury, private unit is located on the top floor and has all the amenities this popular complex affords.
This spacious 2 bedroom 2 bath unit has approximately 1475 sq. ft. of lanai and living area! The spacious ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
The Aloha Spirit is Alive and Well in Maui! It's absolutely beautiful. The best beaches , clean air, amazing sunsets, rainbows, humpback whales and wonderful hiking, along with the best restaurants. The people are the best! Lahaina is gone ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Book with us and come to Maui to explore everything we have to offer!
Enjoy the beautiful lanai and grounds of the Palms at Wailea with this elegant vaulted ceiling two bedroom two bath condominium in north Wailea. The gardens are ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Palms of Wailea #1605 It is an elegant ground floor, tropical garden view 2 bedroom 2 bath unit with a fully-stocked kitchen, washer and dryer, partial air conditioning, and complimentary wifi. The primary bedroom suite is luxurious with a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Palms at Wailea 1405 offers the perfect location in Wailea. This 2-bedroom/2-bath ground-level unit surrounded by lush landscaping and ocean views make this a great Hawaiian getaway!
Maui's most exclusive location with the best weather is...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Palms at Wailea #603 has a fully equipped kitchen, washer and dryer and unlike most units at the Palms, it is fully air conditioned. It has flat screen TVs, high speed wireless that is complimentary. There is a king bed in the master and a queen...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
The main living area boasts expansive high beam ceilings that add to the wonderful flow of air blowing in off the Shores of Maui. Very spacious and open, bringing the outdoors into your living room and kitchen! This unit is situated in the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Palms at Wailea #1803 is ground floor 1 bedroom, 2 bath garden view unit with a/c in the bedroom only, a fully-equipped kitchen, washer & dryer, 2 flat screen TVs, DVD player, telephone, and wireless Internet. The bedroom features a California ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
This cool, ground floor condominium is the most spacious 1200 sq ft two-bedroom 'C' plan, with sunken living room, brand new designer furniture, and extensive travertine and granite surfaces. Oceanic Time Warner cable, internet, phone, and ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Palms at Wailea 601 offers the perfect location in Wailea. This 2-bedroom/2-bath ground level unit surrounded by the lush landscaping makes this a great Hawaiian getaway!
Maui's most exclusive location with the best weather is the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
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
