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 Ekolu%') AND sleeps>=1 order by rating desc LIMIT 0, 50
ALOHA!
Welcome to Our Maui Condo where Hoʻokipa means "hospitality"! You're sure to enjoy our Wailea Ekolu home and the Maui sunsets with SPECTACULAR OCEAN VIEWS of Molokini and the neighboring island of Kahoolawe.
Our condo is ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Welcome to Happy Everything!
10 Wailea Ekolu Complex!
A premier, fully re-modeled, well appointed and comfortable 2-story townhouse situated on hole 10 of the famous Wailea Blue Golf Course at beautiful Wailea, Maui. Comfortably ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kihei
Welcome to ocean view luxury in the heart of Wailea; welcome to your perfect Maui getaway.
This 2 bedroom, 2 bathroom renovated condo in the Wailea Ekolu neighborhood gives you all the amenities of home, combined with all the luxury of a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Aloha!
Welcome to our Our Maui Condo! ʻIKE KAI means "OCEAN VIEWS". This wonderful one bedroom, two bath, ground floor condo with BEAUTIFUL OCEAN VIEWS will satisfy even the most discriminating visitor.
Our condo is located on ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
We invite you to share our lovely South Maui condo where you will you'll be enchanted by its beautiful garden setting and expansive ocean views! Located in Wailea Ekolu Village, Unit #803 offers you a meticulously maintained one-bedroom, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Experience the beauty of Maui at Wailea Ekolu 1007, a stunning two-bedroom, two-bathroom ocean view condo designed for relaxation and comfort. Located along the picturesque Wailea Blue Golf Course, this ground floor vacation rental offers ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Aloha,
Welcome to our family gem, location Wailea Ekolu Unit 1704. Our 1070 square foot spacious condo with private lanais, has been a family treasure since it was purchased new in 1979. Newly renovated and restored to its original vintage ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kihei
We invite you to treat yourself to Wailea Ekolu #1106, a refined Hawaiian coastal residence with a chic remodel and a commanding Panoramic ocean view stretching from Makena, Molokini, and all the way out to West Maui. Experience year round ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Experience the comforts of home in a newly renovated, spacious, ocean-view condo. Greet each day from your relaxing private lanai, where each morning’s view and sunset are more stunning than the last.
Enjoy the best panoramic ocean views in...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Welcome to Wailea Ekolu 407, experience breathtaking, panoramic ocean views from main living area and over-sized lanai of this spacious single level luxury condo, in the heart of Wailea and convenient to world class golf, tennis, restaurants and...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kihei
E Komo Mai to our luxury 2 bedroom unit on the 2nd floor with a beautiful ocean view and a spacious interior. From our comfortable lanai seating you have a full 180 degree view of the islands of Molokini, Kahoolawe, Lanai, and the West Maui ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Towering oleander and bougainvillea grace the front entry of Wailea Ekolu 706. Enjoy views out over the tropical grounds and beyond from the elevated second floor positioning of this condo. During the winter months, you can whale watch right ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Spectacular Ocean and Sunset Views!!
A short walk to Wailea’s best beaches.
Newly furnished and well appointed home will provide an exceptional experience.
Wailea Ekolu is peaceful and spacious development with dinning, coffee, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Discover the perfect Hawaiian retreat at Wailea Ekolu Village with this stunning two-bedroom, two-bathroom ocean view rental. This premium condo offers breathtaking views of the Pacific Ocean, Kaho'olawe, and Molokini from its private lanai. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Relax at our quiet 2 bedroom /2 bath condo with stunning views overlooking the Wailea Blue golf course all the way to the ocean. Guests can enjoy amenities like a washing machine, AC, and WiFi during their stay. We hope you'll enjoy your stay at...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to Wailea Ekolu 1106 by Gather, exclusively offered by the Stice Team. This beautifully remodeled two-bedroom, two-bathroom Hawaiian coastal residence offers breathtaking panoramic ocean views stretching from Makena and Molokini to West ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Wailea Ekolu is one of most sought after properties in Wailea as it is nestled on the Wailea Golf Course. It has a quiet and private atmosphere in the lush tropical foliage. Wailea Ekolu has two lovely pool areas and a large pavilion area. ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
This Wailea Ekolu retreat goes hand in hand with your Maui experience. Here you will find a clean, open, beautiful condominium, with an amazing ocean view from everywhere within the condo. This is an ideal retreat, in a perfect setting that's a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea-Makena
Wailea Ekolu #105 is a luxury 2Bd/2Ba condo with scenic views of the ocean, mountains, and tropical garden. The unit has tile floors, contemporary furnishings, three large flat-screen TVs, king bed in master, two twins convertible to king in ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
ENJOY THE BEAUTIFUL MAUI SUNSET! Sharon's spacious, 1,400 square foot Wailea Ekolu condominium is a two bedroom, two bath, ocean view unit. Located on the ground floor, it is surrounded by grass and lush island foliage. The condo accommodates...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Indoor outdoor living with Fantastic Ocean views from this spacious 2 bed/ 2 bath ground floor private condo!
Enjoy early morning walks or a relaxing dip in the pool. This unit has been completely remodeled from top to bottom, all new ...
- 3 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kihei
Welcome to Wailea Ekolu 310, experience breathtaking, panoramic ocean views from main living area and over-sized lanai of this spacious single level luxury condo, in the heart of Wailea and convenient to world class golf, tennis, restaurants and...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Aloha! Wailea Ekolu #604, a 2-bedroom, 2-bathroom, second floor unit which features a fully equipped kitchen, high-speed wireless internet, and a washer and dryer. There is a split system air conditioning throughout the unit to keep your ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Lesli's luxury Wailea Ekolu Village Condominium is a 900-square-foot, one bedroom, two bath, oceanview condo, occupying the ground floor of a two-story building. Ekolu 107 accommodates up to four adults comfortably. It is fully-appointed and ...
- 2 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kihei
Wailea Ekolu #503 is 2 bedroom, 2 bath unit on the ground floor with a panoramic ocean view. The unit has split system AC throughout, a fully-equipped kitchen, washer and dryer, a large flat-screen TV, Blu-ray player, and free wifi. There is a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
When you think of Hawaii you imagine awe-inspiring views, amazing sunsets and the natural beauty of the wild blue Pacific. These sights are a daily pleasure from the comfort of your own private lanai. This beautiful ocean view home is one of a ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Wailea
This extra-spacious two-story town-home-styled condo has no common walls and no one above, with a premiere location at Wailea Ekolu unit 510. Enjoy panoramic ocean views from Makena and Molokini to the West Maui Mountains, from the lanai and ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kihei
You'll enjoy the terrific location of this comfortable 2 bedroom / 2 bath condo. Ekolu 1705 is walking distance to restaurants and shops and a short drive to the beach. Kick back on multiple lanai options, enjoying the lovely trade winds. Sleep ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Hawaii Tax ID: TA-144-497-4592-01
FRONT-ROW UNIT - STUNNING OCEAN & GOLF COURSE VIEWS
Wailea Ekolu #304 is a luxurious condominium situated at the front row of Ekolu on the 15th hole of the Wailea Blue Course with panaromic views...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
A true home-away-from-home with room for the whole family. A townhouse style condominium with room for the whole family to enjoy.
Wailea Ekolu Village features deluxe one- and two-bedroom ocean view and garden view condos. The resort ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Wailea
Enjoy spectacular panoramic ocean views from this 2 bedroom condo in a truly private setting! Location is everything and this unit features lovely ocean views from the living area, dining area, kitchen, master bedroom and three lanais and is ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
NEW LISTING!!! PRICE REDUCED!!! Wailea Ekolu #207 is a luxurious accommodation located in the heart of Wailea, offering breathtaking views of the Pacific Ocean. The name “Ekolu” holds significance as it means “three” in Hawaiian, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to Wailea Ekolu 1605 by Gather, exclusively offered by the Stice Team. This beautiful two-bedroom, two-bathroom condo on the ground floor offers a partial ocean view and a tranquil Hawaiian garden setting. With a seamless single-level ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
This is a premier unit with panoramic ocean views located just minutes to all Wailea Beaches, The Shops at Wailea and Luxury Hotels! This beautiful condo is fully remodeled with tasteful furnishings, top of the line appliances, exquisite ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Aloha! Wailea Ekolu #805, a 2-bedroom, 2-bathroom, ground floor unit which features a fully equipped kitchen with granite counters, high-speed wireless internet, and a washer and dryer. In every room there is a split system air conditioning ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Ekolu 702 is a Premium 2 bedroom, 2 bath top-floor condo ideal for family getaways. This unit was updated in late 2021 with Daikin Split Air-Conditioners in each bedroom and living room. The master suite has a luxurious King bed and the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Wailea Ekolu #906 is a 2 bedroom, 2 bath unit on the 2nd floor with panoramic ocean views, air conditioning, and complimentary wifi. Both bedrooms are equipped with air conditioning and ceiling fans. The open kitchen was just fully renovated ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Enjoy the fully remodeled kitchen, vaulted ceilings throughout, open floor plan, and STUNNING ocean views! All windows have been replaced, along with all furniture in living room and both bedrooms! This accommodation is a premier unit at The ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Highly cleaned and sanitized for your vacation. Ask about our AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, traditional housekeeping service will be performed every 7th day. This includes refreshing...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea, Maui
Wailea Ekolu #501 is an ocean view 2 bedroom, 2 bath ground floor unit with air conditioning throughout, a fully equipped kitchen, washer and dryer, 3 flat screen TVs, wireless Internet, and telephone with free long distance calls to the US ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Fourth night free! Every fourth night free! Offer good on new reservations for dates between September 20 and November 30, 2024. Discount applied on final payment. Call or email WaileaRentals for details.
Fresh new upgrades - new ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Notes from the Owner: Come relax in the luxury and tropical splendor of Maui's premier resort, Wailea. Featuring miles of pristine beaches, magnificent sunsets and renowned cuisine, Wailea will surely be your ultimate vacation experience! The ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea, Maui
Enjoy spectacular panoramic ocean views from this beautiful condo in a truly private setting! This is one of the best located units in the complex providing unobstructed ocean views from the living area, dining area, kitchen, master bedroom and ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Wailea
Wailea Ekolu 1205 is a two-bedroom, two-bathroom ocean view vacation residence that comfortably accommodates four people. The sweeping ocean views beyond the Wailea Blue Golf Course and lush tropical landscaping make this private vacation home ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Stunningly updated, private condo near all that Wailea has to offer! Beaches, tennis, golf, shopping and dining all within a mile.
This tropical 2 Bedroom, 2 Bath condo offers a beautiful space to relax and enjoy your Maui vacation. The ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Enjoy the fully remodeled kitchen, vaulted ceilings throughout, open floor plan, and STUNNING ocean views! All windows have been replaced, along with all furniture in living room and both bedrooms! This accommodation is a premier unit at The ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Wailea Ekolu 1404 is a beautifully appointed one-bedroom, two-bathroom vacation rental that offers an idyllic escape in Maui's popular town of Wailea. This elevated condo on the second floor boasts stunning ocean views and a serene ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Welcome to our charming island get-a-way in Wailea, Maui nestled on the Wailea Blue Golf Course. This newly renovated & furnished condo has an open floor plan in the living and dining room with 2 ensuite king bedrooms outfitted each with smart ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Wailea Ekolu Village condo #1203 is an exquisite one-bedroom, two-bathroom ocean view retreat designed for discerning travelers seeking the best of Wailea. This sanctuary offers a seamless indoor-outdoor living experience, allowing guests to ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Wailea
Wailea Ekolu 104 is a stunning ocean view vacation rental that features two bedrooms and two bathrooms, accommodating up to four guests. Designed with an island-inspired aesthetic, this residence showcases a unique collection of artwork, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
