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 '%Honokeana Cove%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Whether your idea of the perfect Hawaii vacation includes snorkeling, surfing, scuba diving, cycling, golfing, swimming, kayaking, hiking, fishing, tennis, or just relaxing by the pool with a good book and a frosty tropical drink, Napili Point ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Unit 203 is a 2nd floor, Northwest facing unit that enjoys shade year round on the lanai that directly overlooks the cove with turtles, the heated pool, and a spectacular view of the island of Molokai in the distance as well as Humpback whales ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
. . . . WELCOME! Enjoy Old Hawaii “Aloha” in modern comfort. #114 is a ground floor 1-bedroom oceanfront condo in the most romantic spot of West Maui. Your condo opens directly onto a landscaped lawn with heated swimming pool & BBQs. Your ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Oceanfront Honokeana Cove 2 Br / 2 Ba Ground Floor End Unit. You are just a few steps to the ocean for awesome snorkeling with an abundance of green sea turtles, or swimming in the heated pool, cooking on the oceanfront gas BBQs, watching ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
Beautifully furnished for Welcoming Ambience, this Second Floor unit features Bamboo and Teak cabinets and Hawaiian Art. Lovely views of Molokai and Surf breaking across the Point leading into our peaceful snorkeling Cove.
2nd floor Unit. ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
Oceanfront 2 Bedrm / 2 Bath Ground Floor Unit with Fully equipped Kitchen. Superb location within the complex . Offers spectacular views and only steps away from the Pool and the Best Snorkeling on Maui! Nestled in a private cove, with a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
Honokeana Cove is in Napili, West Maui, just 8 miles north of historic Lahaina Town. The gated property surrounds a secluded cove with a breathtaking view of the nearby island of Molokai from every unit. Experience Old Hawaii in one of these 38 ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Honokeana Cove is in Napili, West Maui, just 8 miles north of historic Lahaina Town. The gated property surrounds a secluded cove with a breathtaking view of the nearby island of Molokai from every unit. Experience Old Hawaii in one of these 38 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Honokeana Cove is in Napili, West Maui, just 8 miles north of historic Lahaina Town. The gated property surrounds a secluded cove with a breathtaking view of the nearby island of Molokai from every unit. Experience Old Hawaii in one of these 38 ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Honokeana Cove is in Napili, West Maui, just 8 miles north of historic Lahaina Town. The gated property surrounds a secluded cove with a breathtaking view of the nearby island of Molokai from every unit. Experience Old Hawaii in one of these 38 ...
- 3 bedroom
- 2 bathroom
- Sleeps 7
HI> Lahaina
The view from the lanai of Unit #207 is spectacular and one of the best in the complex. The king size bed is new as is the sleeper sofa bed. The very large mirror in the living room gives a feeling of spaciousness. The location is very private...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Beautiful 2nd Floor Unit. Loft bedroom with Queen bed, downstairs bedroom with with 1 King bed (can be made into 2 Twin beds upon request). Nearly 180 degree view of the Cove. Whale watch from your Lanai (in season) and a guaranteed swim with ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
This beautifully appointed 2nd floor condo has a King bed in the loft bedroom and a Queen bed in the lower bedroom.
Each condo has a lanai overlooking Cove itself, the grassy lawn, the tropical gardens, the heated pool. Tiki torches, located ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
