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 isle%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Steps to the ocean, updated cozy and bright condo on ground floor single story building with beautiful ocean views. Easy access from reserved parking space to your own paradise. Walk out and relax in your private lanai to watch stunning Hawaiian...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kailua-Kona
Direct oceanfront, ground level, recently remodeled D4 at Kona Isle. Enjoy beautiful ocean views and breezes. Steps to the beachfront area with lounge chairs to relax in. Or swim in the solar heated pool. BBQ grills and picnic tables make for ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kailua-Kona
*Recent upgrade: we added air conditioning to the bedroom which is in addition to the living room!
Aloha from Hale Malina! We invite you to enjoy our little piece of paradise, which has been recently updated to help you have a relaxing ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Updated kitchen and bathroom! Optional AC in living room only for an additional $25/night + tax! D2 at the Kona Isle is a beautiful DIRECT OCEANFRONT property on the 1st floor of building D! No stairs! Cook in the full kitchen or on the grill! ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Newly remodeled, easily accessible and desirable ground floor condo in the beautiful Kona Isle property. Located just steps away from a solar heated pool, ocean front lounge and BBQ area along the rocky shore. Where you can spend the day ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Looking for the best of the best at Kona Isle? Kona Isle#C38 is arguably one of the best units in the entire development. Top Floor West Corner of Building C, you've got INCREDIBLE OCEAN VIEWS! This unit is fully remodeled from Top to Bottom, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Welcome to your beach paradise! This stunning oceanfront vacation rental offers breathtaking views of the sparkling blue waters right from your doorstep. With a Newly beautifully remodeled kitchen completed in May 2024 that is sure to impress. ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kailua Kona
A4 at the Kona Isle is undeniably one of the BEST valued properties in the complex.
Upgraded Cooktop, All Flooring, Linens, Bed, Doors, Fans, so many great things!
Beautifully appointed, AC units in the bedroom, and living room, No ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Kona Isle C-28 is a fantastic addition to Knutson & Associates Property Management! We're proud to represent this wonderful second floor, corner end unit in highly desirable Building C at the Kona Isle!
These second floor units are truly...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
E-24 at the Kona Isle is a high in demand Direct Oceanfront Corner End Unit on the 2nd Floor of Building E. This gorgeous condominium has jaw dropping ocean & sunset views from your Lanai. Enjoy amazing ocean breezes that flow through this ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Kona Isle captures the very spirit that defines Hawaii with its beautiful tropical gardens, private beach,
and ever-present tropical ocean breezes. Come lounge under the palm trees and watch the dolphins
and whales at play, enjoy swimming ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
B31 at the Kona Isle is an amazing top floor condo in building B. This corner unit has had considerable upgrades made by the home owners that include: All New Furniture, Vinyl Plank Flooring throughout-No more carpet!, Quartz Countertops in ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Maximum occupancy strictly enforced in accordance with local ordinances.
“Somewhere over the rainbow” is right here! Aloha and welcome to this Kona Isle dream, a stunning condo on the Kona coast! This lovely home has access to complex...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kailua Kona
Kona Isle, Unit#B3 is a fantastic addition to Knutson & Associates Property Management! We're proud to represent this beautiful fully remodeled, ground floor unit.
Enjoy notable features to include: No Stairs, AC Unit in the Living Room, Open...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
