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 '%Elua Village%') AND sleeps>=1 order by rating desc LIMIT 0, 20
This ocean view one-bedroom Wailea Elua Village condo is a great home base for experiencing the joys and beauty of south Maui. Easily walk down to the white-sand Ulua Beach that fronts this property. Be one of the first in the ocean in the ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Elua 1703 is a distinctive oceanfront vacation rental, perfectly situated directly in front of the renowned Ulua Beach and the Wailea Beachfront Walking Path. What sets it apart is its unique privacy, surrounded on three sides by lush, ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Wailea Elua 1704 is a stunning oceanfront vacation rental located a short stroll from one of the top snorkeling beaches on Maui. This spacious two-bedroom, two-bathroom corner unit spans approximately 1,600 square feet and comfortably ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Aloha! We are Julie and Randy and welcome to our home! We want you to enjoy the fantastic ocean views and luxury of our 2-bedroom, 2-bathroom condo in Wailea Elua Village - a gated, 24-acre, oceanfront community on beautiful Ulua Beach in ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
New, New, New! New furniture, new electronics, new beds, mattresses and linens, paint and artwork. Sooooo close to the beach! Treat yourself to the best that Elua Village has to offer. You and your guests will enjoy the short walk to the beach...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Located within short walking distance to the beach and close to the on-property pickleball court and swimming pool, Wailea Elua 1103 enjoys the ideal spot for a Maui vacation.
Upon entering, be struck by the large floor highlighted by a ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea-Makena
Welcome to Wailea Elua 208, where paradise meets luxury! This stunning one-bedroom ocean view vacation rental is the perfect getaway for those seeking both tranquility and adventure. Located in the heart of Wailea, this coastal retreat offers ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Elua Village #1001 is a stunning oceanfront sanctuary that has recently undergone a complete transformation.
For discerning travelers who enjoy the best of Wailea, the extended outdoor living space allows you to enjoy panoramic ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Elua 1203 is a stunning one-bedroom, one-bathroom oceanfront vacation rental located on the ground floor of the prestigious Wailea Elua Village community. This condo offers direct access to Ulua Beach, where guests can enjoy swimming and ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Wailea
Wailea Elua Village 1802 is situated along the southern-most border of the resort, offering more privacy, as well as uninterrupted ocean views across the lawn to Ulua Beach. Convenient parking is located right outside the front door, with a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Elua 1201 is perfectly positioned in the coveted interior courtyard, 39 steps to famous Ulua Beach, perennially named as one of the world's top 10 beaches and one of the best snorkeling reefs on Maui. This ground floor condo features an ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Wailea Elua 905 is a vacation rental situated in the picturesque beach locale of Maui. This spacious three-bedroom, two-bathroom condo offers a perfect blend of comfort and luxury, making it an ideal retreat for families or friends traveling ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Owner direct pricing = better value and better service.
Please see the video (https://youtube.com/watch?v=_mjte4in4k8) and read a few of our many guest reviews to get a feel of this very special owner-managed property.
2 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Wailea Elua 805 is a spacious and family-friendly vacation rental located along the world-famous southern coastline of Maui in the town of Wailea. This beautifully appointed three-bedroom, two-bathroom condo is just a short two-minute walk from ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Wailea
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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
New, New, New! New paint, carpet, appliances, furniture, TV's, linens, and more to come! New photos posted by July! Top Floor Elua Village vacation home with big ocean views from the lanai, living room, and bedrooms, custom artwork is on ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Completely renovated in 2019, Wailea Elua 2401 is a stunning vacation condo that features a large private wrap-around lanai with breathtaking ocean views. This beautifully designed rental offers a serene indoor/outdoor living space, perfect for ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Wailea Elua 1607 is a luxurious ground floor oceanfront vacation rental located in the exclusive Wailea Elua Village. This spacious 1,701 square foot condominium features three bedrooms and two bathrooms, making it an ideal retreat for families ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Wailea Elua Village 1501 is the perfect home base for exploring the sights, sounds, and tastes of Maui. This two-bedroom garden view vacation rental is a short drive to the top Wailea and Kihei beaches for snorkeling, favorite restaurants on the...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Wailea Elua Village 401 is a stunning vacation rental situated in the luxurious Wailea area of Maui. This ground floor two-bedroom, two-bathroom condo is surrounded by tropical views of beautifully mainucred grounds and the South Maui ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
