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 (city = '96748' OR postalCode = '96748' OR region like '%|96748|%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Come share our little oceanfront slice of paradise on Molokai. When you visit the Wavecrest Resort, the A-building is where you want to be. Right on the water, the experience is totally different. You have a front-row seat for all the beauty ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Wavecrest, Kaunakakai
TA-061-740-4416-01
GE-061-740-4416-01
This recently remodeled ground floor oceanfront condo with spectacular ocean views on the lush and undeveloped east end of the " friendly" island of Molokai , is one of the most picturesque locations. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaunakakai
2 Bedroom 1.5 Bath & very rare 2 lanais with oceanviews - Sleeps 6
Gorgeous rare condo at Wavecrest with the luxury of 2 bedrooms, 1.5 baths and 2 separate lanais that both have views of ocean and beautiful tropical courtyard.
Also,...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaunakakai
Pu'u O Hoku Ranch offers a unique getaway for travelers seeking a rustic retreat. You can hike, swim, stargaze, surf, and see a working ranch in action. Pu'u O Hoku is one of the few places in the islands where you can feel Hawaii as it once ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kaunakakai
The 2nd floor A building location is by far the best in all of Wavecrest. Closest to the water, less noise / more private than first floor, below the palm fronds for the best views. Also, you can see the pool from the lanai to decide when to ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Welcome to Molokai Shores luxury condo Ka Hale Kealoha A215! This beautifully updated (and freshly painted Sept 2021!!) 526 sq ft condo boasts high end appliances as well as a fully equipped kitchen with everything you would ever need. Sleeps 4 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
This corner unit is one of the few true two-bedroom ocean front condos on the island of Molokai. The is located in building A at Wavecrest Condominiums, the grounds are beautifully manicured and well equipped with a covered BBQ grill and cabana ...
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Kaunakakai
Resort living in Old Hawaii
Somewhere in time is a memory of unspoiled Hawaii. Listen to the waves, feel the trade winds, watch the whales. Step off the lanai with your fresh fish for an easy stroll to our community barbecue.
The ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Aloha and welcome to Molokai Island Retreat!
Molokai Island Retreat is located on the highly desirable lush east end of Molokai (We are not on Maui) in the Wavecrest Resort. Our condo has the benefit of having a bird's eye view of both ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Our condo is NOT on the island of Maui. It is located on Molokai.
Escape to our beautiful 3rd/top floor condo with ocean views, including views of Maui and Lanai. In whale season, you can whale watch from our lanai! Enjoy the fully ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
“Pu'u O Hoku” is true to its Hawaiian name — which means “Hill of Stars”— surrounded by more than 14,000 acres of protected land, immersed in the transcendent beauty of forest, sky, and ocean. The Ranch is a family-owned biodynamic ...
- 12 bedroom
- 14 bathroom
- Sleeps 30
Hawaii> Kaunakakai
Rare find - Wavecrest’s only ground floor, 2 bedroom 2 unobstructed ocean view lanais unit on the unique island of Molokai. Private washer and dryer in the unit are an added bonus. Wavecrest is on the East end of Molokai which is the most ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaunakakai
Set sail to Molokai and book an unforgettable stay at this Kaunakakai vacation rental. The 1-bedroom, 1-bathroom tropical condo, located in the Molokai Shores Resort community, boasts access to the year-round outdoor pool, shuffleboard, picnic ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kaunakakai
Aloha!
This unit places you amid lovely tropical garden areas with views of the Ocean. An ocean front pool with cabana, a reading library, gas grills, lounge chairs, tennis/pickleball courts and shuffleboard are here for you to enjoy. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaunakakai
Wavecrest C109
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Find your island zen at this Wavecrest Resort condo. Just a short drive from ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaunakakai
Recently renovated, our oceanfront condo is located in Kaunakakai east end of island of Molokai. It is not on Maui. Watch whales from the Lanai during season.
The lanai has a full size comfortable couch to enjoy sunrise and sunsets. The ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kaunakakai
Molokai Shores unit #332: One look inside this recently renovated one-bedroom/one-bathroom with a loft vacation suite, and you’ll see why it’s one of the first to be booked every season. Chic island décor with attractive furniture and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
*MOLOKAI - NOT MAUI*
Here at Rainbow Retreat, we take your comfort extremely seriously. From the Cozy Earth bamboo bedding (Oprah's favorite, 5 years running) to the quality furniture and design you will sink into and enjoy the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Escape to paradise at this 1-bedroom, 1-bath vacation rental in Kaunakakai. Located in the highly sought-after Molokai Shores Resort, this condo offers a tranquil getaway with access to a community pool, gas and charcoal grills, a private ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Molokai Shores A308: Oceanfront living awaits in this modern and tropically designed space. You will enjoy cool living on your private lanai or using one of the three ceiling fans in each bedroom and main living space.
Unwind after a day...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
