select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
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 the sought ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea
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
HI> Kihei
If you love sitting on a large, comfortable lanai and luxuriating in multi-million dollar views with the most amazing sunsets imaginable, there is no better place for you than Unit 406! This unit offers one of the best views in the entire ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea
We recently remodeled our condo with all new upgraded tumbled travertine-style flooring, new window and lanai shades, and new furniture. Why stay in a resort hotel like the Four Season or the Grand Wailea when you can save 2/3 of the cost and ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> 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
HI> Wailea
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 located on the ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> 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 of Molokini...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Wailea Ekolu #103 is a 2 bedroom, 2 bath unit on the ground floor with an ocean view. Split system zoned Mitsubishi A/C with separate compressors in the living room and both bedrooms keeps the condo nice and cool. It's got a fully-equipped ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea
Aloha! We invite you to come to Maui's southwest shores where Haleakala reaches for the sea. Experience spectacular ocean views from our remodeled condo at Wailea Ekolu Village. Enjoy the new gourmet kitchen with all new appliances. Our ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> 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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Kihei
Unit 1507 is completely and beautifully remodeled!! Check out all of the pictures! What you see is what you get!! This ground floor unit flows out to the 11th tee on the Wailea Blue Course. This unit is just steps away from the pool and just ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
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
HI> Wailea
This Wailea Ekolu retreat goes hand in hand with your Maui experience. It's here you will find a clean, open, beautiful condominium, with an amazing ocean view from the lanai. This is an ideal retreat, in a perfect setting that's a fabulous ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea-Makena
This spacious one bedroom, two bathroom is perfectly situated in the prestigious Wailea Ekolu surrounded by lush tropical foliage. The master bedroom features a King size bed, ensuite bathroom and ocean views. The main living area boasts high ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
ENJOY THE BEAUTIFUL MAUI SUNSET! Sharon's spacious, 1,300 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
HI> Wailea
