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 '%Kahana Sunset%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Kahana Sunset Resort offers guests the ideal location to enjoy Maui. This beachfront resort is the only resort situated on the secluded, sandy beach of Keoni Nu'i Bay with pristine views of the beautiful blue Pacific. This direct oceanfront ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Lahaina
Enjoy snorkeling with the sea turtles, humpback whale watching in the winter or gazing at rainbows, this property is perfect for it all! The Kahana Sunset sits on Keonenui Bay and feels as though it has its own private beach. Conveniently ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Lahaina
Enjoy snorkeling with the sea turtles, humpback whale watching in the winter or gazing at rainbows, this property is perfect for it all! The Kahana Sunset sits on Keonenui Bay and feels as though it has its own private beach. Conveniently ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Kahana Sunset Resort offers guests the ideal location to enjoy Maui. This beachfront resort is the only resort situated on the secluded, sandy beach of Keoni Nu'i Bay with magnificent views of Lanai and Molokai. Recently remodeled, E1E is a...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Treat yourself to this direct oceanfront tropical getaway at Kahana Sunset Resort. When you enter this beautifully remodeled 2 bedroom/2.5 bath condominium, you will be immediately captivated by the breathtaking views of the Pacific ocean. ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Kahana
Enjoy snorkeling with the sea turtles, humpback whale watching in the winter or gazing at rainbows, this property is perfect for it all! The Kahana Sunset sits on Keonenui Bay and feels as though it has its own private beach. Conveniently ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Lahaina
Kahana Sunset C2C - This spacious unit is ideal for a couple or family/group of up to four people. The open concept floor plan has all of the conveniences of home. Air conditioned and fully remodeled, one bedroom / one bath.
The jewel of ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kahana
Our condo, now with Air conditioning! unit E-8, is one of 72 units in an oceanfront resort. This unit is a townhouse style with living areas on 1st floor and bedrooms/baths on 2nd floor. Kahana Sunset offers many beautiful amenities, from the ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Lahaina
Kahana Sunset is a beachfront resort on the world famous west coast of Maui, 10 minutes south of Kapalua and north of Kaanapali. You will be swimming and snorkeling with turtles and tropical fish off of the white sand beach of protected Keoni ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Lahaina
Enjoy snorkeling with the sea turtles, humpback whale watching in the winter or gazing at rainbows, this property is perfect for it all! The Kahana Sunset sits on Keonenui Bay and feels as though it has its own private beach. Conveniently ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Lahaina
Enjoy snorkeling with the sea turtles, humpback whale watching in the winter or gazing at rainbows, this property is perfect for it all! The Kahana Sunset sits on Keonenui Bay and feels as though it has its own private beach. Conveniently ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Kahana Sunset is a beachfront resort situated on the sandy beach of Keoni Nu'i Bay. This upgraded and remodeled 1 bedroom / 1 bath spacious condominium has direct ocean views. Relax on your lanai and enjoy your morning cup of coffee. Then ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Enjoy snorkeling with the sea turtles, humpback whale watching in the winter or gazing at rainbows, this property is perfect for it all! The Kahana Sunset sits on Keonenui Bay and feels as though it has its own private beach. Conveniently ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Located on the secluded and sandy beach of Keoni Nu'i Bay, Kahana Sunset Resort is the ideal beachfront Maui location. With panoramic views of the islands of Molokai and Lanai, our beach is ideal for any of your favorite beach activities - ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kahana
Kahana Sunset B9 is an upgraded oceanview air-conditioned two bedroom / two bath condominium with spectacular views of the Pacific from both the living room and master bedroom lanai. Air Conditioning is available and is optional - $25.00 per ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kahana