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 (`headline` like '%Spinnaker%') AND sleeps>=1 order by rating desc LIMIT 0, 15
***** iTrip Vacations Maui takes pride in providing sparkling clean properties. Therefore, we have enhanced our already stringent cleaning protocols between guests. We are following CDC guidelines for cleaning and disinfecting and are using the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Spinnaker A206 is a quiet and serene condominium resort. This comfortable one bedroom, one bath condo is located about 5 minutes away from the world famous Banyan Tree and Lahaina's epicenter. Front Street Dining and shopping abound in this ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
