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 (`headline` like '%Island Sands%') AND sleeps>=1 order by rating desc LIMIT 0, 15
This rare ocean-front condo is stunning! Listen to the sound of the ocean from the comfort of your home, while watching whales (Dec-April) and Hawaiian Green Sea Turtles all year long!
Located a five minute walk from boats, Maui Ocean Center ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Wailuku
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
Oceanfront Condo with Ocean and Mountain Views on Beautiful Ma`alaea Bay.
We are taking extra care to disinfect frequently touched surfaces between reservations.
Welcome to Island Sands Unit 401, an oceanfront community that sits on the ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Wailuku
New split system a/c cooling living room and both bedrooms! This 5th story unit offers gorgeous views of the ocean, Haleakala and peaceful Maalaea Bay that you can enjoy on your large, shady, private lanai which is accessible from the living ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Maalaea
With the ocean just a stones throw away, you will be amazed by the spectacular breathtaking panoramic views! Immaculate and upgraded this spacious 989 sf 2 bedroom, 2 bath, oceanfront condo is your oasis in paradise. Master bedroom and living...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Wailuku
Hawaii Tax ID: TA210-586-8288-01
TMK: 380140150061
Completely renovated beautiful oceanfront condo overlooking Maalaea Bay.
From your private lanai, enjoy the spectacular ocean views with Kahoolawe and Molokini in the backdrop. Or relax by the...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
Direct Oceanfront Condo with Ocean and Mountain Views on Beautiful Ma`alaea Bay.
We are taking extra care to disinfect frequently touched surfaces between reservations.
Welcome to Island Sands Unit 206, an oceanfront community that sits on ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
Cooling breeze throughout the condo in living room and both bedrooms! This 6th story unit offers gorgeous views of the ocean, Sea Turtle sanctuary, Haleakala and peaceful Maalaea Bay that you can enjoy on your large, shady, private lanai which ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
Island Sands Resort 105
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
The Island Sands Resort on Maui is located oceanfront in Maalaea, just a short ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailuku
This 5th story unit has gorgeous views of the ocean and west Maui mountains. Views of peaceful Maalaea Bay that you can enjoy on 2 separate private lanais which is accessible from the living room and master bedroom. The master has a privacy ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Maalaea
Island Sands Resort 607
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
The Island Sands Resort on Maui is located oceanfront in Maalaea, just a short ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Wailuku
Island Sands Resort 208
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
The Island Sands Resort on Maui is located oceanfront in Maalaea, just a short ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailuku
Stunning Ocean Views from the lanai of this newly remodeled 2 bedroom/2 bathroom Island Sands oceanfront property near Ma'alaea Bay and Harbor. The beauty and serenity of Maui abounds at Island Sands Resort.
This top floor corner unit offers ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailuku
Island Sands Resort 107
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
The Island Sands Resort on Maui is located oceanfront in Maalaea, just a short ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Wailuku