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 (city = 'makena' OR postalCode = 'makena' OR region like '%|makena|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
State of Hawaii Transient Accommodations Tax License #TA-094-662-2464-02. County of Maui Short-Term Rental License #Hotel-Zoned. Tax Map Key #210070950035
Sunny Surf E301 is located on Maui island, ranked #1 Best Luxury Destination in the USA ...
3 bedroom
3 bathroom
Sleeps 6
HI> Makena
Located on Maui's southwest shore in the heart of beautiful Makena Bay, this single story oceanfront cottage is an island paradise. Built over 40 years ago and remodeled with vintage Hawaiian decor, guests are provided with all the modern ...
2 bedroom
2 bathroom
Sleeps 4
HI> Makena
Gorgeous home on quiet Old Makena Road with West-facing ocean views from every room.
Slip on your beach shoes, walk down your 40 foot dogleg to the left of your front lawn, step over small rocks, and swim with the turtles at our private ocean ...
3 bedroom
3 bathroom
Sleeps 6
HI> Makena
Welcome to Makena Surf B305! This unit is all about LOCATION and VIEWS! Makena is located a short five minute drive from all of the restaurants and shops in Wailea but offers the seclusion and privacy from all of the resort traffic! Makena Surf ...
2 bedroom
2 bathroom
Sleeps 4
HI> Makena
The Polo Beach condo's sleep 6 in total. Please call for very latest openings as there may be a new booking in progress. Polo Beach Club has both ocean front and Prime (on sand ) ocean front units.
On Beach, adjacent to many amenities (stores, ...
2 bedroom
2 bathroom
Sleeps 6
HI> Makena