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 Kai%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Luana Kai D203 by KNOWLES MAUI
Luana Kai D203 is a sophisticated 2 bedroom, 2 bath resort condo that sleeps up to four guests in a prime oceanfront location. Enjoy 1,150 square feet of luxury living space. Take in the spectacular panoramic ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Over our 3.5 years on VRBO, our condo has welcomed many extremely happy guests. We promise to provide the best service to our guests as this is our vacation home too! (and our only rental property). Our guests’ comfort, safety and enjoyment ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Unit A203 is a, gloriously spacious, pleasantly appointed, deluxe condo with a full ocean view over the outer lawn and ocean. This unit is well lit and wide open. A203 is the only condo that has it's own Master Bar. Condo A203 is decorated with ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
*AC is an option, You must check the AC box during checkout or pay at the front desk. $25/night.
Unit B207 is a deluxe, air conditioned* two bedroom two bathroom condo on the North West side of the property. It has a partial ocean view as...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
*AC is an option, You must check the AC box during checkout or pay at the front desk. $25/night.
Maui Condo Unit C105 is a Deluxe 2 bedroom, 2 bathroom rental with a king size bed and two twin beds. C105 has a garden view and faces the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
* (A/C is an additional $25 per day plus tax).
Unit C201 is an air conditioned*, standard, 2 bedroom, 2 bath lodging with a partial ocean view. C201 has a double lanai with great view of the pool, ocean, and West Maui mountains, “The ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
*AC is an option. You must check the AC box during checkout or pay at the front desk. $25/night.
D103 is an air conditioned*, deluxe, 2 bedroom, 2 bathroom ocean view condo with a king size bed and two twin beds. It has a view of the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Panoramic Ocean Views with AC* at Luana Kai Resort A202
* Placed all brand-new furnishings in the entire condo, April 2022
* Total bathroom renovation and entire unit painting to be completed end of June 2022
**Air conditioning is ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
D105 with the the a/c option
(**Air conditioning is included in the rate during the low season dates of: May 1st - October 31st.
*During high season: November 1st - April 30th Air conditioning is an option for an additional cost of ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
B102 is a fully furnished, two bedroom, two bath, ground floor unit..
**AC is an option. You must check the AC box during checkout or pay at the front desk. $25/night.
B102 has wood flooring in the Bedrooms with a King bed in the Master ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Luana Kai #C-203 has just completed a full renovation as of October 2022 . This 1 bedroom, 1 bath ocean view unit on the 2nd floor is located in one of the most desirable locations in the complex. The unit is situated in a quiet location away ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
*AC is an option, You must check the AC box during checkout or pay at the front desk. $25/night.
Unit B307 is an air conditioned*, deluxe, two bedroom two bathroom accommodation on the North West side of the resort. It has a partial ocean...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
D102 with the a/c option**Air conditioning is included in the rate during the low season dates of: May 1st - Dec 1st.
* Dec 2nd - April 30th Air conditioning is an option for an additional cost of $25/night +tax, to be paid at the front ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
*AC is an option, You must check the AC box during checkout or pay at the front desk. $25/night
Vacation rental D303 is a deluxe, 2 bedroom, 2 bathroom, ocean view condo with a king size bed and two twin beds. It directly overlooks the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Luana Kai B314 by KNOWLES MAUI
The Space
Luana Kai B314 is a extra-large modern 3-bedroom, 3-bath condo that sleeps up to eight guests in a prime top-floor oceanfront location. Enjoy 1,470 square feet of luxury living space with huge ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kihei
*AC is an option. You must check the AC box during checkout or pay at the front desk. $25/night
Unit A303 is a deluxe air conditioned* condo at the ocean side corner of the property overlooking the park. It has a full view of the sea and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
B112 is a standard, 2 bedroom, 2 bathroom, garden view unit with king size and queen size beds. The kitchen has been redone with recessed can lighting, granite counter tops, a modern tile, full cover backsplash. The bar is free standing. B112 is...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Apartment B206 is a nice one bedroom one bathroom partial ocean view condo with filtered views of the Ocean. B206 has a modern tile backsplash in the kitchen and has a large glass table setting where the bar has been completely removed. The ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
*AC is an option, You must check the AC box during checkout or pay at the front desk. $25/night.
B304 is a Deluxe, air conditioned*, 2-bedroom, 2 bath, partial ocean view rental. The condo interior was repainted in 2018 and new carpeting ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Condo B210
is a Deluxe, 1 bedroom, 1 bathroom, partial ocean view lodging with a queen sized bed. It has cool stone tile floors in a variety of light earth colors. It has a modern kitchen, with canned lighting, and a large curved bar with ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
