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, 30
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
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
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
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
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 ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
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
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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> 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 ...
- 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This ground floor unit, set amid rolling green hills and colorful flowers, features sleek cabinetry, granite countertops and cool tile flooring. The carpeted living area opens to a garden view lanai for a seamless indoor/outdoor living ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
For a vacation condo that feels like a private home, select this two story condo with a sunken living room and cascading lanai. Four sets of sliding doors on the first floor provide garden views and invite tropical breezes into the open floor...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Wailea
This condo has been fully renovated in the summer of 2021. Open the windows or lanai doors and let the Maui breeze blow through as you relax in this comfortable island suite. You'll delight at the explosion of fuchsia bougainvillea blooming all ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Enjoy three garden view lanai areas from this spacious second floor Maui vacation condo. Granite countertops in the kitchen and both baths and large, flat screen TV are a few of the updates to this condo.Families and couples traveling together ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea-Makena
In a quiet corner, close to the ocean and resort’s pool pavilion, Wailea Ekahi Village 7A offers a place to relax and unwind. Stretch your legs in the morning with a stroll on the cool, green grass just off the lanai and surround yourself with...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
This second floor, one-bedroom vacation condo is ideally situated with the paddle tennis court and one of the resort’s four swimming pools on one side, and sun-kissed Keawakapu Beach on the other. Garden and ocean views from the kitchen and ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea-Makena
Gold Rating - CoralTree 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 décor. ...
- 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
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
