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
This luxurious 3bedroom/3bath residence is conveniently set within Enclave One of the Luana Garden Villas. Villa 2A's north facing orientation offers a Shady respite from West Maui's legendary endless sun and its designation within "Grounded" ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
This luxurious 3Bedroom/3Bath residence is conveniently set within Enclave One of the Luana Garden Villas. This premiere grounded offering's southern orientation offers a bright inviting setting for you and your ohana (family) and its ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
This luxurious brand-new 3Bedroom/3Bath residence is conveniently set within Enclave One of the Luana Garden Villas. Villa 2D's north-facing orientation offers a Shady respite from West Maui's legendary endless sun and its designation withing ...
- 4 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
This luxurious brand-new 3Bedroom/3Bath residence is conveniently set within Enclave Two of the Luana Garden Villas. Its southern orientation offers a bright inviting setting for you and your ohana (family) and its designation within our ...
- 4 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 “four” separate neighboring villas in one building, which is perfect for a multi-family vacation. Luana ...
- 16 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...
- 12 bedroom
- 9 bathroom
- Sleeps 24
Hawaii> Lahaina
This luxurious brand-new 3Bedroom/3Bath residence is conveniently set within Enclave Two of the Luana Garden Villas. Villa 9C's north-facing orientation offers a Shady respite from West Maui's legendary endless sun and its designation within our...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Please note that this unit’s central air conditioning is currently under repair. To ensure your comfort, we’ve provided high-quality portable air conditioning units throughout the space. Rates have been significantly discounted to reflect ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Welcome to Luana Garden Villa, where paradise awaits you at Honua Kai Resort & Spa in Kaanapali, Maui. Our luxurious and spacious condos, Luana 14D, Luana 15D and Luana 18C, offer high-end amenities and stylish decor, ensuring comfort and luxury...
- 12 bedroom
- 9 bathroom
- Sleeps 24
Hawaii> Kaanapali
This luxurious brand-new 3Bedroom/3Bath residence is conveniently set within Enclave Two of the Luana Garden Villas. This premiere offering is defined by its west-facing orientation and open view plane between the Hokulani and Konea Towers. Its ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
This luxurious brand-new 3 Bedroom/3 Bath residence is conveniently set within Enclave Three of the Luana Garden Villas. Villa 14C's north-facing orientation offers a Shady respite from West Maui's legendary endless sun and its designation ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
This luxurious brand-new 3Bedroom/3Bath residence is conveniently set within Enclave Two of the Luana Garden Villas. Villa 10A's west-facing orientation offers an open view plane between the Hokulani and Konea Towers and its designation within ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Please note that this unit’s central air conditioning is currently under repair. To ensure your comfort, we’ve provided high-quality portable air conditioning units throughout the space. Rates have been significantly discounted to reflect ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
This luxurious 3Bedroom/3Bath residence is conveniently set within Enclave Two of the Luana Garden Villas. Villa 9A's north-facing orientation offers a Shady respite from West Maui's legendary endless sun and its designation within "Grounded" ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
This luxurious brand-new 3Bedroom/3Bath residence is conveniently set within Enclave Three of the Luana Garden Villas. As a premier elevated offering, Villa 15C is defined by its west-facing orientation. Its designation within our "Elevated" ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
This luxurious brand-new 3Bedroom/3Bath residence is conveniently set within Enclave Three of the Luana Garden Villas. This premiere grounded offering is defined by its southwest-facing orientation and gorgeous views of the West Maui Mountains. ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
This luxurious 3Bedroom/3Bath residence is conveniently set within Enclave One of the Luana Garden Villas. Villa 2B's north facing orientation offers a Shady respite from West Maui's legendary endless sun and its designation within our ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Please note that this unit’s central air conditioning is currently under repair. To ensure your comfort, we’ve provided high-quality portable air conditioning units throughout the space. Rates have been significantly discounted to reflect ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina