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 '%Maui Sands%') AND sleeps>=1 order by rating desc LIMIT 0, 20
🌺 Your Maui Paradise Retreat Awaits! Ocean/ Beachfront Bliss at the highly sought after resort of Sands of Kahana with Air Conditioning! 🏖️
🎉 Book with Confidence and get ready for an unforgettable escape to paradise! This ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Sands is a hidden gem near Kapalua, a family-friendly property with a handful of buildings and beautiful grounds full of tropical plantings, mature trees, and warm breezes. Enjoy amazing ocean views, sunsets, and wildlife watching from ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Disney and Mickey Mouse Tropical Heaven! Your Dream Hawaiian Vacation starts here! Stay in West Maui only 200 steps to the ocean. This beautiful condo has Air Conditioning in each bedroom and the living room. It has everything you ...
- 3 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Lahaina
MAUI SANDS SEASIDE. Oceanfront building with garden and ocean view. 1 bedroom ground floor condo within a paradise. This Maui Vacation Rental is the perfect escape destination. Come unwind on the special ocean-side sundeck and watch the turtles...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili-Honokowai
Stay in an ocean front complex with garden and ocean view from lanai. One bedroom ground floor condo within a paradise. This Maui Vacation Rental is the perfect escape destination. Come unwind on the special ocean-side sundeck and watch the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili-Honokowai
Private one bedroom at Maui Sands Seaside unit 720. Beautiful Oceanfront building with AC. Step out of this west Maui condo and snorkel with the turtles that swim off the beach or walk up the road to bite into fresh tropical fruit at the local ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Napili-Honokowai
Ohanacondos presents this oceanfront 1 bedroom top floor condo within a paradise. This Maui Vacation Rental is the perfect escape destination. Come unwind on the special ocean-side sun deck with and watch the turtles and whales. Aloha! Step ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili-Honokowai
