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 Shores%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Located on the south end of Napili Bay, a protected, crescent-shaped, white-sand beach with breathtaking views of Moloka'i and Lana'i islands, Napili Shores Resort is the ideal location for your Maui vacation. H268 is a lovely upgraded ...
1 bedroom
1 bathroom
Sleeps 4
HI> Lahaina
BEACHFRONT ON MAUI... A206 AT NAPILI SHORES RESORT! Located directly on gorgeous Napili Bay on West Maui with 240-degree view of the water and spectacular West Maui sunsets. There is practically no better view or location on the island!!! Brand...
0 bedroom
1 bathroom
Sleeps 3
HI> Lahaina
Beautiful, air-conditioned 2nd floor Studio Condo with vaulted ceilings and a wonderful airy feel at the famous Napili Shores Resort.
The condo is light and bright and features fully equipped kitchen with granite counter tops, a private lanai,...
1 bedroom
1 bathroom
Sleeps 3
HI> Lahaina
Spend your next getaway in our tropical retreat in Maui! Conveniently located next to the ocean and the gorgeous beaches, you'll have everything you need for a warm and sunny escape. Discover the beautiful surroundings or unwind by the ocean ...
0 bedroom
1 bathroom
Sleeps 3
HI> Lahaina
Fabulous, GROUND FLOOR studio condo with ocean view, and air conditioning now available to rent at Napili Shores! Napili Shores is an ultra popular, meticulously managed and maintained, oceanfront resort featuring two immaculate swimming pools ...
0 bedroom
1 bathroom
Sleeps 2
HI> Lahaina
Come get away to the island of Maui and to Napili Shores Resort.
****COVID-19 testing requirements are fluid, so please visit online the Hawaii Government website to determine if you need a test before your departure to Maui. Additionally, you...
1 bedroom
1 bathroom
Sleeps 4
HI> Lahaina
Located on the south end of Napili Bay, a protected, crescent-shaped, white-sand beach with breathtaking views of Moloka'i and Lana'i islands, Napili Shores Resort is the ideal location for your Maui vacation.
Pride of ownership apparent in ...
1 bedroom
1 bathroom
Sleeps 4
HI> Napili
Napili Shores Resort offers luxurious condominiums in the tropical paradise of Napili Bay. The resort is located on six beautifully landscaped acres and has two pools and two restaurants on the property. It's a getaway spot you won't soon ...
1 bedroom
1 bathroom
Sleeps 3
HI> Lahaina
NAPILI SHORES RESORT is a 152-unit, low-rise, condominium complex located on the west coast of Maui, ten miles north of Lahaina and four miles north of Kaanapali... offering two outdoor swimming pools (one is heated), hot tub, two restaurants, ...
1 bedroom
1 bathroom
Sleeps 2
HI> Napili Bay, Lahaina
All guests are required to pay a $75 resort fee ( for key and parking pass ) upon check in directly to Outrigger Napili Shores.
Relax and take in the majestic beauty of this One-Bedroom stunning Ocean and Sunset view condo resort. This ...
1 bedroom
1 bathroom
Sleeps 5
HI> Lahaina
Napili Shores offers a breathtaking view of the sunset over Molokai from one of Maui's finest beaches. Cooled by gentle island breezes, this one bedroom condo has an updated full kitchen, split AC system (bedroom & living room), ceiling fans and...
1 bedroom
1 bathroom
Sleeps 4
HI> Lahaina
Stunningly fabulous, air-conditioned 2nd Floor Studio Condo, now available to rent at Napili Shores! Napili Shores is an ultra popular, well-managed and maintained oceanfront resort featuring two immaculate swimming pools set atop lush tropical...
0 bedroom
1 bathroom
Sleeps 2
HI> Lahaina
Home away from home in a location unlike any other! A one-of-a-kind unit, this ground floor, non-smoking, ocean view studio will provide the relaxation you're looking for. Watch the surf while you sip your complimentary morning coffee on the ...
0 bedroom
1 bathroom
Sleeps 2
HI> Lahaina
Napili Shores D-125 is perfect for your Maui vacation. The lanai of this ground floor Napili Shores studio condominium extends into the grass and landscape of Napili Shores Resort. You are only a few steps to the white sand beach that border ...
0 bedroom
1 bathroom
Sleeps 3
HI> Lahaina
Gorgeous condo with a direct Ocean Front View, air-conditioned Ground Floor Studio Condo now available to rent at Napili Shores! Napili Shores is an ultra popular, well-managed and maintained oceanfront resort featuring two immaculate swimming ...
0 bedroom
1 bathroom
Sleeps 2
HI> Lahaina
