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, 50
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 ...
- 2 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 ...
- 2 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
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 ...
- 2 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 ...
- 3 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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 3
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
Whale season is here dates are filling up fast book now. Newly 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
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 ...
- 2 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
Beautiful 2 Bedroom Condo on the island of Molokai. Wonderful east end condo with access to the beach and great views of Maui and Lanai. Fully stocked kitchen ready for you to come and enjoy. Lanai off the Primary bedroom and private bathroom. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaunakakai
Remodeled Ocean View Condo at Molokai Shores!! You walk into Engineered Bamboo Flooring in Hallway and Living Room. The Lanai is Nicely Tiled and has a Wicker Couch to Lounge on and High Bistro Table that Allows you to see the Beautiful Ocean ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaunakakai
Enjoy the peace and tranquility of this amazing ocean-view property. You’ll sleep soundly at night to the sound of the crashing waves. Ask us about vehicle availability options during your stay. This unit is a quick walk to the Kepuhi Beach, ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaunakakai
Spacious and wonderfully positioned corner unit condo on the third floor that offers privacy, no noise from above and only one wall connecting this unit with others. The main living area and bedroom face the ocean for spectacular views. There...
- 2 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Kaunakakai
Feel at home the moment you step into A311, our recently remodeled condo, Aloha Kai. Look right as you enter the front door and you’ll instantly see why you came to Molokai—the stunning view across the ocean channel of neighbor islands Maui,...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaunakakai
Get away to the island of Moloka'i, the best kept secret of the Hawaiian Islands because it is the "Real Hawaii." Experience a real Hawaiian Island of 50 years ago! Our kitchen was recently remodeled! We are in building "A" of ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kaunakakai
There's nothing else like it! Some will say it’s 'awesome', others have called it 'amazing', the Hawaiians would say 'no ka ‘oi' (the best).
Hale No Ka ’Oi is simply the best home away from home you will find on Molokai and ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai,
Yea! Our WiFi has just been upgraded, September 2022, in our remodeled, privately owned unit.
Our oceanside condo is located in the only hotel on the island, Hotel Moloka’i, and is within a 2 mile walking distance from Kaunakakai ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Kaunakakai
LAST MINUTE SPECIAL WINTER RATES @ $150 NT+TAX & FEES
GREAT CONDO, GREAT LOCATION, GREAT DEAL FOR A GREAT MOLOKAI GETAWAY. BOOK YOUR STAY TODAY!
UPDATED UPSCALE OCEAN FRONT 1ST FLOOR CONDO @ WAVECREST RESORT IN BUILDING A ON ISLAND ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaunakakai
Come enjoy the natural peace and beauty of Molokai, HI from your private lanai that is truly ocean front. Start your day with an amazing view of the sun rising over Maui while enjoying your favorite beverage and breakfast with the sounds of the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Your next island getaway awaits on Molokai - a Hawaiian island anchored by the highest sea cliffs in the world! Explore all that Hawaii’s 5th island has to offer from this 1-bedroom, 1-bath vacation rental located on the shores of Kaunakakai ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Resort living in Old Hawaii
Somewhere in time is a memory of unspoiled Hawaii. Listen to the waves, feel the trade winds, and watch the whales. Step off the lanai with your fresh fish for an easy stroll to our community ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Welcome to Wavecrest! Unique 2 bedroom unit -only a few with double lanais. The privacy of the top end offers the best ocean views. This property is 13 miles from Kaunakakai on the east end towards the Halawa Valley. Wavecrest offers an ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kaunakakai
Nicely set up unit; there are two queen sized beds for comfortable sleeping. Recently remodeled, the fully equipped kitchen makes cooking a pleasure. Everything you need is provided, including linens, washer and dryer in the complex, flat ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
This condo is located on beautiful Molokai. Enjoy the quiet setting of this condo located on the ground floor at the far eastern side of the complex unit C134. Many people that have stayed in this unit comment that its location on the grounds ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Beautiful oceanfront condo at Molokai Shores. Clean and comfortable, A106 has been completely renovated in 2014 - tile floors throughout, new appliances (yes, there is a dishwasher!), new beds and furniture, luxury linens, flat screen TV's in ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
This unit sits at the ocean end of A building where it catches a cool breeze almost everyday while overlooking the manicured grounds of Molokai Shores and the Pacific Ocean lined by palm trees. The sun rises beautifully over Maui and sits behind...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Discover the tropical oasis you've been dreaming of at this 1-bedroom, 1-bathroom Kaunakakai vacation rental. Nestled in the idyllic Molokai, this cozy condo offers a patio to soak in the stunning island views. Spend the day enjoying a splash in...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Aloha Molokai!
It will be Humpback Whale season in the Kaholi channel of Molokai, Hawaii, December - April, an epic event to watch these giants with their babies so close up.
If you are looking for the true ALOHA spirit, this ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
This is a newly renovated 1 bedroom condo on the ground floor in the 'C' building at Wavecrest Resort. It has been renovated with attention to detail including soothing colors, "black-out" curtains, crown molding throughout, beautifully tiled ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
The premier unit at Wavecrest, one of only two ground floor rentals with views of the ocean and neighboring islands and the pali. Nicely set up unit with a king sized and queen sized beds for comfortable sleeping. The bathroom and master ...
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Kaunakakai
Leisurely island-living awaits at this 1-bed, 1-bath Kaunakakai vacation rental! With a pool and private beach access at your fingertips, there's every reason to spend time enjoying the balmy tropical weather of Molokai Island. If you feel like ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
**ALOHA...before booking - our condo is located on Molokai not Maui.
Our condo is located on the 3rd floor (B326) One bedroom; full bath and loft. Shower/tub combo. Body wash & shampoo dispenser. Bedroom has a queen size bed. Loft has a ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Wavecrest C309
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Make your way to this beautiful ocean view condo, located on the third floor of...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Make memories that’ll last a lifetime at this 1-bedroom, 1-bath Kaunakakai vacation rental! This bright property features 2 flat-screen TVs, a well-equipped kitchen, and resort amenities just steps from your door. Lounge by the pool, play ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
It’s all about the view in this 570 sq. ft. home edging landscaped lawns and the Pacific. A private lanai offers incredible views for sharing meals prepped in the open-style kitchen. Other comforts include hardwood floors, breakfast bar, cable...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> KAUNAKAKAI
Molokai Shores unit #217: Upon entry, notice the open layout that leads your gaze to the sliding glass door offering views of the Hawaiian blue sky and palm trees just outside your second-floor retreat. Handsome hardwood-like flooring and a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaunakakai
Molokai Shores unit #317: High ceilings, stunning ocean views, and a spacious, open-concept design highlight this 805-square-foot two-bedroom/two-bathroom with a loft vacation retreat. This space is designed for a relaxing retreat with vivid ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaunakakai
Molokai Shores unit #131, on the ground floor: Stroll across a manicured lawn from the ground floor lanai of your renovated oceanfront suite to a gorgeous beach. The beach is perfect for a morning stroll or an evening of stargazing. Celebrate ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> KAUNAKAKAI
Ground-Floor Unit | Lanai w/ Rocking Chairs | Steps to Pool & Waterfront Lounge Chairs
Bid Aloha to Molokai and revel in the magical feeling of this untouched Hawaiian island! Nestled on the island's southern shore, this 1-bed, 1-bath ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Wavecrest C211
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Boasting a covered lanai and access to a shared pool, a cabana, grills, shared ...
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaunakakai
Wavecrest A309
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
This is a deluxe, top-of-the-line, one-bedroom, oceanfront condo located on the...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Cherish every moment in this one-bedroom Oceanview condominium with breathtaking views of the Pacific. Feel like you’re floating while relaxing on your private lanai. Inside you’ll find a kitchen with a full-size oven/stovetop and ...
- 1 bedroom
- 2 bathroom
- Sleeps 3
Hawaii> Kaunakakai
Wavecrest C216
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Your peaceful Hawaiian getaway awaits at this second-floor Wavecrest Resort ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kaunakakai
