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 (city = 'maui' OR postalCode = 'maui' OR region like '%|maui|%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Indulge in entertainment abound when vacationing in Wailea Beach Villas Penthouse 211. After you’ve spent an action-packed day at the beach or hiking one of Maui’s scenic trails, return to your vacation residence and discover some more ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maui
Concierge Realty is proud to present luxury villas at Marriott Maui Ocean Club Napili.
We are able to offer 7 night weekly rentals with check-in on Fridays, Saturdays, and Sundays only. This ad is for Friday check-in only. Please inquire ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Maui
Make an inquiry! I have pre-reserved villa units in July & Aug 2024 at the amazing Westin Kaanapali ocean resort villas. Dates are:: July 12-19 (1bd OV) & Aug 3-10 (Studio Island view @ KOR North) August 10-17 Studio Oceanview, Aug 17-24 Studio ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Maui
Concierge Realty is proud to present luxury villas at Westin Ka'anapali.
We are able to offer 7 night weekly rentals with check-in on Fridays, Saturdays, and Sundays only. This ad is for Sunday check-in only. Please inquire about the ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Comfort meets convenience at Ka‘anapali Beach Club, located on Maui’s western shore just minutes from downtown Lahaina. Relax in the pool, set among lush landscape and calming waterfalls, or sip your morning coffee at the on-site open-air ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Comfort meets convenience at Ka‘anapali Beach Club, located on Maui’s western shore just minutes from downtown Lahaina. Relax in the pool, set among lush landscape and calming waterfalls, or sip your morning coffee at the on-site open-air ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Comfort meets convenience at Ka‘anapali Beach Club, located on Maui’s western shore just minutes from downtown Lahaina. Relax in the pool, set among lush landscape and calming waterfalls, or sip your morning coffee at the on-site open-air ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Comfort meets convenience at Ka‘anapali Beach Club, located on Maui’s western shore just minutes from downtown Lahaina. Relax in the pool, set among lush landscape and calming waterfalls, or sip your morning coffee at the on-site open-air ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Comfort meets convenience at Ka‘anapali Beach Club, located on Maui’s western shore just minutes from downtown Lahaina. Relax in the pool, set among lush landscape and calming waterfalls, or sip your morning coffee at the on-site open-air ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Comfort meets convenience at Ka‘anapali Beach Club, located on Maui’s western shore just minutes from downtown Lahaina. Relax in the pool, set among lush landscape and calming waterfalls, or sip your morning coffee at the on-site open-air ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Comfort meets convenience at Ka‘anapali Beach Club, located on Maui’s western shore just minutes from downtown Lahaina. Relax in the pool, set among lush landscape and calming waterfalls, or sip your morning coffee at the on-site open-air ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Comfort meets convenience at Ka‘anapali Beach Club, located on Maui’s western shore just minutes from downtown Lahaina. Relax in the pool, set among lush landscape and calming waterfalls, or sip your morning coffee at the on-site open-air ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Comfort meets convenience at Ka‘anapali Beach Club, located on Maui’s western shore just minutes from downtown Lahaina. Relax in the pool, set among lush landscape and calming waterfalls, or sip your morning coffee at the on-site open-air ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Are you looking for a large living space that is walking distance to the beach with a slice of ocean view? The Blue Hula at Maui Kamaole is a 1-bedroom / 2-bathroom condo that is steps away from the Kamaole III beach plus hotel-style amenities ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Maui
*** Sanitation/Cleaning Update ***
At Diamond Resorts, the safety and well-being of our guests and team members is of utmost concern. We remain diligent in our commitment to provide a safe, hospitable environment for all who visit our ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Comfort meets convenience at Ka‘anapali Beach Club, located on Maui’s western shore just minutes from downtown Lahaina. Relax in the pool, set among lush landscape and calming waterfalls, or sip your morning coffee at the on-site open-air ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
"*** Sanitation/Cleaning Update ***
At Diamond Resorts, the safety and well-being of our guests and team members is of utmost concern. We remain diligent in our commitment to provide a safe, hospitable environment for all who visit our ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
This villa is located in the prestige area of Maui between the Ritz Carlton and Montage! The two-level villa is located on the second floor overlooking the 9th Green of Kapalua's Bay Course, with views of the Ocean and Molokai, and the West Maui...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Maui
Our comfortably furnished Kihei Kai Nani vacation condo will be your home away from home. Located in a lush tropical setting; palms, vibrant flowering trees, and the sweet perfume of plumeria and hibiscus will surround you. Afternoon tradewinds ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Maui
Why stay at a crowded hotel when you can have the entire condo to yourself? We are ready to welcome our guests back and are excited to again share Hawaii with you all.
If you are looking for a perfect get away in paradise, this is it! This ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maui