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, 50
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
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
Enjoy partial ocean views from your private covered lanai at this 2BR/2BA hideaway, located next to the beautiful Honokowai Beach Park. Recently updated, the inviting interior is highlighted by a sparkling full kitchen with new granite ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
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
