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 '%Lauloa%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Hawaii is now open for visitors with a negative PCR COVID test required. This is great news because visitors will feel safe while vacationing on Maui and also safe while flying there because all travelers will be required to show a negative ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
Enjoy breathtaking views of Maalaea Bay, the grand volcano Haleakala and the sparkling Kihei lights at night, all from the comfort of your private lanais off the master and living room. This 4th/top floor condo has been nicely remodeled and has ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
Enjoy breathtaking views of Maalaea Bay, the grand volcano Haleakala and the sparkling Kihei lights at night, all from the comfort of your private lanais off the master and living room. This third floor unit has been nicely remodeled and has a/c...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
Enjoy breathtaking views of Maalaea Bay, the grand volcano Haleakala and the sparkling Kihei lights at night, all from the comfort of your private lanais off the master and living room. This 3rd floor condo has a split system a/c in the living ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Maalaea
Enjoy breathtaking views of Maalaea Bay, the grand volcano Haleakala and the sparkling Kihei lights at night, all from the comfort of your private lanais off the master and living room. This 2nd floor condo with elevator for convenience has a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailuku
New on the rental market. Two bedroom-two bath condo on second floor of Lauloa. Walk to end of block and visit the Maui Ocean Center, several restaurants and shops, or take a cruise from the harbor with the Pacific Whale Foundation.
At the other...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
Lovely Lauloa #307 is an ocean front, beautifully remodeled condo in in a secluded, laid-back resort. With sleek tile flooring, high-end furniture, in-unit washer/dryer, 2 split ACs, TVs with complementary cable, high-speed internet and free ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
Enjoy breathtaking views of Maalaea Bay, the grand volcano Haleakala and the sparkling Kihei lights at night, all from the comfort of your private lanais off the master and living room. This 4th/top floor condo has been nicely remodeled and wall...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Maalaea
Enjoy breathtaking views of Maalaea Bay, the grand volcano Haleakala and the sparkling Kihei lights at night, all from the comfort of your private lanais off the master and living room. This 3rd floor condo with elevator for convenience has a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Maalaea