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 '%Hyatt Residence%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Whether you choose to spend your days exploring the island of Maui or lazing about on the soft sand of the island’s signature beach, Hyatt Residence Club Maui, Kāʻanapali Beach Resort promises to offer the ideal home base for any Hawaiian ...
- 3 bedroom
- 3 bathroom
- Sleeps 12
HI> Lahaina
This flawless residence is what dreams are made of. Unveiled with the grand opening of the Hyatt Residence Club Ka'anapali Christmas New Years 2014/2015, 12 exquisitely appointed 3Bedroom residences Boast 2100+ square feet and are the new ...
- 3 bedroom
- 3 bathroom
- Sleeps 11
HI> Lahaina
Note: Hawaii updates on COVID-19 protocols for travelers can be found here: https://www.gohawaii.com/travel-requirements
Our Cancellation Policy: Travelers who cancel at least 14 days before check-in will get back 100% of the amount they’ve...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
world's most beautiful beaches, is the Hyatt Residence Club Ka'anapali. Within the lush borders of this sprawling tropical paradise, families are delighted year after year with exceptional service and amenities that only a five star hotelier is ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
ali, one of the world's most beautiful beaches, is the Hyatt Residence Club Ka'anapali. Within the lush borders of this sprawling tropical paradise, families are delighted year after year with exceptional service and amenities that only a five ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Beautiful 2 bedroom 2 bath residence with amazing oceanfront views!
Kaanapali, one of the world's most beautiful beaches, home to the Hyatt Residence Club Kaanapali. Within the lush borders of this sprawling tropical paradise, families are ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Over 2000 sq. ft. three-bedroom suite with one king in both the master bedroom and second bedroom and two queen beds in the third bedroom, queen size sleeper sofa, and stunning ocean, beach, and pool views.
Full kitchen, private furnished ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
Two bedroom two bath ocean view villa, 1,174 sq. ft. residence that features one king and one queen bed, queen sleeper sofa, full kitchen with stainless steel appliances, furnished lanai and views of the ocean, beach and pool. A free-standing ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
2 Bedroom suite with king beds and queen sleeper sofa (sleeps 6) and beautiful direct ocean and pool views. The unit is located on floor 9 or above, direct ocean view. Relaxing lobby lounges overlooking the pool and ocean, where you can enjoy ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
HI> Lahaina
Beautiful 2 bedroom 2 bath residence with amazing oceanfront views!
Kaanapali, one of the world's most beautiful beaches, home to the Hyatt Residence Club Kaanapali. Within the lush borders of this sprawling tropical paradise, families are ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Exquisite 2 Bedroom Residence With Jaw-Dropping Oceanfront Views at Kaanapali's Newest, Most Exclusive Resort!
Proudly perched upon Ka'anapali, one of the world's most beautiful beaches, is the Hyatt Residence Club Ka'anapali. Within the lush ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
HI> Lahaina
Two bedroom two bath ocean view villa, 1,174 sq. ft. residence that features one king and one queen bed, queen sleeper sofa, full kitchen with stainless steel appliances, furnished lanai and views of the ocean, beach and pool. A free-standing ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Exquisite 2 Bedroom Residence With Oceanfront Views at Kaanapali's Newest, Most Exclusive Resort!
Proudly perched upon Ka'anapali, one of the world's most beautiful beaches, is the Hyatt Residence Club Ka'anapali. Within the lush borders of ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
HI> Lahaina
Hyatt Residence Club and Ka'anapali Beach are the perfect blend of relaxed living that borders on perfection. Nestled between seashells and rainbows. This is a great 3 bedroom 3 bathroom unit on a level 1-4. This property is brand new and ...
- 3 bedroom
- 3 bathroom
- Sleeps 11
HI> Lahaina
Proudly perched upon Ka'anapali, one of the world's most beautiful beaches, is the Hyatt Residence Club Ka'anapali. Within the lush borders of this sprawling tropical paradise, families are delighted year after year with exceptional service and...
- 2 bedroom
- 2 bathroom
- Sleeps 7
HI> Lahaina
