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 '%Paki Maui%') AND sleeps>=1 order by rating desc LIMIT 0, 20
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
Hawaii> Lahaina
Summary:
Beautiful 1 bedroom Paki Maui condo has been completely renovated and remodeled. Beachfront location is amazing and adjacent to Honokawai Beach park. Fresh, new, and always clean unit.
The Space:
Unit is on the quiet side ...
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
Welcome to Paki Maui! Located on the north end of Kaanapali Beach, this recently updated (new floors, walk in shower, paint and ceiling fans) one bedroom condo offers a breathtaking ocean view. Sit on your lanai and enjoy the tranquility of ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Paki Maui 313 is a one-bedroom, one-bathroom oceanfront resort located at the north end of Ka'anapali, Lahaina. Lush gardens with Koi ponds and an abundance of fragrant indigenous flowers create a dreamy setting and an ideal tropical getaway ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Imagine sitting on your lanai and enjoying the serenity of the mature landscaped garden areas with a large water feature with colorful koi. Just a short distance to the pool, barbeque and cabana. There is a large grassy area with plenty of space...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
With its lanai merging into lush courtyard landscaping, this one-bedroom suite features full kitchen convenience for prepping meals and snacks. Tropical furnishings play out with a sofabed, dining table for four and bedroom with floral accents. ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
From sunrise to sunset, ogle offshore islands & evolving Pacific panoramas from the oceanfront lanai of this roomy suite. “Live big” touches include floor-to-ceiling sliders, full kitchen for meal prep, cool tile floors, WiFi, ceiling fans &...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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
Hawaii> Honokowai
Paki Maui #409 on the 4th floor: Upon entry, you’ll notice the open layout that leads you to the floor-to-ceiling sliding glass doors. The tile floor acts like a paved path to guide you to the private lanai that offers views of the Hawaiian ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Just say “ahhh!” With tasteful island décor, this gorgeous one-bedroom awes through its kitchen with stainless steel appliances, and living area with sofa, flat screen, ceiling fan and four-seat table–although you’ll likely prefer lanai...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Furnished 1 bdrm, one bath, Paki Maui condo offers paradise at an affordable price. Sit on the lanai, and enjoy the serenity of the mature landscaped tropical garden areas with a large water feature with a colorful koi pond.
Lounge by the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Make the most of your stay between November 6th, 2024 and January 7th, 2025, with our exclusive offer! Book 6 nights and enjoy the 7th night free, plus complimentary late check-out to savor every moment of your getaway. Don't miss this ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina