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
"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
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 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
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
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
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
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
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
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
Oceanfront complex, one-bedroom, one-bath, single-level, ground-floor corner unit.
Quiet location. No traffic noise (you are in paradise, there should be none). The condo is located in the 'Lower Village' just steps from one of the 3 quiet ...
- 2 bedroom
- 1 bathroom
- Sleeps 5
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
The main pool, pool deck, and beach gate will be closed from June 3, 2024 to June 14, 2024 to clean, restore, and re-seal the pool deck. The other 3 pools on property will remain open during this time. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Wailea Ekahi #52E is a beautifully renovated studio condo with tropical garden views. The complex is nicely situated near the famous Keawakapu Beach. The unit is on the second floor and features a King bed with a ceiling fan and an oversized air...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Wailea
COMPLETELY RENOVATED WITH GREAT LOCATION . WONDERFUL MORNING AND EVENING OCEAN VIEWS. LOCATED NEXT TO ONE OF THE 'QUIET' POOLS FOR AFTERNOON COOLING OFF.
Located on 33 acres ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Wailea Ekahi 33A is a beautiful, romantic, family friendly, 1,100 square-foot 1 bedroom, 2 bath condo in a magnificent, lush tropical paradise resort on spectacular Keawakapu beach. Views are of a tropical garden with partial ocean and mountain ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Wailea, Maui
Welcome to my sunny Wailea Paradise! This refreshed and tastefully decorated second-floor condo (Unit 45F) has fantastic ocean and garden views and is the perfect spot for a romantic getaway or family vacation. Keawakapu Beach is just a short ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Wailea
