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 (city = 'napili' OR postalCode = 'napili' OR region like '%|napili|%') AND sleeps>=1 order by rating desc LIMIT 0, 20
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 ...
- 3 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 ...
- 0 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...
- 1 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...
- 0 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 ...
- 0 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 ...
- 0 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
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
Discover the perfect oceanfront escape at this newly remodeled studio condo, nestled directly on the renowned Napili Bay Beach. With a 2020 full remodel, this cozy retreat boasts a refreshing "coastal comfort" theme, ideal for two guests. Enjoy ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
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 ...
- 0 bedroom
- 1 bathroom
- Sleeps 3
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
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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili
Wake up each morning and enjoy a breakfast filled with tropical fruit and fresh island coffee on your private lanai in this completely remodeled studio accommodations - great Napili Beach Vibe! C-119 is specifically designed for you to relax ...
- 0 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Napili
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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Napili
Welcome to Papaua Paradise, your oceanfront home in West Maui. Experience the beauty of the Pacific Ocean right outside your door with panoramic views of neighboring Moloka’i and Lana’i. Enjoy the sunset from the large lanai and explore the ...
- 5 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Napili
Ocean View air conditioned Napili Shores Resort G-256. With Breathtaking views of the Pacific, Molokai, and Lanai, Napili Shores Resort is known for its spectacular oceanfront setting and its proximity to one of the Maui's premier beaches: ...
- 0 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Napili
Napili Shores Resort I-170
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 ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Napili
