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 (city = 'Kaanapali' OR postalCode = 'Kaanapali' OR region like '%|Kaanapali|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Completely remodeled December 2021 - Ground level Ka'anapali Royal Two Bedroom / Two Bath - Unit B-102. With over 1,500 sf of air conditioned living space all on one level, this gorgeous condominium is ideally located directly on the ...
2 bedroom
2 bathroom
Sleeps 4
HI> Kaanapali
This resort is currently fully open, all amenity use is subject to Hawaii State Covid-19 rules and regulations and CDC recommendations concerning social distancing and cleaning procedures. These rules and recommendations regarding amenity usage ...
2 bedroom
3 bathroom
Sleeps 6
HI> Kaanapali
This property was remodeled in 2020 and was just added to our rental pool! We are still working on finalizing furniture then professional photos will be taken.
**THE TOTAL AMOUNT LISTED IN THE "RATE CALCULATOR" REPRESENTS ROOM AND TAX ONLY. ...
3 bedroom
2 bathroom
Sleeps 6
HI> Kaanapali
Aston Ka’anapali Shores one-bedroom ocean view condo.
Located Oceanfront, the Aston Ka’anapali Shores offers a one-bedroom, one bathroom, ocean view condo. The condo includes a king or queen bed in the bedroom and a sofa-bed in the living ...
1 bedroom
1 bathroom
Sleeps 4
HI> Kaanapali
GREATLY REDUCED PRICE!! New Year's Eve and January 4 and 5!!
NEW YEAR’S EVE - GREATLY REDUCED PRICE!!
BIG SALE PRICE!!
Large inviting living room, Gorgeous dining room, breathtaking large Master Bd Rm and ensuite bath with a large modern ...
2 bedroom
2 bathroom
Sleeps 8
HI> Kaanapali
This resort is currently fully open, all amenity use is subject to Hawaii State Covid-19 rules and regulations and CDC recommendations concerning social distancing and cleaning procedures. These rules and recommendations regarding amenity usage ...
3 bedroom
3 bathroom
Sleeps 8
HI> Kaanapali
Welcome to Marriott's luxurious 5-star resort and its spectacular Lahaina and Napili Tower villas! Your sophisticated, bright, spacious oceanfront 3 bedroom/3 bath villa, with breathtaking panoramic Ka'anapali Beach and expansive Pacific Ocean ...
3 bedroom
3 bathroom
Sleeps 12
HI> Kaanapali
This is a lovely Studio featuring a Queen sized Murphy Bed. The bed is easily placed into the wall to expand your living space if you so desire. One of Maui Kai’s little gems is unit 302. In colorful, floral designs, this room presents itself ...
0 bedroom
1 bathroom
Sleeps 2
HI> Kaanapali
Aston Ka’anapali Shores two-bedroom garden view condo.
Located Oceanfront, the Aston Ka’anapali Shores offers a two-bedroom, two-bathroom, garden view condo. The condo includes a king or queen bed in the 1st bedroom, two twins in the 2nd ...
2 bedroom
2 bathroom
Sleeps 6
HI> Kaanapali
This resort is currently fully open, all amenity use is subject to Hawaii State Covid-19 rules and regulations and CDC recommendations concerning social distancing and cleaning procedures. These rules and recommendations regarding amenity usage ...
3 bedroom
3 bathroom
Sleeps 8
HI> Kaanapali
* Enjoy your stay with enhanced cleaning and disinfecting protocols. Private entrance to your condo, along with OPEN AIR OUTDOOR WALKWAY to your condo. *
Located in the heart of Kaanapali, enjoy the privacy of a spacious 1200 sq ft top floor ...
1 bedroom
1 bathroom
Sleeps 4
HI> Kaanapali
This resort is currently fully open, all amenity use is subject to Hawaii State Covid-19 rules and regulations and CDC recommendations concerning social distancing and cleaning procedures. These rules and recommendations regarding amenity usage ...
4 bedroom
4 bathroom
Sleeps 12
HI> Kaanapali
Located on the beautiful island of Maui, you will enjoy this tropical paradise and the many activities designed for the whole family. The resort offers spacious 1 bedroom villas, this one has an SCENIC VIEW, beautiful pool including adult only ...
1 bedroom
1 bathroom
Sleeps 4
HI> Kaanapali
This resort is currently fully open, all amenity use is subject to Hawaii State Covid-19 rules and regulations and CDC recommendations concerning social distancing and cleaning procedures. These rules and recommendations regarding amenity usage ...
3 bedroom
3 bathroom
Sleeps 8
HI> Kaanapali
This resort is currently fully open, all amenity use is subject to Hawaii State Covid-19 rules and regulations and CDC recommendations concerning social distancing and cleaning procedures. These rules and recommendations regarding amenity usage ...
2 bedroom
2 bathroom
Sleeps 6
HI> Kaanapali
