select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
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. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
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 onto ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> 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 to ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Wailea
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
HI> Kihei
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.**
Our beautiful ocean view unit is situated in ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Stay local, not corporate. WaileaRentals presents: Wailea Ekahi Village - 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...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea
LOCATION, LOCATION, LOCATION-
Our Studio Condo in Building 9 is just steps from the Ocean Front Pool, Pavilion and Ocean. With Sweeping Views of the Greenbelt and Partial Ocean Views.
Located in the lower village just steps from the beach, ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Kihei
The master bedroom suite offers a King bed, sitting area, TV, DVD, air conditioning, a private lanai with an Ocean view plus chaise lounges for sunning. Soaring ceilings and overhead fan add to tropical breezes for comfortable sleeping.
The ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Kihei
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 gas grill and...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Condo 1 bedroom, 2 bath (sleeps 4)
PRIME location on the front row in lower Wailea Ekahi, Wailea. Listen to the sound of the waves and enjoy the ocean views. Famous Keawakapu Beach is just steps away! Beautiful ocean views from every room. ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea
Wailea Ekahi 34D is located in the lower village, on the greenbelt, with direct views of the ocean, Molokini and Kaho'olawa.
This condo has been completely renovated from the studs in. Furnished with high end furniture, fixtures and decor in ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, note that this has been replaced with a no-contact service for you and our team’s health and ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea
Please read under Rules & policies-Rental Agreement the new COVID-19 Rules & Guidelines- and the Waiver of Liability Agreement that must be signed upon arrival.
Welcome to our remodeled and reconfigured ground level 1 bedroom, 2 full bathrooms ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea
Oceanfront complex, one-bedroom, one-bath, single-level, ground-floor corner unit.
Quiet location. No traffic noise (you are in paradise there should be none). The condo is located in the 'Lower Village' just steps from one of 3 quiet pools and ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
HI> Kihei
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, note that this has been replaced with a no-contact service for you and our team’s health and ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea, Maui
