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 = 'kihei' OR postalCode = 'kihei' OR region like '%|kihei|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Walk out of your condo and onto Maui's longest beach - direct access to serene Sugar Beach. No stairs or elevator to deal with.
Small, boutique atmosphere with RARE truly beachfront pool, deck and lawn.
If you are looking for the peace of ...
1 bedroom
1 bathroom
Sleeps 4
HI> Kihei
Enjoy a majestic Hawaiian getaway during your stay at this 1-bedroom, 1-bathroom vacation rental condo in Kihei! Up to 6 guests can spend days with their toes in the sand at the beach just steps away, and their nights sipping cocktails by the ...
1 bedroom
1 bathroom
Sleeps 4
HI> Kihei
Blessed by Kaunas, Aloha Aku means the place that ‘gives love and kindness’. Formally known as Aikane Hale. The total number of guests shall be limited to up two (2) adult guests and up to two (2) minor guests per bedroom. As we are an ...
1 bedroom
1 bathroom
Sleeps 4
HI> Kihei
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
Ekahi means #1 in Hawaiian and this Maui luxury complex lives up to its name. Located in Wailea, Maui – the sunny side of the island – Ekahi Village sits on 34 acres of lush Hawaiian landscape and 1.5 mile long Keawakapu Beach.
Take ...
1 bedroom
1 bathroom
Sleeps 2
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
This super-modern ground floor condo has been completely remodeled for your comfort and style. Kitchen has beautiful wood cabinets with granite counter tops for easy clean-up. Granite top is used as a dining set with tall comfortable rattan ...
1 bedroom
1 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
This beautiful family-friendly oceanfront property is in N. Kihei, within steps to the pool and beaches. Lovely gardens with many on-site facilities incl. barbecue, exercise room, and 6 tennis courts. Has ocean and pool view from its private ...
1 bedroom
2 bathroom
Sleeps 5
HI> Kihei
****Outstanding Condo 37' LCD HDTV, iPod docking system, King Bed and free Wi-Fi + cable - Great Price for all of the amenities of Home + Great Location****
You are invited to stay in this beautiful, romantic condo in South Kihei, right next ...
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
Aloha and welcome to our retreat in Wailea, Maui, the heart of paradise. Your Hawaiian vacation will be nothing short of spectacular when you stay in Unit 1510, Palms of Wailea ocean view condo. There are many reasons our guests consider our ...
2 bedroom
2 bathroom
Sleeps 6
HI> Kihei
Ocean Views Forever – also overlooks beach. Unit just completely Upgraded and remodeled with high end materials, finishes and furniture. Master Bedroom has King Size Bed, spacious Master Bathroom and large flat screen TV. Downstairs Bedroom ...
2 bedroom
2 bathroom
Sleeps 6
HI> Kihei
Blessed by Kaunas, Aloha Aku means the place that ‘gives love and kindness’. Formally known as Aikane Hale.
To help keep our guests safe we are increasing sanitation procedures and will not be providing breakfast. We appreciate your ...
1 bedroom
1 bathroom
Sleeps 4
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
