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, 20
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 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
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, ...
- 1 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 ...
- 0 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 ...
- 1 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
This condo is hotel zoned and complies with all current Maui County ordinances and regulations
E komo mai to Maui Kai 301, our stunning 1-bedroom, 1-bathroom corner unit condo at the prestigious Maui Kai Resort in Kaanapali, Maui. This ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
