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, 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
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
Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2024 and receive a 4-door rental car from one of our major rental car agency partners. The Car is complimentary, you pay only ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2024 and receive a 4-door rental car from one of our major rental car agency partners. The Car is complimentary, you pay only ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2024 and receive a 4-door rental car from one of our major rental car agency partners. The Car is complimentary, you pay only ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
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
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
This is a legally permitted vacation rental and hotel zone according to the County of Maui ordinances.
E Ko Mo Mai (Welcome to our Home)
Napili is one of the best-kept secrets of West Maui. Situated just South of Kapalua. Napili ...
- 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
Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2024 and receive a 4-door rental car from one of our major rental car agency partners. The Car is complimentary, you pay only ...
- 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
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 to the condo including new mattresses and bedding, kitchen supplies and small appliances, ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Napili, Lahaina
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
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
