select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`headline` like '%Maui Kai%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Even if our automated calendar shows our condo is booked please check with us! Use the ASK OWNER A QUESTION option with no commitment prior to booking.
No Resort or Amenity charges
No Parking charge
No Extra Charges except what you see on ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Our Penthouse-level ocean front studio is remodeled, personally decorated, and complete with all the amenities you expect for a relaxing vacation. We offer all the comforts and conveniences of an island home, as we ourselves have been renters on...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
HAWAII'S COVID RULE ARE ALWAYS CHANGING
Please check BEFORE ARRIVING.
Our Unit is sanitized
Special note: Management is on property as well as housekeeping. Whatever you need it is on property, not like other management companies.
New ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
### PLEASE REFER TO => https://www.vrbo.com/2254443?adultsCount=2&arrival=2021-08-18&departure=2021-08-25. ###
Air Conditioning
Kitchen
Laundry
Non-Smoking
Outdoor Grill
Parking
Patio
Pool
Spa
Satellite Or Cable TV
Wireless...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Spectacular Ocean views from this highly desirable ninth floor one bedroom unit on the Kaanapali coast of beautiful west Maui. Enjoy beautiful unobstructed panoramic ocean views from your own spacious private and enclosed lanai.
View the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hi> Lahaina
This highly sought after and completely remodeled, top floor PENTHOUSE on Ka'anapali Beach has sweeping oceanfront views! Our stunning, one bedroom/one bathroom suite has exceptional features including new stainless steel appliances, beautiful ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Enjoy unbeatable panoramic views from this highly desirable 2nd floor oceanfront unit on the Kaanapali coast. You can’t get any closer to the ocean than this resort! Watch gorgeous sunsets over Molokai & Lanai every day from the comfort of ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Maui Kai 507 & 508
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
This family of Maui Kai condos is exactly what you need to wow your family and friends!...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> Lahaina
