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 '%Maui Kamaole%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Maui Kamaole D209
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Luxury and privacy meet at Maui Kamaole, located just minutes away from the three sunny ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Maui Kamaole K207
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Luxury and privacy meet at Maui Kamaole, located just minutes away from the three sunny ...
- 0 bedroom
- 0 bathroom
- Sleeps 4
HI> Kihei
Maui Kamaole M210
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Luxury and privacy meet at Maui Kamaole, located just minutes away from the three sunny ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Maui Kamaole K203
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Luxury and privacy meet at Maui Kamaole, located just minutes away from the three sunny ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Maui Kamaole C108
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Luxury and privacy meet at Maui Kamaole, located just minutes away from the three sunny ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
This ocean view, two-bedroom, two-bath condominium is located near the front of Maui Kamaole and is located up one flight of stairs on the second level. Inside you will notice it is designed in the style of a townhouse with the master bedroom on...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Maui Kamaole M207
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Luxury and privacy meet at Maui Kamaole, located just minutes away from the three sunny ...
- 0 bedroom
- 0 bathroom
- Sleeps 4
HI> Kihei
This beautiful two-bedroom condominium has been remodeled and decorated by a designer. Enjoy sunsets and ocean views while relaxing on the private lanai. This unit is located up on the hill and overlooks the lush tropical landscape of the Maui ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihe
Maui Kamaole L103
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Luxury and privacy meet at Maui Kamaole, located just minutes away from the three sunny ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Kihei
Maui Kamaole D205
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Luxury and privacy meet at Maui Kamaole, located just minutes away from the three sunny ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Partial ocean view remodeled unit located in the nicest complex in Kihei. This 2 bed, 2 bath unit was renovated in 2019. The complex boasts 2 pools and 2 hot tubs and is considered one of the quietest on the island. This unit is uniquely ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Maui Kamaole H110
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Luxury and privacy meet at Maui Kamaole, located just minutes away from the three sunny ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Maui Kamaole C203
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
This condo at Maui Kamaole reflects a modern island style with a premium kitchen and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Maui Kamaole K106
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Luxury and privacy meet at Maui Kamaole, located just minutes away from the three sunny ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Maui Kamaole D111
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Luxury and privacy meet at Maui Kamaole, located just minutes away from the three sunny ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei