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 '%Maui Kai%') AND sleeps>=1 order by rating desc LIMIT 0, 50
MAUI OCEANFRONT CONDOMINIUM... PREMIUM STUDIO... Third Floor.
Note: Please read our Guest Reviews
Prime third floor location provides privacy and the best view of ocean surf, whales and sea turtles. Instead of waking up in the ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
OCEANFRONT High Floor RENOVATED Maui Kai 806 Condo Private OPEN Lanai KING BED
Experience true oceanfront at low welcome back pricing!
Recent Cal KING bed and appliances!
MK806 is an oceanfront studio condo apartment with a perfect ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Oceanfront Maui Kai 1 bedroom, 1 bath on North Kaanapali Beach
New Remodel with New furnishings!
Walk to restaurants and stores
Heated Swimming Pool & Jacuzzi with BBQ Area
AC
Free parking and NO Resort Fees!
Our stunning, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Escape to the beautiful shores of West Maui and enjoy island living!! Our ocean front ninth-floor condo located at the Maui Kai resort in Kāʻanapali offers comforting amenities to make you feel at home. Here is why our Maui home is the best ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Oceanfront Maui Kai Penthouse 1 bedroom, 1 bath on North Kaanapali Beach
Walk to restaurants and stores
Heated Swimming Pool & Jacuzzi with BBQ Area
AC
Free parking and NO Resort Fees!
Highly sought after and completely ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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
...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Maui Kai 607 is a charming studio offering an amazing oceanfront location. You can't
get any closer to the water! Enjoy gazing out at the magical Maui waters, take in beautiful sunset or do some whale watching from your condo!This spacious ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
This condo is hotel zoned and complies with all current Maui County ordinances and regulations
Oceanfront Corner Unit with Panoramic Views – Your Maui Paradise Awaits!
E komo mai (welcome) to your perfect Hawaiian escape, where ...
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
Oceanfront Maui Kai 1 bedroom, 1 bath with enclosed lanai on North Kaanapali Beach
Walk to restaurants and stores
Heated Swimming Pool & Jacuzzi with BBQ Area
AC
Free parking and NO Resort Fees!
Beautiful one bedroom/one ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Oceanfront Maui Kai 1 bedroom, 1 bath on North Kaanapali Beach
Walk to restaurants and stores
Heated Swimming Pool & Jacuzzi with BBQ Area
AC
Free parking and NO Resort Fees!
Beautifully renovated one bedroom/one bathroom ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
