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, 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
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
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
Please Send An Inquiry Before Requesting To Book By Clicking The Contact Host Tab
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...
- 3 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Lahaina
Concierge Realty is proud to present luxury villas at Hyatt Ka'anapali Beach Club!
**Reservations are available in weekly (7 night) increments with arrivals and departures on Saturdays only.
**All bookings are time sensitive and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Please note that this listing is for a Saturday - Saturday stay, either Dec. 23 - Dec. 30, Dec. 30 - Jan. 6 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
