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, rewritten_description,
(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 '%Hyatt Residence%') AND sleeps>=1 order by rating desc LIMIT 0, 50
3 Bedroom Oceanfront Luxury at The Hyatt Residence Club – Ka'anapali's Newest, Most Exclusive Resort.
Perched upon Ka'anapali, one of the world's most beautiful beaches is the Hyatt Residence Club Ka'anapali. Within the lush borders of
- 4 bedroom
- 3 bathroom
- Sleeps 11
Hawaii> Lahaina
AMAZING! LUXURY! BEST OF THE BEST 3 Bed, 3 Bath in Maui!! Ocean Beach front Paradise!!
THE UNIT IS AN UPPER FLOOR 3 BEDROOM, 3 BATH WITH SPECTACTULAR OCEANFRONT VIEWS OVER THE PALM TREES! There are only 6 upper floor 3 bedroom units at
- 4 bedroom
- 3 bathroom
- Sleeps 11
Hawaii> LAHAINA
Please choose a Friday through Sunday for check-in and enjoy a seven-night stay.
Rates are set for Garden/Island View. Ocean view/oceanfront may be available depending on your travel dates.
Thank you for choosing Dash Realty
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Available from Saturday, Jul. 5, 2025 (4pm check-in) to Saturday, Jul. 12, 2025 (10am checkout).
Minimum 6 nights from Jul. 5, 2025
Luxury fully-furnished, 2 bedroom 2 bathroom oceanfront unit in top tier Hyatt Residence Club
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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 connected to the
- 4 bedroom
- 3 bathroom
- Sleeps 10
Hawaii> Lahaina
Available Jun 1-8 2024 and Jun 8-15 2024.
Look no further for your Maui escape - the unrivaled beauty of Ka anapali Beach is just a few steps away at this highly acclaimed Hyatt Vacation Club property. The resorts sprawling grounds are
- 2 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Lahaina, HI
Enjoy the prime holiday season at Kaanapali’s newest and most luxurious resort, the Hyatt Residence Club Kaanapali. This unit is available for a 7-night or 14-night booking, with check-in and check-out on Saturday. This one-bedroom mountain
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Please note that this listing is for a Saturday - Saturday stay, either Dec. 20 - Dec. 27, Dec. 27 - Jan. 3 or the entire 14 day period. If you choose to check in or out on a different day, you will be charged for the entire 7 or 14 night
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
