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, 20
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 ...
- 1 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 ...
- 0 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 ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
★Free Parking, Free Wifi, No Resort Fees★
Brand New Powerful Split Air Conditioner will Keep you Cool!
Your Maui Dream Starts Here: Ground Floor Paradise at Valley Isle Resort Unit 101
Escape to paradise in Valley Isle ...
- 1 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 ...
- 1 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Lahaina
Book 5 nights and enjoy the 6th night free! Valid for new reservations from 10/15/24 for stays between 10/15/2024 - 11/21/2024!
This spectacular 2 bedroom/2bath upgraded condo is directly oceanfront on the 7th floor just steps to the ...
- 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Experience direct oceanfront living from the finest Penthouse offering at Valley Isle Resort in Kahana, Maui- introducing Residence #804 offered by the Stice Team of Hawaii Life Vacations. Experience Jaw dropping, unobstructed views of the vast ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
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, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Spacious ocean front studio, #806 at the Valley Isle Resort on the beach in Kahana. Enjoy the convenience of a fully equipped kitchen as well as all the comforts and conveniences of home. Wake up to the sound of the ocean waves and enjoy your ...
- 0 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
Make the most of your stay between September 5th, 2024 and November 21st, 2024, with our exclusive offer! Book 6 nights and enjoy the 7th night free, plus complimentary late check-out to savor every moment of your getaway. Don't miss this ...
- 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...
- 0 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
This is a legally permitted vacation rental and hotel zone according to the County of Maui ordinances.
Welcome to our stunning 1-bedroom, 1-bathroom condo in Kahana, Maui. This newly renovated property offers expansive ocean views that ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2024 and receive a 4-door rental car from one of our major rental car agency partners. The Car is complimentary, you pay only ...
- 2 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 ...
- 2 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. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
