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! 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 ...
- 1 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 ...
- 1 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, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
G O L D R A T I N G: CoralTree Residence Collection Hawaii’s Gold category residences combine refined and stylish interiors with superior home conveniences. Each Gold residence maintains upgrades in interior design motifs and coordinated ...
- 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
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, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
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
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 ...
- 1 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
Unit 1507 is a ground floor unit that flows out to the 11th tee on the Wailea Blue Course. This unit is just steps away from the pool and just minutes to the Wailea Beaches, Shops at Wailea and luxury hotels! VERY private and peaceful and so ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
This spacious one bedroom, two bathroom is perfectly situated in the prestigious Wailea Ekolu surrounded by lush tropical foliage. The primary bedroom features a King size bed, ensuite bathroom and ocean views. The main living area boasts high ...
- 1 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kihei
