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, 30
One of the best views on Maui, this 3 bedroom/ 2 bathroom oceanfront condo is as close to the ocean as you can possibly get - literally a few steps away! Our condo is one of the very few that has a breathtaking, unobstructed ocean view where you...
- 3 bedroom
- 2 bathroom
- Sleeps 7
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
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
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 steps from ...
- 3 bedroom
- 3 bathroom
- Sleeps 9
Hawaii> Lahaina
One of the best views on Maui, this 3 bedroom/2 bathroom oceanfront condo is as close to the Pacific Ocean as you can possibly get - literally a few steps away! Our condo is one of the very few that has an unobstructed ocean view where you can ...
- 3 bedroom
- 2 bathroom
- Sleeps 9
Hawaii> Lahaina