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 (`headline` like '%Mana Kai Maui Resort%') AND sleeps>=1 order by rating desc LIMIT 0, 30
5-STAR VACATION RENTAL BY OWNER IN MAUI, DIRECTLY ON KEAWAKAPU BEACH IN WAILEA/KEHEI, SOUTH MAUI:
Mana Kai Maui Resort Unit 402 is a totally remodeled, custom designed, luxury two-bedroom beachfront condo located at the ocean end of the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Wake up to an unforgettable view and the soothing sounds of the ocean waves.
This condominium suite sets a tone of serenity by surrounding you with cool colors, quality accessories, finishes and furnishings, a fully-equipped kitchen, and ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Located directly on the ocean front, this is a not to be missed experience! Start and build your Maui memories here where you will find both relaxation and be inspired to adventure! This serenely accessorized condo has a long lanai that runs ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kihei
Mana Kai Maui Resort 201C
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Mana Kai Maui Resort 614
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei, Maui
Enjoy a 'keep it simple' stay, contented with the basics of everything you need to sleep comfortably and be ready for active days making your Maui memories! This bed and bath lock off suite offers choice of bed arrangement of either one king or...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Mana Kai Maui Resort 605
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Mana Kai Maui Resort 709
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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 ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Mana Kai Maui Resort 602C
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Mana Kai Maui Resort 215
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Mana Kai Maui Resort 707
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Mana Kai Maui Resort 706
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Mana Kai Maui Resort 706a
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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Mana Kai Maui Resort 211b
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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei, Maui