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, 50
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
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...
- 3 bedroom
- 2 bathroom
- Sleeps 6
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....
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Immerse yourself in the enchanting beauty of Maui from this incredible oceanfront Napili location. Dive into the inviting waters to swim alongside majestic sea turtles in the stunning Honokeana Cove, just a few feet from your doorstep, or walk ...
- 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
K B M Resorts: Napili Point NAP-B39; Stunning 1-Bedroom Ocean Front Villa, Prime Location & Turtle Views!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2025 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili-Honokowai
K B M Resorts: Napili Point NAP-C43; Free Rental Car, The Best Ocean Front 2 Bedroom Beautifully Remodeled!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
K B M Resorts: NAP-C42 Free rental car, Gorgeous 2 Bedroom, ocean view, easy access to parking, pool and beach!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15,...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Nestled on Kaelekii Point overlooking Honokeana Bay on West Maui, this clean, modern, and spacious one bedroom one bath condo showcases vast ocean views and year-round sunsets from the kitchen, living room and lanai. The bathroom features a dual...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
This is a legally permitted vacation rental and hotel zone according to the County of Maui ordinances. ✅
Oceanfront Paradise with Stunning Views, Snorkeling, and Modern Comforts
E Komo Mai! (Welcome to Our Home) Experience the ...
- 2 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...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
K B M Resorts: Napili Villa NAP-C18, Ocean Front Spacious 2B/2B, L'Occitane, Beach & Kid Amenities, Fantastic Location, Snorkeling & Turtles!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an ...
- 3 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...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili-Honokowai
This property is hotel zoned, and not being affected by the recent proposed legislation.
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, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
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 in late 2024 to the condo including all new tile flooring throughout the unit along with ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Napili, 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
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
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
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
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
K B M Resorts: Napili Point NAP-A25; Stunning 1-Bedroom Ocean Front Villa, Prime Location & Turtle Views!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2025 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Spectacular Ocean & Outer Island views from your Air Conditioned ground floor condo at The Napili Point! This spacious 1 Bed 1 Bath, plus sofa bed, has everything to make you feel right at home in Maui.
Enjoy snorkeling with Sea ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
FREE rental car with booking! Charming ocean view 1 bedroom, Napili Bay condo. This condo offers a modern, fully equipped kitchen and private lanai.
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili-Honokowai
