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 Bay Resort%') AND sleeps>=1 order by rating desc LIMIT 0, 20
***NEWLY REMODELED*** Best Beachfront Location! This is Hawaii the way you dream about it. No building taller than a tree on Napili Bay!
Swim, surf, snorkel, whale watch and glorious sunsets without leaving the property.
30 ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
*******REMODELED******* Best Beach View Location! This is Hawaii the way you dream about it. No building taller than a tree on Napili Bay.
Swim, surf, boogie board, stand up paddle, snorkel, seasonal whale watching and glorious sunsets ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
The Napili Bay Resort Unit 111 is a ground level studio right on the shores of Napili Beach. Immerse yourself in the tranquility of this crescent-shaped beach, celebrated for its calm, crystal-clear waters. Ranked among Maui’s top two beaches ...
- 0 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahain
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 Bay Resort condo 217 is a perfect, serene retreat with stunning views and easy beach access. Guests praise the comfortable bed, well-stocked kitchen, and thoughtful extras like beach chairs and welcome baskets. The lanai offers a ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Napili Bay Resort Condo 211 offers a serene getaway with convenient beach access and stunning ocean views. Guests appreciate the clean, well-appointed unit, comfortable king-size bed, and fully equipped kitchen. Enjoy the peaceful atmosphere, ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Napili Bay Resort condo 105 offers an unbeatable beachfront location with stunning ocean views and direct beach access. Guests love the well-equipped kitchen, comfortable bed, and thoughtful amenities like beach chairs and boogie boards. The ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Best Beachfront Location! This is Hawaii the way you dream about it. No building taller than a tree on Napili Bay.
Swim, surf, boogie board, snorkel, whale watch and glorious sunsets without leaving the property.
30 seconds ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Napili Bay Resort Condo 216 is ideal for couples, just steps from a beautiful beach. Guests praise its excellent location, quiet garden view, and cozy Old Hawaii vibe. The studio is well-equipped, with comfortable furnishings, beach gear, and a ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Beachside/Ocean view condo 212 is only 15 steps away from the beautiful white sand beach of Napili Bay. Away from the hassle and congestion of high rise resorts, the bay is perfect for swimming, snorkeling, and just plain relaxing in the sun or ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
