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 '%Napili Point%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Enjoy breathtaking views from this newly remodeled ocean front one bedroom condo at the highly sought out Napili Point Resort. Watch breaching whales cavort right in front of your reef front condo. Capture brilliant sunsets over Lanai and ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Napili Point, Unit A-2 is located on Maui's western shore. This fully-equipped one-bedroom ground-floor condo (sleeps four) offers beautiful views of the Pacific Ocean from the lanai and living room, with the islands of Molokai and Lanai in ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Napili
A PREMIER PROPERTY - VIEWS! VIEWS! Panoramic Ocean Views - Private Turtle Cove and Secluded Pools Big Ocean Views! Turtle Cove Cabana is currently being renewed with new furnishings and we're so excited for you to enjoy the fresh, tropical ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Napili Point Resort is located on the Northwest side of Maui a few miles north of Kaanapali and Lahaina. It is away from the highly populated resorts, but close enough to enjoy it. The condo is West-facing on Honokeana Cove and looks out ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
BEST RATE AT NAPILI POINT
Our Napili Point condo is located in one of the most prestigious areas in Maui. Bounded by beautiful Napili Bay to the north and overlooking Honokeana Cove to the south, Napili Point Resort is the consummate oceanfront...
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Lahaina
Do you enjoy beautiful sunsets, walking on the beach, smelling tropical flowers, looking at breathtaking scenery, being one with nature? Want to enjoy paradise? Make memories as beautiful as the sunsets? If so, you will want to book this ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina, Maui
Condo, 1 Bedroom (King size bed + pull out couch + Convertible sofa bed), 1 Bath, (Sleeps up to 5 - maximum 2 adults)
The big pool is just outside our glass doors and beautiful Napili Bay beach is just few minutes walking distance.
This ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
HI> Lahaina
Napili Point is a meticulously maintained low rise building and grounds that nest on Honokeana Cove home to some of the best snorkeling, diving, swimming, and surfing that Maui has to offer. The luxurious and understated classic Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
CORNER ONE BEDROOM CONDOMINIUM, NEWLY REDECORATED, ALL THE AMENITIES OF HOME. POOL NEARBY. DRINK YOUR COFFEE ON THE LANAI, WHILE WATCHING THE WHALES. GO FOR A SNORKEL EXCURSION IN HONOKEANA BAY JUST BELOW, THEN SPEND YOUR AFTERNOON ON ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Napili-Honokowai
If the calendar for C20 is not available for your dates, please look at the availability for C25 VRBO #641701.
We recently made some major upgrades to the condo including new mattresses and bedding, kitchen supplies and small appliances, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Napili, Lahaina
If the calendar for C25 is not available for your dates, please look at the availability for C20, VRBO#254292.
Brand New ICE COLD Air Conditioning throughout the condo, just installed in October 2021.
We recently made some other upgrades to the...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Perched above Honokeana Cove, the home for a tropical paradise of green sea turtles and a multitude of brightly colored tropical fish swimming throughout the coral, is A-26, a condominium within Napili Point Resort. The spectacular views from ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
