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 (city = '96763' OR postalCode = '96763' OR region like '%|96763|%') AND sleeps>=1 order by rating desc LIMIT 0, 20
The Artists House, Permit # STLA 2017/0002 is a home away from home with the comfortable furnishings and great amenities. The fabulous Lana'i sunsets can be enjoyed outside on the deck where there is glass dining room table with 6 chairs and bbq...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lanai
Maui County Permit No. STLA 2016/0001
Step back into the charm of Old Hawaii in...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Lanai City
The island of Lana'i is suited for the return visitor who wants to experience a different part of Hawaii or for the first time traveler who wants to get away from the tourist crowds or Maui and Waikiki. A 4 wheel drive is recommended to fully ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Lanai City
The Island of Lanai is a true get away, known as “Hawaii’s Most Enticing Island”. It’s only nine miles from Maui yet feels like a world away. You can truly immerse yourself in the elegance and amenities the Island has to offer including ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Lanai
Spacious home on the island of Lanai. Footsteps from Four Seasons at Manele Bay Hotel and Hulopoe Beach. All the comforts of home in an island paradise. Two bedrooms, each with king-sized beds, and two and one half baths, including an outdoor ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Lanai City
