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 '%paki maui%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Welcome to Paki Maui 324! Located on the North end of Kaanapali Beach, this condo offers a breathtaking ocean view from not only one, but two lanais. Enjoy the ocean from either the master bedroom lanai or the lanai off the living room! ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
Just steps from the Sea ~ Beautifully Remodeled and Spacious 2 Bdrm/2 Bath at Paki Maui ~This second floor 2 bedroom, 2 bath condo is located at the Ocean front resort of PAKI MAUI in Honokowai. Just 5 minutes north of Kaanapali and just south ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
This property is currently for sale. If applicable, the property manager will contact you to make arrangements to schedule showings at a convenient time.
Paki Maui 313 is a one-bedroom, one-bathroom oceanfront resort located at the north end of...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Ocean front views in our Paki Maui vacation condo in Honokowai, one floor up from ground level. Our Paki Maui condo is remodeled with tile throughout and is tastefully furnished including new furniture package. Enjoy the Visitor's Channel on ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Welcome to Paki Maui! Located on the north end of Kaanapali Beach, this one bedroom condo offers a breathtaking ocean view. Sit on your lanai and enjoy the tranquility of the ocean views and sounds. Enjoy a tropical beverage while watching ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Paki Maui One Bedroom Garden View - Honokowai - this first floor garden view one bedroom/one bath is tastefully decorated and located in an ideal location with a peaceful garden view. Sit on your corner lanai and enjoy the beauty of the lush, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Honokowai
If you are looking for a lush tropical oasis, this condo is for you. Overlooking a gorgeous courtyard. The unit was recently remodeled with new tile floors, granite counters, and remodeled bathrooms. This is one of the nicest units at Paki Maui ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina