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 = 'maunaloa' OR postalCode = 'maunaloa' OR region like '%|maunaloa|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Wander the white-sand shores of Kepuhi Beach a short stroll away or kick back, relax and enjoy the ocean view from your private lanai. No matter how you spend your time here in Molokai, this 2-bedroom, 2-bath vacation rental is sure to make it ...
2 bedroom
2 bathroom
Sleeps 5
HI> Maunaloa
Kepuhi Beach Resort. In front of the others. WHY TAKE A BACK SEAT TO THE OCEAN! Beside Kepuhi Beach it's a 10 min. walk to the Famous Papohaku 2 mile secluded Beach. Oceanside Pool. Equipped Kitchen....
1 bedroom
1 bathroom
Sleeps 2
HI> Maunaloa
Our condo is spacious and comfortable. We have a car that you can use while you’re there, too. The kitchen is fully stocked. It has everything you need for your stay, except for your personal items. It is very quiet and secluded with wildlife ...
1 bedroom
1 bathroom
Sleeps 4
HI> Maunaloa
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
I-3 is a spacious open oceanfront studio recently renovated in winter, 2018. With high ceilings and a wall of doors open to the screened lanai, you can relax and enjoy the sounds of the waves and a view of the beach. There is a fully equipped ...
1 bedroom
1 bathroom
Sleeps 2
HI> Maunaloa
This spacious open-air 1bedroom 2 bath townhouse is located on Molokai’s sunny west end at Kalua Koi. The architecture is plantation-style with two tall French doors spanning the length of the main floor. It is two-story with 1,200 sq. ft....
1 bedroom
2 bathroom
Sleeps 4
HI> Maunaloa
Hale Ula Lani (House of Red Sky) - 212 Ke Nani Kai
Molokai.....Hawaii’s best kept secret......a step back into the Hawaii of yesterday.
Only a stepping stone away from Honolulu and a ferry ride to Maui, this is the place to find welcome ...
2 bedroom
2 bathroom
Sleeps 4
HI> Maunaloa
Cheerful, clean and efficient studio space with direct ocean view. During whale season, wake up to whale watching from this cozy, charming studio that is well-stocked for your vacation enjoyment. Fully appointed kitchen, and cafe table in ...
1 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
Kepuhi Beach Resort Condo. Corner ground floor 1 BR. Living and Bedroom both face the awesome blue ocean view which is backdrop to the 11 acre green grounds full of mesmerizing swaying palm trees. 800' to water’s edge on Kepuhi Beach. Short ...
1 bedroom
1 bathroom
Sleeps 4
HI> Maunaloa
New to the rental market is a "front row" view unit with beautiful island furnishings for that tropical vacation get-away! Private and quiet. Relax in this 2 bedroom/2 bath 909 sq. foot condo with King size beds in both bedrooms.
Enjoy ...
2 bedroom
2 bathroom
Sleeps 4
HI> Maunaloa
2 Bedrooms, 2 Bathrooms, with additional loft. Sleeps 6. Non Smoking.
Welcome to MaiTai.
Mai Tai is a bright airy living space with vaulted ceilings that give your holiday home a spacious feel.
The kitchen, with granite counter tops has every ...
3 bedroom
2 bathroom
Sleeps 6
HI> Maunaloa
One of the finest studio units at Kepuhi Beach Resort, right on the ocean with no buildings or obstructions to your view and steps from the pool. Watch sunsets from the lanai and walk to the beach 200 feet away. This condo has been the owners ...
1 bedroom
1 bathroom
Sleeps 2
HI> Maunaloa
One of the few Paniolo Hale units within steps to the beach! 2 Bedroom, 2 Bathroom, & Wrap Around Lanai with Ocean Views
Our spacious, ocean-view townhouse is only steps from Kepuhi Beach. This 2000 sq ft townhouse feels more like a beach home...
2 bedroom
2 bathroom
Sleeps 5
HI> Maunaloa
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
HI> Maunaloa
