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 = 'Captain Cook' OR postalCode = 'Captain Cook' OR region like '%|Captain Cook|%') AND sleeps>=1 order by rating desc LIMIT 0, 30
Welcome to PonoMana Oasis. A perfect and secluded destination if you are coming to Hawaii for a personal retreat, vacation or much-needed rejuvenation.
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Captain Cook
Welcome to PonoMana Oasis. A perfect and secluded destination if you are coming to Hawaii for a personal retreat, vacation or much-needed rejuvenation.
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Captain Cook
Please check out our cottage on the same property for smaller groups: Vrbo 953957
2 bedroom
3 bathroom
Sleeps 6
Hawaii> Captain Cook
DUE TO OUR AGE & MEDICAL HISTORY WE ARE ONLY ACCEPTING FULLY COVID 19 VACCINATED GUESTS! We have both had 3 shots of the Phizer vaccine, wear masks when in public and have kept our little coffee farm a safe place. We will not accept ...
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Captain Cook
3 bedroom
3 bathroom
Sleeps 10
Hawaii> Captain Cook
The Milolii Whale House offers breathtaking, 270 degree views of the Pacific Ocean! Located 100 yards from the waves crashing on the cliff side, the Whale House offers the best views in the area. Relax on one of the 2 spacious lanai's while ...
3 bedroom
3 bathroom
Sleeps 5
Hawaii> Captain Cook
‘Ohia Cottage is a well-appointed guest house on a secluded private farm in the heart of Kona’s coffee belt.
2 bedroom
1 bathroom
Sleeps 3
Hawaii> Captain Cook
One of three villas on a private, beautiful 5-acre orchard retreat in South Kona. Due to the elevation, the area is considered to have the best views in Kona displaying a combination of sloping hillside, shoreline and open ocean ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Captain Cook
One of three villas on a private, beautiful 5-acre orchard retreat in South Kona. Due to the elevation, the area is considered to have the best views in Kona displaying a combination of sloping hillside, shoreline and open ocean ...
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Captain Cook
A true Hawaiian-style vacation rental makes you feel welcome in this fully equipped family home. Just steps to the magical blue waters of Kealakekua Bay, you'll be able to swim, snorkel, and paddle practically in your front yard. With a ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Captain Cook
*We are only accepting 31+ day reservations*
4 bedroom
4 bathroom
Sleeps 7
Hawaii> Captain Cook
This comfy, stylish guesthouse is located near Kealakekua Bay and the Captain Cook Monument. Here you can enjoy snorkeling, hiking, kayaking, boat tours and scuba diving. Our Guesthouse offers 2 bedrooms with queen beds, a full-size kitchen, ...
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Captain Cook
The moment you enter the Royal Palm lined driveway of this gorgeous estate, you'll know you have arrived at your new sanctuary! Papa Belle Estate is a 3.5 acre oasis on the South Kona coast offering breathtaking views, wonderful amenities, and ...
2 bedroom
3 bathroom
Sleeps 4
Hawaii> Captain Cook
Peaceful 5 acre farm, stunning views of ocean, sun sets, night sky. Sprawling tropical surroundings, fruit trees and working coffee farm in a neighborhood with sheep, goats, chickens. Beaches within 20 minutes. Half hour from Captain Cook’s ...
3 bedroom
1 bathroom
Sleeps 5
Hawaii> Captain Cook
About this space
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Captain Cook
Experience the 'Aloha Spirit' at this 2 bedroom, 1 bath vacation rental in the Capitan Cook/Naalehu area. This roomy, remodeled guesthouse, with a private entry, also has a fully equipped kitchen.
2 bedroom
1 bathroom
Sleeps 5
Hawaii> Captain Cook
Enjoy spectacular views of Kealakekua bay in the newly built Coffee Cottage in Captain Cook, Hawaii! Situated amongst the coffee trees at a pleasant 1350 ft. elevation, it’s a perfect temperature year round.
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Captain Cook
Your hosts Tammy and Joe are committed to providing a 5-star experience. The home is maintained in immaculate condition with the highest levels of spotless cleaning before you check in.
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Captain Cook
Kona recalls the Beach Boys playing their pop hits by the pool. The band left but the good vibrations linger. Situated on 9.5 gated acres, gated for with an amazing Hawaiian plantation-style home with separate sleeping quarters and a guest ...
5 bedroom
5 bathroom
Sleeps 12
Hawaii> Captain Cook
Sun Tracks Across the Water ---
2 bedroom
1 bathroom
Sleeps 3
Hawaii> captain cook
STVR 19-360891, NUC 19-1179
2 bedroom
3 bathroom
Sleeps 4
Hawaii> Captain Cook
Everything you might need to enjoy an exciting or relaxing vacation right by the ocean at the beautiful and world famous, "Kealakekua Bay'.
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Captain Cook
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Captain Cook
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Captain Cook
Experience spinner dolphins, sea turtles, hump-back whales (in winter), manta rays, amazing fish and coral reefs at pristine Kealakekua Bay, a protected marine sanctuary.
3 bedroom
2 bathroom
Sleeps 7
Hawaii> Captain Cook
This rustic wooden mountain cabin is situated next to a forest, in a secluded spot away from the main house, on a 3.5 acre farm. At an elevation of 2,100 feet, it avoids the summer heat at sea level ('Cool and peaceful..' - Teri), yet is close ...
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Captain Cook
Beautiful island style cottage with sunset views and tropical garden. If you want to experience true Hawaiian living in an eco-friendly natural, non smoking environment this is your place. Have a soak in the tub, pick fresh herbs, veggies and ...
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Captain Cook
Please check out the main house on the same property for larger groups:
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Captain Cook
South Kona Hideaway is near some of the best snorkeling Hawaii has to offer. We are situated between Honaunau (Place of Refuge) and Kealakekua Bay at an elevation of 900 ft. Your beautifully decorated suite has a living room with a queen sofa...
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Captain Cook
Front row views of Kona sunsets
4 bedroom
4 bathroom
Sleeps 9
Hawaii> Captain Cook
