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
**Air conditioning is included in the rate during the low season dates of: May 1st - December 1st.
*During high season: December 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.
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
**Air conditioning is included in the rate during the low season dates of: May 1st - December 1st.
*During high season: December 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 4
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
**Air conditioning is included in the rate during the low season dates of: May 1st - December 1st.
*During high season: December 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 4
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 - December 1st.
*During high season: December 2nd - 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
**Air conditioning is included in the rate during the low season dates of: May 1st to December 1st.
*During high season: December 20th – April 15th Air conditioning is an option for an additional cost of $25/night +tax, to be paid at 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.
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
**Air conditioning is included in the rate during the low season dates of: May 1st - December 1st.
*During high season: December 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 4
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