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 (city = 'maui' OR postalCode = 'maui' OR region like '%|maui|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Concierge Realty is proud to present luxury villas at Westin Ka'anapali.
We are able to offer reservations in seven night increments with arrivals and departures Fridays, Saturdays and Sundays
True paradise, overlooking a sparkling pool and ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Maui
Concierge Realty is proud to present luxury villas at Marriott Maui Ocean Club Napili.
We are able to offer reservations in weekly increments with arrivals and departures Fridays, Saturdays and Sundays.
Discover the true meaning of paradise.
...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> Maui
Vacations a la Mode is proud to present luxury villas at Marriott Maui Ocean Club Lahaina and Napili Towers.
We are able to offer reservations in weekly increments with arrivals and departures Fridays, Saturdays and Sundays.
Risk free ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> Maui
-- HAWAI'I COVID-19 SAFE TRAVELS PROGRAM ----
For anyone planning travel to the Hawaiian Islands, it is important to be aware of the State of Hawai'i Safe Travels Hawai'i program entry requirements prior to departure. This enhanced entry into ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Maui
BEST Location! Beachfront Resort-Top 6th floor- High End Remodel Complete
Beachfront, Oceanfront and on Front Street - Lahaina Shores Beachfront Resort. A hotel with many amenities including a 24 hour front desk
Absolutely beautiful ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> maui
This villa is located in the prestige area of Maui between the Ritz Carlton and Montage! The two- evel 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
HI> Maui
The world is changing, and we are changing with it. We have taken the time to revamp our practices to ensure a clean and safe environment for all of our guests and staff.
We have added very detailed cleaning checklists and have also implemented ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Maui
AMAZING 2 BEDROOM 2 BATH CONDO IN POPULAR PALMS AT WAILEA. SLEEPS UP TO 6 PERSONS. Largest 2 bedroom in area
Check out our other two condos VRBO 81055 & VRBO 1000286 This is the largest (1299 sq ft ) two-bedroom ‘C’ plan, built in The ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Maui
Our lovely one bedroom Maui vacation condo is situated on a half mile stretch of uncrowded white sandy beach in the beachfront community of Kahana. A first rate beach community conveniently located between the fabulous resort areas of Kaanapali...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Maui
** Enjoy your stay here with enhanced cleaning and disinfecting protocols. PRIVATE ENTRANCE (no shared door handle) along with OPEN AIR OUTDOOR WALKWAY to your condo.** | | Enjoy a premier ocean view from the J block at the Maui Eldorado Resort...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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
HI> Maui
** Please note, free night discounts are already included in the advertised rate and no additional deductions are necessary.** Enjoy this two bedroom and two-bathroom corner unit on the fifth floor of the Hokulani Building overlooking the Maui ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Maui
Ka'anapali Beach Club has 3 level's of rooms. Deluxe Ocean View is the highest tier. This Deluxe Ocean View room is a rare corner room with wrap around balcony. Both the living room and the bedroom have walk out balcony's and directly overlook ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Maui
** Please note, free night discounts are already included in the advertised rate and no additional deductions are necessary.** Relax in this spacious three-bedroom and three-bathroom oceanfront unit on the second floor of the Hokulani Building ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Maui
The world is changing, and we are changing with it. We have taken the time to revamp our practices to ensure a clean and safe environment for all of our guests and staff.
We have added very detailed cleaning checklists and have also implemented ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Maui
