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 Vista%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Aloha! We are happy to share our gorgeous, bright, clean and well-equipped vacation home with you. One bedroom with one queen bed, one bath and a sofa bed (sleeps four). Maui Vista is just steps from Charley Young beach. This quiet unit is ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Clean, private, updated, one bedroom condo perfect for couples and families. Condo has additional queen size pull-out couch. Located in Kihei on the leeward, sunny side of Maui. Great for snorkeling, swimming and scuba diving; right across the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
The Maui Vista Resort is located across the street from one of the Top 10 beaches, Charlie Young/Kamaole Beach Park I. Just around the corner is Cove Park, where you can learn to master your surfing skills.Shopping, dining and grocery store is ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Great Location! This 1 bedroom ground floor unit at the Maui Vista complex is located in S Kihei, which is centrally located on the southwest side of Maui, an easy drive to nearly all of Maui’s outdoor activities and landmarks.
Situated in a ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
One-bedroom Garden view condo located on the ground floor. This unit accommodates up to four people with a queen bed in the bedroom and a pull out sofa bed in the living room. The kitchen has been renovated with new cabinetry, countertops, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> KIHEI
Soak in the sun and unwind at this stunning condo in the heart of South Kihei.
Located on the bottom floor in the first building and only steps away from the pool. We are a short walking distance from the famous Charley Young Beach, fantastic ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kihei
Desirable upgraded third floor front building ocean view unit only 900 feet from Kamaole Beach 1. Short walking distance to Kihei shops and restaurants. Central south Maui location for easy access to all island locations. Lush tropical ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Just picture yourself; it's a warm tropical evening, you're sitting on your lanai, watching one of those magnificent Hawaiian sunsets you've only seen on postcards. Pinch yourself! It's real! You CAN be here in Paradise.
Our ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Centrally located in Kihei, right across from Charley Young Beach, this 2 bedroom/2 bath Ocean view condo is the perfect getaway for the whole family!
Just 1 block from local surf spot, The Cove. Many World-famous beaches just moments away ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Welcome to Maui Vista! Just bring your Aloha spirit and we will provide all the rest. Your 1 bed, 1 bath unit sleeps 4 and provides you with a partial ocean view from your living room, kitchen and lanai. Your second-floor unit, accessible by ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
This tastefully renovated condo is a tranquil and inviting retreat. Comfortable furnishings and select upgrades will make you feel at home. The cheerful living room has a cozy couch with a sofa sleeper option for up to 2 children (12 or under), ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Kihei
**Note: The quarantine situation for Hawaii evolves frequently. Overseas visitors (Canada, Japan, and US mainland) have an alternative to the 10-day mandatory quarantine in effect. Under this option, travelers can come to Hawaii if they can ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
The world is changing, and we are changing with it. Here at CB Island Vacations, we have taken the time to revamp our practices to ensure a clean and safe environment for all of our guests and staff.
We have added very detailed cleaning ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Let your Hawaiian vacation begin. You will be greeted inside the condo with a fresh floral arrangement & welcome treats of local fruits & chocolate.
Maui Vista is one of the most centrally located condo complexes in Kihei and only a 25 minute ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Aloha. Have you noticed how we're constantly towards the top of Kihei and Maui Vista searches. Well, vrbo has a system of metrics they use that ranks all listings, basically putting the best units available in front of guests...and we're ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei