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 '%Koa Resort%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Welcome to your Maui home away from home, located in the desirable Koa Resort complex with just a short walk to the gorgeous beaches of South Maui. Unit 4B is a spacious ground floor fully furnished two bedroom one bathroom vacation rental ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
HI> Kihei
CHECK OUT OUR VIDEO ABOVE FOR FULL DETAILS! Just scroll and click on the pictures above to find it.
BOOK WITH CONFIDENCE. Let's face it. There are hundreds of options in Maui to book your next vacation. And you want to make sure it's right....
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Kihei
Aloha and welcome to our Maui vacation home.
The first floor location is convenient and offers a private garden setting from the lanai. The two bedroom one bath condo has been updated with all new appliances and furnishings. The master ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
A rare low-density complex (only 54 units) on 5 acres of lush well manicured grounds with the largest private heated pool on Maui and the ocean that awaits you across the street! Fully air conditioned! The complex boasts private tennis courts,...
- 2 bedroom
- 1 bathroom
- Sleeps 6
HI> Kihei
Remodeled November 2018!!
This spacious townhome is beautifully appointed with all new furniture and bedding throughout. California King Beds and Flat screen TVs are featured in 3 of the 4 bedrooms. The 4th bedroom, an airy loft, features two...
- 4 bedroom
- 3 bathroom
- Sleeps 8
HI> Kihei
This large 3 bedroom, 2 bath condo is great for up to 6 people. Featuring a full kitchen with granite and island, there is also a dining for 6 both inside and out. The lanai overlooks the gardens and pool area. Bedrooms include a king bed, a ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Summary:
Aloha!
My family and I live on Maui and we are so excited to host your vacation. Don't get stuck with a major rental company that doesn't care about your individual group. We take pride in providing personal touches and making sure ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
HI> Kihei
A beautiful tropical garden setting awaits you from this first floor location. The one bedroom one bath apartment is upgraded and updated . New Air Conditioning throughout the apartment! It has a spacious living/dining/kitchen area. The ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
This 4-bedroom, 3-bath ground-floor end unit is tropically decorated "Island Style" and is available for your Maui vacation! This spacious condo is conveniently located just 40 feet from the entrance to the swimming pool and hot tub. Koa Resort ...
- 4 bedroom
- 3 bathroom
- Sleeps 10
HI> Kihei
A rare find! Three bedrooms and three baths and two levels make for plenty of space in this apartment. The first floor has a master bedroom-bath suite with a king bed; the second bedroom has two twin beds, and there is a kitchen and dining ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Kihei
Summary:
Aloha and welcome to our 3 bedroom condo, your home away from home! My family and I live on Maui and we are so excited to host your vacation. Don't get stuck with a major rental company that doesn't care about your individual group. We ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
HI> Kihei
Summary:
Aloha!
My family and I live on Maui and we are so excited to host your vacation. Don't get stuck with a major rental company that doesn't care about your individual group. We take pride in providing personal touches and making sure ...
- 0 bedroom
- 2 bathroom
- Sleeps 8
HI> Kihei
This large 2 bedroom, 1 bath ground-floor townhome is beautifully decorated in Hawaiian style decor. There is a Queen bed in the downstairs bedroom, Queen in the second bedroom and one full bath. With 850 square feet of living space, guests ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
HI> Kihei
When you stay at Koa Resort 5H, you'll see firsthand why Kihei was once so popular with Hawaiian royalty! Featuring six miles of beaches with spectacular views, Kihei offers endless opportunities for swimming, surfing, snorkeling and kayaking ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> Kihei
** Brand New To Our Rental Inventory - Virtual Tour Coming Soon **
Private 2nd floor unit and loft at the Koa Resort - directly across the street from Kalepolepo Beach Park in Kihei. Main floor includes a spacious living room, full kitchen with...
- 3 bedroom
- 2 bathroom
- Sleeps 8
HI> Kihei
