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 '%Ekahi Village%') AND sleeps>=1 order by rating desc LIMIT 0, 20
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
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
Hawaii> Kihei
You can hear the waves crash against the shore from your lanai or perhaps you would prefer to enjoy it from your own private balcony. This unit is adorned with trinkets and decor from all over Japan providing the feeling of appreciation for its ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
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
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
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
Hawaii> Kihei
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
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
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
Remodeled, ground floor condo tucked in the lush tropical foliage of Wailea Ekahi Village. #26B is a large 1 bedroom, 2 bathroom with a wide open floor plan and lanai leading out to the grassy lawn. Tons of windows allow natural light to ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Wailea Ekahi Village Resort is located on the world famous Keawakapu Beach. Low rise buildings built in clusters sprawl across 34 acres of colorful gardens, making it a very popular vacation choice for guests looking for a great location, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
We recently hosted several prominent Wailea-area realtors to our condo. Their consensus is that Ekahi 26C has the most spectacular ocean views of any condo in Wailea Ekahi Village!
Enjoy the best that Maui has to offer in Wailea Ekahi ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Listen to the waves calmly lap against the shore as you drink your coffee on your own private lanai. Enjoy cooking your favorite meal in a newly renovated kitchen equipped with stainless steel appliances, custom cabinetry, and granite counter ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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.
We purchased this first ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
This spacious one bedroom, two bath ground-floor condo is just steps away from the pool and a short walk through the beautiful grounds to the beach. Free parking a few steps away.
This condo has a California king bed in the air ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Wailea Ekahi Village tropical vacation condos are situated above Maui's beautiful Keawakapu Beach and close to all the top Wailea resort hotels. Enjoy easy access from your vacation condo at Wailea Ekahi Village to the restaurants and ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Wailea
Ekahi Village 27C is a beautifully-decorated, updated and meticulously-maintained one bedroom, one-and-a-half bathroom condo in South Maui's prestigious Wailea resorts. Fully air conditioned for your comfort, the condo features a very spacious ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
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
Hawaii> Kihei
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
