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, 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
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 ...
- 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.
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 ...
- 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
*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 ...
- 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
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 ...
- 3 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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
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
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
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...
- 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
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
This fully equipped 2BR/2BA oceanfront condo with partial ocean view has all the amenities, pool, hot tub, BBQ, tennis, putting green, shuffleboard etc... and is located right on the beach. The unit is situated on the south side of the Luana Kai...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Unit # A207 Popular Oceanfront end unit. These photos are from this unit including the photo from the lanai looking out at the ocean. Located on South Kihei Road, this condominium is set back approximately 100 yards from the water. Between the...
- 2 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
Vacation Rental B103 is an air conditioned*, two bedroom, two bath, ground floor unit with a sleeper sofa in the living area. It comfortably ...
- 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.
B108 is an air conditioned*, 2 bedroom, 2 bathroom garden view condo. It offers easy access to the putting green, pool, bbq's, tennis, and ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
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
A/c option* (Air conditioning is an option for an additional cost of $25/night +tax, to be paid to the front desk)
Unit C110 is a 2 bedroom, 2 bathroom, standard vacation rental with a king size bed, two twin beds, and a pleasing garden ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
A308 is a deluxe vacation rental on the end of the top floor of Building A in the North West part of the property. Like all third floor condos, it has a high vaulted ceiling with skyview windows. The living room has a huge Sectional sofa, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Unit B311 is a standard, two bedroom, two bathroom, partial ocean view condo with a newly remodeled kitchen. It has an upstairs master bedroom with a king size bed and a guest bedroom with two twin beds. B311 has red tile floors in the main ...
- 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
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
B110 is a beautifully remodeled, Deluxe one bedroom, one bathroom condo. It is a ground floor unit and ideal for heading to the pool area for enjoying a refreshing dip in the pool, a realxing soak in the hot tub or grilling on one of...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Escape to your dream vacation destination with our completely remodeled 1 bedroom condo, nestled right on the breathtaking shores of Maui. Enjoy a slice of heaven where modern comfort meets the natural beauty of the Pacific Ocean.
Enjoy ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Apartment C101 with the the a/c option* (Air conditioning is an option for an additional cost of $25/night +tax, You must check the AC box during checkout or pay at the front desk.) is a deluxe two bedroom, two bathroom, garden view ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
