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, rewritten_description,
(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, 50
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! Enjoy our newly refurbished 600sqft condo located at the heart of Kihei with only 3min walk to the beach
Features:
• New king bed with 14inch hotel style mattress
• Queen sofa sleeper
• Two smart TVs
• 1 window
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Located just across the street from the ocean and surf spot, paradise awaits! Fabulous corner unit in arguably one of the best locations on Maui! Across from Charley Young Beach and Kamaole Beaches, you are only steps away from a beautiful beach
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Perfect location!
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
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
DISCOUNTED RATES APRIL-MAY
Welcome to your dream tropical paradise! Bask in the glory of gorgeous sunsets right from your own living room or lanai. Centrally located in the heart of Kihei, this 2bd/2ba top floor, 2-story loft condo is
- 2 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kihei
Located in sunny South Kihei at Maui Vista Complex enjoy what this 1-bedroom condo has to offer. With a comfy king bed, WiFi, AC, 2 smart TVs, washer & dryer our guests can relax and unwind after a day at the beach.
The "Beach Closet" at
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Aloha,
A beautifully renovated top floor 2 bed 2 bath, with vaulted ceilings and fantastic amenities. The unit faces Maalaea Bay and the West Maui Mountain. Elevator access to the unit makes it very convenient for all ages; parking is free,
- 2 bedroom
- 2 bathroom
- Sleeps 6
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
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
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
Enjoy beautiful ocean views from this top-floor condo. Located just across the street from Charlie Young Beach, and provides easy access to the other Kamaole Beaches and the "Cove". King bed in master, and twins in the loft. Rates are based on
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Vista is located across from Charley Young Beach (Kam 1)Fully furnished condo, including full Kitchen, in-condo washer/dryer, large refrigerator, air conditioner, new Smart TV ,cable and WiFi internet. One Bedroom has a Queen size bed
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Hello and Welcome to Maui. This non-smoking 1 bedroom, 1 bath Maui Vista unit is located directly across the street from the world famous Charley Young Beach. I've upgraded the internet speeds to 300 Mbps Download and 20 Mbps Upload. This unit
- 1 bedroom
- 1 bathroom
- Sleeps 3
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
Our guests not only love the upscale tropical décor, they love the location in the building closest to the beach. Maui Vista 1-308 is literally a three minute walk from the front door to the pristine golden sand at Kamaole I Beach. The condo
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Aloha!
Welcome to our updated 1 Bedroom 1 Bathroom condo at Maui Vista. This unit is beautifully nestled away at the back of the complex on the ground floor. This is one of the most private and quiet locations in the complex. You can
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kihei
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 the renowned
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Our ground floor Maui Vista condo overlooking the gardens has been recently remodeled to create a resort style vacation spot at an affordable price. A sunny lanai provides a perfect spot for morning coffee.
Sleeps 4 comfortably- 1
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> 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,
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Completed in August 2024, this exquisite condo has undergone a full renovation, making it one of the most updated and refined units in the building. Every aspect has been thoughtfully designed by a top Maui interior design team, ensuring that
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Quiet and peaceful one-bedroom condo located at the Maui Vista. This condo is located in the rear of the property, set back from the majority of the noise. It is the perfect place to relax on your lanai (balcony). This one-bedroom condo offers
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to Maui Vista 2-301, everything in this condo was selected to set the tone for your ultimate tropical Maui vacation, from the locally sourced beach art to the comfortable island-style furnishings. Located a close walk to Charlie Young
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to Maui Vista 3421! Great location in the heart of Kihei with Ocean Views! This 2bedroom/2 bath condo with second level is the perfect accommodation for small families or couples traveling together. Just 1 block from local surf spot,The
- 3 bedroom
- 2 bathroom
- Sleeps 6
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
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
At Maui Vista 3-102 you can walk right out onto your lanai and the beautiful garden beyond, under the Plumeria trees – or sip coffee or your favorite beverage on your own private patio/lanai. Our fully equipped condo, which comes with
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Vista 2213! Centrally located in Kihei across from Charley Young beach. This 1bed/1bath is minutes to beaches, dining, shopping, and golf!Welcome to Maui Vista 2213! This striking condo is the perfect location for your Maui getaway. Its
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
One bedroom partial ocean view condo located on the third floor with partial ocean views. This unit will accommodate up to four (4) people with a queen bed in the bedroom and a pull-out sofa bed in the living room. The living room has a
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Vista Resort is South Maui's Best Value, offering 1 and 2 bedroom condos. Consisting of 3 buildings, pools, tennis courts, and BBQ areas at each building. This complex is in prime location to everything in Kihei located across from famous
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This one-bedroom condo can accommodate up to four people with a queen bed in the bedroom and a pull-out sofa bed in the living room. The fully equipped kitchen is perfect for preparing meals to dine-in or to take with you while on the go. The
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> KIHEI
Experience the perfect Maui getaway at Maui Vista #3410, a charming 2-bedroom, 2-bathroom condo in South Kihei. Ideally located across from Charley Young Beach, this affordable rental offers stunning Pacific Ocean views from your private lanai.
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
***DISCLOSURE 11/5/24: Home is listed for sale, and tenants may need to accommodate showings with 48 hours notice.
Unit is 3419 is centrally located and highly updated. The unit and complex are directly across the street from world
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Beautifully Renovated one-bedroom condo with partial ocean views. This unit sleeps 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 all new granite countertops,
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Vista 2410
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Located across the street from beautiful Charley Young Beach, this 2BR/2BA
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
This loft style condo with its vaulted ceilings, large windows and new paint is clean, bright and cozy. It has two queen size beds in both the master and loft bedroom.. The loft bedroom has a full bathroom with a shower and the bathroom
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
There’s a reason guests return year after year to Maui Vista 1210. The condo is beautifully maintained, in an ideal location across from Charley Young Beach, just north of Kamaole Beach I, and offers amenities that are simply exceptional. Best
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Book with us and come to Maui to explore everything we have to offer!
Welcome to your beautiful vacation home at Maui Vista. Amazing unit with new carpet, split AC system, glass titled back-splash, Remodeled bathroom and nice furniture.
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Kihei
Maui Vista 2116
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Discover island bliss at Maui Vista! Nestled across the street from the ocean,
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Remodeled in 2024! Maui Vista 3201 is one of the best locations in Kihei! This 1 bedroom, 1 bath condo is the perfect retreat for your Maui getaway with beaches, dining, shopping, and golf all within minutes. It's just a block away from a
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
One bedroom garden view condo located on the second floor. This unit sleeps up to four people with a queen bed in the bedroom and a pull-out sofa bed in the living room. There are many tropical accents and upgrades throughout this unit. Enjoy
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Remodeled kitchen, and bathroom plus new flooring. This one-bedroom, one-bathroom, garden-view condo offers the simplicity of home in a tropical paradise. The master bedroom has a queen bed and the living room has a sofa bed, allowing this unit
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Enjoy the convenience of South Maui from this one-bedroom condo at the Maui Vista. This garden-view condo is located towards the back of the condo and provides peace and quiet. This condo will accommodate up to four people with a queen bed in
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Book with us and come to Maui to explore everything we have to offer!
Relax while enjoying your luxurious ocean views! This wonderful lofted unit feels more like a home than a condo home. Your home away from home has wonderful amenities
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Book with us and come to Maui to explore everything we have to offer!
Ocean view tropical escape. A short stroll to beautiful Charley Young Beach, directly across the street from your unit. Completely remodeled with porcelain tile, full
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
One-bedroom condo with a partial ocean view. This unit sleeps up to four people with a queen bed in the bedroom and a pull out sofa bed in the living room. The kitchen opens up to the dining and living areas creating a wide-open living space.
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
One bedroom one bath garden view condo located on the third floor at the, centrally located, Maui Vista. This unit will accommodate up to four people with a queen bed in the bedroom and a pull-out sofa bed in the living room. The living room has
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to our cozy suite in South Kihei! Our home offers everything you need for a wonderful and relaxing stay on the beautiful island of Maui. Step out onto our oversized lanai and breathe in the tropical breeze while enjoying the lush
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Large two-bedroom condo with a loft with ocean views. This vacation rental features a queen bed in the master bedroom, two twins in the loft bedroom, and a pull-out sofa bed in the living room. This unit looks out over the pool. Relax on the
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
