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 = 'lahaina' OR postalCode = 'lahaina' OR region like '%|lahaina|%') AND sleeps>=1 order by rating desc LIMIT 0, 50
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Lahaina
Welcome to Hale Mahina A-302! With a direct oceanfront view and located on a secluded and gated white-sand beach, our condo is perfect for those looking for a quiet and relaxing West Maui getaway.
2 bedroom
1 bathroom
Sleeps 3
Hawaii> Lahaina
Welcome to Maui Ka’anapali Villas!
1 bedroom
2 bathroom
Sleeps 4
Hawaii> Lahaina
This second floor garden view studio at Aina Nalu Resort provides an excellent base for your vacation. The studio has a queen bed, dining area, efficiency kitchen, vaulted ceilings and a bathroom. The kitchen features: conduction cooktop (one ...
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Lahaina
Unit 162.
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Lahaina
Maui is outdoor living at its finest! Enjoy having breakfast lunch and dinner on your lanai staring at the ocean! Wake each morning to birds singing, swaying palm trees and the teal blue waters of the ocean.. there is no escaping the absolute ...
2 bedroom
2 bathroom
Sleeps 5
Hawaii> Lahaina
Book any 5-day minimum from 2/1/25 - 2/28/25 and get a $999 nightly rate.
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Lahaina
Royal Kahana 907 is located on the northwest side of the building which is the quiet side of the building that offers both sun and shade onto the lanai. With the opposite side of the building there is no escaping the sun or the sound coming up ...
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Lahaina
UPGRADED UNIT***OCEANVIEWS FROM THE LIVING AREA AND MASTER BEDROOM***AIR CONDITIONED***GOURMET KITCHEN***EQUIPPED WITH BABY GEAR!!
2 bedroom
2 bathroom
Sleeps 6
Hawaii> Lahaina
PRIME SEASON DISCOUNT DUE TO CANCELLATION: Dec 12 - 20, 2024.
1 bedroom
2 bathroom
Sleeps 4
Hawaii> Lahaina
Aloha! Come and experience your Maui dream vacation!
2 bedroom
2 bathroom
Sleeps 6
Hawaii> Lahaina
Imagine your own little private, gated sanctuary, on the water … a stunningly lush paradise that is all yours. The warm, scented breeze … flowers … palm trees … exotic flora and fauna. It feels like you’re far from civilization as you ...
2 bedroom
3 bathroom
Sleeps 4
Hawaii> Lahaina
Discover the best in hospitality: Your five-star retreat awaits!
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Lahaina
Maui Kaanapali Villas is located on 11 acres of beautifully landscaped tropical gardens. The beach in front of the property is rated number one on Maui. There are many activities just steps away including snorkeling, swimming and scuba. Check ...
0 bedroom
1 bathroom
Sleeps 2
Hawaii> Lahaina
Our condo, now with Air conditioning! Our condo is in north Lahaina, far away from the fire affected areas. We are considered to be located Napili Honokowai. Our unit E-8, is one of 72 units in an oceanfront resort. This unit is a townhouse ...
2 bedroom
2 bathroom
Sleeps 5
Hawaii> Lahaina
Papakea is an unique property. Instead of a high rise it is a set of buildings only 4 levels high. There are three sets of buildings that front the ocean and we are located in the middle section--the perfect location for reaching either of the...
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Lahaina
Kahana Sunset is a beachfront resort on the world famous west coast of Maui, 10 minutes south of Kapalua and north of Kaanapali. You will be swimming and snorkeling with turtles and tropical fish off of the white sand beach of protected Keoni ...
2 bedroom
3 bathroom
Sleeps 6
Hawaii> Lahaina
NO RESORT OR PARKING FEES WHEN BOOKING WITH US!
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Lahaina
#1 GUEST FAVORITE! Enjoy this luxury residence with beautiful bamboo flooring, contemporary island design, dramatic floor-to-ceiling windows and easy access to heavenly Napili & Kapalua Bays. This home offers you a chance to fill it with ...
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Lahaina
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Lahaina
*Available for booking! Thankfully, our condo is not located in the wildfire affected area*
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Lahaina
FREE daily activities included with your stay value up to $570! Complimentary admission, every day of your stay*: Whale Watch (seasonal), Dinner Sunset Sail, Snorkel Sail, Alpaca Farm Tour, Pineapple Farm Tour, and All Day Electric Bike Rental. ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Lahaina
The Kahana Beach House is a spacious and comfortable home located across the street from a secluded beach. Close to some of Maui's best restaurants, golf, and exciting island attractions the beach house serves as a great central hub to explore ...
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Lahaina
Summary:
4 bedroom
3 bathroom
Sleeps 9
Hawaii> Lahaina
Located on the shores of Kaanapali Beach this remodeled and completely refurnished unit has all the amenities needed to make your Maui vacation a perfect experience and hoping you will return to our Hale again one day.
1 bedroom
2 bathroom
Sleeps 4
Hawaii> Lahaina
Enjoy a prime ocean and golf course view, while sipping your morning coffee from the privacy of your own lanai.
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Lahaina
Experience a relaxing Hawaiian vacation in one of Maui's most serene oceanfront settings. Despite the devastating fire in Lahaina, Puamana remains a haven of tranquility and beauty, where the spirit of "Old Hawaii" lives on. Unit 9-1 is located ...
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Lahaina
This oceanfront, single-level townhome is located just 25 feet from the water, offering a front-row seat to stunning sunsets and surfers from the comfort of your lanai. While the Lahaina fire has impacted some parts of the community, this ...
4 bedroom
2 bathroom
Sleeps 8
Hawaii> Lahaina
Okika (Orchid) Hale - Luxurious Villa - just steps to beach! | Aloha and welcome to the Okika (Orchid) Hale an elegant tri-level three bedroom vacation home located just steps away from two of Maui's most beautiful beaches and the world famous ...
3 bedroom
3 bathroom
Sleeps 7
Hawaii> Lahaina
Aloha and welcome to this Maui treasure. Whaler #224 is a tropical 1 bedroom, 2 bath partial ocean view home with a wonderful corner location that boasts views of both the ocean and mountains from the incredible wrap-around lanai. The interior ...
1 bedroom
2 bathroom
Sleeps 4
Hawaii> Lahaina
3 Bedroom Oceanfront Luxury at The Hyatt Residence Club – Ka'anapali's Newest, Most Exclusive Resort.
4 bedroom
3 bathroom
Sleeps 11
Hawaii> Lahaina
2 Bedroom Mountain/Garden View Villa at Marriott's Maui Ocean Club – New Lahaina Tower!
3 bedroom
2 bathroom
Sleeps 8
Hawaii> Lahaina
Kapalua Golf Villa 18V4 is a 1-bedroom, 2-bathroom villa that accommodates 2 guests and just completed a full remodel in December 2022. Feel at ease when arriving through your private entrance, welcoming you into a beautiful and bright living ...
1 bedroom
2 bathroom
Sleeps 2
Hawaii> Lahaina
Luxury Oceanfront Studio Villa at The Westin Ka'anapali Ocean Resort Villas North.
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Lahaina
Freshly Renovated 1 Bedroom Oceanfront Suite at Marriott's Maui Ocean Club.
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Lahaina
2 bedroom
1 bathroom
Sleeps 2
Hawaii> Lahaina
This incredible listing was recently remodeled and boasts gorgeous views of both the tranquil blue Pacific Ocean AND the lush West Maui Mountains.
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Lahaina
2 Bedroom Oceanfront Luxury Villa at The Westin Ka'anapali Ocean Resort North!
3 bedroom
2 bathroom
Sleeps 8
Hawaii> Lahaina
2 Bedroom Oceanview Luxury Villa at The Westin Ka'anapali Ocean Resort North!
3 bedroom
2 bathroom
Sleeps 8
Hawaii> Lahaina
This exquisite three-bedroom suite offers an incredible location, the first unit back from the very front of the building. You will be perfectly situated to enjoy partial views of the Pacific Ocean while soaking up the morning sun with your ...
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Lahaina
Hokulani 511 boasts an incredible 5th-floor interior courtyard location with full ocean views above the palm trees. Gather, reconnect, and celebrate in this spacious 2 bedroom floor plan which offers an abundance of interior living space with an...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Lahaina
Konea 613 is amongst a class of the most sought after 2 bedroom floor plans at Honua Kai. What distinguishes this column in the Konea interior are the direct ocean views from virtually every interior vantage point of the suite. This premier ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Lahaina
Hokulani 246 is an opulent two bedroom partial ocean view suite offering views of the Pacific Ocean and the awe-inspiring West Maui Mountains. As the second two bedroom back from the front you will find that this suite is well situated to enjoy ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Lahaina
Upon first entrance to Konea 402, your senses will acknowledge that you've chosen one of the finest three bedroom direct oceanfront residences that Honua Kai has to offer. ALI'I (Hawaiian word for 'royalty') residences offer the largest 3BR ...
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Lahaina
Hokulani 248 is a luxurious two bedroom suite that offers guests the best of both worlds. Enjoy beautiful partial ocean views, as well as stunning views of the West Maui Mountains, right from the comfort of your spacious lanai ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Lahaina
Two Bedroom Ocean View Villa at Marriott's Maui Ocean Club - New Lahaina Tower!
3 bedroom
2 bathroom
Sleeps 8
Hawaii> Lahaina
Freshly Renovated One Bedroom Ocean View Suite at Marriott's Maui Ocean Club!
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Lahaina
Luxury 3Bdrm villa, ocean view, sleeps 10, close to beach and pool!
4 bedroom
3 bathroom
Sleeps 10
Hawaii> Lahaina
Penthouse 2Bdrm, ocean views as far as you can see, remodeled!
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Lahaina
Freshly Renovated 2 Bedroom Oceanfront Suite at Marriott's Maui Ocean Club.
3 bedroom
3 bathroom
Sleeps 8
Hawaii> Lahaina
