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 = 'maalaea' OR postalCode = 'maalaea' OR region like '%|maalaea|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
As you step through the door of this newly renovated condo, you're met with the sight of bright blue ocean and harbor views straight ahead off your own private lanai. With a fully remodeled kitchen and brand new modern furnishings throughout, ...
1 bedroom
1 bathroom
Sleeps 3
HI> Maalaea
Dream your most desired vacation. Then come to magical Maui, one of the world’s most elite vacation destinations. How better to experience our island than by renting from an owner who has combined her own personal getaway with the conveniences...
1 bedroom
1 bathroom
Sleeps 2
HI> Maalaea
Enjoy breathtaking ocean views from this 4th/top floor unit. One of the largest lanais at the complex! The bedroom has a new comfy king bed, beautifully remodeled tiled walk-in shower, 40" Roku smart TV and a split system a/c unit to keep you ...
1 bedroom
1 bathroom
Sleeps 4
HI> Maalaea
New....New....New.......everything new here. All new furniture, new bedding, new linens.....new owners!
This is the place for you....direct oceanfront....with the surf, turtles and whales right in front of you! Sit on your oceanfront lanai ...
1 bedroom
1 bathroom
Sleeps 4
HI> Maalaea
*100% REFUND WITH PROOF OF POSITIVE COVID TESTS TAKEN 3 DAYS PRIOR TO ARRIVAL*
Recently remodeled throughout! (To see our reviews for our other units in this building, search on this site for 1393484 and 1893280)
1 bed (Cal King), 1 bath, ...
1 bedroom
1 bathroom
Sleeps 4
HI> Maalaea
Gourmet kitchen, reverse osmosis water system, special star gazing binoculars, a special bath pillow, marble bath, 440 thread count sheets, separate number mattress system in master bedroom.
Plus peace and serenity is what you'll find here in ...
2 bedroom
2 bathroom
Sleeps 3
HI> Maalaea
THE MAKANI A KAI RESORT 'ON THE BEACH' is the smallest resort in Maalaea with only 24 units, and one of only two complexes that have full beach front access. You can't get closer to the Pacific ocean than you can in this bright spacious fully ...
2 bedroom
2 bathroom
Sleeps 4
HI> Maalaea
*100% REFUND WITH PROOF OF POSITIVE COVID TESTS TAKEN 3 DAYS PRIOR TO ARRIVAL*
Remodeled floors, kitchen and bathroom!
(To see our reviews for our other units in this building, search on this site for 1070628 and 1893280)
1 bed (Cal King), 1 ...
1 bedroom
1 bathroom
Sleeps 4
HI> Maalaea
This upscale, high end condo has all the amenities and comforts you could ever want in a vacation rental. A large dining table is located on the lanai where you can sit and watch the whales, boats and surfers. The weekend brings the canoe club ...
2 bedroom
2 bathroom
Sleeps 4
HI> Maalaea
You'll find surf, sunshine and a relaxing time if you stay at this magnificent 2-bedroom/2 bath luxury condo. The view from the double lanai is panoramic and steps away from the ocean. The first of the winter whale sightings have been spotted ...
2 bedroom
2 bathroom
Sleeps 4
HI> Maalaea
Located just steps away from the longest beach on Maui with sugary sand, this remodeled condo is located on the 2nd floor with ocean views from every room, including your private lanai overlooking the ocean. You will be able to spread out in ...
2 bedroom
2 bathroom
Sleeps 6
HI> Maalaea
Enjoy breathtaking views of Maalaea Bay, the grand volcano Haleakala and the sparkling Kihei lights at night, all from the comfort of your private lanais off the master and living room. This 3rd floor condo has a split system a/c in the living ...
2 bedroom
2 bathroom
Sleeps 4
HI> Maalaea
Location, location, location! Wake up to diamonds sparkling on the ocean top.
Spectacular top floor views of Makena, Molokini crater, and the Island of Kahoolawe. Whales in full view from our lanai during whale season, all while enjoying ...
1 bedroom
1 bathroom
Sleeps 2
HI> Maalaea
When in the master bedroom bed you'll feel as if you are on a cloud with the stars and moon above. The bedroom wall is all glass facing the ocean. You'll feel as if you are floating away to sleep on a magical cloud. You can open the side ...
2 bedroom
2 bathroom
Sleeps 4
HI> Maalaea
Soak in the views on your private lanai with this updated 2 story condo located on the 3rd floor with room to spread out with incredible ocean views, all just steps to the sand. The downstairs bedroom features a king bed with tub shower bathroom...
2 bedroom
2 bathroom
Sleeps 4
HI> Maalaea
