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 '%Valley Isle%') AND sleeps>=1 order by rating desc LIMIT 0, 50
When you go on holiday, the goal is to forget about the rest of the world. And the best way to do that? By choosing an unforgettable destination – Hale Kai O Kihei, on Maui’s tranquil southwestern shores.
At Hale Kai O Kihei, your ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Enjoy spectacular unobstructed 180-degree views from our direct oceanfront vacation rental one bedroom condo at the Valley Isle Resort, located on the beach in beautiful West Maui. Swim, snorkel, relax by the heated swimming pool or just enjoy ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Just minutes to Ka'anapali, Napili, and Kapalua, the Valley Isle Resort will give you and your family the fun and relaxation it needs.
Great Restaurants and Shopping Within Walking Distance of the Resort
Direct Beachfront ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
From the moment you arrive to Valley Isle 707, you will be mesmerized by the views of Molokai and Lanai. Step inside and find a spacious, modern living space with porcelain tiled floors, a luxurious queen-sized Murphy bed, and a comfortable ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
There's no denying it. The ocean brings us both joy and tranquility that truly soothes the soul. Walker's Paradise Maui welcome's you to come enjoy the breathtaking views, fall asleep and wake up to the sounds of the ocean, watch the most ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Enjoy this relaxed and private, direct ocean front penthouse condo on Kahana Bay. Spectacular views of Molokai, Lanai & Sunsets. Feel the tropical breezes off of the ocean. Smell the fragrant flowers, dip your toes in the warm island waters. Now...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
★Free Parking, Free Wifi, No Resort Fees★
Newly Remodeled and featuring a Powerful Split Air Conditioner to Keep you Cool!
Your Maui Dream Starts Here: Ground Floor Paradise at Valley Isle Resort #101
Escape to paradise ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Valley Isle Resort #105 is a charming ground floor 1-bedroom unit situated along Maui's picturesque western coastline. This cozy retreat features a queen bed in the bedroom and a convenient queen-sized Murphy bed in the oceanfront living ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Valley Isle 301 is the perfect Hawaiian retreat! This gorgeous 1 bedroom/1 bath nicely updated condo offers ocean views! Valley Isle 301 is just steps to the beach, conveniently located on Maui's West Coast between Kaanapali and ...
- 3 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Lahaina
TMK #390200010155
Hawai'i Tax ID #205-260-2880-01
If you need some rest-and-refresh time to get ready to face the New Year, we have just the answer. A five-day window has just opened at our condo on Maui. Think of it: kicking back on ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This spectacular 2 bedroom/2 bath upgraded condo is directly oceanfront on the 7th floor just steps to the beach, conveniently located on Maui's West Coast between Kaanapali and Kapalua. This unit has breathtaking views of the ocean and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Oceanfront Valley Isle - beautiful, remodeled ocean front, 2 bedroom, 2 bathroom condo with fabulous a ocean view!
Pool
BBQ areas
Walking distance to restaurants and store
Washer/Dryer, Free parking and NO Resort Fees!
Brand New ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Welcome to Valley Isle 804 by Gather, exclusively offered by the Stice Team. This luxurious condo on the eighth floor offers direct oceanfront living at its finest in the heart of Kahana, Maui. As soon as you step into this one-bedroom, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Close to sailing, scuba diving, and more, this smoke-free condo brings it all within reach. Kahana Beach is within an easy 7-minute walk and West Maui Mountains is also a quick 11-minute walk away, so leave your car at the property, which ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
Overlooking a sandy beach protected by coral reefs, you will fall in love with the impressive oceanfront views and colorful sunsets that set the sky ablaze with a spectacle of colors. As if that's not enough, you will be conveniently located to ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Welcome to your tropical paradise retreat in Kahana! Experience the epitome of oceanfront living with breathtaking full ocean views from this exclusive end unit. Nestled in a serene and private setting, this 1-bedroom, 1-bath vacation rental ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Ocean front condo on the ocean in Kahana. Bring your DVD's from home and watch them on the 27" LCD TV.
Front row seats for whale watching! The Humpback Whale season starts its 6-8 week migration to Maui from Alaska in the Fall! Here are...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
This condo is Hotel Zoned and a legally permitted vacation rental according to the County of Maui ordinances.
Oceanfront Luxury in Kahana – Newly Renovated with Stunning Views and Modern Comfort
Aloha and welcome to your hale ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
KBM Resorts: VIR-508 - Fifth floor condo with ocean front views on Kahana Bay!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2025 and receive a 4-door rental...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Lahaina
Remodeled, very clean, with ocean views from this penthouse (12th floor) condo on the ocean in Kahana. Four guests maximum please. Enjoy ocean views on the lanai off of the living room and master bedroom. Watch your DVD's from home on the 46 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Book with us and come to Maui to explore everything we have to offer!
Now with Air Conditioning - Split AC installed June 2023!
This private 2 bedroom 2 bath ground floor unit provides nice ocean views and easy ocean access on the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Deluxe remodeled condo on the 2nd floor, directly ocean front on Kahana Bay. Updates to this unit included a fresh coat of paint, new beds (king bed and queen Murphy/wall bed), flat screen TV in living room, light fixtures and decorative items. ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Enjoy this large 2-bedroom, 2-bathroom unit at the Valley Isle Resort in an oceanfront building with all the homey comforts you need for your vacation in paradise. Floor-to-ceiling glass sliders provide an abundance of natural light & allow ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Valley Isle Resort Unit #1004 is an oceanfront one-bedroom & one-bathroom corner suite condo situated on the 10th floor. This unit offers panoramic views of the Pacific Ocean and the neighboring islands of Molokai and Lanai from the balcony. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Exclusive Resort Living at Valley Isle Resort on this 2nd Floor unit.
Newly luxuriously renovated one bedroom with ocean view from your bedroom, living room and Lanai. Fully equipped kitchen, washer and dryer in the unit.
The resort has ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Check out this condo! This one bedroom is a deluxe remodeled ocean view condo located on Kahana Bay. The condo has updated stainless steel appliances and granite counter tops in the kitchen. It has all new furniture including the king bed and ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Oceanfront Bliss at Valley Isle 1107
Discover the ultimate Maui getaway at Valley Isle Room 1107, a charming oceanfront studio that invites you to experience the beauty and serenity of the island from the moment you ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Valley Isle condo is located in the Kahana district of Kahana, 700 meters from Pohaku Park Beach, 1.3 km from Ka'opala Beach and 1.6 km from Keonenui Beach. The property features a balcony, free private parking and free WiFi.
This ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
★Free Parking, Free Wifi, No Resort Fees★
Brand New Split Air Conditioner in Bedrooms and Living Room will keep you cool!
Experience the serenity of Maui from the perspective of Valley Isle Resort Unit 1003. This comfortable ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
★Free Parking, Free Wifi, No Resort Fees★
Brand New Powerful Split AC will keep you cool and comfortable!
Valley Isle Unit 501 offers a comfortable and spacious retreat for up to 4 guests seeking an oceanfront escape in West ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Free Parking, Free Wi-fi, No Resort Fees
Unit 1202 at Valley Isle offers a comfortable and functional living space ideal for a small family or a couple seeking a beautiful retreat on the Maui coast. This 1-bedroom, 1-bathroom unit is ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
★Free Parking, Fee Wi-fi, No Resort Fees★
Tranquility by the Ocean: Valley Isle Resort Unit 503 Awaits
Embrace the serenity of Maui at Valley Isle Resort Unit 503, a serene 2-bedroom condo offering mesmerizing ocean views and ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
