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 '%Puunoa%') AND sleeps>=1 order by rating desc LIMIT 0, 15
The two bedroom, two bathroom oceanfront villas are what Hawaiian dreams are made of. Over 1,700-square feet of living space boasts lavish designer features, elegant furnishings, and a fully equipped gourmet kitchen ready for delicious ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Discover your perfect slice of Maui paradise within the gated grounds of the exclusive Puunoa Beach Estate. Your second floor, two-bedroom residence offers stunning views of the Pacific Ocean, plus the neighboring islands of Lanai and Molokai ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
The Maui villa and beach house rentals of Puunoa Beach Estates offer ultra-luxurious design details and furnishings, lavish space, the privacy of a gated enclave, and a location within a stroll of Lahaina Town.
Here your Maui vacation rental ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Lahaina
The two bedroom, two bathroom oceanfront villas are what Hawaiian dreams are made of. Over 1,700-square feet of living space boasts lavish designer features, elegant furnishings, and a fully equipped gourmet kitchen ready for delicious ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
