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 Reef%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Recent Comment from guest: "We have decided this is our favorite condo! We love the layout of the floor plan and the kitchen is well appointed. The utensils and dishes are in good shape. We have been in condos where the utensils were rusted and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Completely remodeled Kahana Maui vacation condo with direct oceanfront views. Updates include new marble floors throughout (excluding bedroom), kitchen cabinets and appliances, imported Brazilian granite countertop, marble bathroom, carpeting in...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
This private suite offers a bright and airy floorplan. With sweeping, direct ocean front views facing the islands of Lanai and Molokai. Tastefully renovated, offering 1 bedroom, 1 bathroom suite. Fully equipped kitchen complete with granite ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Deluxe remodeled vacation condo with ocean front views. Face-lift in Summer '12 included remodeled bathroom with tiled walk-in shower, new cabinetry and granite counters. Carpet replaced with new tile throughout condo including lanai. Bring your...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Enjoy the many shades of blue that sparkle below. This oceanfront unit sleeps up to four people with a queen bed in the bedroom and a pull out sofa bed in the living room. The furnishings are a mixture of rattan and tropical accents. The ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> LAHAINA
Hurray...after three years, construction on the sea wall is complete with new landscaping, new steps to the ocean and beach. It looks beautiful. Also, because of COVID-19 we have updated our cleaning process to include complete sanitation of ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
This recently updated, direct Ocean Front 1 bedroom, 1 bathroom condo in West Maui is perfect for you! This private, top floor suite at Kahana Reef offers a bright and airy layout, with direct oceanfront views facing the islands of Lanai and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
This top floor, private, corner suite offers sweeping, direct oceanfront views facing the islands of Lanai and Molokai. Kahana Reef 422 is a tastefully renovated 1 bedroom, 1 bathroom suite, that offers extra side windows, to let in additional ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Direct oceanfront views of the Pacific Ocean and the neighboring island of Molokai from this ground floor one-bedroom vacation rental located in Kahana area of W. Maui. This vacation condominium features a remodeled kitchen and bathroom with ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> LAHAINA
Ocean Front Views!! Gorgeous Ocean Front views from this one-bedroom Condo. This unit sleeps up to four people with a king bed in the bedroom and a pull out sofa bed in the living room. The furnishings are a mixture of rattan with tropical ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> LAHAINA
Modern and contemporary designs, furnishings and accents complement this completely renovated, and newly updated, Kahana vacation rental. No detail was missed in this well-appointed condo. The fully equipped kitchen is completely open to the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> LAHAINA
Ground floor Ocean Front One Bedroom Condo. This unit is next to the pool and has a beautiful sunbathing spot in front of the lanai. The bedroom has a king bed and the living room has a pull out sofa bed, allowing this unit to sleep up to four ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> LAHAINA
***Please inquire before booking. Dates are not confirmed until Owner/ Manager sends confirmation. Calendars are not live or accurate due to multi agents and units.***
*TRIP INSURANCE IS HIGHLY RECOMMENDED. Please let us know if you are ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> Lahaina
Located ground floor and on the ocean front in Kahana, this 1 bedroom, 1 bath fully equipped condo has all you will want and or need for the quiet Maui vacation. The living room contains a window/portable a/c . Walk right out to the ocean front...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
***Please inquire before booking. Dates are not confirmed until Owner/ Manager sends confirmation. Calendars are not live or accurate due to multi agents and units.***
*TRIP INSURANCE IS HIGHLY RECOMMENDED. Please let us know if you are ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
