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 Islander Inn%') AND sleeps>=1 order by rating desc LIMIT 0, 20
COMPLETELY REMODELED - DOWNTOWN, YOUR OWN PERSONAL TOUR
If you are Looking for the Perfect Condo in the Perfect Location then you have found it as this is it and You Will Love it.
New Kitchen Cabinets & Countertops, FULL ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua-Kona
Aloha, welcome to our amazing ground floor, garden view condo, in the heart of Kona town close to EVERYTHING! We have finished up with a complete remodel last year. It is all fresh and new just for you to enjoy. We live on island and would like...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua-Kona
COMPLETELY REMODELED - DOWNTOWN, TAKE A LOOK, YOU WILL WANT TO STAY HERE, IT HAS A QUEEN SIZE MURPHY BED, KITCHENETTE WITH INDUCTION COOKTOP, FULL SIZE MICROWAVE, FULL FRIDGE, ALL OF THE COOKING ITEMS YOU WILL EVER NEED AND MORE, SEPARATE ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua-Kona
COMPLETELY REMODELED - DOWNTOWN, TAKE A LOOK, YOU WILL WANT TO STAY HERE, HAS QUEEN SIZE MURPHY BED.KITCHENETTE WITH INDUCTION COOKTOP, FULL SIZE MICROWAVE, FULL FRIDGE, ALL OF THE COOKING ITEMS YOU WILL EVER NEED AND MORE, FULL SEPARATE ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua-Kona
TROPICALLY COMPLETELY REMODELED - DOWNTOWN, TAKE A LOOK, YOU WILL WANT TO STAY HERE, HAS QUEEN SIZE MURPHY BED, KITCHENETTE WITH INDUCTION COOKTOP, FULL SIZE MICROWAVE, FULL FRIDGE, ALL OF THE COOKING ITEMS YOU WILL EVER NEED AND MORE, ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua-Kona
Leave your worries on the mainland while enjoying a relaxing getaway at this cozy studio in Kailua-Kona. Situated downtown in the Kona Islander Inn, this efficient vacation rental gives guests access to a shared pool and hot tub for hot days and...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
NAUTICAL THEMED UNIQUE CONDO HAS BEEN COMPLETELY REMODELED - DOWNTOWN, TAKE A LOOK, YOU WILL WANT TO STAY HERE, HAS QUEEN SIZE MURPHY BED, KITCHENETTE WITH INDUCTION COOKTOP, FULL SIZE MICROWAVE, FULL SIZE FRIDGE, ALL OF THE COOKING ITEMS YOU ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua-Kona
