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 '%Ekahi Village%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Ekahi means #1 in Hawaiian and this Maui luxury complex lives up to its name. Located in Wailea, Maui – the sunny side of the island – Ekahi Village sits on 34 acres of lush Hawaiian landscape and 1.5 mile long Keawakapu Beach.
Take ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kihei
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
HI> Kihei
Aloha and thank you for taking the time to consider staying in our beautiful space in paradise. 29F is one of the top units available in the Ekahi Village with the best view. Wake up to the sounds of tropical birds singing, waves crashing - ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
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!
CANCELLATION ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Situated on the hill overlooking Ekahi Village, our Ekahi 46D condominium offers great views of the ocean from the living room, kitchen and lanai.
The vaulted ceilings in this 2nd level condo enhance its open and airy feeling and nicely ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
A modern 2 bedroom, 2 bath condo w. extra bunk beds and an amazing ocean view!
South Maui is one of the most beautiful destinations in all of Maui and Wailea Ekahi Village is the perfectly-situated, beachside resort we call home . Guests ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailea
Ekahi means #1 in Hawaiian and this Maui luxury complex lives up to its name. Located in Wailea, Maui – the sunny side of the island – Ekahi Village sits on 34 acres of lush Hawaiian landscape and 1.5 mile long Keawakapu Beach.
Take ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kihei
Waiting for you to come and unwind. Just bring yourself, everything else is HERE!
Towels, beach chairs, boogie board, whatever you need!!!
This beautiful second floor unit has an open, beautiful garden/mountain view. The vaulted ceilings give ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Wailea,Kihei
Located on the ground floor this lovely one bedroom, two bathroom unit has a 400 square foot lanai with picturesque garden and ocean views and Quiet Pool 3 just steps away. Patio equipped with gas bbq, spacious patio seating & chaise lounge. ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Welcome to Paradise!!
This 2 Bed, 2 Bath Luxury Ekahi Village Unit is impeccably appointed and maintained. Starting Summer 2019, it is being offered to rental guests for the first time in over 20 years [and possibly for the first time ever]....
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
View! View! View! Imagine sipping gourmet coffee while enjoying the ocean view and listening to the birds chirping? Imagine a sunset dinner on the lanai or taking a nap on the chaise lounge chair while the ocean breeze comforts you? Our spacious...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea
Wailea Ekahi Village 27C is a beautifully-decorated, extensively-updated and meticulously-maintained one bedroom, one-and-a-half bathroom condo in one of sunny South Maui's most prestigious oceanfront resorts. The condo features the exclusive ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Welcome to Wailea Ekahi 50E, our deluxe condo for two.
We are on the 2nd (top) floor with beautiful ocean and garden views and wonderful tropical breezes. In addition, there are ceiling fans throughout the unit.
The large living room-dining...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Kihei
Wailea Ekahi Village 44C is a lovely and romantic two-story townhouse. The downstairs lanai is surrounded by lush gardens with the sweet aroma of native flora. The upstairs lanai affords a panoramic ocean view and breathtaking sunsets.
This ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Vacation getaway amenities don't get much better than those offered at the world-famous Wailea Ekahi Village. Whether you're looking for a sandy beach experience, a comfortable place to relax out of the sun, or just a home-base to explore the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
