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
P L A T I N U M R A T I N GCoralTree Residence Collection Hawaii’s signature Platinum category rating is reserved for those residences that exemplify outstanding interior quality, comfort and design. Platinum residences reflect luxurious, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea-Makena
Surrounded by tropical blooms, this spacious and uniquely laid out suite boasts fantastic ocean views. Select a book from the extensive collection or enjoy an afternoon nap on one of the three separate lanais – one completely secluded in the...
- 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! ...
- 2 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. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
The first photo is just a section of the incredible ocean view from the two west facing lanais and the dining room window. Wailea Ekahi 14F is a luxurious upper-floor 2-bedroom condo with a breathtaking 180-degree ocean view, situated in a ...
- 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. ...
- 2 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 ...
- 1 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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
If it’s privacy you want, Wailea Ekahi Village 39A is tucked discreetly behind a row of towering tropical plants offering guests a private oasis to relax, entertain or enjoy a family barbecue.Tasteful décor and updated appliances inside ...
- 1 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
G O L D R A T I N GCoralTree Residence Collection Hawaii’s Gold category residences combine refined and stylish interiors with superior home conveniences. Each Gold residence maintains upgrades in interior design motifs and coordinated ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
G O L D R A T I N GCoralTree Residence Collection Hawaii’s Gold category residences combine refined and stylish interiors with superior home conveniences. Each Gold residence maintains upgrades in interior design motifs and coordinated ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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 ...
- 0 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
[TA-164-628-0704-01]
Welcome to Hale Wailea 6D located within the Wailea Ekahi Village. Our quiet, newly listed & updated, spacious 2nd floor unit is a short walk from the newly renovated Village pavilion, pool, and award winning ...
- 1 bedroom
- 1 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Escape to paradise at Wailea Ekahi Village 4A, Maui's dream vacation rental. This spacious 2-bedroom, 2.5-bathroom townhouse offers the perfect blend of indoor comfort and outdoor living.
***construcion notice: THE PAVILION POOL DECK, ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kihei
Prime Location & Ocean Vistas: Escape to Maui's paradise at Wailea Ekahi Village unit 5F. This charming 2-bedroom, 2-bathroom condo boasts a prime location near the beachfront pool, pavilion, and Wailea Beach Walk. Relax on the second-floor ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei