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 (`headline` like '%Napili Bay Resort%') AND sleeps>=1 order by rating desc LIMIT 0, 15
The Napili Bay Resort, located just North of Lahaina Town Center, and one bay South of Kapalua Bay which is considered by many to be the best location in Maui.
Unit 206 is located on the second floor of the Napili Bay Resort near the center of...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
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, snorkel, whale watch and glorious sunsets without leaving the property.
30 seconds from the ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
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
Best beach view location in Maui with sunset views year rounds. Only 30 steps to the beach. Fall asleep to the soothing sounds of the ocean while cool trade winds caress your skin.
1 Minute from Blender to Beach
Private Top Floor Corner Condo...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
The Napili Bay Resort, located just North of Lahaina Town Center, and one bay South of Kapalua Bay which is considered by many to be the best location on Maui.
Unit #114, located on the ground floor (1st door, corner unit) of the Napili Bay ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> 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 from the ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> 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 from the ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina