select * from (Select a.`postalCode`,a.`uniturl`, `region`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `source`, `property_type`, `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 and b.blocked=0 ) as vw where 1 and round(price)>0 and bedrooms>=0 AND (city = 'Kahului' OR postalCode = 'Kahului' OR region like '%|Kahului|%') AND sleeps>=1 order by rating desc LIMIT 0, 20
The wonders of Maui are all around us. From this point, you can easily access the incredible diversity of things to do and see, from the dramatic and varied landscapes of Haleakala to the waters of Honolua Bay, not to mention all the forests, ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kahului
The wonders of Maui are all around us. From this point, you can easily access the incredible diversity of things to do and see, from the dramatic and varied landscapes of Haleakala to the waters of Honolua Bay, not to mention all the forests, ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kahului
Cruise Maui in your own adventure SUV fully equipped for up to 3ppl to camp all over the island! We've thought of everything and packed it neatly into your Nissan Xterra (automatic trans). Cooking gear, sleeping gear incl. a super comfy memory ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kahului
Ready for a unique experience on Maui? Want to explore the entire island and stay over in the most remote and beautiful spots? Want to spend a fraction of the price of staying at a hotel/resort? You've found the best accommodation with Epic ...
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kahului
Epic Maui Camping sets our guests up to cruise Maui in your own adventure SUV fully equipped for up to 3ppl to camp all over the island! We've thought of everything and packed it neatly into your Nissan Xterra (automatic trans). Cooking gear, ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kahului
25 feet of unobstructed Kahului Harbor View! Watch whales from the sofa or your desk in this fully equipped one bedroom, one and ½ bath condo. High end finishes and top-of-the-line appliances give you a luxury experience in this centrally ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kahului
We are a licensed vacation rental:
STHA-2017/0002
TA-061-740-4416-01
GE-061-740-4416-01
Aloha & Welcome,
The Fisher's Hana Hale is located across the street from Hana Bay and Waikoloa Beach. Our guests enjoy the privacy...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahului
2015 DODGE RAM PROMASTER 2500 Diesel -HIGH TOP
‼️ ‼️‼️Attention to all customers!!!!! PLEASE PLAN AHEAD OF TIME !!!!
if you plan trip to Maui and rent a camper van, you MUST have a reservation with either Camp Olowalu or ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kahului
With an ideal seaside location and comfortable amenities, your Maui getaway is sure to be the perfect mix of relaxation and adventure! Start your day with breakfast at the on-site restaurant. Spend an afternoon on the sundeck at the refreshing ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahului
With an ideal seaside location and comfortable amenities, your Maui getaway is sure to be the perfect mix of relaxation and adventure! Start your day with breakfast at the on-site restaurant. Spend an afternoon on the sundeck at the refreshing ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahului
The wonders of Maui are all around us. From this point, you can easily access the incredible diversity of things to do and see, from the dramatic and varied landscapes of Haleakala to the waters of Honolua Bay, not to mention all the forests, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahului
The wonders of Maui are all around us. From this point, you can easily access the incredible diversity of things to do and see, from the dramatic and varied landscapes of Haleakala to the waters of Honolua Bay, not to mention all the forests, ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kahului
The wonders of Maui are all around us. From this point, you can easily access the incredible diversity of things to do and see, from the dramatic and varied landscapes of Haleakala to the waters of Honolua Bay, not to mention all the forests, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahului
The wonders of Maui are all around us. From this point, you can easily access the incredible diversity of things to do and see, from the dramatic and varied landscapes of Haleakala to the waters of Honolua Bay, not to mention all the forests, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahului
The wonders of Maui are all around us. From this point, you can easily access the incredible diversity of things to do and see, from the dramatic and varied landscapes of Haleakala to the waters of Honolua Bay, not to mention all the forests, ...
- 3 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Kahului
The wonders of Maui are all around us. From this point, you can easily access the incredible diversity of things to do and see, from the dramatic and varied landscapes of Haleakala to the waters of Honolua Bay, not to mention all the forests, ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kahului
The wonders of Maui are all around us. From this point, you can easily access the incredible diversity of things to do and see, from the dramatic and varied landscapes of Haleakala to the waters of Honolua Bay, not to mention all the forests, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahului
With an ideal seaside location and comfortable amenities, your Maui getaway is sure to be the perfect mix of relaxation and adventure! Start your day with breakfast at the on-site restaurant. Spend an afternoon on the sundeck at the refreshing ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahului
With an ideal seaside location and comfortable amenities, your Maui getaway is sure to be the perfect mix of relaxation and adventure! Start your day with breakfast at the on-site restaurant. Spend an afternoon on the sundeck at the refreshing ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kahului
With an ideal seaside location and comfortable amenities, your Maui getaway is sure to be the perfect mix of relaxation and adventure! Start your day with breakfast at the on-site restaurant. Spend an afternoon on the sundeck at the refreshing ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahului
