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 '%kona coast%') AND sleeps>=1 order by rating desc LIMIT 0, 50
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
Official website. When Granma was 95, we had to move her in with us to take care of her. This left her little panabode cabin (900 square feet with a 500 square-foot wrap-around lanai) vacant. Lucky you . . . you can spend your Hawaiian vacation ...
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Kailua-Kona
Plan your next tropical getaway and book this Kamuela condo for a week of beach exploration from the comfort of a tropical sanctuary. Located just a mile away from Holoholokai Beach Park, this 2-bedroom, 2.5 bathroom vacation rental lets you ...
2 bedroom
3 bathroom
Sleeps 6
Hawaii> Kamuela
2 bedroom
3 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Kona Coast Resort #10-301 is one of the best ocean view 2 bedroom, 2 bath condos, with all of the amazing amenities of a 5-Star Resort! Enjoy two Swimming Pools, one “family” pool with an on-site Restaurant/bar, and nightly live music plus ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Kailua Kona
Experience the best of Kona in this bright and inviting retreat! Located within walking distance to grocery stores, Historic Ali‘i Drive, downtown, and the pier, this cozy getaway offers the perfect blend of convenience and island charm. Enjoy...
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Kailua-Kona
The clear Pacific waters, volcanic rock beaches, and vibrant hibiscus flowers of the Big Island await at this 3-bedroom, 2-bath vacation rental bungalow overlooking the sea. This house is the perfect launching point for all your Hawaiian ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Bob and Meri's Condominium, on the Big Island of Hawaii, is part of the Keauhou Gardens I complex located in the Kona Coast Resort. Our condo is a two level townhome of 2000 sq ft having three bedrooms and three baths. There two lanais with ...
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Kailua-Kona
Experience the best of Hawaii in this luxury 5,600 sq ft estate in the Mauna Lani resort area. Take a dip in the heated pool and hot tub (heated to your desired temperature), drink a beer in the billiards room, have an evening putting ...
5 bedroom
8 bathroom
Sleeps 14
Hawaii> Waimea
Newly renovated Two Bedroom Two Bath Condo with Full Ocean View in Center of Complex on 2nd Floor on the Kona Coast. Corner Unit
2 bedroom
2 bathroom
Sleeps 5
Hawaii> Kailua-Kona
Welcome to our "piece of paradise!" Our extremely comfortable unit is located in the quietest building in the Kona Coast Resort and looks out on to the 16th Fairway of Kona Country Club. Our updated 1 bedroom/1 bath condo is very spacious with ...
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Kailua
Aloha -
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Kailua Kona
Kona Coast Resort #2-201 is a beautifully maintained 2 bedroom, 2 bath condo that has all of the amazing amenities of a 5-Star Resort! You are able to enjoy the two Swimming Pools (one “family” pool with a children's pool and one quiet spa ...
2 bedroom
2 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Kona Coast Resort #8-204 is a beautifully maintained 2 bedroom, 2 bath condo that has all of the amazing amenities of a 5-Star Resort! You are able to enjoy the two Swimming Pools (one “family” pool with a children's pool and one quiet spa ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kailua Kona
2500 Square Foot Private and Spaciious Townhome. Sitting on the 16th Fairway of the Kona Country Club. Views of the ocean from Office and Stair Landing. High quality 600TC linens. Large and expansive new (2010) master bathroom. Air ...
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Kailua Kona
Looking for long term renters over 3 months or longer! $2100/month
2 bedroom
1 bathroom
Sleeps 3
Hawaii> Kailua-Kona
Experience the allure of the Kona Coast with a stay at this remarkable 2-bedroom, 2-bathroom vacation rental condo. Infused with the spirit of aloha, this home offers both comfort and convenience. Decorated with care, it can comfortably ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kailua Kona
Feel the peaceful trade winds blowing off the beautiful Pacific Ocean as you come home to this stunning 3-bedroom townhome located in the renowned Kona Coast Resort. Tasteful island decor fills this spacious condo, which was just remodeled and ...
3 bedroom
3 bathroom
Sleeps 7
Hawaii> Kailua-Kona
Escape to a tranquil retreat on the Kona Coast, where breathtaking ocean and golf course views await you. This beautifully remodeled 1-bedroom, 2-bath condo at Keauhou Akahi overlooks the picturesque Kona Country Club and the expansive Pacific ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kailua Kona
Wake each morning to the serene sounds of the ocean kissing the shoreline when you stay at this 2-bedroom, 2-bathroom Kailua-Kona vacation rental townhome. From this oceanside space, world-class snorkeling, parasailing, and whale watching are ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kailua-Kona
Renew your spirits with sand between your toes and a salty ocean breeze when you stay at this sunny 3-bedroom, 2-bathroom vacation rental in Kailua-Kona! Spend the day in Historic Kailua Village visiting the historic sites, shops, and ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Kailua-Kona
TA: 201-601-6896-01
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Kailua Kona
Escape the hustle and bustle of daily life at this welcoming 1-bedroom, 1-bathroom vacation rental in Kailua-Kona! Sip local coffee out on the lanai while you book a tee time at Makalei Golf Club, which is just over a mile away. Be sure to stop ...
2 bedroom
1 bathroom
Sleeps 2
Hawaii> Kailua-Kona
Kona Coast Resort's unit 10-104 is a spacious, 1,100 square foot one-bedroom, one-bathroom condo that exudes a traditional Hawaiian ambiance. This unit boasts a fully equipped kitchen, a washer/dryer, and a private lanai with an ocean view. The ...
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Kailua Kona
Keauhou Gardens 11-101 is a spacious one bedroom/one bath unit located in the Keauhou Gardens section of the Kona Coast Resort situated on 21 acres of beautifully landscaped tropical Gardens.
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Kailua-Kona
We know you'll just love this cozy guest apartment. We've been told it feels like a rather sophisticated tree house. Pretty rooms and comfy beds. Just a quick drive to the beach and activities, but none of the hustle-bustle or crowds. The ...
3 bedroom
1 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Keauhou Gardens 5-204 is a spacious three bedroom/two bath condo located in the Keauhou Gardens section of the Kona Coast Resort situated on 20+ acres of tropical landscaped Gardens and the beautiful Kona Coast Golf Course.
3 bedroom
2 bathroom
Sleeps 8
Hawaii> Kailua-Kona
SPACIOUS 1200sq. ft. 1bedroom/1bath Villa is beautiful, fully furnished and in a QUIET location in the Resort. This resort has everything you need-Pools, Tennis, Fitness, Restaurant, Sauna, jacuzzi's, volleyball, list goes on and ...
1 bedroom
1 bathroom
Sleeps 6
Hawaii> Kona
Plan an island getaway at this 1-bedroom, 2-bathroom vacation rental. This open-air Kailua-Kona home is a private tropical paradise, with a fenced yard, outdoor pool, and stunning views of the nearby Kona Coast framed by sprawling windows. Grab ...
3 bedroom
2 bathroom
Sleeps 2
Hawaii> Kailua-Kona
Your adventure to the Kona Coast starts at this oceanfront Big Island property, just steps away from the sun, sand, and surf. Guests will enjoy spectacular dining options, including a waterfront restaurant and poolside bar. The on-site spa and ...
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Kailua-Kona
Your adventure to the Kona Coast starts at this oceanfront Big Island property, just steps away from the sun, sand, and surf. Guests will enjoy spectacular dining options, including a waterfront restaurant and poolside bar. The on-site spa and ...
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Kailua-Kona
Your adventure to the Kona Coast starts at this oceanfront Big Island property, just steps away from the sun, sand, and surf. Guests will enjoy spectacular dining options, including a waterfront restaurant and poolside bar. The on-site spa and ...
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Kailua-Kona
Your adventure to the Kona Coast starts at this oceanfront Big Island property, just steps away from the sun, sand, and surf. Guests will enjoy spectacular dining options, including a waterfront restaurant and poolside bar. The on-site spa and ...
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Kailua-Kona
Your adventure to the Kona Coast starts at this oceanfront Big Island property, just steps away from the sun, sand, and surf. Guests will enjoy spectacular dining options, including a waterfront restaurant and poolside bar. The on-site spa and ...
2 bedroom
2 bathroom
Sleeps 8
Hawaii> Kailua-Kona
Your adventure to the Kona Coast starts at this oceanfront Big Island property, just steps away from the sun, sand, and surf. Guests will enjoy spectacular dining options, including a waterfront restaurant and poolside bar. The on-site spa and ...
2 bedroom
2 bathroom
Sleeps 8
Hawaii> Kailua-Kona
Your adventure to the Kona Coast starts at this oceanfront Big Island property, just steps away from the sun, sand, and surf. Guests will enjoy spectacular dining options, including a waterfront restaurant and poolside bar. The on-site spa and ...
3 bedroom
3 bathroom
Sleeps 12
Hawaii> Kailua-Kona
When you stay at Wyndham Kona Coast Resort in Kailua-Kona on the Big Island's west coast, you will feel as if you are stepping back in time to a more simple, unspoiled era. Every detail has been designed to re-create the charming traditional ...
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Kailua-Kona
Your adventure to the Kona Coast starts at this oceanfront Big Island property, just steps away from the sun, sand, and surf. Guests will enjoy spectacular dining options, including a waterfront restaurant and poolside bar. The on-site spa and ...
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Kailua-Kona
Featuring a private balcony, this one-bedroom villa features a fully equipped kitchen, dining room, living room with a TV and DVD player, and in-room laundry facilities. The private bathroom includes a hairdryer and ironing ...
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Kailua-Kona
Summary:
9 bedroom
6 bathroom
Sleeps 18
Hawaii> Kailua-Kona
Summary:
6 bedroom
6 bathroom
Sleeps 18
Hawaii> Kailua-Kona
Discover this lovely 2-bedroom gem in Kailua-Kona. This cozy condo features 1 king bed, 1 sofa bed, and 1 twin bed, perfect for a small group of guests. With amenities like a fitness room, WiFi, and a washing machine, your stay will be enjoyable...
2 bedroom
2 bathroom
Sleeps 6
Hawaii> Kailua-Kona
