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 '%Lahaina Shores%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Lahaina Shores 525
This newly renovated, ocean front condo in Lahaina Shores Beach Resort offers outstanding sunset ocean views including a view of the island of Lanai in the distance. You can hear the sound of the ocean from your bed every ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Elegant Hotel Suite with a full kitchen and beautiful top to bottom REMODEL. Enjoy all the amenities of this first-class resort hotel, Lahaina’s warm sunshine, and a beautiful white sand beach. Top-quality finishes throughout include; custom...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
My 4th Floor Oceanfront Condo at Lahaina Shores has sweeping views of Lanai. Watch the whales breeching from the balcony, enjoy the warm tradewinds and walk to the historic whaling town of Lahaina which has renowned restaurants, nightlife, live...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Direct ocean front views from our 4th floor remodeled studio condo located at the beautiful beach front Resort in Lahaina Town: Lahaina Shores. Air conditioned and completely remodeled kitchen with granite counters. Tiled walk-in shower with ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Great deals for last-minute travel, and fill-in dates always available!
Our complete renovation is finished and ready for your visit! The entire space has been refreshed! New floors, cabinets, huge walk-in shower, and more... but comfort and ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
GREAT LAST-MINUTE BOOKING SPECIALS - CHECK OUR CALENDAR FOR YOUR PREFERRED DATES!
Spacious Oceanfront Studio just a couple blocks from the heart of Lahaina! Watch the whales from your lanai - fabulous 180 degree views and gorgeous sunsets!
No...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Enjoy the sound of the surf and rustle of the palm trees. Marvel at the amazing ocean views and colorful sunsets from this beautifully appointed oceanfront studio. Recently remodeled, this spacious studio has a fully equipped kitchen, large ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
SPECTACULAR OCEANFRONT LOCATION! Just steps from the ocean. See breaching whales and breathtaking sunsets from your private lanai (patio). Watch the cruise ships offshore and the surfers on the waves near the harbor. Fall asleep to the ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
GREAT LAST-MINUTE BOOKING SPECIALS - CHECK OUR CALENDAR FOR YOUR PREFERRED DATES!
This is the 6th floor condo that satisfies all your desires for your Maui Dream vacation!!
This beautifully redecorated studio is a perfect balance of style ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Please note we accept only VISA and MasterCard.
Recent January 2022 cancellation. Please view my calendar for available dates.
At Lahaina Shores Beach Resort you feel miles away from the crowds, yet you can walk into the historic town of ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
This upgaded one bedroom ocean front corner unit is located in sunny Lahaina Town on a beautiful sandy beach and has a panoramic ocean view, fiery sunsets, the sound of the surf and rustle of the palm trees. The spacious bedroom features a ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Lahaina
My 6th Floor Oceanfront Condo at Lahaina Shores has drop dead panoramic views of Lanai. Watch the whales breeching from the balcony, enjoy the warm tradewinds and walk to the historic whaling town of Lahaina which has renowned restaurants, ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Lahaina Shores is a beachfront condo on the edge of Downtown Lahaina. You will be steps from the pool, hot tub, and beach. You will be a quick walk to restaurants, bars, the banyan tree, the harbor, and more in the Lahaina Historic District. The...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
This oceanfront studio in Lahaina Shores is a great spot from which to explore the island of Maui!! After a day of activities, relax on the lanai and watch the beautiful sunsets, then out to dinner OR make your own meals in the fully equipped ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Lahaina
Our lovely Maui condo has newly installed countertops and paint, plush carpet, Cal-King bed, twin sofa sleeper, shower/tub, free high speed internet, DVD player, fully equipped kitchen including new refrigerator, electric range, coffee maker, ...
- 0 bedroom
- 1 bathroom
- Sleeps 3
HI> Lahaina
