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, 50
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
Elua Village 2105- Owner Managed = 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 ...
- 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
FREE Rental Car! Beautiful 2 Bedroom Wailea home, large balcony, a/c, easy local access!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2025 and receive a ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
New, New, New! New paint, carpet, appliances, furniture, TV's, linens, and more to come in 2024 and 2025! Top Floor Elua Village vacation home with big ocean views from the lanai, living room, and bedrooms, custom artwork is on display ...
- 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
Wailea Elua Village 2005 is a stunning two-bedroom, two-bathroom vacation rental located in the desirable Wailea region of Maui. This beautifully appointed condo offers a perfect blend of luxury and comfort.
The spacious interior features an ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Situated near the center of the resort, Wailea Elua 1502 is siutated near the putting green and central swimming pool. Just a short walk away is the oceanside Wailea Beach Walk where you can stroll along the shore for a few miles on a paved path...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea-Makena
Ideally situated in a quiet corner along the northern edge of the resort, Wailea Elua Village 707 is just a short stroll to the beachfront pavilion with swimming pool. This vacation rental in the heart of Wailea offers guests a comfortable and ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Wailea Elua Village 104 is a stunning Wailea condominium rental that offers a truly unparalleled Hawaii vacation experience. Situated along the pristine golden sands of Ulua Beach on Maui's southern shore, this luxurious one-bedroom, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Elua 705 is an exquisite vacation rental located on the stunning shores of Maui. This two-bedroom, two-bathroom condominium offers a spacious layout ideal for families or groups of friends seeking a relaxing getaway. With approximately ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Welcome to your dream vacation retreat in Wailea! As you step inside Wailea Elua 706, you'll immediately be captivated by the spacious and thoughtfully designed interior. The open concept living area is flooded with natural light, creating a ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
The Wailea Elua 804 vacation rental is a true gem nestled within the picturesque Wailea resort community on the island of Maui. From the moment you step inside this stunning, 1,700-square-foot condo, you're enveloped in a sense of luxury and ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Wailea
Wailea Elua Village 910 is a stunning one-bedroom, one-bathroom vacation rental located in the exclusive Wailea community on Maui. This beautifully remodeled condo offers a luxurious retreat a short stroll to one of the best snorkeling beaches ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Elua 1202 is a stunning vacation rental property that offers visitors a truly luxurious and unforgettable experience in the heart of Maui's renowned Wailea resort area. Situated just steps away from the pristine white sands and ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Elua 1510 is a charming two-bedroom, two-bathroom vacation rental located in the premier Maui vacation destination of Wailea. This upstairs condo offers stunning ocean views and is just a short stroll away from the pristine Ulua Beach, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Elua Village 1511 is a premier vacation rental nestled in the heart of Wailea, offering a perfect blend of luxury, comfort, and stunning natural beauty. This exquisite one-bedroom, two-bathroom villa provides close to 1,000 square feet of...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Elua Village 2008 is a luxurious vacation rental situated along the southern coastline of Maui in the desirable Wailea region. This elegant condo offers a serene retreat for travelers seeking a blend of comfort and natural beauty.
The...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Wailea Elua Village 2402 is an exquisite ocean-view second-floor condo located in the prestigious Wailea area of Maui. This elevated condo with vaulted ceilings enjoys great views out over the South Maui coastline, especially remarkable during ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
Welcome to Wailea Elua Village #2108. This two-bedroom, two-bath residence is fully remodeled and redecorated, features an extra-large floor plan of more than 1,500 square feet, and boasts gorgeous, elevated views of the ocean, off-shore islets,...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Wailea Elua Village offers tropical vacation condos set amid Wailea’s resort hotels, making it a perfect luxury destination. Enjoy easy access from this vacation condo at Wailea Elua Village to the restaurants and spas of the Wailea ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
