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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
ELUA 1703
PLATINUM OCEAN FRONT CONDO WITH FULL PANORAMIC OCEAN VIEWS
This ground level condo sleeps 6 with 2 bedrooms, 2 full baths, and a sleeper/sofa.
Elua 1703 is a unique ocean front property. It is positioned directly in front ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
You'll stroll along the tropical walkway toward the ocean to reach this prime oceanfront suite with postcard views of the sparkling Pacific. The convenient location just off the Wailea Beach Walk lets you enjoy easy access to Maui’s ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
G O L D R A T I N GCoralTree Residence Collection Hawaii’s Gold category residences combine refined and stylish interiors with superior home conveniences. Each Gold residence maintains upgrades in interior design motifs and coordinated ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
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
P L A T I N U M R A T I N G
CoralTree Residence Collection Hawaii’s signature Platinum category rating is reserved for those residences that exemplify outstanding interior quality, comfort and design. Superior furnishings and unique ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kihei
P L A T I N U M R A T I N GCoralTree Residence Collection Hawaii’s signature Platinum category rating is reserved for those residences that exemplify outstanding interior quality, comfort and design. Superior furnishings and unique fixtures ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
G O L D R A T I N GCoralTree Residence Collection Hawaii’s Gold category residences combine refined and stylish interiors with superior home conveniences. Each Gold residence maintains upgrades in interior design motifs and coordinated ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
P L A T I N U M R A T I N G
CoralTree Residence Collection Hawaii’s signature Platinum category rating is reserved for those residences that exemplify outstanding interior quality, comfort and design. Platinum residences reflect ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
G O L D R A T I N GCoralTree Residence Collection Hawaii’s Gold category residences combine refined and stylish interiors with superior home conveniences. Each Gold residence maintains upgrades in interior design motifs and coordinated ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea-Makena
Located within short walking distance to the ocean and close to the pickleball court and swimming pool, this suite features a sunken living area that is separated from the bedrooms by the foyer - making it perfect for families and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea-Makena
P L A T I N U M R A T I N GCoralTree Residence Collection Hawaii’s signature Platinum category rating is reserved for those residences that exemplify outstanding interior quality, comfort and design. Platinum residences reflect luxurious, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
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
This 3-bedroom, 2-bath vacation condo is family friendly, a short 2-minute walk from Ulua Beach, and within easy walking distance of the paddle tennis court, beachfront pool / pavilion and center swimming pool.Outfitted with a fully equipped ...
- 3 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
NOTE*** 5th NIGHT FREE. Each 5th NIGHT FREE. Stay 10 nights and get 2 nights FREE. Special valid for reservation dates through the end of September 2024 on all new reservations. Call or email for details. Credit applied to your final ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
P L A T I N U M R A T I N GCompletely renovated in 2019, this condo features a large private, wrap-around lanai with ocean views. Wailea Elua 2401 offers guests a quiet indoor/outdoor living area to enjoy Maui’s year-round ideal tropical ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
P L A T I N U M R A T I N G
CoralTree Residence Collection Hawaii’s signature Platinum category rating is reserved for those residences that exemplify outstanding interior quality, comfort and design. Superior furnishings and unique ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea-Makena
