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 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 ...
- 2 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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
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 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
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 ...
- 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-conditioned 2-bedroom, 2-bath unit is immaculate and beautiful and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
