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 '%Napili Point%') AND sleeps>=1 order by rating desc LIMIT 0, 30
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
Hawaii> Napili
After the Lahaina fires, Napili Point Resort is now fully operational again. There is still lots on Maui to visit, experience and enjoy! We need your help by visiting us as we greatly rely on tourist dollars!
Honokeana Cove is one of ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Villa B39 is a prime oceanfront ground-level location at Napili Point steps to Napili Bay, offering striking ocean views, easy access, and air conditioning for your comfort. The lanai is the perfect spot for turtle and whale watching, and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Do you want to enjoy paradise? Make memories as beautiful as the sunsets? Enjoy beautiful sunsets, walking on the beach, smelling tropical flowers, looking at breathtaking scenery, being one with nature? If so, you will want to book this ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina, Maui
WOW! Spectacular Ocean and outer island views. Your oceanfront patio is just steps away from the beautiful Honokeana Cove (commonly called turtle cove), which lends to excellent and safe snorkeling on most days. Sip on your Mai Tai, take a deep...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
If you can't wait to get under the water and gaze at neon tropical fish and brilliantly colored coral, stay here in this 955-square-foot, 2-bedroom, 2-bathroom, oceanfront villa on Napili Bay. You'll be just steps from the beach and two ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
A PREMIER PROPERTY - VIEWS! VIEWS! Panoramic Ocean Views - Private Turtle Cove and Secluded Pools Big Ocean Views!
Perched perfectly on Honokeana Cove ("Turtle Cove") enjoy coffee from your lanai watching then jump in for a swim or snorkel ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> Lahaina, Maui
BEST VALUE 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
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
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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
villa C42 is a prime oceanfront second level location at Napili Point with very close proximity to Napili Bay, offering striking ocean views. The lanai is the perfect spot for turtle and whale watching. Fabulous snorkeling is just steps away. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Villa C43 is a prime oceanfront second level location at Napili Point with very close proximity to Napili Bay, offering striking ocean views. The lanai is the perfect spot for turtle and whale watching. Fabulous snorkeling is just steps away. ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Condo, 1 Bedroom (King size bed + pull out couch + Convertible sofa bed), 1 Bath, (Sleeps up to 4 - maximum 2 adults)
The big pool is just outside our glass doors and beautiful Napili Bay beach is just few minutes walking ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Napili Point on famous Napili Bay
2 bedroom, 2 bath codo with incredible ocean and island views.
Swimming Pool
Between Napili and Kapalua with restaurants and shops within walking distance
Washer and dryer in unit
Free parking, no...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Welcome to your dream vacation getaway! This beautiful one bedroom condo is located right next to the pool, beach, and many other amenities, making it the perfect spot for relaxation and fun.
As you enter the condo, you are greeted with a...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili-Honokowai
Napili Point on famous Napili Bay - 1 bedroom, 1 bath remodeled with new furniture.
Breathtaking ocean views
AC
Two oceanfront swimming pools
Gas BBQ Grills and picnic tables on site
Oceanfront lawn
Washer and dryer
Free ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
villa C18 is a prime oceanfront second level location at Napili Point with very close proximity to Napili Bay, offering striking ocean views. The lanai is the perfect spot for turtle and whale watching. Fabulous snorkeling is just steps away. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Napili Point B42 has it all - remodeled, spacious, air-conditioned, single level floor plan. From your lanai, you'll experience breathtaking views of the pristine waters of the Pacific - feel a sense of serenity as you listen to the gentle surf...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili
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
Hawaii> Napili, Lahaina
This 1 of a Kind Napili Villa C37 is a prime oceanfront second level location at Napili Point with very close proximity to Napili Bay, offering striking ocean views. This unit is unique as both bedrooms are on the same floor. No Stairs in the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Villa B43 is a prime oceanfront ground level location at Napili Point with very close proximity to Napili Bay, offering striking ocean views. The lanai is the perfect spot for turtle and whale watching. Fabulous snorkeling is just steps away. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Welcome to Napili Point B35 nestled in the heart of Napili. This exquisite one-bedroom, one-full bath retreat offers the perfect blend of comfort, convenience, and breathtaking ocean views.As you step into the tastefully decorated living area, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Fully furnished 1 Bedroom 1 Bathroom Condo, Air Conditioned, upgraded kitchen, with pull out Queen mattress couch bed. Over looking Turtle Cove and just steps from Napili Beach, and Seashouse restaurant on Napili Bay....
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina