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 (`headline` like '%kealakekua bay%') AND sleeps>=1 order by rating desc LIMIT 0, 20
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
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
'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.
Enter the gate at 'Okika Lani and walk into an ...
- 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
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
*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
Hale Maluhia La‘a' - Home of Sacred Peace
Review all 99% of our wonderful
5 Star reviews on our home
Please contact the owner with any questions.
This is our beautiful 4-bdrm; 4th bdrm/Great Room home
It's spacious, airy, ...
- 4 bedroom
- 2 bathroom
- Sleeps 10
Hawaii> Capt Cook
"Pathway of the Gods" is the meaning of the name given by ancient Hawaiians to Kealakekua Bay. Five hundred feet from the bay, nestled among the palm trees and fragrant plumeria blossoms is the site of your next vacation. Let us "Big Isle" ...
- 3 bedroom
- 2 bathroom
- Sleeps 10
Hawaii> Captain Cook
The Pagoda House is a beautiful, almost ocean-front traditional Hawai'ian screen home with a private pool and lush tropical garden overlooking Kealakekua Bay Marine Sanctuary - widely considered some of the best snorkeling in all of Hawai'i. The...
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Captain Cook
I swim and see dolphins many times a week, the reason I chose to live at Kealakekua Bay. The "Ohana"-guest apartment for rent is on the GROUND floor. It is completely separate from the two floors where I live upstairs. You can walk down the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Captain Cook
This home Hale Lawai'a has a private kayak launch with excellent channel access to Kealakekua Bay.
The upstairs unit has 3 bedrooms, and 2 bathrooms. The master bedroom has a King bed, the guest room has a Queen bed and there is a queen...
- 3 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Captain Cook
Manini Beach Breath Taker
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Located in Kealakekua Bay, a protected marine sanctuary and an ideal...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Captain Cook
Kealakekua Bay (which means Pathway to the Gods) has one of the Big Island's most spectacular coral reefs. Because it is a Marine Life Sanctuary, the fish are plentiful and swarm over the well developed reef that slopes from the shores into the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Captain Cook
*Inquiry Only*
Welcome to Hale Mauka in the McCoy Plantation
Residence is just a few minutes from the main road, making it convenient to the market and restaurants. This family home was built by the McCoy plantation founder and his...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Captain Cook
Stay comfortably in Captain Cook at this 1-bedroom cottage. Nestled in a delightful setting, this charming retreat features a full bed, WiFi, and an iron for your convenience. The bathroom offers a refreshing shower to start your day. Kickback, ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Captain Cook
