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, 50
Newly built LUXURY designer home including a 6-person HOT TUB and an amazing view of the ocean. The living space on the top floor is 2300 sq. ft. including a covered lanai of 1150 sq. ft. Bedrooms with attached bathrooms are 30 ft. apart with ...
2 bedroom
2 bathroom
Sleeps 5
Hawaii> Captain Cook
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Captain Cook
Ask about 10 day specials/ 2 person stays and 8th night free if you book a 7th night stay!!!!
3 bedroom
3 bathroom
Sleeps 10
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...
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Captain Cook
HAWAII LAW COMPLIANT !!
3 bedroom
1 bathroom
Sleeps 5
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
Aloha,
6 bedroom
6 bathroom
Sleeps 10
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
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
If you are adventurous and free spirited, but still require all the amenities a luxury rental home has to offer then Pu`uhonua ('Place of Refuge') is the place for you. Experience tropical Hawaii at it’s finest in this unique pole house ...
5 bedroom
3 bathroom
Sleeps 10
Hawaii> Captain Cook
Aloha and Welcome to Ocean Song!
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Captain Cook
'Okika Lani sits at the south end of Kealakekua Bay on a private road with spectacular views of the Pacific Ocean, the Captain Cook Monument, and crescent shaped, white sand Ke'ei Beach.
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Captain Cook
The property is a one-acre lot with a small mango orchard (30 trees), fruit trees (lime, lemon, orange and avocado) and a beautifully manicured landscape. The cottage is separate from the main house, so your privacy is assured. There is a ...
1 bedroom
1 bathroom
Sleeps 2
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 ...
2 bedroom
1 bathroom
Sleeps 3
Hawaii> Captain Cook
STVR 19-360891, NUC 19-1179
2 bedroom
3 bathroom
Sleeps 4
Hawaii> Captain Cook
Front row views of Kona sunsets
5 bedroom
4 bathroom
Sleeps 9
Hawaii> Captain Cook
Book now and enjoy an incredible stay on beautiful Hawaii Island for Christmas Week and the New Year!
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Captain Cook
Sun Tracks Across the Water ---
2 bedroom
1 bathroom
Sleeps 3
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
'HALE GEDIMINAS' vacation rental is in a lush tropical setting on sunny Kona Coast. Spectacular sunsets on private lanai with ocean view overlooking Ili-Ili beach, which is 5 min down by car. The unit is studio like with private entrance, has a...
1 bedroom
1 bathroom
Sleeps 2
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
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Captain Cook
Please check out our cottage on the same property for smaller groups: Vrbo 953957
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Captain Cook
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Captain Cook
4 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
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 peekaboo...
4 bedroom
3 bathroom
Sleeps 6
Hawaii> Captain Cook
Bay View Farms Estate House
4 bedroom
7 bathroom
Sleeps 20
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
*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, ...
3 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
Relax and rejuvenate in cozy comfort while staying with us. Enjoy the sights and sounds of nature as we are surrounded by exotic flowering trees, many of which are homes to a variety of birds and even coquis whose musical chirps along with the ...
1 bedroom
1 bathroom
Sleeps 2
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
Indulge in the ultimate Hawaiian getaway at this stunning 3-bed, 3-bath vacation rental house in Captain Cook. Upon arrival, you’ll be greeted by 3 manicured acres of mature fruit trees. Past the front door lies access to the ocean-view lanai,...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Captain Cook
Escape to paradise in this 1-bedroom, 1-bath vacation rental house in Captain Cook. Located near top attractions, like Kealakekua Bay and Puʻuhonua o Hōnaunau National Historical Park, this property is the perfect home base for your Hawaiian ...
2 bedroom
1 bathroom
Sleeps 3
Hawaii> Captain Cook
Enjoy your stay in our 24' and 30' yurts. Beautiful ocean views, sunsets, and starry nights.
2 bedroom
2 bathroom
Sleeps 7
Hawaii> Captain Cook
Manini Beachfront Getaway
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Captain Cook
Our home is in a rural area of the Big Island, on one acre of landscaped property with orchids, palms, banana plants, a koi pond and more. This is our personal residence, available the months when we are not there. The kitchen is totally ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Captain Cook
We are located 40 minutes from Kona, 1hr 20min from Volcano National Park and Pebble Beach is just 5 minutes from our home. We have a quiet and tranquil setting for you to fully relax hawaiian style. We have a couple of sunset viewing areas ...
0 bedroom
1 bathroom
Sleeps 2
Hawaii> Captain Cook
Make this home your base camp for all of your Big Island adventures. This unique round house with spectacular ocean views is located one hour from Hawaii Volcano National Park and one hour to Kona, a midpoint location for your sightseeing ...
2 bedroom
1 bathroom
Sleeps 6
Hawaii> Captain Cook
Makalani (Heavenly View) Cottage is a delightfully romantic cottage surrounded by a tropical garden in South Kona's coffee-belt with a breathtaking panoramic view of the Pacific Ocean. For the adventurous traveler seeking authentic Hawaiian ...
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Captain Cook
On-Site Whale Watching | 4 Snorkeling Sets | Wraparound Lanai
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Captain Cook
Kona Cliff House at Pebble Beach is a romantic getaway & perfect for all things ocean! Spectacular coastal views from every room in this fully remodeled penthouse. New custom gourmet kitchen stocked with your master chef needs.
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Captain Cook
2 bedroom
1 bathroom
Sleeps 3
Hawaii> Captain Cook
Modern 2 story home with Private Pool and deck to relax!!! Sleeps 12, this home has one of the best views from the large Lanai, with the ocean a stone's throw away to watch whales, dolphins & amazing sunsets! . This Vacation home is built for ...
4 bedroom
3 bathroom
Sleeps 12
Hawaii> Captain Cook
Tropical Hideaway is a charming Hawaii-style downstairs studio apartment in a lush garden setting, with ocean and sunset views, plus a chemical-free swimming pool with waterfall and private hot tub. Tropical Hideaway is just a three minute drive...
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Captain Cook
Welcome to Koni Kai, Hawaiian translation: Passionate Sea. Koni Kai is a beautifully designed, very comfortable oceanfront home. Considerable time and effort has been spent to ensure Koni Kai is equipped with everything one might want/need ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Captain Cook
Escape to our charming 2-bedroom +vacation home in Captain Cook, where you'll be greeted by stunning beach views and a host of amenities to make your stay truly memorable. Enjoy your favorite shows with the smart TV and satellite/cable ...
2 bedroom
3 bathroom
Sleeps 4
Hawaii> Captain Cook
