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 '%Maui Eldorado%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Amazing ocean view! Our beautifully remodeled studio suite is located right in the heart of Kaanapali and is center to an incredible ocean view surrounded by lush tropical grounds. Feel the Aloha of the island as you gaze at the ocean and ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
This resort is currently fully open, all amenity use is subject to Hawaii State Covid-19 rules and regulations and CDC recommendations concerning social distancing and cleaning procedures. These rules and recommendations regarding amenity usage ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kaanapali
Be one of the first to enjoy the place after a complete remodel. Photos taken January 2021
Maui Eldorado resort property on Kaanapali golf course. Beautiful paradise views from lanais & floor to ceiling glass windows.
A short walk (less than ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> Lahaina
Imagine yourself sitting on one of your two private lanai's while overlooking the 4th green of the Royal Golf Course at Kaanapali and experiencing views of the blue Pacific ocean, sunsets, winter whale watching and the island of Molokai. Our ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
J-220 is one of the best view, best located, largest studios at Maui Eldorado with 702 square feet. Guests have loved J-220 and returned many times.
One of the closest units to the ocean and beach. Second floor privacy, security, and view. ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Welcome to the spacious, designer remodeled condo on the top floor (2nd Floor).
Gorgeous ocean views from the living room, bedroom and the private lanai with lush gardens. Steps away from one of the 3 resort pools and a 7 minute walk to ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kaanapali
Why not hunker down and workcation in beautiful Maui? The Kaanapali Beach Resort area is a 1,500 acre luxury resort which includes two championship golf courses along one and one-half miles of the world famous Kaanapali beach. Three on-site ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Lahaina
This resort is currently fully open, all amenity use is subject to Hawaii State Covid-19 rules and regulations and CDC recommendations concerning social distancing and cleaning procedures. These rules and recommendations regarding amenity usage ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
This spacious one-bedroom maui eldorado resort condominium offers comfortable non-smoking accommodation for up to 6 guests. The air-conditioned, 2nd floor (top floor), condominium has ocean views from almost every location inside. It is ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
HI> Lahaina
Note: Maui Eldorado resort charges a one time $60 resort fee and $18 per day fee at check in.
Beautiful Kaanapali beach and Whalers Village is an easy walk from K110. Located on ground floor our Studio unit sleeps 3 comfortably. Gorgeous fully...
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Lahaina
Come enjoy your own piece of paradise at Maui Eldorado E104! This spacious, air-conditioned 1-bedroom, has two queen beds and a sofa sleeper, sleeping up to 6 people. Feel free to spend the day watching whales from the cabana or swimming with ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
HI> Lahaina
Condo 1 Bedroom + Convertible bed(s), 1 Bath (Sleeps 4-6)
The Maui Eldorado is in the beautiful resort community of Ka'anapali, with virtually everything you need at your doorstep,including Whalers Village for shops and restaurants, Black Rock ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
HI> Lahaina
This resort is currently fully open, all amenity use is subject to Hawaii State Covid-19 rules and regulations and CDC recommendations concerning social distancing and cleaning procedures. These rules and recommendations regarding amenity usage ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
* Enjoy your stay with enhanced cleaning and disinfecting protocols, before your check-in. Private entrance to your condo, along with OPEN AIR OUTDOOR WALKWAY *
Maui Eldorado Resort, private condo J120. Enjoy paradise in this modern private ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Kaanapali
Enjoy your own piece of paradise! Eldorado L102 is the perfect place to bring your family and explore all the wonder Maui has to offer. Come cook in this gorgeous new kitchen that has everything you need! Brand new appliances, a gorgeous ...
- 1 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
