select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
Steps to ocean, updated cozy and bright condo on ground floor single story with beautiful ocean views. Walk out and relax in your private lanai to watch stunning Hawaiian sunsets. Completely renovated kitchen with new appliances and new paint ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Kailua-Kona
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
This renovated ocean view 1 bedroom condo is located at the water's edge in scenic Kailua-Kona! The complex is beautifully ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua Kona
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
Desirable ground floor unit located just steps away from the pools, the ocean front lounge area and BBQ's. Kona Isle B5 is nicely ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua Kona
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
Very nice unit! One bedroom, one bathroom offer a nice partial ocean view. Super stocked everything, with high end linens and towels....
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua Kona
E23 at the Kona Isle is a beautiful DIRECT OCEANFRONT property on the 2nd floor of building E!
These units are in high demand! Feel the ocean breezes come into your living room in this gorgeous 1 bedroom, 1 bath condo. The sofa does pull out to...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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
HI> Kailua-Kona
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
This unit is VERY peaceful! The waves crashing on the rocks pretty much drowns out any ambient noise in the other units and the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua Kona
Kona Isle C-28 is a fantastic new addition to Knutson & Associates Property Management as of January 2019! We're proud to represent this wonderful second floor, corner end unit in highly desirable Building C at the Kona Isle!
These second ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua Kona
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
E Komo Mai! We invite you to enjoy our little piece of paradise, which has been tastefully decorated in tropical decor and fully ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Kailua Kona
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
This updated condo is complete with tiled entry, marble countertops and completely furnished for your Hawaiian vacation! Living area...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua Kona
A4 at the Kona Isle is undeniably one of the BEST valued property in the complex.
Owners upgraded Cooktop, All Flooring, Linens, Bed, Doors, Fans, so many great things in December 2021!
Beautifully appointed, AC units in the bedroom, and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua-Kona
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
Kona Isle is a beautiful oceanfront condominium unit has been designed with tropical tastes in mind with comfortable furnishings and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua Kona
B31 at the Kona Isle is an amazing top floor condo in building B at the Kona Isle. This corner unit has had considerable upgrades made by the home owners in July 2021 that include: All New Furniture, Vinyl Plank Flooring throughout-No more ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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 in the...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua Kona