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 '%Maui Eldorado%') AND sleeps>=1 order by rating desc LIMIT 0, 50
E Komo Mai “welcome” to Maui Eldorado A210, with ocean and Kaanapali golf course views at unit A210!!
Enjoy a fresh and modern stay with a newly remodeled kitchen, bathroom, flooring and furniture. Located in the heart of Kaanapali....
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaanapali
Situated in the Kaanapali Beach Resort area, enjoy this spacious ground floor studio at #1 Kaanapali Beach, Maui Eldorado Resort C101, located in the heart of Kaanapali. Relax in this spacious and tropical suite condo, fully furnished with a ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaanapali
One of the best ocean view, nearest the beach, largest studios at Maui Eldorado; 702 square feet. Second floor privacy, security, and view. Completely upgraded in 2018. Cal king bed. Complete kitchen & every convenience. 42' TV, Blue-Ray...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Welcome to West Maui! You’ll love this spotless tropical Maui Eldorado studio condo in heart of the beautiful, world famous Kaanapali Beach. This updated unit has everything you’ll need for a wonderful vacation on Maui! Maui Eldorado is ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaanapali
Note: Maui Eldorado resort charges a one time $60 resort fee and $20 per day fee at check in.
Beautiful Ka'anapali beach resort and Whalers Village is an easy walk from # K110. Located on ground floor our Studio unit sleeps 3 ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
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
Hawaii> Lahaina
This is a legally permitted vacation rental according to the County of Maui ordinances.
Oceanfront Bliss with Spacious Living, Private Lanai, and Unforgettable Sunsets
E Kō Mo Mai! (Welcome!) Embrace the spirit of aloha as you ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Scenic golf course and ocean views from our spacious ground floor studio which sleeps 4 comfortably.
Walking distance to stunning Ka'anapali beach and Whaler's Village.
Take a short walk on the beach to great restaurants, hotels and ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Enjoy your next family getaway in centrally located Kaanapali beach resort area with spacious 1440 square feet plus double length lanais. Ideal for a family up to 6 person, this accommodation offers premium ocean and golf course views and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaanapali
Centrally located in the heart of Ka'anapali, Maui Eldorado Kaanapali is the perfect place to enjoy your Maui Vacation.
This ground-floor end unit with an elevated garden view is very close to the front desk and outdoor parking - handy ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
This is a legally permitted vacation rental and hotel zone according to the County of Maui ordinances.
Breathtaking Ocean Views, Spacious Lanai, and Exclusive Beach Cabana at Maui Eldorado
E Kō Mo Mai (Welcome) to your perfect ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
E Komo Mai “welcome” to Maui Eldorado A206! This modern condo is located in the heart of Kaanapali, one of the world's most well-known destination resorts with spectacular ocean, Molokai and western exposure towards the island of Lanai. ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaanapali
Remodeled Kitchen & Bathrooms, Dual-Zone AC & More ~ Hosted by Maui Westside
● Spacious and renovated one-bedroom, two-bathroom condo with ocean views
● Newly renovated kitchen with stainless steel appliances, beautiful cabinetry, and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kaanapali
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
Hawaii> Lahaina
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
Hawaii> Lahaina
Aloha! We welcome you to enjoy your next vacation at the Maui Eldorado Kaanapali C102 in this designer decorated 1 bedroom vacation condo - perfect for a couple, or a family up to four!
This newly remodeled condo was just completed in ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
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...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Stylish 2-Bedroom With Upgraded Finishes & Furniture ~Hosted By Maui Westside
● Frontline location with breathtaking ocean and golf course views
● Spacious and luxuriously remodeled 2-bedroom, 2-bathroom condo
● Comfortably sleeps...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaanapali
Maui Eldorado Resort E106
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Get a true taste of tropical island living with this spacious, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Aloha!! Welcome to your next beach vacation at this tropical 1 bedroom 2 bathroom vacation rental at Maui Eldorado F201 -- located in the Kaanapali Beach Resort, perfect for friends, family or couple getaway! Bonus: New flooring just completed ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kaanapali
Graciously oversized A104 one bedroom, two queen beds with 1000 square feet plus 200 sq ft lanai space, located next to one of the three swimming pools. Centrally located in the heart of Kaanapali - Maui Eldorado Resort. Enjoy this spacious ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Aloha! We welcome you to enjoy your next Maui vacation at the Maui Eldorado D108, perfect for friends and family getaway!
Located in the heart of Kaanapali in the Kaanapali beach resort area, framed by Kaanapali Golf Course & fragrant ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Eldorado Resort, private condo J120. Enjoy paradise in this modern private condo at Maui Eldorado located in the J block. This spacious condo rental offers frontage views of Kaanapali Golf Course. Fully-furnished for 2 adults. Bonus: ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaanapali
ALOHA!! Welcome to this beautifully remodeled spacious modern 1 bedroom condo 2 full bathrooms at the Maui Eldorado Kaanapali F101!! Perfect for a couple or family get away with all the comforts of home.
Enjoy a leisure stroll or a ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kaanapali
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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Lahaina
Enjoy your next vacation at the Maui Eldorado in this newly designer-decorated modern ocean view 1 bedroom, 2 bath condo. Very private, this top floor unit with over 1000 sq. ft of living space, is just a few convenient steps to parking at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Bright corner unit condo with tile flooring at G201 Maui Eldorado, Kaanapali Resort near the main pool with a peekaboo of the ocean. Perfect for a relaxing getaway in paradise! Granite in kitchen and bathroom. 2 person max.
New: Work ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaanapali
K207 a luxurious bright modern Hawaiian style décor condo, second floor at the Maui Eldorado Resort, 10 minute walk to Whaler's Village shops, and restaurants. Enjoy premium luxuries such as wood floor, granite kitchen and bathroom with a ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaanapali
Aloha -- Welcome to our condo apartment.
It is a 1200 sq ft ground floor corner unit located in the Maui Eldorado Beach Resort, beside the 4th fairway of the Royal Kaanapali Golf Course. The condo has two queen size beds - each in a separate ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
There will be a $65 check-in fee and a $20 per day resort fee payable to the front desk on arrival.
Located in the center of popular Kaanapali Beach, this well-appointed 960 square foot garden view suite can comfortably accommodate...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Lahaina
This beautifully remodeled, spacious two-bedroom, and two-bathroom unit with a peekaboo ocean view condo on the lanai. Maui Eldorado F104 is located in the heart of Kaanapali. Just a short walk to Whalers Village to enjoy some shopping, ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy this spacious 1 bedroom with 2 queen beds, sip your drinks on the expansive patio while enjoying views of the ocean, main pool and nightly sunsets!
Located in the heart of Kaanapali - great for shopping, dining, and fun ocean ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaanapali
This is a legally permitted vacation rental and hotel zone according to the County of Maui ordinances.
Oceanfront Retreat – Private Beach Cabana, Golf Course Views, and Spacious Lanai
E komo mai (welcome) to your island ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Your dream vacation on the world famous North Kaanapali Beach Resort with easy access to shopping, dining, and all beach activities. Take a stroll on the oceanfront boardwalk to resorts, spas, shopping, a multitude of restaurants, and world ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Maui Eldorado Resort is located in the heart of Ka'anapali on the golf course. Easy walk or free shuttle to private beach cabana for Eldorado guests only. Whalers Village is also within walking distance with world class shopping and restaurants....
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
