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, 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! 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 ...
- 3 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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Aloha,
Maui is open for 2025 bookings! 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...
- 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
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
Maui Vista #3-319 is a 1 bedroom 1 bath unit on the third floor with a partial ocean view. The complex sits right across the street from Charley Young Beach and a short walk from Maui--Kamaole Beach Park I. The unit features air-conditioning in ...
- 2 bedroom
- 1 bathroom
- Sleeps 2
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
Our air conditioned, quiet, 1 bedroom, 1 bath condo is located across from one of the most beautiful parks and surfing, paddle boarding, swimming, and snorkeling beaches on Maui. Situated in the heart of Kihei, Foodland, restaurants, and gift ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
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
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
Maui Vista #2-210 is a 1 bedroom, 1 bath unit on the second floor. There is air conditioning in the living room and a ceiling fan in the bedroom, (no A/C in the bedroom) a fully-equipped kitchen, washer & dryer, elevator, flat-screen TV, and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Vista #1-301 is a 1 bedroom, 1 bath unit on the third floor with a partial ocean view. It has a fully equipped kitchen, room unit A/C in both the living room and bedroom, flat screen TV, and free wifi. Telephone with answering machine ...
- 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
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
Aloha!
Aloha!
Welcome to our newly renovated 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 quietest locations in ...
- 2 bedroom
- 1 bathroom
- Sleeps 3
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
Maui Vista #2-222 is a 1 bedroom / 1 bath, garden view unit. It has a full kitchen, air conditioning in both the living room and bedroom, and a washer / dryer. There is also cable T.V, local calling, and complimentary Wi-Fi. Complex is right ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
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
Please visit Maui! Despite the horrendous tragedy that has taken our beloved Lahaina, the rest of the island businesses need your support. Lahaina is a 45 minute drive from Kihei. Although we all loved Lahaina, there is still much to see on the ...
- 1 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
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
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 #1-418 is a spectacular 2 Bd 2 Bath unit with a full ocean view. Our unit is in one of the highly coveted buildings in the complex, building 1; which not only provides quick and easy access to the world-renown Kamaole Beach 1 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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
Please visit Maui! Despite the horrendous tragedy that has taken our beloved Lahaina, the rest of the island businesses need your support. Lahaina is a 45 minute drive from Kihei. Although we all loved Lahaina, there is still much to see on the ...
- 1 bedroom
- 1 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
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
*Professional Photos Coming September*
Book 5 nights and enjoy the 6th night free! Valid for new reservations from 8/6/24 for stays between 8/6/24 and 11/21/24.
Welcome to Maui Vista! It is centrally located in South Kihei with ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
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
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
***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
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
Maui Vista #2-411 is located in Kihei, just across the street from popular Charley Young Beach and 2.8 miles from Wailea Beach. The ocean view from this condo is beautiful and the complex features an outdoor pool area and a tennis court! ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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
