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
Settle into your lovely 2 bedroom villa, one with king sized bed with cable TV, Blu-Ray DVD, Playstation, and bathroom with tub and shower. The second bedroom is furnished with two queen or double beds, and the same amenities and private ...
2 bedroom
3 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Beautiful oceanfront property featuring a private gated home with two additional separate king Bedroom Suites, each with private entrances. Enjoy unobstructed ocean views of the Pacific Ocean, Kona Coast, and Kahalu'u Beach with stunning ...
4 bedroom
4 bathroom
Sleeps 8
Hawaii> Kailua Kona
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 Wifi equipped Ceiling Fans Portable Air Conditioner in living room Enjoy Dophins spinning and whale ...
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 Kona
Aloha - Our "home away from home" has all the comforts of home with ocean views that are endless. This specatular top floor end unit is a spacious 1 bedroom/1 bath 1453 sq ft Island-style villa. Kona Coast Resort unit 1-304 is located at the...
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
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 Comfortable modern downstairs vacation apartment -SLEEPS: 2 Adults with garden views and its own entrance. Fully furnished with queen bed (sleeps 2 adults) kitchen table...
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 peaceful retreat on the Kona Coast, where breathtaking ocean and golf course views await. This beautifully remodeled 1-bedroom, 2-bath condo at Keauhou Akahi overlooks the stunning Kona Country Club and the vast Pacific Ocean. The ...
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 TMK: 750200070024 Experience your Hawaiian vacation at Casa de Emdeko, known for being the Crown Jewel of the Kona Coast. Relax in the pool or the saltwater pool nearby, lounge in the chairs at our oceanfront ...
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
Turn moments into memories in this lovely two-bedroom, two-bath, Royal Sea Cliff property. This unit has plenty of room for all your guests and a great Hawaii vibe. Soak up garden views, central air conditioning, and enjoy the amenities this ...
2 bedroom
2 bathroom
Sleeps 4
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. Keauhou Gardens 11-101 is a privately owned ...
2 bedroom
1 bathroom
Sleeps 4
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
Brand new listing!!! Get the discount while you can! Kona Coast Resort #1-301 is a 3 bedroom, 2 bath condo with fantastic ocean views and all of the amazing amenities of a 5-Star Resort! Enjoy two swimming pools, three spas, a ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Unknown