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 '%Kahana Outrigger%') AND sleeps>=1 order by rating desc LIMIT 0, 20
You can't get closer to the Pacific Ocean than this! Situated on the West edge of Maui between the world-renowned golf course at Kapalua and the world-famous beach of Ka'anapali, you are perfectly positioned to access Maui's top beaches, golf ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
You can't get closer to the Pacific Ocean than this! Situated on the West edge of Maui between the world-renowned golf course at Kapalua and the world-famous beach of Ka'anapali, you are perfectly positioned to access Maui's top beaches, golf ...
- 3 bedroom
- 2 bathroom
- Sleeps 9
Hawaii> Lahaina
Home away from home is the only good description of our "condo" in Kahana. Fantastic sunsets, outstanding views in all directions, romantic moonlit nights and whale watching (in season) are all to be expected at our Kahana Outrigger vacation ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
This 3 bedroom, 2 bath, 2 story loft style (closed off with windows) unit has its master bedroom and newly remodeled bathroom in the loft with rain shower head in a walk in tiled shower overlooking the living room. Entry, kitchen and dining ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Welcome to Kahana Outrigger 2B2 stunning condo in West Maui, where breathtaking ocean views and spacious accommodations await you. This 3-bedroom, 2-bathroom retreat is the perfect haven for your family to unwind and create lifelong ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
★Maui's Secluded Paradise: Your Spacious Beachfront Escape★
Nestled on the sunny west coast of Maui, this private haven awaits in Kahana, between the famed Kaanapali and Kapalua resorts. This property offers a tranquil escape, mere ...
- 3 bedroom
- 3 bathroom
- Sleeps 9
Hawaii> Lahaina
