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 (`propertyName` like '%kepuhi beach resort%') AND sleeps>=1 order by rating desc LIMIT 0, 20
We do not accommodate for Race events. Please chose another condo for these events. You cannot beat the view it is the best. One of the best priced premium oceanfront condos at Kepuhi Beach Resort. Welcome to the heavenly island of Molokai ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaluakoi
Located on Molokai’s West End in Kepuhi Beach Resort, our beautifully remodeled ocean-view condo has everything you need to experience your aloha paradise. The king size bed in the bedroom loft and queen sofa sleeper in the living room ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Maunaloa
A fabulously furnished 2nd floor condominium at Kepuhi Beach Resort. The condo has a private lanai is covered for shade, allowing you to relax, watch the sunset over the channel. The oceanfront pool and barbecue area are a short walk from the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Maunaloa
