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, rewritten_description,
(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, 50
**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
- 0 bedroom
- 1 bathroom
- Sleeps 2
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
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua-Kona
Welcome to the Kona Islander Inn—your tranquil home away from home in the heart of Kailua-Kona. This charming studio offers a private lanai with serene views of the pool, creating a peaceful escape amid the island’s vibrant coastal
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua-Kona
Experience the convenience of being close to popular beaches, shops, restaurants, and historic landmarks with this delightful and cozy retreat. Ideal for explorers and relaxers alike, it is your perfect base for memorable adventures and
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua-Kona
Welcome to "Breezy Palms" your charming remodeled studio in the heart of downtown Kailua-Kona! This stylish and modern retreat offers the perfect blend of comfort and convenience, making it an ideal getaway for your Hawaiian vacation. Just steps
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> KAILUA KONA
