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 '%Hoolei%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Dramatic ocean views, this spacious town home is approximately 2500 sq ft of interior footage and 596 sq ft of lanai space. The Hoolei community is located directly across the street from the Four Seasons and the Grand Wailea Resort. Unit 31-2 ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Wailea-Makena
This property is hotel zoned, and not being affected by the recent proposed legislation.
Located in highly desirable secluded area of neighborhood your villa welcomes you with spacious floor plan and sweeping ocean views. Marvel at the ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Wailea
Welcome to Ho'olei 93-3 by Gather, a luxurious three-bedroom, three-and-a-half-bathroom condo nestled in the exclusive gated community directly across from Wailea Beach and the Grand Wailea Resort. Offered exclusively by the Stice Team, this ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Wailea
Welcome to Ho’olei Residence 23-3 (L3) by Gather, an exclusive offering by the Stice Team, nestled in an exclusive gated community directly across from Wailea Beach and the Grand Wailea Resort.
This luxury villa lives like a high-end ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Wailea
