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, 30
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...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
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...
- 2 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 2
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> Lahaina
"The area of this condo was unaffected by the recent Lahaina Fires. Your visit will help Maui heal and rebuild after the fires. West Maui, has come back to life. Restaurants and shops are opening. Our Beaches, waterfalls and hikes are ...
- 1 bedroom
- 2 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...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
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
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
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/balcony with lush gardens. Steps away from one of the 3 resort pools and a 7 minute walk...
- 1 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
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 ...
- 2 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: ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
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
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
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 plus lanai one-bedroom (2 queens in this ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Lahaina
TThis 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, ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
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 ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaanapali
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaanapali
"The area of this condo was unaffected by the recent Lahaina Fires. Your visit will help Maui heal and rebuild after the fires. West Maui, has come back to life. Restaurants and shops are opening. Our Beaches, waterfalls and hikes are ...
- 2 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...
- 1 bedroom
- 1 bathroom
- Sleeps 6
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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
"The area of this condo was unaffected by the recent Lahaina Fires. Your visit will help Maui heal and rebuild after the fires. West Maui, has come back to life. Restaurants and shops are opening. Our Beaches, waterfalls and hikes are ...
- 1 bedroom
- 1 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, ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
This charming 1st floor studio at the Maui Eldorado resort offers a comfortable air-conditioned accommodation for up to 4 guests. With golf course views and a beautiful ocean view from the private lanai whether you're sipping your morning coffee...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina