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 (`address` like '%3200 Wailea Alanui Dr%' ) order by rating desc LIMIT 0, 15
Ground Floor 1200 Square Foot Condo With Large Lanai Facing Private Greenbelt. 2 Bedroom 2 Bath Condo Sleeps 6 (pull out sofa bed) in a very ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Kihei
End Unit on Second Floor End Unit Gives You Maximum Privacy - 1200 Square Foot Condo With Large Lanai Facing Private Greenbelt and View of Water ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Kihei
If you are looking for the a slice of paradise, this condo is it!
This approximately 1200 sq. ft. top floor, non-smoking unit is beautifully ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Maui
Elegant, romantic, family-friendly, spacious inside and out villa-style condo retreat on spread-out sloping grounds with large manicured ...
-
1
bedroom
-
2
bathroom
-
Sleeps 4
HI>
Kihei
The fabulous Keawakapu Beach is just a short 10 min stroll. The Palms at Wailea is a gorgeous property with a large pool and hot tub. A ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Kihei
Hawaii Tax ID: TA-058-717-5936-01
QUIET PRIVACY IN PARADISE - BEAUTIFUL GARDEN/OCEAN VIEWS
The Palms #902 is a luxurious one-bedroom two-bath...
-
1
bedroom
-
2
bathroom
-
Sleeps 4
HI>
Kihei
In sunny Wailea, a short stroll to some of south Maui's most incredible sand beaches, you will find our WAILEA TREASURE! Close proximity to all ...
-
2
bedroom
-
2
bathroom
-
Sleeps 4
HI>
Kihei
The Palms at Wailea condo complex is one of the most elegant developments in the exclusive and breathtaking resort community of Wailea, Maui. Our...
-
1
bedroom
-
2
bathroom
-
Sleeps 2
HI>
Kihei
This beautiful 2 bedroom, 2 bath luxury condo is located in the desirable Maui town of Wailea. Within walking distance to one of Maui’s most ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Kihei
Hawaii Tax ID: 2-2-1-008-082-0018-000 AMAZING 2 BEDROOM 2 BATH CONDO IN POPULAR PALMS AT WAILEA. SLEEPS UP TO 6 PERSONS. Largest 2 bedroom in ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Maui
APARTMENTS NEW FEATURES INCLUDE:
- THIS EXCITING NEW RENOVATION IS COMPLETED!! GORGEOUS CHARCOAL GRAY BAMBOO FLOORS THROUGHOUT AND AQUA...
-
1
bedroom
-
2
bathroom
-
Sleeps 4
HI>
Kihei
Please read FULL description before booking-->
Condo 1506. This 2 bedroom 2 bath is perfect for your stay on Maui. Enjoy the sweeping ocean ...
-
2
bedroom
-
2
bathroom
-
Sleeps 4
HI>
Kihei
Modern Luxury! Complete remodel in 2018--featured on A&E home show Vacation Rental Potential.
This luxurious, modern retreat at The Palms at ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Kihei
One of the finest vacation rentals in all of Maui, this condo is located on the coveted inner courtyard of the famous Palms at Wailea. Brand new...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Kihei
Stunning 30 K Recent Reno and Redecoration for a Hawaiian Beach Vibe. Wailea is one of the most sought after resort addresses on Maui. Here you ...
-
1
bedroom
-
2
bathroom
-
Sleeps 4
HI>
Wailea
