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 '%Milowai%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Overview:
Marvel at the ocean and mountain views as you relax in this beautiful 4th floor, corner penthouse, oceanfront condo on Maui. Exit from your private elevator directly into the thoughtfully renovated and unique Dolphin Penthouse. Make ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Wailuku
We chose Milowai in Maalaea due to it's fantastic convenient and direct oceanfront location. It is only 20 minutes to almost anywhere on the Island and we love to see and do it all.
The unit is on the ground floor directly on the ocean and is ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Wailuke
