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 (`propertyName` like '%Islander%') AND sleeps>=1 order by rating desc LIMIT 0, 15
"Surf's Up!" at Islander on the Beach
New to Our Rental Program! Newly Decorated for Your enjoyment!
Gorgeous Ocean Front View!
"Surf's Up!" at Island on the Beach 327 has GOOD VIBES. From the moment you step into this prime, third floor ...
0 bedroom
1 bathroom
Sleeps 2
HI> Kapaa
2 Bedroom Oceanview Grand Islander (2 Bed/2 Bath Ocean View) Waikiki Beach – Hilton HGVC
Hilton Hawaiian Village
Grand Islander by Hilton Grand Vacations Club gives guests ideal access to the best stretch of Waikiki's famous white-sand beach...
2 bedroom
2 bathroom
Sleeps 6
HI> Honolulu
Islander on the Beach 155
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
You'll love staying at this beautiful condo where you're always steps away from ...
0 bedroom
1 bathroom
Sleeps 4
HI> Kapaa
Fun and Affordable studio right in the village of Kona! Kid friendly too!
Kona Islander Inn Hotel units offer private lanais (decks), color TVs and air conditioning. One queen bed and one sofa bed to allow for a total of 4 people.
Our Hotel ...
0 bedroom
1 bathroom
Sleeps 4
HI> Kailua Kona
2 Bedroom Oceanview Grand Islander (2 Bed/2 Bath Ocean View) Waikiki Beach – Hilton HGVC
Hilton Hawaiian Village
Grand Islander by Hilton Grand Vacations Club gives guests ideal access to the best stretch of Waikiki's famous white-sand beach...
2 bedroom
2 bathroom
Sleeps 6
HI> Honolulu
Islander on the Beach 257
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
With partial ocean views from the furnished private balcony, this lovely ...
0 bedroom
1 bathroom
Sleeps 4
HI> Kapaa
Unit IOB 308 is on the Third Floor in the Lobby Building with Ocean Views
1 Bedroom on 3rd Floor with Sweeping Views and Large Lanai
King Size Bed with Queen Sofa Sleeper
Kitchen with Built In Cook Top and Microwave
Counter Height Refrigerator...
1 bedroom
1 bathroom
Sleeps 4
HI> Kapaa
Located on the Second Floor in the Lanai Building with Ocean and Pool Views
Beautiful Views of the Ocean, Pool and Tropical Grounds
The unit is in the Lanai building with gorgeous pool and ocean views. Just 50 steps to the beach or 20 steps to...
0 bedroom
1 bathroom
Sleeps 3
HI> Kapaa
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
COVID-19 Update: We offer full refunds if Kauai reinstates a travel ban on incoming visitors. For current Kauai county travel restrictions please refer to their website: https://www.kauai.gov/covid-19
Aloha and welcome to our Kauai island ...
0 bedroom
1 bathroom
Sleeps 3
HI> Kapaa
Unit IOB 250 is on the Second Floor, Located in the Niihau Building and is Ocean Front
Unobstructed Direct Oceanfront Unit for Gorgeous Ocean Views on the Second Floor
*California King Size Bed
*Relax in the Two Lounge Chairs and Ottoman
*Mini...
0 bedroom
1 bathroom
Sleeps 2
HI> Kapaa
COVID-19 Update: We offer full refunds if Kauai reinstates a travel ban on incoming visitors. For current Kauai county travel restrictions please refer to their website: https://www.kauai.gov/covid-19
Aloha and welcome to our Kauai island ...
0 bedroom
1 bathroom
Sleeps 3
HI> Kapaa
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
COVID-19 -
During this time of the pandemic, anyone needing to cancel a reservation because of Government Travel Restrictions, Quarantines, Flight Cancellations, and pre-travel positive test (medically documented by the testing agency) directly...
0 bedroom
1 bathroom
Sleeps 4
HI> Kapaa
COVID-19 Update: We offer full refunds if Kauai reinstates a travel ban on incoming visitors. For current Kauai county travel restrictions please refer to their website: https://www.kauai.gov/covid-19
Aloha and welcome to our Kauai island ...
0 bedroom
1 bathroom
Sleeps 2
HI> Kapaa