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, 50
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Two Bedroom Ocean View Villa at Marriott's Maui Ocean Club - New Lahaina Tower!
With its premier location, luxurious accommodations, and sprawling tropical grounds, Marriott Maui Ocean Club is a perennial Maui favorite, delighting couples...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Freshly Renovated One Bedroom Ocean View Suite at Marriott's Maui Ocean Club!
Family 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Freshly Renovated 2 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 ...
- 3 bedroom
- 3 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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Freshly Renovated 2 Bedroom Oceanview 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 oceanview ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Three Bedroom Oceanfront Villa at Marriott’s Maui Ocean Club!
With its premier location, luxurious accommodatiWith its premier location, luxurious accommodations, and sprawling tropical grounds, Marriott Maui Ocean Club is a ...
- 4 bedroom
- 3 bathroom
- Sleeps 12
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 ...
- 1 bedroom
- 1 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 ...
- 1 bedroom
- 1 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 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 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 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 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 ...
- 1 bedroom
- 1 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 ...
- 1 bedroom
- 1 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 ...
- 1 bedroom
- 1 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
- 1 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
- 1 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 ...
- 3 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 ...
- 3 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 ...
- 1 bedroom
- 1 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
- 1 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 ...
- 3 bedroom
- 3 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 ...
- 4 bedroom
- 3 bathroom
- Sleeps 10
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 ...
- 3 bedroom
- 3 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 ...
- 3 bedroom
- 3 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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Oceanfront Studio Villa at Marriott’s Maui Ocean Club - New Lahaina or Napili Towers!
With its premier location, luxurious accommodations, and sprawling tropical grounds, Marriott's Maui Ocean Club is a perennial Maui favorite, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Marriott’s Maui Ocean Club - Lahaina/Napili Villas is one of the most popular timeshare resorts in the Marriott Vacation Club. Kids and kids-at-heart will get a kick out of the resort's 3.5-acre super pool complete with a water slide, ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Your ideal Hawaiian trip starts with a stay at Marriott's Maui Ocean Club - Molokai, Maui, & Lanai Towers. Your large one-bedroom suite is located on scenic Ka'anapali Beach, one of the islands' most sought-after destinations. Your suite has a ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Your perfect Hawaiian vacation begins at Marriott's Maui Ocean Club - Molokai, Maui & Lanai Towers. Your spacious one-bedroom suite is situated on picturesque Ka'anapali Beach--one of the most desired locations in the islands. Your suite ...
- 1 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Marriott's Maui Ocean Club - Molokai, Maui & Lanai Towers - on Kaanapali Beach
OCEAN VIEW
2 Bedroom Villa - 3 bath
sleeps 8
June 7-14, 2024
7 days, $5,500 for week
Unit sleeps 8, Oceanview. Kitchenette with dishwasher, ...
- 2 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Bellani Vacations is proud to offer 2 bedroom villas at Marriott's Maui Ocean Club-Lahaina & Napili Towers.
**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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Find tranquility at Marriott's Maui Ocean Club - Molokai, Maui & Lanai Towers. Our beachfront vacation ownership resort welcomes visitors with a picture-perfect location on Ka'anapali Beach in West Maui. Test your swing at nearby ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> LAHAINA - MAUI
Freshly Renovated 1 Bedroom Mountain/Garden View 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Sleeps 4 - 1 Bedroom - 2 Beds - 2 Full baths
...............................................................................................................................................................
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Your perfect Hawaiian vacation begins at Marriott's Maui Ocean Club-Ka'anapali Beach. Your spacious one-bedroom 2 bath suite is situated on picturesque Ka'anapali Beach. Your suite includes a layout with bedroom, living areas, and balcanies. A ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Studio room at Marriott’s Maui Ocean Club. Amid the azure Pacific, along the crystal sands of Kā‘anapali Beach, Marriott’s Maui Ocean Club is an oasis of relaxation, adventure and bliss. Enjoy some of the best golf, tennis, diving and ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Three-bedroom villa at Marriott's Maui Ocean Club in Lahaina. Though you’re on a tranquil resort island, your accommodations include everything you need to make your Hawaiian getaway comfortable. Enjoy the 3.5 acre Superpool with a display of ...
- 4 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Lahaina
Come explore Maui at this premium level Marriott property by the ocean. Surrounded by clear, blue waters of the Pacific, this dream getaway is the perfect place to enjoy your next tropical destination.
This property has everything you ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
11 Nights available! Dec 22, 2024 to Jan 2, 2025 (7 night minimum)
Ocean View! And this is whale watching season.
This spectacular 16 acre Kaanapali Beachfront resort occupies one of the most coveted locales in Lahaina and also ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Marriott's Maui Ocean Club is one of the most popular timeshare resorts - and for good reason! This spectacular 16 acre Kaanapali Beachfront resort resort occupies one of the most coveted locales in Lahaina and also boasts a number of delicious ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Marriott's Maui Ocean Club - Lahaina Villas is one of the most popular timeshare resorts - and for good reason! Kids and kids-at-heart will get a kick out of the resort's 3.5-acre super pool complete with a water slide, waterfalls, and ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Enjoy the glamour of this stylish, upscale place. Napili Tower is one of the most popular timeshare resorts - and for good reason! Kids and kids-at-heart will get a kick out of the resort's 3.5-acre super pool complete with a water slide, ...
- 3 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Lahaina
Luxury reigns supreme in this one-bedroom, where all the comforts of a heavenly escape await.If you’re searching for the quintessential Hawaiian getaway, then this resort is quite the catch. If the sunshine, beaches, and glowing pools (many, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Luxury reigns supreme in this one-bedroom, where all the comforts of a heavenly escape await.If you’re searching for the quintessential Hawaiian getaway, then this resort is quite the catch. If the sunshine, beaches, and glowing pools (many, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Cozy yet spacious. Intimate yet extensive. This one-bedroom features luxurious comfort for memories together and space to escape.If you’re searching for the quintessential Hawaiian getaway, then this resort is quite the catch. If the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Cozy yet spacious. Intimate yet extensive. This one-bedroom features luxurious comfort for memories together and space to escape.If you’re searching for the quintessential Hawaiian getaway, then this resort is quite the catch. If the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Spread out with the whole family in this spacious two-bedroom suite.If you’re searching for the quintessential Hawaiian getaway, then this resort is quite the catch. If the sunshine, beaches, and glowing pools (many, many glowing pools) ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Spread out with the whole family in this spacious two-bedroom suite.If you’re searching for the quintessential Hawaiian getaway, then this resort is quite the catch. If the sunshine, beaches, and glowing pools (many, many glowing pools) ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
