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 (`propertyName` like '%Maalaea Yacht Marina%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Newly remodeled, ocean side condo in Maalaea Harbor. 2 bedroom and 2 bath. Large outdoor lanai over looking the ocean. Lounge at the ocean side pool or walk a few steps to the beach. Some of the best views for seeing whales and sea life right ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailuku
Aloha! Welcome to our wonderful oceanfront Condo perfectly situated in Maalaea just 15 minutes from the airport, 10 minutes from Kihei and 25 minutes from Lahaina! If you are looking for a beautiful ocean view, just steps from the water, and you...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Wailuku
