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 '%Hoyochi Nikko%') AND sleeps>=1 order by rating desc LIMIT 0, 20
After visiting Hoyochi Nikko for 20 years we decided to purchase our own piece of paradise in this ocean front ground floor beauty. Hoyochi Nikko is a small 18 unit complex, so you do not have the large crowds that Hotels and Larger complexes ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
What if you could walk into one of those “old school” postcards of the Hawaiian Islands? Well, you can at Hoyochi Nikko Unit 108! Step back in time to the 1940’s, with a one-of-a-kind slice of paradise. Our unit features romantic Hawaiiana...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Napili-Honokowai
