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, 50
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 ...
- 2 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
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!
VIEWS:...
- 3 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. ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Condo 1 bedroom, 2 bath (sleeps 4)
PRIME location on the front row in lower Wailea Ekahi, Wailea. Listen to the sound of the waves and enjoy the ocean views. Famous Keawakapu Beach is just steps away! Beautiful ocean views from every room. ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
"Comfortable luxury with a magnificent view," wrote a recent guest. Wailea Ekahi 14F is an upper-floor 2-bedroom 2-bath condo. Situated in a quiet tropical garden setting in the center of Wailea Ekahi Village, far from road and pool noise, with ...
- 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. ...
- 3 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 ...
- 2 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
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...
- 2 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
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 ...
- 1 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
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 ...
- 2 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.
Unwind in Style:
Indulge in expansive ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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
Welcome to Codge’s Beach House! This 2 bedroom , 2 bathroom unit (SLEEPS 6), was remodeled in late 2022 with ceiling fans, new split ductless AC's, brand new kitchen and bathroom and with a lot of thought for comfort and ease of use. We ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Imagine waking to the gentle lull of the trade winds, sunlight streaming through your lanai, and the promise of a perfect day in paradise. Welcome to Unit 42A at Wailea Ekahi Villas, a meticulously remodeled one-bedroom, two-full-bathroom haven ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to my sunny Wailea Ekahi Paradise! This unit is a remodeled, expanded and wonderfully furnished 2 bedroom 2 bathroom ground-floor condo (Unit 43A) is the perfect spot for a family or group vacation! Keawakapu Beach is just a short walk ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Ekahi 4D is a charming studio vacation rental perfect for the couple or solo traveler. This second-floor unit offers an elevated retreat with a bird's eye view of the surrounding tropical landscaping and peek-a-boo ocean views.
The ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Wailea
Wailea Ekahi 7B is a beautifully appointed vacation rental located within the serene Wailea Ekahi Village. This spacious one-bedroom, two-bathroom condo offers a perfect blend of comfort and luxury.
The interior of Wailea Ekahi 7B features a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Ekahi 11C is an ideal Hawaiian retreat for friends or families traveling together. Each of the two bedrooms in this spacious condo feature a private lanai and en suite bathroom. Many guests return to this condo year after year for its ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Wailea Ekahi Village 19B is a two-story, two-bedroom, two-and-a-half-bath townhome that comfortably accommodates up to four guests. This beautifully designed residence features island-inspired décor, creating a cozy and inviting atmosphere ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Welcome to Wailea Ekahi 25D, an exquisite vacation rental that embodies the essence of luxurious island living in Wailea. This one-bedroom, one-bathroom second-floor condo offers a enjoys elevated views of the 32-acre manicured grounds. Vaulted ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Ekahi 35C is a stunning vacation rental located in the desirable Wailea community. This beautifully appointed one-bedroom, one-bathroom condo offers an ideal blend of comfort and luxury. Make use of the ground floor location to really ...
- 2 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
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 floorplan and lanai leading out to the grassy lawn. Tons of windows allow natural light to brighten...
- 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
Discover Wailea Ekahi 39E, our exquisite 1-bedroom, 2-bath condo with stunning ocean views. Whether you're seeking a romantic getaway, a solo escape, or a tranquil spot to work remotely, this condo provides the ultimate coastal ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Experience Maui paradise at Wailea Ekahi 21B, a fully renovated ground-floor one-bedroom/two-bath vacation condo nestled within the prestigious Wailea resort district. This beautiful unit showcases a designer remodel, offering a spacious, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Make your Maui dreams come true at Wailea Ekahi 35D! This vacation rental is perched on the top floor with a private entrance surrounded by manicured grass lawns, colorful bougainvillea, and fragrant plumeria trees.
This modern remodeled ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Our large 1 bedroom 1 bathroom has been recently renovated for your comfort. There is a king bed and a walk-in shower. Private lanai. Air conditioning in all rooms. Very well stocked kitchen. new fridge with water dispenser and ice maker. Beach ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Wailea Ekahi Village is a tropical oasis that sits right on Ke'awakapu Beach, considered by locals to be Maui’s best beach. Surrounded by major resort hotels, shopping centers, and championship golf courses, it's a vacationer's dream! This ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Unwind in this gorgeous second-floor, 1-bedroom, 2-bathroom corner unit with breathtaking ocean views and lush tropical gardens right from your private lanai. "Serenity" offers the perfect blend of comfort and elegance, with bright natural ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
The master bedroom suite offers a King bed, sitting area, TV, DVD, air conditioning, a private lanai with an Ocean view plus chaise lounges for sunning. Soaring ceilings and overhead fan add to tropical breezes for comfortable sleeping.
The ...
- 2 bedroom
- 3 bathroom
- Sleeps 5
Hawaii> Wailea
Please read under Rules & policies-Rental Agreement the new COVID-19 Rules & Guidelines- and the Waiver of Liability Agreement that must be signed upon arrival.
Welcome to our remodeled and reconfigured ground level 1 bedroom, 2 full ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Our spacious Wailea Ekahi 1 bedroom, 2 bath condominium is fully appointed and includes phone, radio, high speed wi-fi internet connection, color TVs with DVD and cable, private laundry center and personal touches for your enjoyment and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Wailea Ekahi 34D is located in the lower village, on the greenbelt, with direct views of the ocean, Molokini and Kaho'olawa.
This condo has been completely renovated from the studs in. Furnished with high end furniture, fixtures and ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kihei
Unit 45B is located in Building 45 on the ground floor. This lovely one bedroom, two bathroom condo has a 400 square foot lanai with picturesque garden and ocean views and Quiet Pool 3 just steps away. Patio equipped with spacious patio ...
- 2 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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Wailea Ekahi 47F is surrounded by lush gardens, offering guests a private hideaway to relax while being serenaded by birds. Our unit is a five minute walk to the sparkling sands of Keawakapu Beach. You'll stroll through Wailea Ekahi's lush ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
[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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Ekahi Village #48-D is an impeccable studio unit on the second floor which provides picturesque Ocean and Garden views from the lanai. This tastefully-appointed suite features upscale furniture including a king bed and a sofa sleeper ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Wailea
Welcome to Wailea Ekahi 48A, offering the largest floor plan with gorgeous ocean view! This beautiful 2 bedroom/2.5 bath is the perfect retreat for couples or families. The first level of this spacious condo features a sunken living room ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kihei
