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
** HEAVY DISCOUNT for month of April and MAY 2024 while the roof is being replaced in adjacent building A, B, D building. ** By booking these months, you agree that there will be noise distraction and best to be out enjoying Maui during business...
- 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! We are grateful to have you here and helping our economy recover. You’ll love this spotless tropical Maui Eldorado condo in heart of the beautiful, world famous Kaanapali Beach. This updated unit has everything ...
- 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
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
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
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
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> Lahaina
This is a legally permitted vacation rental according to the County of Maui ordinances.
🌺 E Kō Mo Mai" (Welcome to our Home) at the Maui Eldorado. 🌴🌊🌅
Discover the hidden gem of Kaanapali Beach at the Maui Eldorado. Revel ...
- 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
Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2024 and receive a 4-door rental car from one of our major rental car agency partners. The Car is complimentary, you pay only ...
- 1 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
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
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
Large Living Area & Lanai With Easy Resort Access - Hosted by Maui Westside
● Spacious 2-bedroom, 2-bath corner unit with over 1,440 square feet of luxury
● Tastefully remodeled with granite counters, Kitchenaid appliances, bamboo ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaanapali
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
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
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> Lahaina
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
Spacious Living Area, Lanai and Easy Access to Resort ~ Hosted by Maui Westside
● Spacious 1,440 square feet corner unit with a peek-a-boo ocean view
● Oversized covered lanai with seating for eight and an electric BBQ
● Open ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaanapali
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
This is a legally permitted vacation rental and hotel zone according to the County of Maui ordinances.
E Ko Mo Mai (Welcome to our Home) at the Maui Eldorado.
The less-known gem of Kaanapali Beach. Enjoy the gorgeous ocean view and...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
UNIT J-213 -WELL LOCATED ONE BEDROOM UNIT IN THE HEART OF THE FABULOUS MAUI ELDORADO RESORT. THE ONLY PROPERTY IN KAANAPALI RESORT WITH THEIR OWN PRIVATE BEACH CABANA. LOCATED ALONG THE ROYAL KAANAPALI GOLF COURSE. A VERY SPECIAL PROPERTY CLOSE...
- 2 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Lahaina
This is a legally permitted vacation rental and hotel zone according to the County of Maui ordinances.
E Kō Mo Mai" (Welcome to our Home) at the Maui Eldorado.
Discover the hidden gem of Kaanapali Beach at the Maui Eldorado. Revel...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Garden View 1 Bedroom
- Kitchen includes fridge, stove/oven, microwave, dishwasher, cookware and tableware
- 1 king bed or 2 queen beds
- Queen sofa sleeper in living room
- 1200 sqft / 112 sqm
- Air conditioning
- Washer/dryer...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Garden View 2 Bedroom 2 Bath
- Full kitchen includes refrigerator, stove/oven, microwave, dishwasher, cookware, tableware
- Master bedroom with 1 king bed
- Guest bedroom with 2 double beds
- Sofa bed in living area
- 1700 square ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Partial Ocean View 1 Bedroom
- Full kitchen includes refridgerator, stove/oven, microwave, dishwasher, cookware, tableware
- 1 king bed or 2 queen beds
- Queen sofa sleeper in living room
- 1200 sqft / 111 sqm
- Bathroom with ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- 2nd floor condo with balcony
- Tile throughout unit
- Open kitchen layout with granite counters, stainless steel fridge, stove/oven, microwave, dishwasher, cookware and tableware
- 2 queen beds
- Queen sofa sleeper in living ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- 2nd floor condo with balcony
- Tile throughout unit
- Open kitchen layout with granite counters, stainless steel fridge, stove/oven, microwave, dishwasher, cookware and tableware
- 2 queen beds
- Queen sofa sleeper in living room ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- 2nd floor condo with balcony
- Open kitchen layout with granite counters, stainless steel fridge, stove/oven, microwave, dishwasher, cookware and tableware
- 2 queen beds
- 1200 square feet / 111 square meters
- Bathroom with ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- Full kitchen includes refrigerator, stove/oven, microwave, dishwasher, cookware, tableware
- 2 KING beds (NO SOFA SLEEPER)
- Bathroom with roll-in tile shower
- Corner 1st floor unit
- Partial ocean view
- Lanai dining
- ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- 1st floor condo with balcony
- Updated open kitchen layout with granite counters, white fridge, stove/oven, microwave, dishwasher, cookware and tableware
- Tile throughout unit
- 1 king bed
- Queen sofa sleeper
- 660-880 square ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
- Full kitchen includes refrigerator, stove/oven, microwave, dishwasher, cookware, tableware
- 2 KING beds
- Queen sofa sleeper in living room
- Partial ocean view
- Lanai dining
- Bathroom with walk-in tile shower
- 1200 sqft...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Partial Ocean View Studio
- Kitchen includes refrigerator, stove, oven, microwave, dishwasher, cookware and tableware
- 1 king bed or 1 queen bed
- Queen sofa sleeper
- 660-880 square feet / 61-82 square meters
- Bathroom with ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Partial Ocean View 2 Bedroom 2 Bath- Full kitchen includes refrigerator, stove/oven, microwave, dishwasher, cookware and tableware
- Bedding configuration varies and is based on availability; configuration 1 king/1 king, or 1 queen/2 queens, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Garden View Studio
- Kitchen includes refrigerator, stove, oven, microwave, dishwasher, cookware and tableware
- 1 king bed or 1 queen bed
- Queen sofa sleeper
- 660-880 square feet / 61-82 square meters
- Bathroom with shower or ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
