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 '%Polo Beach Club%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Location, location, location…. Polo Beach is the premiere condominium that sits at the south end of the Wailea Beach walk, next to the Fairmont Kei Lani resort. Our unit is on the sunny south side of the building, overlooking the pool area and...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Wailea
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, we will be exchanging bath towels and amenities every three days and performing a traditional ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Makena, Maui
Welcome to our little piece of paradise! We were so excited to be able to purchase our condo a few years back and are now ready to share it with guests. Polo Beach Club is truly a magical place, a hidden gem that sits at the south end of the ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Kihei
Polo Beach Club is an exclusive beachfront complex on one of Wailea's best swimming beaches, next to the Fairmont Kea Lani. The famous oceanfront walkway begins at Polo Beach and fronts the most prestigious resort hotels in Maui. Polo Beach Club...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
A gem in paradise!
Listen to the soothing sounds of the waves- nearly impossible to get closer to the beach in an oceanfront condominium! Great swimming, snorkelling and opportunity to spot turtles and whales at Polo Beach located just steps ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Polo #406 is a beautiful, comfortable unit overlooking the ocean. It offers breathtaking views of Molokini, West Maui, Kahoolawe, and Lanai. The unobstructed sunsets are absolutely stunning!
While staying at the Polo Beach Club, guests are ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea-Makena
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, we will be exchanging bath towels and amenities every three days and performing a traditional ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Makena, Maui
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, we will be exchanging bath towels and amenities every three days and performing a traditional ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Makena, Maui