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 '%Wailea Ekahi%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Condo Details:
**This is a NON-Smoking Unit AND a non-smoking property. All forms of smoking or vaping is prohibited in the units, lanais as well as common areas including the parking lot. **
**This is a PET free unit. ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Nestled in the prestigious Wailea Ekahi Village, condo 30D is an exquisitely decorated island-inspired vacation rental that offers a perfect blend of luxury and comfort with breathtaking ocean views. The lanai provides an idyllic setting for ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea-Makena
Nestled in the heart of Wailea, Wailea Ekahi 38F is an exquisite vacation rental that offers a luxurious and serene Maui escape. This stunning two-bedroom, two-bathroom condo takes full advantage of its second floor positioning and boasts ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Our Family has Two - Two Bedroom/Two Bathroom Units above and Below Each other in Ekahi Village. This is great for Families or large groups traveling together. Both units tend to be among the most popular in the entire complex! ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Welcome to this Wailea Ekahi Condo (Unit 33C -LINKS TO OUR PERSONAL WEBSITE ARE LOCATED BELOW). Our one bedroom, one bath ocean view unit is located within Wailea Ekahi Village, one of South Maui's premiere oceanfront resort developments. ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
"Comfortable luxury with a magnificent view," wrote a recent guest. Wailea Ekahi 14F is an upper-floor 2-bedroom 2-bath condo. Situated in a quiet tropical garden setting in the center of Wailea Ekahi Village, far from road and pool noise, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea-Makena
Our Family owns 2 - Two bedroom units above and below each other in Ekahi Village. This is perfect for large Family vacations or groups of friends traveling together. Be together, but still enjoy your own comfortable bedroom and bathroom. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Aloha and mahalo for your interest in our spot in Paradise. Ekahi says it all. This one bedroom (with comfortable sleeper sofa), two-bath renovated unit is on the ground floor. This means the lanai is much larger than upper units. It also means ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Luxurious Tropical Retreat - Unit 31D is truly "one-of-kind"!
Ideally located overlooking the lower Ekahi Village, Unit 31D provides our guests with the best of everything Maui has to offer: spectacular views, privacy and a short stroll ...
- 2 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Wailea
Unit 1B is located on beautiful Keawakapu Beach in gorgeous Wailea. This totally remodeled lower village, ground floor unit has one large lanai with a beautiful ocean view and Ekahi’s 34 acre tropical landscaped gardens. It has a lanai table ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
If you’re seeking privacy and relaxation, Wailea Ekahi Village 39A offers a secluded Maui retreat nestled behind a lush row of towering tropical plants. This hidden gem provides a tranquil oasis perfect for unwinding after a full day exploring...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Rentals presents: Wailea Ekahi Village 8E - Ekahi means #1 in Hawaiian and that is exactly what Ekahi Village is - 1 of Wailea's top luxury beachfront condominium resorts. Located directly on Keawakapu Beach at the north end of Wailea on ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Ocean View, King Bed, quiet Ground floor Studio condo, in the beautiful Wailea Ekahi Resort, near one of the 4 private pools and a short walk to the beach.
Enhanced cleaning protocols and private ground floor entrance with Lanai opening ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Welcome to your piece of paradise in a completely remodeled, fully furnished, ground floor unit! Our home is located in Wailea Ekahi, one of the few Kihei and Wailea properties located directly on the beach; no need to cross a road or even ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Our home is in the 1st (and closest) phase of Ekahi and is just steps away from the main pool pavilion, the beach, and a second pool even closer. Ekahi is a huge complex, so check the complex maps we included before booking. Some units are in ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
*** Low season fall 2024 discount. 15% off nightly rate on all travel dates from September 10 - December 15, 2024.
Escape to paradise at Wailea Ekahi Village 4A, Maui's dream vacation rental. This spacious 2-bedroom, 2.5-bathroom ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kihei
Retreat and relax in this comfortable, serene, light and airy, completely remodeled unit.
This ground floor unit in the quiet, beachfront Wailea Ekahi Village won't ask you to carry your bags up a single step, while still providing a ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to Codge’s Beach House! This 2 bedroom , 2 bathroom unit (SLEEPS 6), was remodeled in late 2022 with ceiling fans, new split ductless AC's, brand new kitchen and bathroom and with a lot of thought for comfort and ease of use. We ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Welcome to my sunny Wailea Ekahi Paradise! This unit is a remodeled, expanded and wonderfully furnished 2 bedroom 2 bathroom ground-floor condo (Unit 43A) is the perfect spot for a family or group vacation! Keawakapu Beach is just a short walk ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Wailea Ekahi 3E is a charming one-bedroom vacation rental located in the picturesque Wailea Ekahi Village. Situated on the second floor, this condo offers elevated views over the tropical grounds lush with colorful island landscaping.
The ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
