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 '%Makani A Kai%') AND sleeps>=1 order by rating desc LIMIT 0, 15
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
This 2nd story beach front condo offers direct beach access from complex grounds with views of the breathtaking Maalaea Bay, the grand volcano Haleakala and the sparkling Kihei lights at night. Enjoy your private lanai. The master features a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
This is a unique property on Maalaea Bay. Recently upgraded and renovated, it boasts wheelchair accessible features such as a large master bathroom, ADA compliant, including a large roll-in shower. Ground floor accessibility and very close ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Maalaea
