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 Islander Inn%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Well-appointed studio unit in the Kona Islander Inn. Beautiful tile flooring with a mixture of modern and island themed décor create the perfect setting for your island getaway.
The comfortable king-sized bed sits atop a custom-built platform ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Kailua-Kona
My wife and I spent several years going to this condo as our vacation get away, and were finally able to buy it. We feel that the location is the best in the Kona Islander Inn complex, and the view is wonderful. We have spent lots of time ...
- 0 bedroom
- 1 bathroom
- Sleeps 3
HI> Kailua-Kona
Aloha, welcome to our amazing ground floor, garden view condo, in the heart of Kona town close to EVERYTHING! We have just finished up with a complete remodel. It is all fresh and new just for you to enjoy. We live on island and would like to ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kailua-Kona
Well-appointed studio unit in the Kona Islander Inn. Beautiful tile flooring with a mixture of modern and island themed decor create the perfect setting for your island getaway.
The comfortable king-sized bed sits atop a custom-built platform ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kailua-Kona
This lovely studio unit is in an ideal locale for your Big Island Vacation. The Kona Islander Inn's central location puts you within walking distance to all of the restaurants, shopping and more. The inn opens up directly onto Alii Drive, the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua-Kona
PLEASE SEND AN INQUIRY BY CLICKING THE CONTACT HOST TAB BEFORE REQUESTING TO BOOK!
The Kona Islander is quaint with the nostalgic atmosphere of a country inn. rooms at the Kona Islander Inn Hotel include a kitchenette fully equipped with tea ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua-Kona
