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 '%Mana Kai Maui Resort%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Mana Kai Maui Resort 506
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Mana Kai Maui Resort 615a
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Mana Kai Maui Resort 409a
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Mana Kai Maui Resort 709a
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Mana Kai Maui Resort 605a
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Mana Kai Maui Resort 709b
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kihei
Mana Kai Maui Resort 211a
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Mana Kai Maui Resort 202C
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Mana Kai Maui Resort 506a
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Mana Kai Maui Resort 211
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, we will be exchanging bath towels and amenities every three days and performing a traditional ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei, Maui
Mana Kai Maui Resort 702C
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Mana Kai Maui Resort 614a
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Mana Kai Maui Resort 614b
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Kihei
Mana Kai Maui Resort 707A
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Swim, lounge, and snorkel at the fabulous Mana Kai Maui Resort, the jewel at the...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kihei