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 '%Kihei Sands%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Our last winter opening until May! Just 409/nt for this gorgeous OCEANFRONT condo!
Mar 18-24
Are you craving PANORAMIC views from your condo & private balcony? Condo B9 boasts unobstructed 180° up-close-&-personal views of white sand
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kihei Sands is a Direct Beachfront complex, Popular Unit A1 - An Amazing Location!
Aloha & E Komo Mai to our beautiful Condo, Unit A1~
We purchased and completely renovated A1, we love spending time here as a family! Since we are new
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Oceanfront for just $459/night through May 15! Book NOW!
We can't wait to welcome your party of 4 to Kihei Sands Beachfront Condominiums B8 in sunny South Maui! Condo B8 is a 2-bedroom, OCEANFRONT townhouse-style condo on the 2nd level
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Gap Fills:
*6 nights Mar 30-Apr 5 $309 Our last week this season - book now for whale season before it's gone!
Fabulous views - steps from the beach - oceanfront property!
Welcome to Kihei Sands Beachfront Condominiums Condo A11
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Whales have been RIGHT IN FRONT of our building - don't miss this!
Are you island hopping and need just a few nights in Maui? Fill our gaps!
One night min:
Feb 25-26-27 - $349
Mar 9&10 - $209/nt
Apr 1-5 Four nights -
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Just $349/night through May 15 - book now before dates disappear for good!
This HIGH-END five-star luxury condo's impeccable remodel was finished in August 2024 with your comfort in mind. Kihei Sands' ONLY true 2-bedroom unit has a full
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
May 1-16 only $179/night! Prices have never been lower!
We are ON THE WATER! You won't need to cross the street or walk through acres of land to get your feet wet. It's 75, sunny & the drinks are cold! If you're looking for an unpopulated
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
7-night min:
$339/nt - March 22 - Apr 1
Dates JUST opened up! Whales have been RIGHT IN FRONT of our building - book now before they head back to Alaska mid-April!
ALOHA! Are you ready to spend some time barefoot at the beach?
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kihei
Incredible views!
Gap Fills:
Feb 25-26-27 $229/nt
March 22-23-24 $229/nt
Apr 9-15 Six nights $389
You'll love staying in our one-bedroom Condo A10 with a gorgeous view of the beach & the Pacific Ocean. The bedroom boasts a
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Are you ready to come out of the dark & into the sunshine? Surprise your sweetheart with a trip to Maui this winter and join us here at beautiful Kihei Sands! With many airfare deals going on right now, it's a great time to book a trip. Come
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
All of April - start of low season - just $229/nt!
Aloha & welcome to Condo B14! This 2nd floor (no elevator) condo is priced for 4 persons - we'll add $42/pp/night for each additional guest over 4, up to 6 guests total. A child under
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Our property is NOT impacted by the news of potentially prohibiting Short Term Rentals (STR) in Maui. Kihei Sands is zoned as a hotel property so meaning it is exempt from any of the potential STR regulations being proposed by the
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Gap Fill:
Mar 29-Apr 3 - Need an extra night or two? Just $359/nt in our gorgeous condo on oceanfront property! Steps to the beach!
Maui has never been more affordable! Condo B4 is a beautifully renovated 2B/2Ba townhouse-style unit
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Spring rates! Welcome to Condo B10 in sunny South Maui! This second-story (no elevator) condo is perfect for two couples or perhaps two BFFs who wish to have a little more space to spread out, each with their own bathroom & bedroom.
Our
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
April 21 - May 15 dates just $179!
The weather is warm, skies are sunny & the drinks are cold! If you're looking for an unpopulated spot within a 15-minute drive of dining, shopping & nightlife, we're it! We've got just two openings left
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Whales have been RIGHT IN FRONT of our building - don't miss this! They head back to Alaska mid-April - last chance to see them!
Feb 24-Mar 8 $389nt - 5 Night Min.
Gap Fill: Mar 22 & 23 - $339/nt OCEANFRONT
Condo A8 is a
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Just $269/night through May 15! Family reunion, birthday or anniversary on the horizon? Have an unforgettable family trip together - no matter the occasion, it's always better at the BEACH!
From our crystal-clear mosaic-tiled OCEANFRONT
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Act now - this condo is POPULAR!
Gap Fills: April 11-16 $249/nt
May 13-18 $249/nt
Other dates just $329 through May 13
Condo B5 is a 2B/2Ba (Sleeps 4) townhouse style condo on the 2nd level (NO ELEVATOR) at Kihei Sands
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Spring into Maui at just $249/night until May 15!
Tired of waiting for Spring? Kihei Sands is waiting for YOU! Everyone will stay COOL with whisper-quiet Mitsubishi split A/C in the living area & each bedroom. Ceiling fans throughout if
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
This condo is priced for 4 persons - we'll add $42/pp/night for each additional guest over 4, up to 6 guests total. A child under the age of two at the time of arrival will count towards the total number of guests allowed, however the extra fee
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Are you ready to shake off the winter chill? Come join us for sunny days and warm evenings at low season rates - just $229 through May 15!
Our 2-bedroom/2-bath townhouse style home with ocean view is on the 2nd level (no elevator) at
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Just $419/night through June 15! Friends trip? Kids & grandparents? Come stay with us!
Aloha & welcome to Condo B15, a 4-BEDS / 2-BATHS townhouse-style home on the 2nd level (no elevator) at Kihei Sands Condominiums!
This
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
LITERALLY A FEW STEPS FROM THE BEACH AND OCEAN!
You'll love staying in our home-away-from-home. If you're looking for a quiet, serene spot away from the crowds, look no more. Our photos are up-to-date & show accurate views of the condo &
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
