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 (city = '96748' OR postalCode = '96748' OR region like '%|96748|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
You’ll love stepping from the ground floor lanai onto expansive lawns fringing this casual 570 sq. ft. suite with beautiful ocean views and tropical décor. The open design flows from a full kitchen with breakfast bar into the living area with...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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. Enjoy ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kaunakakai
Enjoy the serenity of Molokai at our beautiful Wavecrest condo, located on the lush east end of the island. Relax on the third floor lanai with the picturesque views of the ocean and coconut trees swaying in the breeze. Enjoy swimming in the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kaunakakai
Endure the magic of Molokai. Unwind, reset + enjoy the rarest of a traveler's dreams: a relatively untouched tropical escape. Masses of coconut palms sway in the breeze, and not a single traffic signal is to be seen. Relish in the spectacular ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kaunakakai
Pu'u O Hoku 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 was — ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kaunakakai
Molokai Shores A214
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
This one-bedroom, one-bath condo has views of the sparkling blue waters of the Pacific...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kaunakakai
Our condo is NOT on the island of Maui. It is located on Molokai.
Escape to our beautiful 3rd floor condo with ocean views, including views of Maui and Lanai. In whale season, you can whale watch from our lanai! Enjoy the fully equipped ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kaunakakai
Molokai Shores A314
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Molokai Shores 314 is a lovely condo located on the third floor that offers memorable ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
HI> Kaunakakai
Moloka'i - aka "the friendly isle"
Our condo is located on the 3rd floor. One bedroom; full bath and loft. Shower/tub combo. Body wash & shampoo dispenser. Bedroom has a queen size bed. Loft has a full size bed and a full size sofa/futon bed....
- 1 bedroom
- 1 bathroom
- Sleeps 6
HI> 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 community ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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
HI> Kaunakakai
Newly renovated 1 bedroom condo in the "A" building, which has the best 180 degree views from the Lanai showing the full coastline of Lahaina, Maui, Lanai Island and the calm pacific in between. Relax at a beautiful mosaic pool. Unit sports high...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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 the C ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kaunakakai
Take it easy at this unique and tranquil getaway in a setting much like the "old Hawaii" of 50 years ago. This very special place is lush and tropical with an ocean breeze flowing though the condo accompanied with the sounds of the coconut trees...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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 go....
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kaunakakai