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 '%Makani Sands%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Oceanfront Condo in West Maui is your home away from home while exploring the island. Private lanai on the ocean with spectacular views of our neighboring islands of Molokai & Lanai. Completely remodeled with new granite kitchen & bathroom. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> LAHAINA
Enjoy beautiful sunsets, magnificent views of the islands of Lanai and Molokai, turtles off the reef and whales in the winter season from the lanai of this 2nd floor one bedroom fully updated Maui Rental Condo. Unit 202 includes fully equipped ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Makani Sands Unit #207 is a beautiful one bedroom condo on the 2nd floor. Easily accessible by stairs or elevator. You will be mesmerized by the sound of the waves and the views out to the islands of Lanai and Molokai. The beautiful outside ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Makani Sands condo #107 is a one bedroom condo on the first floor where you can walk out to the grass and beach. This condo has been freshly painted and updated. The ocean side lanai off the living room is perfect for watching the sunset over ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Makani Sands #305 is a freshly renovated & beautifully decorated 3 Bedroom, 2 1/2 Bath townhouse on the 3rd & 4th floor. With two lanais boasting incredible views of the ocean & neighboring islands of Molokai and Lanai you will have a front row ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Welcome to Makani Sands Unit #206. This beautiful one-bedroom condominium surrounds you with traditional Hawaiian feel and décor in your own beachfront home by the sea! To make your vacation in Paradise effortless, there is a High Definition ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
MAKANI SANDS 106-Honokowai - Direct Beachfront - Sandy Beach - With spectacular views of the Pacific, you will have a front row seat watching breath-taking sunsets and unobstructed views of the humpback whales when in season. Pride of ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honokowai
Makani Sands townhouse #309 is a 3 Bedroom, 2 1/2 Bath condo on the 3rd & 4th floor with 3 lanais, and an incredible view of the ocean our neighboring islands of Molokai & Lanai. Upstairs, there is a king bed in the master bedroom with private ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
Makani Sands Unit #208 is your home away from home while on Maui.
This one bedroom condo has a beautiful view of the ocean, as well as our neighboring islands of Molokai & Lanai. Condo has bamboo floors in the living room, and a large ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
This Unique spacious corner #310 at Makani Sands, is the largest condo in the building! 3 Bedroom, 3 1/2 Bath on the 3rd & 4th floor has incredible views of the ocean and neighboring islands of Molokai & Lanai, with quick access to our beach & ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Lahaina
Unit 101, a 1 bedroom 1 1/2 bath West Maui vacation rental corner condo will make your Maui vacation just like being at home. From your private vacation rental lanai, you can watch the beautiful sunsets or relax to the sound of the ocean's ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Makani Sands condo #203 is a one bedroom on the 2nd floor. This condo is beautifully decorated in the Hawaiian style with all the comforts of home. There is a full kitchen and all the necessary appliances, conventional stove, and a microwave. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Makani Sands #301 is a spacious corner 3 Bedroom, 2 1/2 Bath townhouse on the 3rd & 4th floor corner, with an incredible view of the ocean. Decorated in a traditional Hawaiian style, this beautiful townhouse comes equipped with 3 cable TVs. ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
Makani Sands #302 is a 3 bedroom 2 1/2ba townhouse on the 3rd & 4th floors with 3 lanais with spectacular view. Quick access to our beach and BBQs. This beautiful condo is filled with art work by local Hawaiian artists. Gourmet kitchen with new...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Makani Sands unit #109 is located on the 1st floor with quick access to our sandy beach. Private lanai on the ocean side has a table & chairs so you can sit with your morning coffee or watch the sunset over the ocean in the evening. There is a ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Come visit our family owned and upgraded one bedroom condo as it has everything you will need. Being on the second floor gives you a stunning and an unobstructed view of Lanai and Molokai islands, passing sailboats, sea turtles, Humpback whales,...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
