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
Situated in a quiet neighborhood, the Maui Vista is located across the street from Charley Young Beach and within walking distance of shopping, restaurants, bars, grocery stores and surfing/standup paddle-boarding lessons.
This condo ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
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
This recently remodeled, bright one bedroom condo is appointed with wood flooring in the living room, bedroom and kitchen with tile in the bathroom and hallway, keeping the space airy and cool. LG-HIMacs counter tops in living room and bathroom...
- 2 bedroom
- 1 bathroom
- Sleeps 4
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
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 fourth floor, two-story condo is across the street from Charley ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
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
Welcome to your ultimate Maui getaway at Honu Kihei -- Maui Vista 2107!
β
Fully air-conditioned for your comfort (mini-split/living room and air conditioner/bedroom)
β
Free Fast WiFi
β
Flat-screen TV for streaming and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
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
