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
Make an inquiry! Now booking 2025 stays. Please inquire with any questions and dates you want me to check availability for. I can book 7 night stays in a 2bd, 1bd or studio villa depending on real time availability with Westin Owners site. I ...
- 2 bedroom
- 2 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
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
If you are looking for the closest proximity to a perfect white sandy beach then look no further! Enjoy ten miles of pristine beach with views of Haleakala and Kaho'olawe in the background just steps from your front door. Spot turtles and see ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
AMAZING 2 BEDROOM 2 BATH CONDO IN POPULAR PALMS AT WAILEA. SLEEPS UP TO 6 PERSONS. Largest 2 bedroom in area
This is the largest (1299 sq ft ) two-bedroom ‘C’ plan, built in The famous Palms at Wailea. with vaulted ceilings with huge ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maui
Practice Aloha in this 2 bedroom 2 bath lock-off Villa. The larger side has a living room with sofabed, dining area, kitchen. Master bedroom with Heavenly Bed, HDTV and bathroom with large shower, double vanities jacuzzi tub. The smaller side ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Maui
Hotel Zoned Accommodations: Condominium - 3 Bedrooms - 2 Baths - (Sleeps 6)
Professionally Cleaned Condo, No-Contact Check-In/Check Out
Newly installed AC throughout
This spacious 1145 sq. ft. two bedroom and a loft ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maui
Escape to paradise at Maui Banyan H-210, your ultimate Hawaiian retreat! Nestled across the street from the stunning Kamaole Beach 2, with picturesque views of the majestic West Maui Mountains, this location offers unparalleled beauty and ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Maui
Brand New, $150,000 modern kitchen/vanities with surround Aquarium murals. Brand New sliding doors $35,000. New $10000 Morrocan Rug!
Brand New Stainless Steel Refrigerator and New Stainless Steel Oven and new SS Hood. New red Kitchen-aid ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
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
Can be rented as a 2 bedroom, 1 bedroom, or studio.
We are in Building G, Unit 304.
Time to get away!
Great Location. 300' from the beach! Unit located right across the street from Kamaole Beach II. Kamaole Beach II is one ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maui
One Bedroom villa, washer/dryer in unit, full kitchen. (TWO bedroom villa also available, please inquire about rates). Rate quoted is for island/garden view villa.
Please choose a Friday through Sunday arrival and enjoy a 7 night ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Hono Kai C12 is just steps from Maui's Sugar Beach! Located in central Maui, this property makes it easy to explore all of Maui. Enjoy your morning coffee on your private lanai with tropical garden views and tranquility. Watch many whales ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
For our guests’ peace of mind, this property has incorporated enhanced cleaning and low-contact protocols.
ABOUT THE SPACE
This Deluxe One-Bedroom Ocean-View Condo is a spacious 820 sq. ft. featuring sweeping views of the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Concierge Realty is proud to present luxury villas at Marriott Maui Ocean Club Napili.
Reservations are available in weekly (7 night) increments with arrivals and departures on Fridays, Saturdays, and Sundays only.
Nestled along ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Concierge Realty is proud to present luxury villas at Marriott Maui Ocean Club Towers
We are able to offer reservations in weekly increments with arrivals and departures Fridays, Saturdays and Sundays.
Nestled along the pristine ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Stroll the white sand Ka’anapali Beach, sharing the sunsets with the isles of Lana’i and Moloka’i in view. Dine in the finest restaurants or grill your own fresh fish and steaks near the pool. Take a short walk along the boardwalk to ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Maui
*DISCLAIMER: All referenced views in the "Amenities" section indicate ALL OF THE RESORT'S AVAILABLE VIEW TYPES. There is no guaranteed view on the specific unit you'd be booking unless indicated on the listing headline. By proceeding with this ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maui
Two Bedroom Villa picturesque Maui Views from furnished private lanai. New stainless steel appliances, washer and dryer, Kitchen fully equipped. Enjoy whale-watching, snorkeling wind surfing scuba diving just steps away....
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maui
