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 = 'Kahului' OR postalCode = 'Kahului' OR region like '%|Kahului|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Say hello to our new keiki 2018 Custom Mercedes Metris Campervan from the Rent For Less Maui Camper fleet!
Brand new to the market is our Mercedes Campervan This weekender version sleeps 2.
with full size bed , that sleeps 2 It's easy ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> 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
HI> 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
HI> Kahului
Our new "HALE "
2012 Mercedes-Benz Sprinter-Fully custom build-with full California king size bed and Toilet inside.
All Rent For Less Maui vans are considered “road trip ready.” Whether you are flying in from out of town or looking to ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> 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 of their own unit ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kahului
2015 DODGE RAM PROMASTER 2500 Diesel -HIGH TOP- Camper -RV with ONLY 7900 Miles ONLY
Fully custom off the grid conversion with a minimalist open design. Whether you’re a weekend adventurer, or plan to live in the van full time, this van will ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> 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
HI> 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
HI> 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
HI> 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
HI> 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 ...
- 4 bedroom
- 4 bathroom
- Sleeps 16
HI> 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> 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
HI> 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
HI> 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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 12
HI> Kahului
