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, 20
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
