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, ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
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
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
Fully Loaded 2022 Jeep Gladiator Rubicon with a Pop up tent! Our camper truck comes with all the amenities! Travel around the lush island of Maui and stay in a different part of the island every night!! Book your adventure today!! We provide ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
Fully Loaded 2022 Jeep Gladiator Rubicon with a Pop up tent! Our camper truck comes with all the amenities! Travel around the lush island of Maui and stay in a different part of the island every night!! Book your adventure today!! We provide ...
- 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
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
When it comes to comfort, convenience, and an aloha spirit - you found the right place to stay. Relax by the pool, indulge in our buffet dinner, and enjoy views out over Kahului Bay. All this is yours within 10 minutes of the airport, ...
- 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
When it comes to comfort, convenience, and an aloha spirit - you found the right place to stay. Relax by the pool, indulge in our buffet dinner, and enjoy views out over Kahului Bay. All this is yours within 10 minutes of the airport, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahului
NOTE: The safety and security of our Guests and Team Members has always been our priority.
We are taking additional precautionary measures to ensure our facilities are maintained to the highest standards and to do our part in reducing the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahului
