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 '%Royal Mauian%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Highly cleaned and sanitized for your vacation. Ask about our AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, traditional housekeeping service will be performed every 7th day. This includes refreshing
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei, Maui
ALOHA!
Welcome to Kihei, Maui and your oceanfront paradise! Our incredibly beautiful condo is near the center of the building and only steps away from the water. Watch whales, savor the sunset and enjoy the sound of the waves from the
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Fully remodeled and updated, our home is ideally suited for a romantic getaway, celebrating a special life milestone, those looking for a little laid-back downtime, and anyone wanting to enjoy Maui to its fullest potential. Our 1 bedroom 1 bath
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Experience No. 604 at Royal Mauian, a comfy top-floor, air-conditioned beachfront sanctuary with breathtaking views. Nestled between two white sand beaches, enjoy the best of both worlds: dive into vibrant beach life or relax watching the ocean
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
You'll enjoy making memories in this well maintained, beautiful, family owned condo, Unit 515. The view is fabulous and the location is perfect. Simply walk downstairs and lounge on the grass next to the pool, or walk right next door to Kamaole
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to your perfect Maui getaway at Royal Mauian Unit 509! This beautifully designed, fully remodeled 1-bedroom, 1-bathroom oceanfront condo is located in the vibrant Kihei area, just steps from the stunning beaches and local attractions.
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Indulge in the ultimate Maui experience at Royal Mauian #307, where stunning ocean and coastline views await. This exceptional two-bedroom condo offers a luxurious retreat with upscale amenities and unbeatable beachfront location in South
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei, Maui
Welcome to Royal Mauian 104, where luxury meets the beauty of Maui’s coastline. Nestled on the ground floor of the prestigious Royal Mauian complex, this modern 2-bedroom, 2-bathroom condo offers the perfect blend of style and comfort. With
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Experience the ultimate Maui vacation at Royal Mauian #207, a stunning two-bedroom condo offering breathtaking ocean and coastline views. Located in the unique six-story Royal Mauian property in South Kihei, this oceanfront retreat provides
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei, Maui
A Note From The Owner:
Everything about this condo says "vacation" from the custom kitchen to the oceanfront living-room-style lanai. Come with friends or bring your ohana for a get away with plenty of room for everyone and all the
- 3 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kihei, Maui
Amazing VIEWS of 3 Islands from this FULL oceanfront beach condo located in South Kihei. If you want the best...this is it! Royal Mauian Resort #316
Watch whales (in season) and turtles feeding on the snorkeling reef from the private
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kihei
This perfect 2 Bdrm Condo, Unit# 304, is located right on the beautiful and sandy Kamaole I beach. The best beach on Maui! Enjoy eating all of your meals on the large lanai prepared in the fully equipped kitchen. Cal King size temperpedic bed
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Spend your vacation in one of Maui's most beautiful oceanfront two-bedroom, two-bath condos at the wonderful Royal Mauian Resort.
Located in south Kihei, near Wailea, on Maui's sunny southern shore, this privately owned residence is
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
After a long trip to get to Maui, it is wonderful to walk into the condo and be wowed by the view. You are right on the ocean. On the 2nd floor, you are looking directly at the water. I think everyone heads to the lanai immediately.
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
A unit renovation will take place in unit 310, next door to this unit, beginning April 7th through September 15th. Please expect noise as well as the potential for dust and debris during work hours.
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Highly cleaned and sanitized for your vacation. Ask about our AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, traditional housekeeping service will be performed every 7th day. This includes refreshing
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei, Maui
Welcome to Royal Mauian #607 – Your Oceanfront Retreat in Paradise!
Escape to Maui’s breathtaking coastline and experience true island luxury at Royal Mauian #607. This stunning 2-bedroom, 2-bathroom condo is perched on the top
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei, Maui
Welcome to Royal Mauian #218, a beautifully remodeled condo offering exquisite details and modern amenities for your perfect Hawaiian getaway.
Key Features:
*Remodeled with Exquisite Detail: Enjoy a stylish and contemporary living
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei, Maui
Highly cleaned and sanitized for your vacation. Ask about our AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, traditional housekeeping service will be performed every 7th day. This includes refreshing
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei, Maui
Hawaii Tax ID: TA-076-894-8224-01
TMK: 390050100065
MAGNIFICENT! 30 feet from the ocean with a 180 degree unobstructed panoramic ocean view. Deluxe Unit with the best location in the building. Beautiful and serene, with warm ocean
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Experience the best of Maui at Royal Mauian 204, a stunning oceanfront condo in South Kihei. This spacious 2-bedroom, 2-bathroom unit offers breathtaking views of the Pacific Ocean, neighboring islands, and Molokini Crater. Enjoy romantic beach
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Royal Mauian is an excellent location for stunning sunsets, romantic beach walks and seasonal whale watching. This luxurious renovated unit offers amazing views of the Pacific Ocean. The rooftop garden offers breathtaking 360 panoramic ocean and
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Highly cleaned and sanitized for your vacation. Ask about our AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, traditional housekeeping service will be performed every 7th day. This includes refreshing
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei, Maui
Highly cleaned and sanitized for your vacation. Ask about our AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, traditional housekeeping service will be performed every 7th day. This includes refreshing
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to Royal Mauian #518
Your dream Maui vacation begins here! Discover unmatched oceanfront luxury at Royal Mauian #518, a spacious three-bedroom, two-bathroom condo in the heart of South Kihei. This 1,350 sq. ft. retreat offers modern
- 3 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kihei
Highly cleaned and sanitized for your vacation. Ask about our AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, traditional housekeeping service will be performed every 7th day. This includes refreshing
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei, Maui
Beautiful ocean views from this oceanfront, two-bedroom condo right on South Kihei Road. This condo has enough space for the entire family between the two bedrooms, a thoughtfully furnished living room, and the condo's private lanai or balcony
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Highly cleaned and sanitized for your vacation. Ask about our AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, traditional housekeeping service will be performed every 7th day. This includes refreshing
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei, Maui
Royal Mauian #511
Features:
Completely Upgraded Interior: Enjoy a modern, stylish living space with high-end finishes and contemporary decor.
King Bed in Master Bedroom: Sleep soundly in the spacious and comfortable king-sized bed,
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei, Maui
Welcome to Royal Mauian #405, an extraordinary oceanfront two-bedroom condo that showcases stunning views of the Pacific Ocean and Maui’s breathtaking coastline. Located in the heart of South Kihei, this condo offers the perfect blend of
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei, Maui
