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, rewritten_description,
(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 (city = 'napili' OR postalCode = 'napili' OR region like '%|napili|%') 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
Welcome to West Maui's best-kept secret - The Residences at Napili Bay! Get ready to experience an unforgettable vacation in this hidden gem, just steps away from one of Maui's favorite beaches - Napili Bay.
Behind a private gate, you'll
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Napili
Welcome to our little piece of paradise at Napili Bay #210. This studio unit provides you with the comforts of home while being located right on wonderful Napili Bay Beach. It has a galley style kitchen, full bathroom, living area that sleeps
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Napili
Napili Shores Resort H-167 - 1BD/1BA
Perfect for family vacations, the lanai of this air-conditioned ground floor one bedroom / one bath Napili Shores condominium extends into the grass and landscape of Napili Shores Resort. You will be
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili
Newly remodeled oceanfront studio at Napili Shores Building A 204 with sweeping views of beautiful Napili Bay. A few steps to the white sand beach of Napili which has been named the most beautiful beach in the world by Travel and Leisure 2017.
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Napili
Spoil Yourself in this one of a kind ocean/sandy beach front Corner Unit with a wraparound balcony hanging over the ocean at the front and what seems like a 'private' sandy swimming beach at the side. (An end corner Unit) This is NOT a
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Napili
Napili Shores Resort is located on the south end of the gorgeous sandy beach of Napili Bay. A one-of-a-kind unit, this ground floor, non-smoking, ocean view G building studio is the ideal location for a peaceful Maui vacation. You will enjoy
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Napili
Napili Shores Resort I-173
From breathtaking sunset views of the islands of Molokai and Lanai to the gentle sounds of the surf lulling you deeper into 'Polynesian Paralysis.' The "I" building at Napili Shores is a place you will remember
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Napili
Relax and enjoy your Maui vacation at Unit #112 Napili Bay Resort! The beach is right outside your door-just steps away! Our privately owned condo has a beautiful ocean view of Napili Bay and the beach. You can also see the islands of Molokai
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili
Located in the H building of Napili Shores Resort, this spacious one-bedroom condominium is the ideal location for a peaceful Maui vacation. Napili Shores Resort is situated on the crescent-shaped Napili Bay. Enjoy your private lanai where you
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Napili
Spectacular views of the Pacific from Napili Shores B-109, an air-conditioned first floor one-bedroom/one-bath condominium overlooking a lush tropical oceanfront setting. You are only a few steps to the water's edge and will enjoy the ocean's
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili
Escape to Napili Bay 104, a breathtaking oceanfront studio that redefines your idea of paradise. Nestled directly on the pristine Napili Bay Beach, this stunning retreat effortlessly blends modern luxury with coastal charm, making it the
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Napili
Napili Shores Resort H-166
Full remodel taking place Summer 2024 - new kitchen and bathroom, updated furnishings ... be the first to enjoy the brand new space!
Perfect for family vacations, the lanai of this ground floor 1-bedroom
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili
Napili Shores Resort G -156 is an ocean view and air conditioned ground floor studio. This G building ground floor Napili Shores studio condominium extends into the grass and landscape of Napili Shores Resort.
Napili Shores G-156
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Napili
Located on the second floor of F building at Napili Shores Resort, this spacious one bedroom / one bath condominium with private lanai is the ideal place for a peaceful Maui vacation. Napili Shores Resort is adjacent to the gorgeous sandy beach
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili
This property is only available for long-term rental with a minimum 6 month lease.
Welcome to Napili Beach House, a Maui luxury vacation home that stands above the rest. Boasting awe-inspiring views of Napili Bay and the island of
- 8 bedroom
- 10 bathroom
- Sleeps 24
Hawaii> Napili
Welcome to Napili Shores E135, a stunning ground-level 1 bedroom 1 bathroom condo nestled in the heart of Napili featuring a garden view and split AC system. This condo sleeps up to 4 guests. This resort does not have elevators.
The
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili
