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 '%Hono Kai%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Located just steps away from the longest beach on Maui with sugary sand, this remodeled condo is located on the 2nd floor with ocean views from every room, including your private lanai overlooking the ocean. You will be able to spread out in ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Maalaea
Soak in the views on your private lanai with this updated 2 story condo located on the 3rd floor with room to spread out with incredible ocean views, all just steps to the sand. The downstairs bedroom features a king bed with tub shower bathroom...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Maalaea
Nestled at the entry of the complex, just doors back from the beach, this remodeled and well-appointed condo on the second floor is just steps from the sand. Relax on your private lanai or in the bedroom suite which offers a comfy king bed and ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Wailuku
In this beautiful ground floor garden-view unit, you will feel immersed in the rich tropical foliage as you enjoy your private patio only steps away from beach access! Recently remodeled, this unit features a bedroom suite with a new comfy king ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Wailuku