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 '%Honokeana Cove%') AND sleeps>=1 order by rating desc LIMIT 0, 30
. . . . 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
Hawaii> 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> 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
Hawaii> Lahaina
BEAUTIFUL REMODEL TO THIS VACATION RENTAL
Beautifully remodeled(11/22) for welcoming ambience, this newly updated second floor unit is light and bright, featuring bamboo and teak cabinets, LVP flooring, and updated furnishings for your ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> 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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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 6
Hawaii> 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
Hawaii> Lahaina
Visit A-6, and the Napili area, untouched by the wild fire that devastated Lahaina Town! We are fully operational and need tourists to support our employees, several of whom have lost everything! We welcome you!
At the tip of ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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
Hawaii> 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...
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> 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 ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> 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, ...
- 1 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Lahaina
