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 '%Kaanapali Plantation%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Ocean views from every room, most peaceful & private location in Kaanapali Plantation. Situated steps from the pool& tennis court yet do not hear any noise. Off of the street and parking areas. Nestled on the hillside overlooking the Royal ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
This property is hotel zoned, and not being affected by the recent proposed legislation.
Nestled in the West Maui Kaanapali hillside, Kaanapali Plantation 62 top-to-bottom renovation (2021). Enjoy this spacious 3-bedroom/3-bath townhouse ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Across the street from North Ka'anapali Beach, is the lush tropical and beautifully maintained Plantation Resort.
Situated on over 10 acres, #12 is a large upgraded two bedroom / one and a half bath condominium with panoramic golf ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaanapali
** Last-Minute Cancellations...take advantage of special rates into the Summer! **
Kaanapali Plantation #7 - Single level, spacious, two bedroom/two bath with central air conditioning. The jewel of this condominium is the lanai which can ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Escape to paradise in this remodeled plantation style cottage nestled in the heart of the International Colony Club, Kaanapali, Maui. Boasting 3bedrooms and 2bathrooms, this charming retreat offers ample space for relaxation and rejuvenation. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
