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 (city = 'napili' OR postalCode = 'napili' OR region like '%|napili|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Wake up each morning and enjoy a breakfast filled with tropical fruit and fresh island coffee on your private lanai in this completely remodeled and everything new ( April 2021) studio accommodations - great Napili Beach Vibe! C-119 is ...
- 0 bedroom
- 1 bathroom
- Sleeps 3
HI> Napili
This complex is subject to Hawaii State Covid-19 rules and regulations and CDC recommendations concerning social distancing and cleaning procedures. These rules and recommendations regarding amenity usage are subject to changes and limitations ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Napili
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
HI> 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 apparent in ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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 5
HI> 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
HI> Napili
G-257 AT NAPILI SHORES RESORT - Come and enjoy a true Hawaiian escape awaits you at this lovely upgraded ocean view air conditioned Napili Shores Resort studio condominium.
Located on the beautiful and tranquil Napili Bay, this second floor ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> 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
HI> 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
HI> 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 3
HI> 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 4
HI> Napili
Napili Shores Resort H-267
Perfect for family vacations, this air conditioned one bedroom / one bath ocean view second floor unit in the H building at Napili Shores Resort is the ideal location to enjoy your Maui vacation. This unit comes with...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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 only ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Napili
Napili Gardens is a charming property with only 16 three bedroom townhomes located across the street from Napili Kai Beach Resort on pristine Napili Bay. There is a 2 car enclosed garage on ground level. The main level has open kitchen, dining ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> 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
HI> Napili