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 '%Luana Garden Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Crafted for multi-family vacations or larger gatherings, this listing offers two distinct Villas at the illustrious Luana Garden Villas — nestled on the captivating Kaanapali Beach on Maui’s western coast. Together, the upper and garden ...
- 6 bedroom
- 6 bathroom
- Sleeps 16
Hawaii> Lahaina
Maui Resort Rentals Presents the Premier Luana Garden Villas Experience...
• Free Maui Resort Rentals courtesy shuttle offering service between Luana and a number of West Maui locations.
• 24/7 local guest service from ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Resort Rentals Presents the Premier Luana Garden Villas Experience...
• Free Maui Resort Rentals courtesy shuttle offering service between Luana and a number of West Maui locations.
• 24/7 local guest service from ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Resort Rentals Presents the Premier Luana Garden Villas Experience...
• Free Maui Resort Rentals courtesy shuttle offering service between Luana and a number of West Maui locations.
• 24/7 local guest service from ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Resort Rentals Presents the Premier Luana Garden Villas Experience...
• Free Maui Resort Rentals courtesy shuttle offering service between Luana and a number of West Maui locations.
• 24/7 local guest service from ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Resort Rentals Presents the Premier Luana Garden Villas Experience...
• Free Maui Resort Rentals courtesy shuttle offering service between Luana and a number of West Maui locations.
• 24/7 local guest service from ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Resort Rentals Presents the Premier Luana Garden Villas Experience...
• Free Maui Resort Rentals courtesy shuttle offering service between Luana and a number of West Maui locations.
• 24/7 local guest service from ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
***Aloha and Welcome to Maui and Luana at Honua Kai Resort***
Luana 10B is a ground level beautifully designed and fully furnished villa in the new Luana subdivision of the Honua Kai Resort with 2047 sf of indoor living space. The large lanai...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Resort Rentals Presents the Premier Luana Garden Villas Experience...
• Free Maui Resort Rentals courtesy shuttle offering service between Luana and a number of West Maui locations.
• 24/7 local guest service from ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy the ease and convenience of parking right at your private villa entrance with one garage parking space, plus one additional parking space in the driveway, included in your rental.
Maui Resort Rentals Presents the Premier Luana ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Kaanapali Luxury Vacation Rentals welcomes you to our beautiful Luana Garden Villas at the Honua Kai Resort.
This listing is for “two” separate neighboring villas, which is perfect for a multi-family vacation. Luana Garden Villas is ...
- 6 bedroom
- 6 bathroom
- Sleeps 16
Hawaii> Lahaina
Kaanapali Luxury Vacation Rentals welcomes you to our beautiful Luana Garden Villas at the Honua Kai Resort.
This listing is for “four” separate neighboring villas in one building, which is perfect for a multi-family vacation. Luana ...
- 12 bedroom
- 12 bathroom
- Sleeps 32
Hawaii> Lahaina
Kaanapali Luxury Vacation Rentals welcomes you to our beautiful Luana Garden Villas at the Honua Kai Resort.
This listing is for “three” separate neighboring villas, which is perfect for a multi-family vacation. Luana Garden Villas is...
- 9 bedroom
- 9 bathroom
- Sleeps 24
Hawaii> Lahaina
Maui Resort Rentals Presents the Premier Luana Garden Villas Experience...
• Free Maui Resort Rentals courtesy shuttle offering service between Luana and a number of West Maui locations.
• 24/7 local guest service from ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Resort Rentals Presents the Premier Luana Garden Villas Experience...
• Free Maui Resort Rentals courtesy shuttle offering service between Luana and a number of West Maui locations.
• 24/7 local guest service from ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
between Luana and a number of West Maui locations.
• 24/7 local guest service from professionals trained by leading brands such as Marriott, Montage, and Ritz-Carlton.
• Only manager with 8000+ sq. ft. of office and warehouse space ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Resort Rentals Presents the Premier Luana Garden Villas Experience...
• Free Maui Resort Rentals courtesy shuttle offering service between Luana and a number of West Maui locations.
• 24/7 local guest service from ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Resort Rentals Presents the Premier Luana Garden Villas Experience...
• Free Maui Resort Rentals courtesy shuttle offering service between Luana and a number of West Maui locations.
• 24/7 local guest service...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Resort Rentals Presents the Premier Luana Garden Villas Experience...
• Free Maui Resort Rentals courtesy shuttle offering service between Luana and a number of West Maui locations.
• 24/7 local guest service from ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Resort Rentals Presents the Premier Luana Garden Villas Experience...
• Free Maui Resort Rentals courtesy shuttle offering service between Luana and a number of West Maui locations.
• 24/7 local guest service from ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina