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, 50
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
Hoyochi Nikko 202
This two-bedroom unit features a master bedroom on the main level with a king-size bed and a spiral staircase leading to a large lofted second bedroom with a queen-size bed. The unit is tastefully decorated with many ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Lahaina
