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 '%Maui Vista%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Locally owned and operated 🤙🏻
Clean, private, updated, one-bedroom condo perfect for couples and families. Condo has additional queen size Murphy bed.
Located in Kihei on the leeward, sunny side of Maui. Great for snorkeling, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
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
Hawaii> Kihei
Welcome to Maui Vista unit #1216! Just bring your Aloha spirit and we will provide all the rest. This unit has undergone a complete remodel as of October 2022. We are the same owners as before and look forward to continue providing our guests ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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, and ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Beautifully remodeled and renovated partial ocean view condo. This two-bedroom unit sleeps up to six people with a king in the master bedroom, two twins in the upstairs loft bedroom and a pull-out sofa bed in the living room. The kitchen has ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Newly remodeled 1 bedroom/1 bathroom corner unit that sleeps 4. Ideally located with ocean and mountain views. Stay in style with everything you need for work and play. Start your day with a walk on Charley Young beach-literally across the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Summary:
Discover the newly renovated charm of Maui Vista 3-220, where a fresh tropical ambiance awaits your Maui escape. Immerse yourself in the clean, inviting theme that sets the stage for an unforgettable adventure. Just steps away from ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
You will be located in Maui Vista unit 3207, across from Charley Young Beach on the north end of Kamaole Beach 1 (KAM 1) where you find white sand beaches attributed to South Maui.
Maui Vista Resort is a three-building property in South ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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
Hawaii> Kihei
Premium upgrades, superior furnishings & charming decor make this condo a comfortable place to settle while on Maui. This vacation condo is so much more than just a place to sleep and cook, it will be your home away from home. Have breakfast on...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Your dream vacation starts here. This unit is fully renovated with exceptional decor and amenities, truly giving you the feeling of home away from home. Hard-surface wood floors throughout and tile in the bathroom are attractive, and cooling. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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
Hawaii> Kihei
This fully remodeled top floor corner unit is an ideal place to relax after Maui adventures. A quiet and comfortable condo to make you feel at home. The kitchen features upgraded appliances, stone counters, new cabinets, stylish lighting, and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Aloha!
Enjoy this recently remodeled 3rd floor (easy access from elevator), 1 bedroom, 1 bathroom condo at the Maui Vista #2306 in South Kihei. This condo is quietly located in the second building, away from traffic, directly above the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Aloha. Welcome to Maui Vista #3110. Just bring your Aloha spirit and we'll provide all the rest. This ground floor 1 bed/1 bath (584 sq. ft.) unit in Building #3 provides easy access to the pool, bbq and tennis courts. Ground floor units provide...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Vista #2418 is a spectacular 2 bedroom 2 bath unit that features custom cabinetry, granite counter tops, tile and granite floors downstairs, and bamboo floors upstairs.
The beautifully designed kitchen has everything you will need for ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Maui Vista #2-423 is a fully renovated 2 Bed 2 Bath unit with a tropical garden view. The unit is equipped with a full kitchen, washer & dryer, and air conditioning in the living room and master bedroom. Complimentary Wi-Fi and Long distance ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Vista #1-307 is a 1 bedroom 1 bath condo (not hotel) with a great ocean view. Unit 1-307 is on the 3rd floor in the closest building to the beach. Just cross the road and you are on the world-renowned Kamaole Beach 1 also known as Charlie ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Vista #2-101 is a 1 bedroom, 1 bath unit on the ground floor with a tropical garden view. It features room unit air conditioning in both the living room and bedroom, a fully-equipped kitchen, washer and dryer, a California king bed, 2 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This lovely peek-a-boo ocean view unit 2-304 is located in building 2, providing lots of privacy yet close to the pool and tennis courts. Just a 4 minute walk to the white sand beaches of Charlie Young, Kam I,II, III, and numerous restaurants ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
