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 '%Hyatt Residence%') AND sleeps>=1 order by rating desc LIMIT 0, 20
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
Hyatt Residence Club Ka'anapali 2 Bedroom Unit Sleeps 6
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
Book our Amazing Luxury Villa & let The Timeshare Brokers, LLC make the booking ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
--PLEASE READ THIS FIRST --
PLEASE DO NOT USE THE 'REQUEST TO BOOK' FUNCTION (button on right side of page) BUT RATHER - USE THE "CONTACT OWNER" SMALLER BUTTON TO CONFIRM WITH US THAT YOUR DATES ARE AVAILBLE.
This property is a ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
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
LOOK!: This condo is available for CHRISTMAS WEEK! Dec 21-Dec 28, 2024 only.
If you are looking for the best vacation location in Lahaina, Maui, look no further!
This Hyatt Residence Club condo overlooks the unrivaled beauty of ...
- 3 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Lahaina
Available from Saturday, Jul. 20, 2024 (4pm check-in) to Saturday, Jul. 27, 2024 (10am checkout).
Minimum 6 nights from Jul. 20, 2024
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
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
Luxury fully furnished, 2 bedroom 2 bathroom oceanfront unit in top tier Hyatt Residence Club located inside world class Hyatt Maui beachfront resort, adjacent to Hyatt Regency hotel.
This 1,200 sq ft two bedroom suite has two bedrooms ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Lahaina
Available 14-21 October 2023.
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Look no further for your Maui escape - the unrivaled beauty of Ka'anapali Beach is just a few steps away at this Hyatt Residence Club property! The resort's sprawling grounds are home to everything needed to elevate your vacation; you can relax ...
- 3 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Lahaina
A short distance from scuba diving, snorkeling, and more, this beach condo lets you experience it all. There's convenient onsite parking, so you can leave your vehicle behind and head out to Kaanapali Beach and Hanakaoo Beach Park, just a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
