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 '%Marriott\'s Maui Ocean%') AND sleeps>=1 order by rating desc LIMIT 0, 30
Freshly Renovated 1 Bedroom Oceanfront Suite at Marriott's Maui Ocean Club.
When you can’t afford a mediocre Maui vacation!
Family time is limited, make the most of your vacation time with an out of this world Ocean front ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
With its premier location, luxurious accommodations, and sprawling tropical grounds, Marriott Maui Ocean Club is a perennial Maui favorite, delighting couples and families with amazing vacations year after year. Ideally nestled in the heart of ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
With its premier location, luxurious accommodations, and sprawling tropical grounds, Marriotts Maui Ocean Club is a perennial Maui favorite, delighting couples and families with amazing vacations year after year. Ideally nestled in the heart of ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
With its premier location, luxurious accommodations, and sprawling tropical grounds, Marriott Maui Ocean Club is a perennial Maui favorite delighting couples and families with amazing vacations year after year. Ideally nestled in the heart of ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Why pay for a small hotel room when you can get TWICE the size for about the same price?
Marriott’s Maui Ocean club is a full service resort with everything needed for a fabulous stress-free vacation. Marriott just completed a ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Time is limited, make the most of your vacation time with an out of this world Ocean front experience. Why pay for a small hotel room when you can get THREE times the size for about the same price?
Marriott’s Maui Ocean club is a ...
- 2 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
For any reservation inquiries, please use the "Contact Host" feature under "Check Availability."
Hosted by Travelscowt.
Discover our exceptional ratings with hundreds of 5-star reviews on VRBO, Google, and our own Travelscowt ...
- 2 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
For any reservation inquiries, please use the "Contact Host" feature under "Check Availability."
Hosted by Travelscowt.
Discover our exceptional ratings with hundreds of 5-star reviews on VRBO, Google, and our own Travelscowt ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Thank you for your interest in booking with Bellani Vacations!
**Choose a Friday, Saturday, or Sunday for check-in, and enjoy a 7 night stay. We can typically only book this resort in 7 night increments. Please use the "CONTACT HOST" ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Come explore Maui at this premium level Marriott Resort set right on the beach. Surrounded by the clear, blue waters of the Pacific, this dream getaway is the perfect place to enjoy your next tropical destination.
This resort has ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
With its premier location, luxurious accommodations, and sprawling tropical grounds, Marriott Maui Ocean Club is a perennial Maui favorite, delighting couples and families with amazing vacations year after year. Ideally nestled in the heart of ...
- 3 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Lahaina
With its premier location, luxurious accommodations, and sprawling tropical grounds, Marriott Maui Ocean Club is a perennial Maui favorite, delighting couples and families with amazing vacations year after year. Ideally nestled in the heart of ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
