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 '%kepuhi beach resort%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Kepuhi Beach Resort #1153
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Newly remodeled, this ground-floor condo at Kepuhi Beach Resort offers beautiful...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Maunaloa
Kepuhi Beach Resort #1152
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Discover beautiful views of the ocean from your private lanai at this ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Maunaloa
Top floor, 2nd story condo at Kepuhi Beach Resort on the West Shore of the island of Molokai. Vaulted 25’ tall ceilings for a really expansive feel. Corner unit, for a panoramic experience…….Surf in one direction, palm trees in the ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Maunaloa
Closest to the water, one-bedroom, corner ground floor private unit. Newly upgraded full kitchen/granite counters & new appliances + new bathroom vanity
King size bed looking onto the ocean.
Sunsets right out front with no obstruction
Close to ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Maunaloa
Kepuhi Beach Resort is located next to Papohaku Beach (three miles of white sand beaches). Address is 1131 Kaluakoi Rd. Unit 2174, Maunaloa, HI 96770
Snorkeling is within footsteps of your door, Beach equipment included: Boogie Boards, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Maunaloa
Kepuhi Beach Resort #2156
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
This second-floor, ocean view studio at Kepuhi Beach Resort has a wonderfully ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Maunaloa
Enjoy watching the video tour!
Our wonderful cottage is located just steps from the pristine white ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
HI> Maunaloa
Welcome to Molokai, the most 'Hawaiian' island in the Hawaii.
Kepuhi Beach Resort is located on the west end of Molokai, next to the longest stretch of sandy beach in Hawaii, Papohaku Beach (three miles of white sandy beach). On any given ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Maunaloa
Kepuhi Beach Resort #1231
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Kepuhi Beach Resort #1231 is a very private, studio-style condo that sits at the...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Maunaloa
Kepuhi Beach Resort #1162
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Walk just a few minutes to the white sand beach from this ground-floor condo at ...
- 0 bedroom
- 1 bathroom
- Sleeps 3
HI> Maunaloa
Kepuhi Beach Resort #2143
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Discover a beautiful, two-level condo with an ocean view and a bedroom loft at ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Maunaloa
Kepuhi Beach Resort #2222
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Located in the oceanfront Kepuhi Beach Resort, this two-level, loft-like condo ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Maunaloa
Kepuhi Beach Resort #1234
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
There's nothing to obstruct the oceanfront view other than palm trees swaying in...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Maunaloa
Kepuhi Beach Resort #1182
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
This ground-floor condo, located in the middle of the villas complex at Kepuhi ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Maunaloa
Kepuhi Beach Resort #1226
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
This ground-floor, corner condo at Kepuhi Beach Resort offers an extra dose of ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Maunaloa
