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, 20
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
