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 '%Valley Isle%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Ocean front in Kahana. Restyled & updated decor make this 8th floor 1 bedroom a treat for the discerning vacationer. Watch movies on the 32" flat screen TV in the ocean front living room. The bedroom has a 26" flat screen. The tiled & glass ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
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
HI> Lahaina
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
HI> Kihei
Our condominiums are located on a fabulous piece of paradise, on the beach less than 50 feet from the ocean's soothing waves. Fall asleep to the sounds of the ocean. Step out onto your own private lanai for a cup of coffee or a glass of wine.
...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
This is a stunning corner unit on the 11th Floor of the Valley Isle Resort. It has extra windows and boasts a stunning panoramic view from the kitchen, bedroom, and living room. The condo was recently upgraded with new flooring and has been ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
This is a one bedroom oceanfront corner unit located at the Valley Isle resort in West Maui. It boasts wonderful unobstructed views of the ocean and neighboring islands of Lanai and Molokai. There is plenty of marine life at your doorstep year ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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
HI> Lahaina
This spectacular 2 bedroom/2bath upgraded condo is directly oceanfront on the 7th floor just steps to the beach, conveniently located on Maui's West Coast just minutes from Lahaina Town between Kaanapali & Kapalua. This unit has breathtaking ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Calling all Ocean Lovers! Penthouse: corner ocean front with exquisite sunset views in Kahana. New flooring, new king sized bed and other upgrades as of November 2020. Enjoy ocean front views from the lanai off of the living room and master ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
All the bells and whistles await your arrival at Maui’s Valley Isle Resort. A luxurious 1 bedroom with King-size Bed & 1 bath oceanfront condo with queen sofa bed in living room on a sandy beach that begs your snorkeling adventure. There are...
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Lahaina
Ocean front in Kahana and only a few minutes walk to sandy beach. Short drive to Kaanapali and Lahaina. Kapalua and Napili bays are just up the street! Walking distance to many shops, eateries and also our wonderful farmers market. In ...
- 1 bedroom
- 0 bathroom
- Sleeps 4
HI> 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 some ...
- 0 bedroom
- 1 bathroom
- Sleeps 3
HI> Lahaina
Corner ocean front condo with panoramic ocean views in Kahana. Enjoy ocean front views from the lanai off of the living room and master bedroom. A flat screen TV coupled with the DVD player keeps you entertained in the evenings.Bring your laptop...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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
HI> 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
HI> Lahaina
