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
Nestled in the prestigious Wailea Ekahi Village, condo 30D is an exquisitely decorated island-inspired vacation rental that offers a perfect blend of luxury and comfort with breathtaking ocean views. The lanai provides an idyllic setting for ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea-Makena
Nestled in the heart of Wailea, Wailea Ekahi 38F is an exquisite vacation rental that offers a luxurious and serene Maui escape. This stunning two-bedroom, two-bathroom condo takes full advantage of its second floor positioning and boasts ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
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 you’re seeking privacy and relaxation, Wailea Ekahi Village 39A offers a secluded Maui retreat nestled behind a lush row of towering tropical plants. This hidden gem provides a tranquil oasis perfect for unwinding after a full day exploring...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
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
Wailea Ekahi 3E is a charming one-bedroom vacation rental located in the picturesque Wailea Ekahi Village. Situated on the second floor, this condo offers elevated views over the tropical grounds lush with colorful island landscaping.
The ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Ekahi 4B is a charming ground-floor vacation studio nestled on a gentle slope in the picturesque Wailea Ekahi Village. This island hideaway offers a unique blend of accessibility and privacy, featuring a secluded back lanai enveloped by ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Wailea
Escape to Wailea Ekahi 15E, a comfortable 600 square foot vacation rental in the luxurious Wailea community. This vacation rental condo offers the the perfect blend of island charm, with it's elevated second floor location overlooking the ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Wailea
Wailea Ekahi 22F is located in an ideal location, closest on property (a short walk) to Keawakapu Beach and the Wailea Ekahi beachfront swimming pool and recently remodeled beach pavilion. Whip up some happy hour drinks and snacks in your ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
This Wailea Ekahi Village residence completed a beautiful renovation in 2022. From colorful artwork to comfortable and sleek furnishings, you will instantly recognize why this Wailea vacation rental earned our highest internal ranking of ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Welcome to Wailea Ekahi 17B, a one-bedroom residence in beautiful Wailea! This vacation rental offers a spacious and comfortable living space, perfect for couples or small families looking for a relaxing getaway.
Step onto the large lanai...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Enjoy a relaxing indoor/outdoor tropical vacation experience from this ground floor ocean view vacation rental. Start your morning on the lanai with a freshly brewed cup of coffee and walk out on the sprawling grass lawn to feel the soft grass ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
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
*** Low season fall 2024 discount. 15% off nightly rate on all travel dates from September 10 - December 15, 2024.
Prime Location & Ocean Vistas: Escape to Maui's paradise at Wailea Ekahi Village unit 5F. This charming 2-bedroom, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
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
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
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
