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 '%Menehune Shores%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Gorgeous Ocean Front views! This two-bedroom condo has spectacular Ocean Front views that are visible from most of the condo. Enjoy waking up with fabulous views of the ocean from the master bedroom. The fully-equipped kitchen has everything you...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Enjoy sun-soaked beach days and relaxing balmy evenings at this fourth-floor 2BR/2BA Menehune Shores condo. Your rental offers a prime location on the right side of the building, overlooking the pool and ocean and offering split system remote ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Fresh and clean 2 bedroom, 2 bath that sleeps 6. Oceanfront unit with air conditioning in both bedrooms and living room. This beautiful resort is located in South Kihei, next to the Hawaiian Islands Humpback Whale National Marine Sanctuary and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Menehune Shores 606
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
The Menehune Shores condominium complex boasts a prime oceanfront location in North ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Completely Remodeled Ocean Front two-bedroom condo located at the Menehune Shores in Kihei creates the perfect spot for your Maui getaway. The lanai is a great place to relax and enjoy the ocean views. The beach in front of the property is great...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Kihei
Upgraded direct oceanview condo at Menehune Shores #306 with views, views, views! Enjoy watching the sunset, seasonal whale watching, outriggers, paddle-boarders and kite boarding from the comfort of your private oceanfront Lanai. Many ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Kihei
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, note that this has been replaced with a no-contact service for you and our team’s health and ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
HI> Kihei
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, note that this has been replaced with a no-contact service for you and our team’s health and ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
HI> Kihei
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, note that this has been replaced with a no-contact service for you and our team’s health and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Beautiful third floor one bedroom condo at Menehune Shores in Kihei- If you like the water this is as close as you can get. The kitchen has
been re-modeled and is well stocked for cooking at home. There is a washer and dryer
and new carpet and...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei Maui
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, note that this has been replaced with a no-contact service for you and our team’s health and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Menehune Shores 526
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
This ]ocean view condo enjoys fantastic views down the Kihei coastline and out over ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Menehune Shores #401 is a 4th floor unit that is beautifully furnished 2 Bedroom 2 Bath unit that can sleep 6. It has a fully equipped kitchen, washer and dryer, ceiling fans and a giant flat screen TV. This unit has no air conditioning. Whale ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Menehune Shores #425 is an oceanfront ocean view unit with a gorgeous view of the ocean. It is a 2 bedroom 2 bath unit with a fully equipped kitchen, washer and dryer, and internet service. Long distance calling to the US Mainland and Canada is ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Located front and center on the fourth-floor, this spacious 3BR/2BA Menehune Shores condo offers unbeatable views of the sparkling ocean below. Enjoy the sounds of the waves lapping the shore as you are situated toward the ocean side and far ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
HI> Kihei
