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, rewritten_description,
(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, 50
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
Beautiful single level condo in South Maui!
Our unit is located on the second floor with an ocean view, recent updates, close to shopping, beaches and activities. The view can be enjoyed on our expansive double sized lanai for casual
- 2 bedroom
- 2 bathroom
- Sleeps 5
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
- 3 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
This two bedroom, two-bathroom, top floor condo at Luana Kai sleeps 6 with a sofa bed in the living room. The kitchen has been beautifully remodeled with top of the line appliances and features stunning hand-crafted wood details like a split
- 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
- 4 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.
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
*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
- 3 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
- 3 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
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
This updated ocean front condo is located on the ground floor (no stairs/steps) - Great for people with mobility issues or young/old families. The beach is only steps from your personal patio.
Open concept, spacious floor plan, upgraded
- 2 bedroom
- 2 bathroom
- Sleeps 7
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
- 3 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
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to Luana Kai D305! This uniquely located, oceanfront condominium is only steps across a lush green lawn to a beautiful sandy beach. It is ideal for watching surfers, windsurfers, and kite boarders as well as Humpback Whales during the
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
B111 is a one bedroom apartment with a king sized bed on the ground floor. B111 provides quick access from the lanai to the pool, tennis courts, putting green, park, and ocean at Luana Kai Resort. B111 is decorated with cool rich blue carpeting
- 2 bedroom
- 1 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
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
D306 is a beautiful deluxe, 2 bedroom, 2 bathroom apartment with a king size bed and two twin size beds. Condo D306 has pergo floor downstairs with a carpeted stairway and master bedroom int he loft. The bathrooms are have medium size tiles and
- 3 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
D307 is a deluxe, 2 bedroom, 2 bathroom condo with a king size bed and two twin beds. Condo D307 has white and earth toned tile floors
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Apartment C303 is a deluxe, 2 bedroom, 2 bathroom, partial ocean view condo with a king size bed upstairs and 2 twin beds downstairs. with nice views over the pool and filtered views of the ocean. The floors are tiled excepting the bedrooms
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Summary:
Top floor beachfront unit with vaulted ceilings, AC, Oceanview's and Beautiful Sunsets. Luana Kai is truly a beautifully landscaped property. You can enjoy a heated pool, Jacuzzi, Saunas, shuffleboard, BBQ area, tennis/pickleball
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kihei
*AC is an option. You must check the AC box during checkout or pay at the front desk. $25/night.
Maui Condo D204 is an air conditioned*, deluxe, 2 bedroom, 2 bathroom condo with a full ocean view. The master bedroom has a king sized bed
- 3 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
- 3 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 B308 is an air conditioned*, completely remodeled, 2 bedroom, 2 bathroom, partial ocean view condo on the northwest side of the
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Enjoy this updated loft suite with modern ocean vibe! We enjoy walking with our daughters to the beach just 300 ft away to spot sea turtles, find shells and coral, paddle board, or just relax. We also love the rich amenities by Luana Kai,
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
