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 '%Luana Garden Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 15
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 0 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 6 bedroom
- 6 bathroom
- Sleeps 16
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 6 bedroom
- 6 bathroom
- Sleeps 16
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 9 bedroom
- 9 bathroom
- Sleeps 24
HI> Lahaina
COVID-19 CANCELLATION POLICY: Full refund will be issued for any booking made after November 26, 2020 if:
Mandatory 14 day quarantine, without pre-testing option, is extended to the guest’s reservation dates.
ENHANCED CLEANING AND SAFETY ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
