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. Our eco-friendly oasis is within minutes of some of the island’s best waters to ...
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. Our eco-friendly oasis is within minutes of some of the island’s best waters to ...
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Captain Cook
Please check out our cottage on the same property for smaller groups: Vrbo 953957 This Unique property showcases a 153 foot ocean facing deck with luxurious indoor/outdoor Hawaiian style living. Everything is completely redone and ...
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
We can help you with KAYAKS! As a means to provide protection to the marine wildlife, only permitted Kayaking is allowed in Kealakekua Bay. As part of our vacation home rental you are provided complimentary use of our kayaks and launch ...
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. How amazing would it be to wake up and smell the coffee in Hawaii?! Our cottage is a perfect setting to host honeymooners ...
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* With construction completed during the Summer of 2020, be one of the first to enjoy the open design and simple elegance of the Dolphin House. This oceanfront house has 3 bedrooms with en-suite ...
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 bath unit in small neighborhood. The space B & B style cute and homey 1 bedroom 1 bath downstairs apartment, newly remodeled, 800 sq. ft. of interior space. Has its own laundry room with washer, ...
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. Stroll around our 3 enchanting acres of ...
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. Stretch out in the California ...
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. The property is very private with secure gated ...
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 --- Sun Tracks Cross the Water Beautiful panoramic sunset views across the curvature of the earth. Close enough to watch whales, away from crowds and the beaten tourist path, your vacation starts here. This ...
2 bedroom
1 bathroom
Sleeps 3
Hawaii> captain cook
STVR 19-360891, NUC 19-1179 From home to ocean in under a minute! This newly built custom home is just 200 feet from the ocean and located in the heart of authentic Old Hawaii - Captain Cook locale on the Big Island of Hawaii. An ...
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'. This private location is perfect for adventuring around our quaint neighborhood, with quiet walks, ...
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Captain Cook
The secluded Cottage unit offers 1 bedroom (Queen & Twin), 1 bath and a full kitchen just foot steps away from the ocean where you can swim with dolphins and whales! There is a private Sun Deck with a breath-taking view of the bay and a ...
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Captain Cook
Kona Mauna Kai is a working farm on the slopes of Mauna Loa on the Big Island of Hawaii. Mauna Kai means mountain and ocean and that’s exactly what you get on our farm. 180 degree views of the beautiful Kona coastline. On the farm, ...
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. Enjoy glorious sunsets through the palm fronds from the lanai or ...
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: vrbo 1542506 This cottage is perfect for a couple looking to save money but still have a million dollar view. In Kealakekua Bay, just 3 minutes from some of the ...
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 Our two-story oceanfront home has views from every room and tropical breeze flowing from roof top cupola through every window and door. The main living area is upstairs with 4 bedrooms and 3 ...
4 bedroom
4 bathroom
Sleeps 9
Hawaii> Captain Cook