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 '%Kamaole Sands%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Casual comforts and tropical décor prevail in this air-conditioned 818sf suite with its full kitchen for meal convenience. Savor pina coladas on the lanai while mapping out tomorrow’s agenda. Amenities include a washer/dryer, ceiling fans, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> KIHEI
You’ll love the view of majestic Haleakala from this air-conditioned 818sf vacation home near the pool. Enjoy a separate living area, private bedroom, furnished lanai, full kitchen for “at home” dining, ceiling fans, WiFi, washer/dryer, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> KIHEI
Overlooking coconut palms and a swimming pool, this air-conditioned 884sf retreat lets you vacation in casual comfort. Enjoy stylish hardwood floors, whimsical island art, a full kitchen, washer/dryer, furnished lanai, ceiling fans, flat screen ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> KIHEI
Placing a premium on privacy, this air-conditioned 1,102sf condo features a loft that’s perfect for families. Enjoy Haleakala views from the lanai while savoring meals prepped in the full kitchen. Other features include WiFi, ceiling fans and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> KIHEI
Aside from its sweeping views, Unit 5-307 offers all the comforts of home during your vacation. This 818 square foot rental features large flat screen TVs in the living room and bedroom, WiFi, air conditioning, washer/dryer, and a full kitchen ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> KIHEI
Open design invites Maui beauty to flow through floor-to-ceiling sliders between the private lanai and tile-floor living area. This 818sf air-conditioned suite appeals with homey touches like a kitchen for meal ease, flat screens, DVD, ceiling ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> KIHEI
Lush coconut palms off your furnished lanai merge with tropical artwork and décor in this air-conditioned 884sf suite with upgraded kitchen for preparing meals. Relax with homey conveniences including a washer/dryer, WiFi, ceiling fans, DVD and...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> KIHEI
Casual island living defines this 818sf ground floor suite cooled by ceiling fans and air conditioning. Following the weekly Mai Tai party, grill fresh mahi mahi to enjoy on your lanai. Conveniences include a full kitchen, DVD, flat screens, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> KIHEI
Island décor and an open, upgraded kitchen add appeal to this air-conditioned 1,102sf vacation home. Dine at the breakfast bar or on your lanai overlooking the courtyard with coconut palms and banana trees. Other touches include WiFi, ceiling ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> KIHEI
Embrace lush tropical splendor flowing from the lanai into the spacious living area and open design kitchen with stainless appliances. This high-style 818sf air-conditioned suite adds homey appeal with a washer/dryer, ceiling fans, WiFi, flat ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> KIHEI
You’ll love this 884sf tropical suite with lanai flowing onto beautiful lawns. Socialize while prepping nosh in the modern kitchen that opens to a living area with cool tile floors. Perks include WiFi, flat screens, AC, ceiling fans, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> KIHEI
Offered first time in 17 years for vacation rental! Ground Floor Stunning Ocean View Remodeled/Furnished, 2/2 from the Best location in Building 10! Unobstructed views from the Living room, Master bedroom (spectacular) and kitchen. Air ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailea-Makena
Open, airy design makes this 818sf air-conditioned suite ideal for reconnecting and bonding. Perks include a private bedroom, modern kitchen flowing into the living area, courtyard/pool view lanai, 2 upgraded baths, washer/dryer, flat screens, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> KIHEI
Toast epic sunsets on the lanai of this modern 1,200sf suite with Pacific view. Tropical style rolls out with a spiral staircase to loft and master bedrooms, modern kitchen flowing into the open living area, laundry, ceiling fans, AC, WiFi, flat...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> KIHEI
With so much to explore on the Valley Isle, there’s no beating the superior, central location of this vacation condo in Kamaole Sands. From the lush rainforests off the Hana Highway, to the spectacular, out-of-this-world landscape of Haleakala...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> KIHEI