select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, note that this has been replaced with a no-contact service for you and our team’s health and ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> 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 large ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, note that this has been replaced with a no-contact service for you and our team’s health and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei, Maui
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
HI> Kihei
You'll enjoy making memories in this well maintained, beautiful, family owned condo, Unit 515. If you already know the Royal Mauian Resort, get to know our family as well. We rent to a few guests a year and have many returning clients. We ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
Royal Mauian #104 completed a full renovation in August of 2021. Royal Mauian #104 has new tile floors, new mattresses, an updated kitchen, bathrooms, and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei, Maui
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, note that this has been replaced with a no-contact service for you and our team’s health and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, note that this has been replaced with a no-contact service for you and our team’s health and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
No. 604 | AC | at oceanfront Royal Mauian wistfully gazes at the beach and beyond the crystal blue sea to an ancient volcano. Set just footsteps between two soft, white sand beaches on Maui, here is where you can truly be immersed in beach life....
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
This beautifully decorated 2 bedroom, 2 bath ground floor condominium home underwent a complete renovation. In April 2019 we replaced all the windows with new thermal aluminum windows that will keep the home quiet and cool. We are also upgraded ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, note that this has been replaced with a no-contact service for you and our team’s health and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Hawaii Tax ID: TA-200-360-7552-01
TMK: 390050100032
UNIT #216: Two bedroom, two bath 2nd floor ocean front unit. The Royal Mauian Resort is located just steps away from two of Maui's finest beaches. Unit 216 is conveniently...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
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
HI> Kihei
Royal Mauian #410 is a 2 bedroom, 2 bath unit on the 4th floor with a panoramic ocean view and central A/C throughout. It has a fully-equipped kitchen, full size washer and dryer, 3 brand new flat-screen TV, DVD, telephone, and free WIFI. There ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Highly cleaned and sanitized for your vacation. Ask about out AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, note that this has been replaced with a no-contact service for you and our team’s health and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei, Maui