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 (`address` like '%68-1118 N Kaniku Dr%' ) order by rating desc LIMIT 0, 15
Welcome and aloha to Hale Papa Kea at Kulalani, a beautiful, fully furnished and professionally decorated 2 bedroom, 2 ½ bathroom townhouse with...
-
2
bedroom
-
3
bathroom
-
Sleeps 4
HI>
Kamuela
FOR A LIMITED TIME WE ARE INCLUDING A $100 GIFT CARD TO LAVA LAVA BEACH CLUB ON EVERY NEW RESERVATION MADE FROM JUN 10, 2019
KULALANI 501 - ...
-
2
bedroom
-
3
bathroom
-
Sleeps 4
HI>
Waimea
❤️PiH❤️ brought to you by Paradise in Hawaii Luxury Homes
Welcome to Seashell Villa at Kulalani on the Big Island of Hawaii.
Welcome to...
-
3
bedroom
-
3
bathroom
-
Sleeps 8
HI>
Kamuela
❤️PiH❤️ brought to you by Paradise in Hawaii Luxury Homes
Welcome to the newest home in our Hawaiian Luxury Collection.
Island Hideaway...
-
2
bedroom
-
3
bathroom
-
Sleeps 6
HI>
Kamuela
Welcome to Kulalani @ Mauna Lani! This resort area abounds with beautiful beaches with easy access for swimming, snorkeling & scuba-diving; ...
-
2
bedroom
-
3
bathroom
-
Sleeps 4
HI>
Waimea
❤️PiH❤️ brought to you by Paradise in Hawaii Luxury Homes
Welcome to Inspiration Villa at Kulalauni on the Big Island of Hawaii.
This ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Kamuela
In a private gated community with designer furniture, luxurious bedding, and a kitchen all professionally decorated with a contemporary tropical ...
-
2
bedroom
-
3
bathroom
-
Sleeps 6
HI>
Waimea
❤️PiH❤️ brought to you by Paradise in Hawaii Luxury Homes
Welcome to Island Time Villa, a part of our Hawaiian Luxury Collection.
This ...
-
3
bedroom
-
3
bathroom
-
Sleeps 6
HI>
Kamuela
❤️PiH❤️ Sweet Heaven Villa brought to you by Paradise in Hawaii Luxury Homes
Welcome to the newest home in our Hawaiian Luxury ...
-
4
bedroom
-
4
bathroom
-
Sleeps 10
HI>
Kamuela
❤️PiH❤️ brought to you by Paradise in Hawaii Luxury Homes
Welcome to Starfish House, a part of our Hawaiian Luxury Collection. The ...
-
3
bedroom
-
3
bathroom
-
Sleeps 8
HI>
Kamuela
❤️PiH❤️ brought to you by Paradise in Hawaii Luxury Homes
Welcome to Hawaiiana Escape at Kulalani on the Big Island of Hawaii.
Welcome ...
-
3
bedroom
-
3
bathroom
-
Sleeps 8
HI>
Kamuela
❤️PiH❤️ brought to you by Paradise in Hawaii Luxury Homes
Welcome to Tranquility Villa at Kulalani on the Big Island of Hawaii
This ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Kamuela
❤️PiH❤️ brought to you by Paradise in Hawaii Luxury Homes.
Welcome to Paradise Found Villa, a part of our Hawaiian Luxury Collection. ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Kamuela
This SOPHISTICATED TWO MASTER SUITE, 2 ½ BATH TOWNHOME is perfectly situated for privacy within the Kulalani Resort at Mauna Lani and features ...
-
2
bedroom
-
3
bathroom
-
Sleeps 4
HI>
Waimea
Find outdoor living at its finest at the 2-bedroom, 2.5-bath Kulalani 104 at Mauna Lani. Several spacious, private lanais offer lush tropical ...
-
2
bedroom
-
3
bathroom
-
Sleeps 4
HI>
Kamuela
