select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, we will be exchanging bath towels and amenities every three days and performing a traditional ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailea, Maui
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, we will be exchanging bath towels and amenities every three days and performing a traditional ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea-Makena
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 Maui....
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Note - individual lanai BBQs are not allowed at this property starting today 2/18/22. Wailea Elua Village is the premier resort community located directly on Ulua beach in Wailea featuring 24 acres of lush tropical landscapes, luxury ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailea
Note - individual lanai BBQs are not allowed at this property starting today 2/18/22. You will have a short walk to the beach from this wonderful property and can easily store surf boards, paddle boards, or kayaks on the outside lanai while you...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
See the video and guest comments!
Fully renovated luxury condo in Elua Village, Wailea's premier beachfront destination. Nice ocean views from the lanai, living room, kitchen and master bedroom. True beach front complex; just a 4 minute walk ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, we will be exchanging bath towels and amenities every three days and performing a traditional ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea
Note - individual lanai BBQs are not allowed at this property starting today 2/18/22. Top Floor condominium with big ocean views from the lanai, living room, and bedrooms. Brand new central A/C system. Wailea Elua Village is a premier ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Note - individual lanai BBQs are not allowed at this property starting today 2/18/22 Wailea Elua Village is a premier vacation property located directly on Ulua beach in Wailea and features 152 condos on 24 acres of lush tropical landscapes, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, we will be exchanging bath towels and amenities every three days and performing a traditional ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailea, Maui
If you are looking for an awesome oceanfront condo on Maui with spectacular views, then this is the condo for you. Located on Maui - voted the World’s Best Vacation Destination by Conde Nast - this condo is in the best condo village in Wailea,...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Wailea, Maui
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, we will be exchanging bath towels and amenities every three days and performing a traditional ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea-Makena